Period
to 24 June 2019

The following table provides summary statistics for contract job vacancies advertised in the City of London with a requirement for SQL Server Analysis Services skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited SQL Server Analysis Services over the 6 months to 24 June 2019 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Microsoft SQL Server Analysis Services (SSAS)
Central London > City of London
6 months to
24 Jun 2019
Same period 2018 Same period 2017
Rank 157 155 163
Rank change year-on-year -2 +8 -23
Contract jobs citing SQL Server Analysis Services 80 100 72
As % of all contract IT jobs advertised in the City of London 1.24% 1.44% 1.15%
As % of the Database & Business Intelligence category 4.76% 5.74% 4.36%
Number of daily rates quoted 53 88 46
City of London median daily rate £475 £490 £448
Median daily rate % change year-on-year -3.06% +9.50% -0.56%
10th Percentile £363 £351 £353
90th Percentile £625 £619 £588
Central London median daily rate £475 £485 £460
% change year-on-year -2.06% +5.43% +2.22%
Number of hourly rates quoted 0 2 2
City of London median hourly rate - £22.00 £21.50
Median hourly rate % change year-on-year - +2.33% -
Central London median hourly rate - £22.00 £21.50
% change year-on-year - +2.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 contract 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
Contract vacancies with a requirement for database or business intelligence skills 1,681 1,742 1,653
As % of all contract IT jobs advertised in the City of London 26.10% 25.12% 26.42%
Number of daily rates quoted 1,320 1,428 1,303
City of London median daily rate £536 £525 £500
Median daily rate % change year-on-year +2.14% +5.00% +5.26%
10th Percentile £406 £363 £328
90th Percentile £682 £675 £663
Central London median daily rate £525 £525 £500
% change year-on-year - +5.00% +5.26%
Number of hourly rates quoted 10 10 3
City of London median hourly rate £39.78 £22.25 £21.50
Median hourly rate % change year-on-year +78.80% +3.49% +13.16%
10th Percentile £22.15 £20.63 £20.75
90th Percentile £56.93 £36.90 £22.85
Central London median hourly rate £35.00 £30.00 £21.50
% change year-on-year +16.67% +39.53% +13.16%

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
Contractor Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing SQL Server Analysis Services in the City of London.

Contractor daily rate trend for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing SQL Server Analysis Services in the City of London over the 6 months to 24 June 2019.

Contractor daily rate histogram for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Contractor Hourly Rate Trend in the City of London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing SQL Server Analysis Services in the City of London.

Contractor hourly rate trend for SQL Server Analysis Services in the City of London

For the 6 months to 24 June 2019, IT contractor 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 contract job ads across the City of London region with a requirement for SQL Server Analysis Services.

1 62 (77.50%) SQL
2 59 (73.75%) SQL Server Integration Services
3 57 (71.25%) SQL Server
4 56 (70.00%) Power BI
4 56 (70.00%) Power Platform
5 55 (68.75%) Business Intelligence
6 53 (66.25%) SQL Server Reporting Services
7 34 (42.50%) Data Warehouse
8 26 (32.50%) Finance
9 25 (31.25%) Microsoft Azure
10 24 (30.00%) Microsoft
10 24 (30.00%) ETL
11 22 (27.50%) Microsoft Analysis Services
12 20 (25.00%) T-SQL
13 19 (23.75%) Data Analysis Expressions (DAX)
14 14 (17.50%) Banking
15 13 (16.25%) Agile Software Development
15 13 (16.25%) Microsoft Excel
15 13 (16.25%) Visualisation
16 12 (15.00%) SQL Server 2012
16 12 (15.00%) SQL Server 2014
16 12 (15.00%) MDX
17 10 (12.50%) Kimball Methodology
17 10 (12.50%) DevOps
17 10 (12.50%) C#
18 9 (11.25%) SharePoint
18 9 (11.25%) Tableau
18 9 (11.25%) PowerShell
18 9 (11.25%) SQL Server 2016
18 9 (11.25%) SQL Server 2017

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 (11.25%) SharePoint
2 2 (2.50%) SharePoint 2013
3 1 (1.25%) Apache Spark
3 1 (1.25%) IIS
Applications
1 13 (16.25%) Microsoft Excel
2 1 (1.25%) Microsoft Office
2 1 (1.25%) MS Visio
Business Applications
1 1 (1.25%) CA PPM
Cloud Services
1 56 (70.00%) Power Platform
2 25 (31.25%) Microsoft Azure
3 5 (6.25%) Azure Data Factory
4 4 (5.00%) Amazon AWS
5 3 (3.75%) Azure Functions
5 3 (3.75%) Serverless
6 2 (2.50%) Dynamics 365
6 2 (2.50%) Google Cloud Platform
7 1 (1.25%) Data Lake Analytics
7 1 (1.25%) Office 365
7 1 (1.25%) OpenShift
7 1 (1.25%) PaaS
7 1 (1.25%) PowerApps
Communications & Networking
1 4 (5.00%) SAN
Database & Business Intelligence
1 59 (73.75%) SQL Server Integration Services
2 57 (71.25%) SQL Server
3 56 (70.00%) Power BI
4 53 (66.25%) SQL Server Reporting Services
5 34 (42.50%) Data Warehouse
6 22 (27.50%) Microsoft Analysis Services
7 12 (15.00%) SQL Server 2012
7 12 (15.00%) SQL Server 2014
8 9 (11.25%) SQL Server 2016
8 9 (11.25%) SQL Server 2017
9 8 (10.00%) SQL Server 2008
10 6 (7.50%) Azure SQL Database
11 5 (6.25%) OLAP
11 5 (6.25%) SQL Server 2005
12 4 (5.00%) Relational Database
13 3 (3.75%) Data Lake
13 3 (3.75%) Data Mart
13 3 (3.75%) OLAP Cube
13 3 (3.75%) SQL Server 2000
14 2 (2.50%) QlikView
Development Applications
1 5 (6.25%) Visual Studio
2 3 (3.75%) Team Foundation Server
2 3 (3.75%) Visual Studio Team System
3 2 (2.50%) JIRA
4 1 (1.25%) Eclipse
4 1 (1.25%) Hudson
4 1 (1.25%) SQL Server Management Studio (SSMS)
General
1 26 (32.50%) Finance
2 14 (17.50%) Banking
3 7 (8.75%) Investment Banking
4 6 (7.50%) Retail
5 4 (5.00%) Front Office
6 2 (2.50%) Financial Institution
7 1 (1.25%) Advertising
7 1 (1.25%) Telecoms
Job Titles
1 57 (71.25%) Developer
2 32 (40.00%) Business Intelligence Developer
3 18 (22.50%) SQL Developer
4 11 (13.75%) Power BI Developer
5 10 (12.50%) Analyst
6 9 (11.25%) Analyst Developer
7 8 (10.00%) SQL BI Developer
7 8 (10.00%) SSRS Developer
8 7 (8.75%) DBA
8 7 (8.75%) Report Developer
9 6 (7.50%) Business Intelligence Analyst
9 6 (7.50%) Power BI Analyst
9 6 (7.50%) SQL DBA
10 5 (6.25%) Architect
10 5 (6.25%) Consultant
11 4 (5.00%) Senior Developer
11 4 (5.00%) SQL Analyst
11 4 (5.00%) SQL Server Developer
12 3 (3.75%) Lead DevOps
12 3 (3.75%) SSIS Developer
Libraries, Frameworks & Software Standards
1 12 (15.00%) MDX
2 6 (7.50%) .NET
3 3 (3.75%) XML
4 2 (2.50%) JSON
4 2 (2.50%) Web Services
5 1 (1.25%) AngularJS
5 1 (1.25%) ASP.NET
5 1 (1.25%) HTML
5 1 (1.25%) HTML5
5 1 (1.25%) Kafka
5 1 (1.25%) RESTful
5 1 (1.25%) WPF
Miscellaneous
1 7 (8.75%) Analytical Skills
2 5 (6.25%) Greenfield Project
2 5 (6.25%) Replication
3 4 (5.00%) Hedge funds
3 4 (5.00%) NHS
3 4 (5.00%) Self-Motivation
4 3 (3.75%) Data Structures
4 3 (3.75%) Reinsurance
5 2 (2.50%) Management Information System
6 1 (1.25%) Cloud Native
6 1 (1.25%) Clustering
6 1 (1.25%) Equities
6 1 (1.25%) Foreign Exchange (FX)
Operating Systems
1 6 (7.50%) Windows
2 1 (1.25%) Windows Server
2 1 (1.25%) Windows Server 2003
2 1 (1.25%) Windows Server 2008
Processes & Methodologies
1 55 (68.75%) Business Intelligence
2 24 (30.00%) ETL
3 13 (16.25%) Agile Software Development
3 13 (16.25%) Visualisation
4 10 (12.50%) DevOps
4 10 (12.50%) Kimball Methodology
5 8 (10.00%) Business Analysis
6 7 (8.75%) Dashboard Development
6 7 (8.75%) Data Analysis
7 6 (7.50%) Asset Management
7 6 (7.50%) Data Modelling
7 6 (7.50%) Migration
8 5 (6.25%) Analytics
8 5 (6.25%) Data Migration
8 5 (6.25%) Performance Monitoring
9 4 (5.00%) Capacity Planning
9 4 (5.00%) Data Integration
9 4 (5.00%) Dimensional Modelling
9 4 (5.00%) High Availability
9 4 (5.00%) Test Automation
Programming Languages
1 62 (77.50%) SQL
2 20 (25.00%) T-SQL
3 19 (23.75%) Data Analysis Expressions (DAX)
4 10 (12.50%) C#
5 9 (11.25%) PowerShell
6 6 (7.50%) Python
7 4 (5.00%) Shell Script
8 2 (2.50%) Java
8 2 (2.50%) JavaScript
9 1 (1.25%) PL/SQL
9 1 (1.25%) R
9 1 (1.25%) VBA
9 1 (1.25%) VBScript
Qualifications
1 4 (5.00%) Degree
2 3 (3.75%) Computer Science Degree
3 2 (2.50%) ITIL Certification
4 1 (1.25%) ITIL Foundation Certificate
4 1 (1.25%) Microsoft Certification
4 1 (1.25%) Postgraduate
4 1 (1.25%) SC Cleared
4 1 (1.25%) Security Cleared
Quality Assurance & Compliance
1 5 (6.25%) Data Quality
2 1 (1.25%) PMO
2 1 (1.25%) QA
2 1 (1.25%) Solvency II
System Software
1 1 (1.25%) Docker
Systems Management
1 1 (1.25%) Grafana
1 1 (1.25%) Kibana
1 1 (1.25%) WMI
Vendors
1 24 (30.00%) Microsoft
2 9 (11.25%) Tableau
3 4 (5.00%) Databricks
4 2 (2.50%) Bloomberg
4 2 (2.50%) FactSet
4 2 (2.50%) Oracle
5 1 (1.25%) Cognos
5 1 (1.25%) Genesys
5 1 (1.25%) Google
5 1 (1.25%) Hyperion
5 1 (1.25%) Siebel
5 1 (1.25%) Xero