Period
to 16 November 2019

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 16 November 2019 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
16 Nov 2019
Same period 2018 Same period 2017
Rank 86 148 149
Rank change year-on-year +62 +1 -33
Permanent jobs citing SQL Server Analysis Services 344 233 211
As % of all permanent IT jobs advertised in the City of London 3.45% 2.09% 2.07%
As % of the Database & Business Intelligence category 11.70% 6.80% 6.61%
Number of salaries quoted 327 214 192
City of London median annual salary £62,500 £62,500 £57,500
Median salary % change year-on-year - +8.70% -4.17%
10th Percentile £47,500 £41,250 £43,750
90th Percentile £81,250 £77,500 £77,250
Central London median annual salary £62,500 £60,000 £55,000
% change year-on-year +4.17% +9.09% -8.33%

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,939 3,425 3,190
As % of all permanent IT jobs advertised in the City of London 29.44% 30.67% 31.24%
Number of salaries quoted 2,611 3,111 2,921
City of London median annual salary £70,000 £65,000 £60,000
Median salary % change year-on-year +7.69% +8.33% +4.35%
10th Percentile £42,500 £40,000 £40,000
90th Percentile £100,000 £95,000 £87,500
Central London median annual salary £67,500 £65,000 £59,500
% change year-on-year +3.85% +9.24% +8.18%

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

Job postings citing SQL Server Analysis Services as a percentage 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

This chart provides the 3-month moving average for salaries quoted in permanent IT 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

The salary distribution of IT jobs citing SQL Server Analysis Services in the City of London over the 6 months to 16 November 2019.

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

For the 6 months to 16 November 2019, 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 292 (84.88%) SQL Server Integration Services
2 268 (77.91%) SQL Server
3 263 (76.45%) Power BI
3 263 (76.45%) Power Platform
4 258 (75.00%) Business Intelligence
5 235 (68.31%) Data Warehouse
6 225 (65.41%) SQL
7 198 (57.56%) SQL Server Reporting Services
8 162 (47.09%) Microsoft
9 147 (42.73%) Azure
10 141 (40.99%) Finance
11 126 (36.63%) Data Analysis Expressions (DAX)
12 107 (31.10%) T-SQL
13 104 (30.23%) ETL
14 102 (29.65%) Microsoft Analysis Services
15 93 (27.03%) Agile Software Development
15 93 (27.03%) C#
16 84 (24.42%) Python
17 74 (21.51%) Visualisation
18 73 (21.22%) Data Modelling
19 64 (18.60%) ITIL
19 64 (18.60%) Analytics
20 62 (18.02%) Analytical Skills
21 60 (17.44%) Problem-Solving
22 55 (15.99%) Kimball Methodology
23 54 (15.70%) User Acceptance Testing
24 51 (14.83%) Data Architecture
25 50 (14.53%) .NET
26 48 (13.95%) MDX
27 47 (13.66%) R

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 35 (10.17%) SharePoint
2 5 (1.45%) SAS
3 4 (1.16%) Confluence
3 4 (1.16%) SharePoint 2013
4 1 (0.29%) SharePoint 2010
Applications
1 30 (8.72%) Microsoft Excel
2 3 (0.87%) Microsoft Project
3 1 (0.29%) Microsoft Office
3 1 (0.29%) MS Visio
Cloud Services
1 263 (76.45%) Power Platform
2 147 (42.73%) Azure
3 40 (11.63%) AWS
4 38 (11.05%) Azure Data Factory
5 8 (2.33%) PowerApps
6 6 (1.74%) AWS CloudFormation
6 6 (1.74%) GitHub
7 3 (0.87%) SaaS
8 2 (0.58%) Azure Active Directory
8 2 (0.58%) Cloud Computing
8 2 (0.58%) Mimecast
9 1 (0.29%) Azure Machine Learning
9 1 (0.29%) GCP
9 1 (0.29%) PaaS
Communications & Networking
1 6 (1.74%) Network Security
2 4 (1.16%) SAN
Database & Business Intelligence
1 292 (84.88%) SQL Server Integration Services
2 268 (77.91%) SQL Server
3 263 (76.45%) Power BI
4 235 (68.31%) Data Warehouse
5 198 (57.56%) SQL Server Reporting Services
6 102 (29.65%) Microsoft Analysis Services
7 43 (12.50%) Data Lake
8 32 (9.30%) SQL Server 2012
8 32 (9.30%) SQL Server 2016
9 31 (9.01%) Azure SQL Database
10 21 (6.10%) Enterprise Data Warehouse
11 20 (5.81%) PostgreSQL
11 20 (5.81%) Relational Database
12 19 (5.52%) OLAP
13 15 (4.36%) OLAP Cube
14 12 (3.49%) SQL Server 2014
15 11 (3.20%) QlikView
16 10 (2.91%) SQL Server 2008
17 8 (2.33%) Big Data
18 7 (2.03%) MySQL
Development Applications
1 21 (6.10%) Visual Studio
2 11 (3.20%) Git (software)
3 10 (2.91%) Atlassian Bamboo
3 10 (2.91%) Bitbucket
4 9 (2.62%) Team Foundation Server
5 7 (2.03%) Subversion
6 6 (1.74%) JIRA
7 3 (0.87%) Oracle APEX
8 2 (0.58%) SQL Server Management Studio (SSMS)
9 1 (0.29%) Jenkins
9 1 (0.29%) Maven
9 1 (0.29%) Visual Studio Team System
General
1 141 (40.99%) Finance
2 20 (5.81%) Telecoms
3 16 (4.65%) Banking
4 10 (2.91%) Retail
5 4 (1.16%) Legal
5 4 (1.16%) Marketing
6 3 (0.87%) Public Sector
7 2 (0.58%) Law
7 2 (0.58%) Publishing
8 1 (0.29%) Investment Banking
Job Titles
1 201 (58.43%) Developer
2 138 (40.12%) Business Intelligence Developer
3 58 (16.86%) SQL Developer
4 54 (15.70%) Analyst
5 43 (12.50%) SQL BI Developer
6 29 (8.43%) DBA
6 29 (8.43%) Power BI Developer
6 29 (8.43%) SQL DBA
7 25 (7.27%) Business Intelligence Analyst
8 24 (6.98%) Database Developer
9 23 (6.69%) Azure Developer
9 23 (6.69%) Lead Developer
10 22 (6.40%) Administrator
10 22 (6.40%) Data Warehouse Developer
10 22 (6.40%) SSAS Developer
11 21 (6.10%) SSRS Developer
12 19 (5.52%) Senior Developer
12 19 (5.52%) SQL Database Developer
13 18 (5.23%) Business Intelligence Lead
14 17 (4.94%) Database Engineer
Libraries, Frameworks & Software Standards
1 50 (14.53%) .NET
2 48 (13.95%) MDX
3 23 (6.69%) ASP.NET
4 19 (5.52%) D3.js
4 19 (5.52%) Vue.js
5 17 (4.94%) XML
6 11 (3.20%) RESTful
7 8 (2.33%) ASP.NET MVC
8 7 (2.03%) .NET Framework
8 7 (2.03%) SOAP
9 5 (1.45%) WCF
10 4 (1.16%) Web Services
11 3 (0.87%) WPF
12 2 (0.58%) HTML
13 1 (0.29%) COM
13 1 (0.29%) CSS
13 1 (0.29%) HTML5
13 1 (0.29%) jQuery
13 1 (0.29%) REST
13 1 (0.29%) WinForms
Miscellaneous
1 62 (18.02%) Analytical Skills
2 30 (8.72%) Management Information System
3 24 (6.98%) Data Centre
4 23 (6.69%) Reinsurance
5 17 (4.94%) Public Cloud
5 17 (4.94%) Self-Motivation
6 16 (4.65%) AS400
6 16 (4.65%) iSeries
7 15 (4.36%) Private Cloud
8 6 (1.74%) Greenfield Project
8 6 (1.74%) Replication
9 4 (1.16%) Credit Risk
10 3 (0.87%) Taxonomies
11 2 (0.58%) Clustering
11 2 (0.58%) Market Risk
12 1 (0.29%) Analytical Mindset
12 1 (0.29%) Data Structures
12 1 (0.29%) Mashup
Operating Systems
1 46 (13.37%) Windows
1 46 (13.37%) Windows Server
2 5 (1.45%) Linux
3 4 (1.16%) Windows Server 2003
Processes & Methodologies
1 258 (75.00%) Business Intelligence
2 104 (30.23%) ETL
3 93 (27.03%) Agile Software Development
4 74 (21.51%) Visualisation
5 73 (21.22%) Data Modelling
6 64 (18.60%) Analytics
6 64 (18.60%) ITIL
7 60 (17.44%) Problem-Solving
8 55 (15.99%) Kimball Methodology
9 54 (15.70%) User Acceptance Testing
10 51 (14.83%) Data Architecture
11 46 (13.37%) Change Management
12 44 (12.79%) DevOps
13 36 (10.47%) Proactive Monitoring
14 34 (9.88%) Data Visualisation
15 30 (8.72%) Data Analysis
16 26 (7.56%) Data Analytics
17 24 (6.98%) Decision-Making
18 23 (6.69%) Computer Science
18 23 (6.69%) Kanban
Programming Languages
1 225 (65.41%) SQL
2 126 (36.63%) Data Analysis Expressions (DAX)
3 107 (31.10%) T-SQL
4 93 (27.03%) C#
5 84 (24.42%) Python
6 47 (13.66%) R
7 45 (13.08%) Java
8 24 (6.98%) VBA
9 21 (6.10%) PowerShell
10 17 (4.94%) VB
11 16 (4.65%) RPG
12 9 (2.62%) VB.NET
13 8 (2.33%) Bash Shell
14 4 (1.16%) PL/SQL
15 3 (0.87%) VBScript
16 1 (0.29%) JavaScript
Qualifications
1 22 (6.40%) Degree
2 19 (5.52%) Computer Science Degree
3 14 (4.07%) ITIL Foundation Certificate
4 5 (1.45%) Microsoft Certification
Quality Assurance & Compliance
1 10 (2.91%) Data Quality
1 10 (2.91%) QA
2 8 (2.33%) SLA
System Software
1 8 (2.33%) Active Directory
1 8 (2.33%) Hyper-V
1 8 (2.33%) XenApp
2 6 (1.74%) Docker
2 6 (1.74%) VMware Infrastructure
2 6 (1.74%) VMware Workstation
3 5 (1.45%) Virtual Machines
Systems Management
1 12 (3.49%) Control-M
2 8 (2.33%) Kubernetes
3 7 (2.03%) Failover Clustering
4 6 (1.74%) Ansible
4 6 (1.74%) Opscode Chef
4 6 (1.74%) Puppet
4 6 (1.74%) Terraform
5 4 (1.16%) Dollar Universe
5 4 (1.16%) Tivoli
5 4 (1.16%) Tivoli Storage Manager
6 1 (0.29%) Perfmon
Vendors
1 162 (47.09%) Microsoft
2 36 (10.47%) Tableau
3 26 (7.56%) Databricks
4 17 (4.94%) VMware
5 15 (4.36%) Veeam
6 10 (2.91%) Atlassian
7 8 (2.33%) Citrix
8 7 (2.03%) Alteryx
8 7 (2.03%) Oracle
9 6 (1.74%) Infragistics
10 4 (1.16%) IBM
10 4 (1.16%) ServiceNow
11 3 (0.87%) Cognos
12 1 (0.29%) Bloomberg
12 1 (0.29%) Calypso
12 1 (0.29%) Google
12 1 (0.29%) Murex
12 1 (0.29%) RedGate
12 1 (0.29%) Reuters
12 1 (0.29%) Sybase