IDD Data & Analytics Specialist

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 Civil is a recognized leader in the market, backed by strong self-perform capabilities and deep local expertise. We play a key role in building and enhancing infrastructure across Canada, the U.S., and an expanding international footprint improving everyday life through the roads, bridges, tunnels, and transit systems that connect communities. With more than a century of experience and a full suite of integrated services, Aecon is a trusted partner for delivering complex civil projects, including tunnels, transit expansions, airports, ports, highways, and large-scale site development.

Reporting to IDD Data & Analytics Lead, the IDD Analytics Specialist will be responsible for collecting, analyzing, transforming, and presenting data from various business systems to support operational, project, and executive decision-making. The role develops reports, dashboards, and performance metrics, ensuring data accuracy, consistency, and timely delivery of information to stakeholders.

This position works closely with project teams, business leaders, functional departments, and technology teams to provide actionable insights, automate reporting processes, and improve organizational performance through data-driven decision-making.

What You'll Do Here

• Design, develop, and maintain reports, scorecards, dashboards, and KPI tracking tools.
• Create executive-level reporting packages and management dashboards.
• Develop recurring operational, project, and corporate performance reports.
• Automate reporting processes to improve efficiency and data accuracy.
• Analyze large datasets to identify trends, risks, opportunities, and performance gaps.
• Perform ad hoc analysis to support business and project initiatives.
• Interpret complex data and provide meaningful recommendations to stakeholders.
• Monitor key business metrics and produce variance analyses and forecasting reports.
• Extract, transform, and load data from multiple platforms and systems.
• Consolidate information from sources such as SharePoint, Power BI, ERP systems, ACC, Aconex, and other enterprise applications.
• Ensure data quality, consistency, integrity, and governance standards are maintained.
• Develop and maintain data models and reporting datasets.
• Collaborate with project teams and business leaders to gather reporting requirements.
• Translate business needs into reporting and analytical solutions.
• Present findings and recommendations to management and executive leadership.
• Provide training and support to report users and stakeholders.
• Identify opportunities to enhance reporting processes and business intelligence capabilities.
• Implement automation and analytics solutions to improve efficiency.
• Support the adoption of digital reporting and data visualization tools.
• Maintain documentation for reporting methodologies, processes, and data sources.

What You Bring To The Team

• Bachelor's degree in Business Analytics, Information Management, Computer Science, Statistics, Engineering, Finance, or a related field.
• Experience with Power Automate, Python, DAX, Power BI datasets, and data extraction from platforms such as ACC, Aconex, ESRI, and SharePoint is considered an asset.
• 3+ years of experience in reporting, analytics, business intelligence, project controls, or data analysis.
• Experience working with large datasets and enterprise systems.
• Experience developing executive dashboards and performance reports.
• Advanced proficiency in Microsoft Excel, Power BI, SQL, Power Query, and data visualization tools to develop dashboards, reports, and data-driven insights.
• Experience with data modeling, ETL processes, database querying, and enterprise information systems, including SharePoint and similar platforms.
• Ability to analyze, extract, and transform data from multiple sources to support business reporting, decision-making, and process improvement initiatives.
• Strong analytical, problem-solving, and data storytelling skills, with the ability to present complex information clearly to stakeholders.
• Excellent communication, stakeholder management, collaboration, and time management skills, with a focus on continuous improvement and business outcomes.

Reason for Vacancy: New

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