Period
to 22 April 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 22 April 2019 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
UK
6 months to
22 Apr 2019
Same period 2018 Same period 2017
Rank 815 796 811
Rank change year-on-year -19 +15 -50
Permanent jobs citing Microsoft Analysis Services 297 414 400
As % of all permanent IT jobs advertised in the UK 0.20% 0.23% 0.23%
As % of the Database & Business Intelligence category 0.71% 0.76% 0.76%
Number of salaries quoted 232 372 362
UK median annual salary £52,500 £48,000 £45,000
Median salary % change year-on-year +9.38% +6.67% -5.26%
10th Percentile £36,250 £33,750 £33,750
90th Percentile £86,250 £65,000 £67,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - -5.56%

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 41,889 54,311 52,428
As % of all permanent IT jobs advertised in the UK 28.21% 30.61% 30.61%
Number of salaries quoted 34,217 45,253 44,697
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £30,500 £29,750
90th Percentile £85,000 £80,000 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +1.19%

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 22 April 2019.

Salary histogram for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Top 15 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 22 April 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 +4 284 £52,500 +10.53% 21
London +35 155 £62,500 +19.05% 7
UK excluding London +12 140 £45,000 +5.88% 14
Midlands +51 49 £45,000 -5.26% 1
East Midlands +50 36 £42,000 -0.59%
South East -24 27 £49,500 +10.00% 7
North of England +20 23 £41,750 +1.83% 6
South West +19 19 £30,750 -41.43%
West Midlands +14 13 £45,000 -5.26% 1
East of England +49 12 £50,000 +25.00%
North West +15 11 £38,750 -3.13% 5
Yorkshire +13 8 £60,000 +33.33% 1
Scotland +13 6 £87,500 +182.26%
Wales +13 5 £34,000 -43.33%
North East - 4 - -

For the 6 months to 22 April 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 294 (98.99%) SQL Server Analysis Services
2 291 (97.98%) SQL Server
3 253 (85.19%) SQL
4 238 (80.13%) Business Intelligence
5 237 (79.80%) SQL Server Integration Services
6 208 (70.03%) SQL Server Reporting Services
7 201 (67.68%) Data Warehouse
8 192 (64.65%) Microsoft
9 140 (47.14%) Microsoft Azure
10 134 (45.12%) Power BI
11 131 (44.11%) T-SQL
12 125 (42.09%) ETL
13 94 (31.65%) Azure SQL Database
14 90 (30.30%) Analytics
15 89 (29.97%) Agile Software Development
16 82 (27.61%) Data Modelling
17 78 (26.26%) Data Analysis Expressions (DAX)
17 78 (26.26%) Azure Data Factory
18 72 (24.24%) SQL Server 2016
19 71 (23.91%) MDX
20 65 (21.89%) Finance
20 65 (21.89%) Data Lake
21 64 (21.55%) Visualisation
22 61 (20.54%) Tableau
23 54 (18.18%) Kimball Methodology
23 54 (18.18%) Retail
24 52 (17.51%) Analytical Skills
25 49 (16.50%) SQL Server 2012
26 47 (15.82%) R
26 47 (15.82%) Scrum

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 42 (14.14%) SharePoint
2 33 (11.11%) SAS
3 11 (3.70%) IIS
4 4 (1.35%) SharePoint Server
5 3 (1.01%) SharePoint 2010
5 3 (1.01%) SharePoint 2013
6 2 (0.67%) Apache
6 2 (0.67%) Apache Pig
6 2 (0.67%) Apache Solr
6 2 (0.67%) Apache Spark
6 2 (0.67%) Jupyter
7 1 (0.34%) Elasticsearch
Applications
1 29 (9.76%) Microsoft Excel
2 5 (1.68%) Microsoft Office
3 2 (0.67%) SPSS
Business Applications
1 4 (1.35%) Markit EDM
2 3 (1.01%) Carpe Diem
2 3 (1.01%) Elite 3E
3 1 (0.34%) Dynamics CRM
Cloud Services
1 140 (47.14%) Microsoft Azure
2 78 (26.26%) Azure Data Factory
3 26 (8.75%) Amazon AWS
4 20 (6.73%) Azure Machine Learning
5 18 (6.06%) Data Lake Analytics
6 10 (3.37%) PaaS
7 8 (2.69%) SaaS
8 5 (1.68%) Office 365
9 4 (1.35%) Azure Functions
9 4 (1.35%) IaaS
9 4 (1.35%) Serverless
10 2 (0.67%) Apigee
10 2 (0.67%) Azure Active Directory
10 2 (0.67%) Boomi
10 2 (0.67%) GitHub
10 2 (0.67%) Google Analytics
10 2 (0.67%) iPaaS
11 1 (0.34%) Cloud Computing
11 1 (0.34%) Dynamics 365
11 1 (0.34%) Google Cloud Platform
Communications & Networking
1 3 (1.01%) Internet
2 2 (0.67%) Firewall
Database & Business Intelligence
1 294 (98.99%) SQL Server Analysis Services
2 291 (97.98%) SQL Server
3 237 (79.80%) SQL Server Integration Services
4 208 (70.03%) SQL Server Reporting Services
5 201 (67.68%) Data Warehouse
6 134 (45.12%) Power BI
7 94 (31.65%) Azure SQL Database
8 72 (24.24%) SQL Server 2016
9 65 (21.89%) Data Lake
10 49 (16.50%) SQL Server 2012
11 37 (12.46%) SQL Server 2008
12 33 (11.11%) OLAP
13 31 (10.44%) Big Data
14 30 (10.10%) Relational Database
14 30 (10.10%) SQL Server 2005
15 26 (8.75%) NoSQL
16 24 (8.08%) Hadoop
17 23 (7.74%) Azure SQL Data Warehouse
17 23 (7.74%) MongoDB
17 23 (7.74%) PostgreSQL
Development Applications
1 27 (9.09%) Team Foundation Server
2 23 (7.74%) Visual Studio
3 8 (2.69%) Git (software)
4 3 (1.01%) SQL Server Management Studio (SSMS)
4 3 (1.01%) Visual Studio Team System
5 2 (0.67%) Eclipse
5 2 (0.67%) ER Studio
5 2 (0.67%) ERwin
5 2 (0.67%) Jenkins
5 2 (0.67%) Maven
6 1 (0.34%) JIRA
General
1 65 (21.89%) Finance
2 54 (18.18%) Retail
3 38 (12.79%) Marketing
4 6 (2.02%) Banking
4 6 (2.02%) Telecoms
5 5 (1.68%) Law
6 3 (1.01%) Advertising
6 3 (1.01%) Games
7 2 (0.67%) Investment Banking
Job Titles
1 150 (50.51%) Developer
2 101 (34.01%) Business Intelligence Developer
3 61 (20.54%) DBA
4 53 (17.85%) SQL DBA
5 50 (16.84%) Senior Developer
6 45 (15.15%) SQL Developer
7 44 (14.81%) Senior Business Intelligence Developer
8 41 (13.80%) Administrator
9 36 (12.12%) Business Intelligence Lead
10 29 (9.76%) Consultant
11 28 (9.43%) Lead Developer
12 24 (8.08%) Data Warehouse Developer
13 23 (7.74%) Microsoft Consultant
13 23 (7.74%) SQL BI Developer
14 21 (7.07%) SSIS Developer
15 18 (6.06%) Analytics Consultant
16 17 (5.72%) Analyst
16 17 (5.72%) SSRS Developer
17 16 (5.39%) SSAS Developer
18 15 (5.05%) Azure Developer
Libraries, Frameworks & Software Standards
1 71 (23.91%) MDX
2 24 (8.08%) .NET
3 10 (3.37%) JSON
4 6 (2.02%) D3.js
5 4 (1.35%) REST
6 2 (0.67%) Anaconda
6 2 (0.67%) Apache NiFi
6 2 (0.67%) Apache Tez
6 2 (0.67%) Kafka
6 2 (0.67%) Natural Language Processing
6 2 (0.67%) OAuth
6 2 (0.67%) OpenID
6 2 (0.67%) SAML
6 2 (0.67%) TensorFlow
6 2 (0.67%) Web Services
6 2 (0.67%) XML
6 2 (0.67%) XSL
6 2 (0.67%) XSLT
7 1 (0.34%) ASP.NET
7 1 (0.34%) COM
Miscellaneous
1 52 (17.51%) Analytical Skills
2 44 (14.81%) Replication
3 43 (14.48%) Clustering
4 13 (4.38%) Greenfield Project
5 8 (2.69%) Data Structures
6 7 (2.36%) Hedge funds
7 6 (2.02%) Self-Motivation
8 5 (1.68%) Management Information System
9 3 (1.01%) Reinsurance
10 2 (0.67%) Fixed Income
10 2 (0.67%) PMI
10 2 (0.67%) Public Cloud
10 2 (0.67%) RIA
10 2 (0.67%) Virtual Team
11 1 (0.34%) Fintech
11 1 (0.34%) Tandem
11 1 (0.34%) User Experience
Operating Systems
1 16 (5.39%) Windows
2 5 (1.68%) Windows Server 2008
3 4 (1.35%) Windows Server
3 4 (1.35%) Windows Server 2012
4 3 (1.01%) Windows Server 2003
Processes & Methodologies
1 238 (80.13%) Business Intelligence
2 125 (42.09%) ETL
3 90 (30.30%) Analytics
4 89 (29.97%) Agile Software Development
5 82 (27.61%) Data Modelling
6 64 (21.55%) Visualisation
7 54 (18.18%) Kimball Methodology
8 47 (15.82%) Scrum
9 41 (13.80%) Data Analytics
10 37 (12.46%) Performance Tuning
10 37 (12.46%) Problem-Solving
11 34 (11.45%) DevOps
12 31 (10.44%) Dimensional Modelling
13 30 (10.10%) High Availability
14 29 (9.76%) CRM
14 29 (9.76%) Data Science
15 26 (8.75%) Machine Learning
16 25 (8.42%) Database Security
16 25 (8.42%) ITIL
17 24 (8.08%) Change Control
Programming Languages
1 253 (85.19%) SQL
2 131 (44.11%) T-SQL
3 78 (26.26%) Data Analysis Expressions (DAX)
4 47 (15.82%) R
5 37 (12.46%) Python
6 34 (11.45%) C#
7 29 (9.76%) PowerShell
8 8 (2.69%) JavaScript
9 6 (2.02%) U-SQL
10 5 (1.68%) VBA
11 4 (1.35%) Java
11 4 (1.35%) VB
12 3 (1.01%) VBScript
13 2 (0.67%) Bash Shell
13 2 (0.67%) C++
13 2 (0.67%) Perl
13 2 (0.67%) PHP
13 2 (0.67%) Ruby
13 2 (0.67%) XPath
14 1 (0.34%) VB.NET
Qualifications
1 44 (14.81%) Microsoft Certification
2 24 (8.08%) MCSA
3 17 (5.72%) Degree
4 11 (3.70%) MCSE
4 11 (3.70%) MCT
5 6 (2.02%) MCITP
6 2 (0.67%) CEH
6 2 (0.67%) PMI Certification
6 2 (0.67%) TOGAF Certification
7 1 (0.34%) Computer Science Degree
7 1 (0.34%) Numerate Degree
Quality Assurance & Compliance
1 29 (9.76%) QA
2 17 (5.72%) GDPR
3 12 (4.04%) SLA
4 10 (3.37%) Data Quality
5 3 (1.01%) PMO
6 2 (0.67%) Solvency II
7 1 (0.34%) ISO/IEC 27001
7 1 (0.34%) PCI DSS
System Software
1 23 (7.74%) VMware Infrastructure
2 5 (1.68%) Active Directory
Systems Management
1 21 (7.07%) Failover Clustering
1 21 (7.07%) Perfmon
2 5 (1.68%) Ansible
3 4 (1.35%) Microsoft Clustering
4 3 (1.01%) WMI
5 2 (0.67%) Ambari
5 2 (0.67%) Opscode Chef
5 2 (0.67%) Puppet
5 2 (0.67%) Salt
5 2 (0.67%) SQL Sentry
Vendors
1 192 (64.65%) Microsoft
2 61 (20.54%) Tableau
3 32 (10.77%) Databricks
4 23 (7.74%) VMware
5 21 (7.07%) RedGate
5 21 (7.07%) SolarWinds
5 21 (7.07%) Veeam
6 8 (2.69%) Oracle
7 4 (1.35%) Bloomberg
7 4 (1.35%) FactSet
7 4 (1.35%) IBM
8 3 (1.01%) Aderant
8 3 (1.01%) Facebook
8 3 (1.01%) Google
8 3 (1.01%) SAP
9 2 (0.67%) Axway
9 2 (0.67%) Cisco
9 2 (0.67%) Informatica
9 2 (0.67%) PeopleSoft
9 2 (0.67%) Red Hat