indeed
Project Controls Reporting Analyst - KENAIDAN/MURPHY JOINT VENTURE
Kenaidan Contracting Ltd
Toronto, CAN
Full Time
Senior
Onsite
1 weeks ago
Power BIDAXPower QueryPower AppsPower AutomateSQL
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
Power BIDAXPower Query
About the Role
Kenaidan Murphy Joint Venture seeks a Project Controls Reporting Analyst for the Bloor-Yonge Capacity Improvements Project in Toronto. You will develop executive dashboards, Power BI solutions, and automate reporting to support project decision-making.
Key Skills for This Role
Power BIDAXPower QueryPower AppsPower AutomateSQL
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
Requirements
- Bachelor’s degree in Engineering, Data Analysis, Computer Science, or related field
- 6+ years of experience in project controls / data analysis
- At least 3+ years on large scale construction projects
- Advanced proficiency in Power BI
- Strong knowledge in DAX solutions, Data warehousing, and SQL
- 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
Full Job Posting
Project Overview
- Kenaidan and Murphy joint venture for Bloor Yonge Capacity Improvements Project, a TTC initiative to expand and modernize Canada's busiest subway hub.
- KMJV is committed to transforming the station for faster, more reliable, and more comfortable travel.
Who We Are
- Kenaidan Contracting Ltd, founded in 1974, is a dynamic construction firm focused on community well being.
- Murphy is a leading international specialist engineering and construction company founded in 1951, operating in UK, Ireland, Canada, and America.
Position Summary
- The Project Controls Reporting Analyst will develop and maintain reporting systems, dashboards, and automated tools connecting project controls processes with executive level reporting.
How will you contribute to the team?
- 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.
Education and Experience
- 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.
Compensation
- Salary Range: Between CAD 100,000 to CAD 130,000 depending on experience.
- Top wages, benefit coverage for you and your dependents, employer RRSP contributions (no match required), Paid Time Off.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career