Pensions Data Specialist

WTW group; Birmingham; Hybrid; GBP 60,000 - GBP 80,000; Full time

Job summary

A leading benefits consultancy in the UK is looking for a Pensions Data Specialist to support DB pension projects through calculations and data management. The role requires strong analytical and numerical skills, with hands-on experience in Excel and exposure to project management. Ideal candidates are organized, effective communicators, and may have an actuarial background. The position offers a hybrid work model and a comprehensive benefits package including health care, wellness programs, and a pension scheme.

Benefits

25 days of annual leave

Private healthcare

Defined contribution pension scheme

Electric vehicle car scheme

Cycle-to-work programme

Qualifications

• Experience in pension project administration, calculations, or data analysis.
• Strong working knowledge of Excel for data manipulation.
• Familiarity with data auditing or cleansing is highly desirable.

Responsibilities

• Support delivery of bulk calculation and data-driven pension projects.
• Carry out accurate pension calculations and operations.
• Assist in data cleansing and transformation for projects.

Skills

Strong numerical skills

Analytical skills

Problem-solving skills

Effective communication

Organizational skills

Education

Experience in DB pensions

Actuarial background

Tools

Excel

VBA

SQL

Python

Job description

Description

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.

This is hybrid role which can be based out of our London, Reigate, Bristol, Birmingham, Manchester, Leeds or Edinburgh 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]