Hamilton, ON, CA
Position Title: Lead, Reporting
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.
- Develop, maintain, and continually enhance an integrated project reporting framework, ensuring consistency, accuracy, and alignment across cost, schedule, risk, resource, estimating, and operational reporting.
- Lead the design, development, deployment, and governance of Microsoft Power Platform solutions, including Power BI, Power Apps, Power Automate, Dataverse, Microsoft Fabric, and related technologies to support reporting, analytics, automation, and operational processes.
- Lead the integration of project systems including SAP, Primavera P6, InEight, Aconex, SharePoint, Microsoft Teams, and other enterprise platforms, ensuring data consistency and scalability across reporting and analytics solutions.
- Develop reporting requirements in collaboration with stakeholders, management, and operations teams, and deliver standardized reporting solutions that provide meaningful insights into project performance and support data-driven decision-making.
- Analyze and report on project performance, including cost, schedule, progress, forecasting, trends, risks, opportunities, and other key performance indicators, providing actionable recommendations to senior leadership and project executives.
- Establish reporting and data governance standards, including KPI definitions, reporting controls, data validation processes, reporting calendars, data ownership, quality assurance processes, and a single source of truth for project performance reporting.
- Provide leadership and subject matter expertise in reporting, analytics, data management, and Power Platform solutions, promoting best practices and supporting capability development across the project team.
- Identify and implement continuous improvement initiatives that enhance reporting processes, streamline workflows, improve operational efficiency, and maximize project performance.
- Minimum 6 years' experience in reporting, business intelligence, project controls, data analytics, or a related role, preferably within large-scale construction, infrastructure, transit, rail, or transportation projects.
- Post-secondary education in Business Administration, Engineering, Computer Science, Information Systems, Statistics, Economics, Data Analytics, or a related discipline.
- Advanced experience with Microsoft Power Platform, including Power BI, Power Apps, Power Automate, Dataverse, and Microsoft Fabric, with demonstrated experience developing enterprise reporting, analytics, and workflow automation solutions. Microsoft Power BI, Power Platform, Fabric, or related Microsoft certifications are considered an asset.
- Strong technical expertise in data modeling, semantic models, dimensional modeling, DAX, Power Query (M), SQL, and enterprise reporting architecture. Experience with Python, R, SAP Webi, or other analytics tools is considered an asset.
- Experience integrating data from multiple enterprise systems, including ERP, scheduling, financial, document control, and operational platforms, into scalable reporting and analytics solutions.
- Experience establishing reporting governance frameworks, KPI definitions, data quality standards, reporting controls, and performance management processes.
- Strong understanding of project controls principles, including cost management, scheduling, forecasting, progress measurement, change management, and Earned Value Management (EVM). Knowledge of industry best practices such as PMI and AACEI is considered an asset.
- Excellent communication, presentation, stakeholder management, and relationship-building skills, with the ability to effectively communicate insights and recommendations to all levels of the organization.
- Proven ability to manage multiple priorities in a fast-paced project environment while maintaining a high level of accuracy, attention to detail, and professionalism.
- Must be able to travel to other project sites/offices.
- Background checks required.
- Valid Driver’s License.
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.