Data Migration Analyst

AFH Financial Group; Bromsgrove; Hybrid; GBP 40,000 - 65,000; Full time

Benefits offered by this job

Training and qualifications support

Contributory pension scheme and life/"

Discretionary annual bonus

Job summary

AFH Wealth Management in Bromsgrove is seeking a Data Migration Analyst (M&A Integration) to support data transfers during acquisitions. You will analyse source data, map, cleanse, and migrate into target systems while ensuring compliance and data integrity.

The role requires strong SQL, ETL, and data transformation skills, experience with financial services data, and collaboration with IT, vendors and programme teams to deliver smooth migrations.

Qualifications

• Bachelor’s degree in computer science, information systems or a related field.
• Strong understanding of data mapping, ETL processes, and data transformation.
• Experience with data governance frameworks and regulatory requirements (GDPR/FCA).
• Proven experience in data migration/integration, preferably in financial services.
• Experience with cloud-based data environments.

Responsibilities

• Transfer data from legacy to new environments across multiple acquisitions.
• Analyse source system data from acquired organisations.
• Define and document data mappings and rules.
• Perform ETL to transform and load data into target systems.
• Monitor data quality and address post-migration issues.
• Maintain documentation for audits and regulatory reviews.

Skills

Data migration

Data integration

SQL

ETL

Python

Data mapping

Regulatory compliance

Stakeholder management

M&A integration

Data governance

Education

Bachelor's degree in Computer Science / Information Systems

Tools

ETL tools

Migration tools

Job description

• Location: Bromsgrove, Worcestershire, United Kingdom
• Salary: Competitive Salary and Benefits

Data Migration Analyst (M&A Integration)

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

AFH Wealth Management is oneof 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:

• 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
• 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
• Social events