Business Analyst

Aecon; Hamilton; On-site; CAD 65,000 - 75,000; Full time

Job summary

Aecon is hiring a Business Analyst in Hamilton, ON to develop and maintain reporting solutions that drive project performance insights. You will transform data from multiple project systems into actionable dashboards and metrics, enabling safer, faster, smarter decisions across large infrastructure programs.

Bring 1–3 years of BI experience, Power BI proficiency, and strong SQL/data modeling skills. Collaboration with project teams and stakeholders is essential in a fast-paced, governance-driven

Qualifications

• Experience developing reports and dashboards using BI tools (Power BI, Excel).
• Strong data modeling, SQL, and data transformation knowledge.
• Ability to translate stakeholder needs into analytics solutions.
• Excellent communication and collaboration with technical and non-technical teams.
• Experience in construction/infrastructure project environments is a plus.

Responsibilities

• Gather reporting requirements with project teams and translate into analytics solutions.
• Develop and maintain reports, dashboards, and visuals for performance metrics (cost, schedule, resource).
• Analyze project data to identify trends, risks, and KPIs for decision-making.
• Validate data from project systems to ensure accuracy and reliability of reporting.
• Identify opportunities to automate reporting and improve data access using Microsoft technologies.

Skills

Reporting

Data analytics

Power BI

SQL

Data modeling

Stakeholder management

Excel

Project controls

Python

Education

Engineering/CS/IS degree

Tools

SAP

Primavera P6

InEight

Aconex

Power Platform

Microsoft Fabric

Job description

Location: Hamilton, ON, CA

Operating Sector: Finance

Position Title: Business 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?

Safer. Faster. Smarter.

This is how Aecon Utilities is committed to delivering projects. Aecon Utilities is a leading North American utility infrastructure provider with a strong track record delivering safe, reliable and innovative solutions across electrical, telecommunications, pipeline distribution and renewable energy markets. With operations across North America, Aecon Utilities supports critical utility infrastructure that powers and keeps communities connected. Guided by our core value of Safety Always, we partner with clients to build the infrastructure that powers the future.

Hamilton LRT Civil & Utilities Alliance has been selected by Metrolinx as the development partner for the Hamilton LRT Civil & Utilities Works project in Ontario. Under the alliance, Aecon is the construction partner responsible for project delivery. The Hamilton LRT will bring 14 kilometres of modern, reliable and frequent LRT service across Hamilton’s downtown core.

The Hamilton LRT isn’t just a transit project, it’s reshaping how a city connects, grows, and moves. Join us in being part of a dynamic team building critical infrastructure that will leave a lasting legacy for generations to come!

What You'll Do Here:

• Partner with project teams and stakeholders to gather reporting requirements and translate business needs into practical reporting and analytics solutions.
• Develop and maintain reports, dashboards, and visualizations that provide meaningful insights into project performance, including cost, schedule, resource, and operational metrics.
• Analyze project data to identify trends, risks, opportunities, variances, and key performance indicators, and communicate findings to support informed decision-making.
• Manage and validate data from multiple project systems and business applications, ensuring reporting information is accurate, consistent, and reliable.
• Identify opportunities to improve reporting processes, automate manual activities, and enhance access to project information through Microsoft technologies and data-driven solutions.

What You Bring to the Team:

• 1-3 years of experience in reporting, data analytics, business intelligence, project controls, or a related role.
• Post-secondary education in Engineering, Computer Science, Information Systems, Statistics, Data Analytics, Business Analytics, or a related discipline.
• Experience developing reports, dashboards, and visualizations using Microsoft Power BI, Excel, or similar reporting tools.
• Working knowledge of data modeling, Power Query (M), DAX, SQL, and data transformation techniques.
• Experience gathering business requirements and translating stakeholder needs into practical reporting and analytics solutions.
• Strong analytical and problem-solving skills with the ability to interpret data and provide actionable insights.
• Strong communication and interpersonal skills with the ability to work effectively with technical and non-technical stakeholders.
• Ability to manage multiple priorities and work independently in a fast-paced project environment.
• Strong attention to detail and commitment to data accuracy and quality.
• Experience within construction, infrastructure, transit, rail, engineering, or other project-based environments.
• Experience working with project systems such as SAP, Primavera P6, InEight, Aconex, or similar enterprise applications.
• Experience with Microsoft Power Platform, including Power Apps and Power Automate.
• Exposure to Microsoft Fabric or other modern analytics platforms.
• Knowledge of project controls concepts such as cost management, scheduling, forecasting, progress measurement and change management.
• Experience with Python or other programming languages used for analytics and automation.
• Occasional travel to project sites and office locations may be required.

Reason for Vacancy: New

The expected pay range for this role is $65,000 - $75,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, specialized 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.