Reporting Analyst

Come Build Your Career at Aecon!

Aecon delivers some of the most complex and impactful infrastructure projects — from transformative transportation networks to critical energy, industrial and nuclear programs. The projects we build connect communities and power future generations. With deep roots in North America and a strong footprint internationally, Aecon brings global expertise and proudly serves public and private sector clients through its Construction and Concessions segment.

Safety Always is not only our #1 core value – it is the standard that anchors our culture. We believe the most ambitious projects deserve the most committed people. At Aecon, you won’t just build your career — you’ll help build what matters to enable future generations to thrive.

At Aecon, you can count on:

• Safety Always. Our number one core value. The safety of our people, projects, partners, and stakeholders is our priority focus – today and always.
• Integrity. We lead by example, with humility and courage.
• Accountability. We’re passionate about delivering on our commitments.
• Inclusion. We provide opportunities where people feel valued, supported, and empowered to contribute fully.

We deliver infrastructure with purpose, and our people are at the heart of everything we do. Aecon employees are incredibly proud to build some of the most impactful infrastructure of this generation – we call it Aecon Proud.

At Aecon we:

• Ensure you and your family receive the services and benefits needed to support your mental, emotional, and physical well-being.
• Are intentional when it comes to investing in your development. We help you build your career and advance your skills through our Aecon University, tuition reimbursement, and Leadership Programs.
• Are committed to creating work environments focused on mutual respect, teamwork, collaboration, and new ideas, through meaningful initiatives, training, partnerships with Veteran groups, our Aecon Women in Trades and diversity programs, as well as our Employee Resource Groups (ERGs), to ensure we are building with top talent and harnessing our collective strengths within every aspect of our culture.
• Operate responsibly by managing risk, safety, and environmental considerations across all our projects and surrounding communities.

Our success is built on the passion, expertise, and dedication of our people. Together, we embrace strong execution, innovation, and continuous improvement — values that come to life through the unique talents and collaborative spirit of every team member. If you’re inspired to make a difference through future-building projects, join our best-in-class team.

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

• 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.
• Strong understanding of Project Management and Earned Value Management.
• 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.
• Advanced knowledge in project controls, Earned Value Management and Project metrics analysis.

At CanAtom, we are committed to creating an inclusive and accessible workplace. We encourage applications from all qualified individuals and will provide accommodations throughout the recruitment process upon request. 

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.

As part of our commitment to fair and transparent hiring practices, Aecon may use artificial intelligence (AI) tools to assist in screening and reviewing candidates. These tools are applied responsibly and in accordance with applicable privacy laws and Aecon’s AI Usage Policy. All final decisions are made by qualified Aecon team members.