Data Migration Analyst: Transform & Validate Client Data

Vertage Inc.; Greater London; On-site; GBP 45,000 - 65,000; Full time

Job summary

Vertage Inc. seeks a Data Migration Analyst to support large-scale implementations and transformations, handling complex datasets and migrations with client stakeholders.

You will analyse data, map and cleanse datasets, validate results, and migrate data into target systems while collaborating with clients and internal teams, and mentoring junior members where required. Experience with pensions administration or financial services is valued, as is strong Excel, SQL, and Python skills to ensure

Qualifications

• Experience in data analysis, data migration, or implementation projects.
• Strong Excel skills with Pivot Tables and XLOOKUP/VLOOKUP.
• Proficient in SQL and ideally Python; capable of data mapping, transformation, validation and reconciliation.
• Excellent stakeholder management and client-facing communication.
• Experience in pensions administration, financial services, or consulting environments.

Responsibilities

• Analyse, validate, and transform client data for system implementations.
• Gather and interpret client requirements, processes, and data structures.
• Perform data mapping, cleansing, reconciliation, and migration activities.
• Support loading transformed data into target systems.
• Identify, investigate, and resolve data issues throughout implementation projects.
• Work closely with clients and internal teams to deliver successful project outcomes.
• Conduct system demonstrations and provide implementation support.
• Contribute to platform enhancements, testing, and technical documentation.
• Support project delivery by identifying risks, issues, and mitigation plans.
• Mentor and support junior team members where required.

Skills

Data analysis

Data migration

Implementation projects

Microsoft Excel

SQL

Python

Data mapping

Data transformation

Data validation

Data reconciliation

Stakeholder management

Client-facing communication

Pension schemes knowledge

Pensions administration experience

Job description

Vertage Inc. seeks a Data Migration Analyst to support large-scale implementations and transformations, handling complex datasets and migrations with client stakeholders.

You will analyse data, map and cleanse datasets, validate results, and migrate data into target systems while collaborating with clients and internal teams, and mentoring junior members where required. Experience with pensions administration or financial services is valued, as is strong Excel, SQL, and Python skills to ensure