Period
to 25 October 2021

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 25 October 2021 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
UK
6 months to
25 Oct 2021
Same period 2020 Same period 2019
Rank 858 599 775
Rank change year-on-year -259 +176 +69
Permanent jobs citing Microsoft Analysis Services 192 89 310
As % of all permanent jobs advertised in the UK 0.15% 0.18% 0.23%
As % of the Database & Business Intelligence category 0.55% 0.63% 0.83%
Number of salaries quoted 176 66 265
10th Percentile £40,000 £41,875 £38,250
25th Percentile £45,938 £47,500 £45,000
Median annual salary (50th Percentile) £57,500 £60,000 £55,000
Median % change year-on-year -4.17% +9.09% +4.76%
75th Percentile £72,500 £78,438 £78,750
90th Percentile £78,750 £87,500 £87,500
UK excluding London median annual salary £47,500 £48,750 £45,000
% change year-on-year -2.56% +8.33% +5.88%

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 35,185 14,024 37,154
As % of all permanent IT jobs advertised in the UK 27.85% 28.69% 27.27%
Number of salaries quoted 22,520 11,928 30,811
10th Percentile £35,000 £33,750 £31,250
25th Percentile £42,500 £42,000 £38,250
Median annual salary (50th Percentile) £57,500 £55,000 £52,500
Median % change year-on-year +4.55% +4.76% +5.00%
75th Percentile £77,500 £72,500 £70,000
90th Percentile £95,000 £88,750 £86,250
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

Microsoft Analysis Services
Job Vacancy Trend

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

Job vacancy trend for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Salary Trend

3-month moving average salary quoted in jobs citing Microsoft Analysis Services.

Salary trend for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Salary Histogram

Salary distribution for jobs citing Microsoft Analysis Services over the 6 months to 25 October 2021.

Salary histogram for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Top 14 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 25 October 2021. 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 -240 181 £57,500 -4.17% 20
London -198 109 £65,000 -10.34% 10
UK excluding London -205 73 £47,500 -2.56% 10
North of England -112 35 £47,500 -9.52%
Work from Home -249 29 £53,750 -10.42%
Midlands -102 25 £45,000 -10.00% 5
North West -88 20 £48,750 -18.75%
West Midlands -92 20 £46,250 -7.50% 4
Yorkshire -82 15 £47,500 +5.56%
South East -161 6 £48,750 -2.50% 4
East Midlands -81 4 £40,000 +23.08% 1
South West -97 3 £47,500 +5.56% 1
Wales - 2 £45,000 -
Scotland - 2 £49,350 -

For the 6 months to 25 October 2021, 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 171 (89.06%) SQL Server Analysis Services
2 164 (85.42%) SQL
2 164 (85.42%) Business Intelligence
3 162 (84.38%) SQL Server
4 149 (77.60%) Microsoft
5 145 (75.52%) Power BI
5 145 (75.52%) Power Platform
6 133 (69.27%) Data Warehouse
7 127 (66.15%) Azure
8 105 (54.69%) SQL Server Integration Services
9 102 (53.13%) Analytics
10 100 (52.08%) Azure Data Factory
11 82 (42.71%) SQL Server Reporting Services
11 82 (42.71%) Data Modelling
12 72 (37.50%) Databricks
13 70 (36.46%) ETL
14 68 (35.42%) Azure Synapse Analytics
15 61 (31.77%) Visualisation
16 58 (30.21%) Agile Software Development
17 53 (27.60%) Data Lake
18 52 (27.08%) Azure SQL Database
19 44 (22.92%) Finance
20 43 (22.40%) DevOps
21 40 (20.83%) Data Visualisation
21 40 (20.83%) Tableau
22 37 (19.27%) T-SQL
23 36 (18.75%) Data Management
24 33 (17.19%) Data Analysis Expressions (DAX)
25 32 (16.67%) Python
26 30 (15.63%) Kimball Methodology

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 13 (6.77%) SharePoint
2 5 (2.60%) Apache Spark
3 4 (2.08%) FileNet
3 4 (2.08%) Papyrus
4 1 (0.52%) Apache
4 1 (0.52%) Apache Synapse
4 1 (0.52%) Elasticsearch
4 1 (0.52%) Oracle SOA Suite
4 1 (0.52%) SAS
Applications
1 27 (14.06%) Microsoft Excel
2 9 (4.69%) Microsoft Office
3 1 (0.52%) MS Visio
Business Applications
1 7 (3.65%) Dynamics AX
2 2 (1.04%) Dynamics CRM
2 2 (1.04%) NetSuite
Cloud Services
1 145 (75.52%) Power Platform
2 127 (66.15%) Azure
3 100 (52.08%) Azure Data Factory
4 68 (35.42%) Azure Synapse Analytics
5 21 (10.94%) AWS
6 18 (9.38%) Azure Cosmos DB
6 18 (9.38%) Dynamics 365
7 16 (8.33%) PaaS
8 13 (6.77%) Serverless
9 11 (5.73%) Microsoft 365
10 9 (4.69%) Azure Data Lake Analytics
10 9 (4.69%) Azure Functions
10 9 (4.69%) Azure Stack
11 7 (3.65%) PowerApps
11 7 (3.65%) SaaS
12 6 (3.13%) Azure Logic Apps
12 6 (3.13%) GitHub
13 5 (2.60%) Azure Storage
13 5 (2.60%) Power Automate
14 4 (2.08%) Azure Sentinel
Communications & Networking
1 2 (1.04%) Cisco ASA
1 2 (1.04%) Firewall
Database & Business Intelligence
1 171 (89.06%) SQL Server Analysis Services
2 162 (84.38%) SQL Server
3 145 (75.52%) Power BI
4 133 (69.27%) Data Warehouse
5 105 (54.69%) SQL Server Integration Services
6 82 (42.71%) SQL Server Reporting Services
7 53 (27.60%) Data Lake
8 52 (27.08%) Azure SQL Database
9 40 (20.83%) Tableau
10 27 (14.06%) Azure SQL Data Warehouse
11 24 (12.50%) OLAP
12 17 (8.85%) Relational Database
13 12 (6.25%) PolyBase
14 11 (5.73%) SQL Server 2016
15 10 (5.21%) OLTP
16 9 (4.69%) DTS
17 8 (4.17%) Data Mining
17 8 (4.17%) Data Vault
17 8 (4.17%) SQL Server 2012
18 7 (3.65%) Big Data
Development Applications
1 25 (13.02%) Visual Studio
2 13 (6.77%) Git (software)
3 10 (5.21%) Team Foundation Server
4 8 (4.17%) Jenkins
4 8 (4.17%) JIRA
5 5 (2.60%) SQL Server Management Studio (SSMS)
6 4 (2.08%) ER Studio
6 4 (2.08%) ERwin
6 4 (2.08%) GDB
6 4 (2.08%) NUnit
6 4 (2.08%) Postman
6 4 (2.08%) Subversion
6 4 (2.08%) Visual Studio Code
7 1 (0.52%) Atlassian Bamboo
7 1 (0.52%) Gradle
7 1 (0.52%) Sourcetree
7 1 (0.52%) Vagrant
General
1 44 (22.92%) Finance
2 27 (14.06%) Analytical Skills
3 25 (13.02%) Social Skills
4 9 (4.69%) Law
4 9 (4.69%) Retail
5 6 (3.13%) Inclusion and Diversity
6 5 (2.60%) Legal
7 4 (2.08%) Banking
7 4 (2.08%) Games
7 4 (2.08%) Public Sector
8 2 (1.04%) Advertising
8 2 (1.04%) Front Office
8 2 (1.04%) Presentation Skills
8 2 (1.04%) Publishing
9 1 (0.52%) Automotive
9 1 (0.52%) Manufacturing
Job Titles
1 69 (35.94%) Data Engineer
2 58 (30.21%) Developer
3 43 (22.40%) Azure Engineer
4 40 (20.83%) Business Intelligence Developer
5 25 (13.02%) Analyst
6 24 (12.50%) Architect
7 21 (10.94%) Data Architect
8 19 (9.90%) Senior Data Engineer
9 14 (7.29%) Business Intelligence Analyst
10 13 (6.77%) DBA
11 12 (6.25%) Azure Architect
12 10 (5.21%) SQL DBA
13 9 (4.69%) Business Developer
13 9 (4.69%) Data Warehouse Developer
14 8 (4.17%) Analyst Developer
14 8 (4.17%) Lead Developer
14 8 (4.17%) Senior DBA
14 8 (4.17%) Senior SQL DBA
15 6 (3.13%) Junior
15 6 (3.13%) Technical Leader
Libraries, Frameworks & Software Standards
1 28 (14.58%) MDX
2 14 (7.29%) .NET
3 10 (5.21%) REST
4 9 (4.69%) Middleware
5 8 (4.17%) HTML
6 6 (3.13%) Web Services
6 6 (3.13%) XML
7 5 (2.60%) .NET Framework
7 5 (2.60%) Entity Framework
7 5 (2.60%) PySpark
8 4 (2.08%) HTML5
8 4 (2.08%) jQuery
8 4 (2.08%) OAuth
8 4 (2.08%) RESTful
8 4 (2.08%) SOAP
8 4 (2.08%) XSLT
9 3 (1.56%) HTML5 Canvas
9 3 (1.56%) JSON
9 3 (1.56%) Spark Streaming
10 2 (1.04%) AngularJS
Miscellaneous
1 25 (13.02%) Management Information System
2 10 (5.21%) Public Cloud
3 4 (2.08%) Analytical Mindset
3 4 (2.08%) Online Games
4 3 (1.56%) Foreign Exchange (FX)
5 2 (1.04%) Greenfield Project
5 2 (1.04%) Legacy Systems
5 2 (1.04%) Self-Motivation
6 1 (0.52%) BYOD
6 1 (0.52%) Clustering
6 1 (0.52%) Data Structures
6 1 (0.52%) Housing Association
6 1 (0.52%) N-Tier
6 1 (0.52%) Replication
6 1 (0.52%) User Experience
Operating Systems
1 13 (6.77%) Windows
2 7 (3.65%) Windows 10
3 4 (2.08%) Linux
4 3 (1.56%) Windows Server
5 2 (1.04%) Windows 7
Processes & Methodologies
1 164 (85.42%) Business Intelligence
2 102 (53.13%) Analytics
3 82 (42.71%) Data Modelling
4 70 (36.46%) ETL
5 61 (31.77%) Visualisation
6 58 (30.21%) Agile Software Development
7 43 (22.40%) DevOps
8 40 (20.83%) Data Visualisation
9 36 (18.75%) Data Management
10 30 (15.63%) Kimball Methodology
11 24 (12.50%) Data Engineering
12 23 (11.98%) Migration
12 23 (11.98%) Scrum
13 22 (11.46%) Data Analytics
13 22 (11.46%) Stakeholder Management
13 22 (11.46%) Storytelling
14 21 (10.94%) Data Strategy
15 20 (10.42%) Release Management
16 19 (9.90%) Data Analysis
16 19 (9.90%) Dimensional Modelling
Programming Languages
1 164 (85.42%) SQL
2 37 (19.27%) T-SQL
3 33 (17.19%) Data Analysis Expressions (DAX)
4 32 (16.67%) Python
5 26 (13.54%) PowerShell
6 20 (10.42%) C#
7 13 (6.77%) U-SQL
8 6 (3.13%) X++
9 5 (2.60%) JavaScript
9 5 (2.60%) VB.NET
10 4 (2.08%) C
10 4 (2.08%) C++
10 4 (2.08%) Fortran
10 4 (2.08%) Java
10 4 (2.08%) Shell Script
11 3 (1.56%) Scala
11 3 (1.56%) VBA
12 2 (1.04%) Perl
13 1 (0.52%) PL/SQL
13 1 (0.52%) VB
Qualifications
1 17 (8.85%) Microsoft Certification
2 12 (6.25%) Degree
2 12 (6.25%) Security Cleared
3 3 (1.56%) SC Cleared
4 1 (0.52%) Computer Science Degree
4 1 (0.52%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 17 (8.85%) Data Quality
2 6 (3.13%) QA
3 1 (0.52%) SLA
System Software
1 2 (1.04%) Docker
2 1 (0.52%) Active Directory
2 1 (0.52%) VirtualBox
Systems Management
1 13 (6.77%) Terraform
2 4 (2.08%) Control-M
2 4 (2.08%) Kubernetes
3 2 (1.04%) Opscode Chef
3 2 (1.04%) Puppet
4 1 (0.52%) Ansible
4 1 (0.52%) Docker Swarm
4 1 (0.52%) Microsoft Intune
Vendors
1 149 (77.60%) Microsoft
2 72 (37.50%) Databricks
3 22 (11.46%) Oracle
4 19 (9.90%) Alteryx
5 8 (4.17%) Cognos
5 8 (4.17%) JD Edwards
6 6 (3.13%) Google
7 5 (2.60%) IBM
8 4 (2.08%) AppDynamics
8 4 (2.08%) HP
8 4 (2.08%) Netezza
8 4 (2.08%) Salesforce.com
8 4 (2.08%) ServiceNow
8 4 (2.08%) Splunk
8 4 (2.08%) Sybase
8 4 (2.08%) Teradata
9 3 (1.56%) Informatica
10 2 (1.04%) CheckPoint
10 2 (1.04%) Cisco
10 2 (1.04%) RedGate