Talent.com
Reporting Analyst
Reporting AnalystAECON • Pickering, Ontario, Canada
Reporting Analyst

Reporting Analyst

AECON • Pickering, Ontario, Canada
30+ days ago
Job type
  • Full-time
Job description

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 cant do it safely we dont do it at all.
  • Integrity. We lead by example with humility and courage.
  • Accountability. Were 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. Were 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 Youll 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 :

  • Bachelors degree in engineering Data Analytics Business Finance or a related discipline.
  • 35 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.

    Required Experience :

    IC

    Key Skills

    Cognos,Microsoft Access,SQL,Crystal Reports,Financial Report Writing,Power BI,Pivot tables,ssrs,Tableau,Regulatory Reporting,SAS,Data Analysis Skills

    Employment Type : Full Time

    Experience : years

    Vacancy : 1

    Create a job alert for this search

    Reporting Analyst • Pickering, Ontario, Canada

    Similar jobs
    Senior Analyst

    Senior Analyst

    Vaco by Highspring • Ajax, Ontario, Canada
    Temporary
    Our client is sourcing a Senior Analyst for a 6-month contract.Responsible for month-end, quarter-end, and annual close process in accordance with company requirements. Responsible for expense reimb...Show more
    Last updated: 21 days ago • Promoted
    Planning and Analysis Officer

    Planning and Analysis Officer

    Vaco by Highspring • Ajax, Ontario, Canada
    Temporary
    Our client is sourcing a Planning and Analysis Officer for a 6-month contract.Lead financial close activities, including monthly, quarterly, and annual performance reviews, with a focus on variance...Show more
    Last updated: 5 hours ago • Promoted • New!
    Business System Analyst-Payments

    Business System Analyst-Payments

    LTIMindtree • Oshawa, Ontario, Canada
    Full-time
    LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace.Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnan...Show more
    Last updated: 15 hours ago • Promoted • New!
    Senior Loans Analyst : Agribusiness Credit & Negotiations

    Senior Loans Analyst : Agribusiness Credit & Negotiations

    Farm Credit Canada • Ajax
    Full-time
    A leading financial institution is seeking a skilled credit analyst in Ajax, Ontario.Responsibilities include negotiating and preparing credit submissions for complex agribusiness proposals, assess...Show more
    Last updated: 8 days ago • Promoted
    Product Analyst

    Product Analyst

    LendCare • Pickering, ON, Canada
    Full-time
    Canada’s fastest-growing point-of-sale financing providers and a proud part of the.At goeasy, our people and culture are the heartbeat of everything we do, and we’re proud to be recogni...Show more
    Last updated: 17 hours ago • Promoted • New!
    Duckcreek Senior Business Analyst

    Duckcreek Senior Business Analyst

    Coforge • Oshawa, Ontario, Canada
    Full-time
    Duckcreek Senior Business Analyst.Policy, Duckcreek, Business Analysis, Agile.We at Coforge are hiring a Duckcreek Senior Business Analyst with the following skillset : . Bachelor’s or master’s degre...Show more
    Last updated: 11 hours ago • Promoted • New!
    Analyst, Portfolio, Enterprise Banking

    Analyst, Portfolio, Enterprise Banking

    Standard Bank of South Africa Limited • Pickering
    Full-time
    Business Segment : Business & Commercial Banking.To support the Banker, Enterprise (i.Portfolio & Multi-Channel) with the day-to-day administration, portfolio management, sales, operational and cred...Show more
    Last updated: 8 days ago • Promoted
    Insurance document reviewer

    Insurance document reviewer

    Great Value Hiring • Oshawa, Ontario, Canada
    Full-time
    Insurance document reviewer [$80-$105 / hr].Insurance experts to review specialized content related to health insurance, reimbursement structures, and lifelong condition support.Review and validate i...Show more
    Last updated: 15 hours ago • Promoted • New!
    Financial Reporting Consultant

    Financial Reporting Consultant

    Vaco by Highspring • Pickering, ON, CA
    Temporary
    Our client is sourcing a Financial Reporting Consultant for a 6-month contract.Manage certain accounting processes and ensure data integrity of accounting records. Consolidate accounting records for...Show more
    Last updated: 28 days ago • Promoted
    System Analyst - OGGN Inc.

    System Analyst - OGGN Inc.

    OGGN Inc. • oshawa, on, ca
    Full-time
    Please specify your security clearance level in resume, resumes without security clearance level will not be shortlisted for review for this client • • •. Location : Remote (Physically present in Canada...Show more
    Last updated: 16 hours ago • Promoted • New!
    Senior Financial Analysts ( Projects )

    Senior Financial Analysts ( Projects )

    Vaco by Highspring • Oshawa, ON, CA
    Full-time
    Lead and support finance-related projects, including system testing and data validation, to ensure accuracy and functionality. Collaborate with cross-functional stakeholders to gather, document, and...Show more
    Last updated: 9 days ago • Promoted
    Strategy Analyst

    Strategy Analyst

    Vaco by Highspring • Whitby, ON, CA
    Temporary
    Our client is sourcing a Strategy Analyst for a 6-month contract.This role supports senior leadership within the insurance sector by delivering market insights, competitive analysis, and strategic ...Show more
    Last updated: 20 days ago • Promoted
    Senior Statistical Analyst II

    Senior Statistical Analyst II

    Tigermed • Oshawa, Ontario, Canada
    Full-time
    Communicate with clients as the.Archive all programming deliverables and documentation per SOPs.Mentor team members and support their technical and professional development.CDISC standards, and com...Show more
    Last updated: 11 hours ago • Promoted • New!
    Senior Statistical Analyst I

    Senior Statistical Analyst I

    Tigermed • Oshawa, Ontario, Canada
    Full-time
    Communicate with clients as the.Archive all programming deliverables and documentation per SOPs.Mentor team members and support their technical and professional development.CDISC standards, and com...Show more
    Last updated: 15 hours ago • Promoted • New!
    Accounting Analyst

    Accounting Analyst

    Vaco by Highspring • Uxbridge, ON, CA
    Temporary
    Accounting Analyst – 2 Month Contract.The Accounting Analyst supports accurate financial reporting, analysis, and compliance by preparing journal entries, reconciling accounts, and analyzing financ...Show more
    Last updated: 21 days ago • Promoted
    Senior Loans Analyst

    Senior Loans Analyst

    Farm Credit Canada • Ajax
    Full-time +1
    Closing Date (MM / DD / YYYY) : 01 / 04 / 2026.Worker Type : Term (Fixed Term).Salary Range (plus eligible to receive a performance based incentive, applicable to position) : $92,310 - $124,890 Credit analys...Show more
    Last updated: 8 days ago • Promoted
    Business Analyst III

    Business Analyst III

    Empire Life • Oshawa, Ontario, Canada
    Full-time +2
    Empire Life is looking to hire a Business Analyst III to join our Group Initiatives team! We are actively seeking candidates to fill a current, open position. The total target compensation (TTC) ran...Show more
    Last updated: 11 hours ago • Promoted • New!
    Hybrid Oracle Cloud ERP Architect : Integrations & Reporting

    Hybrid Oracle Cloud ERP Architect : Integrations & Reporting

    Cognizant • Ajax
    Full-time
    A leading technology consulting firm is seeking an Oracle Cloud ERP Technology Architect to design and implement innovative solutions with Oracle ERP technology. The ideal candidate will have 5+ yea...Show more
    Last updated: 29 days ago • Promoted