IDD Data & Analytics Specialist

Aecon • Toronto, ON

1d • CA$70,000 - CA$100,000

About The Position

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.

Requirements

• Bachelor's degree in Business Analytics, Information Management, Computer Science, Statistics, Engineering, Finance, or a related field.
• 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.

Nice To Haves

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

Responsibilities

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level