Reporting Analyst

Join to apply for the Reporting Analyst role at Aecon Group Inc. 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. 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. 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. 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. Seniority level Mid‑Senior level Employment type Full‑time Job function Research, Analyst, and Information Technology Industries Construction Referrals increase your chances of interviewing at Aecon Group Inc. by 2x. Get notified about new Reporting Analyst jobs in Pickering, Ontario, Canada. #J-18808-Ljbffr