Pensions Data Specialist

Willis Towers Watson; Leeds; Hybrid; GBP 30,000 - 45,000; Full time

Job summary

A leading global advisory firm is seeking a Pensions Data Specialist in Leeds. This role involves supporting bulk calculations and data-driven pension projects for DB schemes. Candidates need experience in DB pensions, strong analytical skills, and proficiency in Excel. The position offers a hybrid work model and a comprehensive benefits package including health care, leave, and personal development opportunities. This role is ideal for those looking to enhance their technical and project skills in a dynamic environment.

Benefits

25 days annual leave plus a bonus day

Private healthcare

Life insurance

Employee assistance programme

Cycle-to-work programme

Qualifications

• Experience working in DB pensions, ideally in pension data or calculations.
• Strong numerical, analytical, and problem-solving skills required.
• Good knowledge of Excel for data manipulation and modeling.

Responsibilities

• Support delivery of bulk calculation and data-driven pension projects.
• Carry out pension calculations and data manipulation tasks.
• Assist with data auditing, cleansing, and transformation work.

Skills

Pension project administration

Excel data manipulation

Analytical skills

Problem-solving

Organisational skills

Job 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.

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]