Period
to 23 November 2017

The following table provides summary statistics for contract job vacancies advertised in London with a requirement for OLAP skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited OLAP over the 6 months to 23 November 2017 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.

Online Analytical Processing (OLAP)
England > London
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 488 518 450
Rank change year-on-year +30 -68 -27
Contract jobs citing OLAP 148 101 179
As % of all contract IT jobs advertised in London 0.31% 0.22% 0.38%
As % of the Database & Business Intelligence category 1.32% 0.96% 1.59%
Number of daily rates quoted 123 81 143
London median daily rate £525 £475 £450
Median daily rate % change year-on-year +10.53% +5.56% -
10th Percentile £400 £325 £301
90th Percentile £675 £625 £648
England median daily rate £475 £425 £425
% change year-on-year +11.76% - -
Number of hourly rates quoted 0 0 0
London median hourly rate - - -
England median hourly rate £55.00 - -

OLAP 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 London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Contract vacancies with a requirement for database or business intelligence skills 11221 10532 11240
As % of all contract IT jobs advertised in London 23.82% 23.30% 24.12%
Number of daily rates quoted 8339 7465 8017
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% +5.88%
10th Percentile £355 £325 £305
90th Percentile £663 £638 £625
England median daily rate £460 £425 £413
% change year-on-year +8.24% +3.03% +3.13%
Number of hourly rates quoted 62 39 75
London median hourly rate £26.88 £29.88 £22.50
Median hourly rate % change year-on-year -10.03% +32.80% -18.18%
10th Percentile £18.28 £15.25 £14.85
90th Percentile £58.75 £84.40 £92.00
England median hourly rate £32.00 £28.00 £27.50
% change year-on-year +14.29% +1.82% +11.11%

OLAP
Job Vacancy Trend in London

Job postings citing OLAP as a percentage of all IT jobs advertised in London.

Job vacancy trend for OLAP in London

OLAP
Contractor Daily Rate Trend in London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing OLAP in London.

Contractor daily rate trend for OLAP in London

OLAP
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing OLAP in London over the 6 months to 23 November 2017.

Contractor daily rate histogram for OLAP in London

OLAP
Contractor Hourly Rate Trend in London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing OLAP in London.

Contractor hourly rate trend for OLAP in London

OLAP
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the London region over the 6 months to 23 November 2017. 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
Central London +16 28 £500 -4.76% 4
West London -2 4 £450 -0.66%
South London -31 2 £525 +43.84%
East London -7 1 £350 -26.32%
OLAP
England

For the 6 months to 23 November 2017, IT contractor jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the London region with a requirement for OLAP.

1 101 (68.24%) SQL Server
2 93 (62.84%) SQL
3 92 (62.16%) Business Intelligence
4 78 (52.70%) ETL
5 74 (50.00%) SQL Server Integration Services
6 73 (49.32%) Microsoft
7 68 (45.95%) SQL Server Reporting Services
7 68 (45.95%) SQL Server Analysis Services
8 65 (43.92%) Data Warehouse
9 54 (36.49%) Finance
10 51 (34.46%) MDX
11 46 (31.08%) Data Modelling
12 45 (30.41%) Agile Software Development
13 42 (28.38%) C#
14 41 (27.70%) Banking
14 41 (27.70%) OLAP Cube
15 40 (27.03%) Kimball Methodology
16 37 (25.00%) T-SQL
17 35 (23.65%) Java
18 32 (21.62%) JavaScript
18 32 (21.62%) SQL Server 2008
18 32 (21.62%) Tableau
19 31 (20.95%) Power BI
20 29 (19.59%) Analytical Skills
21 28 (18.92%) Oracle OLAP
21 28 (18.92%) Oracle
22 27 (18.24%) SQL Server 2012
23 26 (17.57%) Dimensional Modelling
24 25 (16.89%) Analytics
25 23 (15.54%) Performance Tuning

OLAP
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 8 (5.41%) SharePoint
2 6 (4.05%) Apache Spark
2 6 (4.05%) SAS
3 5 (3.38%) Apache
4 2 (1.35%) IIS
4 2 (1.35%) SharePoint 2010
5 1 (0.68%) Apache Pig
Applications
1 20 (13.51%) Microsoft Excel
2 6 (4.05%) Microsoft PowerPoint
3 5 (3.38%) MS Visio
4 4 (2.70%) Microsoft Office
5 1 (0.68%) Microsoft Project
5 1 (0.68%) Spreadsheet
Business Applications
1 9 (6.08%) ION MarketView
2 4 (2.70%) Dynamics AX
3 2 (1.35%) Dynamics CRM
3 2 (1.35%) Oracle Retail
3 2 (1.35%) SAP R/3
Cloud Services
1 17 (11.49%) Microsoft Azure
2 12 (8.11%) Amazon AWS
3 4 (2.70%) Dynamics 365
4 2 (1.35%) OpenShift
5 1 (0.68%) Cloud Computing
5 1 (0.68%) IaaS
5 1 (0.68%) PaaS
Communications & Networking
1 1 (0.68%) Kerberos
Database & Business Intelligence
1 101 (68.24%) SQL Server
2 74 (50.00%) SQL Server Integration Services
3 68 (45.95%) SQL Server Analysis Services
3 68 (45.95%) SQL Server Reporting Services
4 65 (43.92%) Data Warehouse
5 41 (27.70%) OLAP Cube
6 32 (21.62%) SQL Server 2008
7 31 (20.95%) Power BI
8 28 (18.92%) Oracle OLAP
9 27 (18.24%) SQL Server 2012
10 21 (14.19%) SQL Server 2016
11 16 (10.81%) Microsoft Analysis Services
11 16 (10.81%) OLTP
11 16 (10.81%) PowerPivot
12 15 (10.14%) BusinessObjects
13 13 (8.78%) QlikView
14 11 (7.43%) Relational Database
14 11 (7.43%) SQL Server 2014
15 10 (6.76%) PostgreSQL
16 9 (6.08%) Oracle BI EE
Development Applications
1 17 (11.49%) Visual Studio
2 12 (8.11%) Team Foundation Server
3 8 (5.41%) Subversion
4 6 (4.05%) Bitbucket
4 6 (4.05%) ERwin
4 6 (4.05%) JIRA
4 6 (4.05%) Octopus Deploy
5 2 (1.35%) Git (software)
5 2 (1.35%) Toad
6 1 (0.68%) Eclipse
6 1 (0.68%) TeamCity
General
1 54 (36.49%) Finance
2 41 (27.70%) Banking
3 20 (13.51%) Front Office
4 18 (12.16%) Investment Banking
5 10 (6.76%) Back Office
6 6 (4.05%) Publishing
7 5 (3.38%) Retail
8 4 (2.70%) Retail Banking
9 2 (1.35%) Marketing
10 1 (0.68%) Advertising
10 1 (0.68%) Legal
10 1 (0.68%) Telecoms
Job Titles
1 108 (72.97%) Developer
2 42 (28.38%) Business Intelligence Developer
3 36 (24.32%) SQL Developer
4 22 (14.86%) Senior Developer
5 20 (13.51%) JavaScript Developer
6 19 (12.84%) SSAS Developer
7 17 (11.49%) SSIS Developer
8 16 (10.81%) Analyst
9 15 (10.14%) C# Developer
9 15 (10.14%) SQL BI Developer
10 12 (8.11%) Data Warehouse Developer
10 12 (8.11%) SQL Server Developer
11 11 (7.43%) HTML Developer
12 10 (6.76%) Business Intelligence Analyst
12 10 (6.76%) Node.js Developer
12 10 (6.76%) SSRS Developer
13 9 (6.08%) Business Developer
14 8 (5.41%) Data Analyst
14 8 (5.41%) Full Stack Developer
14 8 (5.41%) SQL Analyst
Libraries, Frameworks & Software Standards
1 51 (34.46%) MDX
2 20 (13.51%) .NET
3 18 (12.16%) XML
4 16 (10.81%) HTML
5 15 (10.14%) HTML5
6 14 (9.46%) Web Services
7 13 (8.78%) Node.js
7 13 (8.78%) XSD
7 13 (8.78%) XSLT
8 12 (8.11%) AngularJS
9 10 (6.76%) Kendo UI
10 8 (5.41%) D3.js
11 6 (4.05%) JSON
11 6 (4.05%) Kafka
11 6 (4.05%) SOAP
12 5 (3.38%) Apache Camel
12 5 (3.38%) Ext JS
13 4 (2.70%) JDBC
13 4 (2.70%) ODBC
14 3 (2.03%) ASP.NET
Miscellaneous
1 29 (19.59%) Analytical Skills
2 21 (14.19%) Fixed Income
3 10 (6.76%) Foreign Exchange (FX)
4 8 (5.41%) Market Risk
5 7 (4.73%) Greenfield Project
5 7 (4.73%) Hedge funds
6 6 (4.05%) Computer Science
7 5 (3.38%) Data Centre
7 5 (3.38%) Reference Data
7 5 (3.38%) Reinsurance
8 4 (2.70%) Credit Risk
8 4 (2.70%) Equities
9 2 (1.35%) Analytical Mindset
9 2 (1.35%) Clustering
9 2 (1.35%) Replication
10 1 (0.68%) Data Structures
10 1 (0.68%) Derivative
10 1 (0.68%) Grid Computing
10 1 (0.68%) N-Tier
10 1 (0.68%) User Experience
Operating Systems
1 11 (7.43%) Linux
2 8 (5.41%) Unix
3 1 (0.68%) Windows
Processes & Methodologies
1 92 (62.16%) Business Intelligence
2 78 (52.70%) ETL
3 46 (31.08%) Data Modelling
4 45 (30.41%) Agile Software Development
5 40 (27.03%) Kimball Methodology
6 26 (17.57%) Dimensional Modelling
7 25 (16.89%) Analytics
8 23 (15.54%) Performance Tuning
9 21 (14.19%) Visualisation
10 20 (13.51%) Data Analysis
11 18 (12.16%) Continuous Integration
11 18 (12.16%) Scrum
12 17 (11.49%) Data Visualisation
13 16 (10.81%) Migration
13 16 (10.81%) Open Source
14 14 (9.46%) MVVM
15 13 (8.78%) Electronic Trading
15 13 (8.78%) User Acceptance Testing
16 11 (7.43%) DevOps
16 11 (7.43%) ETL Development
Programming Languages
1 93 (62.84%) SQL
2 42 (28.38%) C#
3 37 (25.00%) T-SQL
4 35 (23.65%) Java
5 32 (21.62%) JavaScript
6 18 (12.16%) Data Analysis Expressions (DAX)
7 13 (8.78%) Python
8 9 (6.08%) PL/SQL
9 8 (5.41%) Lisp
10 7 (4.73%) PowerShell
11 5 (3.38%) Shell Script
12 4 (2.70%) C
13 3 (2.03%) R
13 3 (2.03%) VB
14 2 (1.35%) ABAP
14 2 (1.35%) SAS Macro
14 2 (1.35%) XMLA
15 1 (0.68%) TypeScript
15 1 (0.68%) VBA
Qualifications
1 8 (5.41%) Degree
2 6 (4.05%) MCITP
2 6 (4.05%) MCSE
2 6 (4.05%) Microsoft Certification
3 2 (1.35%) Computer Science Degree
3 2 (1.35%) Security Cleared
4 1 (0.68%) BPSS Clearance
4 1 (0.68%) ISEB
4 1 (0.68%) Numerate Degree
4 1 (0.68%) SC Cleared
Quality Assurance & Compliance
1 12 (8.11%) QA
2 6 (4.05%) Data Quality
3 1 (0.68%) Basel II
System Software
1 10 (6.76%) Docker
2 4 (2.70%) Oracle RAC
3 2 (1.35%) Active Directory
4 1 (0.68%) HDFS
4 1 (0.68%) Virtual Machines
4 1 (0.68%) VMware Infrastructure
Systems Management
1 3 (2.03%) Data Guard
2 1 (0.68%) Enterprise Manager Cloud Control
2 1 (0.68%) Oracle Enterprise Manager
2 1 (0.68%) Oracle Identity Management
2 1 (0.68%) Oracle Identity Manager
Vendors
1 73 (49.32%) Microsoft
2 32 (21.62%) Tableau
3 28 (18.92%) Oracle
4 10 (6.76%) Cognos
5 9 (6.08%) ION Trading
6 8 (5.41%) IBM
7 6 (4.05%) Jaspersoft
7 6 (4.05%) RedGate
8 5 (3.38%) Informatica
8 5 (3.38%) InterSystems
8 5 (3.38%) Sencha
9 4 (2.70%) Netezza
10 2 (1.35%) JD Edwards
10 2 (1.35%) Salesforce.com
10 2 (1.35%) SAP
11 1 (0.68%) Atlassian
11 1 (0.68%) MicroStrategy
11 1 (0.68%) Red Hat
11 1 (0.68%) Teradata
11 1 (0.68%) VMware