Period
to 22 April 2021

The following table provides summary statistics for permanent job vacancies advertised in 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 22 April 2021 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
England > London
6 months to
22 Apr 2021
Same period 2020 Same period 2019
Rank 323 255 200
Rank change year-on-year -68 -55 +7
Permanent jobs citing SQL Server Analysis Services 278 598 1,063
As % of all permanent jobs advertised in London 0.88% 1.34% 1.76%
As % of the Database & Business Intelligence category 3.08% 4.84% 6.01%
Number of salaries quoted 217 553 977
10th Percentile £43,600 £43,750 £41,250
25th Percentile £51,250 £53,750 £47,500
Median annual salary (50th Percentile) £62,500 £70,000 £60,000
Median % change year-on-year -10.71% +16.67% +9.09%
75th Percentile £77,500 £82,500 £72,500
90th Percentile £87,500 £95,000 £83,750
England median annual salary £52,500 £55,000 £50,000
% change year-on-year -4.55% +10.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 London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 9,030 12,349 17,673
As % of all permanent IT jobs advertised in London 28.66% 27.69% 29.20%
Number of salaries quoted 6,967 10,189 14,827
10th Percentile £43,750 £40,000 £38,750
25th Percentile £52,500 £50,000 £47,500
Median annual salary (50th Percentile) £70,000 £65,000 £65,000
Median % change year-on-year +7.69% - +8.33%
75th Percentile £87,500 £85,000 £82,500
90th Percentile £100,000 £105,000 £95,000
England median annual salary £55,000 £55,000 £52,500
% change year-on-year - +4.76% +5.00%

SQL Server Analysis Services
Job Vacancy Trend in London

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

Job vacancy trend for SQL Server Analysis Services in London

SQL Server Analysis Services
Salary Trend in London

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

Salary trend for SQL Server Analysis Services in London

SQL Server Analysis Services
Salary Histogram in London

Salary distribution for jobs citing SQL Server Analysis Services in London over the 6 months to 22 April 2021.

Salary histogram for SQL Server Analysis Services in London

SQL Server Analysis Services
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL Server Analysis Services within the London region over the 6 months to 22 April 2021. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London +1 101 £60,000 -14.29% 8
West London +61 27 £62,500 -10.71% 3
South London +17 1 £55,000 +4.76% 3
SQL Server Analysis Services
England

For the 6 months to 22 April 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 London region with a requirement for SQL Server Analysis Services.

1 243 (87.41%) Business Intelligence
2 242 (87.05%) SQL
3 235 (84.53%) SQL Server Integration Services
4 211 (75.90%) SQL Server Reporting Services
5 201 (72.30%) Power BI
5 201 (72.30%) Power Platform
6 192 (69.06%) SQL Server
7 183 (65.83%) Data Warehouse
8 168 (60.43%) Azure
9 134 (48.20%) ETL
10 123 (44.24%) Microsoft
11 96 (34.53%) Microsoft Analysis Services
12 93 (33.45%) Analytics
13 90 (32.37%) T-SQL
14 80 (28.78%) Visualisation
15 79 (28.42%) Python
16 75 (26.98%) Azure Data Factory
17 72 (25.90%) Azure SQL Database
18 71 (25.54%) Data Analysis Expressions (DAX)
19 69 (24.82%) Finance
20 67 (24.10%) Data Modelling
21 56 (20.14%) Agile Software Development
22 50 (17.99%) AWS
23 49 (17.63%) Data Management
23 49 (17.63%) Tableau
24 48 (17.27%) Azure Synapse Analytics
25 44 (15.83%) Data Visualisation
26 43 (15.47%) Migration
27 42 (15.11%) Azure SQL Data Warehouse
28 38 (13.67%) Data Quality

SQL Server Analysis Services
Co-occurring IT Skills in 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 17 (6.12%) SharePoint
2 11 (3.96%) SAS
3 4 (1.44%) Apache Spark
4 3 (1.08%) Apache Airflow
Applications
1 20 (7.19%) Microsoft Excel
2 6 (2.16%) Microsoft Office
3 2 (0.72%) MS Visio
Business Applications
1 4 (1.44%) Dynamics CRM
2 2 (0.72%) Dynamics AX
2 2 (0.72%) NetSuite
3 1 (0.36%) Elite 3E
Cloud Services
1 201 (72.30%) Power Platform
2 168 (60.43%) Azure
3 75 (26.98%) Azure Data Factory
4 50 (17.99%) AWS
5 48 (17.27%) Azure Synapse Analytics
6 30 (10.79%) PaaS
7 25 (8.99%) Azure Stack
8 17 (6.12%) GCP
9 16 (5.76%) Azure Cosmos DB
10 15 (5.40%) IaaS
11 7 (2.52%) Azure Data Lake Analytics
12 6 (2.16%) Azure Sentinel
12 6 (2.16%) Azure Storage
12 6 (2.16%) Microsoft 365
13 4 (1.44%) Amazon S3
13 4 (1.44%) GitHub
14 3 (1.08%) Dynamics 365
14 3 (1.08%) Google Data Studio
14 3 (1.08%) Matillion
14 3 (1.08%) SaaS
Communications & Networking
1 4 (1.44%) FTP
2 2 (0.72%) Intranet
2 2 (0.72%) Kerberos
Database & Business Intelligence
1 235 (84.53%) SQL Server Integration Services
2 211 (75.90%) SQL Server Reporting Services
3 201 (72.30%) Power BI
4 192 (69.06%) SQL Server
5 183 (65.83%) Data Warehouse
6 96 (34.53%) Microsoft Analysis Services
7 72 (25.90%) Azure SQL Database
8 49 (17.63%) Tableau
9 42 (15.11%) Azure SQL Data Warehouse
10 37 (13.31%) Relational Database
11 31 (11.15%) Data Lake
12 25 (8.99%) Big Data
13 20 (7.19%) SQL Server 2012
14 16 (5.76%) QlikView
15 15 (5.40%) Qlik Sense
16 14 (5.04%) OLTP
17 13 (4.68%) Star Schema
18 12 (4.32%) SQL Server 2008
19 11 (3.96%) Hadoop
19 11 (3.96%) Oracle Reports
Development Applications
1 24 (8.63%) Git (software)
2 17 (6.12%) Team Foundation Server
3 9 (3.24%) Jenkins
4 7 (2.52%) Octopus Deploy
4 7 (2.52%) Visual Studio
5 4 (1.44%) ER Studio
5 4 (1.44%) ERwin
5 4 (1.44%) JIRA
5 4 (1.44%) Subversion
6 2 (0.72%) Atlassian Bamboo
6 2 (0.72%) NUnit
6 2 (0.72%) Postman
6 2 (0.72%) SQL Server Management Studio (SSMS)
6 2 (0.72%) Vagrant
7 1 (0.36%) Eclipse
General
1 69 (24.82%) Finance
2 12 (4.32%) Marketing
3 9 (3.24%) Retail
4 7 (2.52%) Banking
5 6 (2.16%) Advertising
6 5 (1.80%) Law
7 2 (0.72%) Automotive
7 2 (0.72%) Front Office
7 2 (0.72%) Public Sector
8 1 (0.36%) Italian Language
8 1 (0.36%) Legal
8 1 (0.36%) Social Housing
8 1 (0.36%) Spanish Language
Job Titles
1 122 (43.88%) Developer
2 77 (27.70%) Business Intelligence Developer
3 65 (23.38%) Analyst
4 41 (14.75%) Business Intelligence Analyst
4 41 (14.75%) Data Engineer
5 28 (10.07%) Data Analyst
6 26 (9.35%) SQL Developer
7 23 (8.27%) Analyst Developer
8 22 (7.91%) Consultant
9 21 (7.55%) Power BI Developer
10 20 (7.19%) Data Consultant
11 19 (6.83%) DBA
12 18 (6.47%) Azure Engineer
13 17 (6.12%) Architect
13 17 (6.12%) Azure Consultant
13 17 (6.12%) Data Warehouse Developer
13 17 (6.12%) Senior Developer
13 17 (6.12%) SQL DBA
14 14 (5.04%) Data Architect
14 14 (5.04%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 22 (7.91%) .NET
2 16 (5.76%) REST
3 11 (3.96%) XML
4 8 (2.88%) MDX
5 4 (1.44%) Node.js
6 3 (1.08%) .NET Framework
6 3 (1.08%) Web Services
7 2 (0.72%) Entity Framework
7 2 (0.72%) HTML
7 2 (0.72%) OAuth
7 2 (0.72%) RESTful
7 2 (0.72%) Spark Streaming
7 2 (0.72%) XSLT
8 1 (0.36%) AngularJS
8 1 (0.36%) ASP.NET
8 1 (0.36%) CSS3
8 1 (0.36%) HTML5
8 1 (0.36%) JSON
8 1 (0.36%) Kafka
8 1 (0.36%) Sass
Miscellaneous
1 25 (8.99%) Data Structures
2 22 (7.91%) Analytical Skills
3 16 (5.76%) Reinsurance
4 11 (3.96%) Greenfield Project
5 8 (2.88%) User Experience
6 7 (2.52%) Clustering
7 6 (2.16%) Management Information System
8 2 (0.72%) Analytical Mindset
8 2 (0.72%) Blog
8 2 (0.72%) Organisational Skills
8 2 (0.72%) Social Media
9 1 (0.36%) Client/Server
9 1 (0.36%) Cloud Native
9 1 (0.36%) Data Centre
9 1 (0.36%) Enterprise Software
9 1 (0.36%) Hedge funds
9 1 (0.36%) Mobile App
9 1 (0.36%) NHS
9 1 (0.36%) Replication
Operating Systems
1 10 (3.60%) Windows
2 2 (0.72%) Linux
2 2 (0.72%) Unix
2 2 (0.72%) Windows Server
3 1 (0.36%) Windows 10
3 1 (0.36%) Windows 7
Processes & Methodologies
1 243 (87.41%) Business Intelligence
2 134 (48.20%) ETL
3 93 (33.45%) Analytics
4 80 (28.78%) Visualisation
5 67 (24.10%) Data Modelling
6 56 (20.14%) Agile Software Development
7 49 (17.63%) Data Management
8 44 (15.83%) Data Visualisation
9 43 (15.47%) Migration
10 38 (13.67%) Data Analytics
11 37 (13.31%) DevOps
12 35 (12.59%) Continuous Integration
12 35 (12.59%) Data Lineage
13 27 (9.71%) Kimball Methodology
14 24 (8.63%) Stakeholder Management
15 23 (8.27%) Decision-Making
16 22 (7.91%) Data Architecture
16 22 (7.91%) Data Integration
17 19 (6.83%) Continuous Improvement
17 19 (6.83%) Dimensional Modelling
Programming Languages
1 242 (87.05%) SQL
2 90 (32.37%) T-SQL
3 79 (28.42%) Python
4 71 (25.54%) Data Analysis Expressions (DAX)
5 26 (9.35%) C#
6 20 (7.19%) R
7 12 (4.32%) PowerShell
8 8 (2.88%) VB
9 7 (2.52%) U-SQL
10 5 (1.80%) Java
11 3 (1.08%) Go
11 3 (1.08%) PHP
12 2 (0.72%) VBA
12 2 (0.72%) VBScript
13 1 (0.36%) Bash Shell
13 1 (0.36%) JavaScript
13 1 (0.36%) Perl
13 1 (0.36%) Shell Script
Qualifications
1 16 (5.76%) Degree
2 13 (4.68%) Security Cleared
3 11 (3.96%) SC Cleared
4 7 (2.52%) Microsoft Certification
5 4 (1.44%) Computer Science Degree
5 4 (1.44%) Numerate Degree
6 1 (0.36%) ITIL Certification
6 1 (0.36%) MCSA
6 1 (0.36%) MCSE
Quality Assurance & Compliance
1 38 (13.67%) Data Quality
2 7 (2.52%) GDPR
3 1 (0.36%) ISO/IEC 27001
3 1 (0.36%) SLA
System Software
1 8 (2.88%) Docker
2 6 (2.16%) VMware Infrastructure
3 5 (1.80%) Active Directory
4 4 (1.44%) HDFS
5 2 (0.72%) VirtualBox
Systems Management
1 8 (2.88%) Ansible
1 8 (2.88%) Terraform
2 6 (2.16%) Grafana
3 2 (0.72%) Docker Swarm
3 2 (0.72%) Kubernetes
4 1 (0.36%) Failover Clustering
4 1 (0.36%) Microsoft Clustering
Vendors
1 123 (44.24%) Microsoft
2 36 (12.95%) Salesforce.com
3 35 (12.59%) Google
4 26 (9.35%) Databricks
5 20 (7.19%) Oracle
6 15 (5.40%) QAD
7 13 (4.68%) Teradata
8 10 (3.60%) Informatica
9 7 (2.52%) Alteryx
10 6 (2.16%) VMware
11 5 (1.80%) SAP
11 5 (1.80%) Talend
12 3 (1.08%) IBM
13 2 (0.72%) Alibaba
13 2 (0.72%) Cloudera
13 2 (0.72%) Hortonworks
13 2 (0.72%) JD Edwards
13 2 (0.72%) Percona
14 1 (0.36%) Aderant
14 1 (0.36%) Nintex