Job Description

Pensions Administration Systems - Scheme Transitions & Data Specialist

The Scheme Transitions & Data Specialist plays a central role in onboarding new pension schemes, transitioning schemes leaving the platform, and supporting buy-ins and buyouts. The role combines technical data skills, pensions knowledge, and hands on configuration of administration systems.

You will work closely with transition managers, administrators, actuaries, and clients to understand benefit structures, interpret data, code transformations, and ensure a smooth and accurate transition of member data and services. This role is ideal for someone who enjoys working with data, solving problems, and translating complex pension requirements into robust system configurations.

The ideal candidate will be based in our Belfast, Birmingham, Bristol, Croydon, Manchester or Reading city centre office with a hybrid workstyle. Edinburgh, Glasgow and Leeds offices may be considered for the right candidate.

What does the role entail?

Scheme Transitions & Data Migration

• Lead or support the migration of member data for new scheme implementations, scheme exits, buy-ins, and buyouts.

• Analyse, cleanse, and transform incoming data using SQL/SSMS and other internal tools into our pensions admin systems.

• Interpret benefit specifications and translate them into system configuration requirements.

• Produce and validate data extracts for schemes transitioning away from the platform.

System Configuration & Scheme Setup

• Set up integrated services as required including:

• Reporting and MI

• Standard and bespoke member letters

• Member website configuration

• Payroll setup and validation

• Workflow and case management alignment

Quality Assurance & Testing

• Identify data anomalies, inconsistencies, and gaps, and work with stakeholders to resolve them.

• Validate outputs against benefit specifications, payroll gross to net reports, actuarial data, member prints, and client expectations.

• Ensure all work is documented, tested, and peer reviewed.

Collaboration & Communication

• Work closely with transition leads, administrators, actuaries, third party providers, and clients to clarify requirements, resolve data queries, and provide updates.

• Communicate technical issues clearly to non-technical audiences.‑technical audiences.

• Support knowledge transfer to administration teams post transition.

• Contribute to continuous improvement of transition processes, templates, and tools.

What we're looking for

Essential

• Strong SQL/SSMS skills, including scripting, data manipulation, and troubleshooting.

• Solid understanding of DB pension schemes (Trust based), including benefits, data items, and calculation concepts.

• Experience working with pensions administration systems and/or payroll systems.

• Ability to interpret benefit specifications and translate them into system rules.

• Experience with data mapping, migration, or transformation.

• Strong analytical and problem-solving skills.

• Ability to work independently, manage workload, and maintain structured documentation.

• Clear communication skills across technical and non‑technical audiences.

Desirable

• Experience with DC schemes.

• Familiarity with XML and relational databases.

• Understanding of scheme integrations (letters, workflows, payroll, reporting).

• Experience with buy-in/buyout data requirements.

• Exposure to pensions projects such as GMP Equalisation or Pensions Dashboard.

What you can expect in return

• A competitive salary and market leading bonus scheme with stretch targets for high performance

• Study support to help you achieve professional qualifications, with salary increases for exam passes

• Development and training opportunities to support your career ambitions throughout your time with us

• A friendly, and supportive team who will help you to deliver your best work

You can find out more about us and the benefits we offer on our careers website Isio – Careers & Benefits

What’s next?

Click on the ‘apply’ and follow the simple application process on-line.

At Isio, we are committed to fostering an inclusive, equitable and diverse workplace, in which our colleagues feel they belong, regardless of background or difference. We uphold the values of respect, fairness, and inclusion in our actions and decisions. We believe that by adhering to these principles, we will create a stronger, more innovative, and supportive environment for all, as well as ensuring that the advice and support we provide to our clients is more creative, more insightful and leaves a lasting impact.

We have offices across the UK and many of our roles offer a hybrid, flexible approach to work to help create a work-life balance that works for you. Isio Group is an equal opportunities employer and we welcome applications from all suitably qualified candidates. If you think you may require a reasonable adjustment to be made for any reason at any stage of your recruitment process, please ask us hrrecruitment@isio.com