Period
to 13 November 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 13 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
6 months to
13 Nov 2018
Same period 2017 Same period 2016
Rank 664 632 635
Rank change year-on-year -32 +3 -118
Contract jobs citing OLAP 229 254 276
As % of all contract IT jobs advertised in the UK 0.22% 0.25% 0.26%
As % of the Database & Business Intelligence category 0.98% 1.12% 1.16%
Number of daily rates quoted 160 178 210
UK median daily rate £500 £475 £425
Median daily rate % change year-on-year +5.26% +11.76% -
10th Percentile £350 £345 £308
90th Percentile £600 £650 £589
UK excluding London median daily rate £463 £400 £400
% change year-on-year +15.63% - -
Number of hourly rates quoted 2 1 0
UK median hourly rate £18.50 £52.50 -
Median hourly rate % change year-on-year -64.76% - -
UK excluding London median hourly rate £18.50 £52.50 -
% change year-on-year -64.76% - -

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,331 22,587 23,722
As % of all contract IT jobs advertised in the UK 22.49% 22.11% 22.62%
Number of daily rates quoted 16,253 15,399 15,738
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £313 £310 £281
90th Percentile £638 £625 £595
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% -
Number of hourly rates quoted 243 281 374
UK median hourly rate £32.50 £30.75 £28.34
Median hourly rate % change year-on-year +5.69% +8.50% +0.10%
10th Percentile £12.85 £14.00 £10.08
90th Percentile £57.07 £55.00 £52.23
UK excluding London median hourly rate £34.25 £35.00 £28.18
% change year-on-year -2.14% +24.20% -4.47%

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 13 November 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 13 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
England -32 214 £478 +0.53% 50
UK excluding London -6 123 £463 +15.63% 30
London -32 104 £525 - 27
South East -28 28 £475 +25.00% 6
South West -14 26 £525 +10.53% 1
North of England -26 25 £425 +4.62% 4
East of England +15 19 £450 - 5
Yorkshire -10 15 £425 +19.30% 4
Midlands -26 12 £450 +12.50% 7
Scotland -1 11 £550 +57.14% 4
North West -5 9 £385 -30.00%
West Midlands -35 9 £450 +12.50% 3
East Midlands +10 3 - - 4
North East +1 1 £450 +2.86%
Wales - 1 £415 - 2
Northern Ireland - 1 - - 1

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

1 173 (75.55%) Data Warehouse
2 155 (67.69%) SQL
3 112 (48.91%) Business Intelligence
4 106 (46.29%) ETL
5 88 (38.43%) Finance
6 82 (35.81%) Data Modelling
7 79 (34.50%) Analytics
8 78 (34.06%) SQL Server
9 70 (30.57%) OLAP Cube
10 69 (30.13%) SQL Server Integration Services
11 66 (28.82%) Big Data
12 64 (27.95%) Microsoft
13 63 (27.51%) SQL Server Reporting Services
13 63 (27.51%) Agile Software Development
14 62 (27.07%) SQL Server Analysis Services
15 47 (20.52%) Data Quality
16 46 (20.09%) Hadoop
17 45 (19.65%) Star Schema
18 40 (17.47%) Apache Hive
18 40 (17.47%) Power BI
19 39 (17.03%) Kafka
20 38 (16.59%) Oracle
20 38 (16.59%) Oracle OLAP
21 37 (16.16%) Relational Database
22 36 (15.72%) Machine Learning
23 35 (15.28%) Apache Spark
23 35 (15.28%) Data Science
24 34 (14.85%) Kimball Methodology
24 34 (14.85%) Visualisation
25 32 (13.97%) Enterprise Data Warehouse

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 35 (15.28%) Apache Spark
2 12 (5.24%) SAS
3 8 (3.49%) Apache
4 4 (1.75%) SharePoint
4 4 (1.75%) Tomcat
5 2 (0.87%) IIS
6 1 (0.44%) WebLogic
Applications
1 21 (9.17%) Microsoft Excel
2 6 (2.62%) Microsoft Office
2 6 (2.62%) Spreadsheet
3 1 (0.44%) Microsoft PowerPoint
3 1 (0.44%) Microsoft Project
Business Applications
1 7 (3.06%) Infor M3
2 5 (2.18%) HFM
3 3 (1.31%) FastStats
4 2 (0.87%) Cognos Business Intelligence
4 2 (0.87%) Cognos TM1
4 2 (0.87%) Dynamics AX
5 1 (0.44%) Dynamics CRM
5 1 (0.44%) Dynamics NAV
5 1 (0.44%) NetSuite
5 1 (0.44%) Oracle Assets
5 1 (0.44%) Oracle Cash Management
5 1 (0.44%) Oracle EBS
5 1 (0.44%) Oracle EBS R12
5 1 (0.44%) Oracle Financials
5 1 (0.44%) Oracle General Ledger
5 1 (0.44%) Oracle iSupplier
5 1 (0.44%) Oracle Payables
5 1 (0.44%) Oracle Receivables
Cloud Services
1 23 (10.04%) Microsoft Azure
2 8 (3.49%) PaaS
3 7 (3.06%) Data Lake Analytics
4 5 (2.18%) Azure Data Factory
5 4 (1.75%) IaaS
6 3 (1.31%) Amazon AWS
6 3 (1.31%) GitHub
7 2 (0.87%) Google Analytics
8 1 (0.44%) Azure Machine Learning
8 1 (0.44%) Cloud Computing
8 1 (0.44%) Dynamics 365
8 1 (0.44%) SaaS
Communications & Networking
1 2 (0.87%) Internet
2 1 (0.44%) Extranet
2 1 (0.44%) Intranet
Database & Business Intelligence
1 173 (75.55%) Data Warehouse
2 78 (34.06%) SQL Server
3 70 (30.57%) OLAP Cube
4 69 (30.13%) SQL Server Integration Services
5 66 (28.82%) Big Data
6 63 (27.51%) SQL Server Reporting Services
7 62 (27.07%) SQL Server Analysis Services
8 46 (20.09%) Hadoop
9 45 (19.65%) Star Schema
10 40 (17.47%) Apache Hive
10 40 (17.47%) Power BI
11 38 (16.59%) Oracle OLAP
12 37 (16.16%) Relational Database
13 32 (13.97%) Enterprise Data Warehouse
14 31 (13.54%) OLTP
15 24 (10.48%) Data Lake
15 24 (10.48%) Microsoft Analysis Services
16 22 (9.61%) SQL Server 2008
17 21 (9.17%) SQL Server 2012
18 20 (8.73%) Oracle ODI
Development Applications
1 11 (4.80%) Visual Studio
2 10 (4.37%) Team Foundation Server
2 10 (4.37%) Toad
3 6 (2.62%) Bitbucket
3 6 (2.62%) Visual Studio Team System
4 4 (1.75%) Git (software)
5 2 (0.87%) PowerDesigner
5 2 (0.87%) SQL Server Management Studio (SSMS)
5 2 (0.87%) XMLSpy
6 1 (0.44%) Atlassian Bamboo
6 1 (0.44%) Eclipse
6 1 (0.44%) JIRA
6 1 (0.44%) Oracle Forms
6 1 (0.44%) TeamCity
General
1 88 (38.43%) Finance
2 20 (8.73%) Retail
3 13 (5.68%) Banking
4 8 (3.49%) Front Office
5 7 (3.06%) Marketing
6 4 (1.75%) Manufacturing
6 4 (1.75%) Pharmaceutical
6 4 (1.75%) Telecoms
7 3 (1.31%) Electronics
7 3 (1.31%) Financial Institution
8 2 (0.87%) Games
8 2 (0.87%) Investment Banking
8 2 (0.87%) Legal
9 1 (0.44%) French Language
9 1 (0.44%) General Ledger
Job Titles
1 122 (53.28%) Developer
2 47 (20.52%) Business Intelligence Developer
3 33 (14.41%) Data Engineer
3 33 (14.41%) SQL Developer
4 31 (13.54%) Hadoop Engineer
5 18 (7.86%) ETL Developer
5 18 (7.86%) SQL BI Developer
6 17 (7.42%) Big Data Engineer
6 17 (7.42%) Data Warehouse Developer
7 14 (6.11%) Power BI Developer
7 14 (6.11%) SSAS Developer
8 13 (5.68%) Administrator
8 13 (5.68%) Oracle Developer
9 12 (5.24%) Architect
9 12 (5.24%) Consultant
9 12 (5.24%) DBA
10 11 (4.80%) Senior Developer
10 11 (4.80%) SSIS Developer
11 9 (3.93%) Ab Initio Developer
11 9 (3.93%) Oracle ETL Developer
Libraries, Frameworks & Software Standards
1 39 (17.03%) Kafka
2 18 (7.86%) MDX
3 11 (4.80%) Web Services
4 9 (3.93%) JSON
4 9 (3.93%) XML
5 8 (3.49%) .NET
5 8 (3.49%) Oracle GoldenGate
6 5 (2.18%) Apache Camel
7 3 (1.31%) ASP.NET Web API
7 3 (1.31%) Swagger
8 2 (0.87%) RESTful
9 1 (0.44%) ADO.NET
9 1 (0.44%) Matplotlib
9 1 (0.44%) NumPy
9 1 (0.44%) Pandas
9 1 (0.44%) REST
9 1 (0.44%) scikit-learn
9 1 (0.44%) SciPy
9 1 (0.44%) SOAP
9 1 (0.44%) XBRL
Miscellaneous
1 21 (9.17%) Analytical Skills
2 18 (7.86%) Data Structures
3 12 (5.24%) Self-Motivation
4 10 (4.37%) Replication
5 7 (3.06%) Greenfield Project
6 5 (2.18%) Computer Science
6 5 (2.18%) Fixed Income
6 5 (2.18%) Hedge funds
7 3 (1.31%) Management Information System
8 2 (0.87%) Reinsurance
9 1 (0.44%) Credit Risk
9 1 (0.44%) Data Centre
9 1 (0.44%) FMCG
9 1 (0.44%) Market Risk
9 1 (0.44%) NHS
9 1 (0.44%) PMI
Operating Systems
1 18 (7.86%) Unix
2 3 (1.31%) Windows
3 1 (0.44%) Linux
3 1 (0.44%) Solaris
Processes & Methodologies
1 112 (48.91%) Business Intelligence
2 106 (46.29%) ETL
3 82 (35.81%) Data Modelling
4 79 (34.50%) Analytics
5 63 (27.51%) Agile Software Development
6 36 (15.72%) Machine Learning
7 35 (15.28%) Data Science
8 34 (14.85%) Kimball Methodology
8 34 (14.85%) Visualisation
9 31 (13.54%) SQL Optimisation
10 29 (12.66%) Dimensional Modelling
11 24 (10.48%) Migration
12 23 (10.04%) Performance Tuning
13 21 (9.17%) Data Integration
14 20 (8.73%) Data Management
15 18 (7.86%) Data Architecture
15 18 (7.86%) Data Migration
15 18 (7.86%) Problem-Solving
16 17 (7.42%) Data Analysis
16 17 (7.42%) ETL Development
Programming Languages
1 155 (67.69%) SQL
2 29 (12.66%) T-SQL
3 22 (9.61%) C#
4 15 (6.55%) Python
5 14 (6.11%) Java
6 12 (5.24%) VBA
7 10 (4.37%) Data Analysis Expressions (DAX)
7 10 (4.37%) PL/SQL
8 8 (3.49%) Bash Shell
8 8 (3.49%) Perl
8 8 (3.49%) Shell Script
9 6 (2.62%) R
10 5 (2.18%) Java 8
10 5 (2.18%) U-SQL
11 3 (1.31%) Jython
11 3 (1.31%) PowerShell
11 3 (1.31%) VBScript
12 2 (0.87%) Go
13 1 (0.44%) VB
13 1 (0.44%) XMLA
Qualifications
1 5 (2.18%) Degree
1 5 (2.18%) Security Cleared
2 4 (1.75%) Microsoft Certification
3 2 (0.87%) SC Cleared
4 1 (0.44%) Computer Science Degree
4 1 (0.44%) Master's Degree
4 1 (0.44%) MCSA
4 1 (0.44%) MCSE
4 1 (0.44%) PhD
4 1 (0.44%) PMI Certification
Quality Assurance & Compliance
1 47 (20.52%) Data Quality
2 10 (4.37%) QA
3 2 (0.87%) EMIR
3 2 (0.87%) MiFID
3 2 (0.87%) Solvency II
4 1 (0.44%) IFRS
System Software
1 5 (2.18%) Docker
2 1 (0.44%) Virtual Machines
Systems Management
1 31 (13.54%) Oozie
2 3 (1.31%) Data Guard
2 3 (1.31%) Oracle EDQ
2 3 (1.31%) Oracle RMAN
3 2 (0.87%) Ambari
3 2 (0.87%) Ganglia
3 2 (0.87%) Nagios
Vendors
1 64 (27.95%) Microsoft
2 38 (16.59%) Oracle
3 20 (8.73%) Ab Initio
4 17 (7.42%) Tableau
5 13 (5.68%) Cognos
6 12 (5.24%) Informatica
7 11 (4.80%) Talend
8 9 (3.93%) Sybase
9 8 (3.49%) Greenplum
10 7 (3.06%) EXASOL
10 7 (3.06%) Infor
11 6 (2.62%) MicroStrategy
11 6 (2.62%) SAP
12 5 (2.18%) IBM
12 5 (2.18%) Teradata
13 3 (1.31%) Anaplan
13 3 (1.31%) Cloudera
13 3 (1.31%) Hortonworks
14 2 (0.87%) Google
14 2 (0.87%) Netezza