Period
to 15 September 2019

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 15 September 2019 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
England > London
6 months to
15 Sep 2019
Same period 2018 Same period 2017
Rank 161 211 250
Rank change year-on-year +50 +39 -21
Permanent jobs citing SQL Server Analysis Services 1,141 1,221 1,115
As % of all permanent IT jobs advertised in London 2.06% 1.78% 1.48%
As % of the Database & Business Intelligence category 7.28% 5.71% 5.03%
Number of salaries quoted 1,050 1,104 1,023
London median annual salary £60,000 £55,000 £57,500
Median salary % change year-on-year +9.09% -4.35% +4.55%
10th Percentile £43,750 £40,225 £39,000
90th Percentile £86,250 £77,500 £76,250
England median annual salary £55,000 £50,000 £47,500
% change year-on-year +10.00% +5.26% -5.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 15,663 21,369 22,159
As % of all permanent IT jobs advertised in London 28.30% 31.20% 29.48%
Number of salaries quoted 12,986 16,966 17,808
London median annual salary £65,000 £62,500 £60,000
Median salary % change year-on-year +4.00% +4.17% +4.35%
10th Percentile £38,750 £37,500 £36,250
90th Percentile £97,500 £92,500 £90,000
England median annual salary £52,500 £50,000 £48,500
% change year-on-year +5.00% +3.09% +2.11%

SQL Server Analysis Services
Job Vacancy Trend in London

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

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

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

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 15 September 2019. 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 +61 472 £62,500 - 28
West London -19 37 £60,000 +9.09% 3
South London -59 15 £50,000 +4.17% 1
East London +34 14 £45,000 -10.00% 3
North London +3 2 £33,000 -30.53%
SQL Server Analysis Services
England

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

1 977 (85.63%) SQL Server Integration Services
2 900 (78.88%) Business Intelligence
3 877 (76.86%) SQL Server
4 847 (74.23%) SQL
5 809 (70.90%) SQL Server Reporting Services
6 770 (67.48%) Data Warehouse
7 691 (60.56%) Power BI
7 691 (60.56%) Power Platform
8 541 (47.41%) Microsoft
9 495 (43.38%) Azure
10 477 (41.81%) Finance
11 462 (40.49%) T-SQL
12 414 (36.28%) ETL
13 343 (30.06%) Data Analysis Expressions (DAX)
14 312 (27.34%) Agile Software Development
15 295 (25.85%) C#
15 295 (25.85%) Analytics
16 281 (24.63%) Data Modelling
17 241 (21.12%) Python
18 218 (19.11%) .NET
19 216 (18.93%) Microsoft Analysis Services
20 194 (17.00%) MDX
21 189 (16.56%) Azure SQL Database
22 188 (16.48%) Kimball Methodology
23 180 (15.78%) Data Lake
24 172 (15.07%) SQL Server 2012
25 170 (14.90%) DevOps
26 157 (13.76%) Visualisation
27 145 (12.71%) Tableau
28 144 (12.62%) Azure Data Factory

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 59 (5.17%) SharePoint
2 17 (1.49%) SAS
3 14 (1.23%) Confluence
4 9 (0.79%) Apache
5 8 (0.70%) Apache Airflow
5 8 (0.70%) Apache Pig
6 6 (0.53%) SharePoint 2013
7 5 (0.44%) Oracle SOA Suite
8 4 (0.35%) Apache Spark
9 3 (0.26%) BizTalk Server
9 3 (0.26%) IIS
10 2 (0.18%) Drupal
10 2 (0.18%) Jetty
10 2 (0.18%) SharePoint 2010
11 1 (0.088%) MS Exchange
11 1 (0.088%) NServiceBus
11 1 (0.088%) Oracle Workflow
Applications
1 73 (6.40%) Microsoft Excel
2 3 (0.26%) Microsoft Project
3 2 (0.18%) MS Visio
4 1 (0.088%) Microsoft Office
4 1 (0.088%) Spreadsheet
Business Applications
1 7 (0.61%) Dynamics AX
2 5 (0.44%) Dynamics CRM
2 5 (0.44%) NetSuite
2 5 (0.44%) SAP FI-GL
3 2 (0.18%) Cognos Planning
3 2 (0.18%) Cognos TM1
3 2 (0.18%) Dynamics NAV
3 2 (0.18%) HFM
4 1 (0.088%) Endur
4 1 (0.088%) FastStats
4 1 (0.088%) Oracle Assets
4 1 (0.088%) Oracle EBS
4 1 (0.088%) Oracle Financials
4 1 (0.088%) Oracle General Ledger
4 1 (0.088%) Oracle Payables
4 1 (0.088%) Oracle Procure-to-Pay
4 1 (0.088%) Oracle Receivables
4 1 (0.088%) Raiser's Edge
Cloud Services
1 691 (60.56%) Power Platform
2 495 (43.38%) Azure
3 144 (12.62%) Azure Data Factory
4 95 (8.33%) AWS
5 34 (2.98%) PowerApps
6 31 (2.72%) Data Lake Analytics
7 25 (2.19%) Azure Machine Learning
8 20 (1.75%) GCP
9 14 (1.23%) PaaS
10 12 (1.05%) Dynamics 365
11 11 (0.96%) Serverless
12 10 (0.88%) Azure Functions
13 8 (0.70%) Amazon S3
14 7 (0.61%) Cloud Computing
14 7 (0.61%) Office 365
15 6 (0.53%) AWS CloudFormation
15 6 (0.53%) GitHub
15 6 (0.53%) SaaS
16 4 (0.35%) Azure Stack
17 3 (0.26%) Azure Active Directory
Communications & Networking
1 8 (0.70%) SAN
2 6 (0.53%) Network Security
3 2 (0.18%) Internet
3 2 (0.18%) WAN
4 1 (0.088%) DHCP
4 1 (0.088%) DNS
4 1 (0.088%) Firewall
4 1 (0.088%) VLAN
Database & Business Intelligence
1 977 (85.63%) SQL Server Integration Services
2 877 (76.86%) SQL Server
3 809 (70.90%) SQL Server Reporting Services
4 770 (67.48%) Data Warehouse
5 691 (60.56%) Power BI
6 216 (18.93%) Microsoft Analysis Services
7 189 (16.56%) Azure SQL Database
8 180 (15.78%) Data Lake
9 172 (15.07%) SQL Server 2012
10 132 (11.57%) OLAP
11 127 (11.13%) SQL Server 2016
12 79 (6.92%) Relational Database
13 78 (6.84%) Big Data
14 75 (6.57%) QlikView
15 52 (4.56%) MongoDB
15 52 (4.56%) SQL Server 2014
16 51 (4.47%) Azure SQL Data Warehouse
17 46 (4.03%) PostgreSQL
18 44 (3.86%) SQL Server 2008
19 40 (3.51%) PowerPivot
Development Applications
1 80 (7.01%) Visual Studio
2 48 (4.21%) Git (software)
3 41 (3.59%) JIRA
4 29 (2.54%) Team Foundation Server
5 25 (2.19%) Jenkins
6 22 (1.93%) Bitbucket
7 20 (1.75%) Subversion
8 13 (1.14%) Atlassian Bamboo
9 9 (0.79%) Octopus Deploy
9 9 (0.79%) TeamCity
10 8 (0.70%) ProC
10 8 (0.70%) SQL Server Management Studio (SSMS)
11 4 (0.35%) Visual Studio Team System
12 3 (0.26%) Maven
12 3 (0.26%) Oracle APEX
13 1 (0.088%) MorphX
13 1 (0.088%) MSTest
13 1 (0.088%) NSubstitute
13 1 (0.088%) Rhino Mocks
13 1 (0.088%) SpecFlow
General
1 477 (41.81%) Finance
2 55 (4.82%) Retail
3 41 (3.59%) Banking
4 30 (2.63%) Legal
5 23 (2.02%) Law
6 20 (1.75%) Telecoms
7 18 (1.58%) Public Sector
8 16 (1.40%) Financial Institution
8 16 (1.40%) Marketing
9 14 (1.23%) Investment Banking
10 12 (1.05%) Front Office
11 10 (0.88%) Games
12 7 (0.61%) Advertising
13 6 (0.53%) Automotive
14 5 (0.44%) Publishing
15 4 (0.35%) Billing
16 3 (0.26%) Military
17 2 (0.18%) Back Office
18 1 (0.088%) Pharmaceutical
Job Titles
1 745 (65.29%) Developer
2 478 (41.89%) Business Intelligence Developer
3 310 (27.17%) SQL Developer
4 165 (14.46%) SQL BI Developer
5 120 (10.52%) Senior Developer
6 112 (9.82%) Analyst
7 93 (8.15%) Data Warehouse Developer
8 92 (8.06%) SSRS Developer
9 88 (7.71%) DBA
10 87 (7.62%) Database Developer
11 86 (7.54%) SQL Server Developer
12 85 (7.45%) SSIS Developer
13 84 (7.36%) SQL DBA
14 80 (7.01%) Power BI Developer
15 72 (6.31%) Senior Business Intelligence Developer
16 71 (6.22%) Business Intelligence Analyst
16 71 (6.22%) SQL Server BI Developer
17 67 (5.87%) SQL Database Developer
18 66 (5.78%) SSAS Developer
19 55 (4.82%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 218 (19.11%) .NET
2 194 (17.00%) MDX
3 61 (5.35%) ASP.NET
4 38 (3.33%) .NET Framework
5 33 (2.89%) XML
6 31 (2.72%) HTML
7 30 (2.63%) Web Services
8 21 (1.84%) WCF
9 18 (1.58%) Entity Framework
9 18 (1.58%) HTML5
10 17 (1.49%) ASP.NET Web API
10 17 (1.49%) LINQ
11 16 (1.40%) CSS
12 15 (1.31%) AngularJS
13 14 (1.23%) Apache Flex
13 14 (1.23%) Aurelia
13 14 (1.23%) Flash
13 14 (1.23%) NHibernate
14 13 (1.14%) jQuery
15 10 (0.88%) RESTful
Miscellaneous
1 114 (9.99%) Analytical Skills
2 49 (4.29%) Data Centre
3 47 (4.12%) Greenfield Project
4 43 (3.77%) Clustering
5 40 (3.51%) Hedge funds
6 39 (3.42%) Management Information System
6 39 (3.42%) Replication
7 36 (3.16%) Reinsurance
8 28 (2.45%) iSeries
9 27 (2.37%) AS400
10 21 (1.84%) Self-Motivation
11 20 (1.75%) Data Structures
12 16 (1.40%) Algorithms
12 16 (1.40%) Public Cloud
13 15 (1.31%) Private Cloud
14 14 (1.23%) Client/Server
15 12 (1.05%) Credit Risk
16 10 (0.88%) Fixed Income
17 9 (0.79%) Market Risk
18 7 (0.61%) Enterprise Software
Operating Systems
1 75 (6.57%) Windows
2 45 (3.94%) Windows Server
3 34 (2.98%) Linux
4 5 (0.44%) Windows Server 2003
5 4 (0.35%) Red Hat Enterprise Linux
6 3 (0.26%) Unix
6 3 (0.26%) Windows Server 2008
7 1 (0.088%) Windows 10
7 1 (0.088%) Windows 7
7 1 (0.088%) Windows 8
7 1 (0.088%) Windows Server 2012
Processes & Methodologies
1 900 (78.88%) Business Intelligence
2 414 (36.28%) ETL
3 312 (27.34%) Agile Software Development
4 295 (25.85%) Analytics
5 281 (24.63%) Data Modelling
6 188 (16.48%) Kimball Methodology
7 170 (14.90%) DevOps
8 157 (13.76%) Visualisation
9 142 (12.45%) Problem-Solving
10 119 (10.43%) Data Analytics
11 106 (9.29%) Scrum
12 93 (8.15%) Data Management
13 86 (7.54%) Computer Science
14 85 (7.45%) Data Architecture
15 77 (6.75%) Migration
16 72 (6.31%) Data Science
17 70 (6.13%) Performance Tuning
18 68 (5.96%) Data Analysis
18 68 (5.96%) Data Visualisation
19 63 (5.52%) Unit Testing
Programming Languages
1 847 (74.23%) SQL
2 462 (40.49%) T-SQL
3 343 (30.06%) Data Analysis Expressions (DAX)
4 295 (25.85%) C#
5 241 (21.12%) Python
6 123 (10.78%) R
7 101 (8.85%) PowerShell
8 50 (4.38%) VBA
9 37 (3.24%) JavaScript
10 33 (2.89%) Java
11 27 (2.37%) RPG
12 25 (2.19%) Bash Shell
13 19 (1.67%) VB
14 18 (1.58%) VB.NET
15 15 (1.31%) PL/SQL
16 10 (0.88%) C
17 8 (0.70%) Shell Script
18 7 (0.61%) MATLAB
19 5 (0.44%) U-SQL
19 5 (0.44%) VBScript
Qualifications
1 100 (8.76%) Degree
2 59 (5.17%) Computer Science Degree
3 31 (2.72%) Microsoft Certification
4 9 (0.79%) ITIL Foundation Certificate
4 9 (0.79%) MCSE
5 6 (0.53%) MCSA
6 5 (0.44%) Master's Degree
7 2 (0.18%) DBS Check
7 2 (0.18%) PMI Certification
7 2 (0.18%) PMP
8 1 (0.088%) Numerate Degree
8 1 (0.088%) PhD
8 1 (0.088%) Security Cleared
Quality Assurance & Compliance
1 45 (3.94%) Data Quality
2 34 (2.98%) QA
3 9 (0.79%) GDPR
3 9 (0.79%) SLA
4 4 (0.35%) ISO/IEC 27001
5 3 (0.26%) GAAP
6 1 (0.088%) PCI DSS
System Software
1 25 (2.19%) Docker
2 15 (1.31%) VMware Infrastructure
3 10 (0.88%) Active Directory
3 10 (0.88%) Hyper-V
4 8 (0.70%) HDFS
4 8 (0.70%) XenApp
5 6 (0.53%) VMware Workstation
6 4 (0.35%) Virtual Machines
7 1 (0.088%) LXC
Systems Management
1 24 (2.10%) Ansible
2 18 (1.58%) Grafana
3 15 (1.31%) SQL Sentry
4 10 (0.88%) Kubernetes
4 10 (0.88%) Prometheus
5 9 (0.79%) Failover Clustering
6 8 (0.70%) Control-M
7 7 (0.61%) Dollar Universe
7 7 (0.61%) Hadoop YARN
8 6 (0.53%) Opscode Chef
8 6 (0.53%) Puppet
8 6 (0.53%) Terraform
9 5 (0.44%) Microsoft Clustering
10 3 (0.26%) Tivoli
10 3 (0.26%) Tivoli Storage Manager
11 2 (0.18%) Perfmon
11 2 (0.18%) WMI
Vendors
1 541 (47.41%) Microsoft
2 145 (12.71%) Tableau
3 108 (9.47%) Databricks
4 51 (4.47%) Oracle
5 26 (2.28%) VMware
6 20 (1.75%) Alteryx
7 18 (1.58%) Teradata
8 17 (1.49%) Veeam
9 16 (1.40%) Atlassian
10 14 (1.23%) Google
10 14 (1.23%) SAP
11 11 (0.96%) IBM
11 11 (0.96%) Informatica
12 8 (0.70%) Citrix
13 7 (0.61%) Guidewire
13 7 (0.61%) Netezza
14 5 (0.44%) JD Edwards
15 4 (0.35%) Cognos
15 4 (0.35%) Hyperion
15 4 (0.35%) Red Hat