At a Glance
- Tasks: Lead data migration for pension schemes and ensure smooth transitions.
- Company: Join a supportive team at Isio, a leader in pensions administration.
- Benefits: Competitive salary, bonuses, study support, and career development opportunities.
- Why this job: Make a real impact by solving complex data challenges in pensions.
- Qualifications: Strong SQL skills and understanding of DB pension schemes required.
- Other info: Hybrid workstyle with opportunities for professional growth.
The predicted salary is between 36000 - 60000 £ per year.
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 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 Responsibilities
- 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
- 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.
- 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.
- Support knowledge transfer to administration teams post transition.
- Contribute to continuous improvement of transition processes, templates, and tools.
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.
Benefits
- 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.
Isio is committed to fostering an inclusive, equitable and diverse workplace in which 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.
Pensions Admin Systems Specialist in Reading employer: Isio
Contact Detail:
Isio Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Pensions Admin Systems Specialist in Reading
✨Tip Number 1
Network like a pro! Reach out to people in the pensions industry, especially those who work with data and systems. Attend events or webinars, and don’t be shy about asking for informational chats – you never know where a conversation might lead!
✨Tip Number 2
Show off your SQL skills! If you’ve got experience with SQL/SSMS, make sure to highlight that in conversations. Maybe even prepare a few examples of how you've used it to solve problems or improve processes in past roles.
✨Tip Number 3
Get familiar with our company culture! Check out our careers website to understand what we value at Isio. Tailor your conversations to reflect how your skills and experiences align with our mission and values – it’ll make you stand out!
✨Tip Number 4
Follow up after interviews! A quick thank-you email can go a long way. Mention something specific from your chat that excited you about the role or the team – it shows you’re genuinely interested and engaged.
We think you need these skills to ace Pensions Admin Systems Specialist in Reading
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Pensions Admin Systems Specialist role. Highlight your SQL skills, experience with pensions administration systems, and any relevant projects you've worked on. We want to see how your background fits with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about pensions and data. Share specific examples of how you've solved problems in previous roles, and let us know why you want to join our team at StudySmarter.
Show Off Your Analytical Skills: Since this role involves a lot of data analysis, make sure to showcase your analytical and problem-solving skills in your application. Mention any tools or methodologies you’ve used to interpret data and resolve issues, as this will resonate with us.
Apply Through Our Website: We encourage you to apply through our careers website. It’s the best way to ensure your application gets to the right people. Plus, you can find more info about us and the benefits we offer while you're there!
How to prepare for a job interview at Isio
✨Know Your SQL Inside Out
Make sure you brush up on your SQL and SSMS skills before the interview. Be prepared to discuss how you've used these tools in past roles, especially in data manipulation and troubleshooting. They might even throw a technical question your way, so practice some common SQL queries!
✨Understand Pension Schemes Thoroughly
Familiarise yourself with defined benefit pension schemes and their intricacies. Be ready to explain how you interpret benefit specifications and translate them into system configurations. Showing that you can connect the dots between technical requirements and pension knowledge will impress the interviewers.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled data anomalies or inconsistencies in previous roles. Highlight your analytical skills and how you collaborated with stakeholders to resolve issues. This will demonstrate your ability to handle the challenges that come with transitioning member data.
✨Communicate Clearly and Confidently
Practice explaining complex technical concepts in simple terms. You’ll likely need to communicate with both technical and non-technical audiences, so being able to bridge that gap is crucial. Consider role-playing with a friend to refine your communication style before the big day.