Critical Key requirements
- Overall 7+ years' experience
- A minimum of 2-3 years' experience in using Microsoft's Power BI analytics software.
- Preferable 1-2 years working experience with Railroad/Transit industry
- Preferably 2 years hands-on experience with enterprise data analysis.
- Strong analytical and problem-solving skills
QUALIFICATIONS EXPERIENCE & EDUCATION
- Minimum 2 years HxGN EAM (or other EAM/enterprise data management software) experience.
- Minimum years of IT related experience
- Minimum of 2 years of experience developing and implementing Power BI solutions, including modelling, design, development and testing of data visualization or paginated report solutions
- Proficiency in Data Analysis (DAX), M, ETL (Power Query), SQL (or data extraction and integration tools) and performance optimization
- Strong ability to work on multiple initiatives simultaneously and work within tight deadlines
- Experience working in an Agile project delivery model is an asset
- Understanding of complex relational database organization, design, and functionality.
- Ability to communicate clearly in conversation and in presentations to both technical and non-technical staff and to provide updates to all levels of management and stakeholders
- Ability to effectively prioritize and execute in a high-pressure environment
- Ability to independently set priorities and meet deadlines in a fast-paced environment, a self-starter
- Excellent inter-personal skills including the ability to work with individuals at all levels of the organization
RESPONSIBILITIES
- Support Client's Power BI and applications sustainment efforts, with a focus on the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities.
- This position will play a primary role in the sustainment of the existing Power BI solutions under the management of the Client E&E Department, with a focus on availability, reliability, contract management and maintenance as needs arise.
- Under the direction of the Report Development Lead, extract transform and load data, using SQL.
- Support the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities
- Create mock-up reports for proof-of-concept reviews.
- Support and develop activities related to end-to-end data lifecycle management, including the review of data loads for accuracy and completeness.
- Support client Business lead in developing system reporting solutions based on business needs.
- Support client's Business lead in creating, validating, executing and documenting test cases
- Assist in the development of end-user training and reference materials
- Perform or assist in end-user training
- Assist in implementation go-live and post-go-live activities
- Support requests from users to research system problems or errors, and to assist in their resolution
- Support EAM integration with Power BI solutions.
- Configure Power BI to communicate valuable information to business lines