Power BI Business Intelligence Professional

What you will be doing :

Extract project performance data from multiple source systems, including SAP Business Warehouse, SAS, MS SQL Server, Microsoft Dynamics, and other proprietary data source systems. This includes key project attributes around costs, milestones, change items, deficiencies, labour resources, risks, change items, and related information.

Perform data cleaning, transformation, and analysis using MS Excel, MS Power Query, Power BI, VBA, SQL, SAS, and translate these into visualized and actionable information.

Publish several daily, monthly, and quarterly summary reports of ongoing results and prepare other ad-hoc analyses in a timely manner.

Develop new standard reports in Excel and Power BI Dashboards such that they can be prepared efficiently in a repeatable manner.

Communicate summary results of analysis findings and associated reports to project teams, senior leaders, and other audiences as needed.

Support and / or execute the facilitation of Customer Services processes (including forecast deep-dive reviews and project releases).

Apply analytical skills and judgment to analyze and recommend solutions to improve processes and close Portfolio reporting gaps to meet the needs of all project participants.

Develop documentation of operational processes and analysis managed by the team.

Work with partners in Technology Business Unit to ensure backend system architecture for reports and dashboards is delivered and sustained, allowing for on-demand accessibility of data.

Develop relationships with other subject matter experts within and outside of BC Hydro who are involved in performance reporting and advanced data analytics.

Support senior team members / Team Leads as required.

Resolve moderately complex problems independently under areas of authority, occasionally seeking input from others on more complex issues.

What you must have :

Minimum 5 years of relevant work experience, with demonstrated capabilities in reporting and data analytics using Power BI, MS Excel, VBA, and MS Power Query.

Post-secondary degree or diploma in a relevant field such as Computer Science, Engineering, Science, Mathematics, or Economics.

Strong communication and presentation skills, with the ability to summarize data to visually tell a story using PowerPoint and Power BI Dashboards.

Solid experience using advanced visualization tools like Power BI, writing DAX and M Code, and using data transformation in Power BI.

Strong coordination and collaboration skills, with the ability to work with various stakeholders among cross-functional teams to facilitate sessions and processes.

Understanding of basic statistics and relational databases.

A Professional designation in Engineering, Business, or related.

Understanding of project management principles and lifecycle.

Salary / Rate Range : $48.50-$60.00 per hour

Term : ?????? 12-month contract; most likely to extend

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.