Period
to 19 October 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 19 October 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
19 Oct 2021
Same period 2020 Same period 2019
Rank 188 128 70
Rank change year-on-year -60 -58 +80
Permanent jobs citing SQL Server Analysis Services 69 73 409
As % of all permanent jobs advertised in the City of London 1.16% 2.02% 4.11%
As % of the Database & Business Intelligence category 3.85% 7.30% 13.34%
Number of salaries quoted 63 56 393
10th Percentile £51,050 £58,750 £46,250
25th Percentile £53,750 £66,250 £51,250
Median annual salary (50th Percentile) £62,500 £73,750 £62,500
Median % change year-on-year -15.25% +18.00% -
75th Percentile £76,250 £84,063 £72,500
90th Percentile £84,250 £88,750 £81,250
Central London median annual salary £62,500 £72,500 £62,500
% change year-on-year -13.79% +16.00% -

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,792 1,000 3,067
As % of all permanent IT jobs advertised in the City of London 30.08% 27.66% 30.81%
Number of salaries quoted 1,586 835 2,756
10th Percentile £46,250 £42,350 £42,500
25th Percentile £56,250 £52,500 £52,500
Median annual salary (50th Percentile) £72,500 £70,000 £67,500
Median % change year-on-year +3.57% +3.70% +3.85%
75th Percentile £95,000 £85,000 £85,000
90th Percentile £108,750 £100,000 £100,000
Central London median annual salary £72,500 £70,000 £65,000
% change year-on-year +3.57% +7.69% -

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 19 October 2021.

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

For the 6 months to 19 October 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 63 (91.30%) SQL Server Integration Services
2 56 (81.16%) SQL
3 54 (78.26%) SQL Server Reporting Services
4 46 (66.67%) Business Intelligence
5 38 (55.07%) SQL Server
5 38 (55.07%) Power Platform
6 37 (53.62%) Power BI
7 35 (50.72%) ETL
7 35 (50.72%) Finance
8 31 (44.93%) Azure
9 27 (39.13%) Data Warehouse
10 23 (33.33%) Analytics
11 20 (28.99%) Microsoft
12 19 (27.54%) C#
13 18 (26.09%) T-SQL
14 17 (24.64%) Data Modelling
15 16 (23.19%) Agile Software Development
16 14 (20.29%) Microsoft Excel
17 13 (18.84%) Tableau
17 13 (18.84%) Social Skills
18 11 (15.94%) Visualisation
19 10 (14.49%) Data Management
19 10 (14.49%) VBA
19 10 (14.49%) .NET
19 10 (14.49%) Management Information System
20 9 (13.04%) Configuration Management
20 9 (13.04%) Microsoft Analysis Services
20 9 (13.04%) Unit Testing
20 9 (13.04%) Git (software)
20 9 (13.04%) AWS

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 6 (8.70%) SharePoint
2 1 (1.45%) Oracle SOA Suite
Applications
1 14 (20.29%) Microsoft Excel
2 2 (2.90%) Microsoft Office
Business Applications
1 4 (5.80%) Elite 3E
2 1 (1.45%) IBM Planning Analytics
Cloud Services
1 38 (55.07%) Power Platform
2 31 (44.93%) Azure
3 9 (13.04%) AWS
4 8 (11.59%) Azure Data Factory
5 6 (8.70%) Azure Synapse Analytics
5 6 (8.70%) PowerApps
6 4 (5.80%) Dynamics 365
7 2 (2.90%) Azure Cosmos DB
7 2 (2.90%) Azure Storage
7 2 (2.90%) Serverless
8 1 (1.45%) Azure Functions
8 1 (1.45%) Azure Stack
8 1 (1.45%) GitHub
8 1 (1.45%) IaaS
8 1 (1.45%) PaaS
8 1 (1.45%) Power Automate
8 1 (1.45%) SaaS
Communications & Networking
1 1 (1.45%) FTP
1 1 (1.45%) PuTTY
1 1 (1.45%) WinSCP
Database & Business Intelligence
1 63 (91.30%) SQL Server Integration Services
2 54 (78.26%) SQL Server Reporting Services
3 38 (55.07%) SQL Server
4 37 (53.62%) Power BI
5 27 (39.13%) Data Warehouse
6 13 (18.84%) Tableau
7 9 (13.04%) Microsoft Analysis Services
8 6 (8.70%) DB2
8 6 (8.70%) MySQL
8 6 (8.70%) Oracle Database
9 5 (7.25%) Azure SQL Database
9 5 (7.25%) Data Lake
9 5 (7.25%) Relational Database
10 4 (5.80%) Metadata
11 3 (4.35%) Azure SQL Data Warehouse
11 3 (4.35%) Biml
11 3 (4.35%) MongoDB
11 3 (4.35%) RDBMS
11 3 (4.35%) SQL Server 2012
11 3 (4.35%) SQL Server 2017
Development Applications
1 9 (13.04%) Git (software)
2 6 (8.70%) Team Foundation Server
3 3 (4.35%) Octopus Deploy
3 3 (4.35%) Visual Studio
4 2 (2.90%) Jenkins
4 2 (2.90%) SQL Server Management Studio (SSMS)
5 1 (1.45%) ER Studio
5 1 (1.45%) ERwin
5 1 (1.45%) GDB
5 1 (1.45%) Sourcetree
5 1 (1.45%) Visual Studio Code
General
1 35 (50.72%) Finance
2 13 (18.84%) Social Skills
3 8 (11.59%) Banking
4 5 (7.25%) Front Office
4 5 (7.25%) Investment Banking
4 5 (7.25%) Law
5 4 (5.80%) Analytical Skills
5 4 (5.80%) Legal
6 1 (1.45%) Marketing
6 1 (1.45%) Retail
Job Titles
1 39 (56.52%) Developer
2 18 (26.09%) Business Intelligence Developer
3 13 (18.84%) SQL Developer
4 10 (14.49%) Analyst
5 9 (13.04%) Data Analytics Engineer
6 8 (11.59%) Automation Engineer
6 8 (11.59%) Data Engineer
7 7 (10.14%) Software Engineer
8 6 (8.70%) Power BI Developer
8 6 (8.70%) Senior Developer
9 5 (7.25%) DBA
9 5 (7.25%) ETL Developer
10 4 (5.80%) Analyst Developer
10 4 (5.80%) Applications Development Manager
10 4 (5.80%) Applications Manager
10 4 (5.80%) Business Intelligence Analyst
10 4 (5.80%) Senior Analyst
10 4 (5.80%) Software Development Manager
10 4 (5.80%) SQL DBA
10 4 (5.80%) VBA Developer
Libraries, Frameworks & Software Standards
1 10 (14.49%) .NET
2 1 (1.45%) ADO
2 1 (1.45%) CSS
2 1 (1.45%) HTML
2 1 (1.45%) HTML5
2 1 (1.45%) jQuery
2 1 (1.45%) JSON
2 1 (1.45%) Kafka
2 1 (1.45%) MDX
2 1 (1.45%) Middleware
2 1 (1.45%) REST
2 1 (1.45%) WPF
2 1 (1.45%) XML
Miscellaneous
1 10 (14.49%) Management Information System
2 4 (5.80%) Clustering
2 4 (5.80%) User Experience
3 3 (4.35%) Housing Association
4 1 (1.45%) Marketing Technology
4 1 (1.45%) N-Tier
4 1 (1.45%) Public Cloud
4 1 (1.45%) Self-Motivation
4 1 (1.45%) Wiki
Operating Systems
1 4 (5.80%) Windows
2 1 (1.45%) Windows Server
2 1 (1.45%) Windows Server 2012
Processes & Methodologies
1 46 (66.67%) Business Intelligence
2 35 (50.72%) ETL
3 23 (33.33%) Analytics
4 17 (24.64%) Data Modelling
5 16 (23.19%) Agile Software Development
6 11 (15.94%) Visualisation
7 10 (14.49%) Data Management
8 9 (13.04%) Configuration Management
8 9 (13.04%) Data Analytics
8 9 (13.04%) Unit Testing
9 8 (11.59%) Data Analysis
9 8 (11.59%) Data Visualisation
9 8 (11.59%) Requirements Gathering
10 7 (10.14%) DevOps
10 7 (10.14%) Dimensional Modelling
10 7 (10.14%) PRINCE2
10 7 (10.14%) Software Delivery
10 7 (10.14%) Software Engineering
11 6 (8.70%) Kimball Methodology
11 6 (8.70%) Performance Tuning
Programming Languages
1 56 (81.16%) SQL
2 19 (27.54%) C#
3 18 (26.09%) T-SQL
4 10 (14.49%) VBA
5 8 (11.59%) PowerShell
5 8 (11.59%) R
6 7 (10.14%) Python
7 6 (8.70%) Data Analysis Expressions (DAX)
8 2 (2.90%) JavaScript
8 2 (2.90%) VB.NET
9 1 (1.45%) Scala
9 1 (1.45%) VB
Qualifications
1 3 (4.35%) Degree
2 1 (1.45%) ITIL Certification
2 1 (1.45%) Microsoft Certification
Quality Assurance & Compliance
1 7 (10.14%) Data Quality
2 1 (1.45%) SLA
System Software
1 4 (5.80%) VMware Infrastructure
2 2 (2.90%) Active Directory
2 2 (2.90%) Docker
Systems Management
1 2 (2.90%) Ansible
1 2 (2.90%) Grafana
1 2 (2.90%) Microsoft Clustering
1 2 (2.90%) Terraform
2 1 (1.45%) Automic
Vendors
1 20 (28.99%) Microsoft
2 8 (11.59%) Alteryx
3 6 (8.70%) Oracle
4 5 (7.25%) Databricks
5 4 (5.80%) iManage
5 4 (5.80%) Intapp
5 4 (5.80%) VMware
6 3 (4.35%) RedGate
7 2 (2.90%) Cognos
7 2 (2.90%) IBM
8 1 (1.45%) Actuate
8 1 (1.45%) Aderant
8 1 (1.45%) Google
8 1 (1.45%) Netezza
8 1 (1.45%) Teradata