Power BI Business Intelligence Professional

Job Title: Power BI Business Intelligence Professional
Job ID: 85908
Location: Burnaby, British Columbia


Overview:
You are naturally curious and have a passion for data analytics. You are a master at cleaning, analyzing, and communicating data using Power BI dashboards and other emerging analytics tools. You can summarize complex analysis and data sets into meaningful insights for verbal and visual communication to senior leaders and other stakeholders. You are detail-oriented but can also speak about the big picture. You are proactive and willing to take on unplanned challenges while adapting to changing priorities. You possess an open mind with a desire to learn and grasp new and complex problems quickly, particularly where no precedent exists. You understand how to achieve success as a key contributor to a larger team.

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.


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com