Power BI Developer

Location: North York, ON – Hybrid (2–3 days onsite per week)
Contract Duration: 1 year with potential extension (up to an additional 2 years) or conversion to permanent
Working Hours: Monday–Friday, 35 hours per week (8-hour workday with 1-hour unpaid lunch)

Job Title: Power BI Developer

Overview

The Engineering, Construction & Expansion (ECE) Project Management Office (PMO) is seeking an experienced Power BI Developer to design, develop, and maintain interactive dashboards and reporting solutions that support strategic and operational decision-making.

In this role, you will collaborate with Project Controls, Project Management, Risk Management, and business analysts to transform complex data into meaningful insights. The successful candidate will ensure reporting accuracy, maintain strong data governance practices, and help deliver high-quality analytics for a large capital project portfolio.

This position reports to the Director, Project Controls & Risk.

Key Responsibilities

• Review and assess existing reports and data sources to identify opportunities for improvement.
• Design, develop, and maintain Power BI dashboards and reports aligned with business requirements.
• Gather and document reporting requirements from business stakeholders.
• Collaborate with data engineers and analysts to acquire, cleanse, transform, and model data for reporting.
• Develop and optimize Data Analysis Expressions (DAX) calculations and measures.
• Ensure adherence to data governance, security, and compliance best practices.
• Troubleshoot and resolve issues related to Power BI reports, datasets, and data models.
• Provide training, documentation, and user support for reporting tools.
• Monitor report performance and implement optimization strategies.
• Stay current with Power BI updates, features, and industry best practices.

Deliverables

• Develop interactive Power BI dashboards and reports for the ECE capital project portfolio consisting of 600+ projects, with drill-down capabilities at the enterprise, program, and project levels.
• Create dashboards and reporting solutions supporting additional PMO functions such as:
• Project Risk Management
• Estimating
• Quality Management
• Document Control

Required Qualifications

Technical Skills

• 3–5 years of hands-on experience developing Power BI dashboards and reports, ideally for large project portfolios or enterprise environments.
• Strong proficiency in Power BI, DAX, Power Query, and data modeling.
• Experience integrating data from multiple sources including databases, APIs, files, and cloud platforms.
• Understanding of data governance, security practices, and Row-Level Security (RLS).
• Ability to translate business requirements into technical reporting solutions.
• Experience troubleshooting and optimizing Power BI reports and datasets.
• Experience working in cross-functional or agile team environments.

Analytical Skills

• Strong problem-solving abilities for resolving reporting and automation challenges.
• Ability to analyze business processes and identify opportunities for data-driven improvements and automation.
• Strong data interpretation skills to support strategic decision-making.

Soft Skills

• Excellent verbal and written communication skills.
• Strong stakeholder engagement and collaboration abilities.
• Ability to work effectively in team-based environments.
• Strong organizational and time-management skills with the ability to manage multiple priorities.

Education

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Knowledge of SQL and data warehousing concepts.
• Experience supporting enterprise-level Business Intelligence solutions is preferred.

Pay: $60.00-$80.00 per hour

Expected hours: 35.0 per week

Education:

• Bachelor's Degree (preferred)

Experience:

• Power BI: 5 years (preferred)
• DAX & Power Query: 3 years (preferred)

Location:

• North York, ON M2N 6L9 (preferred)

Work Location: Hybrid remote in North York, ON M2N 6L9