Business Analyst

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.