Period
to 13 May 2021

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 13 May 2021 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
13 May 2021
Same period 2020 Same period 2019
Rank 153 144 115
Rank change year-on-year -9 -29 -12
Permanent jobs citing SQL Server Analysis Services 84 132 263
As % of all permanent jobs advertised in the City of London 1.70% 1.79% 2.63%
As % of the Database & Business Intelligence category 5.78% 7.47% 8.56%
Number of salaries quoted 74 129 261
10th Percentile £40,000 £47,452 £43,750
25th Percentile £47,500 £57,500 £47,500
Median annual salary (50th Percentile) £60,000 £70,000 £62,500
Median % change year-on-year -14.29% +12.00% +4.17%
75th Percentile £81,250 £75,000 £73,750
90th Percentile £87,500 £80,000 £86,250
Central London median annual salary £60,000 £70,000 £60,000
% change year-on-year -14.29% +16.67% -

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 1,454 1,766 3,072
As % of all permanent IT jobs advertised in the City of London 29.40% 23.95% 30.71%
Number of salaries quoted 1,283 1,554 2,779
10th Percentile £45,000 £41,250 £41,250
25th Percentile £54,750 £51,250 £51,250
Median annual salary (50th Percentile) £75,000 £67,500 £67,500
Median % change year-on-year +11.11% - +8.00%
75th Percentile £88,750 £83,750 £83,750
90th Percentile £107,500 £100,000 £97,500
Central London median annual salary £72,500 £68,000 £65,000
% change year-on-year +6.62% +4.62% +4.00%

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 13 May 2021.

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

For the 6 months to 13 May 2021, 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 78 (92.86%) SQL Server Integration Services
2 71 (84.52%) SQL Server Reporting Services
3 70 (83.33%) Business Intelligence
4 67 (79.76%) SQL
5 62 (73.81%) SQL Server
6 52 (61.90%) Power BI
6 52 (61.90%) Power Platform
7 51 (60.71%) T-SQL
8 44 (52.38%) Azure
9 43 (51.19%) ETL
10 37 (44.05%) Data Warehouse
11 28 (33.33%) Finance
12 21 (25.00%) Python
12 21 (25.00%) Social Skills
13 17 (20.24%) Microsoft Analysis Services
13 17 (20.24%) Visualisation
14 15 (17.86%) Migration
14 15 (17.86%) QAD
15 14 (16.67%) Reinsurance
16 13 (15.48%) DevOps
16 13 (15.48%) SQL Server 2012
16 13 (15.48%) Analytics
16 13 (15.48%) Azure SQL Database
16 13 (15.48%) AWS
16 13 (15.48%) Microsoft
17 12 (14.29%) Data Analysis Expressions (DAX)
17 12 (14.29%) Tableau
18 11 (13.10%) Git (software)
18 11 (13.10%) Data Modelling
19 10 (11.90%) Agile Software Development

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 9 (10.71%) SharePoint
Applications
1 9 (10.71%) Microsoft Excel
2 5 (5.95%) Microsoft Office
Business Applications
1 1 (1.19%) Dynamics CRM
Cloud Services
1 52 (61.90%) Power Platform
2 44 (52.38%) Azure
3 13 (15.48%) AWS
4 9 (10.71%) Azure Data Factory
5 5 (5.95%) Microsoft 365
6 1 (1.19%) Azure Data Lake Analytics
6 1 (1.19%) Azure Storage
Database & Business Intelligence
1 78 (92.86%) SQL Server Integration Services
2 71 (84.52%) SQL Server Reporting Services
3 62 (73.81%) SQL Server
4 52 (61.90%) Power BI
5 37 (44.05%) Data Warehouse
6 17 (20.24%) Microsoft Analysis Services
7 13 (15.48%) Azure SQL Database
7 13 (15.48%) SQL Server 2012
8 12 (14.29%) Tableau
9 10 (11.90%) Relational Database
10 9 (10.71%) SQL Server 2016
11 8 (9.52%) InfluxDB
11 8 (9.52%) MongoDB
11 8 (9.52%) PostgreSQL
11 8 (9.52%) RDBMS
12 6 (7.14%) Data Lake
12 6 (7.14%) SQL Server 2008
13 5 (5.95%) SQL Server 2019
14 3 (3.57%) Azure SQL Data Warehouse
14 3 (3.57%) Big Data
Development Applications
1 11 (13.10%) Git (software)
2 8 (9.52%) Jenkins
2 8 (9.52%) Octopus Deploy
2 8 (9.52%) Team Foundation Server
3 1 (1.19%) Visual Studio
General
1 28 (33.33%) Finance
2 21 (25.00%) Social Skills
3 7 (8.33%) Banking
4 5 (5.95%) Documentation Skills
5 3 (3.57%) Analytical Skills
5 3 (3.57%) Influencing Skills
5 3 (3.57%) Law
5 3 (3.57%) Retail
6 2 (2.38%) Front Office
6 2 (2.38%) Public Sector
7 1 (1.19%) Legal
7 1 (1.19%) Marketing
7 1 (1.19%) Social Housing
Job Titles
1 57 (67.86%) Developer
2 36 (42.86%) Business Intelligence Developer
3 30 (35.71%) Analyst
4 20 (23.81%) Business Intelligence Analyst
5 16 (19.05%) Analyst Developer
6 13 (15.48%) SQL Developer
7 12 (14.29%) Senior Developer
8 10 (11.90%) Senior Business Intelligence Developer
9 9 (10.71%) Report Analyst
10 8 (9.52%) DBA
10 8 (9.52%) Power BI Developer
10 8 (9.52%) Senior DBA
10 8 (9.52%) Senior SQL DBA
10 8 (9.52%) Senior SQL Server DBA
10 8 (9.52%) SQL DBA
10 8 (9.52%) SQL Server DBA
11 7 (8.33%) Data Analyst
11 7 (8.33%) Report Developer
12 6 (7.14%) Data Warehouse Developer
12 6 (7.14%) SQL Analyst
Libraries, Frameworks & Software Standards
1 6 (7.14%) .NET
2 5 (5.95%) XML
3 1 (1.19%) MDX
Miscellaneous
1 14 (16.67%) Reinsurance
2 8 (9.52%) Clustering
3 7 (8.33%) Management Information System
4 3 (3.57%) Data Structures
5 1 (1.19%) User Experience
Operating Systems
1 8 (9.52%) Windows
Processes & Methodologies
1 70 (83.33%) Business Intelligence
2 43 (51.19%) ETL
3 17 (20.24%) Visualisation
4 15 (17.86%) Migration
5 13 (15.48%) Analytics
5 13 (15.48%) DevOps
6 11 (13.10%) Data Modelling
7 10 (11.90%) Agile Software Development
8 9 (10.71%) ETL Development
9 8 (9.52%) Capacity Planning
9 8 (9.52%) Configuration Management
9 8 (9.52%) Database Security
9 8 (9.52%) High Availability
9 8 (9.52%) Open Source
9 8 (9.52%) Performance Analysis
9 8 (9.52%) Performance Monitoring
9 8 (9.52%) Scrum
9 8 (9.52%) Service Delivery
9 8 (9.52%) Task Automation
9 8 (9.52%) Wealth Management
Programming Languages
1 67 (79.76%) SQL
2 51 (60.71%) T-SQL
3 21 (25.00%) Python
4 12 (14.29%) Data Analysis Expressions (DAX)
5 9 (10.71%) PowerShell
5 9 (10.71%) R
6 8 (9.52%) C#
7 1 (1.19%) VB
Qualifications
1 7 (8.33%) Degree
Quality Assurance & Compliance
1 5 (5.95%) Data Quality
System Software
1 8 (9.52%) Docker
1 8 (9.52%) VMware Infrastructure
2 5 (5.95%) Active Directory
Systems Management
1 8 (9.52%) Ansible
1 8 (9.52%) Grafana
1 8 (9.52%) Terraform
Vendors
1 15 (17.86%) QAD
2 13 (15.48%) Microsoft
3 8 (9.52%) VMware
4 2 (2.38%) Databricks
4 2 (2.38%) Informatica
4 2 (2.38%) Oracle
5 1 (1.19%) Alteryx