Implementation Consultant - Data Migration
Bristol, England, United Kingdom Full-time Posted 1 hour ago
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
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.
Procentia is an award-winning software and technology company specialising in the Pensions and Pension Risk Transfer market. We design intelligent solutions that put administrators and members at the heart of any pension scheme.
Established in 2002, we’re renowned for our leading web-based pensions administration and management system, IntelliPen. Our platform helps schemes meet the demand for self-serve technology and provide meaningful consumer-like experiences that their members expect from online financial platforms.
With offices in the UK and North America, we support some of the largest pension schemes and retirement plans across the private, public, and insurance sectors.
We've been Highly Commended for ‘Technology Innovation of the Year 2025’ at the UK Pensions Awards, named 'Pension Technology Firm of the Year 2024' at the Pensions Age Awards, and voted ‘No.1 UK Pension Administration Software Provider’ in 2022 and 2023.
Check out our locations here.
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.
- 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
- 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
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.
Procentia is an award-winning software and technology company specialising in the Pensions and Pension Risk Transfer market. We design intelligent solutions that put administrators and members at the heart of any pension scheme.
Established in 2002, we’re renowned for our leading web-based pensions administration and management system, IntelliPen. Our platform helps schemes meet the demand for self-serve technology and provide meaningful consumer-like experiences that their members expect from online financial platforms.
With offices in the UK and North America, we support some of the largest pension schemes and retirement plans across the private, public, and insurance sectors.
We've been Highly Commended for ‘Technology Innovation of the Year 2025’ at the UK Pensions Awards, named 'Pension Technology Firm of the Year 2024' at the Pensions Age Awards, and voted ‘No.1 UK Pension Administration Software Provider’ in 2022 and 2023.
Check out our locations here.
