Data Migration Consultant

We are looking for an experienced Data Migration Consultant with pension calculations capability to join a dynamic pension services client.

You will lead the planning and delivery of projects for pensions clients, ensuring legacy system data is transitioned accurately into new environments. You'll design mapping frameworks, build transformation logic, develop automated migration scripts, and rigorously test outputs to validate integrity, using tools such as T-SQL, SQL, Excel macros and XML.

Bringing strong financial services and migration expertise, you'll combine technical knowledge with an analytical approach to deliver compliant, accurate outcomes, working within the client delivery team to gather requirements, produce frameworks, configure migrations, and occasionally travel to client sites where needed.

• Design, implement, and optimize SQL-based solutions to support migration and reporting needs.
• Develop plans and processes, ensuring minimal disruption to existing services and integrity.
• Perform ETL operations to migrate data between systems, ensuring accuracy and completeness.
• Collaborate with other team members to gather requirements and design solutions that meet project and company goals.
• Monitor and improve performance, managing indexing, partitioning and query optimization.
• Ensure compliance with protection and privacy standards, proactively managing risks.
• Configure workflows, maintenance screens, interfaces with other systems, pensioner payroll and reports.
• Communicate with clients throughout the software customisation process to obtain feedback and approval.
• Customise software systems based on client's individual needs and specifications.
• Educate clients on how to use Intelli Pen and customised system features. Engage with training team when required.
• Create documentation for clients and for internal use where appropriate.
• Provide support in the software release process and software upgrade process when required.
• Build relationships with team members and all internal and external clients.

• Proven track record in designing and implementing solutions, including data mapping, transformation, reconciliations and validation.
• Strong understanding of database design principles, data modelling, and normalisation.
• Experience with relational databases such as SQL Server.
• Ability to troubleshoot and optimise queries and database structures for improved performance and resource management.
• Proven experience in large-scale projects, preferably within the pensions or financial services industry.
• Skilled in ETL processes, data cleansing, and mapping strategies. Experience implementing software systems.
• Proficiency with T-SQL, Microsoft SQL Server Management, XML and Microsoft full suite.
• The ability to prioritise, meet deadlines and deliver rapid outcomes.
• Excellent verbal, written communication and organisational skills.
• Experience designing and implementing pensions calculations.
• Defined Benefit and Defined Contribution calculations experience.
• Configuring or developing pensions or financial services software.
• Alternative programming knowledge including developing Excel macros or similar.
• Intelli Pen / Intelli Calcs experience would be advantageous.

• Core hours:
  Monday to Friday, 37.5 hours per week.
• Location:
  
  Remote; may need to travel to client sites around the UK when required.
• Day rate:
  Competitive day rates via umbrella contract, dependent on experience.
• Duration: 6 months with opportunity to extend.

To apply for this role as Data Migration Consultant, please click apply online and upload an updated copy of your CV.

Pre-Employment screening checks will include employment, activity & GAP verification, DBS or Access NI, Credit, Sanctions & CIFAS checks.

We are committed to equality of opportunity for all hires. Applications from individuals are encouraged regardless of age, disability, sex, gender reassignment, sexual orientation, pregnancy and maternity, race, religion or belief and marriage and civil partnerships.

We will never ask for your bank details at the application stage.