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.
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.
Why Join Isio
Isio is a fast-growing professional services business, that offers career development through an evolving client base, diverse and meaningful work, nationwide opportunities, and a culture that rewards high performance and accountability.
We hold ourselves to the highest standards and our values guide how we advise our clients, how we operate as a business and how we work together as a team. We call it the Isio Attitude. We encourage our people to be bold, to communicate with conviction, and to deliver advice that matters.
Here, growth brings opportunity - more responsibility, more clients, and work that stretches and develops you. We invest in training and development so you can expand your skills and explore different career paths across diverse markets to make your mark. Isio is a place to realise your potential and build a career with impact. You can find out more about Isio and the benefits we offer on our career’s website
About Isio
A progressive advisory firm, partnering with clients of all sizes to deliver expertise in pensions, employee benefits and wealth advisory services.
Working with pension trustees, employers, individuals, families and their offices, we are supported by talented colleagues across 10 UK offices. With a Big 4 heritage we combine a strong focus on quality with a fresh perspective challenging traditional thinking.
Our culture shapes our work; we foster a supportive environment where we develop our people to grow and fulfil their potential. We invest in our services, products and technology, and provide clear, expert solutions for our clients. This brings clarity, confidence, and better outcomes for everyone.
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 can offer a hybrid, flexible approach to work, supporting 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.