Project Controls Reporting Analyst

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

Project Controls Reporting Analyst (Toronto, ON)

Kenaidan and Murphy are excited to announce a joint venture dedicated to bringing global innovation to infrastructure projects across Ontario.
Project Overview: The Bloor-Yonge CapacityImprovements Project is a significant undertaking by the Toronto Transit Commission (TTC) to expand and modernize Bloor-Yonge station – Canada’s busiest subway hub. This initiative is focused on meeting both current and future ridership needs by improving the station’s efficiency, capacity, and accessibility.
Who we are: Founded in 1974, Kenaidan continues to be a fixture as a dynamic construction firm dedicated to creating structures that will contribute to the well-being of our community and enhance the fabric of our communities for years to come. Our confidence in our expertise and passion for our work has allowed us to deliver an array of projects with unmatched precision, quality, and efficiency. From general contracting to construction management, we deploy a collaborative approach, embedding innovation and sustainability into every project. #TeamKenaidan #MoveToMurphy.
We are a proud Equal Opportunity Employer, committed to providing employees’work-life balancewith acompetitive compensationpackage including:

• Top wages
• Benefit coverage for you and your dependents
• Employer RRSP contributions (no match required)
• Paid Time Off

We currently have an opening in Toronto, ON for a:
Project Controls Reporting Analyst
The Project Controls Reporting Analyst will be responsible for developing and maintaining reporting systems, dashboards, and automated tools that connect project controls processes with executive-level reporting.

• 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.

• Bachelor’s degree in Engineering, Data Analysis, Computer Science, or related field.
• 6+ years of experience in project controls / data analysis with preferred 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.
• Strong organizational, communication, and problem-solving skills.

Salary Range: Between $100,000 to $130,000 depending on experience.

We are an inclusive and equal opportunity employer committed to providing diversity and accommodation for applicants upon request in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). The KMJV does not accept resumes from recruitment agencies, employment services or head hunters that are not in a formal contractual arrangement with us. Any resume or other information received from an agency not approved by us will be considered unsolicited and will not be considered. We will not pay any referral, placement or other fee for the supply of such unsolicited resumes or information.

We thank all candidates who apply, however, only those selected for an interview will be contacted.

This is a full time position