Sql analyst Jobs in Ajax, ON

Come Build Your Career at Aecon!

As a Canadian leader in infrastructure development, Aecon is and building what matters for future generations to thrive! We lead some of the most impactful infrastructure of our generation, at the forefront of transformational change in transportation and energy, and partnering every day to build, connect, power, and strengthen our communities.

At Aecon, you can count on:

• Safety Always. Our number one core value. If we can’t do it safely, we don’t do it at all.
• Integrity. We lead by example, with humility and courage.
• Accountability. We’re passionate about delivering on our commitments.
• Inclusion. We provide equitable opportunities for everyone.

We lead the infrastructure industry with purpose, and our are at the heart of everything we do. So, we invest in our people, just like they invest in us!

At Aecon we:

• Ensure you and your family receive the services needed to support your mental, emotional, and physical well-being.
• Believe in helping you build your career through our Aecon University and Leadership Programs.
• Are committed to supporting and investing in inclusive work environments, through initiatives like Equity, Diversity & Inclusion training, our Aecon Women in Trades and Aecon Diversity in Trades programs, and our Employee Resource Groups (ERGs) to ensure we are building inclusion into every aspect of our culture at Aecon.
• Are a leader in sustainable construction. With a strong commitment to operating responsibly by minimizing our impact on the environment and surrounding communities.

Our business success relies on strong execution and continuous improvement – driven by the diversity, expertise and teamwork of our people. We’re always searching the globe for innovative, collaborative minds to join our best-in-class Aecon community!

As part of an alliance agreement, Aecon has been awarded a contract in an Aecon-led partnership with Kiewit Nuclear Canada by Ontario Power Generation (OPG) for the execution phase on the Darlington New Nuclear Project (DNNP) in Clarington, Ontario. In 2025, Aecon began the Construction of the Unit 1 Small Modular Reactor at the Darlington site.

What Is the Opportunity?

The Data & Systems Specialist plays a critical role in supporting Training, Construction Operations, and Project Leadership by consolidating workforce training, operational, and project data into meaningful insights. This role improves reporting visibility, enables risk-informed decision-making, and implements automated workflows that streamline compliance, reporting, and workforce readiness across large-scale nuclear projects.

The position focuses on how information is captured, analyzed, and presented to support planning, training, and execution phases of project delivery.

Working closely with Training, Operations, and Leadership teams, the Data & Systems Specialist enhances reporting accuracy, reduces manual processes, supports continuous improvement initiatives, and strengthens performance visibility as the project continues to scale.

This role combines data analytics, reporting development, systems coordination, workflow automation, and stakeholder support to enable effective project delivery and workforce performance management. The position reports directly to the Manager, Data & Systems Analyst.

As a Data & Systems Specialist, you will provide ongoing data analytics, systems support, and digital solutions across nuclear projects during planning, training, and execution windows. You will support workforce training data, electronic work packages, and operational reporting while contributing to risk analysis in the areas of safety, quality, production, and cost.

You will act as a key enabler of digital transformation by automating workflows, improving data integrity, and supporting leadership with timely, accurate insights that inform operational decisions.

Key Responsibilities

Data Analytics & Reporting

• Collect, manage, analyze, and interpret training, workforce, and operational data to identify trends and support project decision-making
• Develop dashboards, reports, and visualizations to improve visibility into workforce training status and readiness compliance, safety, quality, production, and cost
• Support Layered Leadership Model (LLM) reporting and other leadership performance reporting requirements
• Develop dashboards and reporting tools that enhance leadership visibility into field engagement and performance trends
• Assist operations leadership in effectively presenting field performance insights
• Develop series modeling and analytical frameworks using structured data gathering techniques
• Maintain data quality, integrity, and reporting standards across training and operational platforms

Workflow Automation & Process Improvement

• Design and implement automated workflows to streamline reporting, compliance tracking, and data collection
• Reduce manual processes through digital solutions and system optimization
• Identify and support opportunities for continuous improvement and digital transformation across projects

Systems & Software Coordination

• Support and coordinate business intelligence platforms and supporting systems (e.g., Power BI, Power Apps, Power Automate, Excel)
• Design, develop, and maintain databases that support training, operations, and project reporting needs
• Act as a liaison with software vendors for system development, troubleshooting, maintenance, and upgrades
• Gain subject matter expertise in one or more commonly used software platforms within the nuclear division

Stakeholder & Training Support

• Consolidate training and compliance data from multiple systems into unified reporting platform
• Provide ongoing analytical and systems support to project teams, operations, and internal clients
• Develop procedures, processes, and documentation as required
• Develop and deliver training to the nuclear division on new software, tools, and technologies
• Collaborate closely with Training, Construction Operations, and Project Leadership teams

Planning & Execution Support

• Apply statistical and process analysis techniques to support planning, training, and execution phases
• Independently plan, schedule, and manage workload while aligning with project timelines and stakeholder needs
• Identify opportunities to enhance reporting efficiency, data flow, and system usability
• Support implementation of evolving reporting and workflow requirements as the project grows and operational needs expand
• Travel to remote work alternate project sites as required

Reason for vacancy: New role

The expected salary range for this position is $65,000-$75,000

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.

We strongly encourage applicants who identify as Indigenous to apply to work with us on the Darlington New Nuclear Project. At Aecon, Indigenous is an umbrella term for First Nations (status and non-status), Metis and Inuit