Period
to 16 November 2019

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 16 November 2019 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
16 Nov 2019
Same period 2018 Same period 2017
Rank 655 670 603
Rank change year-on-year +15 -67 +11
Contract jobs citing OLAP 129 212 251
As % of all contract IT jobs advertised in England 0.17% 0.22% 0.27%
As % of the Database & Business Intelligence category 0.79% 0.99% 1.20%
Number of daily rates quoted 103 149 175
England median daily rate £550 £500 £475
Median daily rate % change year-on-year +10.00% +5.26% +10.47%
10th Percentile £364 £347 £345
90th Percentile £800 £603 £650
UK median daily rate £525 £500 £475
% change year-on-year +5.00% +5.26% +11.76%
Number of hourly rates quoted 2 2 2
England median hourly rate £70.00 £18.50 £53.75
Median hourly rate % change year-on-year +278.38% -65.58% -
10th Percentile £67.50 £17.25 £51.63
90th Percentile £72.50 £19.75 £54.88
UK median hourly rate £70.00 £18.50 £53.75
% change year-on-year +278.38% -65.58% -

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 16,362 21,475 20,860
As % of all contract IT jobs advertised in England 21.52% 22.60% 22.04%
Number of daily rates quoted 11,170 15,094 14,421
England median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% +5.88%
10th Percentile £325 £318 £313
90th Percentile £669 £649 £638
UK median daily rate £475 £475 £450
% change year-on-year - +5.56% +5.88%
Number of hourly rates quoted 231 222 265
England median hourly rate £32.50 £33.50 £32.00
Median hourly rate % change year-on-year -2.99% +4.69% +14.29%
10th Percentile £13.99 £14.00 £14.37
90th Percentile £72.50 £57.48 £56.29
UK median hourly rate £35.00 £32.50 £31.23
% change year-on-year +7.69% +4.07% +10.82%

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 16 November 2019.

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 16 November 2019. 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 +53 76 £600 +14.29% 17
South East +43 30 £475 - 6
Midlands +48 10 £400 -11.11% 4
West Midlands +34 7 £400 -11.11% 3
North of England +18 7 £325 -23.53% 6
East of England +17 6 £400 -11.11%
North West +18 5 £325 -15.58% 3
East Midlands +29 3 £450 - 1
Yorkshire +20 2 - - 3
OLAP
UK

For the 6 months to 16 November 2019, 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 98 (75.97%) SQL
2 92 (71.32%) Business Intelligence
3 75 (58.14%) SQL Server
4 71 (55.04%) ETL
5 70 (54.26%) Power BI
5 70 (54.26%) Power Platform
6 66 (51.16%) SQL Server Analysis Services
7 63 (48.84%) Data Warehouse
8 61 (47.29%) Agile Software Development
9 55 (42.64%) Finance
10 54 (41.86%) Tableau
11 53 (41.09%) Visualisation
12 48 (37.21%) Microsoft
13 43 (33.33%) SQL Server Integration Services
14 42 (32.56%) Data Visualisation
15 41 (31.78%) SQL Server Reporting Services
16 38 (29.46%) Cognos
17 34 (26.36%) C#
17 34 (26.36%) Data Analysis
18 33 (25.58%) QlikView
18 33 (25.58%) Analytical Skills
19 32 (24.81%) Analytics
20 28 (21.71%) Data Modelling
20 28 (21.71%) OLAP Cube
21 27 (20.93%) PowerShell
22 26 (20.16%) MDX
22 26 (20.16%) Hedge funds
23 25 (19.38%) Git (software)
23 25 (19.38%) Microsoft Excel
23 25 (19.38%) T-SQL

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 8 (6.20%) SAS
2 6 (4.65%) Apache
3 5 (3.88%) SharePoint
4 4 (3.10%) Apache Spark
Applications
1 25 (19.38%) Microsoft Excel
2 4 (3.10%) Microsoft Office
3 3 (2.33%) Spreadsheet
4 2 (1.55%) Microsoft PowerPoint
Business Applications
1 4 (3.10%) Oracle Applications
1 4 (3.10%) Oracle EBS
1 4 (3.10%) Oracle Procure-to-Pay
2 3 (2.33%) Oracle Cash Management
2 3 (2.33%) Oracle EBS R12
2 3 (2.33%) Oracle Payables
2 3 (2.33%) Oracle Receivables
3 2 (1.55%) Oracle iSupplier
4 1 (0.78%) Cognos TM1
4 1 (0.78%) Dynamics AX
4 1 (0.78%) NetSuite
Cloud Services
1 70 (54.26%) Power Platform
2 21 (16.28%) Azure
3 12 (9.30%) AWS
3 12 (9.30%) Azure Data Factory
4 4 (3.10%) Azure Functions
4 4 (3.10%) Serverless
5 3 (2.33%) Azure Machine Learning
5 3 (2.33%) Office 365
6 2 (1.55%) Data Lake Analytics
6 2 (1.55%) Dynamics 365
7 1 (0.78%) GCP
Communications & Networking
1 3 (2.33%) FTP
2 1 (0.78%) LAN
Database & Business Intelligence
1 75 (58.14%) SQL Server
2 70 (54.26%) Power BI
3 66 (51.16%) SQL Server Analysis Services
4 63 (48.84%) Data Warehouse
5 43 (33.33%) SQL Server Integration Services
6 41 (31.78%) SQL Server Reporting Services
7 33 (25.58%) QlikView
8 28 (21.71%) OLAP Cube
9 24 (18.60%) Relational Database
10 19 (14.73%) Data Lake
11 18 (13.95%) Oracle OLAP
12 15 (11.63%) Big Data
12 15 (11.63%) Microsoft Analysis Services
13 13 (10.08%) Hadoop
13 13 (10.08%) SQL Server 2012
14 11 (8.53%) Star Schema
15 9 (6.98%) Amazon Redshift
15 9 (6.98%) Azure SQL Data Warehouse
15 9 (6.98%) Azure SQL Database
16 8 (6.20%) PowerPivot
Development Applications
1 25 (19.38%) Git (software)
2 24 (18.60%) TeamCity
3 23 (17.83%) Octopus Deploy
4 6 (4.65%) SQL Server Management Studio (SSMS)
5 5 (3.88%) Visual Studio
6 4 (3.10%) Bitbucket
7 3 (2.33%) JIRA
7 3 (2.33%) Team Foundation Server
8 2 (1.55%) ERwin
8 2 (1.55%) Visual Studio Team System
8 2 (1.55%) Zephyr
9 1 (0.78%) Subversion
General
1 55 (42.64%) Finance
2 15 (11.63%) Retail
3 7 (5.43%) Legal
4 5 (3.88%) Front Office
5 4 (3.10%) Billing
6 3 (2.33%) General Ledger
6 3 (2.33%) Marketing
7 2 (1.55%) Banking
7 2 (1.55%) Public Sector
7 2 (1.55%) Telecoms
8 1 (0.78%) Games
8 1 (0.78%) Investment Banking
8 1 (0.78%) Law
8 1 (0.78%) Manufacturing
Job Titles
1 79 (61.24%) Developer
2 50 (38.76%) Business Intelligence Developer
3 16 (12.40%) Data Engineer
4 15 (11.63%) Consultant
5 14 (10.85%) SQL Developer
6 12 (9.30%) Analyst
7 9 (6.98%) C# Developer
7 9 (6.98%) SSRS Developer
8 8 (6.20%) Azure Developer
8 8 (6.20%) Business Developer
8 8 (6.20%) Data Warehouse Developer
8 8 (6.20%) ETL Developer
8 8 (6.20%) Power BI Developer
8 8 (6.20%) SQL BI Developer
8 8 (6.20%) SSIS Developer
9 7 (5.43%) SSAS Developer
10 6 (4.65%) Architect
10 6 (4.65%) Business Intelligence Consultant
11 5 (3.88%) Business Intelligence Analyst
11 5 (3.88%) Senior Developer
Libraries, Frameworks & Software Standards
1 26 (20.16%) MDX
2 24 (18.60%) .NET
3 21 (16.28%) AngularJS
3 21 (16.28%) ASP.NET
3 21 (16.28%) React
4 20 (15.50%) CSS
4 20 (15.50%) HTML
5 16 (12.40%) XML
6 11 (8.53%) Web Services
7 9 (6.98%) Kafka
8 5 (3.88%) JSON
9 4 (3.10%) Apache Camel
10 3 (2.33%) Oracle GoldenGate
10 3 (2.33%) Vue.js
11 2 (1.55%) Ext JS
11 2 (1.55%) Node.js
11 2 (1.55%) REST
11 2 (1.55%) SOAP
12 1 (0.78%) RabbitMQ
Miscellaneous
1 33 (25.58%) Analytical Skills
2 26 (20.16%) Hedge funds
3 11 (8.53%) Data Structures
4 5 (3.88%) Data Protection Act
5 3 (2.33%) Equities
5 3 (2.33%) Fixed Income
5 3 (2.33%) Replication
6 2 (1.55%) Greenfield Project
6 2 (1.55%) Reference Data
6 2 (1.55%) User Experience
6 2 (1.55%) Virtual Team
6 2 (1.55%) W3C
7 1 (0.78%) Algorithms
7 1 (0.78%) Enterprise Software
7 1 (0.78%) Hybrid Cloud
7 1 (0.78%) Management Information System
7 1 (0.78%) RIA
7 1 (0.78%) Taxonomies
Operating Systems
1 1 (0.78%) Android
1 1 (0.78%) Apple iOS
1 1 (0.78%) Linux
1 1 (0.78%) Windows
Processes & Methodologies
1 92 (71.32%) Business Intelligence
2 71 (55.04%) ETL
3 61 (47.29%) Agile Software Development
4 53 (41.09%) Visualisation
5 42 (32.56%) Data Visualisation
6 34 (26.36%) Data Analysis
7 32 (24.81%) Analytics
8 28 (21.71%) Data Modelling
9 24 (18.60%) Dimensional Modelling
10 22 (17.05%) Kimball Methodology
11 21 (16.28%) TDD
12 19 (14.73%) Web Development
13 18 (13.95%) Data Management
14 16 (12.40%) Performance Tuning
15 15 (11.63%) ETL Development
16 14 (10.85%) Problem-Solving
17 13 (10.08%) Business Analysis
18 12 (9.30%) Data Architecture
18 12 (9.30%) Scrum
19 11 (8.53%) Data Integration
Programming Languages
1 98 (75.97%) SQL
2 34 (26.36%) C#
3 27 (20.93%) PowerShell
4 25 (19.38%) T-SQL
5 23 (17.83%) Data Analysis Expressions (DAX)
6 15 (11.63%) Python
7 8 (6.20%) Java
8 5 (3.88%) JavaScript
9 4 (3.10%) Java 8
9 4 (3.10%) PL/SQL
10 3 (2.33%) R
11 1 (0.78%) VB.NET
Qualifications
1 16 (12.40%) Degree
2 5 (3.88%) SC Cleared
2 5 (3.88%) Security Cleared
3 3 (2.33%) CFA
4 2 (1.55%) Computer Science Degree
5 1 (0.78%) CIMA
5 1 (0.78%) DV Cleared
5 1 (0.78%) Microsoft Certification
Quality Assurance & Compliance
1 8 (6.20%) Data Quality
2 4 (3.10%) QA
3 1 (0.78%) IFRS
3 1 (0.78%) PMO
System Software
1 6 (4.65%) Docker
2 2 (1.55%) HDFS
2 2 (1.55%) VMware Infrastructure
3 1 (0.78%) Active Directory
3 1 (0.78%) Apache Flume
Systems Management
1 6 (4.65%) Control-M
1 6 (4.65%) Opscode Chef
1 6 (4.65%) Puppet
2 3 (2.33%) Oozie
3 2 (1.55%) HP ALM
4 1 (0.78%) Terraform
Vendors
1 54 (41.86%) Tableau
2 48 (37.21%) Microsoft
3 38 (29.46%) Cognos
4 24 (18.60%) MicroStrategy
5 18 (13.95%) Oracle
6 9 (6.98%) Talend
7 8 (6.20%) Informatica
8 7 (5.43%) IBM
9 6 (4.65%) SAP
10 3 (2.33%) Ariba
10 3 (2.33%) Databricks
10 3 (2.33%) EXASOL
11 2 (1.55%) Ab Initio
11 2 (1.55%) Citrix
11 2 (1.55%) HP
11 2 (1.55%) InterSystems
11 2 (1.55%) Sencha
11 2 (1.55%) VMware
12 1 (0.78%) JD Edwards
12 1 (0.78%) Perforce