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

Microsoft Analysis Services
UK
6 months to
13 Apr 2021
Same period 2020 Same period 2019
Rank 666 663 823
Rank change year-on-year -3 +160 -4
Permanent jobs citing Microsoft Analysis Services 172 334 310
As % of all permanent jobs advertised in the UK 0.21% 0.29% 0.21%
As % of the Database & Business Intelligence category 0.78% 1.09% 0.73%
Number of salaries quoted 130 298 241
10th Percentile £37,499 £41,250 £35,000
25th Percentile £42,500 £46,500 £45,000
Median annual salary (50th Percentile) £55,000 £70,000 £52,500
Median % change year-on-year -21.43% +33.33% +10.53%
75th Percentile £65,938 £95,000 £76,250
90th Percentile £75,000 £115,000 £86,250
UK excluding London median annual salary £45,000 £45,000 £45,000

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 21,917 30,681 42,357
As % of all permanent IT jobs advertised in the UK 26.39% 26.95% 28.45%
Number of salaries quoted 17,685 25,311 35,070
10th Percentile £33,750 £32,500 £31,250
25th Percentile £41,250 £40,000 £37,500
Median annual salary (50th Percentile) £55,000 £52,500 £52,500
Median % change year-on-year +4.76% - +5.00%
75th Percentile £73,750 £72,500 £70,000
90th Percentile £88,750 £88,750 £85,000
UK excluding London median annual salary £48,500 £45,000 £45,000
% change year-on-year +7.78% - +5.88%

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 13 April 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 13 April 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 -36 161 £55,000 -21.43% 52
London -30 94 £60,563 -19.25% 23
UK excluding London +91 67 £45,000 - 32
Work from Home -76 48 £60,563 +34.58% 10
North of England +58 33 £40,000 -15.79% 7
Yorkshire +23 20 £40,000 -6.62% 2
South East +82 15 £50,000 +11.11% 8
North West +33 13 £60,000 +20.00% 4
South West +13 9 £40,000 -11.11%
Midlands +28 8 £45,000 +20.00% 12
West Midlands +24 7 £45,000 -35.71% 10
East Midlands +10 1 £52,500 +50.00% 2
Wales - 1 - -
Scotland - 1 £57,500 - 3

For the 6 months to 13 April 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 157 (91.28%) SQL Server Analysis Services
2 156 (90.70%) SQL
3 150 (87.21%) Business Intelligence
4 148 (86.05%) SQL Server
5 137 (79.65%) Power BI
5 137 (79.65%) Power Platform
6 129 (75.00%) Azure
7 126 (73.26%) Data Warehouse
8 115 (66.86%) SQL Server Integration Services
9 105 (61.05%) Microsoft
10 95 (55.23%) SQL Server Reporting Services
11 85 (49.42%) Visualisation
12 81 (47.09%) Azure Data Factory
13 80 (46.51%) Analytics
14 75 (43.60%) ETL
15 72 (41.86%) T-SQL
16 64 (37.21%) Agile Software Development
17 63 (36.63%) Azure SQL Database
18 58 (33.72%) Data Modelling
19 55 (31.98%) DevOps
20 45 (26.16%) Azure SQL Data Warehouse
21 44 (25.58%) Data Visualisation
22 42 (24.42%) Data Management
23 41 (23.84%) Continuous Integration
24 40 (23.26%) Data Analysis Expressions (DAX)
24 40 (23.26%) Python
25 38 (22.09%) Finance
26 37 (21.51%) Tableau
27 36 (20.93%) Data Lake
28 34 (19.77%) 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 9 (5.23%) Apache Spark
2 7 (4.07%) SharePoint
3 5 (2.91%) Apache
3 5 (2.91%) Apache Synapse
4 2 (1.16%) OnBase
Applications
1 24 (13.95%) Microsoft Excel
2 9 (5.23%) Microsoft Office
3 1 (0.58%) Microsoft Project
Business Applications
1 7 (4.07%) Dynamics CRM
2 5 (2.91%) Dynamics AX
3 3 (1.74%) NetSuite
Cloud Services
1 137 (79.65%) Power Platform
2 129 (75.00%) Azure
3 81 (47.09%) Azure Data Factory
4 33 (19.19%) AWS
5 28 (16.28%) PaaS
6 20 (11.63%) Azure Stack
7 17 (9.88%) IaaS
8 14 (8.14%) Dynamics 365
9 12 (6.98%) Azure Functions
9 12 (6.98%) Serverless
10 10 (5.81%) Microsoft 365
11 6 (3.49%) Data Lake Analytics
11 6 (3.49%) GCP
12 4 (2.33%) PowerApps
13 3 (1.74%) Amazon EKS
13 3 (1.74%) AWS Lambda
13 3 (1.74%) Azure Active Directory
13 3 (1.74%) Logic Apps
14 2 (1.16%) Amazon EMR
14 2 (1.16%) IBM Cloud
Communications & Networking
1 2 (1.16%) FTP
Database & Business Intelligence
1 157 (91.28%) SQL Server Analysis Services
2 148 (86.05%) SQL Server
3 137 (79.65%) Power BI
4 126 (73.26%) Data Warehouse
5 115 (66.86%) SQL Server Integration Services
6 95 (55.23%) SQL Server Reporting Services
7 63 (36.63%) Azure SQL Database
8 45 (26.16%) Azure SQL Data Warehouse
9 37 (21.51%) Tableau
10 36 (20.93%) Data Lake
11 23 (13.37%) Cosmos DB
12 17 (9.88%) OLTP
13 14 (8.14%) SQL Server 2019
14 12 (6.98%) PowerPivot
14 12 (6.98%) Relational Database
15 11 (6.40%) OLAP
15 11 (6.40%) SQL Server 2016
16 10 (5.81%) Big Data
16 10 (5.81%) Data Mining
16 10 (5.81%) Oracle Reports
Development Applications
1 23 (13.37%) Team Foundation Server
2 8 (4.65%) Git (software)
2 8 (4.65%) Visual Studio
3 2 (1.16%) Atlassian Bamboo
3 2 (1.16%) Jenkins
3 2 (1.16%) SQL Server Management Studio (SSMS)
3 2 (1.16%) Vagrant
4 1 (0.58%) JIRA
4 1 (0.58%) NUnit
4 1 (0.58%) Postman
4 1 (0.58%) Toad
General
1 38 (22.09%) Finance
2 18 (10.47%) Marketing
3 11 (6.40%) Law
4 6 (3.49%) Advertising
5 3 (1.74%) Public Sector
6 2 (1.16%) Retail
7 1 (0.58%) Front Office
7 1 (0.58%) Social Housing
Job Titles
1 48 (27.91%) Data Engineer
2 38 (22.09%) Developer
3 35 (20.35%) Analyst
4 22 (12.79%) Business Intelligence Developer
5 20 (11.63%) Azure Engineer
5 20 (11.63%) Consultant
6 19 (11.05%) Azure Consultant
6 19 (11.05%) Data Consultant
7 18 (10.47%) Business Intelligence Analyst
8 17 (9.88%) Microsoft Engineer
9 15 (8.72%) Architect
9 15 (8.72%) Microsoft Consultant
10 14 (8.14%) Data Analyst
11 12 (6.98%) Power BI Analyst
12 11 (6.40%) Marketing Analyst
12 11 (6.40%) Marketing Data Analyst
13 10 (5.81%) Operations Analyst
13 10 (5.81%) Senior Data Engineer
14 9 (5.23%) Azure Architect
15 8 (4.65%) Power BI Developer
Libraries, Frameworks & Software Standards
1 15 (8.72%) .NET
2 14 (8.14%) MDX
3 12 (6.98%) XML
4 5 (2.91%) PySpark
5 3 (1.74%) ASP.NET
5 3 (1.74%) Spark Streaming
5 3 (1.74%) Web Services
6 2 (1.16%) .NET Framework
6 2 (1.16%) COM
6 2 (1.16%) CSS
6 2 (1.16%) HTML
6 2 (1.16%) HTML5
6 2 (1.16%) jQuery
6 2 (1.16%) Microsoft Graph
6 2 (1.16%) SOAP
6 2 (1.16%) WPF
7 1 (0.58%) Entity Framework
7 1 (0.58%) REST
7 1 (0.58%) XSLT
7 1 (0.58%) YAML
Miscellaneous
1 30 (17.44%) Analytical Skills
2 6 (3.49%) Data Structures
3 5 (2.91%) NHS
4 3 (1.74%) Greenfield Project
4 3 (1.74%) Hybrid Cloud
4 3 (1.74%) Management Information System
4 3 (1.74%) Reinsurance
4 3 (1.74%) Self-Motivation
5 2 (1.16%) Blog
5 2 (1.16%) Social Media
5 2 (1.16%) Wiki
6 1 (0.58%) Analytical Mindset
6 1 (0.58%) Client/Server
6 1 (0.58%) Clustering
6 1 (0.58%) Hedge funds
Operating Systems
1 10 (5.81%) Windows
2 5 (2.91%) Windows Server
3 4 (2.33%) Windows 10
3 4 (2.33%) Windows Server 2016
3 4 (2.33%) Windows Server 2019
4 1 (0.58%) Linux
4 1 (0.58%) Unix
4 1 (0.58%) Windows 7
Processes & Methodologies
1 150 (87.21%) Business Intelligence
2 85 (49.42%) Visualisation
3 80 (46.51%) Analytics
4 75 (43.60%) ETL
5 64 (37.21%) Agile Software Development
6 58 (33.72%) Data Modelling
7 55 (31.98%) DevOps
8 44 (25.58%) Data Visualisation
9 42 (24.42%) Data Management
10 41 (23.84%) Continuous Integration
11 34 (19.77%) Kimball Methodology
12 25 (14.53%) Data Analytics
13 21 (12.21%) Data Lineage
13 21 (12.21%) Dimensional Modelling
14 20 (11.63%) Data Governance
15 19 (11.05%) Data Architecture
16 18 (10.47%) Business Analysis
16 18 (10.47%) Data Analysis
16 18 (10.47%) Data Engineering
16 18 (10.47%) Unit Testing
Programming Languages
1 156 (90.70%) SQL
2 72 (41.86%) T-SQL
3 40 (23.26%) Data Analysis Expressions (DAX)
3 40 (23.26%) Python
4 24 (13.95%) C#
5 15 (8.72%) PowerShell
6 9 (5.23%) U-SQL
7 8 (4.65%) VB
8 6 (3.49%) JavaScript
9 5 (2.91%) PL/SQL
9 5 (2.91%) Scala
9 5 (2.91%) X++
10 4 (2.33%) R
11 3 (1.74%) C
11 3 (1.74%) Java
12 2 (1.16%) XAML
12 2 (1.16%) XPath
12 2 (1.16%) XQuery
13 1 (0.58%) Perl
13 1 (0.58%) VBA
Qualifications
1 20 (11.63%) Security Cleared
2 18 (10.47%) SC Cleared
3 10 (5.81%) Microsoft Certification
4 6 (3.49%) Degree
5 1 (0.58%) Numerate Degree
Quality Assurance & Compliance
1 33 (19.19%) Data Quality
2 11 (6.40%) QA
3 10 (5.81%) GDPR
System Software
1 10 (5.81%) Docker
2 8 (4.65%) Active Directory
3 2 (1.16%) VirtualBox
Systems Management
1 10 (5.81%) Kubernetes
2 3 (1.74%) Terraform
3 2 (1.16%) Ansible
3 2 (1.16%) Docker Swarm
4 1 (0.58%) Microsoft Clustering
Vendors
1 105 (61.05%) Microsoft
2 28 (16.28%) Databricks
3 19 (11.05%) Google
4 16 (9.30%) Oracle
5 9 (5.23%) Salesforce.com
6 4 (2.33%) Alteryx
7 3 (1.74%) Dynatrace
7 3 (1.74%) JD Edwards
7 3 (1.74%) SAP
7 3 (1.74%) Splunk
8 2 (1.16%) Cloudera
8 2 (1.16%) Hortonworks
8 2 (1.16%) Hyland
8 2 (1.16%) IBM
8 2 (1.16%) Informatica
8 2 (1.16%) MicroStrategy
8 2 (1.16%) Sage
8 2 (1.16%) Salesforce Marketing Cloud
8 2 (1.16%) Talend
9 1 (0.58%) Atlassian