Period
to 12 December 2018

The median annual salary for a Business Intelligence Consultant was £49,500 in advertised job vacancies in Scotland during the 6 months to 12 December 2018.

The first table below provides salary benchmarking and summary statistics including a comparison to same period in the previous 2 years.

BI Consultant
UK > Scotland
6 months to
12 Dec 2018
Same period 2017 Same period 2016
Rank 206 209 196
Rank change year-on-year +3 -13 +2
Permanent jobs requiring a Business Intelligence Consultant 20 21 17
As % of all permanent IT jobs advertised in Scotland 0.38% 0.37% 0.34%
As % of the Job Titles category 0.39% 0.39% 0.35%
Number of salaries quoted 20 10 2
Scotland median annual salary £49,500 £45,250 £48,750
Median salary % change year-on-year +9.39% -7.18% +2.63%
10th Percentile £33,750 £34,750 £43,875
90th Percentile £50,000 £75,000 £54,625
UK median annual salary £52,500 £57,500 £52,500
% change year-on-year -8.70% +9.52% -

The following table is for comparison with the above and includes summary statistics for all permanent IT job vacancies advertised in Scotland. Most job vacancies include a discernible job title that can be normalized. As such, the figures in the second row provide an indication of the number of permanent jobs in our overall sample.

All Permanent IT Job Vacancies
Scotland
Permanent vacancies in Scotland with a recognized job title 5,077 5,426 4,864
% of permanent IT jobs with a recognized job title 95.32% 96.72% 96.22%
Number of salaries quoted 3,310 3,517 3,072
Scotland median annual salary £45,000 £42,500 £42,750
Median salary % change year-on-year +5.88% -0.58% +0.59%
10th Percentile £28,750 £28,000 £27,500
90th Percentile £69,375 £65,000 £65,000
UK median annual salary £50,000 £49,000 £47,500
% change year-on-year +2.04% +3.16% +5.56%

Business Intelligence Consultant
Job Vacancy Trend in Scotland

Job postings that featured Business Intelligence Consultant in the job title as a percentage of all IT jobs advertised in Scotland.

Job vacancy trend for Business Intelligence Consultant in Scotland

Business Intelligence Consultant
Salary Trend in Scotland

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

Salary trend for Business Intelligence Consultant in Scotland

Business Intelligence Consultant
Salary Histogram in Scotland

The salary distribution of IT jobs citing Business Intelligence Consultant in Scotland over the 6 months to 12 December 2018.

Salary histogram for Business Intelligence Consultant in Scotland

Business Intelligence Consultant
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 Consultant within the Scotland region over the 6 months to 12 December 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 +13 14 £50,000 +4.17% 3
Edinburgh -6 6 £37,500 -11.76% 1
Business Intelligence Consultant
UK

Business Intelligence Consultant Skill Set
Top 30 Co-occurring IT Skills in Scotland

For the 6 months to 12 December 2018, Business Intelligence Consultant job roles required the following IT 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 featuring Business Intelligence Consultant in the job title.

1 20 (100.00%) Business Intelligence
2 18 (90.00%) Microsoft Azure
2 18 (90.00%) Amazon AWS
3 17 (85.00%) Data Warehouse
3 17 (85.00%) Data Modelling
4 16 (80.00%) ETL
5 15 (75.00%) SQL
6 13 (65.00%) Oracle
6 13 (65.00%) Python
6 13 (65.00%) Cognos
6 13 (65.00%) Tableau
6 13 (65.00%) Power BI
7 11 (55.00%) SQL Server
8 10 (50.00%) Data Extraction
8 10 (50.00%) Scala
8 10 (50.00%) Relational Database
8 10 (50.00%) Procedural Programming
8 10 (50.00%) Database Theory
8 10 (50.00%) Relational Database Theory
8 10 (50.00%) Data Quality
8 10 (50.00%) Visualisation
8 10 (50.00%) Bash Shell
8 10 (50.00%) Data Visualisation
8 10 (50.00%) Data Engineering
9 5 (25.00%) SQL Server Analysis Services
9 5 (25.00%) SQL Server Reporting Services
9 5 (25.00%) SQL Server Integration Services
9 5 (25.00%) SAS
9 5 (25.00%) Microsoft
10 4 (20.00%) Systems Management Server (SMS)

Business Intelligence Consultant Skill Set
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 5 (25.00%) SAS
Cloud Services
1 18 (90.00%) Amazon AWS
1 18 (90.00%) Microsoft Azure
Database & Business Intelligence
1 17 (85.00%) Data Warehouse
2 13 (65.00%) Power BI
3 11 (55.00%) SQL Server
4 10 (50.00%) Relational Database
5 5 (25.00%) SQL Server Analysis Services
5 5 (25.00%) SQL Server Integration Services
5 5 (25.00%) SQL Server Reporting Services
6 3 (15.00%) DB2
6 3 (15.00%) Hadoop
6 3 (15.00%) SAS EBI
7 2 (10.00%) Base SAS
7 2 (10.00%) QlikView
7 2 (10.00%) SAS Data Integration Studio
7 2 (10.00%) SAS Enterprise Guide
7 2 (10.00%) SAS Enterprise Miner
General
1 3 (15.00%) Finance
Processes & Methodologies
1 20 (100.00%) Business Intelligence
2 17 (85.00%) Data Modelling
3 16 (80.00%) ETL
4 10 (50.00%) Data Engineering
4 10 (50.00%) Data Extraction
4 10 (50.00%) Data Visualisation
4 10 (50.00%) Database Theory
4 10 (50.00%) Procedural Programming
4 10 (50.00%) Relational Database Theory
4 10 (50.00%) Visualisation
5 2 (10.00%) Analytics
5 2 (10.00%) Dashboard Development
5 2 (10.00%) Data Analysis
5 2 (10.00%) Project Management
5 2 (10.00%) SDLC
5 2 (10.00%) Stakeholder Management
Programming Languages
1 15 (75.00%) SQL
2 13 (65.00%) Python
3 10 (50.00%) Bash Shell
3 10 (50.00%) Scala
4 3 (15.00%) Java
4 3 (15.00%) SAS Macro
4 3 (15.00%) VBA
Quality Assurance & Compliance
1 10 (50.00%) Data Quality
Systems Management
1 4 (20.00%) Systems Management Server (SMS)
Vendors
1 13 (65.00%) Cognos
1 13 (65.00%) Oracle
1 13 (65.00%) Tableau
2 5 (25.00%) Microsoft
3 3 (15.00%) MicroStrategy
3 3 (15.00%) Teradata