Business Intelligence Assistant

Looking to make an impact? Join our Performance and Planning Team as an Business Intelligence Assistant and turn data into actionable insights. 

The Scottish Public Pensions Agency (SPPA) is an Agency of the Scottish Government.  Our principal role is to administer the pensions for employees in the National Health Service, Teachers’, Police and Fire-fighters’ pension schemes in Scotland. The Agency administers these public service pension schemes on behalf of Scottish Ministers with an annual pension spend to over 200,000 pensioners of more than £2.5 billion.

You will report to the Performance Analyst, providing support with development and maintenance of performance reports and data gathering to ensure the SPPA delivers clear and concise insights in a timely manner. 

Responsibilities

• Support the Performance Analysts with performance reporting including the production of the daily, weekly and monthly MI reports, preparing reporting packs for Senior Management and the Pension Boards, understanding stakeholder needs and executing data requests.
• Logging and analysing recommendations and good practice from a range of information. Assist Performance Analysts with the implementation of the data management strategy using expertise and knowledge to make recommendations to ensure best practices are implemented while maintaining data security.
• Prepare analysis of the outcomes from reviews drawing out themes, messages and conclusions.  
• Support effective engagement with a range of stakeholders, developing agendas and notes, analysing evidence to support discussion and presenting findings from Continuous Improvement work.  Engage with stakeholders across the organisation to gather and understand requirements to identify opportunities to deliver value by leveraging data while managing expectations and communicating technical information to non-technical stakeholders.
• Providing operational Management Information to facilitate internal discussions to identify recommendations for future improvement priorities.
• Responsible for producing, updating and maintaining reports to a high standard to ensure accuracy and aid decision making across the agency at all levels including the Executive Team.
• Undertake the analysis of data to identify solutions to problems and decide the best format or implementation for stakeholders needs, escalating more complex queries where required.

Success profileSuccess profiles are specific to each job and they include the mix of skills, experience and behaviours candidates will be assessed on. Technical / Professional Skills:

1. Connections and communication - Working
2. Data and insight - Working
3. Delivery and decision making as speed - Working

You can find out more about the skills required, here. Experience:

• Demonstrated experience working with tools including Microsoft Excel / Power Query with the ability to create solutions for common data challenges. 
• Awareness of Business Intelligence tools such as Power BI and Tableau

Behaviours:

• Seeing the bigger picture - Level 2
• Managing a quality service - Level 2
• Developing Self and Others - Level 2

You can find out more about Success Profiles here: Success profiles: candidate guide - gov.scot
 How to applyApply online, providing a CV and Supporting Statement of no more than 750 words which provides evidence of how you meet the skills, experience and behaviours listed in the Success Profile above. 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.  Assessments are scheduled for 23rd February 2026  however this may be subject to change. 

Interview and assessment are expected to take place in person on site at SPPA, 7 Tweedside Park, Tweedbank, Galashiels, TD1 3TE.

About us

The Scottish Public Pensions Agency is an Agency of the Scottish Government. Our principal role is to administer the pensions for employees in the National Health Service, Teachers’, Police and Fire-fighters’ pension schemes in Scotland for over 500,000 key workers. The Agency administers these public service pension schemes on behalf of Scottish Ministers with an annual pension spend to over 200,000 pensioners to the value of more than £2.5 billion.

SPPA Careers | SPPA (pensions.gov.scot) 

Civil Service Nationality Rules 

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.

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, or read about the different levels of security checks in our Candidate Guide. 

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: 15th February 2026 (23.59) - This role is open to internal candidates and Common Citizenship organisations only.