Data Migration Consultant

Location: West Sussex

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 a sharp 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.

What you’ll be doing as a Data Migration Consultant:

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. Additional duties include the configuration of workflows, maintenance screens, interfaces with other systems, pensioner payroll and reports.
Communicating with clients throughout the software customisation process to obtain feedback and approval.
Customising software systems based on client’s individual needs and specifications.
Educating clients on how to use Intelli Pen and customised system features. Engaging with our training team when required.
Creating documentation for clients and for internal use where appropriate.
Providing support in the software release process and software upgrade process when required.
Building relationships with team members and all internal and external clients.
What we’re looking for in a Data Migration Consultant:

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.
Strong understanding of database structures, principles, and practices, with experience in 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 in 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. Monday to Friday.

Location:

Remote. However, you may need to travel to client sites around the UK when required.
Day rate:
Competitive day rates via umbrella contract dependant on experience.
Duration: 6 months with opportunity to extend.

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

Please note any offer is subject to satisfactory pre-employment screening checks. These consist of employment, activity & GAP verification, DBS or Access NI, Credit, Sanctions & CIFAS checks.

We are committed to equality of opportunity for all hires and 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.

To help you stay safe in your job search we will never ask for your bank details at the application stage.

Candidate Source Ltd is an advertising agency. Once you have submitted your application it will be passed to the third party Recruiter who is responsible for processing your application. This will include holding and sharing your personal data, our legal basis for this is legitimate interest subject to your declared interest in a job. Our privacy policy can be found on our website and we can be contacted to confirm who your application has been forwarded to