Period
to 14 August 2018

The following table provides summary statistics for contract job vacancies advertised in England 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 14 August 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.

Online Analytical Processing (OLAP)
UK > England
6 months to
14 Aug 2018
Same period 2017 Same period 2016
Rank 630 610 648
Rank change year-on-year -20 +38 -176
Contract jobs citing OLAP 240 225 249
As % of all contract IT jobs advertised in England 0.26% 0.26% 0.25%
As % of the Database & Business Intelligence category 1.12% 1.13% 1.11%
Number of daily rates quoted 171 160 177
England median daily rate £513 £444 £425
Median daily rate % change year-on-year +15.49% +4.41% -
10th Percentile £350 £318 £306
90th Percentile £588 £625 £600
UK median daily rate £513 £444 £413
% change year-on-year +15.49% +7.58% -2.94%
Number of hourly rates quoted 0 1 0
England median hourly rate - £52.50 -
UK median hourly rate - £52.50 -

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

All Database and Business Intelligence Skills
England
Contract vacancies with a requirement for database or business intelligence skills 21,470 19,983 22,453
As % of all contract IT jobs advertised in England 22.97% 22.68% 22.24%
Number of daily rates quoted 15,147 13,453 15,246
England median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £313 £300 £285
90th Percentile £638 £625 £600
UK median daily rate £463 £450 £425
% change year-on-year +2.78% +5.88% +6.25%
Number of hourly rates quoted 230 230 327
England median hourly rate £30.00 £30.75 £28.50
Median hourly rate % change year-on-year -2.44% +7.89% +14.00%
10th Percentile £14.00 £11.17 £12.00
90th Percentile £52.83 £52.50 £51.00
UK median hourly rate £30.00 £31.50 £29.01
% change year-on-year -4.76% +8.57% +10.52%

OLAP
Job Vacancy Trend in England

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

Job vacancy trend for OLAP in England

OLAP
Contractor Daily Rate Trend in England

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

Contractor daily rate trend for OLAP in England

OLAP
Contractor Daily Rate Histogram in England

The daily rate distribution of IT jobs citing OLAP in England over the 6 months to 14 August 2018.

Contractor daily rate histogram for OLAP in England

OLAP
Contractor Hourly Rate Trend in England

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

Contractor hourly rate trend for OLAP in England

OLAP
Contract Job Locations in England

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the England region over the 6 months to 14 August 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
London +3 141 £525 +3.96% 22
South East -29 34 £475 +37.68% 4
South West +17 24 £525 +2.69% 6
North of England -23 24 £400 +6.73% 12
Yorkshire -23 17 £413 +13.08% 5
Midlands -15 9 £398 +0.95% 2
East of England -2 8 £450 +10.09% 1
North West -15 7 £385 -0.65% 6
West Midlands -30 7 £374 -5.08% 1
East Midlands +8 2 £505 +29.49% 1
OLAP
UK

For the 6 months to 14 August 2018, IT contractor jobs citing OLAP 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 England region with a requirement for OLAP.

1 183 (76.25%) Data Warehouse
2 161 (67.08%) SQL
3 131 (54.58%) Finance
3 131 (54.58%) Analytics
4 118 (49.17%) Data Modelling
5 111 (46.25%) Business Intelligence
5 111 (46.25%) Big Data
6 106 (44.17%) OLAP Cube
7 94 (39.17%) Hadoop
8 92 (38.33%) Data Quality
9 90 (37.50%) Star Schema
10 87 (36.25%) Apache Hive
11 83 (34.58%) ETL
12 82 (34.17%) Data Science
13 81 (33.75%) SQL Server
14 78 (32.50%) Apache Spark
15 77 (32.08%) Kafka
16 76 (31.67%) Machine Learning
17 72 (30.00%) Enterprise Data Warehouse
18 70 (29.17%) SQL Server Integration Services
19 69 (28.75%) Oozie
20 67 (27.92%) SQL Optimisation
21 62 (25.83%) SQL Server Reporting Services
21 62 (25.83%) Microsoft
22 57 (23.75%) SQL Server Analysis Services
23 45 (18.75%) Agile Software Development
24 42 (17.50%) Oracle OLAP
24 42 (17.50%) Oracle
25 39 (16.25%) Power BI
26 36 (15.00%) Data Lake

OLAP
Co-occurring IT Skills in England 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 78 (32.50%) Apache Spark
2 14 (5.83%) SAS
3 8 (3.33%) Apache
4 6 (2.50%) SharePoint
5 4 (1.67%) Tomcat
6 1 (0.42%) Confluence
6 1 (0.42%) IIS
Applications
1 28 (11.67%) Microsoft Excel
2 6 (2.50%) Microsoft Office
2 6 (2.50%) Spreadsheet
3 1 (0.42%) Microsoft PowerPoint
3 1 (0.42%) Microsoft Project
Business Applications
1 5 (2.08%) HFM
2 4 (1.67%) Dynamics AX
3 3 (1.25%) NetSuite
3 3 (1.25%) Oracle ERP
4 2 (0.83%) FastStats
4 2 (0.83%) Infor M3
5 1 (0.42%) Cognos TM1
Cloud Services
1 30 (12.50%) Microsoft Azure
2 12 (5.00%) Amazon AWS
3 8 (3.33%) PaaS
4 6 (2.50%) Amazon S3
5 5 (2.08%) Azure Data Factory
5 5 (2.08%) Data Lake Analytics
6 4 (1.67%) Google Analytics
7 3 (1.25%) Dynamics 365
8 2 (0.83%) Adobe Analytics
8 2 (0.83%) OpenShift
9 1 (0.42%) Azure Machine Learning
9 1 (0.42%) Cloud Computing
9 1 (0.42%) IaaS
Communications & Networking
1 2 (0.83%) Internet
2 1 (0.42%) SSL
Database & Business Intelligence
1 183 (76.25%) Data Warehouse
2 111 (46.25%) Big Data
3 106 (44.17%) OLAP Cube
4 94 (39.17%) Hadoop
5 90 (37.50%) Star Schema
6 87 (36.25%) Apache Hive
7 81 (33.75%) SQL Server
8 72 (30.00%) Enterprise Data Warehouse
9 70 (29.17%) SQL Server Integration Services
10 62 (25.83%) SQL Server Reporting Services
11 57 (23.75%) SQL Server Analysis Services
12 42 (17.50%) Oracle OLAP
13 39 (16.25%) Power BI
14 36 (15.00%) Data Lake
15 27 (11.25%) OLTP
16 26 (10.83%) Relational Database
17 24 (10.00%) NoSQL
18 23 (9.58%) SQL Server 2012
19 21 (8.75%) Microsoft Analysis Services
20 20 (8.33%) SQL Server 2008
Development Applications
1 17 (7.08%) Git (software)
2 12 (5.00%) Visual Studio
3 6 (2.50%) Jenkins
4 5 (2.08%) Toad
4 5 (2.08%) Visual Studio Team System
5 3 (1.25%) SQL Server Management Studio (SSMS)
5 3 (1.25%) Team Foundation Server
6 1 (0.42%) Eclipse
6 1 (0.42%) JIRA
6 1 (0.42%) Octopus Deploy
General
1 131 (54.58%) Finance
2 20 (8.33%) Retail
3 17 (7.08%) Banking
4 9 (3.75%) Marketing
5 7 (2.92%) Front Office
6 4 (1.67%) Manufacturing
7 3 (1.25%) Telecoms
8 2 (0.83%) Electronics
8 2 (0.83%) Financial Institution
9 1 (0.42%) Dutch Language
9 1 (0.42%) French Language
9 1 (0.42%) German Language
9 1 (0.42%) Investment Banking
9 1 (0.42%) Italian Language
9 1 (0.42%) Legal
9 1 (0.42%) Pharmaceutical
9 1 (0.42%) Retail Banking
9 1 (0.42%) Spanish Language
Job Titles
1 84 (35.00%) Developer
2 79 (32.92%) Data Engineer
3 71 (29.58%) Hadoop Engineer
4 40 (16.67%) Business Intelligence Developer
5 34 (14.17%) Big Data Engineer
6 28 (11.67%) SQL Developer
7 21 (8.75%) Architect
8 16 (6.67%) SQL BI Developer
8 16 (6.67%) SSAS Developer
9 14 (5.83%) Senior Developer
10 11 (4.58%) Administrator
10 11 (4.58%) Business Developer
10 11 (4.58%) SSIS Developer
11 10 (4.17%) Analyst
11 10 (4.17%) DBA
11 10 (4.17%) Oracle Developer
12 8 (3.33%) Data Architect
12 8 (3.33%) Power BI Developer
12 8 (3.33%) Solutions Architect
12 8 (3.33%) SSRS Developer
Libraries, Frameworks & Software Standards
1 77 (32.08%) Kafka
2 24 (10.00%) MDX
3 13 (5.42%) .NET
4 7 (2.92%) XML
5 6 (2.50%) RabbitMQ
6 5 (2.08%) LAMP
6 5 (2.08%) LAPP Stack
7 4 (1.67%) JSON
8 2 (0.83%) ASP.NET
8 2 (0.83%) REST
9 1 (0.42%) D3.js
9 1 (0.42%) Matplotlib
9 1 (0.42%) Natural Language Processing
9 1 (0.42%) NumPy
9 1 (0.42%) OAuth
9 1 (0.42%) OpenID
9 1 (0.42%) Pandas
9 1 (0.42%) scikit-learn
9 1 (0.42%) SciPy
9 1 (0.42%) Swagger
Miscellaneous
1 28 (11.67%) Analytical Skills
2 13 (5.42%) Data Structures
3 10 (4.17%) Self-Motivation
4 6 (2.50%) Computer Science
4 6 (2.50%) Greenfield Project
5 5 (2.08%) Fixed Income
5 5 (2.08%) Management Information System
6 3 (1.25%) Credit Risk
6 3 (1.25%) Hedge funds
7 2 (0.83%) Replication
7 2 (0.83%) Robotics
8 1 (0.42%) Algorithms
8 1 (0.42%) Cloud Native
8 1 (0.42%) Data Centre
8 1 (0.42%) Fintech
8 1 (0.42%) Market Risk
8 1 (0.42%) Mobile App
8 1 (0.42%) NHS
8 1 (0.42%) PMI
8 1 (0.42%) Reinsurance
Operating Systems
1 10 (4.17%) Unix
2 6 (2.50%) Linux
3 3 (1.25%) Windows
Processes & Methodologies
1 131 (54.58%) Analytics
2 118 (49.17%) Data Modelling
3 111 (46.25%) Business Intelligence
4 83 (34.58%) ETL
5 82 (34.17%) Data Science
6 76 (31.67%) Machine Learning
7 67 (27.92%) SQL Optimisation
8 45 (18.75%) Agile Software Development
9 31 (12.92%) Visualisation
10 28 (11.67%) Data Management
11 27 (11.25%) Kimball Methodology
12 22 (9.17%) Data Architecture
13 21 (8.75%) Business Analytics
13 21 (8.75%) Data Integration
13 21 (8.75%) Dimensional Modelling
14 20 (8.33%) Performance Tuning
15 19 (7.92%) Problem-Solving
16 18 (7.50%) Data Governance
17 17 (7.08%) Data Visualisation
17 17 (7.08%) SDLC
Programming Languages
1 161 (67.08%) SQL
2 31 (12.92%) T-SQL
3 29 (12.08%) Python
4 24 (10.00%) C#
5 16 (6.67%) Java
6 13 (5.42%) R
7 12 (5.00%) Data Analysis Expressions (DAX)
7 12 (5.00%) PL/SQL
8 11 (4.58%) VBA
9 8 (3.33%) Bash Shell
9 8 (3.33%) Perl
10 6 (2.50%) Scala
11 5 (2.08%) HiveQL
11 5 (2.08%) PowerShell
11 5 (2.08%) Shell Script
12 4 (1.67%) VBScript
13 3 (1.25%) Jython
13 3 (1.25%) U-SQL
14 2 (0.83%) VB.NET
14 2 (0.83%) XMLA
Qualifications
1 7 (2.92%) Degree
2 5 (2.08%) Security Cleared
3 4 (1.67%) Microsoft Certification
4 3 (1.25%) SC Cleared
5 1 (0.42%) Computer Science Degree
5 1 (0.42%) Master's Degree
5 1 (0.42%) MCSA
5 1 (0.42%) MCSE
5 1 (0.42%) PhD
5 1 (0.42%) PMI Certification
5 1 (0.42%) TOGAF Certification
Quality Assurance & Compliance
1 92 (38.33%) Data Quality
2 7 (2.92%) GDPR
3 6 (2.50%) QA
4 2 (0.83%) EMIR
4 2 (0.83%) MiFID
4 2 (0.83%) Solvency II
5 1 (0.42%) IFRS
5 1 (0.42%) PMO
System Software
1 6 (2.50%) Docker
Systems Management
1 69 (28.75%) Oozie
2 6 (2.50%) Kibana
3 3 (1.25%) Data Guard
3 3 (1.25%) Oracle EDQ
3 3 (1.25%) Oracle RMAN
4 1 (0.42%) Ambari
4 1 (0.42%) Control-M
4 1 (0.42%) Ganglia
4 1 (0.42%) Nagios
4 1 (0.42%) Opscode Chef
4 1 (0.42%) Puppet
Vendors
1 62 (25.83%) Microsoft
2 42 (17.50%) Oracle
3 17 (7.08%) Tableau
4 15 (6.25%) Talend
5 14 (5.83%) Cognos
6 12 (5.00%) IBM
7 10 (4.17%) Informatica
8 9 (3.75%) Sybase
9 8 (3.33%) Ab Initio
9 8 (3.33%) Greenplum
10 7 (2.92%) Cloudera
10 7 (2.92%) SAP
11 6 (2.50%) Splunk
12 5 (2.08%) MicroStrategy
12 5 (2.08%) Teradata
13 4 (1.67%) Google
14 3 (1.25%) Anaplan
14 3 (1.25%) Hortonworks
14 3 (1.25%) Hyperion
14 3 (1.25%) JD Edwards