Pensions Data Analyst (defined benefit)

My client is a leading financial services provider and due to growth in their Pension De-Risking team they currently seek an experienced Pensions Data Analyst with Defined Benefit or Bulk Purchase experience to join their friendly team.

This role sits at the heart of a fast-growing pensions risk transfer environment, offering exposure to complex data analysis, scheme onboarding, and regulatory-driven processes.

You will support the successful onboarding and transition of defined benefit pension schemes into BPA arrangements, working closely with operational leadership and stakeholders.

This is a highly technical role where you will analyse, reconcile, and validate complex pension datasets, ensuring accuracy and completeness prior to policyholder transfer.

• Analyse defined benefit pension datasets to assess quality, accuracy, and completeness
• Perform data reconciliation and validation across multiple datasets, including cleansed and transitioned data
• Review benefit specifications and ensure alignment with data and administration requirements
• Develop and maintain calculation models and spreadsheets covering areas such as pensions increases, revaluation, and payroll
• Support benefit calculation processes and technical adjustments within data analysis and reconciliation activity
• Track and document data changes, movements, and audit trails across the scheme onboarding lifecycle
• Test and reconcile parallel payroll runs and benefit calculations to ensure accuracy
• Identify data issues and implement solutions to improve data quality and prevent recurring errors
• Support adherence to regulatory, compliance, and governance standards within financial services
• Work collaboratively with stakeholders across operations, pensions administration, and technical teams

• Proven experience working with defined benefit pensions or BPA / pensions risk transfer environments
• Strong understanding of pension administration processes and benefit calculations
• Hands-on experience performing data analysis, reconciliation, and validation within pensions datasets
• Advanced Excel skills, including complex data manipulation
• High attention to detail with strong analytical and problem-solving capability
• Experience working within regulated, compliance-driven environments
• Strong communication skills and stakeholder engagement ability

In return my client offer a generous remuneration package, varied and interesting workload, excellent prospects for development and hybrid working.