{"@context":"https://schema.org/","@type":"JobPosting","title":"Data Migration Engineer

Working closely with the Lead Data Engineer, this role will play a critical part in ensuring the new data warehouse accurately replicates existing outputs, while identifying and resolving any data gaps introduced during migration., * Perform source-to-target mapping, documenting field-level lineage across systems and transformation layers

• Analyse and interpret complex legacy SQL stored procedures (including multi-CTE logic, temp tables, and parameterised pipelines)
• Support data migration validation, ensuring accuracy and completeness of migrated datasets
• Conduct data reconciliation and gap analysis, identifying discrepancies between source and target systems
• Produce exception reports and support issue resolution
• Document data flows, transformations, and lineage in a clear and structured manner
• Collaborate with business and technical stakeholders to extract and validate requirements
• Support the design and validation of data models aligned to modern data warehouse practices (e.g., medallion architecture)

This is a hands-on role requiring strong analytical capability, deep SQL expertise, and experience working in complex, regulated data environments., * Proven experience in data warehouse migration within complex environments

• Strong background in financial services, ideally wealth or asset management
• Advanced SQL skills, with the ability to independently analyse complex legacy code
• Demonstrated experience in:

• Source-to-target mapping
• Data lineage documentation
• Migration validation and reconciliation

• Familiarity with medallion architecture principles
• Strong documentation skills with attention to detail
• Ability to engage stakeholders and extract critical technical and business knowledge
• Proficiency with:

• Azure SQL Server
• SQL Server Management Studio (SSMS)

Desirable Skills

• Experience with custody or investment platform migrations
• Familiarity with wealth management CRMs (e.g., Curo or similar)
• Exposure to:

• Azure Data Factory
• Azure Synapse Analytics

• Ability to review Power BI reports and identify field-level dependencies
• Experience working within a consultancy delivery model

Tenth Revolution Group are the go-to recruiter for Data & AI roles in the UK offering more opportunities across the country than any other recruitment agency. We're the proud sponsor and supporter of SQLBits, Power Platform World Tour, and the London Fabric User Group. We are the global leaders in Data & AI recruitment.