Reporting Analyst

Come Build Your Career at Aecon
As a Canadian leader in infrastructure development, Aecon is safely and sustainably building what matters for future generations to thrive We lead some of the most impactful infrastructure projects of our generation, at the forefront of transformational change in transportation and energy, and partnering every day to build, connect, power, and strengthen our communities.

At Aecon, You Can Count On

• Safety Always. Our number one core value. If we can't do it safely, we don't do it at all.
• Integrity. We lead by example, with humility and courage.
• Accountability. We're passionate about delivering on our commitments.
• Inclusion. We provide equitable opportunities for everyone.

We lead the infrastructure industry with purpose, and our people are at the heart of everything we do. So, we invest in our people, just like they invest in us

At Aecon We

• Ensure you and your family receive the services needed to support your mental, emotional, and physical well-being.
• Believe in helping you build your career through our Aecon University and Leadership Programs.
• Are committed to supporting and investing in inclusive work environments, through initiatives like Equity, Diversity & Inclusion training, our Aecon Women in Trades and Aecon Diversity in Trades programs, and our Employee Resource Groups (ERGs) to ensure we are building inclusion into every aspect of our culture at Aecon.
• Are a leader in sustainable construction. With a strong commitment to operating responsibly by minimizing our impact on the environment and surrounding communities.

Our business success relies on strong execution and continuous improvement – driven by the diversity, expertise and teamwork of our people. We're always searching the globe for innovative, collaborative minds to join our best-in-class Aecon community

What is the Opportunity?
Aecon Nuclear provides a full spectrum of Engineering, Procurement and Construction (EPC) services, in addition to maintenance and manufacturing services tailored to meet the demanding requirements of the nuclear power industry. Aecon Nuclear' s portfolio of building, refurbishing, maintaining, and decommissioning nuclear power facilities reflects a record of project success that ranges from small but essential maintenance contracts, to major construction endeavors. Aecon supports clients with expert project management to the most exacting standards.

Working with our joint venture partner Atkins Realis, Aecon Nuclear has been awarded the definition phase contract with Ontario Power Generation (OPG) to assist in planning the Pickering Retube, Feeder and Boiler replacement (RFBR) project. This project involves the refurbishment of four reactors and replacement of the forty eight steam generators at the Pickering Nuclear Generating Station.

The Reporting Analyst plays a vital role in the Project Controls team, supporting project performance monitoring and decision-making through accurate, timely, and insightful data reporting and analytics. The position involves integrating data from multiple systems, automating reporting processes, and developing interactive dashboards to track project progress, costs, and performance metrics across various functions such as cost control, scheduling, risk management, and earned value management (EVM).

What You'll Do Here
Data Management and Integration:

• Collect, clean, validate, and maintain large datasets from multiple project systems such as Primavera P6, SAP, EcoSys, and other project databases.
• Utilize Power Query and advanced Excel functions to transform and model raw data into structured, analyzable formats.
• Ensure data integrity, consistency, and traceability across project cost, schedule, and performance datasets.
• Collaborate with IT and system administrators to optimize data flow and automate data refresh pipelines.

Reporting And Dashboard Development

• Design, develop, and maintain Power BI dashboards and interactive visual reports to support project controls and executive decision-making.
• Implement dynamic visualizations and KPIs for cost performance, schedule adherence, earned value (CPI/SPI), risk trends, and forecast variances.
• Automate repetitive reporting tasks using Power Query, Power Automate, and Excel VBA/macros.
• Standardize report templates and ensure alignment with project governance and reporting requirements.

Performance Monitoring And Analysis

• Analyze project trends, variances, and performance indicators to identify potential risks or deviations.
• Support monthly reporting cycles (e.g., Project Performance Reviews, Earned Value Reporting, Cost and Schedule Reconciliations).
• Provide insights into forecast accuracy, cost/schedule performance, resource utilization, and productivity indices.
• Collaborate with cost engineers, planners, and project managers to interpret data and recommend corrective actions.

Stakeholder Communication And Support

• Prepare executive-level presentations and summary dashboards for internal and external stakeholders (e.g., client, regulatory bodies, and senior management).
• Respond to ad hoc data and reporting requests from the Project Controls Manager/Director, Project Director, and other functional leads.
• Ensure that all reports comply with project reporting standards, corporate data governance, and confidentiality requirements.
• Train and support team members in using reporting tools (Power BI, Excel, Power Query).

Continuous Improvement And Automation

• Identify opportunities to improve efficiency, accuracy, and visualization quality in project reporting processes.
• Develop and maintain automated data pipelines for cost, schedule, and performance reporting.
• Stay current with emerging BI tools and data analytics trends to enhance project controls reporting capabilities.
• Participate in system enhancement projects and integration of new technologies.

What You Bring To The Team

• Bachelor's degree in engineering, Data Analytics, Business, Finance, or a related discipline.
• 3–5 years of experience in data analytics or reporting within large infrastructure, energy, or nuclear projects.
• Familiarity with project controls principles (cost, schedule, and performance reporting).
• Strong attention to detail, problem-solving skills, and ability to work in a high-stakes, schedule-driven environment.
• Advanced Microsoft Excel: Pivot Tables, Power Query, Power Pivot, Macros/VBA, advanced formulas, data modeling.
• Power BI: Data modeling (DAX), report and dashboard creation, KPI visualization, data refresh automation, performance tuning.
• Power Query: ETL (Extract, Transform, Load) processes, complex data transformations, custom function creation.
• Database Skills: SQL queries, data connection setup, and cross-platform data integration.
• Project Systems Knowledge: Understanding of P6, SAP, EcoSys, or similar project management/cost systems.
• Analytical Thinking: Ability to interpret complex datasets and communicate insights clearly.
• Advance knowledge in project controls, Earn Value management and Project metrics analysis.

Aecon fosters diversity, inclusion and belonging within and across our organization. We welcome all to apply including, women, visible minorities, Indigenous peoples, persons with disabilities, and persons of any sexual orientation or gender identity.

We are committed to adhering to the objectives and requirements outlined in the Accessible Canada Act (ACA), and to meeting the accessibility needs of persons with disabilities in a timely manner. Through the implementation of the requirements of the ACA and its applicable regulations, appropriate accommodations will be provided upon request throughout the interview and hiring process.