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

Microsoft Analysis Services
UK
6 months to
24 Jan 2021
Same period 2020 Same period 2019
Rank 657 718 816
Rank change year-on-year +61 +98 +26
Permanent jobs citing Microsoft Analysis Services 111 321 320
As % of all permanent jobs advertised in the UK 0.17% 0.26% 0.21%
As % of the Database & Business Intelligence category 0.64% 0.94% 0.73%
Number of salaries quoted 107 288 278
Median annual salary £60,000 £70,000 £50,000
Median salary % change year-on-year -14.29% +40.00% +11.11%
10th Percentile £36,491 £40,875 £34,750
90th Percentile £75,250 £95,000 £77,500
UK excluding London median annual salary £46,250 £45,000 £45,000
% change year-on-year +2.78% - +9.76%

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 17,395 34,027 43,730
As % of all permanent IT jobs advertised in the UK 27.36% 27.07% 28.82%
Number of salaries quoted 14,576 28,178 36,317
Median annual salary £55,000 £52,500 £52,500
Median salary % change year-on-year +4.76% - +9.38%
10th Percentile £33,750 £32,000 £31,250
90th Percentile £87,500 £88,750 £85,000
UK excluding London median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - +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 24 January 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 24 January 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 +62 105 £60,000 -14.29% 24
London +59 62 £62,500 -13.79% 9
UK excluding London +166 43 £46,250 +2.78% 14
Work from Home -37 25 £62,500 +38.89% 1
North of England +70 16 £60,000 +45.15% 5
South East +143 13 £48,750 +8.33% 6
North West +65 12 £60,000 +51.90% 5
South West +61 8 £35,000 -22.22% 1
Midlands +65 5 £32,500 -13.91% 2
East Midlands +61 4 £32,500 -14.47%
Yorkshire +46 3 £45,000 -8.16%
East of England +98 1 - -
West Midlands +62 1 - - 2
North East - 1 £45,000 -

For the 6 months to 24 January 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 106 (95.50%) SQL
2 95 (85.59%) SQL Server Analysis Services
2 95 (85.59%) Azure
3 94 (84.68%) Data Warehouse
4 92 (82.88%) Business Intelligence
5 89 (80.18%) Power BI
5 89 (80.18%) Power Platform
6 87 (78.38%) SQL Server
7 82 (73.87%) Microsoft
8 64 (57.66%) SQL Server Integration Services
9 61 (54.95%) Azure Data Factory
9 61 (54.95%) Analytics
10 59 (53.15%) Visualisation
11 58 (52.25%) Azure SQL Database
11 58 (52.25%) SQL Server Reporting Services
12 47 (42.34%) Agile Software Development
12 47 (42.34%) ETL
13 45 (40.54%) DevOps
14 44 (39.64%) Data Modelling
14 44 (39.64%) T-SQL
15 41 (36.94%) Azure SQL Data Warehouse
16 37 (33.33%) Python
17 33 (29.73%) Continuous Integration
18 32 (28.83%) Data Lake
19 31 (27.93%) Data Analysis Expressions (DAX)
20 30 (27.03%) Data Visualisation
21 29 (26.13%) Data Analytics
22 27 (24.32%) Analytical Skills
22 27 (24.32%) Data Quality
22 27 (24.32%) AWS

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 3 (2.70%) Apache Spark
2 1 (0.90%) Apache Pig
2 1 (0.90%) IIS
2 1 (0.90%) Jupyter
Applications
1 11 (9.91%) Microsoft Excel
2 6 (5.41%) Microsoft Office
Business Applications
1 5 (4.50%) Dynamics CRM
Cloud Services
1 95 (85.59%) Azure
2 89 (80.18%) Power Platform
3 61 (54.95%) Azure Data Factory
4 27 (24.32%) AWS
5 26 (23.42%) PaaS
6 15 (13.51%) IaaS
7 10 (9.01%) Azure Stack
8 8 (7.21%) Data Lake Analytics
9 7 (6.31%) Azure Functions
9 7 (6.31%) Serverless
10 5 (4.50%) Azure Active Directory
10 5 (4.50%) Dynamics 365
10 5 (4.50%) Office 365
10 5 (4.50%) SaaS
11 4 (3.60%) Amazon EKS
11 4 (3.60%) AWS Lambda
12 3 (2.70%) GCP
13 2 (1.80%) Logic Apps
13 2 (1.80%) PowerApps
14 1 (0.90%) Azure Machine Learning
Database & Business Intelligence
1 95 (85.59%) SQL Server Analysis Services
2 94 (84.68%) Data Warehouse
3 89 (80.18%) Power BI
4 87 (78.38%) SQL Server
5 64 (57.66%) SQL Server Integration Services
6 58 (52.25%) Azure SQL Database
6 58 (52.25%) SQL Server Reporting Services
7 41 (36.94%) Azure SQL Data Warehouse
8 32 (28.83%) Data Lake
9 22 (19.82%) Cosmos DB
10 12 (10.81%) OLTP
10 12 (10.81%) Tableau
11 11 (9.91%) Oracle Reports
12 7 (6.31%) PolyBase
12 7 (6.31%) SQL Server 2008
13 6 (5.41%) Delta Lake
14 5 (4.50%) Oracle Database
14 5 (4.50%) Relational Database
14 5 (4.50%) SQL Server 2012
15 4 (3.60%) Hadoop
Development Applications
1 3 (2.70%) Team Foundation Server
1 3 (2.70%) Visual Studio
2 2 (1.80%) SQL Server Management Studio (SSMS)
3 1 (0.90%) ER Studio
3 1 (0.90%) ERwin
3 1 (0.90%) Git (software)
3 1 (0.90%) Jenkins
3 1 (0.90%) Visual Studio Team System
General
1 23 (20.72%) Finance
2 4 (3.60%) Public Sector
2 4 (3.60%) Retail
3 3 (2.70%) Marketing
4 2 (1.80%) Back Office
4 2 (1.80%) Financial Institution
5 1 (0.90%) iGaming
5 1 (0.90%) Legal
5 1 (0.90%) Manufacturing
5 1 (0.90%) Online Betting
5 1 (0.90%) Pharmaceutical
Job Titles
1 37 (33.33%) Data Engineer
2 24 (21.62%) Developer
3 17 (15.32%) Consultant
3 17 (15.32%) Data Consultant
4 16 (14.41%) Azure Consultant
4 16 (14.41%) Business Intelligence Developer
5 14 (12.61%) Analyst
5 14 (12.61%) Microsoft Engineer
6 11 (9.91%) Azure Developer
6 11 (9.91%) DBA
6 11 (9.91%) SQL DBA
7 10 (9.01%) Business Intelligence Lead
7 10 (9.01%) Microsoft Consultant
8 8 (7.21%) Azure Engineer
9 7 (6.31%) Administrator
9 7 (6.31%) Business Intelligence Analyst
9 7 (6.31%) Data Analytics Engineer
9 7 (6.31%) Lead Developer
9 7 (6.31%) Senior Consultant
10 6 (5.41%) Data Analyst
Libraries, Frameworks & Software Standards
1 8 (7.21%) MDX
2 5 (4.50%) .NET
3 3 (2.70%) XML
4 1 (0.90%) Anaconda
4 1 (0.90%) Apache Tez
4 1 (0.90%) Natural Language Processing
4 1 (0.90%) TensorFlow
4 1 (0.90%) Web Services
Miscellaneous
1 27 (24.32%) Analytical Skills
2 6 (5.41%) Data Structures
2 6 (5.41%) Management Information System
3 5 (4.50%) Hybrid Cloud
3 5 (4.50%) NHS
4 4 (3.60%) Client/Server
4 4 (3.60%) Greenfield Project
5 3 (2.70%) Clustering
5 3 (2.70%) User Experience
6 2 (1.80%) Cloud Native
6 2 (1.80%) Reinsurance
6 2 (1.80%) Replication
6 2 (1.80%) Wiki
7 1 (0.90%) Analytical Mindset
7 1 (0.90%) Self-Motivation
Operating Systems
1 10 (9.01%) Windows
2 5 (4.50%) Windows Server
2 5 (4.50%) Windows Server 2016
2 5 (4.50%) Windows Server 2019
Processes & Methodologies
1 92 (82.88%) Business Intelligence
2 61 (54.95%) Analytics
3 59 (53.15%) Visualisation
4 47 (42.34%) Agile Software Development
4 47 (42.34%) ETL
5 45 (40.54%) DevOps
6 44 (39.64%) Data Modelling
7 33 (29.73%) Continuous Integration
8 30 (27.03%) Data Visualisation
9 29 (26.13%) Data Analytics
10 24 (21.62%) Data Management
10 24 (21.62%) Kimball Methodology
11 23 (20.72%) Dimensional Modelling
12 19 (17.12%) Data Ingestion
13 17 (15.32%) Data Engineering
14 16 (14.41%) Problem-Solving
15 14 (12.61%) Continuous Deployment
15 14 (12.61%) Data Lineage
15 14 (12.61%) Mentoring
15 14 (12.61%) Metadata Management
Programming Languages
1 106 (95.50%) SQL
2 44 (39.64%) T-SQL
3 37 (33.33%) Python
4 31 (27.93%) Data Analysis Expressions (DAX)
5 14 (12.61%) PowerShell
6 9 (8.11%) C#
7 7 (6.31%) U-SQL
8 5 (4.50%) JavaScript
9 3 (2.70%) C
9 3 (2.70%) PL/SQL
9 3 (2.70%) R
Qualifications
1 18 (16.22%) Security Cleared
2 16 (14.41%) Microsoft Certification
2 16 (14.41%) SC Cleared
3 1 (0.90%) Degree
3 1 (0.90%) MCITP
Quality Assurance & Compliance
1 27 (24.32%) Data Quality
2 5 (4.50%) QA
System Software
1 8 (7.21%) Active Directory
2 5 (4.50%) Docker
Systems Management
1 5 (4.50%) Kubernetes
2 3 (2.70%) Microsoft Clustering
Vendors
1 82 (73.87%) Microsoft
2 25 (22.52%) Databricks
3 17 (15.32%) Oracle
4 15 (13.51%) Google
5 4 (3.60%) Dynatrace
5 4 (3.60%) Splunk
6 2 (1.80%) Alteryx
6 2 (1.80%) Facebook
6 2 (1.80%) SAP
7 1 (0.90%) Atlassian
7 1 (0.90%) OutSystems