Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform data into insights and support performance reporting for key public services.
- Company: Join the Scottish Public Pensions Agency, a vital part of the Scottish Government.
- Benefits: Flexible working options, supportive environment, and a chance to impact over 640,000 key workers.
- Other info: Great career growth opportunities in a diverse and inclusive workplace.
- Why this job: Make a real difference in public service by leveraging data for better decision-making.
- Qualifications: Experience with Excel and awareness of BI tools like Power BI or Tableau.
The predicted salary is between 28000 - 35000 £ per year.
Looking to make an impact? Join our Performance and Planning Team as a Business Intelligence Assistant and turn data into actionable insights.
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.
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 profile
Success profiles are specific to each job and they include the mix of skills, experience and behaviours candidates will be assessed on.
Technical / Professional Skills:
- Connections and communication - Working
- Data and insight - Working
- Delivery and decision making as speed - Working
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
How to apply
Apply 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.
Apply Before: 24 May 2026 (23.59) - This role is open to internal candidates and Common Citizenship organisations only.
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.
If invited for further assessment, this will consist of an interview and job simulation. Sifting will commence from w/c 25 May 2026. Assessments are scheduled for w/c 8th June 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.
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
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 640,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 £3.7 billion.
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.
As part of the UK Civil Service, we uphold the 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.
Business Intelligence Assistant employer: Scottish Government
Contact Detail:
Scottish Government Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Assistant
✨Tip Number 1
Get to know the company! Research the Scottish Public Pensions Agency and understand their mission. This will help you tailor your conversations during interviews and show that you're genuinely interested in making an impact.
✨Tip Number 2
Practice your data storytelling skills. As a Business Intelligence Assistant, you'll need to present insights clearly. Use mock interviews with friends or family to hone your ability to explain complex data in simple terms.
✨Tip Number 3
Network like a pro! Connect with current employees on LinkedIn or attend industry events. Building relationships can give you insider info about the role and even lead to referrals.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re serious about joining the team at SPPA.
We think you need these skills to ace Business Intelligence Assistant
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Business Intelligence Assistant role. Highlight your experience with data tools like Excel and Power BI, and showcase how you've turned data into actionable insights in previous roles.
Craft a Strong Supporting Statement: Your supporting statement is your chance to shine! Use it to provide specific examples of how you meet the skills and behaviours outlined in the job description. Keep it concise and focused, sticking to the 750-word limit.
Showcase Your Communication Skills: Since this role involves engaging with various stakeholders, emphasise your communication skills. Share examples of how you've effectively communicated technical information to non-technical audiences in the past.
Apply Through Our Website: Don't forget to apply through our website! It’s the best way to ensure your application gets to us directly. Plus, you'll find all the details you need about the role and our organisation there.
How to prepare for a job interview at Scottish Government
✨Know Your Data Tools
Familiarise yourself with Microsoft Excel, Power Query, and any Business Intelligence tools like Power BI or Tableau. Be ready to discuss how you've used these tools in past roles to solve data challenges, as this will show your technical prowess.
✨Understand Stakeholder Needs
Before the interview, think about how you would engage with various stakeholders. Prepare examples of how you've gathered requirements and communicated complex data insights to non-technical audiences. This will demonstrate your ability to connect and communicate effectively.
✨Prepare for Performance Reporting
Brush up on how to produce and maintain performance reports. Be ready to talk about your experience in creating reporting packs and how you ensure accuracy and clarity in your reports. This is crucial for the role, so make it a focal point in your prep.
✨Showcase Continuous Improvement Mindset
Think of instances where you've identified opportunities for improvement through data analysis. Be prepared to share specific examples that highlight your analytical skills and your proactive approach to enhancing processes within an organisation.