Period
to 17 August 2019

The following table provides summary statistics for permanent job vacancies with a requirement for Microsoft Analysis Services skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Microsoft Analysis Services over the 6 months to 17 August 2019 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
UK
6 months to
17 Aug 2019
Same period 2018 Same period 2017
Rank 781 842 821
Rank change year-on-year +61 -21 -44
Permanent jobs citing Microsoft Analysis Services 316 338 408
As % of all permanent IT jobs advertised in the UK 0.22% 0.20% 0.23%
As % of the Database & Business Intelligence category 0.81% 0.66% 0.75%
Number of salaries quoted 276 293 362
UK median annual salary £60,000 £52,500 £45,000
Median salary % change year-on-year +14.29% +16.67% -10.00%
10th Percentile £38,250 £35,000 £33,750
90th Percentile £90,000 £73,750 £70,000
UK excluding London median annual salary £45,000 £43,500 £40,000
% change year-on-year +3.45% +8.75% -11.11%

Microsoft Analysis Services is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 38,949 51,270 54,120
As % of all permanent IT jobs advertised in the UK 27.26% 30.11% 30.70%
Number of salaries quoted 31,903 41,773 45,052
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £31,250 £30,000
90th Percentile £85,000 £82,500 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +3.66%

Microsoft Analysis Services
Job Vacancy Trend

Job postings citing Microsoft Analysis Services as a percentage of all IT jobs advertised.

Job vacancy trend for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Salary Trend

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

Salary trend for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Salary Histogram

The salary distribution of IT jobs citing Microsoft Analysis Services over the 6 months to 17 August 2019.

Salary histogram for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Top 13 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Microsoft Analysis Services within the UK over the 6 months to 17 August 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
England +75 313 £60,000 +14.29% 39
London +94 212 £70,000 +21.74% 13
UK excluding London +15 102 £45,000 +3.45% 26
North of England +39 40 £41,000 -13.68% 8
Midlands +45 29 £45,000 +5.88% 3
North West +44 29 £40,250 -15.26% 5
West Midlands +48 25 £45,000 -
South East +11 23 £47,500 -9.52% 8
Yorkshire +8 11 £45,000 -28.00% 3
East of England +52 5 £50,000 +25.00% 4
East Midlands +2 4 £38,000 -10.59% 3
South West -8 4 £52,500 +34.62% 3
Scotland +5 1 £42,500 +30.77%

For the 6 months to 17 August 2019, IT jobs citing Microsoft Analysis Services 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 with a requirement for Microsoft Analysis Services.

1 311 (98.42%) SQL Server Analysis Services
2 310 (98.10%) SQL Server
3 277 (87.66%) SQL
4 220 (69.62%) Business Intelligence
5 217 (68.67%) Microsoft
6 210 (66.46%) Power BI
6 210 (66.46%) Power Platform
7 209 (66.14%) SQL Server Integration Services
8 195 (61.71%) Data Warehouse
9 189 (59.81%) Microsoft Azure
10 179 (56.65%) SQL Server Reporting Services
11 134 (42.41%) Data Modelling
12 125 (39.56%) Agile Software Development
13 121 (38.29%) Azure Data Factory
14 120 (37.97%) Analytics
14 120 (37.97%) ETL
15 119 (37.66%) Azure SQL Database
16 115 (36.39%) Finance
17 101 (31.96%) Data Lake
18 98 (31.01%) Kimball Methodology
19 94 (29.75%) DevOps
19 94 (29.75%) Problem-Solving
20 92 (29.11%) Data Analysis Expressions (DAX)
21 87 (27.53%) Databricks
22 80 (25.32%) Data Analytics
23 76 (24.05%) Python
24 70 (22.15%) MDX
25 60 (18.99%) Scrum
26 59 (18.67%) T-SQL
27 53 (16.77%) C#

Microsoft Analysis Services
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 22 (6.96%) SharePoint
2 5 (1.58%) IIS
3 2 (0.63%) SharePoint 2013
4 1 (0.32%) Apache Pig
4 1 (0.32%) Apache Spark
4 1 (0.32%) MS Exchange
4 1 (0.32%) SAS
Applications
1 21 (6.65%) Microsoft Excel
2 7 (2.22%) Microsoft Office
2 7 (2.22%) Spreadsheet
3 1 (0.32%) MS Visio
Business Applications
1 6 (1.90%) OPENHousing
2 2 (0.63%) Dynamics AX
2 2 (0.63%) NetSuite
3 1 (0.32%) Dynamics CRM
3 1 (0.32%) Endur
Cloud Services
1 210 (66.46%) Power Platform
2 189 (59.81%) Microsoft Azure
3 121 (38.29%) Azure Data Factory
4 34 (10.76%) Amazon AWS
5 19 (6.01%) Azure Machine Learning
6 12 (3.80%) Azure Functions
6 12 (3.80%) Data Lake Analytics
6 12 (3.80%) Serverless
7 11 (3.48%) PaaS
8 7 (2.22%) Azure Stack
8 7 (2.22%) Dynamics 365
9 6 (1.90%) AWS CloudFormation
9 6 (1.90%) GitHub
10 5 (1.58%) PowerApps
11 3 (0.95%) Google Analytics
11 3 (0.95%) IaaS
12 1 (0.32%) Cloud Computing
12 1 (0.32%) Mimecast
12 1 (0.32%) Office 365
Communications & Networking
1 6 (1.90%) Network Security
2 5 (1.58%) FTP
3 1 (0.32%) DHCP
3 1 (0.32%) DNS
3 1 (0.32%) Firewall
3 1 (0.32%) VLAN
Database & Business Intelligence
1 311 (98.42%) SQL Server Analysis Services
2 310 (98.10%) SQL Server
3 210 (66.46%) Power BI
4 209 (66.14%) SQL Server Integration Services
5 195 (61.71%) Data Warehouse
6 179 (56.65%) SQL Server Reporting Services
7 119 (37.66%) Azure SQL Database
8 101 (31.96%) Data Lake
9 37 (11.71%) OLAP
10 35 (11.08%) SQL Server 2016
11 31 (9.81%) Azure SQL Data Warehouse
12 30 (9.49%) Relational Database
13 26 (8.23%) SQL Server 2012
14 24 (7.59%) SQL Server 2008
15 22 (6.96%) PostgreSQL
16 19 (6.01%) Big Data
17 18 (5.70%) SQL Server 2014
18 15 (4.75%) SQL Server 2005
19 13 (4.11%) PowerPivot
20 9 (2.85%) OLTP
Development Applications
1 15 (4.75%) Visual Studio
2 12 (3.80%) Git (software)
3 11 (3.48%) JIRA
4 9 (2.85%) SQL Server Management Studio (SSMS)
5 7 (2.22%) Zephyr
6 6 (1.90%) Atlassian Bamboo
6 6 (1.90%) Bitbucket
7 5 (1.58%) Team Foundation Server
8 2 (0.63%) Subversion
9 1 (0.32%) MSTest
9 1 (0.32%) NSubstitute
9 1 (0.32%) Rhino Mocks
9 1 (0.32%) SpecFlow
General
1 115 (36.39%) Finance
2 23 (7.28%) Telecoms
3 14 (4.43%) Retail
4 5 (1.58%) Banking
4 5 (1.58%) Marketing
5 3 (0.95%) Military
6 2 (0.63%) Financial Institution
6 2 (0.63%) Games
6 2 (0.63%) Legal
6 2 (0.63%) Manufacturing
7 1 (0.32%) Advertising
7 1 (0.32%) Investment Banking
Job Titles
1 163 (51.58%) Developer
2 104 (32.91%) Business Intelligence Developer
3 79 (25.00%) SQL Developer
4 45 (14.24%) SQL BI Developer
5 43 (13.61%) Azure Developer
6 40 (12.66%) Analyst
7 38 (12.03%) Business Intelligence Lead
8 36 (11.39%) Database Developer
9 35 (11.08%) SQL Database Developer
10 34 (10.76%) DBA
11 30 (9.49%) Lead Developer
11 30 (9.49%) Senior Developer
12 29 (9.18%) SQL DBA
13 27 (8.54%) Senior Business Intelligence Developer
14 23 (7.28%) Azure Specialist
14 23 (7.28%) Consultant
15 22 (6.96%) Business Intelligence Specialist
16 19 (6.01%) Microsoft Consultant
17 16 (5.06%) Administrator
17 16 (5.06%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 70 (22.15%) MDX
2 18 (5.70%) .NET
3 9 (2.85%) XML
4 4 (1.27%) .NET Framework
4 4 (1.27%) CSS
4 4 (1.27%) HTML
4 4 (1.27%) Web Services
5 3 (0.95%) Ajax
5 3 (0.95%) AngularJS
5 3 (0.95%) ASP.NET
5 3 (0.95%) D3.js
5 3 (0.95%) jQuery
5 3 (0.95%) Vue.js
6 2 (0.63%) .NET Core
6 2 (0.63%) ASP.NET Web Forms
6 2 (0.63%) COM
6 2 (0.63%) SOAP
6 2 (0.63%) XHTML
7 1 (0.32%) Middleware
7 1 (0.32%) RESTful
Miscellaneous
1 47 (14.87%) Analytical Skills
2 20 (6.33%) Management Information System
3 17 (5.38%) Replication
4 16 (5.06%) Clustering
5 12 (3.80%) Private Cloud
5 12 (3.80%) Public Cloud
6 11 (3.48%) Hedge funds
7 10 (3.16%) Greenfield Project
8 9 (2.85%) Self-Motivation
9 5 (1.58%) Data Structures
9 5 (1.58%) Smart Meter
10 3 (0.95%) Reinsurance
11 2 (0.63%) Fixed Income
12 1 (0.32%) Algorithms
12 1 (0.32%) Data Protection Act
12 1 (0.32%) Foreign Exchange (FX)
Operating Systems
1 34 (10.76%) Windows
2 30 (9.49%) Windows Server
3 4 (1.27%) Linux
4 3 (0.95%) Windows Server 2003
4 3 (0.95%) Windows Server 2008
4 3 (0.95%) Windows Server 2012
Processes & Methodologies
1 220 (69.62%) Business Intelligence
2 134 (42.41%) Data Modelling
3 125 (39.56%) Agile Software Development
4 120 (37.97%) Analytics
4 120 (37.97%) ETL
5 98 (31.01%) Kimball Methodology
6 94 (29.75%) DevOps
6 94 (29.75%) Problem-Solving
7 80 (25.32%) Data Analytics
8 60 (18.99%) Scrum
9 48 (15.19%) Kanban
10 36 (11.39%) Data Ingestion
11 31 (9.81%) Data Analysis
11 31 (9.81%) Stakeholder Engagement
12 29 (9.18%) Machine Learning
13 28 (8.86%) Change Management
13 28 (8.86%) ITIL
13 28 (8.86%) Proactive Monitoring
13 28 (8.86%) Visualisation
14 26 (8.23%) Unit Testing
Programming Languages
1 277 (87.66%) SQL
2 92 (29.11%) Data Analysis Expressions (DAX)
3 76 (24.05%) Python
4 59 (18.67%) T-SQL
5 53 (16.77%) C#
6 32 (10.13%) PowerShell
7 31 (9.81%) R
8 6 (1.90%) Bash Shell
8 6 (1.90%) VBA
9 5 (1.58%) JavaScript
10 4 (1.27%) Java
11 3 (0.95%) U-SQL
11 3 (0.95%) VBScript
12 2 (0.63%) C
12 2 (0.63%) VB.NET
13 1 (0.32%) Data Mining Extensions (DMX)
13 1 (0.32%) PHP
13 1 (0.32%) Scala
13 1 (0.32%) VB
13 1 (0.32%) X++
Qualifications
1 26 (8.23%) Degree
2 14 (4.43%) Microsoft Certification
3 8 (2.53%) Computer Science Degree
3 8 (2.53%) MCSA
4 6 (1.90%) ITIL Foundation Certificate
5 2 (0.63%) DBS Check
6 1 (0.32%) PhD
Quality Assurance & Compliance
1 12 (3.80%) SLA
2 9 (2.85%) Data Quality
3 8 (2.53%) QA
4 3 (0.95%) GDPR
5 2 (0.63%) PMO
6 1 (0.32%) ISO/IEC 27001
6 1 (0.32%) PCI DSS
System Software
1 13 (4.11%) VMware Infrastructure
2 7 (2.22%) Active Directory
2 7 (2.22%) Hyper-V
3 6 (1.90%) Docker
3 6 (1.90%) VMware Workstation
3 6 (1.90%) XenApp
4 4 (1.27%) Virtual Machines
Systems Management
1 9 (2.85%) Ansible
2 7 (2.22%) HP ALM
3 6 (1.90%) Kubernetes
3 6 (1.90%) Opscode Chef
3 6 (1.90%) Puppet
3 6 (1.90%) Terraform
4 5 (1.58%) Failover Clustering
4 5 (1.58%) Perfmon
5 3 (0.95%) WMI
6 2 (0.63%) Microsoft Clustering
7 1 (0.32%) SQL Sentry
Vendors
1 217 (68.67%) Microsoft
2 87 (27.53%) Databricks
3 46 (14.56%) Tableau
4 19 (6.01%) VMware
5 17 (5.38%) Veeam
6 9 (2.85%) Cognos
7 7 (2.22%) Google
7 7 (2.22%) HP
8 6 (1.90%) Atlassian
8 6 (1.90%) Capita
8 6 (1.90%) Citrix
9 5 (1.58%) RedGate
9 5 (1.58%) SolarWinds
10 2 (0.63%) IBM
10 2 (0.63%) JD Edwards
10 2 (0.63%) PeopleSoft
11 1 (0.32%) Facebook
11 1 (0.32%) Intapp
11 1 (0.32%) OpenLink
11 1 (0.32%) SnapLogic