Data Migration Analyst in Leeds

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.

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

• 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 warehouses.
• 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.

• 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.
• Cash Allowance: Flexible allowance to spend on additional benefits personal to you, including: dental cover, paid sabbatical leave, gym membership, menopause support.
• Bonus Opportunity: Dependent on individual/company performance (eligible after 3 months’ service).
• Financial Advice: Access to free financial advice to help secure your financial future.

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. 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 fairness.

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.

If you need more insight about what it’s like to work here, check out our careers page. If you are ready to explore our vacancies further, get scrolling! The 'Search for Jobs' page shows you all our current roles, each providing an opportunity to develop your career in an organisation that, through innovative products and technology and a clear client focus, has set its sights on being at the forefront of the Wealth Management market. If there is no suitable role for you now, keep checking in. New roles come live all the time and they don’t always stick around for long!