Period
to 5 March 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 5 March 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
5 Mar 2021
Same period 2020 Same period 2019
Rank 132 144 165
Rank change year-on-year +12 +21 -38
Permanent jobs citing SQL Server Analysis Services 89 183 185
As % of all permanent jobs advertised in the City of London 1.88% 2.02% 1.76%
As % of the Database & Business Intelligence category 6.29% 7.97% 5.85%
Number of salaries quoted 88 179 180
Median annual salary £65,000 £70,000 £60,000
Median salary % change year-on-year -7.14% +16.67% -
10th Percentile £40,000 £48,550 £42,750
90th Percentile £88,750 £78,900 £86,250
Central London median annual salary £65,000 £68,750 £60,000
% change year-on-year -5.45% +14.58% +9.09%

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,415 2,297 3,161
As % of all permanent IT jobs advertised in the City of London 29.88% 25.33% 30.15%
Number of salaries quoted 1,227 2,025 2,866
Median annual salary £72,500 £67,500 £65,000
Median salary % change year-on-year +7.41% +3.85% +4.00%
10th Percentile £43,750 £42,500 £41,250
90th Percentile £104,250 £105,000 £96,250
Central London median annual salary £70,000 £67,500 £65,000
% change year-on-year +3.70% +3.85% +8.33%

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 5 March 2021.

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

For the 6 months to 5 March 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 79 (88.76%) Business Intelligence
2 78 (87.64%) SQL Server Integration Services
3 66 (74.16%) SQL Server
4 65 (73.03%) SQL
5 62 (69.66%) SQL Server Reporting Services
6 57 (64.04%) Power BI
6 57 (64.04%) Power Platform
7 53 (59.55%) Azure
8 48 (53.93%) Data Warehouse
9 43 (48.31%) ETL
9 43 (48.31%) T-SQL
10 32 (35.96%) Finance
11 23 (25.84%) Microsoft
11 23 (25.84%) Python
12 21 (23.60%) Microsoft Analysis Services
13 19 (21.35%) Analytics
13 19 (21.35%) Azure Data Factory
14 16 (17.98%) Data Lake
14 16 (17.98%) Azure SQL Database
15 15 (16.85%) QAD
15 15 (16.85%) Data Modelling
15 15 (16.85%) Visualisation
16 14 (15.73%) Data Analysis Expressions (DAX)
17 13 (14.61%) R
17 13 (14.61%) Databricks
18 12 (13.48%) Strategic Roadmap
18 12 (13.48%) Tableau
18 12 (13.48%) DevOps
18 12 (13.48%) Reinsurance
18 12 (13.48%) Microsoft Excel

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.11%) SharePoint
Applications
1 12 (13.48%) Microsoft Excel
2 5 (5.62%) Microsoft Office
Business Applications
1 1 (1.12%) Dynamics CRM
1 1 (1.12%) Salesforce.com CRM
Cloud Services
1 57 (64.04%) Power Platform
2 53 (59.55%) Azure
3 19 (21.35%) Azure Data Factory
4 7 (7.87%) AWS
5 5 (5.62%) Microsoft 365
6 2 (2.25%) IaaS
6 2 (2.25%) PaaS
6 2 (2.25%) SaaS
7 1 (1.12%) Data Lake Analytics
Database & Business Intelligence
1 78 (87.64%) SQL Server Integration Services
2 66 (74.16%) SQL Server
3 62 (69.66%) SQL Server Reporting Services
4 57 (64.04%) Power BI
5 48 (53.93%) Data Warehouse
6 21 (23.60%) Microsoft Analysis Services
7 16 (17.98%) Azure SQL Database
7 16 (17.98%) Data Lake
8 12 (13.48%) Tableau
9 9 (10.11%) SQL Server 2016
10 7 (7.87%) SQL Server 2008
11 5 (5.62%) Delta Lake
11 5 (5.62%) SQL Server 2012
11 5 (5.62%) SQL Server 2019
12 4 (4.49%) Azure SQL Data Warehouse
13 3 (3.37%) Big Data
14 2 (2.25%) Relational Database
15 1 (1.12%) PowerPivot
Development Applications
1 6 (6.74%) Team Foundation Server
2 1 (1.12%) Git (software)
2 1 (1.12%) Visual Studio
General
1 32 (35.96%) Finance
2 7 (7.87%) Banking
3 5 (5.62%) Retail
4 3 (3.37%) Law
5 2 (2.25%) Public Sector
6 1 (1.12%) Legal
6 1 (1.12%) Marketing
Job Titles
1 55 (61.80%) Developer
2 39 (43.82%) Business Intelligence Developer
3 34 (38.20%) Analyst
4 20 (22.47%) Business Intelligence Analyst
5 16 (17.98%) Analyst Developer
6 12 (13.48%) Azure Developer
7 11 (12.36%) Data Analyst
8 10 (11.24%) Senior Business Intelligence Developer
8 10 (11.24%) Senior Developer
9 9 (10.11%) Report Analyst
10 7 (7.87%) Architect
10 7 (7.87%) Data Architect
10 7 (7.87%) Lead Developer
10 7 (7.87%) SQL Developer
11 6 (6.74%) Data Warehouse Developer
11 6 (6.74%) Report Developer
11 6 (6.74%) SQL Analyst
12 5 (5.62%) Data Warehouse Analyst
12 5 (5.62%) Power BI Developer
12 5 (5.62%) Software Analyst
Libraries, Frameworks & Software Standards
1 6 (6.74%) .NET
1 6 (6.74%) MDX
2 5 (5.62%) XML
Miscellaneous
1 12 (13.48%) Reinsurance
2 8 (8.99%) Management Information System
3 7 (7.87%) Data Structures
4 4 (4.49%) Analytical Skills
5 3 (3.37%) Clustering
6 2 (2.25%) Client/Server
7 1 (1.12%) Replication
Operating Systems
1 3 (3.37%) Windows
2 1 (1.12%) Windows Server
Processes & Methodologies
1 79 (88.76%) Business Intelligence
2 43 (48.31%) ETL
3 19 (21.35%) Analytics
4 15 (16.85%) Data Modelling
4 15 (16.85%) Visualisation
5 12 (13.48%) DevOps
5 12 (13.48%) Strategic Roadmap
6 10 (11.24%) Agile Software Development
6 10 (11.24%) Data Visualisation
7 9 (10.11%) Migration
8 8 (8.99%) Data Analytics
8 8 (8.99%) Wealth Management
9 7 (7.87%) Data Development
9 7 (7.87%) Data Integration
9 7 (7.87%) Data Science
9 7 (7.87%) Data Strategy
9 7 (7.87%) Investment Management
9 7 (7.87%) Kimball Methodology
10 6 (6.74%) Data Governance
10 6 (6.74%) Scrum
Programming Languages
1 65 (73.03%) SQL
2 43 (48.31%) T-SQL
3 23 (25.84%) Python
4 14 (15.73%) Data Analysis Expressions (DAX)
5 13 (14.61%) R
6 10 (11.24%) C#
7 2 (2.25%) Java
7 2 (2.25%) PowerShell
8 1 (1.12%) VB
Qualifications
1 7 (7.87%) Degree
Quality Assurance & Compliance
1 7 (7.87%) Data Quality
System Software
1 5 (5.62%) Active Directory
2 1 (1.12%) VMware Infrastructure
Systems Management
1 3 (3.37%) Microsoft Clustering
Vendors
1 23 (25.84%) Microsoft
2 15 (16.85%) QAD
3 13 (14.61%) Databricks
4 2 (2.25%) Informatica
5 1 (1.12%) RedGate
5 1 (1.12%) Salesforce.com
5 1 (1.12%) VMware