Period
to 21 November 2017

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 21 November 2017 with a comparison to the same period in the previous 2 years.

Business Intelligence (BI)
UK > Scotland
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 28 43 37
Rank change year-on-year +15 -6 +8
Permanent jobs citing Business Intelligence 426 271 381
As % of all permanent IT jobs advertised in Scotland 7.52% 5.24% 5.95%
As % of the Processes & Methodologies category 8.28% 5.73% 6.55%
Number of salaries quoted 203 164 305
Scotland median annual salary £45,000 £47,500 £47,000
Median salary % change year-on-year -5.26% +1.06% +10.59%
10th Percentile £31,800 £27,875 £32,500
90th Percentile £66,250 £65,000 £74,000
UK median annual salary £50,000 £50,000 £50,000

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 5148 4729 5815
As % of all permanent IT jobs advertised in Scotland 90.87% 91.42% 90.89%
Number of salaries quoted 3286 2868 3679
Scotland median annual salary £45,000 £44,500 £42,500
Median salary % change year-on-year +1.12% +4.71% +2.41%
10th Percentile £28,250 £28,250 £27,750
90th Percentile £66,250 £65,000 £63,750
UK median annual salary £50,000 £49,500 £47,500
% change year-on-year +1.01% +4.21% +5.56%

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 21 November 2017.

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 21 November 2017. 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
Edinburgh +32 285 £45,000 -10.89% 9
Glasgow -12 123 £45,000 -6.25% 13
Inverclyde +6 7 £44,000 -
Stirling +3 6 £45,000 +30.43%
Fife +1 2 £42,500 +27.82%
Aberdeen -15 2 £24,500 -48.42% 1
Dundee - 2 - -
Scottish Borders +3 1 £35,000 +7.69%
Orkney Islands - 1 - -
Business Intelligence
UK

For the 6 months to 21 November 2017, IT jobs citing Business Intelligence also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Scotland region with a requirement for Business Intelligence.

1 290 (68.08%) SQL
2 235 (55.16%) Finance
3 123 (28.87%) Banking
4 122 (28.64%) Analytical Skills
5 119 (27.93%) ETL
6 114 (26.76%) Data Management
7 113 (26.53%) SQL Server
8 106 (24.88%) Infrastructure Management
9 102 (23.94%) Analytics
10 97 (22.77%) Data Warehouse
11 96 (22.54%) Stakeholder Management
12 95 (22.30%) SAS
12 95 (22.30%) SQL Server Integration Services
13 91 (21.36%) Teradata
14 89 (20.89%) Microsoft
15 84 (19.72%) Oracle
16 81 (19.01%) SQL Server Reporting Services
17 78 (18.31%) Retail Banking
18 74 (17.37%) Agile Software Development
19 66 (15.49%) Data Analysis
20 64 (15.02%) Cognos
21 60 (14.08%) Informatica
22 55 (12.91%) T-SQL
23 53 (12.44%) Degree
23 53 (12.44%) QlikView
24 52 (12.21%) MicroStrategy
25 50 (11.74%) Tableau
26 49 (11.50%) Data Mining
27 45 (10.56%) SAP
28 37 (8.69%) Mentoring

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 95 (22.30%) SAS
2 11 (2.58%) SharePoint
3 7 (1.64%) Apache Spark
4 2 (0.47%) Apache
4 2 (0.47%) JBoss
5 1 (0.23%) IIS
5 1 (0.23%) Oracle Self-Service HR
5 1 (0.23%) Oracle SOA Suite
Applications
1 13 (3.05%) MS Visio
2 10 (2.35%) Microsoft Office
3 9 (2.11%) Microsoft Excel
4 4 (0.94%) SPSS
5 2 (0.47%) Microsoft PowerPoint
Business Applications
1 19 (4.46%) Cognos Business Intelligence
1 19 (4.46%) SAP BPC
2 9 (2.11%) SAP S/4HANA
3 6 (1.41%) Dynamics AX
3 6 (1.41%) SAP GRC
4 5 (1.17%) Dynamics CRM
5 1 (0.23%) FRx
5 1 (0.23%) NetSuite
5 1 (0.23%) Oracle 11i
5 1 (0.23%) Oracle Applications
5 1 (0.23%) Oracle EBS
5 1 (0.23%) Oracle EBS R12
5 1 (0.23%) Oracle HRMS
5 1 (0.23%) Oracle iRecruitment
5 1 (0.23%) Oracle Payroll
Cloud Services
1 16 (3.76%) Microsoft Azure
2 6 (1.41%) Dynamics 365
3 5 (1.17%) Amazon AWS
4 4 (0.94%) Azure Data Factory
5 3 (0.70%) Google Cloud Platform
6 2 (0.47%) Amazon EMR
6 2 (0.47%) Amazon SQS
6 2 (0.47%) Google Analytics
7 1 (0.23%) Azure Machine Learning
7 1 (0.23%) Cloud Computing
7 1 (0.23%) Office 365
Communications & Networking
1 4 (0.94%) HTTP
2 3 (0.70%) Internet
3 2 (0.47%) SSH
3 2 (0.47%) SSL
Database & Business Intelligence
1 113 (26.53%) SQL Server
2 97 (22.77%) Data Warehouse
3 95 (22.30%) SQL Server Integration Services
4 81 (19.01%) SQL Server Reporting Services
5 53 (12.44%) QlikView
6 49 (11.50%) Data Mining
7 36 (8.45%) Power BI
8 35 (8.22%) Relational Database
9 29 (6.81%) BusinessObjects
10 27 (6.34%) SQL Server 2012
11 25 (5.87%) Big Data
12 24 (5.63%) SQL Server Analysis Services
13 21 (4.93%) Base SAS
13 21 (4.93%) Oracle OWB
13 21 (4.93%) RDBMS
14 20 (4.69%) SAS Enterprise Guide
15 17 (3.99%) BODI
15 17 (3.99%) Cognos Report Studio
16 15 (3.52%) PowerCenter
17 13 (3.05%) DB2
Development Applications
1 24 (5.63%) Team Foundation Server
2 7 (1.64%) JIRA
3 5 (1.17%) Maven
4 4 (0.94%) Git (software)
4 4 (0.94%) Oracle APEX
4 4 (0.94%) Oracle Forms
4 4 (0.94%) Subversion
5 3 (0.70%) JUnit
5 3 (0.70%) TeamCity
5 3 (0.70%) tSQLt
6 2 (0.47%) GitLab
6 2 (0.47%) MorphX
6 2 (0.47%) Visual Studio
7 1 (0.23%) ERwin
7 1 (0.23%) VSS/SourceSafe
General
1 235 (55.16%) Finance
2 123 (28.87%) Banking
3 78 (18.31%) Retail Banking
4 27 (6.34%) Marketing
5 14 (3.29%) Manufacturing
6 10 (2.35%) Advertising
7 8 (1.88%) Electronics
7 8 (1.88%) Telecoms
8 6 (1.41%) Legal
9 3 (0.70%) Financial Institution
9 3 (0.70%) Investment Banking
10 2 (0.47%) Games
10 2 (0.47%) Law
10 2 (0.47%) Local Government
10 2 (0.47%) Retail
11 1 (0.23%) Back Office
11 1 (0.23%) Front Office
11 1 (0.23%) International Banking
Job Titles
1 134 (31.46%) Analyst
2 129 (30.28%) Developer
3 102 (23.94%) Consultant
4 67 (15.73%) Business Intelligence Developer
5 64 (15.02%) Business Analyst
5 64 (15.02%) SQL Analyst
6 63 (14.79%) Data Analyst
7 48 (11.27%) Senior Analyst
8 43 (10.09%) SQL Developer
9 40 (9.39%) Technical Analyst
10 39 (9.15%) Technical Business Analyst
11 31 (7.28%) SQL Data Analyst
12 29 (6.81%) SSIS Developer
13 27 (6.34%) Business Intelligence Consultant
14 26 (6.10%) SQL BI Developer
15 22 (5.16%) SAP Consultant
15 22 (5.16%) Senior Business Analyst
15 22 (5.16%) SQL Server Developer
16 21 (4.93%) Teradata Consultant
17 20 (4.69%) Senior Data Analyst
Libraries, Frameworks & Software Standards
1 14 (3.29%) .NET
2 10 (2.35%) HTML
3 8 (1.88%) XML
4 6 (1.41%) HTML5
4 6 (1.41%) SAP Basis
4 6 (1.41%) Web Services
5 5 (1.17%) ASP.NET
6 4 (0.94%) CSS
7 3 (0.70%) .NET Framework
7 3 (0.70%) JSON
7 3 (0.70%) Pandas
7 3 (0.70%) SOAP
8 2 (0.47%) Akka
8 2 (0.47%) ASP.NET Web API
8 2 (0.47%) MDX
8 2 (0.47%) RabbitMQ
8 2 (0.47%) RESTful
8 2 (0.47%) scikit-learn
8 2 (0.47%) Spring Security
8 2 (0.47%) WCF
Miscellaneous
1 122 (28.64%) Analytical Skills
2 19 (4.46%) Credit Risk
3 18 (4.23%) Management Information System
4 12 (2.82%) Data Structures
5 11 (2.58%) Computer Science
6 6 (1.41%) Algorithms
7 4 (0.94%) Greenfield Project
8 3 (0.70%) Driving Licence
8 3 (0.70%) Fintech
8 3 (0.70%) Hedge funds
8 3 (0.70%) Mainframe
9 2 (0.47%) FMCG
10 1 (0.23%) e-Learning
10 1 (0.23%) Enterprise Software
10 1 (0.23%) PMI
10 1 (0.23%) SCORM
10 1 (0.23%) Taxonomies
Operating Systems
1 16 (3.76%) Unix
2 12 (2.82%) Windows
3 1 (0.23%) Linux
3 1 (0.23%) Windows 10
Processes & Methodologies
1 119 (27.93%) ETL
2 114 (26.76%) Data Management
3 106 (24.88%) Infrastructure Management
4 102 (23.94%) Analytics
5 96 (22.54%) Stakeholder Management
6 74 (17.37%) Agile Software Development
7 66 (15.49%) Data Analysis
8 37 (8.69%) Mentoring
9 34 (7.98%) People Management
10 33 (7.75%) Visualisation
11 32 (7.51%) Data Analytics
12 30 (7.04%) Data Modelling
13 29 (6.81%) User Acceptance Testing
14 28 (6.57%) Project Management
15 21 (4.93%) Customer Analytics
15 21 (4.93%) SDLC
16 20 (4.69%) Business Analytics
16 20 (4.69%) Data Integration
16 20 (4.69%) Scrum
17 19 (4.46%) Software Testing
Programming Languages
1 290 (68.08%) SQL
2 55 (12.91%) T-SQL
3 23 (5.40%) Python
4 22 (5.16%) R
5 17 (3.99%) C#
5 17 (3.99%) PL/SQL
5 17 (3.99%) PowerShell
6 14 (3.29%) Java
7 8 (1.88%) JavaScript
8 4 (0.94%) X++
9 3 (0.70%) Scala
9 3 (0.70%) VBA
10 2 (0.47%) C
10 2 (0.47%) C++
11 1 (0.23%) Data Analysis Expressions (DAX)
11 1 (0.23%) HiveQL
11 1 (0.23%) MATLAB
11 1 (0.23%) SAS Macro
Qualifications
1 53 (12.44%) Degree
2 7 (1.64%) Microsoft Certification
3 6 (1.41%) MCDBA
3 6 (1.41%) MCITP
4 4 (0.94%) Security Cleared
5 2 (0.47%) PhD
6 1 (0.23%) BPSS Clearance
6 1 (0.23%) ISEB
6 1 (0.23%) ISEB Practitioner
6 1 (0.23%) PMI Certification
6 1 (0.23%) SAS Certification
Quality Assurance & Compliance
1 21 (4.93%) Data Quality
2 14 (3.29%) QA
3 9 (2.11%) IFRS
4 3 (0.70%) Basel III
4 3 (0.70%) GDPR
System Software
1 1 (0.23%) HDFS
1 1 (0.23%) VMware Infrastructure
Vendors
1 91 (21.36%) Teradata
2 89 (20.89%) Microsoft
3 84 (19.72%) Oracle
4 64 (15.02%) Cognos
5 60 (14.08%) Informatica
6 52 (12.21%) MicroStrategy
7 50 (11.74%) Tableau
8 45 (10.56%) SAP
9 17 (3.99%) IBM
10 9 (2.11%) Netezza
11 6 (1.41%) Atlassian
11 6 (1.41%) Hyperion
12 5 (1.17%) Google
13 3 (0.70%) Apple
13 3 (0.70%) Facebook
13 3 (0.70%) Twitter
14 2 (0.47%) Capita
14 2 (0.47%) Salesforce.com
14 2 (0.47%) Virgin Media
15 1 (0.23%) VMware