Pensions Calculations SME
Location: Remote
Contract Length: 6 months
IR35 Status: Inside IR35
Job Overview
We are seeking an experienced Pensions Calculations SME to support a key pensions project. This role requires strong expertise in pension benefit calculations, drafting calculation pro formas, scheme rule interpretation, and both manual and automated testing.
The successful candidate will have a strong background in pensions administration or consulting, with excellent Excel skills and proven experience delivering accurate calculations within complex pension environments.
Key Responsibilities
- Draft and review pension calculation pro formas.
- Perform both manual and automated calculation testing.
- Interpret scheme rules and benefit specifications (Ben spec).
- Validate pension calculations for accuracy and compliance.
- Support delivery of pensions projects involving member calculations.
- Analyse complex pension data using Excel.
- Work closely with project teams, analysts, and stakeholders.
Required Skills & Experience
- Strong experience in Defined Benefit (DB) pensions calculations.
- Proven knowledge of:
- Deferred calculations
- Retirement calculations
- Transfer value calculations
- Death benefit calculations
- Other specific pension calculation types
- Strong understanding of scheme rules and benefit specifications.
- Advanced Excel skills including:
- Complex formulas
- VLOOKUPs
- Pivot tables
- Experience in calculation testing and quality assurance.
- Excellent analytical and problem-solving skills.
Preferred Background
Candidates from the following sectors are highly desirable:
- Pensions Administration
- Pension Consulting
- Financial Services/Insurance
- In-house Pension Schemes
Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.