Implementation Consultant - Data Migration

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.

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.

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.