Pensions Officer
Role Overview
At the SPPA, we are committed to The Fair Work Framework
This means offering:
Security and stability
Flexible and hybrid working options
Opportunities to learn and develop
A respectful and inclusive working environment
At SPPA we want our workforce to be representative of Scottish society and we strive to be a workplace where people are welcomed and valued for the contribution they make.
We support flexible working and encourage applications from people from all backgrounds, including those starting their careers, changing careers, or returning to work.
We are committed to removing any barriers to applying for our jobs and aim to offer support and make reasonable adjustments to allow full participation in the recruitment process.
Our staff are part of the UK Civil Service observing the Civil Service Code and working for Ministers and senior stakeholders to deliver vital public services which improve the lives of the people of Scotland.
We offer a supportive and inclusive working environment along with a wide range of employee benefits. Find out more about what we offer.
As part of the UK Civil Service, we uphold the Civil Service Nationality Rules.
You can also find out more about careers at the SPPA here - SPPA Careers | SPPA (pensions.gov.scot )
Security checks Successful candidates must complete the Baseline Personnel Security Standard (BPSS), before they can be appointed. BPSS is comprised of four main pre-employment checks – Identity, Right to work, Employment History and a Criminal Record check (unspent convictions).You can find out more about BPSS on the UK Government website, and read about the Government Vetting Charter, or about all the different levels of security checks in our Candidate Guide. Internal candidates may need to gain higher security clearance than they currently hold if successful in their application. Working Pattern: Our standard hours are 35 hours per week. We offer a range of flexible and hybrid working options, with two days minimum working on site at SPPA. If you have specific questions about the role you are applying for, please contact us. Sponsorship: Skilled Worker sponsorship is not available for this role. As a result, we are unable to appoint candidates who require Skilled Worker sponsorship now or in the future. Applicants must have an existing and ongoing right to work in the UK. Equality statement We are committed to equality and inclusion and we aim to recruit a diverse workforce that reflects the population of our nation. Find out more about our commitment to diversity and how we offer and support recruitment adjustments for anyone who needs them. Further information Find out more about our organisation, what we offer staff members and how to apply on our Careers Website. Read our Candidate Guide for further information on our recruitment and application processes. We will hold a reserve list for this post for 12 months. Apply Before: 1 November 2026 (23:59) - This role is open to internal candidates, OGD and Common Citizenship organisations only
Full Job Posting
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.
- Data and Insight – Awareness
- Delivery and decision making at speed – Awareness
- Experience of working with colleagues to review, develop and maintain complex Excel-based calculation tools within a pension’s environment
- Managing a quality service – Level 2
- Working Together – Level 2
About us
At the SPPA, we are committed to The Fair Work Framework
This means offering:
Security and stability
Flexible and hybrid working options
Opportunities to learn and develop
A respectful and inclusive working environment
At SPPA we want our workforce to be representative of Scottish society and we strive to be a workplace where people are welcomed and valued for the contribution they make.
We support flexible working and encourage applications from people from all backgrounds, including those starting their careers, changing careers, or returning to work.
We are committed to removing any barriers to applying for our jobs and aim to offer support and make reasonable adjustments to allow full participation in the recruitment process.
Our staff are part of the UK Civil Service observing the Civil Service Code and working for Ministers and senior stakeholders to deliver vital public services which improve the lives of the people of Scotland.
We offer a supportive and inclusive working environment along with a wide range of employee benefits. Find out more about what we offer.
As part of the UK Civil Service, we uphold the Civil Service Nationality Rules.
You can also find out more about careers at the SPPA here - SPPA Careers | SPPA (pensions.gov.scot )
Security checks Successful candidates must complete the Baseline Personnel Security Standard (BPSS), before they can be appointed. BPSS is comprised of four main pre-employment checks – Identity, Right to work, Employment History and a Criminal Record check (unspent convictions).You can find out more about BPSS on the UK Government website, and read about the Government Vetting Charter, or about all the different levels of security checks in our Candidate Guide. Internal candidates may need to gain higher security clearance than they currently hold if successful in their application. Working Pattern: Our standard hours are 35 hours per week. We offer a range of flexible and hybrid working options, with two days minimum working on site at SPPA. If you have specific questions about the role you are applying for, please contact us. Sponsorship: Skilled Worker sponsorship is not available for this role. As a result, we are unable to appoint candidates who require Skilled Worker sponsorship now or in the future. Applicants must have an existing and ongoing right to work in the UK. Equality statement We are committed to equality and inclusion and we aim to recruit a diverse workforce that reflects the population of our nation. Find out more about our commitment to diversity and how we offer and support recruitment adjustments for anyone who needs them. Further information Find out more about our organisation, what we offer staff members and how to apply on our Careers Website. Read our Candidate Guide for further information on our recruitment and application processes. We will hold a reserve list for this post for 12 months. Apply Before: 1 November 2026 (23:59) - This role is open to internal candidates, OGD and Common Citizenship organisations only
Responsibilities
- Success profile Success profiles are specific to each job and they include the mix of behaviours, experience and technical criteria (if applicable) that candidates will be assessed on. Technical / Professional Skills:
- You can find out more about the skills required, here Experience
- Behaviours:
- Find out more about Success Profiles. How to apply Apply online, providing a CV and supporting statement (of no more than 750 words) providing evidence of how you meet the behaviours, experience and technical skills listed in the Success Profile above. Both the CV and the supporting statement provided will be assessed against the criteria for the role. Artificial Intelligence (AI) tools can be used to support your application, but all statements and examples provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, and presented as your own) applications will be withdrawn and internal candidates may be subject to disciplinary action.Please see our candidate guidance for more information on acceptable and unacceptable uses of AI in recruitment.If invited for further assessment, this will consist of an interview and job simulation excercise. Sifting will commence from 2 November 2026. Assessments are scheduled for w/c 16 November 2026 however this may be subject to change. If invited for further assessment, this will consist of an in-person interview and job simulation assessment at the SPPA office in Tweedbank. Recruitment Principles As a government organisation, we adhere to the Civil Service Commission Recruitment Principles and we investigate any complaints received in relation to recruitment cases.
Qualifications
- Security and stability
- Flexible and hybrid working options
- Opportunities to learn and develop
- A respectful and inclusive working environment
About Scottish Government
Scotland’s devolved government develops policy and delivers public services for people across Scotland.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Scottish Government
Transition Policy and Energy Security - Resilience and Preparedness
Glasgow, GBR
Senior Civil Engineer - Contracts Advisor
Glasgow, GBR
Transition Policy and Energy Security - Resilience and Preparedness
Glasgow, GBR
Senior Finance Business Partner
Glasgow, GBR
Senior Compliance and Assurance Manager
, GBR
Development Management Manager
Glasgow, GBR
Technical Delivery Manager
Glasgow, GBR
Development Management Manager
Glasgow, GBR
Technical Delivery Manager
Glasgow, GBR