The following table provides summary statistics for contract job vacancies advertised in the City of 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 3 months to 29 June 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)
London / City of London
3 months to
29 Jun 2017
Same period 2016 Same period 2015
Rank 163 148 159
Rank change year-on-year -15 +11  
Contract jobs citing OLAP 6 15 51
As % of all contract IT jobs advertised in the City of London 0.18% 0.45% 0.87%
As % of the Database & Business Intelligence category 0.72% 1.88% 3.42%
Number of daily rates quoted 4 13 38
Median daily rate £431 £475 £438
Median daily rate % change year-on-year -9.21% +8.57%  
90% offered a daily rate of more than £408 £405 £317
10% offered a daily rate of more than £579 £701 £538
UK excluding London median daily rate £375 £413 £400
% change year-on-year -9.09% +3.12%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £52.50 - -

OLAP is in the database and business intelligence skills category. The next 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 and business intelligence skills.

Contract Database & Business Intelligence Skills
City of London
Contract job vacancies with a requirement for database and business intelligence skills 834 799 1491
As % of all contract IT job vacancies advertised in the City of London 25.52% 23.91% 25.56%
Number of daily rates quoted 1451 1557 2967
Median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.55%  
90% offered a daily rate of more than £375 £330 £313
10% offered a daily rate of more than £675 £638 £625
UK excluding London median daily rate £400 £375 £350
% change year-on-year +6.66% +7.14%  
Number of hourly rates quoted 12 4 7
Median hourly rate £21.50 £17.88 £30.00
Median hourly rate % change year-on-year +20.27% -40.41%  
90% offered a hourly rate of more than £20.75 £16.13 £16.25
10% offered a hourly rate of more than £22.25 £19.50 £106.00
UK excluding London median hourly rate £38.00 £31.95 £26.00
% change year-on-year +18.93% +22.88%  

OLAP
Job Vacancy Trend in the City of London

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

Job vacancy trend for OLAP in the City of London

OLAP
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 OLAP in the City of London.

Contractor daily rate trend for OLAP in the City of London

OLAP
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing OLAP in the City of London over the 3 months to 29 June 2017.

Contractor daily rate histogram for OLAP in the City of London

OLAP
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 OLAP in the City of London.

Contractor hourly rate trend for OLAP in the City of London

For the 6 months to 29 June 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 City of London region with a requirement for OLAP.

1 11 (84.62%) SQL
2 10 (76.92%) SQL Server
3 8 (61.54%) SQL Server Reporting Services
4 7 (53.85%) SQL Server Integration Services
4 7 (53.85%) SQL Server Analysis Services
4 7 (53.85%) Finance
4 7 (53.85%) ETL
5 6 (46.15%) Business Intelligence
5 6 (46.15%) Microsoft Excel
5 6 (46.15%) MDX
6 5 (38.46%) SQL Server 2008
6 5 (38.46%) T-SQL
6 5 (38.46%) Data Warehouse
7 4 (30.77%) SAS
7 4 (30.77%) Data Modelling
7 4 (30.77%) Data Analysis
7 4 (30.77%) SQL Server 2014
7 4 (30.77%) SQL Server 2016
8 3 (23.08%) Microsoft
9 2 (15.38%) C#
9 2 (15.38%) .NET
9 2 (15.38%) Oracle
9 2 (15.38%) Investment Banking
9 2 (15.38%) Oracle OLAP
9 2 (15.38%) Agile Software Development
9 2 (15.38%) Banking
9 2 (15.38%) Fixed Income
9 2 (15.38%) Front Office
9 2 (15.38%) Scorecard
9 2 (15.38%) Continuous Integration

OLAP
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 4 (30.77%) SAS
Applications
1 6 (46.15%) Microsoft Excel
2 1 (7.69%) MS Visio
Business Applications
1 1 (7.69%) Cognos Business Intelligence
1 1 (7.69%) ION MarketView
1 1 (7.69%) Oracle EBS
1 1 (7.69%) PeopleSoft HCM
Cloud Services
1 1 (7.69%) Amazon AWS
1 1 (7.69%) Microsoft Azure
Database & Business Intelligence
1 10 (76.92%) SQL Server
2 8 (61.54%) SQL Server Reporting Services
3 7 (53.85%) SQL Server Analysis Services
3 7 (53.85%) SQL Server Integration Services
4 5 (38.46%) Data Warehouse
4 5 (38.46%) SQL Server 2008
5 4 (30.77%) SQL Server 2014
5 4 (30.77%) SQL Server 2016
6 2 (15.38%) OLAP Cube
6 2 (15.38%) Oracle OLAP
7 1 (7.69%) Cognos Framework Manager
7 1 (7.69%) Cognos Transformer
7 1 (7.69%) MOLAP
7 1 (7.69%) OLTP
7 1 (7.69%) Oracle Database
7 1 (7.69%) Oracle Database 11g
7 1 (7.69%) Oracle Database 12c
7 1 (7.69%) Oracle ODI
7 1 (7.69%) Oracle Reports
7 1 (7.69%) SQL Server 2012
Development Applications
1 1 (7.69%) Team Foundation Server
1 1 (7.69%) Visual Studio
General
1 7 (53.85%) Finance
2 2 (15.38%) Banking
2 2 (15.38%) Front Office
2 2 (15.38%) Investment Banking
3 1 (7.69%) Back Office
Job Titles
1 10 (76.92%) Developer
2 4 (30.77%) Database Developer
3 3 (23.08%) Business Intelligence Developer
4 2 (15.38%) Architect
4 2 (15.38%) Business Intelligence Architect
4 2 (15.38%) Data Architect
4 2 (15.38%) SQL BI Architect
4 2 (15.38%) SQL Developer
5 1 (7.69%) Business Intelligence Lead
5 1 (7.69%) Cloud Developer
5 1 (7.69%) Lead Data Architect
5 1 (7.69%) Microsoft BI Developer
5 1 (7.69%) OBIEE Developer
5 1 (7.69%) OLAP Developer
5 1 (7.69%) Oracle BI Developer
5 1 (7.69%) Report Specialist
5 1 (7.69%) Senior Business Intelligence Developer
5 1 (7.69%) SQL BI Developer
5 1 (7.69%) SQL Server Architect
5 1 (7.69%) SSIS Developer
Libraries, Frameworks & Software Standards
1 6 (46.15%) MDX
2 2 (15.38%) .NET
3 1 (7.69%) HTML
3 1 (7.69%) HTML5
3 1 (7.69%) Node.js
3 1 (7.69%) XML
3 1 (7.69%) XSD
3 1 (7.69%) XSLT
Miscellaneous
1 2 (15.38%) Fixed Income
2 1 (7.69%) Analytical Skills
2 1 (7.69%) Derivative
2 1 (7.69%) Foreign Exchange (FX)
2 1 (7.69%) Hedge funds
2 1 (7.69%) Interest Rate Derivative
2 1 (7.69%) Management Information System
Processes & Methodologies
1 7 (53.85%) ETL
2 6 (46.15%) Business Intelligence
3 4 (30.77%) Data Analysis
3 4 (30.77%) Data Modelling
4 2 (15.38%) Agile Software Development
4 2 (15.38%) Continuous Integration
4 2 (15.38%) Data Architecture
4 2 (15.38%) Scorecard
5 1 (7.69%) Change Control
5 1 (7.69%) Defect Management
5 1 (7.69%) Dimensional Modelling
5 1 (7.69%) Electronic Trading
5 1 (7.69%) Logical Data Model
5 1 (7.69%) MVVM
5 1 (7.69%) Open Source
5 1 (7.69%) Physical Data Model
5 1 (7.69%) SDLC
5 1 (7.69%) Stakeholder Engagement
5 1 (7.69%) System Testing
5 1 (7.69%) Time Management
Programming Languages
1 11 (84.62%) SQL
2 5 (38.46%) T-SQL
3 2 (15.38%) C#
4 1 (7.69%) Java
4 1 (7.69%) JavaScript
4 1 (7.69%) PL/SQL
4 1 (7.69%) VB
4 1 (7.69%) VB6
4 1 (7.69%) VBA
Qualifications
1 1 (7.69%) Degree
Quality Assurance & Compliance
1 1 (7.69%) Data Quality
Vendors
1 3 (23.08%) Microsoft
2 2 (15.38%) Oracle
3 1 (7.69%) Cognos
3 1 (7.69%) ION Trading
3 1 (7.69%) PeopleSoft
City, London
Devonshire Hayes Recruitment Specialists Ltd
Rate: From £380 to £410 per day
Posted: 6 days ago