Period
to 27 May 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 27 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
6 months to
27 May 2018
Same period 2017 Same period 2016
Rank 647 654 634
Rank change year-on-year +7 -20 -166
Contract jobs citing OLAP 237 182 251
As % of all contract IT jobs advertised in the UK 0.24% 0.20% 0.24%
As % of the Database & Business Intelligence category 1.05% 0.89% 1.08%
Number of daily rates quoted 166 140 172
UK median daily rate £513 £425 £413
Median daily rate % change year-on-year +20.59% +3.03% -2.94%
10th Percentile £350 £313 £301
90th Percentile £588 £575 £575
UK excluding London median daily rate £463 £425 £401
% change year-on-year +8.82% +6.12% -5.76%
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 22,611 20,527 23,287
As % of all contract IT jobs advertised in the UK 22.44% 22.54% 22.02%
Number of daily rates quoted 15,752 13,737 15,728
UK median daily rate £474 £438 £425
Median daily rate % change year-on-year +8.23% +2.94% +6.25%
10th Percentile £313 £295 £278
90th Percentile £625 £613 £600
UK excluding London median daily rate £415 £390 £375
% change year-on-year +6.41% +4.00% +2.74%
Number of hourly rates quoted 232 250 383
UK median hourly rate £33.50 £30.00 £28.50
Median hourly rate % change year-on-year +11.67% +5.26% +4.34%
10th Percentile £14.00 £9.25 £12.04
90th Percentile £53.50 £50.00 £52.70
UK excluding London median hourly rate £33.75 £29.75 £28.50
% change year-on-year +13.45% +4.39% +10.34%

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 27 May 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 16 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 27 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
England +5 219 £513 +18.50% 34
London -6 145 £525 +10.53% 21
UK excluding London -14 91 £463 +8.82% 17
South East -11 29 £475 +24.35% 6
North of England -11 24 £475 +26.67% 3
Wales +3 13 £388 -8.82%
Yorkshire -14 11 £413 +10.00% 2
East of England +2 9 £438 +10.76% 1
North West -15 9 £544 +42.62% 1
Midlands -19 7 £405 +2.86% 1
South West +1 5 £525 +7.69% 2
West Midlands -27 5 £393 +1.29%
North East - 4 £475 -
Northern Ireland - 3 - - 1
East Midlands +2 2 £505 +6.32%
Scotland -39 1 £325 -23.53% 3

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

1 176 (74.26%) SQL
2 152 (64.14%) Data Warehouse
3 128 (54.01%) Business Intelligence
4 123 (51.90%) Finance
5 110 (46.41%) Analytics
6 101 (42.62%) Data Modelling
7 90 (37.97%) ETL
8 89 (37.55%) OLAP Cube
9 86 (36.29%) Big Data
10 83 (35.02%) SQL Server
11 82 (34.60%) Hadoop
12 74 (31.22%) Data Quality
13 71 (29.96%) SQL Server Integration Services
14 69 (29.11%) Star Schema
14 69 (29.11%) Apache Hive
15 67 (28.27%) Apache Spark
16 66 (27.85%) SQL Server Reporting Services
17 65 (27.43%) Kafka
18 63 (26.58%) Data Science
19 60 (25.32%) SQL Server Analysis Services
19 60 (25.32%) Microsoft
20 58 (24.47%) Enterprise Data Warehouse
21 56 (23.63%) Machine Learning
22 53 (22.36%) Oracle OLAP
22 53 (22.36%) Oracle
23 52 (21.94%) Oozie
24 50 (21.10%) SQL Optimisation
24 50 (21.10%) Agile Software Development
25 42 (17.72%) T-SQL
26 39 (16.46%) Analytical Skills

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 67 (28.27%) Apache Spark
2 19 (8.02%) SAS
3 10 (4.22%) Apache
4 5 (2.11%) Confluence
4 5 (2.11%) SharePoint
5 1 (0.42%) Elasticsearch
5 1 (0.42%) IIS
Applications
1 22 (9.28%) Microsoft Excel
2 5 (2.11%) Microsoft Office
3 1 (0.42%) Microsoft PowerPoint
3 1 (0.42%) Microsoft Project
3 1 (0.42%) Spreadsheet
Business Applications
1 14 (5.91%) Dynamics AX
2 3 (1.27%) Dynamics NAV
2 3 (1.27%) NetSuite
2 3 (1.27%) Oracle ERP
3 2 (0.84%) Cognos TM1
3 2 (0.84%) HFM
3 2 (0.84%) Summit
4 1 (0.42%) Dynamics CRM
4 1 (0.42%) Dynamics GP
4 1 (0.42%) Hyperion Planning
4 1 (0.42%) SAP BPC
Cloud Services
1 22 (9.28%) Microsoft Azure
2 14 (5.91%) Amazon AWS
3 7 (2.95%) Amazon S3
4 5 (2.11%) Google Analytics
5 4 (1.69%) Dynamics 365
5 4 (1.69%) PaaS
6 3 (1.27%) Adobe Analytics
6 3 (1.27%) Azure Data Factory
6 3 (1.27%) OpenShift
7 1 (0.42%) Amazon EMR
7 1 (0.42%) Cloud Computing
7 1 (0.42%) Data Lake Analytics
Communications & Networking
1 4 (1.69%) SSL
2 2 (0.84%) SAN
3 1 (0.42%) ATM
3 1 (0.42%) Ethernet
3 1 (0.42%) FCoE
3 1 (0.42%) Fibre Channel
3 1 (0.42%) HTTP
3 1 (0.42%) InfiniBand
3 1 (0.42%) Internet
3 1 (0.42%) iSCSI
3 1 (0.42%) LAN
3 1 (0.42%) WAN
Database & Business Intelligence
1 152 (64.14%) Data Warehouse
2 89 (37.55%) OLAP Cube
3 86 (36.29%) Big Data
4 83 (35.02%) SQL Server
5 82 (34.60%) Hadoop
6 71 (29.96%) SQL Server Integration Services
7 69 (29.11%) Apache Hive
7 69 (29.11%) Star Schema
8 66 (27.85%) SQL Server Reporting Services
9 60 (25.32%) SQL Server Analysis Services
10 58 (24.47%) Enterprise Data Warehouse
11 53 (22.36%) Oracle OLAP
12 37 (15.61%) Power BI
13 32 (13.50%) OLTP
14 27 (11.39%) Data Lake
15 24 (10.13%) NoSQL
15 24 (10.13%) Relational Database
16 18 (7.59%) SQL Server 2012
17 17 (7.17%) SQL Server 2008
18 16 (6.75%) Microsoft Analysis Services
Development Applications
1 21 (8.86%) Git (software)
2 10 (4.22%) Jenkins
3 8 (3.38%) Visual Studio
4 6 (2.53%) JIRA
5 5 (2.11%) Bitbucket
6 4 (1.69%) TeamCity
6 4 (1.69%) Visual Studio Team System
7 3 (1.27%) Toad
8 2 (0.84%) Cucumber
8 2 (0.84%) IntelliJ
8 2 (0.84%) JUnit
8 2 (0.84%) Maven
8 2 (0.84%) SonarQube
8 2 (0.84%) SQL Server Management Studio (SSMS)
9 1 (0.42%) git-flow
9 1 (0.42%) Octopus Deploy
9 1 (0.42%) PyCharm
9 1 (0.42%) Sublime Text
9 1 (0.42%) Team Foundation Server
General
1 123 (51.90%) Finance
2 18 (7.59%) Banking
3 9 (3.80%) Retail
4 7 (2.95%) Front Office
4 7 (2.95%) Marketing
5 5 (2.11%) Investment Banking
6 4 (1.69%) Financial Institution
7 3 (1.27%) German Language
8 2 (0.84%) Dutch Language
8 2 (0.84%) French Language
8 2 (0.84%) Italian Language
8 2 (0.84%) Manufacturing
8 2 (0.84%) Spanish Language
9 1 (0.42%) Electronics
9 1 (0.42%) Law
9 1 (0.42%) Legal
9 1 (0.42%) Pharmaceutical
9 1 (0.42%) Retail Banking
9 1 (0.42%) Telecoms
Job Titles
1 85 (35.86%) Developer
2 67 (28.27%) Data Engineer
3 54 (22.78%) Hadoop Engineer
4 31 (13.08%) Business Intelligence Developer
5 27 (11.39%) Architect
5 27 (11.39%) SQL Developer
6 25 (10.55%) Big Data Engineer
7 22 (9.28%) Analyst
8 17 (7.17%) Senior Developer
9 13 (5.49%) SQL BI Developer
9 13 (5.49%) SSAS Developer
10 10 (4.22%) Business Intelligence Consultant
10 10 (4.22%) Consultant
10 10 (4.22%) SSIS Developer
11 9 (3.80%) Business Developer
12 8 (3.38%) Business Intelligence Analyst
12 8 (3.38%) Data Architect
12 8 (3.38%) Oracle Developer
12 8 (3.38%) Report Writer
12 8 (3.38%) Solutions Architect
Libraries, Frameworks & Software Standards
1 65 (27.43%) Kafka
2 26 (10.97%) MDX
3 21 (8.86%) .NET
4 11 (4.64%) XML
5 8 (3.38%) JSON
6 6 (2.53%) RabbitMQ
6 6 (2.53%) Web Services
7 5 (2.11%) LAMP
7 5 (2.11%) LAPP Stack
8 4 (1.69%) HTML
8 4 (1.69%) Pandas
8 4 (1.69%) REST
8 4 (1.69%) SOAP
8 4 (1.69%) WSDL
9 3 (1.27%) Apache Camel
9 3 (1.27%) LDAP
9 3 (1.27%) Middleware
9 3 (1.27%) PySpark
10 2 (0.84%) AngularJS
10 2 (0.84%) ASP.NET
Miscellaneous
1 39 (16.46%) Analytical Skills
2 12 (5.06%) Computer Science
3 10 (4.22%) Management Information System
4 7 (2.95%) Data Structures
5 6 (2.53%) Market Risk
6 5 (2.11%) Hedge funds
7 4 (1.69%) Client/Server
7 4 (1.69%) Credit Risk
7 4 (1.69%) Data Centre
7 4 (1.69%) Derivative
7 4 (1.69%) Greenfield Project
7 4 (1.69%) Mobile App
7 4 (1.69%) Replication
8 3 (1.27%) Fixed Income
8 3 (1.27%) NHS
8 3 (1.27%) Self-Motivation
8 3 (1.27%) User Experience
9 2 (0.84%) Interest Rate Derivative
9 2 (0.84%) Life Science
9 2 (0.84%) Robotics
Operating Systems
1 16 (6.75%) Linux
2 4 (1.69%) Unix
3 3 (1.27%) Windows
4 1 (0.42%) AIX
4 1 (0.42%) Solaris
Processes & Methodologies
1 128 (54.01%) Business Intelligence
2 110 (46.41%) Analytics
3 101 (42.62%) Data Modelling
4 90 (37.97%) ETL
5 63 (26.58%) Data Science
6 56 (23.63%) Machine Learning
7 50 (21.10%) Agile Software Development
7 50 (21.10%) SQL Optimisation
8 30 (12.66%) Data Management
9 27 (11.39%) Visualisation
10 24 (10.13%) Problem-Solving
11 22 (9.28%) Data Architecture
11 22 (9.28%) Kimball Methodology
12 19 (8.02%) Data Visualisation
13 18 (7.59%) Data Integration
13 18 (7.59%) Performance Tuning
14 17 (7.17%) Scrum
15 16 (6.75%) Data Analytics
15 16 (6.75%) SDLC
16 15 (6.33%) Dimensional Modelling
Programming Languages
1 176 (74.26%) SQL
2 42 (17.72%) T-SQL
3 32 (13.50%) Python
4 25 (10.55%) C#
4 25 (10.55%) Java
5 12 (5.06%) VBA
6 10 (4.22%) Data Analysis Expressions (DAX)
6 10 (4.22%) Shell Script
7 9 (3.80%) PL/SQL
7 9 (3.80%) Scala
8 8 (3.38%) R
9 6 (2.53%) JavaScript
9 6 (2.53%) VB.NET
10 5 (2.11%) HiveQL
10 5 (2.11%) VBScript
10 5 (2.11%) XMLA
11 4 (1.69%) PowerShell
12 3 (1.27%) Java 8
12 3 (1.27%) VB
12 3 (1.27%) VB6
Qualifications
1 11 (4.64%) Degree
2 6 (2.53%) Security Cleared
3 4 (1.69%) TOGAF Certification
4 3 (1.27%) MCSA
4 3 (1.27%) Microsoft Certification
4 3 (1.27%) SC Cleared
5 2 (0.84%) Computer Science Degree
5 2 (0.84%) MCSE
6 1 (0.42%) BPSS Clearance
6 1 (0.42%) PMI Certification
Quality Assurance & Compliance
1 74 (31.22%) Data Quality
2 9 (3.80%) QA
3 7 (2.95%) GDPR
4 2 (0.84%) IFRS
4 2 (0.84%) PMO
5 1 (0.42%) IFRS 9
5 1 (0.42%) ISO/IEC 27001
5 1 (0.42%) PCI DSS
5 1 (0.42%) SAS 70
5 1 (0.42%) SLA
System Software
1 12 (5.06%) Docker
2 1 (0.42%) Active Directory
2 1 (0.42%) Apache Flume
2 1 (0.42%) HDFS
2 1 (0.42%) Hyper-V
2 1 (0.42%) VMware Infrastructure
Systems Management
1 52 (21.94%) Oozie
2 6 (2.53%) Kibana
3 1 (0.42%) Control-M
3 1 (0.42%) Hadoop YARN
3 1 (0.42%) Opscode Chef
3 1 (0.42%) Puppet
Vendors
1 60 (25.32%) Microsoft
2 53 (22.36%) Oracle
3 20 (8.44%) Tableau
4 16 (6.75%) IBM
5 12 (5.06%) SAP
5 12 (5.06%) Talend
6 11 (4.64%) Cloudera
7 10 (4.22%) Informatica
8 9 (3.80%) Cognos
9 8 (3.38%) Ab Initio
9 8 (3.38%) Teradata
10 7 (2.95%) Hortonworks
11 6 (2.53%) Splunk
12 5 (2.11%) Google
12 5 (2.11%) MicroStrategy
13 4 (1.69%) Cisco
13 4 (1.69%) Hyperion
13 4 (1.69%) JD Edwards
13 4 (1.69%) Salesforce.com
14 3 (1.27%) Bloomberg