Job Description

Contract 5 Months £400-£450/day Outside IR35 Fully Remote (Occasional London Meetings)

We are looking for an experienced Data Migration Analyst / Engineer to support the rebuild of a data warehouse for a wealth management firm undergoing a complex system and data migration programme.

Working alongside the Lead Data Engineer and in parallel with a separate application migration team, this role is focused on ensuring the newly built data warehouse faithfully reproduces existing business outputs through robust source-to-target mapping, migration validation, and transformation analysis.

This is primarily a lift-and-shift migration, not a greenfield redesign, and requires someone who can operate independently, identify gaps, and translate complex legacy logic into a modern data warehouse environment.

• Take ownership of data migration and source-to-target mapping activities supporting the rebuilt data warehouse.
• Review limited or incomplete existing mapping documentation and complete or remediate gaps where required.
• Analyse legacy SQL stored procedures, transformations, and pipelines to understand reporting and MI logic.
• Reconcile outputs from the application migration team with current data warehouse logic to ensure continuity of business outputs.
• Validate that the new warehouse accurately replicates existing reporting and MI, identifying discrepancies and data gaps.
• Support the design and build of dimensional models where necessary.
• Perform reconciliation and migration testing, producing exception reporting and supporting issue resolution.
• Document data lineage, transformations, and dependencies from source systems through to downstream consumption.
• Contribute to assessing reporting dependencies and ensuring downstream consumers (e.g. MI, dashboards) remain consistent post-migration.
• Engage with stakeholders to extract undocumented logic and business rules where required.

• Proven experience in data warehouse migrations, including source-to-target mapping, gap analysis, and migration validation.
• Financial services background (wealth management or asset management strongly preferred).
• Strong SQL Server skills, with the ability to independently read and interpret complex legacy stored procedures (multi-CTE logic, temp tables, parameterised processes).
• Field-level data lineage and mapping documentation experience.
• Hands-on experience with reconciliation, validation, and exception reporting.
• Familiarity with medallion architecture (Bronze/Silver/Gold).
• Ability to produce clear, structured technical documentation.
• Comfortable working autonomously and extracting knowledge from technical and business stakeholders.
• Experience with Azure SQL Server and SQL Server Management Studio (SSMS).

• Experience with custody or investment platform migrations.
• Exposure to wealth management CRMs (e.g. Curo or similar).
• Understanding of Azure Data Factory and/or Azure Synapse Analytics.
• Ability to review Power BI report structures and identify field-level dependencies.
• Experience operating within a consultancy-led delivery model.

• Duration: 5 months
• Rate: £400-£450 per day
• IR35 Status: Outside IR35
• Location: Fully remote
• Travel: Occasional meetings in London (infrequent)

My client has limited interview slots and they are looking to fill this vacancy by then end of the month. I have limited slots for 1st stage interviews next week so if you're interest, get in touch ASAP with a copy of your most up to date CV and email me at or call me on .

Please Note: This is a contract role for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check.

TRG are the go-to recruiter for Power BI and Azure Data Platform roles in the UK, offering more opportunities across the country than any other. We're the proud sponsor and supporter of SQLBits, Power Platform World Tour, the London Power BI User Group, Newcastle Power BI User Group and Newcastle Data Platform and Cloud User Group. To find out more and speak confidentially about your job search or hiring needs, please contact me directly at