About us

Procentia is an award-winning software and technology company specialising in the Pensions and Bulk Purchase Annuities 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 web-based pensions administration and management system, IntelliPen. Our platform helps clients meet the demand for self-serve technology and provide meaningful consumer-like experiences expected from online platforms.

Trusted by administrators, employers and trustees, our software is widely regarded as the most comprehensive and feature-rich platform for modern pensions management.

IntelliPen comprises a suite of integrated modular systems that streamline processes from new member registration to online self-serve retirement, and enables collaboration on the same workflows. It delivers up to 90% time and cost efficiencies by automating member retirements, validation, benefit calculations, reporting and pensioner payroll.

With offices in the UK and North America, we support some of the largest pension schemes and plans across the private and public sectors.

We've been 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.

Procentia People are a community of passionate specialists dedicated to developing best-in-class software solutions and client service. We’re a vibrant assortment, everyone is welcome here.

We’re proud of our welcoming and open culture, and our Values. They’re not just words on paper – we’re dedicated to living them every day

The job: 

As part of our continuing growth we are seeking to recruit an Implementation Consultant with Data Migration experience in to Procentia.
The purpose of this role is lead the planning and movement of data from clients legacy
systems to our IntelliPen suite of products. This will involve designing data mapping and
transformation logic, developing automated migration scripts, and validating the integrity of the migrated data.

Here's what you'll be doing:

To be successful, you should be proficient in the use of T-SQL, XML and able to work well as part of a team.
Ultimately, demonstrating strong knowledge and experience in their area, sound technical knowledge as well as exceptional analytical, communication, and customer service skills.
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.

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 

Adaptable and agile 

Be a responsible and reliable professional, with a consultative approach

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

· And many more..