Data Migration Analyst
UK Visa Sponsorship Analytics
Occupation Type
Data analysts
Occupation Code Skill LevelMedium Skilled
Sponsorship Salary Threshold
£41,700
(£21.38 per hour)
Standard minimum applies
Above analytics are generated algorithmically based on job titles and may not always be the same as the company's job classification. You can also check detailed occupation eligibility, and salary criteria on our UK Visa Eligible Occupations & Salary Thresholds page.
Disclaimer: Hunt UK Visa Sponsors aggregates job listings from publicly available sources, such as search engines, to assist with your job hunting. We do not claim affiliation with Schroders Personal Wealth. For the most up-to-date job details, please visit the official website by clicking "Apply Now."
Description
Job Type
Fixed Term (Fixed Term)
Closing Date
29/03/2026
Schroders Personal Wealth aims to improve the way financial advice is offered, by making it more affordable, accessible and powerful for more people. We want to change lives for the better.
As a Data Migration Analyst, you will be a key member of a data migration / data archiving project. Working closely with the Data Migration Lead, you will support the design, build, analysis, mapping, transformation and validation of data required to deliver the data migration / archive project. You will be responsible for profiling, analysing and documenting datasets, including both structured and unstructured data, to ensure high‑quality, complete and accurate data is migrated to the target platform and archive solution appropriately.
You will work collaboratively across business stakeholders, business analysts, data analysts, engineering teams and project delivery to support end‑to‑end migration activities including mapping definition, data quality assessment, rules creation, testing support and reconciliation.
Role | Fixed Term Contract to 31/12/2026
Salary |
Fixed Term (Fixed Term)
Closing Date
29/03/2026
Schroders Personal Wealth aims to improve the way financial advice is offered, by making it more affordable, accessible and powerful for more people. We want to change lives for the better.
As a Data Migration Analyst, you will be a key member of a data migration / data archiving project. Working closely with the Data Migration Lead, you will support the design, build, analysis, mapping, transformation and validation of data required to deliver the data migration / archive project. You will be responsible for profiling, analysing and documenting datasets, including both structured and unstructured data, to ensure high‑quality, complete and accurate data is migrated to the target platform and archive solution appropriately.
You will work collaboratively across business stakeholders, business analysts, data analysts, engineering teams and project delivery to support end‑to‑end migration activities including mapping definition, data quality assessment, rules creation, testing support and reconciliation.
Role | Fixed Term Contract to 31/12/2026
Salary |
£51,907 to £57,098
Location | Leeds, West Yorkshire
Key Responsibilities
Data Analysis & Mapping
Build and conduct detailed data profiling and assessment across datasets, including structured and unstructured data.
Support the creation and maintenance of data mapping specifications between source systems, the target and archive solutions.
Analyse and interpret business rules, transformation logic and data requirements with SMEs, business analysts and the Data Migration Lead.
Document data definitions, relationships, lineage and metadata supporting migration and archival activities.
Support the identification of data gaps, inconsistencies, duplicates and quality issues.
Data Quality & Validation
Perform data quality analysis to identify defects, trends, root causes and potential remediation activities.
Support the development and execution of data cleansing, enrichment and transformation rules.
Assist in defining data quality checks, validation criteria, acceptance thresholds and reconciliation steps.
Work with stakeholders to ensure data issues are logged, triaged, remediated and re‑tested efficiently.
Contribute to ongoing monitoring and reporting of data quality throughout migration cycles.
Migration Design & Execution Support
Location | Leeds, West Yorkshire
Key Responsibilities
Data Analysis & Mapping
Build and conduct detailed data profiling and assessment across datasets, including structured and unstructured data.
Support the creation and maintenance of data mapping specifications between source systems, the target and archive solutions.
Analyse and interpret business rules, transformation logic and data requirements with SMEs, business analysts and the Data Migration Lead.
Document data definitions, relationships, lineage and metadata supporting migration and archival activities.
Support the identification of data gaps, inconsistencies, duplicates and quality issues.
Data Quality & Validation
Perform data quality analysis to identify defects, trends, root causes and potential remediation activities.
Support the development and execution of data cleansing, enrichment and transformation rules.
Assist in defining data quality checks, validation criteria, acceptance thresholds and reconciliation steps.
Work with stakeholders to ensure data issues are logged, triaged, remediated and re‑tested efficiently.
Contribute to ongoing monitoring and reporting of data quality throughout migration cycles.
Migration Design & Execution Support
Support the Data Migration Lead in developing migration processes across extraction, staging, transformation and load phases.
Assist with preparing and validating datasets for mock loads, testing cycles and dress rehearsals.
Validate migrated data against source systems using reconciliation techniques.
Document technical and business findings relating to data anomalies, edge cases and mapping clarifications.
Assist in cutover preparation, data freeze activities and post‑migration verification.
Support quality checks, controls and sign‑off processes.
Data Archiving
Support the design and population of data archival datasets, ensuring completeness and compliance with data retention policies.
Analyse legacy data to determine suitability for archiving versus migration.
Document archival metadata, lineage and access considerations.
Qualifications & Skills
Relevant experience as a Data Analyst, Business Analyst or similar role with exposure to data‑heavy change and migration initiatives.
Experience working with datasets in financial services or financial advice organisations is desirable.
Understanding of data migration, data cleansing, data mapping, ETL/ELT processes and data lineage.
Experience working with 3rd party vendors is advantageous.
Strong technical skills in SQL and experience analysing data across data lakes, databases or wareho
Assist with preparing and validating datasets for mock loads, testing cycles and dress rehearsals.
Validate migrated data against source systems using reconciliation techniques.
Document technical and business findings relating to data anomalies, edge cases and mapping clarifications.
Assist in cutover preparation, data freeze activities and post‑migration verification.
Support quality checks, controls and sign‑off processes.
Data Archiving
Support the design and population of data archival datasets, ensuring completeness and compliance with data retention policies.
Analyse legacy data to determine suitability for archiving versus migration.
Document archival metadata, lineage and access considerations.
Qualifications & Skills
Relevant experience as a Data Analyst, Business Analyst or similar role with exposure to data‑heavy change and migration initiatives.
Experience working with datasets in financial services or financial advice organisations is desirable.
Understanding of data migration, data cleansing, data mapping, ETL/ELT processes and data lineage.
Experience working with 3rd party vendors is advantageous.
Strong technical skills in SQL and experience analysing data across data lakes, databases or wareho
uses.
Ability to work with both structured datasets and unstructured content (e.g., documents, notes, attachments).
Understanding of data quality principles, GDPR and data governance practices.
Strong analytical mindset with excellent attention to detail.
Proficiency with Jira, Confluence or similar tools is beneficial.
Strong communication skills with the ability to translate data issues to technical and non‑technical stakeholders.
We understand not everyone will meet 100% of the requirements, however we encourage you to apply if you think your skills are a good fit for this role.
This job vacancy may close earlier than the advertised date if a suitable candidate is found. We encourage interested applicants to submit their applications as soon as possible.
Some fantastic benefits SPW colleagues enjoy:
Ability to work with both structured datasets and unstructured content (e.g., documents, notes, attachments).
Understanding of data quality principles, GDPR and data governance practices.
Strong analytical mindset with excellent attention to detail.
Proficiency with Jira, Confluence or similar tools is beneficial.
Strong communication skills with the ability to translate data issues to technical and non‑technical stakeholders.
We understand not everyone will meet 100% of the requirements, however we encourage you to apply if you think your skills are a good fit for this role.
This job vacancy may close earlier than the advertised date if a suitable candidate is found. We encourage interested applicants to submit their applications as soon as possible.
Some fantastic benefits SPW colleagues enjoy:
- Generous Holiday Entitlement: 30 days of annual leave plus bank holidays, with the option to buy or sell 5 days.
- Health & Wellbeing: Company-paid Private Medical Insurance, Life Insurance, and Health Screening.
- Company Pension Contribution: A matched pension contribution of up to 15% of your base pay.
We support flexible working:
At SPW, we know how important it is to be able to achieve a balance. We want to support your lifestyle as well as meeting our business needs, so will always aim to be flexible. As well as traditional working patterns, we have colleagues who work informal flexible hours, reduced working hours, and have job-sharing arrangements. Many colleagues work from home, or in a hybrid way.
Ready to restart your career?
We warmly welcome applications from those returning to work after a period of leave, providing appropriate support and training where required.
You belong here:
At SPW, we embrace individuality and diversity of identity, experience, and thought. We actively strive for inclusive behaviours and actions, making appropriate adjustments for disabilities, health conditions and neurodiversities. We ensure equal opportunities for all and transparently report on gender pay to promote fairne
ss.
Schroders Personal Wealth operates under the Senior Managers and Certification Regime as a solo-regulated firm and if this role is classed as a Certified Role under that regime you will be subject to enhanced vetting and will have a number of additional conduct and regulatory duties to adhere to, as well as certifying at least annually that you are fit and proper to perform this role.
Schroders Personal Wealth operates under the Senior Managers and Certification Regime as a solo-regulated firm and if this role is classed as a Certified Role under that regime you will be subject to enhanced vetting and will have a number of additional conduct and regulatory duties to adhere to, as well as certifying at least annually that you are fit and proper to perform this role.