A

AtkinsRéalis

Engineering services for infrastructure and energy

Staff Data Developer

Data EngineeringConfirmed live in the last 24 hours
Full-time$95.3k - $130k /yr

About the Job

Requirements

  • Significant hands-on experience delivering and supporting enterprise data platforms in Microsoft Azure.
  • Experience with Azure Data Factory, Azure Synapse Analytics, Azure SQL, SQL Server, and Azure Data Lake Storage Gen2.
  • Knowledge of ETL/ELT, orchestration, incremental and full-load patterns, dependency management, retry strategies, and batching strategies.
  • Proficiency in T-SQL, stored procedures, source-to-target mapping, and dimensional and relational data modelling.
  • Knowledge of REST API, file-based, database, ERP, and SaaS integration patterns.
  • Knowledge of Delta Lake, Parquet, Operational Data Store, Data Warehouse, Lakehouse, and curated-data concepts.
  • Experience with C#/.NET and Azure Functions.
  • Experience with Git and Azure DevOps pull requests, code reviews, build and release pipelines.
  • Knowledge of CI/CD, environment configuration, release planning, deployment evidence, rollback, and post-release validation.
  • PowerShell or equivalent scripting for automation and operational support.
  • Experience with production troubleshooting, root-cause analysis, logging, monitoring, and incident resolution.
  • Experience with data quality investigation, reconciliation, duplicate handling, key design, and validation.
  • Knowledge of data classification, sensitivity, secure access, Azure Key Vault, and Microsoft Entra ID.
  • Ability to produce clear technical documentation and follow disciplined change-control practices.
  • Ability to move between solution delivery and operational support while maintaining engineering discipline.
  • Ability to communicate with technical and non-technical stakeholders and turn ambiguous issues into actionable engineering work.
  • Sound judgement in assessing release readiness, production risk, data correctness, and appropriate escalation.
  • Ability to work across time zones and coordinate handoffs among globally distributed engineering, QA, analysis, and architecture teams.
  • Ability to coach others, share context, and improve repeatability through standards and automation.
  • Bilingual proficiency in French and English.
  • Knowledge of English is required for collaboration with Canadian or global leadership team members located outside Québec.

Responsibilities

  • Own and deliver end-to-end data engineering changes across source-to-raw, raw-to-integrated, integrated-to-curated, 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.
  • Serve as a senior technical escalation point for Orb incidents and production issues by 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 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 with data analysts, data architects, QA analysts, product owners, business stakeholders, and technical teams to clarify requirements and translate them into 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 technical documentation, including mapping specifications, deployment plans, change records, operational evidence, and support handover material.
  • Contribute to the evolution of the Orb platform through standardized engineering templates, automation, maintainability improvements, and migration toward Microsoft Fabric.
  • Build and rework Azure Data Factory pipelines and supporting SQL or Azure Function components for REST APIs, files, ERP, HR, finance, project, procurement, and other enterprise sources.
  • Review pull requests, validate implementation against engineering patterns, confirm unit testing, and identify defects before release.
  • Coordinate DEV, UAT, pre-production, and production deployment activities.
  • Refresh or rerun pipelines, perform technical checks, and support controlled recovery activities.
  • Contribute to source-to-target mappings, metadata, keys, sensitivity classifications, integrated and curated models, and reconciliation logic.
  • Investigate failed loads, timeouts, API limits, duplicates, missing data, configuration issues, and cross-environment differences.
  • Unblock analysts and engineers, explain platform behaviour, provide practical guidance, and preserve continuity across global handoffs.

Desired Qualifications

  • Developing or secondary experience with Microsoft Fabric, including Data Factory, OneLake, Lakehouse, Warehouse, notebooks, pipelines, and semantic models.
  • Experience with Power BI semantic models and downstream analytical consumption.
  • Knowledge of Master Data Management concepts and Profisee.
  • Experience with real-time and event-driven data processing where required by the platform roadmap.

About the Company

AtkinsRéalis

Engineering services for infrastructure and energy

AtkinsRéalis provides engineering services for infrastructure and nuclear projects, connecting people, data, and technology to plan, design, build, and manage systems worldwide. It delivers integrated services through consulting, design, engineering, and project management, using a global team and data-driven collaboration to move projects from concept to commissioning. The company’s global reach and end-to-end capability across conventional engineering and nuclear sectors enable coordinated delivery across multiple disciplines. Its goal is to transform infrastructure and energy systems worldwide by delivering safe, reliable, and efficient engineering solutions.

Company size
10,001+
Company stage
IPO
Headquarters
Epsom, United Kingdom
Founded
1938

Recently Posted Jobs

Explore more opportunities at AtkinsRéalis

See more jobs