Period
to 24 January 2018

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 January 2018 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 Jan 2018
Same period 2017 Same period 2016
Rank 136 135 74
Rank change year-on-year -1 -61 +56
Contract jobs citing SQL Server Analysis Services 115 102 186
As % of all contract IT jobs advertised in the City of London 1.61% 1.64% 2.70%
As % of the Database & Business Intelligence category 6.50% 5.91% 10.32%
Number of daily rates quoted 100 74 158
City of London median daily rate £450 £425 £485
Median daily rate % change year-on-year +5.88% -12.37% +16.52%
10th Percentile £399 £325 £363
90th Percentile £526 £538 £575
Central London median daily rate £450 £425 £483
% change year-on-year +5.88% -11.92% +16.97%
Number of hourly rates quoted 1 0 0
City of London median hourly rate £21.50 - -
Central London median hourly rate £21.50 - -

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,770 1,727 1,802
As % of all contract IT jobs advertised in the City of London 24.81% 27.79% 26.20%
Number of daily rates quoted 1,485 1,389 1,451
City of London median daily rate £525 £475 £475
Median daily rate % change year-on-year +10.53% - +11.76%
10th Percentile £363 £325 £313
90th Percentile £688 £663 £638
Central London median daily rate £513 £475 £475
% change year-on-year +7.89% - +11.76%
Number of hourly rates quoted 6 1 6
City of London median hourly rate £27.75 £45.00 £40.00
Median hourly rate % change year-on-year -38.33% +12.50% +21.21%
10th Percentile £23.38 £42.50 £27.75
90th Percentile £33.25 £47.50 £60.00
Central London median hourly rate £27.50 £45.00 £38.75
% change year-on-year -38.89% +16.13% +49.04%

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 January 2018.

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

SQL Server Analysis Services
Contract Job Locations in the City of London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing SQL Server Analysis Services within the City of London region over the 6 months to 24 January 2018. 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Moorgate - 1 - -
SQL Server Analysis Services
Central London

For the 6 months to 24 January 2018, 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 103 (89.57%) SQL Server Integration Services
2 100 (86.96%) Business Intelligence
3 93 (80.87%) SQL Server Reporting Services
4 85 (73.91%) SQL
4 85 (73.91%) SQL Server
5 61 (53.04%) Microsoft
6 56 (48.70%) Data Warehouse
7 47 (40.87%) ETL
8 41 (35.65%) Finance
9 37 (32.17%) T-SQL
10 33 (28.70%) MDX
11 28 (24.35%) Power BI
12 26 (22.61%) Kimball Methodology
13 24 (20.87%) C#
14 22 (19.13%) OLAP
15 20 (17.39%) SQL Server 2016
16 19 (16.52%) Data Modelling
16 19 (16.52%) Agile Software Development
17 18 (15.65%) ETL Development
18 17 (14.78%) Microsoft Analysis Services
19 16 (13.91%) Dimensional Modelling
20 15 (13.04%) Web Development
20 15 (13.04%) SQL Server 2012
21 14 (12.17%) .NET
22 13 (11.30%) Law
22 13 (11.30%) SQL Server 2008
23 12 (10.43%) Microsoft Azure
23 12 (10.43%) QlikView
23 12 (10.43%) Visual Studio
24 11 (9.57%) XML

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 8 (6.96%) SharePoint
2 3 (2.61%) IIS
3 2 (1.74%) SAS
4 1 (0.87%) Apache
4 1 (0.87%) Apache Spark
4 1 (0.87%) BizTalk Server
4 1 (0.87%) SharePoint 2010
4 1 (0.87%) Umbraco
Applications
1 4 (3.48%) MS Visio
2 3 (2.61%) Microsoft Excel
3 1 (0.87%) Microsoft Office
3 1 (0.87%) Spreadsheet
Business Applications
1 1 (0.87%) Dynamics AX
Cloud Services
1 12 (10.43%) Microsoft Azure
2 1 (0.87%) Amazon AWS
2 1 (0.87%) Azure Data Factory
2 1 (0.87%) Azure Machine Learning
2 1 (0.87%) Data Lake Analytics
2 1 (0.87%) Dynamics 365
Communications & Networking
1 2 (1.74%) Intranet
1 2 (1.74%) SAN
Database & Business Intelligence
1 103 (89.57%) SQL Server Integration Services
2 93 (80.87%) SQL Server Reporting Services
3 85 (73.91%) SQL Server
4 56 (48.70%) Data Warehouse
5 28 (24.35%) Power BI
6 22 (19.13%) OLAP
7 20 (17.39%) SQL Server 2016
8 17 (14.78%) Microsoft Analysis Services
9 15 (13.04%) SQL Server 2012
10 13 (11.30%) SQL Server 2008
11 12 (10.43%) QlikView
12 11 (9.57%) SQL Server 2014
13 9 (7.83%) BusinessObjects
13 9 (7.83%) OLAP Cube
14 8 (6.96%) DataStage
14 8 (6.96%) MS Access
14 8 (6.96%) PerformancePoint
14 8 (6.96%) SQL Server 2005
15 6 (5.22%) Enterprise Data Warehouse
15 6 (5.22%) IBM InfoSphere
Development Applications
1 12 (10.43%) Visual Studio
2 10 (8.70%) Team Foundation Server
3 3 (2.61%) Subversion
4 2 (1.74%) Eclipse
4 2 (1.74%) ERwin
4 2 (1.74%) Toad
5 1 (0.87%) Jenkins
5 1 (0.87%) Octopus Deploy
5 1 (0.87%) SQL Server Management Studio (SSMS)
5 1 (0.87%) Visual Studio Team System
General
1 41 (35.65%) Finance
2 13 (11.30%) Law
3 6 (5.22%) Marketing
4 5 (4.35%) Retail
5 4 (3.48%) Banking
6 3 (2.61%) Advertising
7 1 (0.87%) Financial Institution
7 1 (0.87%) Investment Banking
7 1 (0.87%) Legal
7 1 (0.87%) Manufacturing
7 1 (0.87%) Pharmaceutical
7 1 (0.87%) Retail Banking
Job Titles
1 90 (78.26%) Developer
2 51 (44.35%) Business Intelligence Developer
3 39 (33.91%) SSIS Developer
4 38 (33.04%) SSAS Developer
5 24 (20.87%) SQL Developer
5 24 (20.87%) SSRS Developer
6 16 (13.91%) SQL BI Developer
7 14 (12.17%) Business Developer
8 9 (7.83%) .NET Developer
8 9 (7.83%) Analyst
8 9 (7.83%) C# Developer
8 9 (7.83%) DBA
8 9 (7.83%) Senior Developer
8 9 (7.83%) SQL DBA
9 8 (6.96%) Business Intelligence Analyst
9 8 (6.96%) C# .NET Developer
10 7 (6.09%) XML Developer
11 6 (5.22%) JavaScript Developer
11 6 (5.22%) QlikView Developer
11 6 (5.22%) VB.NET Developer
Libraries, Frameworks & Software Standards
1 33 (28.70%) MDX
2 14 (12.17%) .NET
3 11 (9.57%) XML
4 7 (6.09%) CSS
4 7 (6.09%) SOAP
5 5 (4.35%) Web Services
6 4 (3.48%) WCF
7 3 (2.61%) jQuery
8 2 (1.74%) .NET Framework
8 2 (1.74%) AngularJS
8 2 (1.74%) ASP.NET
8 2 (1.74%) HTML
8 2 (1.74%) XHTML
9 1 (0.87%) ASP.NET MVC
9 1 (0.87%) ASP.NET Web API
9 1 (0.87%) ASP.NET Web Forms
9 1 (0.87%) COM
9 1 (0.87%) DCOM
9 1 (0.87%) J2EE
9 1 (0.87%) WPF
Miscellaneous
1 6 (5.22%) Greenfield Project
2 5 (4.35%) Analytical Skills
3 4 (3.48%) Replication
4 3 (2.61%) Clustering
4 3 (2.61%) Market Risk
5 2 (1.74%) Data Centre
5 2 (1.74%) Data Structures
5 2 (1.74%) NHS
5 2 (1.74%) W3C
6 1 (0.87%) Derivative
6 1 (0.87%) Digital Media
6 1 (0.87%) Equities
6 1 (0.87%) Equity Derivative
6 1 (0.87%) Fixed Income
6 1 (0.87%) Foreign Exchange (FX)
6 1 (0.87%) Grid Computing
6 1 (0.87%) Hedge funds
6 1 (0.87%) Hybrid Cloud
6 1 (0.87%) Reinsurance
Operating Systems
1 7 (6.09%) Windows
2 6 (5.22%) Linux
3 5 (4.35%) Unix
3 5 (4.35%) Windows Server 2003
4 3 (2.61%) Windows Server
5 2 (1.74%) Windows Server 2008
6 1 (0.87%) VMS
6 1 (0.87%) Windows Server 2012
Processes & Methodologies
1 100 (86.96%) Business Intelligence
2 47 (40.87%) ETL
3 26 (22.61%) Kimball Methodology
4 19 (16.52%) Agile Software Development
4 19 (16.52%) Data Modelling
5 18 (15.65%) ETL Development
6 16 (13.91%) Dimensional Modelling
7 15 (13.04%) Web Development
8 11 (9.57%) Unit Testing
9 9 (7.83%) Data Analysis
10 8 (6.96%) Analytics
11 7 (6.09%) Migration
11 7 (6.09%) Scrum
12 6 (5.22%) Data Visualisation
12 6 (5.22%) Front End Development
12 6 (5.22%) Performance Tuning
12 6 (5.22%) SDLC
12 6 (5.22%) Visualisation
12 6 (5.22%) Web Application Development
13 5 (4.35%) Performance Optimisation
Programming Languages
1 85 (73.91%) SQL
2 37 (32.17%) T-SQL
3 24 (20.87%) C#
4 11 (9.57%) Data Analysis Expressions (DAX)
5 10 (8.70%) JavaScript
6 7 (6.09%) MUMPS
6 7 (6.09%) VB.NET
7 4 (3.48%) PL/SQL
7 4 (3.48%) PowerShell
7 4 (3.48%) VB
8 3 (2.61%) Python
8 3 (2.61%) Shell Script
8 3 (2.61%) VBScript
9 2 (1.74%) C++
9 2 (1.74%) Java
9 2 (1.74%) R
9 2 (1.74%) SAS Macro
9 2 (1.74%) VBA
9 2 (1.74%) VC++
10 1 (0.87%) C
Qualifications
1 5 (4.35%) Degree
2 2 (1.74%) Computer Science Degree
3 1 (0.87%) ITIL Certification
3 1 (0.87%) MCDBA
3 1 (0.87%) Microsoft Certification
3 1 (0.87%) SC Cleared
3 1 (0.87%) Security Cleared
Quality Assurance & Compliance
1 7 (6.09%) QA
2 6 (5.22%) ISO/IEC 27001
3 3 (2.61%) Data Quality
3 3 (2.61%) Solvency II
Systems Management
1 3 (2.61%) Microsoft Clustering
2 2 (1.74%) WMI
3 1 (0.87%) Opscode Chef
Vendors
1 61 (53.04%) Microsoft
2 11 (9.57%) IBM
3 9 (7.83%) Oracle
4 8 (6.96%) Informatica
5 5 (4.35%) Netezza
6 4 (3.48%) Tableau
7 3 (2.61%) Cognos
8 1 (0.87%) Aderant
8 1 (0.87%) Guidewire
8 1 (0.87%) IDERA
8 1 (0.87%) MicroStrategy
8 1 (0.87%) Salesforce.com
8 1 (0.87%) Tagetik