Enable job alerts via email!
Boost your interview chances
Create a job specific, tailored resume for higher success rate.
Join a dynamic team at an innovative consulting firm where you will play a vital role in enhancing business intelligence solutions using Power BI. This position offers the opportunity to support the sustainment of existing BI solutions, ensuring their availability and reliability while collaborating with various business lines to capture objectives and prioritize opportunities. You will engage in data extraction and transformation using SQL, develop proof-of-concept reports, and assist in end-user training. With flexible work-from-home options, this role is perfect for a self-starter who thrives in a fast-paced environment and is eager to make an impact.
RESPONSIBILITIES
Support 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 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 Business lead in developing system reporting solutions based on business needs.
Support 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.
DELIVERABLES & DUE DATES
Support EAM integration with Power BI solutions.
Configure Power BI to communicate valuable information to business lines.
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.
Flexible work from home options available.