Period
to 17 August 2018

The following table provides summary statistics for contract job vacancies 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 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
6 months to
17 Aug 2018
Same period 2017 Same period 2016
Rank 648 631 640
Rank change year-on-year -17 +9 -153
Contract jobs citing OLAP 252 229 260
As % of all contract IT jobs advertised in the UK 0.24% 0.24% 0.24%
As % of the Database & Business Intelligence category 1.07% 1.06% 1.08%
Number of daily rates quoted 173 165 187
UK median daily rate £513 £450 £413
Median daily rate % change year-on-year +13.89% +9.09% -2.94%
10th Percentile £350 £325 £306
90th Percentile £588 £625 £593
UK excluding London median daily rate £475 £375 £401
% change year-on-year +26.67% -6.37% +0.13%
Number of hourly rates quoted 0 1 0
UK median hourly rate - £52.50 -
UK excluding London 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 with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 23,495 21,638 24,139
As % of all contract IT jobs advertised in the UK 22.80% 22.60% 22.19%
Number of daily rates quoted 16,406 14,416 16,181
UK median daily rate £463 £450 £425
Median daily rate % change year-on-year +2.78% +5.88% +6.25%
10th Percentile £313 £300 £281
90th Percentile £638 £625 £600
UK excluding London median daily rate £420 £400 £375
% change year-on-year +5.00% +6.67% +2.74%
Number of hourly rates quoted 238 251 381
UK median hourly rate £28.75 £31.00 £28.50
Median hourly rate % change year-on-year -7.26% +8.77% +4.34%
10th Percentile £13.25 £11.30 £11.50
90th Percentile £52.98 £52.50 £48.75
UK excluding London median hourly rate £28.75 £31.75 £29.76
% change year-on-year -9.45% +6.68% +8.23%

OLAP
Job Vacancy Trend

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

Job vacancy trend for OLAP in the UK

OLAP
Contractor Daily Rate Trend

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

Contractor daily rate trend for OLAP in the UK

OLAP
Contractor Daily Rate Histogram

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

Contractor daily rate histogram for OLAP in the UK

OLAP
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for OLAP in the UK

OLAP
Top 15 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the UK over the 6 months to 17 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
England -20 243 £513 +13.89% 44
London +3 142 £525 - 18
UK excluding London -23 109 £475 +26.67% 27
South East -15 35 £475 +37.68% 4
North of England -24 25 £400 +6.67% 14
South West +11 24 £525 +2.69% 3
Yorkshire -19 17 £401 +9.73% 6
Midlands -13 9 £398 +0.95% 3
North West -11 8 £385 -0.65% 7
East of England -17 8 £450 +10.09% 2
West Midlands -26 7 £374 -5.08% 1
Wales - 6 £375 -
East Midlands -4 2 £505 +29.49% 2
Scotland -46 1 - -
Northern Ireland - 1 - - 1

For the 6 months to 17 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 with a requirement for OLAP.

1 194 (76.98%) Data Warehouse
2 169 (67.06%) SQL
3 135 (53.57%) Finance
4 134 (53.17%) Analytics
5 122 (48.41%) Data Modelling
6 120 (47.62%) Business Intelligence
7 112 (44.44%) Big Data
8 107 (42.46%) OLAP Cube
9 96 (38.10%) Hadoop
10 93 (36.90%) Data Quality
11 92 (36.51%) ETL
12 90 (35.71%) Star Schema
13 88 (34.92%) Apache Hive
14 84 (33.33%) SQL Server
15 82 (32.54%) Data Science
16 78 (30.95%) Apache Spark
17 77 (30.56%) Kafka
18 76 (30.16%) Machine Learning
19 73 (28.97%) SQL Server Integration Services
20 72 (28.57%) Enterprise Data Warehouse
21 69 (27.38%) Oozie
22 67 (26.59%) SQL Optimisation
22 67 (26.59%) SQL Server Reporting Services
23 63 (25.00%) Microsoft
24 59 (23.41%) SQL Server Analysis Services
25 47 (18.65%) Agile Software Development
26 42 (16.67%) Oracle OLAP
26 42 (16.67%) Oracle
27 41 (16.27%) Power BI
28 37 (14.68%) Data Lake

OLAP
Co-occurring IT Skills 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 (30.95%) Apache Spark
2 14 (5.56%) SAS
3 8 (3.17%) Apache
4 6 (2.38%) SharePoint
5 4 (1.59%) Tomcat
6 1 (0.40%) Confluence
6 1 (0.40%) IIS
Applications
1 28 (11.11%) Microsoft Excel
2 6 (2.38%) Microsoft Office
2 6 (2.38%) Spreadsheet
3 1 (0.40%) Microsoft PowerPoint
3 1 (0.40%) Microsoft Project
Business Applications
1 8 (3.17%) Dynamics AX
2 5 (1.98%) HFM
3 3 (1.19%) NetSuite
3 3 (1.19%) Oracle ERP
4 2 (0.79%) FastStats
4 2 (0.79%) Infor M3
5 1 (0.40%) Cognos Business Intelligence
5 1 (0.40%) Cognos TM1
Cloud Services
1 32 (12.70%) Microsoft Azure
2 12 (4.76%) Amazon AWS
3 8 (3.17%) PaaS
4 6 (2.38%) Amazon S3
5 5 (1.98%) Azure Data Factory
5 5 (1.98%) Data Lake Analytics
6 4 (1.59%) Google Analytics
7 3 (1.19%) Dynamics 365
8 2 (0.79%) Adobe Analytics
8 2 (0.79%) OpenShift
9 1 (0.40%) Azure Machine Learning
9 1 (0.40%) Cloud Computing
9 1 (0.40%) IaaS
Communications & Networking
1 2 (0.79%) Internet
2 1 (0.40%) Extranet
2 1 (0.40%) Intranet
2 1 (0.40%) SSL
Database & Business Intelligence
1 194 (76.98%) Data Warehouse
2 112 (44.44%) Big Data
3 107 (42.46%) OLAP Cube
4 96 (38.10%) Hadoop
5 90 (35.71%) Star Schema
6 88 (34.92%) Apache Hive
7 84 (33.33%) SQL Server
8 73 (28.97%) SQL Server Integration Services
9 72 (28.57%) Enterprise Data Warehouse
10 67 (26.59%) SQL Server Reporting Services
11 59 (23.41%) SQL Server Analysis Services
12 42 (16.67%) Oracle OLAP
13 41 (16.27%) Power BI
14 37 (14.68%) Data Lake
15 32 (12.70%) OLTP
16 27 (10.71%) Relational Database
17 25 (9.92%) NoSQL
18 24 (9.52%) SQL Server 2012
19 22 (8.73%) Microsoft Analysis Services
20 21 (8.33%) SQL Server 2008
Development Applications
1 17 (6.75%) Git (software)
2 12 (4.76%) Visual Studio
3 6 (2.38%) Jenkins
4 5 (1.98%) Toad
4 5 (1.98%) Visual Studio Team System
5 3 (1.19%) SQL Server Management Studio (SSMS)
5 3 (1.19%) Team Foundation Server
6 1 (0.40%) Eclipse
6 1 (0.40%) JIRA
6 1 (0.40%) Octopus Deploy
General
1 135 (53.57%) Finance
2 21 (8.33%) Retail
3 18 (7.14%) Banking
4 10 (3.97%) Marketing
5 6 (2.38%) Front Office
6 4 (1.59%) Manufacturing
7 3 (1.19%) Telecoms
8 2 (0.79%) Electronics
8 2 (0.79%) Financial Institution
9 1 (0.40%) Dutch Language
9 1 (0.40%) French Language
9 1 (0.40%) German Language
9 1 (0.40%) Investment Banking
9 1 (0.40%) Italian Language
9 1 (0.40%) Legal
9 1 (0.40%) Pharmaceutical
9 1 (0.40%) Retail Banking
9 1 (0.40%) Spanish Language
Job Titles
1 88 (34.92%) Developer
2 79 (31.35%) Data Engineer
3 71 (28.17%) Hadoop Engineer
4 43 (17.06%) Business Intelligence Developer
5 34 (13.49%) Big Data Engineer
6 29 (11.51%) SQL Developer
7 21 (8.33%) Architect
8 16 (6.35%) SQL BI Developer
8 16 (6.35%) SSAS Developer
9 14 (5.56%) Senior Developer
10 12 (4.76%) Business Developer
11 11 (4.37%) Administrator
11 11 (4.37%) SSIS Developer
12 10 (3.97%) Analyst
12 10 (3.97%) DBA
12 10 (3.97%) Oracle Developer
13 9 (3.57%) Solutions Architect
14 8 (3.17%) Data Architect
14 8 (3.17%) Power BI Developer
14 8 (3.17%) SSRS Developer
Libraries, Frameworks & Software Standards
1 77 (30.56%) Kafka
2 24 (9.52%) MDX
3 13 (5.16%) .NET
4 7 (2.78%) XML
5 6 (2.38%) RabbitMQ
6 5 (1.98%) LAMP
6 5 (1.98%) LAPP Stack
7 4 (1.59%) JSON
8 3 (1.19%) REST
9 2 (0.79%) ASP.NET
9 2 (0.79%) SOAP
9 2 (0.79%) Web Services
10 1 (0.40%) HTML
10 1 (0.40%) LDAP
10 1 (0.40%) Matplotlib
10 1 (0.40%) Natural Language Processing
10 1 (0.40%) ODBC
10 1 (0.40%) SAML
10 1 (0.40%) WSDL
10 1 (0.40%) XBRL
Miscellaneous
1 29 (11.51%) Analytical Skills
2 13 (5.16%) Data Structures
3 10 (3.97%) Self-Motivation
4 7 (2.78%) Management Information System
5 6 (2.38%) Computer Science
5 6 (2.38%) Greenfield Project
6 5 (1.98%) Fixed Income
7 3 (1.19%) Credit Risk
8 2 (0.79%) Hedge funds
8 2 (0.79%) Replication
8 2 (0.79%) Robotics
9 1 (0.40%) Algorithms
9 1 (0.40%) Cloud Native
9 1 (0.40%) Data Centre
9 1 (0.40%) Fintech
9 1 (0.40%) Mobile App
9 1 (0.40%) NHS
9 1 (0.40%) PMI
9 1 (0.40%) Reinsurance
9 1 (0.40%) User Experience
Operating Systems
1 10 (3.97%) Unix
2 6 (2.38%) Linux
3 3 (1.19%) Windows
Processes & Methodologies
1 134 (53.17%) Analytics
2 122 (48.41%) Data Modelling
3 120 (47.62%) Business Intelligence
4 92 (36.51%) ETL
5 82 (32.54%) Data Science
6 76 (30.16%) Machine Learning
7 67 (26.59%) SQL Optimisation
8 47 (18.65%) Agile Software Development
9 33 (13.10%) Data Management
10 32 (12.70%) Visualisation
11 27 (10.71%) Kimball Methodology
12 23 (9.13%) Data Architecture
12 23 (9.13%) Problem-Solving
13 22 (8.73%) Business Analytics
13 22 (8.73%) Dimensional Modelling
14 21 (8.33%) Data Integration
15 20 (7.94%) Performance Tuning
16 18 (7.14%) Data Governance
16 18 (7.14%) Data Visualisation
16 18 (7.14%) SDLC
Programming Languages
1 169 (67.06%) SQL
2 34 (13.49%) T-SQL
3 29 (11.51%) Python
4 27 (10.71%) C#
5 16 (6.35%) Java
6 13 (5.16%) R
7 12 (4.76%) Data Analysis Expressions (DAX)
7 12 (4.76%) PL/SQL
8 11 (4.37%) VBA
9 8 (3.17%) Bash Shell
9 8 (3.17%) Perl
10 6 (2.38%) Scala
11 5 (1.98%) HiveQL
11 5 (1.98%) PowerShell
11 5 (1.98%) Shell Script
12 4 (1.59%) VBScript
13 3 (1.19%) Jython
13 3 (1.19%) U-SQL
14 2 (0.79%) JavaScript
14 2 (0.79%) VB.NET
Qualifications
1 7 (2.78%) Degree
2 5 (1.98%) Security Cleared
3 4 (1.59%) Microsoft Certification
4 3 (1.19%) SC Cleared
5 1 (0.40%) Computer Science Degree
5 1 (0.40%) Master's Degree
5 1 (0.40%) MCSA
5 1 (0.40%) MCSE
5 1 (0.40%) PhD
5 1 (0.40%) PMI Certification
5 1 (0.40%) TOGAF Certification
Quality Assurance & Compliance
1 93 (36.90%) Data Quality
2 7 (2.78%) GDPR
3 6 (2.38%) QA
4 2 (0.79%) EMIR
4 2 (0.79%) MiFID
4 2 (0.79%) Solvency II
5 1 (0.40%) IFRS
5 1 (0.40%) PMO
System Software
1 6 (2.38%) Docker
Systems Management
1 69 (27.38%) Oozie
2 6 (2.38%) Kibana
3 3 (1.19%) Data Guard
3 3 (1.19%) Oracle EDQ
3 3 (1.19%) Oracle RMAN
4 1 (0.40%) Ambari
4 1 (0.40%) Control-M
4 1 (0.40%) Ganglia
4 1 (0.40%) Nagios
4 1 (0.40%) Opscode Chef
4 1 (0.40%) Puppet
Vendors
1 63 (25.00%) Microsoft
2 42 (16.67%) Oracle
3 18 (7.14%) Tableau
4 16 (6.35%) Talend
5 15 (5.95%) Cognos
6 12 (4.76%) IBM
7 11 (4.37%) Informatica
8 10 (3.97%) Ab Initio
9 9 (3.57%) Sybase
10 8 (3.17%) Greenplum
11 7 (2.78%) Cloudera
11 7 (2.78%) SAP
12 6 (2.38%) Splunk
12 6 (2.38%) Teradata
13 5 (1.98%) MicroStrategy
14 4 (1.59%) Google
15 3 (1.19%) Anaplan
15 3 (1.19%) Hortonworks
15 3 (1.19%) Hyperion
15 3 (1.19%) JD Edwards