Data 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.

What is the Opportunity?

Aecon is seeking a Data Analyst to join the Urban Transportations Solutions group to support dynamic, transit projects in Canada. We are proud to support projects that are committed to faster and more convenient travel, ultimately improving transportation experiences. This starts with bringing aboard the best possible team!

What You'll Do Here

• Establish and maintain KPIs and supporting metrics to be used across the project to track performance.
• Develop reporting requirements with functional leads and utilize a standardized approach to performance reporting across the sector.
• Communicate with internal stakeholders and projects to gather performance reporting data and share updates relevant to performance reporting and its processes.
• Support operational reporting systems and develop Power BI dashboards and data models to provide clear insights into project and business performance.
• Develop and maintain Microsoft Fabric data pipelines, lakehouses, and warehouses; monitor data refreshes and resolve pipeline failures.
• Support the full analytics solution lifecycle, from requirements and development through testing, deployment, and maintenance. Use versioning and review practices to manage changes across development, test, and production environments.
• Develop and maintain a comprehensive Performance Management Framework, including development of dashboards to monitor and analyze performance trends.
• Analyze, measure, and report on project goals and objectives, engineering and design performance, construction progress, schedule, financial performance, and other essential KPIs and metrics.
• Develop periodic and ad hoc performance reporting packages.
• Analyze data from sources such as SAP, Primavera P6, and InEight (Hard Dollar) Estimating; validate data quality, investigate discrepancies, and document data sources, transformations, and metric definitions.
• Drive an inclusive culture to promote equity, welcome different perspectives, and enable career progression by fostering a sense of belonging.

What You Bring to the Team

• Relevant experience in data analysis or business intelligence, with the ability to deliver and support analytics solutions, or an equivalent combination of education and experience. Construction or project-performance experience is an asset.
• Completion of a degree in Business Administration, Engineering, Science, Computer Science, Statistics, Economics, or Information Systems, or a related discipline, or a combination of education, training and experience deemed equivalent.
• Organizational skills to handle multiple tasks within a high-pressure work site environment.
• Excellent interpersonal and communication skills (written and oral).
• Hands-on Power BI experience, including Power Query, DAX, and data modeling.
• Practical knowledge of Microsoft Fabric and its lifecycle management across development, test, and production environments.
• Strong SQL and Excel skills, with practical scripting ability in Python or PowerShell.
• Working knowledge of Microsoft Azure, including data services, authentication, permissions, and cloud security fundamentals, is an asset.
• Knowledge of Earned Value Management (EVM) Industry best practices: PMI, AACEI, etc. will be an asset.
• Familiarity with versioning, source control, testing, code review, and controlled releases.
• Ability to work effectively with all levels of management and employees.
• Willingness for continuous learning and advancement of technical knowledge.
• Detail oriented.
• Must be able to travel to projects.
• Be a champion of inclusion and diversity.

Reason for vacancy: Backfill

The expected pay range for this role is $70,000 - $80,000 per year

Individual pay is determined based on several factors, including work location, education, experience, unique skills and job conditions. Other considerations may include certifications, specialist training, and the complexity or scope of the role

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.