Period
to 4 August 2020

The following table provides summary statistics for permanent job vacancies advertised in the City of London 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 4 August 2020 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
Central London > City of London
6 months to
4 Aug 2020
Same period 2019 Same period 2018
Rank 203 245 315
Rank change year-on-year +42 +70 -5
Permanent jobs citing Microsoft Analysis Services 29 88 35
As % of all permanent jobs advertised in the City of London 0.56% 0.86% 0.32%
As % of the Database & Business Intelligence category 2.34% 2.74% 1.00%
Number of salaries quoted 23 86 33
Median annual salary £72,500 £62,500 £65,000
Median salary % change year-on-year +16.00% -3.85% +8.33%
10th Percentile £66,250 £50,000 £48,000
90th Percentile £82,500 £87,500 £73,750
Central London median annual salary £72,500 £62,500 £65,000
% change year-on-year +16.00% -3.85% +8.33%

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 advertised in the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 1,237 3,212 3,486
As % of all permanent IT jobs advertised in the City of London 23.95% 31.42% 31.55%
Number of salaries quoted 1,056 2,894 3,155
Median annual salary £70,000 £67,500 £65,000
Median salary % change year-on-year +3.70% +3.85% +8.33%
10th Percentile £42,500 £42,500 £40,000
90th Percentile £96,250 £97,500 £92,500
Central London median annual salary £70,000 £65,000 £65,000
% change year-on-year +7.69% - +8.33%

Microsoft Analysis Services
Job Vacancy Trend in the City of London

Job postings citing Microsoft Analysis Services as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for Microsoft Analysis Services in the City of London

Microsoft Analysis Services
Salary Trend in the City of London

3-month moving average salary quoted in jobs citing Microsoft Analysis Services in the City of London.

Salary trend for Microsoft Analysis Services in the City of London

Microsoft Analysis Services
Salary Histogram in the City of London

Salary distribution for jobs citing Microsoft Analysis Services in the City of London over the 6 months to 4 August 2020.

Salary histogram for Microsoft Analysis Services in the City of London

For the 6 months to 4 August 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 across the City of London region with a requirement for Microsoft Analysis Services.

1 29 (100.00%) Business Intelligence
2 27 (93.10%) Microsoft
3 26 (89.66%) SQL Server Analysis Services
4 25 (86.21%) SQL Server
4 25 (86.21%) Power BI
4 25 (86.21%) Power Platform
5 24 (82.76%) Agile Software Development
6 22 (75.86%) Azure
7 21 (72.41%) Data Warehouse
8 19 (65.52%) SQL
9 18 (62.07%) SQL Server Integration Services
10 17 (58.62%) SQL Server Reporting Services
11 16 (55.17%) Azure SQL Database
12 15 (51.72%) Data Modelling
13 14 (48.28%) Analytical Skills
14 11 (37.93%) Data Analysis Expressions (DAX)
14 11 (37.93%) MDX
15 10 (34.48%) Finance
15 10 (34.48%) User Acceptance Testing
15 10 (34.48%) SDLC
15 10 (34.48%) Problem-Solving
16 8 (27.59%) Azure Data Factory
16 8 (27.59%) Data Lake
16 8 (27.59%) Performance Tuning
16 8 (27.59%) Snowflake Schema
17 7 (24.14%) C#
17 7 (24.14%) Release Management
17 7 (24.14%) Master Data Management
17 7 (24.14%) SQL Optimisation
17 7 (24.14%) SQL Server 2017

Microsoft Analysis Services
Co-occurring IT Skills in the City of London 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:

Applications
1 3 (10.34%) Microsoft Excel
Business Applications
1 3 (10.34%) Oracle General Ledger
1 3 (10.34%) Oracle Internet Expenses
1 3 (10.34%) Oracle iProcurement
1 3 (10.34%) Oracle Procure-to-Pay
Cloud Services
1 25 (86.21%) Power Platform
2 22 (75.86%) Azure
3 8 (27.59%) Azure Data Factory
4 6 (20.69%) IaaS
4 6 (20.69%) PaaS
5 5 (17.24%) SaaS
6 2 (6.90%) AWS
6 2 (6.90%) Data Lake Analytics
7 1 (3.45%) Office 365
7 1 (3.45%) PowerApps
Database & Business Intelligence
1 26 (89.66%) SQL Server Analysis Services
2 25 (86.21%) Power BI
2 25 (86.21%) SQL Server
3 21 (72.41%) Data Warehouse
4 18 (62.07%) SQL Server Integration Services
5 17 (58.62%) SQL Server Reporting Services
6 16 (55.17%) Azure SQL Database
7 8 (27.59%) Data Lake
7 8 (27.59%) Snowflake Schema
8 7 (24.14%) SQL Server 2017
9 4 (13.79%) OLAP
9 4 (13.79%) RDBMS
9 4 (13.79%) Relational Database
9 4 (13.79%) SQL Server 2016
10 3 (10.34%) Oracle BI Publisher
10 3 (10.34%) Oracle OLAP
10 3 (10.34%) Oracle Reports
11 2 (6.90%) Azure SQL Data Warehouse
11 2 (6.90%) PowerPivot
11 2 (6.90%) SSDT
Development Applications
1 4 (13.79%) Visual Studio
2 2 (6.90%) SQL Server Management Studio (SSMS)
2 2 (6.90%) Team Foundation Server
General
1 10 (34.48%) Finance
2 3 (10.34%) General Ledger
3 1 (3.45%) Law
Job Titles
1 19 (65.52%) Business Intelligence Developer
1 19 (65.52%) Developer
2 10 (34.48%) Senior Business Intelligence Developer
2 10 (34.48%) Senior Developer
3 6 (20.69%) Administrator
3 6 (20.69%) DBA
3 6 (20.69%) SQL DBA
4 4 (13.79%) Data Warehouse Developer
4 4 (13.79%) Junior
4 4 (13.79%) Junior Business Intelligence Developer
4 4 (13.79%) Junior Developer
4 4 (13.79%) SSAS Developer
5 3 (10.34%) Power BI Developer
5 3 (10.34%) SQL BI Developer
5 3 (10.34%) SQL Developer
6 2 (6.90%) Architect
6 2 (6.90%) Business Developer
6 2 (6.90%) Business Intelligence Architect
6 2 (6.90%) SSIS Developer
6 2 (6.90%) SSRS Developer
Libraries, Frameworks & Software Standards
1 11 (37.93%) MDX
2 3 (10.34%) .NET
2 3 (10.34%) ADO
2 3 (10.34%) Oracle Fusion
3 2 (6.90%) D3.js
3 2 (6.90%) Vue.js
Miscellaneous
1 14 (48.28%) Analytical Skills
2 6 (20.69%) Management Information System
3 4 (13.79%) Greenfield Project
4 3 (10.34%) User Experience
Operating Systems
1 6 (20.69%) Windows
1 6 (20.69%) Windows Server
Processes & Methodologies
1 29 (100.00%) Business Intelligence
2 24 (82.76%) Agile Software Development
3 15 (51.72%) Data Modelling
4 10 (34.48%) Problem-Solving
4 10 (34.48%) SDLC
4 10 (34.48%) User Acceptance Testing
5 8 (27.59%) Performance Tuning
6 7 (24.14%) Master Data Management
6 7 (24.14%) Release Management
6 7 (24.14%) SQL Optimisation
7 6 (20.69%) Change Management
7 6 (20.69%) Data Management
7 6 (20.69%) ITIL
7 6 (20.69%) Proactive Monitoring
7 6 (20.69%) Unit Testing
8 5 (17.24%) Business Analysis
8 5 (17.24%) Data Analysis
8 5 (17.24%) Risk Management
9 4 (13.79%) Requirements Gathering
10 3 (10.34%) Strategic Thinking
Programming Languages
1 19 (65.52%) SQL
2 11 (37.93%) Data Analysis Expressions (DAX)
3 7 (24.14%) C#
4 3 (10.34%) T-SQL
5 2 (6.90%) Java
5 2 (6.90%) Python
5 2 (6.90%) R
6 1 (3.45%) JavaScript
6 1 (3.45%) PowerShell
Vendors
1 27 (93.10%) Microsoft
2 6 (20.69%) Oracle
3 3 (10.34%) Tableau
4 1 (3.45%) OutSystems