Procentia
Implementation Consultant - Data Migration
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Let's 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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London