Skip to main content
Ref no:
Flexible across Scotland, G40 4EH
£40,606 - £45,380 per year
Contract Type:
Position Type:
Full Time
35 hours per week

This position has expired.


To design, develop, programme, administer, support and maintain business intelligence systems, providing data integration services through the development and implementation of an integrated data architecture, in accordance with agree standards and to assist in providing a strategic coordination of these technologies within the general ICT environment across Police Scotland and the SPA.


You will have proven and demonstrable experience in the design, development, testing, publishing, and maintenance of BI semantic datasets, Dashboard visualization and reporting using the Microsoft Business Intelligence platform. And must have experience of or knowledge in most of the following components:

o  Power BI Dashboard visualization.

o  SQL Server Analysis Services (SSAS) Tabular Modelling.

o  SQL Server Reporting Services (SSRS).

o  Report Builder (paginated reports).

o  SQL Server Management Studio (SSMS).

o  SQL Server 2016 or above.

o  Power BI Report Server.


You will have knowledge and experience of Business Intelligence principles and practices; knowledge of the development and administration of Business Intelligence / Corporate Reporting systems design and implementation; knowledge of Extract/Transform/Load (ETL) solutions for Business Intelligence; and knowledge of relational database concepts, including a good working knowledge of SQL.


You will have experience of installing and configuring corporate reporting systems and troubleshooting, performance monitoring, tuning and script development in a business intelligence environment and experience designing, developing, and testing business intelligence solutions.


You will be educated to degree in related computer science. Or a Software engineering Discipline.

You will have excellent interpersonal, communication, analytical and problem solving skills and strong prioritisation and organisational skills, customer focused.

You will have the ability to work on your own initiative with limited supervision and to work under pressure as part of a team; and proven skills related to team-working and working with customers to elicit and define requirement specifications.

You will have strong analytical skills; excellent communication skills, both written and verbal; the ability to use your own initiative and deal with a varied programme of work; and be capable of communicating effectively with both a Technical and non-Technical audiences.

This full time post is permanent and will require Management Level Vetting. You will work 35 hours per week, Monday-Friday, 0900 – 1700.

The following competencies at level 2 will be used for the selection process:

We are emotionally aware

We take ownership

We are collaborative

We deliver, support and inspire

We analyse critically

We are innovative and open minded



- Competitive salary and guaranteed allowances

- Annual salary increments

- Local Government Pension Scheme

- 28 days annual leave and 6 public holidays on appointment

- Wide range of family friendly policies

- Employee Assistance Programme

- Access to range of staff associations

- Scottish Police Recreation Association

- Scottish Police Credit Union 

- Cycle to Work Scheme



The Scottish Police Authority / Police Scotland is committed to positive action in the recruitment and selection of people with disabilities. We guarantee an interview to any applicant who has a disability, as defined under the Equality Act 2010, and who meets the essential criteria for the post. Please regard this as an opportunity to let us help you. Tell us of any aspects which could present difficulties and any suggestions for overcoming these.



Applicants must be a British citizen, a member of the EU or other states in the EEA, a Commonwealth citizen or a foreign national free of restrictions. You should also have been resident in the UK for a minimum of five years immediately prior to application.



Please visit the Police Scotland Career Site for Job Reference Number – 1076