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, IntelliPen 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.

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.

As part of working in the Client Success Delivery Team, you are expected to liaise with our clients to gather their requirements, produce specifications and configure the functionality requested. There may be an occasional need to travel to clients’ sites to do this.

You will manage a diverse workload including multiple parallel tasks and you will prioritise your time and tasks effectively alongside the demands set on the team.

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
• An understanding of business processes and workflows

• Ability to learn new technologies quickly

• The ability to prioritise, meet deadlines and deliver rapid outcomes
• Confidence to adapt and learn new programmes and systems

• Excellent verbal, written communication and organisational skills

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