Period
to 18 August 2018

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 18 August 2018 with a comparison to the same period in the previous 2 years.

Business Intelligence (BI)
UK > Scotland
6 months to
18 Aug 2018
Same period 2017 Same period 2016
Rank 47 36 28
Rank change year-on-year -11 -8 +18
Permanent jobs citing Business Intelligence 275 345 413
As % of all permanent IT jobs advertised in Scotland 4.98% 6.42% 7.28%
As % of the Processes & Methodologies category 5.36% 6.94% 7.87%
Number of salaries quoted 221 154 275
Scotland median annual salary £43,500 £45,000 £47,500
Median salary % change year-on-year -3.33% -5.26% +7.95%
10th Percentile £28,250 £32,150 £26,750
90th Percentile £77,500 £69,250 £67,000
UK median annual salary £50,000 £47,500 £50,000
% change year-on-year +5.26% -5.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,129 4,971 5,248
As % of all permanent IT jobs advertised in Scotland 92.92% 92.54% 92.56%
Number of salaries quoted 3,417 3,093 3,112
Scotland median annual salary £45,000 £44,000 £45,000
Median salary % change year-on-year +2.27% -2.22% +5.88%
10th Percentile £29,750 £28,250 £26,750
90th Percentile £70,000 £68,550 £65,000
UK median annual salary £50,000 £50,000 £47,690
% change year-on-year - +4.84% +0.40%

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 18 August 2018.

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 18 August 2018. 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 +10 140 £42,500 +6.25% 16
Edinburgh -23 113 £42,500 -5.56% 13
Aberdeen +4 6 £49,750 -
Stirling -2 6 £37,500 -16.67%
West Lothian -7 6 £42,500 +13.33% 2
South Lanarkshire - 4 £43,000 -
Fife -7 3 £31,500 -28.41% 1
North Lanarkshire - 3 £45,000 -
Highlands - 2 £35,000 -
Renfrewshire - 1 £47,500 -
West Dunbartonshire - 1 £30,000 -
Business Intelligence
UK

For the 6 months to 18 August 2018, 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 163 (59.27%) SQL
2 86 (31.27%) Finance
3 81 (29.45%) ETL
4 79 (28.73%) SQL Server
4 79 (28.73%) Microsoft
5 77 (28.00%) Analytics
6 71 (25.82%) Data Warehouse
7 70 (25.45%) Agile Software Development
8 68 (24.73%) SQL Server Integration Services
9 66 (24.00%) SQL Server Reporting Services
10 54 (19.64%) Power BI
11 48 (17.45%) .NET
12 46 (16.73%) C#
12 46 (16.73%) Data Modelling
12 46 (16.73%) SQL Server Analysis Services
13 44 (16.00%) T-SQL
14 40 (14.55%) SAP
15 39 (14.18%) Oracle
16 36 (13.09%) QlikView
17 34 (12.36%) Relational Database
17 34 (12.36%) Analytical Skills
18 33 (12.00%) SAS
19 32 (11.64%) ASP.NET
20 31 (11.27%) MVC
20 31 (11.27%) Git (software)
21 30 (10.91%) Tableau
21 30 (10.91%) TDD
21 30 (10.91%) Manufacturing
22 29 (10.55%) NoSQL
23 28 (10.18%) Visualisation

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 33 (12.00%) SAS
2 9 (3.27%) SharePoint
3 3 (1.09%) Apache Spark
3 3 (1.09%) Confluence
3 3 (1.09%) Elasticsearch
4 2 (0.73%) Apache
4 2 (0.73%) Oracle SOA Suite
5 1 (0.36%) Apache Pig
5 1 (0.36%) ArcGIS
5 1 (0.36%) CMS
5 1 (0.36%) IIS
5 1 (0.36%) Oracle Workflow
5 1 (0.36%) Umbraco
5 1 (0.36%) WebLogic
Applications
1 15 (5.45%) Microsoft Excel
2 10 (3.64%) Microsoft Office
3 4 (1.45%) Microsoft PowerPoint
4 2 (0.73%) MS Visio
4 2 (0.73%) SPSS
5 1 (0.36%) Microsoft Project
Business Applications
1 8 (2.91%) Dynamics CRM
2 5 (1.82%) Cognos Business Intelligence
2 5 (1.82%) Cognos TM1
2 5 (1.82%) Dynamics AX
3 3 (1.09%) Cognos Controller
4 2 (0.73%) Oracle Applications
4 2 (0.73%) Oracle EBS
4 2 (0.73%) SAP Oil and Gas
5 1 (0.36%) SAP HCM
5 1 (0.36%) SAP HR
5 1 (0.36%) Unit4 Business World
Cloud Services
1 24 (8.73%) Microsoft Azure
2 17 (6.18%) Amazon AWS
3 7 (2.55%) Azure Data Factory
3 7 (2.55%) Google Cloud Platform
4 4 (1.45%) Cloud Computing
4 4 (1.45%) Dynamics 365
4 4 (1.45%) Google Analytics
5 3 (1.09%) Amazon SQS
5 3 (1.09%) SaaS
6 2 (0.73%) Office 365
6 2 (0.73%) Trello
7 1 (0.36%) Amazon EC2
7 1 (0.36%) Amazon EMR
7 1 (0.36%) Amazon S3
7 1 (0.36%) AWS Lambda
7 1 (0.36%) Serverless
Communications & Networking
1 5 (1.82%) HTTP
2 3 (1.09%) Internet
2 3 (1.09%) SMS
3 2 (0.73%) DNS
3 2 (0.73%) Firewall
3 2 (0.73%) TCP/IP
3 2 (0.73%) Wi-Fi
4 1 (0.36%) FTP
4 1 (0.36%) Intranet
4 1 (0.36%) SAN
4 1 (0.36%) SSL
Database & Business Intelligence
1 79 (28.73%) SQL Server
2 71 (25.82%) Data Warehouse
3 68 (24.73%) SQL Server Integration Services
4 66 (24.00%) SQL Server Reporting Services
5 54 (19.64%) Power BI
6 46 (16.73%) SQL Server Analysis Services
7 36 (13.09%) QlikView
8 34 (12.36%) Relational Database
9 29 (10.55%) NoSQL
10 27 (9.82%) SQL Server 2016
11 15 (5.45%) Big Data
12 14 (5.09%) BusinessObjects
12 14 (5.09%) SAS EBI
13 13 (4.73%) SAS Data Integration Studio
14 12 (4.36%) Data Mining
15 11 (4.00%) Qlik Sense
16 10 (3.64%) MySQL
17 9 (3.27%) Oracle Reports
17 9 (3.27%) RDBMS
17 9 (3.27%) SQL Server 2012
Development Applications
1 31 (11.27%) Git (software)
2 10 (3.64%) Oracle Forms
2 10 (3.64%) Visual Studio
3 7 (2.55%) Team Foundation Server
4 5 (1.82%) JIRA
5 4 (1.45%) Jasmine
5 4 (1.45%) Jenkins
5 4 (1.45%) JUnit
5 4 (1.45%) Protractor
5 4 (1.45%) Selenium
5 4 (1.45%) SQL Server Management Studio (SSMS)
5 4 (1.45%) TestNG
6 2 (0.73%) TeamCity
7 1 (0.36%) Atlassian Bamboo
7 1 (0.36%) CA Release Automation
7 1 (0.36%) git-flow
7 1 (0.36%) NetBeans
7 1 (0.36%) Oracle APEX
7 1 (0.36%) Subversion
7 1 (0.36%) Visual Studio Team System
General
1 86 (31.27%) Finance
2 30 (10.91%) Manufacturing
3 27 (9.82%) Marketing
4 22 (8.00%) Electronics
4 22 (8.00%) Telecoms
5 11 (4.00%) Banking
6 7 (2.55%) Advertising
7 5 (1.82%) Legal
7 5 (1.82%) Retail
8 4 (1.45%) Billing
9 3 (1.09%) Publishing
10 2 (0.73%) Back Office
10 2 (0.73%) Investment Banking
10 2 (0.73%) Law
11 1 (0.36%) French Language
11 1 (0.36%) Games
Job Titles
1 101 (36.73%) Developer
2 76 (27.64%) Analyst
3 35 (12.73%) .NET Developer
4 31 (11.27%) Business Intelligence Developer
5 27 (9.82%) Consultant
6 22 (8.00%) Business Intelligence Analyst
7 19 (6.91%) Data Analyst
8 14 (5.09%) Senior Analyst
8 14 (5.09%) SQL Developer
9 10 (3.64%) Business Intelligence Consultant
9 10 (3.64%) SAS Consultant
9 10 (3.64%) Senior Developer
9 10 (3.64%) Support Analyst
10 9 (3.27%) Administrator
10 9 (3.27%) Business Developer
10 9 (3.27%) Data Integration Developer
10 9 (3.27%) Database Developer
10 9 (3.27%) Integration Developer
10 9 (3.27%) Lead Developer
11 8 (2.91%) Graduate
Libraries, Frameworks & Software Standards
1 48 (17.45%) .NET
2 32 (11.64%) ASP.NET
3 27 (9.82%) ASP.NET Web API
3 27 (9.82%) WCF
4 26 (9.45%) ASP.NET MVC
4 26 (9.45%) Node.js
5 25 (9.09%) ASP.NET MVC 5
6 24 (8.73%) RESTful
7 7 (2.55%) CSS
7 7 (2.55%) HTML
7 7 (2.55%) Middleware
8 5 (1.82%) Web Services
9 4 (1.45%) .NET Framework
9 4 (1.45%) AngularJS
9 4 (1.45%) Entity Framework
9 4 (1.45%) RabbitMQ
9 4 (1.45%) REST
10 3 (1.09%) Akka.NET
10 3 (1.09%) Natural Language Processing
10 3 (1.09%) Twitter Bootstrap
Miscellaneous
1 34 (12.36%) Analytical Skills
2 14 (5.09%) Algorithms
3 11 (4.00%) Greenfield Project
4 7 (2.55%) Data Structures
4 7 (2.55%) Mainframe
5 6 (2.18%) User Experience
6 5 (1.82%) Credit Risk
6 5 (1.82%) Fintech
7 4 (1.45%) FMCG
8 3 (1.09%) Enterprise Software
8 3 (1.09%) Management Information System
8 3 (1.09%) Self-Motivation
9 2 (0.73%) Computer Science
9 2 (0.73%) Data Centre
9 2 (0.73%) Driving Licence
9 2 (0.73%) Replication
9 2 (0.73%) Smartphone
9 2 (0.73%) Social Media
10 1 (0.36%) NHS
10 1 (0.36%) TRADACOMS
Operating Systems
1 15 (5.45%) Unix
2 12 (4.36%) Linux
2 12 (4.36%) Windows
3 6 (2.18%) AIX
4 2 (0.73%) Ubuntu
4 2 (0.73%) Windows Server
4 2 (0.73%) Windows Server 2008
5 1 (0.36%) Android
5 1 (0.36%) CentOS
5 1 (0.36%) Red Hat Enterprise Linux
5 1 (0.36%) Windows Server 2003
Processes & Methodologies
1 81 (29.45%) ETL
2 77 (28.00%) Analytics
3 70 (25.45%) Agile Software Development
4 46 (16.73%) Data Modelling
5 31 (11.27%) MVC
6 30 (10.91%) TDD
7 28 (10.18%) Stakeholder Management
7 28 (10.18%) Visualisation
8 27 (9.82%) Data Analytics
9 25 (9.09%) Data Analysis
10 24 (8.73%) BDD
10 24 (8.73%) SDLC
10 24 (8.73%) Web Application Development
11 23 (8.36%) Data Integration
12 22 (8.00%) Digital Marketing
12 22 (8.00%) Programme Management
13 21 (7.64%) Software Engineering
14 20 (7.27%) Creative Thinking
15 19 (6.91%) Problem-Solving
16 18 (6.55%) Machine Learning
Programming Languages
1 163 (59.27%) SQL
2 46 (16.73%) C#
3 44 (16.00%) T-SQL
4 26 (9.45%) Ruby
5 21 (7.64%) Java
6 18 (6.55%) PL/SQL
7 16 (5.82%) JavaScript
7 16 (5.82%) Python
8 11 (4.00%) R
9 9 (3.27%) VBA
10 4 (1.45%) Shell Script
11 3 (1.09%) C++
11 3 (1.09%) SAS Macro
12 2 (0.73%) MATLAB
12 2 (0.73%) Scala
12 2 (0.73%) SOQL
13 1 (0.36%) Perl
13 1 (0.36%) PHP
13 1 (0.36%) VB
13 1 (0.36%) XAML
Qualifications
1 13 (4.73%) Degree
2 3 (1.09%) BPSS Clearance
3 2 (0.73%) Microsoft Certification
3 2 (0.73%) Numerate Degree
4 1 (0.36%) CISSP
4 1 (0.36%) MCP
4 1 (0.36%) MCSA
4 1 (0.36%) MCSE
4 1 (0.36%) PhD
4 1 (0.36%) PRINCE2 Certification
4 1 (0.36%) SC Cleared
4 1 (0.36%) Security Cleared
Quality Assurance & Compliance
1 9 (3.27%) Data Quality
2 3 (1.09%) PMO
2 3 (1.09%) QA
3 2 (0.73%) GDPR
3 2 (0.73%) HL7
3 2 (0.73%) SLA
4 1 (0.36%) Cyber Essentials
4 1 (0.36%) GAAP
4 1 (0.36%) GCP
4 1 (0.36%) HIPAA
4 1 (0.36%) Sarbanes-Oxley
4 1 (0.36%) SSAE 16
System Software
1 5 (1.82%) Docker
2 4 (1.45%) Virtual Machines
3 2 (0.73%) HDFS
3 2 (0.73%) VMware ESXi
4 1 (0.36%) Active Directory
4 1 (0.36%) Hyper-V
4 1 (0.36%) vSphere
Systems Management
1 12 (4.36%) Systems Management Server (SMS)
2 4 (1.45%) Oracle RMAN
3 3 (1.09%) Data Guard
4 2 (0.73%) Puppet
5 1 (0.36%) Ansible
5 1 (0.36%) Docker Swarm
5 1 (0.36%) Grafana
5 1 (0.36%) Kibana
5 1 (0.36%) Kubernetes
5 1 (0.36%) Mesos
5 1 (0.36%) Nagios
5 1 (0.36%) Oozie
5 1 (0.36%) Opscode Chef
5 1 (0.36%) Rundeck
5 1 (0.36%) Single Sign-On
5 1 (0.36%) Terraform
Vendors
1 79 (28.73%) Microsoft
2 40 (14.55%) SAP
3 39 (14.18%) Oracle
4 30 (10.91%) Tableau
5 18 (6.55%) Cognos
6 14 (5.09%) MicroStrategy
7 10 (3.64%) Google
7 10 (3.64%) Informatica
8 6 (2.18%) Teradata
9 5 (1.82%) Hyperion
9 5 (1.82%) Vertica
10 4 (1.45%) IBM
10 4 (1.45%) Salesforce.com
11 3 (1.09%) Talend
12 2 (0.73%) Alteryx
12 2 (0.73%) OutlookSoft
12 2 (0.73%) VMware
13 1 (0.36%) Ab Initio
13 1 (0.36%) Mitel
13 1 (0.36%) Sophos