Pensions Officer
Posted 1 hour 47 minutes ago by Scottish Government OGD Recruitment
Are you looking for an opportunity to apply your pensions expert with a background in technical management?
The Scottish Public Pensions Agency (SPPA) administers pensions for Scottish Teachers, Police, Firefighters' and National Health Service employees on behalf of the Scottish Government.
We're responsible for protecting the financial futures of over half a million people , that's around 1 in 10 people in Scotland.
If you're looking for meaningful work, a supportive environment and a career with purpose, you'll find it at the SPPA.
Our office is based in Tweedbank in the Scottish Borders, the train station is a short two minute walk away and offers regular services to and from Edinburgh Waverly, making it a convenient and well connected location for commuters.
The surrounding area offers access to green space, walking routes and a strong sense of local community, supporting wellbeing both in and outside of work.
Our modern office building is designed to support flexible and collaborative working, with spaces for teamwork, quiet focus and hybrid working. Colleagues benefit from a comfortable, welcoming environment that reflects our commitment to wellbeing and inclusion.
As a Pensions Officer within our Technical Services team, you will support with the design, build, test and maintenance of complex Excel-based calculation tools that underpin critical Police, Fire, NHS and Teachers public sector pensions, data and payroll processes. Working in a highly regulated environment, you will help ensure calculators are accurate, compliant, auditable, and version controlled. You will also contribute to an improvement roadmap, identifying innovative, automation-aligned solutions that will strengthen operational resilience. You will work with various technical experts and operational stakeholders to gather requirements, translate them into clear specifications, and deliver compliant, auditable and user-friendly calculators.
Responsibilities- Build and enhance complex Excel-based calculation tools using robust spreadsheet engineering practices (clear inputs/outputs, validation, error handling, and maintainable formula structures).
- Work closely with the specialist calculation lead, providing operational pensions expertise to support the ongoing development, refinement and compliance/assurance of excel-based user-friendly calculation tools.
- Identify opportunities to streamline and automate administrative processes through calculator development.
- Develop, execute and document appropriate testing, maintaining clear evidence of logic, assumptions, changes and outcomes to support quality assurance and audit readiness.
- Investigate issues raised by users, diagnose root causes, implement controlled fixes, and communicate impacts and mitigations clearly.
- Support structured release management so only approved, accurate versions of calculators are deployed and used
- Work closely with operational colleagues and Technical Services peers to translate requirements into usable calculation tools and to explain technical decisions in plain language.
- Contributes to an improvement roadmap, recommending standardisation and control enhancements to strengthen reliability and user experience.