Staff Data Developer

AtkinsRéalis Group; Montreal (administrative region); Hybrid; CAD 90,000 - 140,000; Full time

Benefits offered by this job

Hybrid working culture

Flexible benefits and training

Job summary

AtkinsRéalis Group in Canada seeks a Senior Data Engineer to own end-to-end data engineering across source-to-raw, raw-to-integrated, and integrated-to-curated pipelines. You will design and optimize Azure Data Factory pipelines, SQL transformations, and Azure Functions, supporting governance and data quality for enterprise platforms.

Collaborate with data analysts, architects, QA, stakeholders, and global teams.

Qualifications

• Significant hands-on experience delivering and supporting enterprise data platforms in Microsoft Azure.

Responsibilities

• Own and deliver end-to-end data engineering changes across S2R, R2I, I2C, and related data flows.
• Design, build, review, test, and optimize Azure Data Factory pipelines, SQL transformations, Azure Functions, curated datasets, and supporting orchestration.
• Troubleshoot failed or long-running pipelines, data issues, and environment defects.
• Serve as senior escalation point for incidents, perform root-cause analysis, and coordinate fixes with teams.
• Prepare deployment plans, manage PRs, reviews, and environment promotions.

Skills

Azure Data Factory

Azure Synapse Analytics

Azure SQL

SQL Server

Azure Data Lake Storage Gen2

ETL/ELT

Data modelling

REST API integration

CI/CD pipelines

PowerShell

Git/Azure DevOps

Data governance

Tools

Microsoft Fabric

Azure Functions

Job description

Overview

AtkinsRéalis is a world-leading engineering services and nuclear company dedicated to engineering a better future for our planet and its people. The Data, AI & Advanced Analytics team delivers enterprise data platforms, analytics, automation, and AI capabilities that support critical business processes across finance, operations, projects, people, and digital services.

Overview

AtkinsRéalis is a world-leading engineering services and nuclear company dedicated to engineering a better future for our planet and its people. The Data, AI & Advanced Analytics team delivers enterprise data platforms, analytics, automation, and AI capabilities that support critical business processes across finance, operations, projects, people, and digital services.

Your role

• Own and deliver end-to-end data engineering changes across source-to-raw (S2R), raw-to-integrated (R2I), integrated-to-curated (I2C), and related data flows.
• Design, build, review, test, and optimize Azure Data Factory pipelines, SQL transformations, Azure Functions, curated datasets, and supporting orchestration.
• Troubleshoot failed or long-running pipelines, source-data issues, dependency problems, duplicate records, key design issues, refresh failures, and environment-specific configuration defects.
• Act as a senior technical escalation point for Orb incidents and production issues, completing root-cause analysis, implementing fixes, validating outcomes, and coordinating follow-up with analysts, QA, platform engineers, and source-system teams.
• Prepare and review deployment plans; coordinate pull requests, code reviews, environment promotion, production releases, rollback readiness, and post-deployment sanity checks.
• Monitor platform operations through Azure and platform logs, identify usage or performance patterns, and recommend changes to schedules, dependencies, batch processing, retries, and load strategies.
• Apply data classification, sensitivity, access, and governance requirements consistently across raw, integrated, curated, and consumer-facing data assets.
• Support data modelling and data quality decisions, including primary keys, business keys, mapping rules, source-to-target metadata, matching logic, and duplicate handling.
• Partner closely with data analysts, data architects, QA analysts, product owners, business stakeholders, and technical teams to clarify requirements and translate them into dependable engineering solutions.
• Provide technical coaching, code-review feedback, troubleshooting support, and knowledge transfer to engineers and analysts across Canada, the United Kingdom, and India.
• Maintain high-quality technical documentation, including mapping specifications, deployment plans, change records, operational evidence, and support handover material.
• Contribute to the evolution of the Orb platform, including standardized engineering templates, automation, maintainability improvements, and migration toward Microsoft Fabric.

Pipeline Engineering

• Build and rework Azure Data Factory (ADF) pipelines and supporting SQL or Azure Function components for REST APIs, files, ERP, HR, finance, project, procurement, and other enterprise sources.

Technical Assurance

• Review pull requests, validate implementation against engineering patterns, confirm unit testing, and identify defects before release.

Release And Operations

• Coordinate DEV, UAT, pre-production, and production deployment activities.
• Refresh or rerun pipelines.
• Perform technical checks.
• Support controlled recovery activities.

Data Design

• Contribute to source-to-target mappings, metadata, keys, sensitivity classifications, integrated and curated models, and reconciliation logic.

Incident Resolution

• Investigate failed loads, timeouts, API limits, duplicates, missing data, configuration issues, and cross-environment differences.

Team Enablement

• Unblock analysts and engineers, explain platform behaviour, provide practical guidance, and preserve continuity across global handoffs.

About You

• Significant hands-on experience delivering and supporting enterprise data platforms in Microsoft Azure.

Primary/Mandatory Skills

• Data Engineering and Integration:
• Azure Data Factory.
• Azure Synapse Analytics.
• Azure SQL.
• SQL Server.
• Azure Data Lake Storage Gen2.
• ETL/ELT, orchestration, incremental and full-load patterns, dependency management, retry and batching strategies.
• T-SQL, stored procedures, source-to-target mapping, dimensional and relational data modelling.
• REST API, file-based, database, ERP, and SaaS integration patterns.
• Delta Lake, Parquet, Operational Data Store, Data Warehouse, Lakehouse, and curated-data concepts.

Software Engineering And DevOps

• C#/.NET and Azure Functions.
• Git and Azure DevOps pull requests, code reviews, build and release pipelines.
• CI/CD, environment configuration, release planning, deployment evidence, rollback, and post-release validation.
• PowerShell or equivalent scripting for automation and operational support.

Operations, Quality, And Governance

• Production troubleshooting, root-cause analysis, logging, monitoring, and incident resolution.
• Data quality investigation, reconciliation, duplicate handling, key design, and validation.
• Data classification, sensitivity, secure access, Azure Key Vault, and Microsoft Entra ID.
• Clear technical documentation and disciplined change-control practices.
• Secondary/Developing Skills:
• Microsoft Fabric, including Data Factory, OneLake, Lakehouse, Warehouse, notebooks, pipelines, and semantic models.
• Power BI semantic models and downstream analytical consumption.
• Master Data Management concepts and Profisee.
• Real-time and event-driven data processing where required by the platform roadmap.
• Ability to move between solution delivery and operational support without losing engineering discipline.
• Ability to communicate clearly with technical and non-technical stakeholders and turn ambiguous issues into actionable engineering work.
• Strong judgement when assessing release readiness, production risk, data correctness, and appropriate escalation.
• Comfort working across time zones and coordinating handoffs among globally distributed engineering, QA, analysis, and architecture teams.
• A collaborative approach to coaching others, sharing context, and improving repeatability through standards and automation.
• Bilingualism (french and English)
• Member of the Canadian or Global Leadership Team: This position requires knowledge of a language other than French, namely English, as it involves collaboration with members of the Canadian or global leadership team located outside Québec.

Rewards & benefits

Explore the rewards and benefits that help you thrive – at every stage of your life and your career at AtkinsRéalis in Canada.

Enjoy competitive compensation, employee recognition, and a brilliant range of flexible benefits you can tailor to your health, wellbeing, financial and lifestyle needs.

Make the most of diverse opportunities for training and professional development to grow your skills and expertise.

And take advantage of our hybrid working culture and generous time-off policies to balance a fulfilling career with your personal life.

Be rewarded