Implementation Consultant – Data Migration

Procentia - Pensions Software Solutions

. Lead and support the planning, preparation and migration of client data from legacy systems into the IntelliPen suite of products .

Posted 9/15/2026full-timeBristol • United KingdomMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing data migration solutions, including data mapping, transformation, and validation, while ensuring compliance with data protection standards. Proficient in optimizing SQL-based data solutions and collaborating effectively with cross-functional teams.

Highest-signal resume keywords

Data Migration SolutionsSQL ServerETL ProcessesT-SQLData Mapping

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data MigrationDatabase DesignData ModellingNormalizationQuery OptimizationData CleansingData TransformationReconciliationData IntegrityPerformance Monitoring

Soft Skills

CollaborationCommunicationProblem-Solving

Tools & Technologies

IntelliPenSQLXML

Industry Keywords

PensionsFinancial ServicesData ProtectionPrivacy Standards

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Lead and support the planning, preparation and migration of client data from legacy systems into the IntelliPen suite of products
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 team members to gather data requirements and design solutions meeting project and company goals
Monitor and improve database performance, including indexing, partitioning, and query optimization
Ensure compliance with data protection and privacy standards and proactively manage migration risks
Communicate with clients throughout the data migration lifecycle to clarify requirements, resolve queries, obtain feedback, and support sign-off
Develop and maintain migration specifications, mapping documentation, reconciliation outputs, and supporting evidence for internal and client review

Requirements

What you’ll need

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 in T-SQL and XML
Ability to work collaboratively with colleagues across Professional Services, Product and Technology
Ability to work with complex data sets

Benefits

Comp & perks

25 days holiday (plus public holidays), increasing with length of service up to a maximum of 28 days, with carry over of up to 1 week
Buying and Selling holiday (up to 1 week)
Volunteer day
5% Employer contribution pension
Life Assurance
Private Medical Insurance
Employee Assistance Programme (EAP)
Health care cash plan
Tusker – Electric Car Leasing scheme