SM
Software Mind
Data Engineer

[C3J] Azure Data Engineer

HybridSeniorData Engineerposted 2w ago
✦Role summaryAI-generated

You will design, build, and operate ETL pipelines to migrate millions of records from legacy SQL Server databases into Azure SQL while ensuring strict data integrity through validation and reconciliation logic. Collaboration with business analysts and client technical leadership will be essential to define data mappings, transformation rules, and document reconstructed source schemas.

Skills required

AzureSQLSql serverAzure sqlETLData modelingData validationData migrationData pipelinesData reconciliationDevOpsDatabricksSnowflakedbt

About this role

Project – the aim you’ll have

Join a large-scale data migration programme run by an international software provider operating in a regulated, audited sector. You will work in a small, senior delivery team alongside the client’s own engineering squads, moving millions of records from a legacy system into a modern Azure estate. Strict reconciliation standards, genuine accountability for data integrity, and direct contact with the client’s technical leadership.

Role – how you’ll contribute

  • Design, build and run ETL pipelines migrating data from legacy SQL Server databases into Azure SQL
  • Profile and reverse-engineer source schemas where documentation is incomplete, and document the model you reconstruct
  • Build validation and reconciliation logic that proves completeness and correctness ahead of the initial load and every delta load
  • Work with the Business Analyst on data mapping, transformation rules and the agreed data dictionary
  • Execute migration rehearsal runs and support the cutover
  • Follow ITIL-aligned change and release management for every production change
  • Diagnose and resolve production data incidents, and contribute to root cause analysis and permanent fixes
  • Maintain technical documentation for the migration components and hand it over at the end of the engagement

    Qualifications

    Expectations – the experience you need

    • 3+ years delivering data migration or ETL development on enterprise or high-stakes systems
    • Strong T-SQL and hands-on experience with Microsoft SQL Server, including SSIS
    • Practical experience with Azure SQL Database and the surrounding Azure data services (Data Factory, Azure DevOps)
    • Demonstrable data validation and reconciliation work: you can explain how you proved a migration was correct, not just that it ran
    • Comfort working from incomplete documentation, using schema discovery and data profiling as a first step
    • Experience handling JSON and XML payloads held inside relational structures
    • English at C1 or above, with daily contact with international stakeholders

    Additional skills – the edge you have

    • Microsoft certification, ideally DP-203 Azure Data Engineer Associate
    • ITIL Foundation v4, or willingness to certify (at our cost)
    • Experience in a regulated, audited sector such as financial services, public sector or healthcare
    • Experience with change data capture and keeping systems in sync during a parallel-run period
    • Exposure to Databricks, Snowflake or dbt

      Additional Information

      What we offer:

      • Flexible and remote cooperation options
      • International projects with leading global clients
      • Travels related to international projects
      • Non-corporate atmosphere
      • Access* to language classes
      • Access* to knowledge-sharing initiatives
      • Access* to private healthcare and life insurance
      • Access* to multisport card

      *The availability and terms of individual benefits may vary depending on the chosen form of cooperation.

      score your resume against this role

      Similar open roles

      Z
      NEW

      D365 Data Engineer

      Zensar·India
      On-siteSeniorData Engineer
      today
      UG
      NEW

      Senior Data Engineer

      UBDS Group·London, England, United Kingdom; Manchester, England, United Kingdom
      On-siteSeniorData Engineer
      today
      C
      NEW

      Senior Data Engineer

      CodeLink·Da Nang, Hai Chau, Vietnam; Hanoi, Ha Noi, Vietnam; Ho Chi Minh City, Ho Chi Minh, Vietnam
      On-siteSeniorData Engineer
      Master data managementData integrationETL
      today
      C
      NEW

      Data Engineer (Machine Learning & Data Platform)

      CodeLink·Da Nang, Hai Chau, Vietnam; Hanoi, Ha Noi, Vietnam; Ho Chi Minh City, Ho Chi Minh, Vietnam
      On-siteMidData Engineer
      today
      B
      NEW

      Data Architect - R01573922

      Brillio·Bangalore, Karnataka, India
      On-siteSeniorData Engineer
      today
      Apply on Software Mind →