Period
to 18 November 2017

The median annual salary for a Microsoft BI Consultant was £65,000 in advertised job vacancies during the 6 months to 18 November 2017.

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

Microsoft Business Intelligence Consultant
UK
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 1103 1169 1258
Rank change year-on-year +66 +89 -6
Permanent jobs requiring a Microsoft BI Consultant 74 53 56
As % of all permanent IT jobs advertised in the UK 0.041% 0.028% 0.026%
As % of the Job Titles category 0.043% 0.029% 0.027%
Number of salaries quoted 65 45 51
UK median annual salary £65,000 £55,000 £70,000
Median salary % change year-on-year +18.18% -21.43% +12.00%
10th Percentile £47,500 £43,750 £45,000
90th Percentile £75,000 £92,500 £87,500
UK excluding London median annual salary £57,500 £48,750 £52,500
% change year-on-year +17.95% -7.14% -16.00%

The following table is for comparison with the above and includes summary statistics for all permanent IT job vacancies. 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
UK
Permanent vacancies in the UK with a recognized job title 171362 183209 211285
% of permanent IT jobs with a recognized job title 95.77% 96.48% 96.46%
Number of salaries quoted 137432 153366 175465
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% -
10th Percentile £27,500 £27,000 £26,250
90th Percentile £78,750 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,500
% change year-on-year - +4.94% +1.25%

Microsoft BI Consultant
Job Vacancy Trend

Job postings that featured Microsoft BI Consultant in the job title as a percentage of all IT jobs advertised.

Job vacancy trend for Microsoft BI Consultant in the UK

Microsoft BI Consultant
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Microsoft BI Consultant.

Salary trend for Microsoft BI Consultant in the UK

Microsoft BI Consultant
Salary Histogram

The salary distribution of IT jobs citing Microsoft BI Consultant over the 6 months to 18 November 2017.

Salary histogram for Microsoft BI Consultant in the UK

Microsoft BI Consultant
Top 11 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Microsoft BI Consultant within the UK over the 6 months to 18 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
England +41 66 £57,500 +4.55% 2
London +1 42 £65,000 +13.04% 1
UK excluding London +75 21 £57,500 +17.95% 1
Midlands - 7 £60,000 -
North of England +12 6 £62,500 +108.33%
Yorkshire +37 5 £70,000 +133.33%
South East +33 4 £53,750 +7.50% 1
South West - 4 £57,500 -
West Midlands - 4 £65,000 -
East Midlands - 3 £55,000 -
North West - 1 £50,000 -

Microsoft BI Consultant Skill Set
Top 30 Co-occurring IT Skills

For the 6 months to 18 November 2017, Microsoft BI Consultant job roles required the following IT skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads featuring Microsoft BI Consultant in the job title.

1 74 (100.00%) Business Intelligence
1 74 (100.00%) Microsoft
2 63 (85.14%) Power BI
3 61 (82.43%) Microsoft Azure
4 57 (77.03%) SQL Server Reporting Services
5 56 (75.68%) SQL Server Integration Services
6 53 (71.62%) SQL Server
7 51 (68.92%) SQL Server Analysis Services
8 50 (67.57%) Data Warehouse
9 49 (66.22%) SQL
10 47 (63.51%) Azure SQL Database
11 46 (62.16%) Analytics
12 41 (55.41%) Azure SQL Data Warehouse
13 37 (50.00%) Data Lake
14 36 (48.65%) Tableau
15 35 (47.30%) Azure Data Factory
16 33 (44.59%) Stakeholder Management
17 31 (41.89%) Visualisation
18 27 (36.49%) Presales
19 26 (35.14%) Data Visualisation
20 24 (32.43%) Business Analytics
20 24 (32.43%) Oracle
21 19 (25.68%) Advertising
22 17 (22.97%) Cortana Intelligence Suite
23 14 (18.92%) SQL Server 2016
24 13 (17.57%) OLAP
25 12 (16.22%) Information Management
25 12 (16.22%) Microsoft Analysis Services
25 12 (16.22%) R
26 11 (14.86%) MDX

Microsoft BI Consultant Skill Set
Co-occurring IT Skills 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 (6.76%) SharePoint
Applications
1 2 (2.70%) Microsoft Excel
2 1 (1.35%) Microsoft Office
2 1 (1.35%) MS Visio
Business Applications
1 9 (12.16%) Dynamics AX
2 2 (2.70%) NetSuite
Cloud Services
1 61 (82.43%) Microsoft Azure
2 35 (47.30%) Azure Data Factory
3 17 (22.97%) Cortana Intelligence Suite
4 7 (9.46%) Dynamics 365
5 5 (6.76%) Amazon AWS
5 5 (6.76%) Azure Active Directory
5 5 (6.76%) PaaS
5 5 (6.76%) Yammer
6 4 (5.41%) Azure Machine Learning
Database & Business Intelligence
1 63 (85.14%) Power BI
2 57 (77.03%) SQL Server Reporting Services
3 56 (75.68%) SQL Server Integration Services
4 53 (71.62%) SQL Server
5 51 (68.92%) SQL Server Analysis Services
6 50 (67.57%) Data Warehouse
7 47 (63.51%) Azure SQL Database
8 41 (55.41%) Azure SQL Data Warehouse
9 37 (50.00%) Data Lake
10 14 (18.92%) SQL Server 2016
11 13 (17.57%) OLAP
12 12 (16.22%) Microsoft Analysis Services
13 11 (14.86%) Big Data
14 10 (13.51%) HDInsight
14 10 (13.51%) Oracle OLAP
15 9 (12.16%) QlikView
16 6 (8.11%) Microsoft Power View
16 6 (8.11%) PowerPivot
17 5 (6.76%) Hadoop
17 5 (6.76%) SQL Server 2012
Development Applications
1 1 (1.35%) Visual Studio
General
1 19 (25.68%) Advertising
2 1 (1.35%) Finance
2 1 (1.35%) French Language
2 1 (1.35%) Retail
Libraries, Frameworks & Software Standards
1 11 (14.86%) MDX
2 7 (9.46%) .NET
Miscellaneous
1 5 (6.76%) Analytical Skills
1 5 (6.76%) Management Information System
1 5 (6.76%) Private Cloud
2 1 (1.35%) Blog
2 1 (1.35%) Computer Science
2 1 (1.35%) Driving Licence
Operating Systems
1 6 (8.11%) Linux
2 5 (6.76%) Windows
2 5 (6.76%) Windows 10
Processes & Methodologies
1 74 (100.00%) Business Intelligence
2 46 (62.16%) Analytics
3 33 (44.59%) Stakeholder Management
4 31 (41.89%) Visualisation
5 27 (36.49%) Presales
6 26 (35.14%) Data Visualisation
7 24 (32.43%) Business Analytics
8 12 (16.22%) Information Management
9 11 (14.86%) Agile Software Development
10 10 (13.51%) Business Development
10 10 (13.51%) Machine Learning
11 9 (12.16%) B2B
11 9 (12.16%) Kimball Methodology
12 8 (10.81%) ETL
12 8 (10.81%) Predictive Analytics
13 7 (9.46%) Collaborative Working
13 7 (9.46%) ERP
13 7 (9.46%) ITIL
14 5 (6.76%) DevOps
14 5 (6.76%) PRINCE2
Programming Languages
1 49 (66.22%) SQL
2 12 (16.22%) R
3 5 (6.76%) Python
4 2 (2.70%) C#
4 2 (2.70%) T-SQL
4 2 (2.70%) X++
Qualifications
1 8 (10.81%) Degree
2 6 (8.11%) Microsoft Certification
3 5 (6.76%) MCSA
3 5 (6.76%) MCSE
4 4 (5.41%) SC Cleared
4 4 (5.41%) Security Cleared
5 1 (1.35%) Numerate Degree
Quality Assurance & Compliance
1 5 (6.76%) QA
2 2 (2.70%) SLA
System Software
1 5 (6.76%) Active Directory
2 1 (1.35%) HDFS
Systems Management
1 5 (6.76%) Microsoft Intune
1 5 (6.76%) SCCM
1 5 (6.76%) SCOM
1 5 (6.76%) SCSM
Vendors
1 74 (100.00%) Microsoft
2 36 (48.65%) Tableau
3 24 (32.43%) Oracle
4 6 (8.11%) JD Edwards
5 5 (6.76%) Google
6 1 (1.35%) SAP