Implementation Consultant - Data Migration

Procentia; West of England; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

25 days holiday

Public holidays

Volunteer day

Pension 5% Employer contribution

Life Assurance

Private Medical Insurance

Employee Assistance Programme (EAP)

Health care cash plan

Tusker – Electric Car Leasing scheme

Job summary

Procentia, part of the Brightwell Group, specializes in pensions software and data migration. We are seeking an Implementation Consultant with strong Data Migration experience to lead planning, mapping, transformation, and migration of client data into IntelliPen.

You will work with Professional Services, Product and Technology to ensure data readiness, quality, and timely delivery. You should be proficient in T-SQL and XML, comfortable with complex data sets, and capable of collaborating across

Qualifications

• 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

Responsibilities

• 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.
• 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.

Skills

Data migration design

SQL Server

T-SQL

XML

ETL

Data cleansing

Performance optimization

Client communication

Job description

About us

Procentia, part of the Brightwell Group, is an award-winning software and technology company specialising in the Pensions and Pension Risk Transfer/Bulk Purchase Annuities market. Established in 2002, the business is renowned for its web-based pensions administration and management system, IntelliPen.

Procentia’s products and solutions help pension schemes and administrators of all types and sizes manage exceptional volumes of data, meet the demand for self-serve technology, and provide meaningful, consumer-like experiences that users expect from modern online financial platforms while minimising the need for administrator intervention and involvement.

With offices in the UK and North America, Procentia supports some of the largest pension schemes, insurers and retirement plans across the private and public sectors, including BP, British Airways Pension Scheme, BTPS, Chicago Transit Authority, Legal & General Retirement America, Retirement System City of Detroit, Rolls-Royce, Royal London, and Universities Superannuation Scheme.

The job:

As part of our continuing growth, we are seeking to recruit an Implementation Consultant with strong Data Migration experience to join Procentia.

The purpose of this role is to lead and support the planning, preparation and migration of client data from legacy systems into the IntelliPen suite of products. This includes data mapping, transformation logic, migration scripting, data cleansing, reconciliation, validation and supporting clients through data readiness activities.

To be successful, you should be proficient in T-SQL and XML, comfortable working with complex data sets, and able to work collaboratively with colleagues across Professional Services, Product and Technology.

Here's what you'll be doing:

• 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.
• 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.

Key skills and experience:

• 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

Lets talk about what's in it for you...

• 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

Don’t meet every requirement?

We know that some candidates, particularly women, disabled people, LGBTQ+ individuals, neurodivergent people, and those from ethnic minority backgrounds, may hesitate to apply unless they meet every listed requirement. At Procentia, we’re committed to building a diverse, inclusive workplace where everyone can thrive. If this role excites you but your experience doesn’t align perfectly with every requirement, we encourage you to apply anyway. You could be a great fit for this role or another opportunity within our team.