Period
to 24 May 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 24 May 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
24 May 2018
Same period 2017 Same period 2016
Rank 625 625 622
Rank change year-on-year 0 -3 -169
Contract jobs citing OLAP 220 173 229
As % of all contract IT jobs advertised in England 0.24% 0.21% 0.24%
As % of the Database & Business Intelligence category 1.06% 0.92% 1.07%
Number of daily rates quoted 162 132 156
England median daily rate £513 £429 £425
Median daily rate % change year-on-year +19.53% +0.88% -2.86%
10th Percentile £356 £313 £316
90th Percentile £588 £575 £575
UK median daily rate £513 £425 £413
% change year-on-year +20.59% +3.03% -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 20,760 18,866 21,489
As % of all contract IT jobs advertised in England 22.54% 22.60% 22.11%
Number of daily rates quoted 14,586 12,689 14,696
England median daily rate £475 £447 £425
Median daily rate % change year-on-year +6.26% +5.18% +6.25%
10th Percentile £313 £300 £281
90th Percentile £638 £615 £600
UK median daily rate £473 £437 £425
% change year-on-year +8.12% +2.82% +6.25%
Number of hourly rates quoted 212 220 330
England median hourly rate £32.00 £30.00 £27.50
Median hourly rate % change year-on-year +6.67% +9.09% -4.15%
10th Percentile £14.03 £9.25 £12.25
90th Percentile £53.50 £48.88 £53.53
UK median hourly rate £33.00 £30.00 £27.75
% change year-on-year +10.00% +8.11% -3.28%

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 24 May 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 24 May 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 +12 146 £525 +10.53% 24
South East -13 29 £475 +24.35% 6
North of England -11 24 £475 +24.59% 3
Yorkshire -12 11 £413 +10.00% 2
East of England -1 9 £438 +10.76%
North West -15 9 £544 +40.32% 1
Midlands -16 7 £405 +2.86% 1
South West +1 5 £525 +7.69% 1
West Midlands -25 5 £393 +1.29%
North East - 4 £475 -
East Midlands +3 2 £505 +6.32%
OLAP
UK

For the 6 months to 24 May 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 164 (74.55%) SQL
2 141 (64.09%) Data Warehouse
3 117 (53.18%) Finance
4 114 (51.82%) Business Intelligence
5 109 (49.55%) Analytics
6 101 (45.91%) Data Modelling
7 86 (39.09%) Big Data
8 82 (37.27%) Hadoop
8 82 (37.27%) OLAP Cube
9 81 (36.82%) SQL Server
10 75 (34.09%) ETL
11 74 (33.64%) Data Quality
12 69 (31.36%) Apache Hive
12 69 (31.36%) Star Schema
13 68 (30.91%) SQL Server Integration Services
14 67 (30.45%) Apache Spark
15 65 (29.55%) Kafka
16 63 (28.64%) Data Science
17 59 (26.82%) Microsoft
18 58 (26.36%) Enterprise Data Warehouse
18 58 (26.36%) SQL Server Analysis Services
19 56 (25.45%) Machine Learning
19 56 (25.45%) SQL Server Reporting Services
20 53 (24.09%) Oracle OLAP
20 53 (24.09%) Oracle
21 52 (23.64%) Oozie
22 50 (22.73%) SQL Optimisation
23 48 (21.82%) Agile Software Development
24 39 (17.73%) Analytical Skills
25 34 (15.45%) Power BI

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 67 (30.45%) Apache Spark
2 19 (8.64%) SAS
3 10 (4.55%) Apache
4 5 (2.27%) Confluence
4 5 (2.27%) SharePoint
5 1 (0.45%) Elasticsearch
5 1 (0.45%) IIS
Applications
1 22 (10.00%) Microsoft Excel
2 5 (2.27%) Microsoft Office
3 1 (0.45%) Microsoft PowerPoint
3 1 (0.45%) Microsoft Project
3 1 (0.45%) Spreadsheet
Business Applications
1 6 (2.73%) Dynamics AX
2 3 (1.36%) Dynamics NAV
2 3 (1.36%) NetSuite
2 3 (1.36%) Oracle ERP
3 2 (0.91%) Cognos TM1
3 2 (0.91%) HFM
3 2 (0.91%) Summit
4 1 (0.45%) Dynamics CRM
4 1 (0.45%) Dynamics GP
4 1 (0.45%) Hyperion Planning
4 1 (0.45%) SAP BPC
Cloud Services
1 20 (9.09%) Microsoft Azure
2 14 (6.36%) Amazon AWS
3 7 (3.18%) Amazon S3
4 5 (2.27%) Google Analytics
5 4 (1.82%) Dynamics 365
5 4 (1.82%) PaaS
6 3 (1.36%) Adobe Analytics
6 3 (1.36%) Azure Data Factory
6 3 (1.36%) OpenShift
7 1 (0.45%) Amazon EMR
7 1 (0.45%) Cloud Computing
7 1 (0.45%) Data Lake Analytics
Communications & Networking
1 4 (1.82%) SSL
2 2 (0.91%) SAN
3 1 (0.45%) ATM
3 1 (0.45%) Ethernet
3 1 (0.45%) FCoE
3 1 (0.45%) Fibre Channel
3 1 (0.45%) HTTP
3 1 (0.45%) InfiniBand
3 1 (0.45%) Internet
3 1 (0.45%) iSCSI
3 1 (0.45%) LAN
3 1 (0.45%) WAN
Database & Business Intelligence
1 141 (64.09%) Data Warehouse
2 86 (39.09%) Big Data
3 82 (37.27%) Hadoop
3 82 (37.27%) OLAP Cube
4 81 (36.82%) SQL Server
5 69 (31.36%) Apache Hive
5 69 (31.36%) Star Schema
6 68 (30.91%) SQL Server Integration Services
7 58 (26.36%) Enterprise Data Warehouse
7 58 (26.36%) SQL Server Analysis Services
8 56 (25.45%) SQL Server Reporting Services
9 53 (24.09%) Oracle OLAP
10 34 (15.45%) Power BI
11 27 (12.27%) Data Lake
12 24 (10.91%) NoSQL
12 24 (10.91%) OLTP
12 24 (10.91%) Relational Database
13 17 (7.73%) SQL Server 2008
13 17 (7.73%) SQL Server 2012
14 16 (7.27%) Microsoft Analysis Services
Development Applications
1 21 (9.55%) Git (software)
2 10 (4.55%) Jenkins
3 8 (3.64%) Visual Studio
4 6 (2.73%) JIRA
5 5 (2.27%) Bitbucket
6 4 (1.82%) TeamCity
6 4 (1.82%) Visual Studio Team System
7 3 (1.36%) Toad
8 2 (0.91%) Cucumber
8 2 (0.91%) IntelliJ
8 2 (0.91%) JUnit
8 2 (0.91%) Maven
8 2 (0.91%) SonarQube
8 2 (0.91%) SQL Server Management Studio (SSMS)
9 1 (0.45%) git-flow
9 1 (0.45%) Octopus Deploy
9 1 (0.45%) PyCharm
9 1 (0.45%) Sublime Text
9 1 (0.45%) Team Foundation Server
General
1 117 (53.18%) Finance
2 18 (8.18%) Banking
3 9 (4.09%) Retail
4 7 (3.18%) Front Office
4 7 (3.18%) Marketing
5 5 (2.27%) Investment Banking
6 4 (1.82%) Financial Institution
7 3 (1.36%) German Language
8 2 (0.91%) Dutch Language
8 2 (0.91%) French Language
8 2 (0.91%) Italian Language
8 2 (0.91%) Manufacturing
8 2 (0.91%) Spanish Language
9 1 (0.45%) Electronics
9 1 (0.45%) Law
9 1 (0.45%) Legal
9 1 (0.45%) Pharmaceutical
9 1 (0.45%) Retail Banking
9 1 (0.45%) Telecoms
Job Titles
1 76 (34.55%) Developer
2 67 (30.45%) Data Engineer
3 54 (24.55%) Hadoop Engineer
4 29 (13.18%) Business Intelligence Developer
5 27 (12.27%) Architect
6 25 (11.36%) Big Data Engineer
6 25 (11.36%) SQL Developer
7 22 (10.00%) Analyst
8 15 (6.82%) Senior Developer
9 13 (5.91%) SQL BI Developer
9 13 (5.91%) SSAS Developer
10 10 (4.55%) Business Intelligence Consultant
10 10 (4.55%) Consultant
10 10 (4.55%) SSIS Developer
11 9 (4.09%) Business Developer
12 8 (3.64%) Business Intelligence Analyst
12 8 (3.64%) Data Architect
12 8 (3.64%) Oracle Developer
12 8 (3.64%) Solutions Architect
13 7 (3.18%) Data Analyst
Libraries, Frameworks & Software Standards
1 65 (29.55%) Kafka
2 25 (11.36%) MDX
3 21 (9.55%) .NET
4 11 (5.00%) XML
5 8 (3.64%) JSON
6 6 (2.73%) RabbitMQ
6 6 (2.73%) Web Services
7 5 (2.27%) LAMP
7 5 (2.27%) LAPP Stack
8 4 (1.82%) HTML
8 4 (1.82%) REST
8 4 (1.82%) SOAP
8 4 (1.82%) WSDL
9 3 (1.36%) Apache Camel
9 3 (1.36%) LDAP
9 3 (1.36%) Middleware
9 3 (1.36%) PySpark
10 2 (0.91%) AngularJS
10 2 (0.91%) ASP.NET
10 2 (0.91%) React
Miscellaneous
1 39 (17.73%) Analytical Skills
2 12 (5.45%) Computer Science
3 10 (4.55%) Management Information System
4 7 (3.18%) Data Structures
5 6 (2.73%) Market Risk
6 5 (2.27%) Hedge funds
7 4 (1.82%) Client/Server
7 4 (1.82%) Credit Risk
7 4 (1.82%) Data Centre
7 4 (1.82%) Derivative
7 4 (1.82%) Greenfield Project
7 4 (1.82%) Mobile App
7 4 (1.82%) Replication
8 3 (1.36%) Fixed Income
8 3 (1.36%) NHS
8 3 (1.36%) Self-Motivation
8 3 (1.36%) User Experience
9 2 (0.91%) Interest Rate Derivative
9 2 (0.91%) Life Science
9 2 (0.91%) Robotics
Operating Systems
1 16 (7.27%) Linux
2 4 (1.82%) Unix
3 3 (1.36%) Windows
4 1 (0.45%) AIX
4 1 (0.45%) Solaris
Processes & Methodologies
1 114 (51.82%) Business Intelligence
2 109 (49.55%) Analytics
3 101 (45.91%) Data Modelling
4 75 (34.09%) ETL
5 63 (28.64%) Data Science
6 56 (25.45%) Machine Learning
7 50 (22.73%) SQL Optimisation
8 48 (21.82%) Agile Software Development
9 29 (13.18%) Data Management
10 27 (12.27%) Visualisation
11 22 (10.00%) Data Architecture
11 22 (10.00%) Kimball Methodology
12 19 (8.64%) Data Visualisation
13 18 (8.18%) Data Integration
13 18 (8.18%) Performance Tuning
14 17 (7.73%) Scrum
15 16 (7.27%) Problem-Solving
16 15 (6.82%) Data Analytics
16 15 (6.82%) Dimensional Modelling
16 15 (6.82%) SDLC
Programming Languages
1 164 (74.55%) SQL
2 34 (15.45%) T-SQL
3 28 (12.73%) Python
4 25 (11.36%) Java
5 23 (10.45%) C#
6 13 (5.91%) VBA
7 10 (4.55%) Data Analysis Expressions (DAX)
7 10 (4.55%) Shell Script
8 9 (4.09%) PL/SQL
8 9 (4.09%) Scala
9 8 (3.64%) R
10 6 (2.73%) JavaScript
10 6 (2.73%) VB.NET
11 5 (2.27%) HiveQL
11 5 (2.27%) VBScript
11 5 (2.27%) XMLA
12 4 (1.82%) PowerShell
13 3 (1.36%) Java 8
13 3 (1.36%) VB
13 3 (1.36%) VB6
Qualifications
1 11 (5.00%) Degree
2 5 (2.27%) Security Cleared
3 4 (1.82%) TOGAF Certification
4 3 (1.36%) MCSA
4 3 (1.36%) Microsoft Certification
4 3 (1.36%) SC Cleared
5 2 (0.91%) Computer Science Degree
5 2 (0.91%) MCSE
6 1 (0.45%) BPSS Clearance
6 1 (0.45%) PMI Certification
Quality Assurance & Compliance
1 74 (33.64%) Data Quality
2 9 (4.09%) QA
3 7 (3.18%) GDPR
4 3 (1.36%) PMO
5 2 (0.91%) IFRS
6 1 (0.45%) IFRS 9
6 1 (0.45%) ISO/IEC 27001
6 1 (0.45%) PCI DSS
6 1 (0.45%) SAS 70
6 1 (0.45%) SLA
System Software
1 12 (5.45%) Docker
2 1 (0.45%) Active Directory
2 1 (0.45%) Apache Flume
2 1 (0.45%) HDFS
2 1 (0.45%) Hyper-V
2 1 (0.45%) VMware Infrastructure
Systems Management
1 52 (23.64%) Oozie
2 6 (2.73%) Kibana
3 1 (0.45%) Control-M
3 1 (0.45%) Hadoop YARN
3 1 (0.45%) Opscode Chef
3 1 (0.45%) Puppet
Vendors
1 59 (26.82%) Microsoft
2 53 (24.09%) Oracle
3 19 (8.64%) Tableau
4 16 (7.27%) IBM
5 12 (5.45%) SAP
5 12 (5.45%) Talend
6 11 (5.00%) Cloudera
7 10 (4.55%) Informatica
8 9 (4.09%) Cognos
9 8 (3.64%) Ab Initio
9 8 (3.64%) Teradata
10 7 (3.18%) Hortonworks
11 6 (2.73%) Splunk
12 5 (2.27%) Google
12 5 (2.27%) MicroStrategy
13 4 (1.82%) Cisco
13 4 (1.82%) Hyperion
13 4 (1.82%) JD Edwards
13 4 (1.82%) Salesforce.com
14 3 (1.36%) Bloomberg