Period
to 17 November 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 17 November 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
17 Nov 2018
Same period 2017 Same period 2016
Rank 649 606 611
Rank change year-on-year -43 +5 -105
Contract jobs citing OLAP 211 254 268
As % of all contract IT jobs advertised in England 0.22% 0.27% 0.27%
As % of the Database & Business Intelligence category 0.99% 1.22% 1.20%
Number of daily rates quoted 148 179 206
England median daily rate £488 £475 £434
Median daily rate % change year-on-year +2.63% +9.51% +2.06%
10th Percentile £345 £345 £310
90th Percentile £604 £650 £588
UK median daily rate £500 £475 £425
% change year-on-year +5.26% +11.76% -
Number of hourly rates quoted 2 1 0
England median hourly rate £18.50 £55.00 -
Median hourly rate % change year-on-year -66.36% - -
UK median hourly rate £18.50 £55.00 -
% change year-on-year -66.36% - -

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,325 20,849 22,242
As % of all contract IT jobs advertised in England 22.61% 22.05% 22.60%
Number of daily rates quoted 14,991 14,419 14,923
England median daily rate £475 £454 £425
Median daily rate % change year-on-year +4.63% +6.82% +3.03%
10th Percentile £318 £313 £288
90th Percentile £644 £638 £600
UK median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 218 262 322
England median hourly rate £34.25 £31.75 £28.00
Median hourly rate % change year-on-year +7.87% +13.39% +0.79%
10th Percentile £14.26 £14.28 £11.25
90th Percentile £57.50 £56.64 £48.68
UK median hourly rate £32.75 £31.23 £28.18
% change year-on-year +4.87% +10.82% -1.12%

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 17 November 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 17 November 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 -31 104 £525 - 19
South East -28 26 £475 +21.79% 7
South West -2 25 £525 +10.53% 1
North of England -30 25 £425 - 3
East of England +13 19 £450 - 5
Yorkshire -15 15 £425 +21.43% 1
Midlands -28 12 £450 +12.50% 6
North West -10 9 £385 -28.37% 2
West Midlands -34 9 £450 +12.50% 2
East Midlands +12 3 - - 4
North East -4 1 £450 +2.86%
OLAP
UK

For the 6 months to 17 November 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 157 (74.41%) Data Warehouse
2 140 (66.35%) SQL
3 100 (47.39%) Business Intelligence
4 90 (42.65%) ETL
5 78 (36.97%) Finance
6 75 (35.55%) Data Modelling
6 75 (35.55%) Analytics
7 70 (33.18%) SQL Server
8 67 (31.75%) OLAP Cube
9 64 (30.33%) Big Data
10 63 (29.86%) Agile Software Development
10 63 (29.86%) SQL Server Integration Services
11 62 (29.38%) Microsoft
12 59 (27.96%) SQL Server Analysis Services
13 58 (27.49%) SQL Server Reporting Services
14 45 (21.33%) Data Quality
15 43 (20.38%) Hadoop
16 42 (19.91%) Star Schema
17 40 (18.96%) Kafka
17 40 (18.96%) Power BI
18 38 (18.01%) Apache Hive
19 37 (17.54%) Relational Database
20 34 (16.11%) Machine Learning
20 34 (16.11%) Oracle OLAP
20 34 (16.11%) Oracle
21 33 (15.64%) Kimball Methodology
21 33 (15.64%) Apache Spark
21 33 (15.64%) Data Science
22 32 (15.17%) Visualisation
23 31 (14.69%) OLTP

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 33 (15.64%) Apache Spark
2 12 (5.69%) SAS
3 11 (5.21%) Apache
4 4 (1.90%) SharePoint
4 4 (1.90%) Tomcat
5 2 (0.95%) IIS
6 1 (0.47%) WebLogic
Applications
1 19 (9.00%) Microsoft Excel
2 6 (2.84%) Microsoft Office
2 6 (2.84%) Spreadsheet
Business Applications
1 7 (3.32%) Infor M3
2 3 (1.42%) FastStats
2 3 (1.42%) HFM
3 2 (0.95%) Dynamics AX
4 1 (0.47%) Cognos Business Intelligence
4 1 (0.47%) Cognos TM1
4 1 (0.47%) Dynamics CRM
4 1 (0.47%) Dynamics NAV
4 1 (0.47%) NetSuite
Cloud Services
1 24 (11.37%) Microsoft Azure
2 8 (3.79%) PaaS
3 7 (3.32%) Data Lake Analytics
4 5 (2.37%) Azure Data Factory
5 4 (1.90%) IaaS
6 3 (1.42%) Amazon AWS
6 3 (1.42%) GitHub
7 2 (0.95%) Google Analytics
8 1 (0.47%) Azure Machine Learning
8 1 (0.47%) Cloud Computing
8 1 (0.47%) Dynamics 365
8 1 (0.47%) SaaS
Communications & Networking
1 2 (0.95%) Internet
2 1 (0.47%) Extranet
2 1 (0.47%) Intranet
Database & Business Intelligence
1 157 (74.41%) Data Warehouse
2 70 (33.18%) SQL Server
3 67 (31.75%) OLAP Cube
4 64 (30.33%) Big Data
5 63 (29.86%) SQL Server Integration Services
6 59 (27.96%) SQL Server Analysis Services
7 58 (27.49%) SQL Server Reporting Services
8 43 (20.38%) Hadoop
9 42 (19.91%) Star Schema
10 40 (18.96%) Power BI
11 38 (18.01%) Apache Hive
12 37 (17.54%) Relational Database
13 34 (16.11%) Oracle OLAP
14 31 (14.69%) OLTP
15 30 (14.22%) Enterprise Data Warehouse
16 24 (11.37%) Data Lake
17 22 (10.43%) Microsoft Analysis Services
18 21 (9.95%) Oracle ODI
19 20 (9.48%) SQL Server 2008
20 19 (9.00%) SQL Server 2012
Development Applications
1 11 (5.21%) Visual Studio
2 10 (4.74%) Toad
3 9 (4.27%) Bitbucket
3 9 (4.27%) Team Foundation Server
4 6 (2.84%) Visual Studio Team System
5 4 (1.90%) Git (software)
6 2 (0.95%) PowerDesigner
6 2 (0.95%) SQL Server Management Studio (SSMS)
6 2 (0.95%) XMLSpy
7 1 (0.47%) Atlassian Bamboo
7 1 (0.47%) Eclipse
7 1 (0.47%) JIRA
7 1 (0.47%) TeamCity
General
1 78 (36.97%) Finance
2 18 (8.53%) Retail
3 10 (4.74%) Banking
4 8 (3.79%) Front Office
5 6 (2.84%) Marketing
6 4 (1.90%) Manufacturing
6 4 (1.90%) Pharmaceutical
6 4 (1.90%) Telecoms
7 3 (1.42%) Electronics
7 3 (1.42%) Financial Institution
8 2 (0.95%) Games
8 2 (0.95%) Investment Banking
8 2 (0.95%) Legal
Job Titles
1 109 (51.66%) Developer
2 44 (20.85%) Business Intelligence Developer
3 31 (14.69%) Data Engineer
4 30 (14.22%) SQL Developer
5 29 (13.74%) Hadoop Engineer
6 18 (8.53%) Data Warehouse Developer
6 18 (8.53%) ETL Developer
7 16 (7.58%) Big Data Engineer
7 16 (7.58%) SQL BI Developer
8 14 (6.64%) Power BI Developer
9 13 (6.16%) Administrator
10 12 (5.69%) Architect
10 12 (5.69%) DBA
10 12 (5.69%) Oracle Developer
10 12 (5.69%) SSAS Developer
11 10 (4.74%) Consultant
11 10 (4.74%) Senior Developer
11 10 (4.74%) SSIS Developer
12 9 (4.27%) Oracle Data Warehouse Developer
12 9 (4.27%) Oracle ETL Developer
Libraries, Frameworks & Software Standards
1 40 (18.96%) Kafka
2 16 (7.58%) MDX
3 12 (5.69%) Web Services
4 10 (4.74%) JSON
4 10 (4.74%) XML
5 9 (4.27%) Oracle GoldenGate
6 8 (3.79%) Apache Camel
7 7 (3.32%) .NET
8 3 (1.42%) ASP.NET Web API
8 3 (1.42%) Swagger
9 2 (0.95%) RESTful
10 1 (0.47%) ADO.NET
10 1 (0.47%) Matplotlib
10 1 (0.47%) NumPy
10 1 (0.47%) Pandas
10 1 (0.47%) REST
10 1 (0.47%) scikit-learn
10 1 (0.47%) SciPy
10 1 (0.47%) SOAP
10 1 (0.47%) XBRL
Miscellaneous
1 19 (9.00%) Analytical Skills
2 18 (8.53%) Data Structures
3 12 (5.69%) Self-Motivation
4 11 (5.21%) Replication
5 7 (3.32%) Greenfield Project
6 5 (2.37%) Computer Science
6 5 (2.37%) Fixed Income
6 5 (2.37%) Hedge funds
7 1 (0.47%) Credit Risk
7 1 (0.47%) Data Centre
7 1 (0.47%) FMCG
7 1 (0.47%) Management Information System
7 1 (0.47%) Market Risk
7 1 (0.47%) NHS
7 1 (0.47%) Reinsurance
Operating Systems
1 11 (5.21%) Unix
2 3 (1.42%) Windows
3 1 (0.47%) Linux
3 1 (0.47%) Solaris
Processes & Methodologies
1 100 (47.39%) Business Intelligence
2 90 (42.65%) ETL
3 75 (35.55%) Analytics
3 75 (35.55%) Data Modelling
4 63 (29.86%) Agile Software Development
5 34 (16.11%) Machine Learning
6 33 (15.64%) Data Science
6 33 (15.64%) Kimball Methodology
7 32 (15.17%) Visualisation
8 29 (13.74%) Dimensional Modelling
8 29 (13.74%) SQL Optimisation
9 24 (11.37%) Performance Tuning
10 20 (9.48%) Scrum
11 19 (9.00%) Data Integration
11 19 (9.00%) Data Management
12 17 (8.06%) Data Architecture
12 17 (8.06%) Problem-Solving
13 16 (7.58%) Business Analytics
13 16 (7.58%) Data Analysis
13 16 (7.58%) Migration
Programming Languages
1 140 (66.35%) SQL
2 27 (12.80%) T-SQL
3 20 (9.48%) C#
4 17 (8.06%) Java
5 15 (7.11%) Python
6 11 (5.21%) VBA
7 10 (4.74%) Data Analysis Expressions (DAX)
8 9 (4.27%) PL/SQL
9 8 (3.79%) Bash Shell
9 8 (3.79%) Java 8
9 8 (3.79%) Perl
10 6 (2.84%) R
11 5 (2.37%) U-SQL
12 3 (1.42%) Jython
12 3 (1.42%) VBScript
13 2 (0.95%) Go
13 2 (0.95%) PowerShell
14 1 (0.47%) Shell Script
14 1 (0.47%) VB
14 1 (0.47%) XMLA
Qualifications
1 5 (2.37%) Degree
2 4 (1.90%) Microsoft Certification
2 4 (1.90%) Security Cleared
3 2 (0.95%) SC Cleared
4 1 (0.47%) Computer Science Degree
4 1 (0.47%) Master's Degree
4 1 (0.47%) MCSA
4 1 (0.47%) MCSE
4 1 (0.47%) PhD
Quality Assurance & Compliance
1 45 (21.33%) Data Quality
2 7 (3.32%) QA
3 2 (0.95%) EMIR
3 2 (0.95%) MiFID
3 2 (0.95%) Solvency II
4 1 (0.47%) IFRS
System Software
1 8 (3.79%) Docker
2 1 (0.47%) Virtual Machines
Systems Management
1 29 (13.74%) Oozie
2 3 (1.42%) Data Guard
2 3 (1.42%) Oracle EDQ
2 3 (1.42%) Oracle RMAN
3 2 (0.95%) Ambari
3 2 (0.95%) Ganglia
3 2 (0.95%) Nagios
Vendors
1 62 (29.38%) Microsoft
2 34 (16.11%) Oracle
3 16 (7.58%) Tableau
4 12 (5.69%) Informatica
5 11 (5.21%) Ab Initio
5 11 (5.21%) Cognos
5 11 (5.21%) Talend
6 9 (4.27%) Sybase
7 8 (3.79%) EXASOL
7 8 (3.79%) Greenplum
8 7 (3.32%) Infor
8 7 (3.32%) MicroStrategy
9 6 (2.84%) SAP
10 4 (1.90%) IBM
11 3 (1.42%) Anaplan
11 3 (1.42%) Cloudera
11 3 (1.42%) Hortonworks
12 2 (0.95%) Google
12 2 (0.95%) MapR
13 1 (0.47%) Netezza