Develop and maintain advanced spreadsheet-based pension calculators, ensuring accuracy, efficiency, and auditability.
Apply knowledge of UK/Scottish pensions legislation and Remedy regulations to ensure calculators are correct and compliant.
Document calculation methodologies and tool structures to support knowledge transfer and long-term sustainability.
Work collaboratively with actuaries, policy colleagues, administrators, and external advisers (e.g., GAD).
Support validation, testing, and assurance of calculations to minimise error and reduce audit/legal risks.
Provide technical advice and guidance to colleagues, acting as an internal expert resource.
Contribute to programme MI and reporting through accurate calculation outputs and analysis.
Ensure calculators are adaptable to future scheme or legislative changes.

Requirements

Fellow of the Institute and Faculty of Actuaries (IFoA) or equivalent actuarial professional body (Essential).
Proven ability to design and deliver complex pension or financial models.
Expert-level Microsoft Excel skills (including advanced formulae, VBA, and modelling best practice).
Experience of UK or Scottish public service pension schemes and regulatory frameworks.
Experience working with actuarial calculations, pensions policy, or financial modelling.
Managing a Quality Service - Level 4
Delivering at Pace - Level 4
Changing and Improving - Level 4
Making Effective Decisions - Level 4.

Benefits

Flexible working hours

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

advanced spreadsheet-based pension calculatorsUK pensions legislationScottish pensions legislationRemedy regulationscalculation methodologiesactuarial calculationsfinancial modellingMicrosoft ExcelVBAmodelling best practice

Soft Skills

collaborationtechnical adviceknowledge transfervalidationtestingassuranceerror minimizationaudit risk reductiondecision makingservice management

Certifications

Fellow of the Institute and Faculty of Actuaries (IFoA)