Data Migration Engineer - Outside IR35 - RemoteOverview

We are seeking an experienced Data Migration Analyst / Engineer to support a major data warehouse rebuild for a wealth management firm undergoing a large-scale system and data migration programme.

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.

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

Key Responsibilities

• 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)

Required Experience & Skills

• 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

To apply for this role please submit your CV or contact Dillon Blackburn on or at .

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.