Senior Project Controls Analytics & Power BI Lead

Kenaidan Contracting Ltd; Toronto; On-site; CAD 100,000 - 130,000; Full time

Benefits offered by this job

Top wages

Benefit coverage for you and your de-p

Employer RRSP contributions

Paid Time Off

Job summary

KMJV (Kenaidan Murphy Joint Venture) seeks a Project Controls Reporting Analyst in Toronto to develop and maintain reporting systems, dashboards, and automation connecting project controls with executive reporting.

The role requires 6+ years in project controls/data analysis, advanced Power BI, strong SQL/DAX, and experience on large infrastructure projects; salary ranges CAD 100,000–130,000, full-time on site with competitive benefits.

Qualifications

• Bachelor’s degree in Engineering, Data Analysis, Computer Science, or related field.
• 6+ years of experience in project controls / data analysis with at least 3+ years on large-scale construction projects.
• Advanced proficiency in Power BI is required.
• Strong knowledge in DAX solutions, Data warehousing, and SQL is desirable.
• Proficiency with project controls tools and software.
• Strong analytical and reporting skills.
• Excellent communication and stakeholder coordination abilities.
• Experience on major infrastructure, transit, transportation, heavy civil, or building projects is preferred.

Responsibilities

• Develop and maintain executive dashboards, reports, KPIs, and presentations to support project decision-making.
• Analyze project performance data to identify trends, risks, opportunities, and areas for improvement.
• Consolidate data from multiple sources into meaningful reports, dashboards, and visualizations.
• Deliver accurate and timely project controls reporting for project leadership and stakeholders.
• Design and maintain Power BI dashboards and reporting solutions using DAX and Power Query.
• Develop Power Apps and Power Automate solutions to streamline business processes, data collection, and reporting workflows.
• Automate reporting activities to improve efficiency, consistency, and data accuracy.
• Manage data integration, validation, governance, and reporting database integrity.
• Perform data analysis and reporting using advanced Excel and business intelligence tools.
• Troubleshoot reporting issues and maintain system documentation, user guides, and workflow maps.
• Collaborate with project teams and stakeholders to develop reporting solutions and support project objectives.
• Provide user training, technical support, and continuous improvement of reporting tools and processes.

Skills

Power BI

DAX

SQL

Data analysis

Excel

Education

Bachelor’s degree in Engineering, Data Analysis, Computer Science, or related field

Tools

Power Apps

Power Automate

Power Query

Job description

KMJV (Kenaidan Murphy Joint Venture) seeks a Project Controls Reporting Analyst in Toronto to develop and maintain reporting systems, dashboards, and automation connecting project controls with executive reporting.

The role requires 6+ years in project controls/data analysis, advanced Power BI, strong SQL/DAX, and experience on large infrastructure projects; salary ranges CAD 100,000–130,000, full-time on site with competitive benefits.