The Data Migration Consultant will lead the planning of data migration projects for pensions clients to move legacy system data to the new environment with accuracy. This activity will involve designing data mapping frameworks, transformation logic and developing automated migration scripts whilst regularly validating the integrity of the migrated data though robust testing. Proficiency in the use of T-SQL, SQL, Excel Macros and XML will be required.
The Data Migration Consultant will have credible financial services knowledge and migration experience, technical knowledge as well as exceptional analytical approach to ensure compliant and accurate outcomes.
The Data Migration Consultant will be part of the client delivery team and will liaise with clients to gather their requirements, produce data frameworks and configure the migration requested. There may be an occasional need to travel to client sites to do this.
What you’ll be doing as a Data Migration Consultant:
Design, implement, and optimize SQL-based data solutions to support data migration and reporting needs.
Develop data migration plans and processes, ensuring minimal disruption to existing services and data integrity.
Perform ETL operations to migrate data between systems, ensuring accuracy and completeness.
Collaborate with other team members to gather data requirements and design solutions that meet project and company goals.
Monitor and improve database performance, managing indexing, partitioning and query optimization.
Ensure compliance with data protection and privacy standards, proactively managing risks associated with data migration. Additional duties include the configuration of workflows, data maintenance screens, interfaces with other systems, pensioner payroll, data migrations and report.
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 IntelliPen 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.
What we’d like to see from your application:
Proven track record in designing and implementing data migration 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 data migration 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.
IntelliPen / IntelliCalcs experience would be advantageous.
Location: Remote. However, you may need to travel to client sites around the UK when required.
The rate on offer: Competitive day rates via umbrella contract dependant on experience.
Hours: Monday to Friday. 37.5 hours per week. Monday to Friday.
Duration: 6 months with opportunity to extend.
Read Less
