Period
to 28 March 2020

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for SQL Server Analysis Services skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL Server Analysis Services over the 6 months to 28 March 2020 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
Central London > City of London
6 months to
28 Mar 2020
Same period 2019 Same period 2018
Rank 142 159 107
Rank change year-on-year +17 -52 -24
Permanent jobs citing SQL Server Analysis Services 171 187 306
As % of all permanent jobs advertised in the City of London 1.94% 1.81% 2.87%
As % of the Database & Business Intelligence category 7.96% 6.00% 9.19%
Number of salaries quoted 168 185 268
Median annual salary £70,000 £62,500 £60,000
Median salary % change year-on-year +12.00% +4.17% -
10th Percentile £47,500 £42,750 £42,500
90th Percentile £78,750 £86,250 £76,250
Central London median annual salary £70,000 £62,500 £60,000
% change year-on-year +12.00% +4.17% -

SQL Server 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,149 3,115 3,331
As % of all permanent IT jobs advertised in the City of London 24.39% 30.22% 31.20%
Number of salaries quoted 1,872 2,795 2,963
Median annual salary £67,500 £65,000 £62,500
Median salary % change year-on-year +3.85% +4.00% +4.17%
10th Percentile £42,500 £41,250 £41,250
90th Percentile £100,000 £96,250 £90,000
Central London median annual salary £69,250 £65,000 £60,000
% change year-on-year +6.54% +8.33% +4.35%

SQL Server Analysis Services
Job Vacancy Trend in the City of London

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

Job vacancy trend for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Salary Trend in the City of London

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

Salary trend for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Salary Histogram in the City of London

Salary distribution for jobs citing SQL Server Analysis Services in the City of London over the 6 months to 28 March 2020.

Salary histogram for SQL Server Analysis Services in the City of London

For the 6 months to 28 March 2020, IT jobs citing SQL Server 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 SQL Server Analysis Services.

1 150 (87.72%) SQL Server Integration Services
2 131 (76.61%) SQL
3 99 (57.89%) Power BI
3 99 (57.89%) Power Platform
4 98 (57.31%) SQL Server
5 97 (56.73%) Business Intelligence
6 95 (55.56%) SQL Server Reporting Services
7 79 (46.20%) Data Warehouse
8 73 (42.69%) Microsoft
9 59 (34.50%) Azure
10 58 (33.92%) T-SQL
11 53 (30.99%) ITIL
11 53 (30.99%) Analytical Skills
12 52 (30.41%) .NET
13 50 (29.24%) Microsoft Analysis Services
13 50 (29.24%) User Acceptance Testing
14 49 (28.65%) C#
15 44 (25.73%) Finance
16 38 (22.22%) Data Analysis Expressions (DAX)
17 37 (21.64%) Reinsurance
18 36 (21.05%) Degree
19 35 (20.47%) Agile Software Development
20 34 (19.88%) XML
21 33 (19.30%) Migration
21 33 (19.30%) Disaster Recovery
22 32 (18.71%) Service Management
22 32 (18.71%) Data Security
22 32 (18.71%) AS400
22 32 (18.71%) RPG
22 32 (18.71%) DB2

SQL Server 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 12 (7.02%) SharePoint
2 2 (1.17%) Confluence
2 2 (1.17%) SharePoint Server
3 1 (0.58%) SAS
3 1 (0.58%) SharePoint 2010
3 1 (0.58%) SharePoint 2013
Applications
1 5 (2.92%) Microsoft Excel
1 5 (2.92%) Microsoft Office
2 1 (0.58%) MS Visio
Business Applications
1 2 (1.17%) RiskWrite
Cloud Services
1 99 (57.89%) Power Platform
2 59 (34.50%) Azure
3 13 (7.60%) Azure Data Factory
4 11 (6.43%) AWS
5 9 (5.26%) IaaS
5 9 (5.26%) PaaS
6 3 (1.75%) Data Lake Analytics
6 3 (1.75%) Office 365
7 2 (1.17%) NuGet
8 1 (0.58%) Cloud Computing
8 1 (0.58%) Mimecast
8 1 (0.58%) SaaS
Communications & Networking
1 2 (1.17%) Internet
1 2 (1.17%) Intranet
1 2 (1.17%) Kerberos
2 1 (0.58%) SAN
Database & Business Intelligence
1 150 (87.72%) SQL Server Integration Services
2 99 (57.89%) Power BI
3 98 (57.31%) SQL Server
4 95 (55.56%) SQL Server Reporting Services
5 79 (46.20%) Data Warehouse
6 50 (29.24%) Microsoft Analysis Services
7 32 (18.71%) DB2
8 22 (12.87%) Data Lake
9 17 (9.94%) Azure SQL Database
10 12 (7.02%) SQL Server 2008
11 11 (6.43%) Relational Database
12 10 (5.85%) QlikView
13 9 (5.26%) SQL Server 2016
14 8 (4.68%) Crystal Reports
14 8 (4.68%) SQL Server 2012
15 5 (2.92%) OLAP
15 5 (2.92%) PowerPivot
16 4 (2.34%) Big Data
16 4 (2.34%) SQL Server 2017
17 3 (1.75%) Azure SQL Data Warehouse
Development Applications
1 23 (13.45%) Team Foundation Server
2 17 (9.94%) Visual Studio
3 13 (7.60%) SQL Server Management Studio (SSMS)
4 6 (3.51%) Visual Studio Team System
5 5 (2.92%) JIRA
6 2 (1.17%) Atlassian Bamboo
6 2 (1.17%) Bitbucket
6 2 (1.17%) Eclipse
6 2 (1.17%) FishEye
6 2 (1.17%) Git (software)
6 2 (1.17%) SonarQube
6 2 (1.17%) Sonatype Nexus
General
1 44 (25.73%) Finance
2 9 (5.26%) Law
3 5 (2.92%) Banking
4 3 (1.75%) Marketing
5 2 (1.17%) Investment Banking
5 2 (1.17%) Retail
Job Titles
1 66 (38.60%) Developer
2 49 (28.65%) Analyst
3 45 (26.32%) Administrator
4 44 (25.73%) Business Intelligence Developer
5 40 (23.39%) SQL Analyst
6 32 (18.71%) SQL Support Analyst
6 32 (18.71%) Support Analyst
7 29 (16.96%) DBA
7 29 (16.96%) SQL DBA
8 20 (11.70%) SQL Developer
9 15 (8.77%) Power BI Developer
10 11 (6.43%) .NET Developer
10 11 (6.43%) Business Intelligence Analyst
10 11 (6.43%) C# Developer
11 9 (5.26%) Business Developer
11 9 (5.26%) C# .NET Developer
11 9 (5.26%) C# VB.NET Developer
11 9 (5.26%) Technical Leader
11 9 (5.26%) VB.NET Developer
12 8 (4.68%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 52 (30.41%) .NET
2 34 (19.88%) XML
3 20 (11.70%) MDX
4 11 (6.43%) ASP.NET
4 11 (6.43%) D3.js
4 11 (6.43%) Vue.js
5 9 (5.26%) ASP.NET MVC
6 7 (4.09%) RESTful
6 7 (4.09%) SOAP
7 4 (2.34%) Web Services
8 3 (1.75%) AngularJS
9 2 (1.17%) WCF
9 2 (1.17%) XSL
9 2 (1.17%) XSLT
10 1 (0.58%) ASP.NET Web API
10 1 (0.58%) MSMQ
10 1 (0.58%) RabbitMQ
10 1 (0.58%) REST
10 1 (0.58%) WinForms
10 1 (0.58%) WPF
Miscellaneous
1 53 (30.99%) Analytical Skills
2 37 (21.64%) Reinsurance
3 32 (18.71%) AS400
3 32 (18.71%) iSeries
4 13 (7.60%) Management Information System
5 5 (2.92%) Self-Motivation
6 4 (2.34%) Greenfield Project
7 3 (1.75%) Analytical Mindset
7 3 (1.75%) Foreign Exchange (FX)
7 3 (1.75%) Replication
8 2 (1.17%) Clustering
8 2 (1.17%) Public Cloud
8 2 (1.17%) SWIFT
9 1 (0.58%) Data Centre
Operating Systems
1 18 (10.53%) Windows
2 15 (8.77%) Windows Server
3 3 (1.75%) Linux
4 2 (1.17%) Unix
5 1 (0.58%) Windows Server 2003
Processes & Methodologies
1 97 (56.73%) Business Intelligence
2 53 (30.99%) ITIL
3 50 (29.24%) User Acceptance Testing
4 35 (20.47%) Agile Software Development
5 33 (19.30%) Disaster Recovery
5 33 (19.30%) Migration
6 32 (18.71%) Computer Science
6 32 (18.71%) Data Security
6 32 (18.71%) Service Management
6 32 (18.71%) Tech Ops
7 30 (17.54%) DevOps
7 30 (17.54%) Visualisation
8 25 (14.62%) ETL
9 22 (12.87%) Analytics
10 20 (11.70%) Data Modelling
11 18 (10.53%) Data Visualisation
11 18 (10.53%) Performance Tuning
12 17 (9.94%) Change Management
13 15 (8.77%) Data Analysis
13 15 (8.77%) Problem-Solving
Programming Languages
1 131 (76.61%) SQL
2 58 (33.92%) T-SQL
3 49 (28.65%) C#
4 38 (22.22%) Data Analysis Expressions (DAX)
5 32 (18.71%) RPG
6 22 (12.87%) Python
7 18 (10.53%) Java
8 17 (9.94%) R
9 13 (7.60%) VB.NET
10 9 (5.26%) PowerShell
11 4 (2.34%) VBA
11 4 (2.34%) VBScript
12 3 (1.75%) PL/SQL
12 3 (1.75%) VB
13 2 (1.17%) VB6
Qualifications
1 36 (21.05%) Degree
2 32 (18.71%) Computer Science Degree
3 4 (2.34%) ITIL Foundation Certificate
3 4 (2.34%) Microsoft Certification
4 3 (1.75%) MCSA
Quality Assurance & Compliance
1 3 (1.75%) Data Quality
2 2 (1.17%) SLA
System Software
1 2 (1.17%) Active Directory
1 2 (1.17%) Docker
2 1 (0.58%) Virtual Machines
Systems Management
1 2 (1.17%) Ansible
1 2 (1.17%) Kubernetes
2 1 (0.58%) Control-M
2 1 (0.58%) Failover Clustering
2 1 (0.58%) Perfmon
2 1 (0.58%) Tivoli
2 1 (0.58%) Tivoli Storage Manager
Vendors
1 73 (42.69%) Microsoft
2 32 (18.71%) ServiceNow
3 13 (7.60%) Tableau
4 9 (5.26%) RedGate
5 8 (4.68%) Infragistics
6 4 (2.34%) Oracle
7 3 (1.75%) Sybase
8 2 (1.17%) Atlassian
9 1 (0.58%) Bloomberg
9 1 (0.58%) Calypso
9 1 (0.58%) Cognos
9 1 (0.58%) Databricks
9 1 (0.58%) IBM
9 1 (0.58%) Informatica
9 1 (0.58%) Murex
9 1 (0.58%) Reuters
9 1 (0.58%) Snow
9 1 (0.58%) Teradata
9 1 (0.58%) TIBCO
9 1 (0.58%) VMware