Pensions Officer

Scottish Government OGD Recruitment; Galashiels; Híbrido; GBP 35.000 - 52.000; Jornada completa

Descripción de la vacante

The Scottish Public Pensions Agency (SPPA) is seeking a Pensions Officer within our Technical Services team to design, build, test and maintain complex Excel-based calculation tools that underpin pensions, data and payroll processes. Working in a highly regulated environment, you will ensure calculators are accurate, auditable and version controlled.

You will gather requirements from technical experts and operational stakeholders, translate them into clear specifications, and deliver compliant,

Formación

• Proven pensions expertise within a regulated public sector environment.
• Experience building and maintaining complex Excel-based calculators.
• Ability to gather and translate requirements from technical and operational stakeholders.
• Ability to work in a regulated, auditable, version-controlled context.

Responsabilidades

• Build and maintain complex Excel-based calculation tools with robust design and validation.
• Collaborate with calculation lead to ensure compliance and auditability of tools.
• Identify opportunities to streamline processes through calculator development and automation.
• Plan and execute testing with clear evidence of logic and changes for QA and audits.
• Diagnose issues, implement fixes and communicate impacts clearly.
• Support release management to deploy approved calculator versions only.
• Translate requirements into usable tools and explain technical decisions in plain language.
• Contribute to an improvement roadmap for standardisation and reliability.

Conocimientos

Pensions expertise

Excel

Analytical thinking

Requirements gathering

Testing & QA

Herramientas

Excel (advanced)

Descripción del empleo

Job description

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.