Data Migration Analyst

AFH Wealth Management; Bromsgrove; On-site; GBP 42,000 - 60,000; Full time

Benefits offered by this job

Training and qualifications support

Pension scheme

Discretionary bonus

Health benefit scheme

Flexible working

Holidays buy/sell

Job summary

AFH Wealth Management is seeking a Data Migration Analyst to support data migration in mergers and acquisitions within the financial services sector. You will analyse source data, map rules, perform ETL, and ensure data integrity and regulatory compliance across environments.

The role requires experience in data migration, strong SQL/excel/python skills, and the ability to manage multiple workstreams with attention to detail.

Qualifications

• Proven experience in data migration or data integration, ideally within financial services.
• Excellent understanding of data mapping, ETL processes, and data transformation.
• Strong technical proficiency to comprehend current system architecture, data structures and integration points.
• Meticulous data analysis ensuring data integrity during transition.
• Experience with M&A or system integration projects.
• Proficiency in SQL and data analysis tools (Excel, Python).
• Experience with migration tools.
• Strong analytical and problem-solving skills.
• Ability to manage multiple workstreams and tight deadlines.

Responsibilities

• Support end-to-end data transfer from legacy to new environments across multiple acquisitions.
• Analyse source system data from acquired organisations.
• Define and document data mappings.
• Identify and resolve data issues during migration.
• Perform ETL to extract, transform, and load data.
• Monitor data performance and provide post-migration support.
• Maintain documentation for audit and regulatory reviews.
• Develop and execute data migration test plans and scripts.
• Ensure data completeness and accuracy of migrated data.

Skills

Data migration

Data mapping

ETL processes

SQL

Data analysis

M&A or system integration

Regulatory compliance

Problem solving

Multi-tasking

Education

Bachelor's degree in CS/IS or related field

Tools

SQL

Excel

Python

Job description

Data Migration Analyst (M&A Integration)

This is a an fantastic opportunity to join our team at AFH Wealth Management.

AFH Wealth Management is one of the UK's leading independent financial advisory and wealth management firms - providing expert advice and long-term financial solutions to individuals, families and businesses. With more than 200 Advisers and 750 staff, we are driven by our culture, values and client-centric approach.

The Data Migration Analyst plays a critical role in supporting mergers and acquisitions (M&A) within the financial services sector. This role is responsible for analysing, mapping, cleansing, and migrating data from acquired entities into target systems while ensuring data integrity, regulatory compliance, and minimal disruption to business operations.

As a Data Migration Analyst you will be responsible for:

• Responsible for supporting the end-to-end process of transferring data from legacy to new environments across multiple acquisitions
• Analyse source system data from acquired organisations
• Liaise with Vendors and business users to understand data requirements and critical data elements
• Define and document data mapping rules between legacy and target systems
• Identify and resolve data issues and discrepancies during the migration process
• Perform ETL process to extract data, transform it according to migration requirements and load into target systems
• Monitor data performance and provide ongoing support to address any post-migration issues.
• Document each phase of the migration process, including data mappings, transformations, and quality checks.
• Produce and enforce development standards and technical standards.
• Contribute to migration strategy, planning, and execution phases
• Liaise with IT, vendors, and programme teams to ensure alignment
• Translate business requirements into technical data mappings and rules
• Ensure adherence to financial services regulatory requirements (e.g., GDPR, FCA guidelines)
• Support data governance frameworks, including data lineage and auditability
• Maintain documentation for audit and regulatory reviews
• Develop and execute data migration test plans and scripts
• Perform reconciliation and ensure completeness and accuracy of migrated data

What we are looking for in our ideal Data Migration Analyst:

Essential

• Proven experience in data migration or data integration roles, ideally within financial services
• Excellent understanding of data mapping, ETL processes, and data transformation
• Strong technical proficiency to comprehend current system architecture, data structures, and integration points
• Skilled in meticulous data analysis and migration, ensuring data integrity during transition
• Experience working on M&A or system integration projects
• Proficiency in SQL and data analysis tools (e.g., Excel, Python, or similar)
• Experience with migration tools
• Strong analytical and problem-solving skills
• Ability to manage multiple workstreams and tight deadlines

Desirable

• Knowledge of financial products (e.g. investments, pensions, insurance)
• Bachelor's degree in computer science, Information Systems or related field
• Understanding of financial platforms/CRMs
• Familiarity with data governance frameworks and regulatory requirements
• Experience in cloud-based data environments
• Attention to detail and data accuracy
• Strong communication and stakeholder management skills
• Adaptability in fast-paced M&A environments
• Structured and methodical approach to problem solving
• Team collaboration and cross-functional working

Benefits of working for AFH Wealth Management:

• Training and qualifications - We take pride in supporting and paying for our staff to undertake professional qualifications relevant to your jobs role once you have passed your three-month probation
• Contributory pension scheme, and death-in-service benefit
• Competitive salary and annual discretionary bonus, following one year's service
• Health benefit scheme - including digital gym subscriptions, dental and optional treatments and alternative therapies
• Flexible working options and competitive holiday allowance, with annual buy and sell scheme options
• Enhanced maternity, adoptive and paternity pay
• Loyalty bonus and additional holiday days, based on length of service
• Employee referral bonus scheme
• Social events

To learn more about this opportunity and the culture of AFH Wealth Management, please visit our Careers website https://www.afhwm.co.uk/careers/. If you have any questions about this vacancy please contact the People Resourcing Team on [e-mail]. We look forward to hearing from you!