Period
to 31 October 2020

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

Microsoft Analysis Services
UK
6 months to
31 Oct 2020
Same period 2019 Same period 2018
Rank 601 754 845
Rank change year-on-year +153 +91 0
Permanent jobs citing Microsoft Analysis Services 86 319 339
As % of all permanent jobs advertised in the UK 0.17% 0.23% 0.21%
As % of the Database & Business Intelligence category 0.61% 0.86% 0.70%
Number of salaries quoted 72 285 327
Median annual salary £60,000 £55,000 £52,500
Median salary % change year-on-year +9.09% +4.76% +16.67%
10th Percentile £37,875 £38,250 £34,750
90th Percentile £87,500 £87,500 £76,250
UK excluding London median annual salary £50,000 £45,000 £43,500
% change year-on-year +11.11% +3.45% +2.35%

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 14,105 37,241 48,511
As % of all permanent IT jobs advertised in the UK 28.37% 27.24% 29.55%
Number of salaries quoted 11,906 30,674 39,559
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +4.17%
10th Percentile £33,750 £31,250 £31,250
90th Percentile £87,500 £86,250 £83,000
UK excluding London median annual salary £48,000 £45,000 £45,000
% change year-on-year +6.67% - +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 31 October 2020.

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 31 October 2020. 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 +150 86 £60,000 +6.67% 14
London +109 44 £72,500 +5.45% 4
UK excluding London +238 42 £50,000 +11.11% 11
North of England +146 16 £60,000 +50.00% 6
Midlands +112 12 £36,250 -13.17% 2
North West +105 12 £60,000 +51.90% 4
Work from Home +11 10 £60,000 - 3
West Midlands +91 8 £50,000 +21.88%
South East +198 7 £50,000 +11.11% 1
East of England +143 4 - -
East Midlands +82 4 £32,500 -28.57% 2
South West +131 3 £45,000 +5.88% 1
North East - 3 £45,000 - 1
Yorkshire +113 1 £45,000 - 1

For the 6 months to 31 October 2020, 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 79 (91.86%) SQL
2 73 (84.88%) Data Warehouse
2 73 (84.88%) SQL Server Analysis Services
3 70 (81.40%) Business Intelligence
3 70 (81.40%) Power BI
3 70 (81.40%) Power Platform
4 67 (77.91%) Microsoft
5 65 (75.58%) SQL Server
6 60 (69.77%) Azure
7 41 (47.67%) SQL Server Reporting Services
8 38 (44.19%) SQL Server Integration Services
9 37 (43.02%) Data Modelling
9 37 (43.02%) Visualisation
9 37 (43.02%) Analytics
10 35 (40.70%) Azure SQL Database
11 29 (33.72%) ETL
11 29 (33.72%) Agile Software Development
11 29 (33.72%) Azure Data Factory
12 28 (32.56%) T-SQL
12 28 (32.56%) Python
13 27 (31.40%) Data Lake
14 26 (30.23%) Azure SQL Data Warehouse
14 26 (30.23%) Finance
14 26 (30.23%) Data Visualisation
14 26 (30.23%) Data Analytics
14 26 (30.23%) Analytical Skills
15 25 (29.07%) Databricks
16 22 (25.58%) Data Analysis Expressions (DAX)
17 19 (22.09%) Dimensional Modelling
18 17 (19.77%) DevOps

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 (3.49%) Confluence
2 2 (2.33%) IIS
2 2 (2.33%) SharePoint
3 1 (1.16%) Apache
3 1 (1.16%) Apache Pig
3 1 (1.16%) Apache Spark
3 1 (1.16%) Apache Synapse
3 1 (1.16%) Jupyter
3 1 (1.16%) Oracle SOA Suite
Applications
1 16 (18.60%) Microsoft Excel
2 6 (6.98%) Microsoft Office
Business Applications
1 2 (2.33%) Oracle General Ledger
1 2 (2.33%) Oracle Internet Expenses
1 2 (2.33%) Oracle iProcurement
1 2 (2.33%) Oracle Procure-to-Pay
2 1 (1.16%) Dynamics CRM
Cloud Services
1 70 (81.40%) Power Platform
2 60 (69.77%) Azure
3 29 (33.72%) Azure Data Factory
4 16 (18.60%) PaaS
5 10 (11.63%) SaaS
6 8 (9.30%) Data Lake Analytics
6 8 (9.30%) IaaS
7 7 (8.14%) AWS
8 5 (5.81%) Serverless
9 4 (4.65%) Azure Functions
10 3 (3.49%) PowerApps
11 2 (2.33%) Azure Active Directory
11 2 (2.33%) Azure Machine Learning
11 2 (2.33%) Azure Stack
12 1 (1.16%) Amazon EKS
12 1 (1.16%) AWS Lambda
12 1 (1.16%) GCP
12 1 (1.16%) Logic Apps
12 1 (1.16%) OpenShift
12 1 (1.16%) Power Automate
Communications & Networking
1 1 (1.16%) AMQP
Database & Business Intelligence
1 73 (84.88%) Data Warehouse
1 73 (84.88%) SQL Server Analysis Services
2 70 (81.40%) Power BI
3 65 (75.58%) SQL Server
4 41 (47.67%) SQL Server Reporting Services
5 38 (44.19%) SQL Server Integration Services
6 35 (40.70%) Azure SQL Database
7 27 (31.40%) Data Lake
8 26 (30.23%) Azure SQL Data Warehouse
9 12 (13.95%) Cosmos DB
10 8 (9.30%) OLTP
11 7 (8.14%) PolyBase
11 7 (8.14%) Tableau
12 6 (6.98%) SQL Server 2017
13 5 (5.81%) Oracle Reports
13 5 (5.81%) SQL Server 2016
13 5 (5.81%) SSDT
14 4 (4.65%) Crystal Reports
14 4 (4.65%) OLAP
14 4 (4.65%) Snowflake Schema
Development Applications
1 9 (10.47%) Visual Studio
2 3 (3.49%) GitLab
2 3 (3.49%) JIRA
3 2 (2.33%) ER Studio
3 2 (2.33%) ERwin
3 2 (2.33%) Git (software)
3 2 (2.33%) Jenkins
3 2 (2.33%) SQL Server Management Studio (SSMS)
4 1 (1.16%) GDB
4 1 (1.16%) Octopus Deploy
4 1 (1.16%) Sourcetree
4 1 (1.16%) TeamCity
4 1 (1.16%) Visual Studio Code
4 1 (1.16%) Visual Studio Team System
General
1 26 (30.23%) Finance
2 10 (11.63%) Back Office
3 3 (3.49%) Marketing
4 2 (2.33%) Financial Institution
4 2 (2.33%) General Ledger
4 2 (2.33%) Retail
5 1 (1.16%) iGaming
5 1 (1.16%) Legal
5 1 (1.16%) Manufacturing
5 1 (1.16%) Online Betting
5 1 (1.16%) Pharmaceutical
5 1 (1.16%) Police
5 1 (1.16%) Public Sector
Job Titles
1 34 (39.53%) Developer
2 26 (30.23%) Business Intelligence Developer
3 24 (27.91%) Data Engineer
4 12 (13.95%) Analyst
5 11 (12.79%) Business Intelligence Lead
5 11 (12.79%) Consultant
5 11 (12.79%) Data Consultant
5 11 (12.79%) Senior Developer
6 10 (11.63%) Azure Consultant
6 10 (11.63%) Lead Developer
6 10 (11.63%) Senior Business Intelligence Developer
7 9 (10.47%) Azure Developer
7 9 (10.47%) Azure Engineer
7 9 (10.47%) SQL Developer
8 8 (9.30%) Architect
8 8 (9.30%) DBA
8 8 (9.30%) SQL Analyst
8 8 (9.30%) SQL DBA
9 7 (8.14%) Business Intelligence Consultant
9 7 (8.14%) Data Architect
Libraries, Frameworks & Software Standards
1 10 (11.63%) MDX
2 6 (6.98%) .NET
3 3 (3.49%) D3.js
3 3 (3.49%) Vue.js
4 2 (2.33%) ADO
4 2 (2.33%) Oracle Fusion
5 1 (1.16%) .NET Core
5 1 (1.16%) Anaconda
5 1 (1.16%) Apache Tez
5 1 (1.16%) Kafka
5 1 (1.16%) Natural Language Processing
5 1 (1.16%) Node.js
5 1 (1.16%) REST
5 1 (1.16%) RESTful
5 1 (1.16%) Spring
5 1 (1.16%) Spring Boot
5 1 (1.16%) TensorFlow
Miscellaneous
1 26 (30.23%) Analytical Skills
2 6 (6.98%) Management Information System
3 5 (5.81%) User Experience
4 4 (4.65%) Client/Server
4 4 (4.65%) Self-Motivation
5 3 (3.49%) Cloud Native
5 3 (3.49%) Clustering
5 3 (3.49%) Replication
6 2 (2.33%) Data Structures
6 2 (2.33%) Greenfield Project
6 2 (2.33%) Hybrid Cloud
7 1 (1.16%) Analytical Mindset
7 1 (1.16%) N-Tier
7 1 (1.16%) Private Cloud
7 1 (1.16%) Wiki
Operating Systems
1 7 (8.14%) Windows
2 1 (1.16%) Windows Server
2 1 (1.16%) Windows Server 2016
2 1 (1.16%) Windows Server 2019
Processes & Methodologies
1 70 (81.40%) Business Intelligence
2 37 (43.02%) Analytics
2 37 (43.02%) Data Modelling
2 37 (43.02%) Visualisation
3 29 (33.72%) Agile Software Development
3 29 (33.72%) ETL
4 26 (30.23%) Data Analytics
4 26 (30.23%) Data Visualisation
5 19 (22.09%) Dimensional Modelling
6 17 (19.77%) DevOps
6 17 (19.77%) Performance Tuning
7 16 (18.60%) Kimball Methodology
7 16 (18.60%) Problem-Solving
8 15 (17.44%) Data Engineering
9 10 (11.63%) Continuous Improvement
9 10 (11.63%) Data Analysis
10 9 (10.47%) Data Management
10 9 (10.47%) Data Transformation
10 9 (10.47%) SDLC
10 9 (10.47%) Validation
Programming Languages
1 79 (91.86%) SQL
2 28 (32.56%) Python
2 28 (32.56%) T-SQL
3 22 (25.58%) Data Analysis Expressions (DAX)
4 10 (11.63%) C#
5 8 (9.30%) PowerShell
6 7 (8.14%) U-SQL
7 4 (4.65%) JavaScript
8 3 (3.49%) Java
8 3 (3.49%) PL/SQL
9 2 (2.33%) VB.NET
10 1 (1.16%) ANSI SQL
10 1 (1.16%) R
10 1 (1.16%) Scala
Qualifications
1 13 (15.12%) Microsoft Certification
2 3 (3.49%) Degree
3 2 (2.33%) Computer Science Degree
3 2 (2.33%) MCITP
3 2 (2.33%) MCSA
4 1 (1.16%) SC Cleared
4 1 (1.16%) Security Cleared
Quality Assurance & Compliance
1 13 (15.12%) Data Quality
2 1 (1.16%) GDPR
System Software
1 3 (3.49%) Active Directory
1 3 (3.49%) Docker
Systems Management
1 3 (3.49%) Microsoft Clustering
2 2 (2.33%) Kubernetes
3 1 (1.16%) Ansible
3 1 (1.16%) Control-M
3 1 (1.16%) Opscode Chef
3 1 (1.16%) Puppet
3 1 (1.16%) Terraform
Vendors
1 67 (77.91%) Microsoft
2 25 (29.07%) Databricks
3 10 (11.63%) Oracle
4 5 (5.81%) Google
5 4 (4.65%) SAP
6 3 (3.49%) Alteryx
7 2 (2.33%) Facebook
7 2 (2.33%) IBM
8 1 (1.16%) Actuate
8 1 (1.16%) Cognos
8 1 (1.16%) Dynatrace
8 1 (1.16%) Netezza
8 1 (1.16%) OutSystems
8 1 (1.16%) Red Hat
8 1 (1.16%) Splunk
8 1 (1.16%) Teradata