Pensions Data Specialist

WTW; Manchester; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

A leading consultancy firm is seeking a Pensions Data Specialist in Manchester. This role focuses on delivering key pension data projects, performing complex calculations, and supporting scheme corrections. Ideal candidates have experience in pension project administration or calculations, strong Excel skills, and a passion for data. The position offers hybrid work flexibility and a comprehensive benefits package including health insurance, a pension scheme, and wellness perks.

Benefits

25 days annual leave plus an extra WTW day

Private healthcare

Life insurance

Group income protection

Employee assistance programme

Volunteer day

Electric vehicle car scheme

Cycle-to-work programme

Dental and optical cover

Critical illness protection

Qualifications

• Experience in DB pensions, ideally in data, calculations, or administration.
• Strong numerical and analytical skills.
• Good working knowledge of Excel.
• Familiarity with data audits or cleansing in a pension context is desirable.
• Effective written and verbal communication skills.
• Experience in pension project administration or coordination is beneficial.

Responsibilities

• Support delivery of pension projects and calculations.
• Perform data manipulation and validation with accuracy.
• Assist in data auditing and transformation work.
• Collaborate with project teams on multiple projects.
• Communicate clearly with project leads and stakeholders.

Skills

Numerical skills

Analytical skills

Problem-solving skills

Excel proficiency

Organizational skills

Communication skills

Tools

Excel

Job description

Overview

At WTW, we believe difference makes us stronger. We want our workforce to reflect the different and varied markets we operate in and to build a culture of inclusivity that makes colleagues feel welcome, valued and empowered to bring their whole selves to work every day. We are an equal opportunity employer committed to fostering an inclusive work environment throughout our organisation. We embrace all types of diversity.

Join WTW as a Pensions Data Specialist and be part of Pension Data Solutions.

Step into a role where your pension project administration, data, and/or calculation expertise truly makes an impact. As a Pensions Data Specialist at WTW, you’ll move beyond day‑to‑day admin and become a key contributor to large-scale, technical DB pension projects. If you enjoy problem‑solving, working with data, and seeing your work improve outcomes for thousands of members, this role is a perfect next step.

You’ll work hands‑on with complex pension data, perform bulk calculations, support scheme corrections, and help deliver projects that shape how pension schemes operate. From GMP exercises to benefit rectifications, no two days are the same. You’ll be part of a supportive team, learning from experienced specialists, while getting the chance to grow your technical, analytical, and project skills.

If you’re currently in pension project administration, pension analysis, or calculations and looking for a more dynamic, project-focused role with room to grow — this is your opportunity to take that next leap.

The Role

• Support the delivery of bulk calculation and data-driven pension projects for DB pension schemes.
• Carry out pension calculations, data manipulation, and validation activities with accuracy and attention to detail.
• Assist in data auditing, cleansing, and transformation work to support projects such as GMP rectification, benefit corrections, and scheme change exercises.
• Work with Excel-based pension models, including reviewing, updating, and modifying calculation templates.
• Collaborate with project teams of 3–6 people, managing delegated tasks and progressing work to agreed deadlines.
• Contribute to multiple projects at once (typically 3–5), each spanning 6–8 months.
• Support project planning, triage activities, tracking tasks, and preparing project documentation.
• Communicate clearly with project leads and stakeholders, raising risks or issues promptly.

Why apply this Role

• Opportunity to build technical pension expertise while developing project skills.
• Exposure to a variety of DB pension projects and calculation scenarios.
• Work closely with experienced colleagues and gain structured development.
• Hands-on involvement with pension data, bulk calculations, and real‑world project environments.

Office location: You can be based in any of our offices across London, Reigate, Bristol, Birmingham, Manchester, Leeds, or Edinburgh. This role follows a flexible hybrid model, with just one day per week working in your nearest office.

Our work style: At WTW, we trust you to know your work and the people, tools and environment you need to be successful. The majority of our colleagues work in a" hybrid" style, with a mix of remote, in-person and in-office interactions dependent on the needs of the team, role and clients. We understand flexibility is key to supporting an inclusive and diverse workforce and WTW offers flexible working opportunities and part-time working.

Qualifications

What you’ll bring

• Experience working in DB pensions, ideally in pension data, calculations, administration, or project-related roles.
• Strong numerical, analytical, and problem‑solving skills.
• Good working knowledge of Excel, including comfort with data manipulation and formula‑based models.
• Familiarity with bulk corrections, data audits, or data cleansing in a pension context is highly desirable.
• Strong organisational skills, with the ability to handle multiple tasks and deadlines.
• Effective communication skills, both written and verbal.
• Experience in any of the following is beneficial:
  • Pension project administration
  • Pension technical calculations
  • Pension data analysis
  • Pension project coordination or junior project management
• Candidates with an Actuarial background and experience in pension projects looking for pension data roles are also encouraged to apply.
• An interest in programming or tech‑enabled solutions is a plus (e.g., VBA, SQL, Python — not essential).

What we offer

Enjoy a benefits package designed to help you thrive, both professionally and personally. You'll receive 25 days of annual leave plus an extra WTW day to relax and recharge. Our comprehensive health and wellbeing offering includes private healthcare, life insurance, group income protection, and regular health assessments, all giving you peace of mind. Secure your future with our defined contribution pension scheme, featuring matched contributions up to 10% from the company.

We support your growth and balance with hybrid working options, access to an employee assistance programme, and a fully paid volunteer day to make a difference in your community. On top of these, you can opt into a variety of additional perks including an electric vehicle car scheme, share scheme, cycle-to-work programme, dental and optical cover, critical illness protection, and much more. Start making the most of your career and wellbeing with a range of benefits tailored for you.

Equal Opportunity Employer

We’re committed to equal employment opportunity and provide application, interview and workplace adjustments and accommodations to all applicants. If you foresee any barriers, from the application process through to joining WTW, please email [e-mail]