Period
to 18 November 2019

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 18 November 2019 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
Central London > City of London
6 months to
18 Nov 2019
Same period 2018 Same period 2017
Rank 225 316 317
Rank change year-on-year +91 +1 -22
Permanent jobs citing Microsoft Analysis Services 103 34 13
As % of all permanent IT jobs advertised in the City of London 1.03% 0.31% 0.13%
As % of the Database & Business Intelligence category 3.52% 1.00% 0.41%
Number of salaries quoted 92 31 11
City of London median annual salary £62,500 £65,000 £85,000
Median salary % change year-on-year -3.85% -23.53% +47.83%
10th Percentile £47,500 £51,250 £57,500
90th Percentile £87,500 £78,750 £92,500
Central London median annual salary £62,500 £62,500 £65,000
% change year-on-year - -3.85% +13.04%

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 2,930 3,391 3,183
As % of all permanent IT jobs advertised in the City of London 29.41% 30.68% 31.25%
Number of salaries quoted 2,603 3,076 2,911
City of London median annual salary £70,000 £65,000 £60,000
Median salary % change year-on-year +7.69% +8.33% +4.35%
10th Percentile £42,500 £40,000 £40,750
90th Percentile £100,000 £95,000 £87,500
Central London median annual salary £67,500 £65,000 £60,000
% change year-on-year +3.85% +8.33% +9.09%

Microsoft Analysis Services
Job Vacancy Trend in the City of London

Job postings citing Microsoft Analysis Services as a percentage 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

This chart provides the 3-month moving average for salaries quoted in permanent IT 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

The salary distribution of IT jobs citing Microsoft Analysis Services in the City of London over the 6 months to 18 November 2019.

Salary histogram for Microsoft Analysis Services in the City of London

For the 6 months to 18 November 2019, 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 103 (100.00%) SQL Server
2 102 (99.03%) SQL Server Analysis Services
3 95 (92.23%) Power BI
3 95 (92.23%) Power Platform
4 87 (84.47%) Data Warehouse
5 78 (75.73%) Microsoft
6 77 (74.76%) SQL
7 70 (67.96%) Azure
8 58 (56.31%) Business Intelligence
9 57 (55.34%) SQL Server Integration Services
10 49 (47.57%) SQL Server Reporting Services
11 46 (44.66%) Problem-Solving
12 40 (38.83%) Windows Server
12 40 (38.83%) Windows
13 37 (35.92%) ITIL
13 37 (35.92%) DevOps
14 36 (34.95%) Proactive Monitoring
14 36 (34.95%) Change Management
14 36 (34.95%) AWS
14 36 (34.95%) User Acceptance Testing
15 31 (30.10%) Python
16 30 (29.13%) Finance
16 30 (29.13%) MDX
17 29 (28.16%) C#
17 29 (28.16%) Kimball Methodology
18 28 (27.18%) Azure SQL Database
18 28 (27.18%) Analytics
18 28 (27.18%) Data Modelling
18 28 (27.18%) ETL
19 27 (26.21%) Data Analysis

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:

Application Platforms
1 2 (1.94%) SharePoint
2 1 (0.97%) SharePoint 2010
2 1 (0.97%) SharePoint 2013
Applications
1 1 (0.97%) Microsoft Excel
Business Applications
1 1 (0.97%) Dynamics AX
Cloud Services
1 95 (92.23%) Power Platform
2 70 (67.96%) Azure
3 36 (34.95%) AWS
4 27 (26.21%) Azure Data Factory
5 6 (5.83%) AWS CloudFormation
5 6 (5.83%) GitHub
6 2 (1.94%) Cloud Computing
6 2 (1.94%) Mimecast
7 1 (0.97%) Azure Machine Learning
7 1 (0.97%) Dynamics 365
7 1 (0.97%) PaaS
7 1 (0.97%) PowerApps
Communications & Networking
1 6 (5.83%) Network Security
Database & Business Intelligence
1 103 (100.00%) SQL Server
2 102 (99.03%) SQL Server Analysis Services
3 95 (92.23%) Power BI
4 87 (84.47%) Data Warehouse
5 57 (55.34%) SQL Server Integration Services
6 49 (47.57%) SQL Server Reporting Services
7 28 (27.18%) Azure SQL Database
8 27 (26.21%) Data Lake
9 20 (19.42%) PostgreSQL
10 14 (13.59%) Relational Database
11 7 (6.80%) MySQL
12 6 (5.83%) SQL Server 2012
13 3 (2.91%) Cognos Framework Manager
13 3 (2.91%) OLAP
14 2 (1.94%) Azure SQL Data Warehouse
15 1 (0.97%) Cosmos DB
15 1 (0.97%) Snowflake Schema
15 1 (0.97%) SQL Server 2014
Development Applications
1 6 (5.83%) Atlassian Bamboo
1 6 (5.83%) Bitbucket
1 6 (5.83%) Git (software)
2 5 (4.85%) Visual Studio
3 1 (0.97%) SQL Server Management Studio (SSMS)
3 1 (0.97%) Visual Studio Team System
General
1 30 (29.13%) Finance
2 20 (19.42%) Telecoms
3 2 (1.94%) Marketing
3 2 (1.94%) Retail
4 1 (0.97%) Banking
4 1 (0.97%) Investment Banking
4 1 (0.97%) Public Sector
Job Titles
1 58 (56.31%) Developer
2 51 (49.51%) Business Intelligence Developer
3 23 (22.33%) DBA
3 23 (22.33%) SQL DBA
4 22 (21.36%) Database Developer
5 21 (20.39%) SQL Developer
6 19 (18.45%) Azure Developer
6 19 (18.45%) SQL BI Developer
6 19 (18.45%) SQL Database Developer
7 17 (16.50%) Administrator
8 15 (14.56%) Database Engineer
9 14 (13.59%) Azure Administrator
10 13 (12.62%) Power BI Developer
11 12 (11.65%) Business Intelligence Lead
11 12 (11.65%) Lead Developer
12 9 (8.74%) Cloud Engineer
13 6 (5.83%) AWS Engineer
13 6 (5.83%) AWS Infrastructure Engineer
13 6 (5.83%) Azure Engineer
13 6 (5.83%) VMware Infrastructure Engineer
Libraries, Frameworks & Software Standards
1 30 (29.13%) MDX
2 19 (18.45%) D3.js
2 19 (18.45%) Vue.js
3 3 (2.91%) RESTful
3 3 (2.91%) SOAP
4 2 (1.94%) .NET
4 2 (1.94%) COM
5 1 (0.97%) .NET Framework
5 1 (0.97%) ASP.NET
5 1 (0.97%) Middleware
5 1 (0.97%) Web Services
5 1 (0.97%) XML
Miscellaneous
1 24 (23.30%) Analytical Skills
2 22 (21.36%) Management Information System
3 17 (16.50%) Public Cloud
4 16 (15.53%) Self-Motivation
5 15 (14.56%) Private Cloud
6 1 (0.97%) Clustering
6 1 (0.97%) Data Structures
6 1 (0.97%) Reinsurance
6 1 (0.97%) Replication
Operating Systems
1 40 (38.83%) Windows
1 40 (38.83%) Windows Server
2 5 (4.85%) Linux
Processes & Methodologies
1 58 (56.31%) Business Intelligence
2 46 (44.66%) Problem-Solving
3 37 (35.92%) DevOps
3 37 (35.92%) ITIL
4 36 (34.95%) Change Management
4 36 (34.95%) Proactive Monitoring
4 36 (34.95%) User Acceptance Testing
5 29 (28.16%) Kimball Methodology
6 28 (27.18%) Analytics
6 28 (27.18%) Data Modelling
6 28 (27.18%) ETL
7 27 (26.21%) Data Analysis
8 26 (25.24%) Agile Software Development
9 25 (24.27%) Data Analytics
10 23 (22.33%) Visualisation
11 22 (21.36%) Decision-Making
11 22 (21.36%) Kanban
11 22 (21.36%) Scrum
12 19 (18.45%) Data Ingestion
12 19 (18.45%) Workflow
Programming Languages
1 77 (74.76%) SQL
2 31 (30.10%) Python
3 29 (28.16%) C#
4 26 (25.24%) Data Analysis Expressions (DAX)
5 19 (18.45%) Java
6 11 (10.68%) T-SQL
7 8 (7.77%) PowerShell
8 6 (5.83%) Bash Shell
9 4 (3.88%) R
10 1 (0.97%) VB
10 1 (0.97%) VB.NET
10 1 (0.97%) VBScript
10 1 (0.97%) X++
Qualifications
1 14 (13.59%) ITIL Foundation Certificate
2 1 (0.97%) Degree
2 1 (0.97%) Microsoft Certification
Quality Assurance & Compliance
1 2 (1.94%) Data Quality
System Software
1 6 (5.83%) Active Directory
1 6 (5.83%) Docker
1 6 (5.83%) Hyper-V
1 6 (5.83%) VMware Infrastructure
1 6 (5.83%) VMware Workstation
1 6 (5.83%) XenApp
2 4 (3.88%) Virtual Machines
Systems Management
1 6 (5.83%) Ansible
1 6 (5.83%) Kubernetes
1 6 (5.83%) Opscode Chef
1 6 (5.83%) Puppet
1 6 (5.83%) Terraform
2 1 (0.97%) Perfmon
Vendors
1 78 (75.73%) Microsoft
2 26 (25.24%) Databricks
3 15 (14.56%) Veeam
3 15 (14.56%) VMware
4 7 (6.80%) Tableau
5 6 (5.83%) Atlassian
5 6 (5.83%) Citrix
6 3 (2.91%) Cognos
7 1 (0.97%) Bloomberg
7 1 (0.97%) Calypso
7 1 (0.97%) Murex
7 1 (0.97%) Reuters
7 1 (0.97%) Sybase