Period
to 17 January 2019

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 17 January 2019 with a comparison to the same period in the previous 2 years.

Business Intelligence (BI)
UK > Scotland
6 months to
17 Jan 2019
Same period 2018 Same period 2017
Rank 48 32 51
Rank change year-on-year -16 +19 -19
Permanent jobs citing Business Intelligence 270 374 206
As % of all permanent IT jobs advertised in Scotland 5.32% 6.81% 4.39%
As % of the Processes & Methodologies category 5.69% 7.37% 4.74%
Number of salaries quoted 179 197 112
Scotland median annual salary £45,000 £45,000 £47,500
Median salary % change year-on-year - -5.26% -
10th Percentile £29,950 £31,250 £35,000
90th Percentile £70,100 £66,250 £66,250
UK median annual salary £51,500 £50,000 £50,000
% change year-on-year +3.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 4,749 5,075 4,343
As % of all permanent IT jobs advertised in Scotland 93.56% 92.39% 92.56%
Number of salaries quoted 3,084 3,329 2,738
Scotland median annual salary £45,000 £45,000 £44,500
Median salary % change year-on-year - +1.12% +4.71%
10th Percentile £29,500 £28,250 £28,750
90th Percentile £69,375 £65,600 £64,825
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

Business Intelligence
Job Vacancy Trend in Scotland

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

Job vacancy trend for Business Intelligence in Scotland

Business Intelligence
Salary Trend in Scotland

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Business Intelligence in Scotland.

Salary trend for Business Intelligence in Scotland

Business Intelligence
Salary Histogram in Scotland

The salary distribution of IT jobs citing Business Intelligence in Scotland over the 6 months to 17 January 2019.

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 17 January 2019. 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
Job
Vacancies
Glasgow -4 123 £45,000 -2.70% 29
Edinburgh -35 95 £47,500 +5.56% 25
West Lothian - 16 - - 1
Aberdeen +2 6 £44,676 +82.35% 2
Dundee +18 5 £33,000 - 1
Fife +8 5 £31,500 -25.88% 2
South Lanarkshire - 3 £41,500 -
Stirling +8 2 £39,500 -
Renfrewshire +1 2 £45,000 +20.00% 2
North Lanarkshire - 2 £40,000 -
Highlands - 2 £35,000 -
Aberdeenshire - 1 £22,500 -
Business Intelligence
UK

For the 6 months to 17 January 2019, 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 168 (62.22%) SQL
2 97 (35.93%) SQL Server
3 88 (32.59%) SQL Server Reporting Services
4 86 (31.85%) Power BI
5 85 (31.48%) ETL
6 84 (31.11%) SQL Server Integration Services
7 82 (30.37%) Data Warehouse
8 79 (29.26%) Microsoft
9 71 (26.30%) Analytics
10 62 (22.96%) Analytical Skills
10 62 (22.96%) Agile Software Development
11 59 (21.85%) Finance
12 53 (19.63%) T-SQL
13 52 (19.26%) Visualisation
14 51 (18.89%) Data Modelling
15 47 (17.41%) Tableau
16 43 (15.93%) Oracle
17 42 (15.56%) QlikView
17 42 (15.56%) SQL Server Analysis Services
18 39 (14.44%) SAS
19 37 (13.70%) Microsoft Azure
20 36 (13.33%) JavaScript
21 34 (12.59%) Data Visualisation
22 32 (11.85%) .NET
22 32 (11.85%) Scrum
23 31 (11.48%) Stakeholder Management
23 31 (11.48%) Python
23 31 (11.48%) Amazon AWS
24 30 (11.11%) Problem-Solving
25 29 (10.74%) Data Engineering

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 39 (14.44%) SAS
2 16 (5.93%) Confluence
3 12 (4.44%) SharePoint
4 6 (2.22%) IIS
5 2 (0.74%) concrete5
5 2 (0.74%) JBoss
5 2 (0.74%) SharePoint 2010
6 1 (0.37%) Apache Solr
6 1 (0.37%) Apache Spark
6 1 (0.37%) ArcGIS
6 1 (0.37%) Elasticsearch
6 1 (0.37%) Exchange Server 2010
6 1 (0.37%) Jetty
6 1 (0.37%) MS Exchange
6 1 (0.37%) nginx
6 1 (0.37%) Oracle SOA Suite
6 1 (0.37%) SharePoint 2013
6 1 (0.37%) Umbraco
6 1 (0.37%) WebSphere
6 1 (0.37%) WildFly
Applications
1 18 (6.67%) Microsoft Excel
2 10 (3.70%) Microsoft Office
3 6 (2.22%) MS Visio
3 6 (2.22%) OmniGraffle
4 2 (0.74%) InfoPath
4 2 (0.74%) Microsoft PowerPoint
5 1 (0.37%) Spreadsheet
5 1 (0.37%) SPSS
Business Applications
1 16 (5.93%) Dynamics CRM
2 8 (2.96%) Oracle EBS
2 8 (2.96%) Oracle ERP
3 7 (2.59%) Dynamics AX
4 3 (1.11%) Cognos TM1
5 2 (0.74%) Cognos Business Intelligence
6 1 (0.37%) Cognos Controller
6 1 (0.37%) Dynamics NAV
6 1 (0.37%) Infor CRM
6 1 (0.37%) Markit EDM
Cloud Services
1 37 (13.70%) Microsoft Azure
2 31 (11.48%) Amazon AWS
3 12 (4.44%) Office 365
4 7 (2.59%) SaaS
5 6 (2.22%) Lucidchart
6 5 (1.85%) Dynamics 365
7 3 (1.11%) Amazon SQS
7 3 (1.11%) Google Cloud Platform
8 1 (0.37%) Amazon EMR
8 1 (0.37%) Amazon S3
8 1 (0.37%) Azure Data Factory
8 1 (0.37%) Cloud Computing
8 1 (0.37%) GitHub
8 1 (0.37%) Serverless
8 1 (0.37%) Taleo
Communications & Networking
1 7 (2.59%) DNS
2 3 (1.11%) HTTP
2 3 (1.11%) SMS
3 1 (0.37%) Firewall
3 1 (0.37%) FTP
3 1 (0.37%) Internet
3 1 (0.37%) TCP/IP
Database & Business Intelligence
1 97 (35.93%) SQL Server
2 88 (32.59%) SQL Server Reporting Services
3 86 (31.85%) Power BI
4 84 (31.11%) SQL Server Integration Services
5 82 (30.37%) Data Warehouse
6 42 (15.56%) QlikView
6 42 (15.56%) SQL Server Analysis Services
7 21 (7.78%) Relational Database
8 17 (6.30%) Oracle Reports
9 16 (5.93%) Big Data
9 16 (5.93%) Oracle BI Publisher
9 16 (5.93%) Oracle Discoverer
10 12 (4.44%) BusinessObjects
10 12 (4.44%) SQL Server 2012
11 11 (4.07%) Data Mining
11 11 (4.07%) SAS EBI
12 9 (3.33%) Enterprise Data Warehouse
12 9 (3.33%) Qlik Sense
12 9 (3.33%) SAS Data Integration Studio
13 8 (2.96%) Oracle BI EE
Development Applications
1 26 (9.63%) Visual Studio
2 20 (7.41%) JIRA
3 11 (4.07%) SQL Server Management Studio (SSMS)
4 9 (3.33%) Oracle Forms
5 8 (2.96%) Oracle APEX
5 8 (2.96%) Team Foundation Server
6 6 (2.22%) Git (software)
6 6 (2.22%) LoadRunner
7 4 (1.48%) Jenkins
7 4 (1.48%) TeamCity
8 3 (1.11%) Hudson
8 3 (1.11%) Maven
8 3 (1.11%) Subversion
9 2 (0.74%) Artifactory
10 1 (0.37%) Ant
10 1 (0.37%) Atlassian Bamboo
10 1 (0.37%) Eclipse
10 1 (0.37%) JUnit
10 1 (0.37%) Selenium
10 1 (0.37%) TestNG
General
1 59 (21.85%) Finance
2 14 (5.19%) Banking
3 12 (4.44%) Marketing
4 9 (3.33%) Manufacturing
4 9 (3.33%) Retail
5 7 (2.59%) Electronics
5 7 (2.59%) Telecoms
6 5 (1.85%) Legal
7 4 (1.48%) Advertising
8 3 (1.11%) Back Office
9 2 (0.74%) Games
9 2 (0.74%) Publishing
10 1 (0.37%) French Language
10 1 (0.37%) Investment Banking
10 1 (0.37%) Law
10 1 (0.37%) Retail Banking
Job Titles
1 94 (34.81%) Developer
2 53 (19.63%) Analyst
3 32 (11.85%) Consultant
4 30 (11.11%) SQL Developer
5 28 (10.37%) Business Intelligence Developer
6 18 (6.67%) Business Intelligence Analyst
6 18 (6.67%) Business Intelligence Consultant
7 16 (5.93%) .NET Developer
8 15 (5.56%) Data Analyst
9 14 (5.19%) Database Developer
10 13 (4.81%) Business Consultant
10 13 (4.81%) Data Engineer
11 12 (4.44%) Software Developer
12 11 (4.07%) Business Analyst
12 11 (4.07%) Senior Analyst
13 10 (3.70%) Test Analyst
14 9 (3.33%) Data Scientist
14 9 (3.33%) Senior Developer
14 9 (3.33%) SQL BI Developer
15 8 (2.96%) Report Specialist
Libraries, Frameworks & Software Standards
1 32 (11.85%) .NET
2 25 (9.26%) ASP.NET
3 15 (5.56%) HTML
4 13 (4.81%) CSS
5 12 (4.44%) .NET Framework
6 11 (4.07%) Web Services
7 8 (2.96%) ASP.NET MVC
7 8 (2.96%) jQuery
7 8 (2.96%) XML
8 7 (2.59%) Ajax
9 4 (1.48%) ASP.NET Web API
9 4 (1.48%) Entity Framework
9 4 (1.48%) REST
9 4 (1.48%) RESTful
10 3 (1.11%) Akka.NET
10 3 (1.11%) DOM
10 3 (1.11%) RabbitMQ
10 3 (1.11%) WCF
11 2 (0.74%) JSON
11 2 (0.74%) Symfony
Miscellaneous
1 62 (22.96%) Analytical Skills
2 11 (4.07%) Algorithms
3 8 (2.96%) Enterprise Software
4 7 (2.59%) Data Structures
5 5 (1.85%) Fintech
6 4 (1.48%) iPad
6 4 (1.48%) iPhone
6 4 (1.48%) Mainframe
6 4 (1.48%) Management Information System
6 4 (1.48%) User Experience
7 3 (1.11%) Greenfield Project
8 2 (0.74%) Taxonomies
8 2 (0.74%) Virtual Team
9 1 (0.37%) Analytical Mindset
9 1 (0.37%) Driving Licence
9 1 (0.37%) Equities
9 1 (0.37%) Fixed Income
9 1 (0.37%) FMCG
9 1 (0.37%) Linux Command Line
9 1 (0.37%) NHS
Operating Systems
1 6 (2.22%) Apple iOS
1 6 (2.22%) Windows
2 5 (1.85%) Unix
3 4 (1.48%) Linux
4 3 (1.11%) Android
5 1 (0.37%) Windows 10
Processes & Methodologies
1 85 (31.48%) ETL
2 71 (26.30%) Analytics
3 62 (22.96%) Agile Software Development
4 52 (19.26%) Visualisation
5 51 (18.89%) Data Modelling
6 34 (12.59%) Data Visualisation
7 32 (11.85%) Scrum
8 31 (11.48%) Stakeholder Management
9 30 (11.11%) Problem-Solving
10 29 (10.74%) Data Engineering
11 25 (9.26%) Data Analytics
11 25 (9.26%) Project Management
12 24 (8.89%) CRM
13 23 (8.52%) ERP
14 22 (8.15%) Data Extraction
15 20 (7.41%) Data Analysis
15 20 (7.41%) Data Science
15 20 (7.41%) Migration
16 19 (7.04%) ITIL
16 19 (7.04%) SDLC
Programming Languages
1 168 (62.22%) SQL
2 53 (19.63%) T-SQL
3 36 (13.33%) JavaScript
4 31 (11.48%) Python
5 27 (10.00%) C#
6 21 (7.78%) Java
7 14 (5.19%) R
8 11 (4.07%) Scala
9 10 (3.70%) Bash Shell
9 10 (3.70%) PL/SQL
10 7 (2.59%) PowerShell
11 6 (2.22%) VB
11 6 (2.22%) VB.NET
12 4 (1.48%) VBA
13 3 (1.11%) MATLAB
13 3 (1.11%) PHP
14 2 (0.74%) Perl
14 2 (0.74%) Ruby
14 2 (0.74%) SAS Macro
15 1 (0.37%) Data Analysis Expressions (DAX)
Qualifications
1 10 (3.70%) Degree
2 4 (1.48%) PRINCE2 Certification
3 2 (0.74%) Numerate Degree
4 1 (0.37%) Computer Science Degree
4 1 (0.37%) ITIL Certification
4 1 (0.37%) MCSA
4 1 (0.37%) MCSE
4 1 (0.37%) Microsoft Certification
4 1 (0.37%) PhD
4 1 (0.37%) SAS Certification
Quality Assurance & Compliance
1 27 (10.00%) Data Quality
2 15 (5.56%) QA
3 8 (2.96%) GDPR
4 1 (0.37%) ISO/IEC 27001
4 1 (0.37%) PMO
System Software
1 9 (3.33%) Active Directory
2 5 (1.85%) Docker
3 2 (0.74%) Apache Flume
4 1 (0.37%) HDFS
4 1 (0.37%) VMware Infrastructure
4 1 (0.37%) vSphere
Systems Management
1 7 (2.59%) Systems Management Server (SMS)
2 3 (1.11%) Ansible
2 3 (1.11%) Opscode Chef
2 3 (1.11%) Puppet
3 2 (0.74%) Kubernetes
4 1 (0.37%) Docker Swarm
4 1 (0.37%) Hadoop YARN
4 1 (0.37%) Mesos
4 1 (0.37%) Rundeck
4 1 (0.37%) Single Sign-On
4 1 (0.37%) WMI
Vendors
1 79 (29.26%) Microsoft
2 47 (17.41%) Tableau
3 43 (15.93%) Oracle
4 23 (8.52%) MicroStrategy
5 18 (6.67%) Cognos
6 14 (5.19%) SAP
7 8 (2.96%) Atlassian
7 8 (2.96%) Teradata
8 6 (2.22%) HP
9 4 (1.48%) Google
9 4 (1.48%) Symantec
10 3 (1.11%) Canon
10 3 (1.11%) IBM
10 3 (1.11%) Talend
11 2 (0.74%) Alteryx
11 2 (0.74%) Cloudera
11 2 (0.74%) Hortonworks
11 2 (0.74%) Hyperion
11 2 (0.74%) Salesforce.com
11 2 (0.74%) Twitter