Period
to

The following table provides summary statistics for permanent job vacancies advertised in Scotland with a requirement for Business Intelligence skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Business Intelligence over the 6 months to 16 August 2022 with a comparison to the same period in the previous 2 years.

Business Intelligence (BI)
UK > Scotland
6 months to
16 Aug 2022
Same period 2021 Same period 2020
Rank 74 51 47
Rank change year-on-year -23 -4 -14
Permanent jobs citing Business Intelligence 218 219 96
As % of all permanent jobs advertised in Scotland 3.84% 5.03% 4.72%
As % of the Processes & Methodologies category 4.21% 5.51% 5.15%
Number of salaries quoted 151 163 70
10th Percentile £31,569 £32,500 £35,000
25th Percentile £37,750 £38,750 £37,500
Median annual salary (50th Percentile) £50,000 £45,000 £44,500
Median % change year-on-year +11.11% +1.12% -1.11%
75th Percentile £67,500 £53,438 £57,188
90th Percentile £80,000 £63,750 £61,375
UK median annual salary £57,500 £55,000 £55,000
% change year-on-year +4.55% - +10.00%

Business Intelligence is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Scotland with a requirement for process or methodology skills.

All Process and Methodology Skills
Scotland
Permanent vacancies with a requirement for process or methodology skills 5,183 3,977 1,864
As % of all permanent IT jobs advertised in Scotland 91.27% 91.36% 91.55%
Number of salaries quoted 2,947 2,562 1,218
10th Percentile £32,690 £31,250 £31,250
25th Percentile £41,250 £37,500 £37,500
Median annual salary (50th Percentile) £55,000 £50,000 £47,500
Median % change year-on-year +10.00% +5.26% +5.56%
75th Percentile £70,767 £62,500 £58,750
90th Percentile £83,770 £77,500 £70,000
UK median annual salary £60,000 £55,750 £55,000
% change year-on-year +7.62% +1.36% +4.76%

Business Intelligence
Job Vacancy Trend in Scotland

Job postings citing Business Intelligence as a proportion of all IT jobs advertised in Scotland.

Job vacancy trend for Business Intelligence in Scotland

Business Intelligence
Salary Trend in Scotland

3-month moving average salary quoted in jobs citing Business Intelligence in Scotland.

Salary trend for Business Intelligence in Scotland

Business Intelligence
Salary Histogram in Scotland

Salary distribution for jobs citing Business Intelligence in Scotland over the 6 months to 16 August 2022.

Salary histogram for Business Intelligence in Scotland

Business Intelligence
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Business Intelligence within the Scotland region over the 6 months to 16 August 2022. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Jobs
Edinburgh -23 84 £49,750 +3.56% 9
Glasgow -25 75 £50,000 +11.11% 11
Aberdeen +22 28 £80,000 +79.07% 2
Moray - 14 - -
Fife - 6 £42,500 - 1
East Lothian - 2 - -
Dundee +23 1 £34,415 -8.23% 2
West Lothian -9 1 £100,000 +158.06% 1
Inverclyde - 1 £32,500 -
Business Intelligence
UK

For the 6 months to 16 August 2022, IT jobs citing Business Intelligence also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Scotland region with a requirement for Business Intelligence.

1 129 (59.17%) Power Platform
2 127 (58.26%) Power BI
3 113 (51.83%) SQL
4 110 (50.46%) Analytics
5 99 (45.41%) Social Skills
6 73 (33.49%) Agile
7 64 (29.36%) Microsoft
7 64 (29.36%) Problem-Solving
8 60 (27.52%) Tableau
9 56 (25.69%) Python
10 55 (25.23%) Finance
10 55 (25.23%) Analytical Skills
11 51 (23.39%) Azure
12 50 (22.94%) Visualisation
13 48 (22.02%) Degree
14 46 (21.10%) Data Modelling
15 45 (20.64%) SQL Server
16 42 (19.27%) Data Analytics
17 41 (18.81%) Data Warehouse
18 40 (18.35%) DevOps
19 37 (16.97%) Mentoring
19 37 (16.97%) Marketing
20 36 (16.51%) Management Information System
20 36 (16.51%) ETL
21 35 (16.06%) R
22 33 (15.14%) Oracle
23 32 (14.68%) Microsoft Excel
23 32 (14.68%) Data Science
23 32 (14.68%) Presentation Skills
24 31 (14.22%) Big Data

Business Intelligence
Co-occurring IT Skills in Scotland by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 22 (10.09%) SAS
2 18 (8.26%) SharePoint
3 17 (7.80%) Apache Spark
4 4 (1.83%) Oracle Workflow
5 3 (1.38%) Confluence
6 2 (0.92%) IIS
6 2 (0.92%) Jupyter
Applications
1 32 (14.68%) Microsoft Excel
2 15 (6.88%) Microsoft PowerPoint
3 12 (5.50%) MS Visio
4 10 (4.59%) Microsoft Office
5 4 (1.83%) Microsoft Project
Business Applications
1 17 (7.80%) Oracle EBS
2 7 (3.21%) Oracle ERP
3 4 (1.83%) Oracle EBS R12
4 2 (0.92%) NetSuite
5 1 (0.46%) Dynamics CRM
5 1 (0.46%) Dynamics NAV
Cloud Services
1 129 (59.17%) Power Platform
2 51 (23.39%) Azure
3 18 (8.26%) GCP
4 15 (6.88%) AWS
4 15 (6.88%) Azure DevOps
5 14 (6.42%) Microsoft 365
6 12 (5.50%) SaaS
7 11 (5.05%) Oracle CX
7 11 (5.05%) PaaS
8 6 (2.75%) Azure Data Factory
8 6 (2.75%) Google Analytics
9 5 (2.29%) Azure Synapse Analytics
10 4 (1.83%) Dynamics 365
11 2 (0.92%) Adobe Analytics
11 2 (0.92%) Azure Active Directory
11 2 (0.92%) IaaS
11 2 (0.92%) Power Automate
12 1 (0.46%) Amazon CloudWatch
12 1 (0.46%) Amazon EMR
12 1 (0.46%) AWS Step Functions
Communications & Networking
1 7 (3.21%) Internet
2 1 (0.46%) DHCP
2 1 (0.46%) DNS
2 1 (0.46%) VPN
Database & Business Intelligence
1 127 (58.26%) Power BI
2 60 (27.52%) Tableau
3 45 (20.64%) SQL Server
4 41 (18.81%) Data Warehouse
5 31 (14.22%) Big Data
6 24 (11.01%) Relational Database
6 24 (11.01%) SQL Server Reporting Services
7 23 (10.55%) Data Lake
8 18 (8.26%) SQL Server Integration Services
9 15 (6.88%) Elasticsearch
9 15 (6.88%) NoSQL
10 11 (5.05%) SQL Server Analysis Services
11 10 (4.59%) Azure SQL Database
12 9 (4.13%) BusinessObjects
12 9 (4.13%) Looker
13 8 (3.67%) BigQuery
13 8 (3.67%) MySQL
13 8 (3.67%) Neo4j
13 8 (3.67%) Qlik Sense
13 8 (3.67%) QlikView
Development Applications
1 23 (10.55%) JIRA
2 12 (5.50%) ER Studio
2 12 (5.50%) ERwin
3 10 (4.59%) Jenkins
4 4 (1.83%) Oracle Forms
4 4 (1.83%) Subversion
5 3 (1.38%) Bitbucket
6 2 (0.92%) Git (software)
6 2 (0.92%) Octopus Deploy
6 2 (0.92%) RStudio
7 1 (0.46%) Atlassian Bamboo
7 1 (0.46%) SQL Server Management Studio (SSMS)
7 1 (0.46%) TeamCity
General
1 99 (45.41%) Social Skills
2 55 (25.23%) Analytical Skills
2 55 (25.23%) Finance
3 37 (16.97%) Marketing
4 32 (14.68%) Presentation Skills
5 27 (12.39%) Banking
6 22 (10.09%) Inclusion and Diversity
7 21 (9.63%) Legal
8 16 (7.34%) Law
9 14 (6.42%) Aviation
10 12 (5.50%) Influencing Skills
11 11 (5.05%) Documentation Skills
12 10 (4.59%) Organisational Skills
12 10 (4.59%) Publishing
13 8 (3.67%) Retail
14 7 (3.21%) Manufacturing
15 4 (1.83%) Electronics
15 4 (1.83%) Public Sector
16 3 (1.38%) Telecoms
17 2 (0.92%) Pharmaceutical
Job Titles
1 59 (27.06%) Analyst
2 41 (18.81%) Developer
3 23 (10.55%) Consultant
4 21 (9.63%) Senior Analyst
5 18 (8.26%) Architect
6 14 (6.42%) Data Consultant
6 14 (6.42%) Graduate
6 14 (6.42%) IT Graduate
7 13 (5.96%) Analytics Consultant
7 13 (5.96%) Data Analyst
8 12 (5.50%) Business Intelligence Consultant
8 12 (5.50%) Data Analytics Consultant
8 12 (5.50%) Solutions Architect
9 11 (5.05%) Business Analyst
9 11 (5.05%) Presales Solution Architect
10 10 (4.59%) SQL Developer
11 9 (4.13%) Analytics Manager
12 8 (3.67%) Data Engineer
12 8 (3.67%) ERP Architect
12 8 (3.67%) Senior Analytics Manager
Libraries, Frameworks & Software Standards
1 17 (7.80%) React
2 12 (5.50%) .NET
3 11 (5.05%) REST
3 11 (5.05%) RESTful
4 10 (4.59%) AngularJS
4 10 (4.59%) Django
4 10 (4.59%) SAML
5 8 (3.67%) Node.js
6 7 (3.21%) HTML
7 6 (2.75%) CSS
7 6 (2.75%) CSS3
7 6 (2.75%) HTML5
8 5 (2.29%) Middleware
9 4 (1.83%) .NET Core
9 4 (1.83%) JSON
9 4 (1.83%) Oracle Fusion
9 4 (1.83%) PySpark
10 3 (1.38%) ASP.NET
11 2 (0.92%) MDX
11 2 (0.92%) XGBoost
Miscellaneous
1 36 (16.51%) Management Information System
2 29 (13.30%) Self-Motivation
3 14 (6.42%) CSOC
3 14 (6.42%) Security Operations Centre
4 13 (5.96%) IoT
5 12 (5.50%) FMCG
6 11 (5.05%) Enterprise Software
6 11 (5.05%) Low-Code
7 10 (4.59%) Hackathon
8 9 (4.13%) Data Structures
9 5 (2.29%) Credit Risk
10 3 (1.38%) Cloud Native
10 3 (1.38%) Mobile App
10 3 (1.38%) Tandem
10 3 (1.38%) User Experience
11 2 (0.92%) Algorithms
11 2 (0.92%) Biotechnology
11 2 (0.92%) Greenfield Project
11 2 (0.92%) Life Science
12 1 (0.46%) Data Protection Act
Operating Systems
1 3 (1.38%) Windows
2 2 (0.92%) Windows Server
3 1 (0.46%) Linux
Processes & Methodologies
1 110 (50.46%) Analytics
2 73 (33.49%) Agile
3 64 (29.36%) Problem-Solving
4 50 (22.94%) Visualisation
5 46 (21.10%) Data Modelling
6 42 (19.27%) Data Analytics
7 40 (18.35%) DevOps
8 37 (16.97%) Mentoring
9 36 (16.51%) ETL
10 32 (14.68%) Data Science
11 29 (13.30%) Collaborative Working
12 28 (12.84%) Computer Science
12 28 (12.84%) Data Analysis
13 27 (12.39%) Data Visualisation
13 27 (12.39%) Mathematics
14 26 (11.93%) Data Pipeline
15 25 (11.47%) ERP
16 24 (11.01%) Information Security
17 23 (10.55%) ITIL
18 22 (10.09%) Software Engineering
Programming Languages
1 113 (51.83%) SQL
2 56 (25.69%) Python
3 35 (16.06%) R
4 14 (6.42%) T-SQL
5 11 (5.05%) JavaScript
6 10 (4.59%) Java
7 8 (3.67%) C#
8 7 (3.21%) PL/SQL
8 7 (3.21%) PowerShell
9 5 (2.29%) Data Analysis Expressions (DAX)
10 4 (1.83%) C
11 2 (0.92%) C++
12 1 (0.46%) Bash
12 1 (0.46%) Embedded C
12 1 (0.46%) Embedded C++
12 1 (0.46%) Perl
12 1 (0.46%) Scala
Qualifications
1 48 (22.02%) Degree
2 14 (6.42%) Security Cleared
3 11 (5.05%) Numerate Degree
3 11 (5.05%) Oracle Certification
4 6 (2.75%) CIPD
5 3 (1.38%) Computer Science Degree
6 2 (0.92%) MBA
7 1 (0.46%) Microsoft Certification
Quality Assurance & Compliance
1 22 (10.09%) Data Quality
2 14 (6.42%) QA
3 5 (2.29%) IFRS
3 5 (2.29%) IFRS 9
4 2 (0.92%) GLP
5 1 (0.46%) PMO
5 1 (0.46%) Sarbanes-Oxley
System Software
1 10 (4.59%) Docker
2 3 (1.38%) Active Directory
3 1 (0.46%) Firmware
3 1 (0.46%) VMware Infrastructure
Systems Management
1 14 (6.42%) Kibana
2 9 (4.13%) Kubernetes
3 1 (0.46%) Active Directory Federation Services
3 1 (0.46%) Ansible
3 1 (0.46%) Microsoft Intune
3 1 (0.46%) Single Sign-On
3 1 (0.46%) Terraform
Vendors
1 64 (29.36%) Microsoft
2 33 (15.14%) Oracle
3 25 (11.47%) Google
4 16 (7.34%) Teradata
5 14 (6.42%) Cognos
6 7 (3.21%) MicroStrategy
6 7 (3.21%) Okta
7 5 (2.29%) Ab Initio
8 4 (1.83%) Databricks
8 4 (1.83%) SAP
9 3 (1.38%) Atlassian
9 3 (1.38%) Qualys
9 3 (1.38%) Workday
10 2 (0.92%) Adobe
10 2 (0.92%) Charles River
10 2 (0.92%) Informatica
10 2 (0.92%) MuleSoft
10 2 (0.92%) PayPal
11 1 (0.46%) Commvault
11 1 (0.46%) VMware