Period
to 13 August 2020

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 13 August 2020 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
13 Aug 2020
Same period 2019 Same period 2018
Rank 448 648 634
Rank change year-on-year +200 -14 -11
Contract jobs citing OLAP 64 170 239
As % of all contract jobs advertised in England 0.21% 0.21% 0.26%
As % of the Database & Business Intelligence category 0.96% 0.93% 1.11%
Number of daily rates quoted 38 132 170
Median daily rate £450 £538 £513
Median daily rate % change year-on-year -16.28% +4.88% +17.14%
10th Percentile £343 £350 £350
90th Percentile £675 £706 £588
UK median daily rate £450 £525 £513
% change year-on-year -14.29% +2.44% +17.14%
Number of hourly rates quoted 0 2 0
Median hourly rate - £70.00 -
UK median hourly rate - £70.00 -

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 6,685 18,345 21,501
As % of all contract IT jobs advertised in England 21.99% 22.17% 22.98%
Number of daily rates quoted 4,414 12,720 15,166
Median daily rate £500 £475 £475
Median daily rate % change year-on-year +5.26% - +5.56%
10th Percentile £325 £325 £313
90th Percentile £700 £650 £638
UK median daily rate £500 £475 £463
% change year-on-year +5.26% +2.70% +2.78%
Number of hourly rates quoted 141 240 231
Median hourly rate £35.00 £35.00 £30.00
Median hourly rate % change year-on-year - +16.67% -3.23%
10th Percentile £15.19 £14.28 £14.00
90th Percentile £55.00 £60.08 £52.75
Median hourly rate £35.00 £35.00 £30.00
% change year-on-year - +16.67% -4.76%

OLAP
Job Vacancy Trend in England

Job postings citing OLAP as a proportion of all IT jobs advertised in England.

Job vacancy trend for OLAP in England

OLAP
Contractor Daily Rate Trend in England

3-month moving average daily rate quoted in jobs citing OLAP in England.

Daily rate trend for OLAP in England

OLAP
Daily Rate Histogram in England

Daily rate distribution for jobs citing OLAP in England over the 6 months to 13 August 2020.

Daily rate histogram for OLAP in England

OLAP
Contractor Hourly Rate Trend in England

3-month moving average hourly rates quoted in jobs citing OLAP in England.

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 13 August 2020. 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 +141 48 £450 -18.18% 6
South East +164 8 £500 +11.11% 1
Midlands +89 6 £425 -2.86% 2
West Midlands +68 5 £425 +3.03%
North of England +111 1 £400 +23.08% 3
East of England +84 1 - -
East Midlands +63 1 - - 2
North East - 1 £400 - 3
OLAP
UK

For the 6 months to 13 August 2020, 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 48 (75.00%) SQL
2 41 (64.06%) Data Warehouse
3 40 (62.50%) Finance
4 38 (59.38%) Business Intelligence
5 27 (42.19%) Analytics
6 24 (37.50%) SQL Server Reporting Services
7 23 (35.94%) SQL Server
8 19 (29.69%) C#
8 19 (29.69%) ETL
9 18 (28.13%) .NET
9 18 (28.13%) Agile Software Development
9 18 (28.13%) Banking
10 17 (26.56%) QA
10 17 (26.56%) SQL Server Analysis Services
11 16 (25.00%) VBA
11 16 (25.00%) Microsoft
12 15 (23.44%) Oracle
12 15 (23.44%) JavaScript
12 15 (23.44%) Oracle OLAP
12 15 (23.44%) OLAP Cube
13 14 (21.88%) Business Analysis
13 14 (21.88%) HTML
13 14 (21.88%) CSS
13 14 (21.88%) Cognos
14 13 (20.31%) ASP.NET
14 13 (20.31%) T-SQL
14 13 (20.31%) DevOps
14 13 (20.31%) Analytical Skills
14 13 (20.31%) Power BI
14 13 (20.31%) Power Platform

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 7 (10.94%) Apache Spark
2 1 (1.56%) IIS
2 1 (1.56%) SAS
Applications
1 3 (4.69%) Microsoft Excel
1 3 (4.69%) Spreadsheet
2 1 (1.56%) Microsoft Office
2 1 (1.56%) Microsoft PowerPoint
2 1 (1.56%) MS Visio
2 1 (1.56%) SPSS
Business Applications
1 2 (3.13%) thinkFolio
2 1 (1.56%) Cognos TM1
2 1 (1.56%) Hyperion Planning
2 1 (1.56%) SAP Oil and Gas
2 1 (1.56%) SAP S/4HANA
2 1 (1.56%) Unit4 Business World
Cloud Services
1 13 (20.31%) Power Platform
2 11 (17.19%) Azure
3 4 (6.25%) GCP
4 3 (4.69%) Azure Data Factory
5 2 (3.13%) AWS
5 2 (3.13%) Azure Active Directory
6 1 (1.56%) Data Lake Analytics
6 1 (1.56%) GitHub
6 1 (1.56%) PowerApps
Communications & Networking
1 2 (3.13%) DNS
1 2 (3.13%) Firewall
2 1 (1.56%) SMTP
Database & Business Intelligence
1 41 (64.06%) Data Warehouse
2 24 (37.50%) SQL Server Reporting Services
3 23 (35.94%) SQL Server
4 17 (26.56%) SQL Server Analysis Services
5 15 (23.44%) OLAP Cube
5 15 (23.44%) Oracle OLAP
6 13 (20.31%) Power BI
7 10 (15.63%) SQL Server Integration Services
8 9 (14.06%) SAP BW
9 8 (12.50%) Data Lake
10 7 (10.94%) BusinessObjects
10 7 (10.94%) BusinessObjects Web Intelligence
10 7 (10.94%) Hadoop
10 7 (10.94%) Lumira
11 6 (9.38%) Azure SQL Data Warehouse
11 6 (9.38%) Data Mining
11 6 (9.38%) DB2
12 5 (7.81%) Enterprise Data Warehouse
12 5 (7.81%) MongoDB
13 4 (6.25%) Azure SQL Database
Development Applications
1 5 (7.81%) Team Foundation Server
2 4 (6.25%) Git (software)
2 4 (6.25%) Octopus Deploy
2 4 (6.25%) TeamCity
2 4 (6.25%) Visual Studio Team System
3 2 (3.13%) Jenkins
3 2 (3.13%) JIRA
3 2 (3.13%) tSQLt
4 1 (1.56%) Cucumber
4 1 (1.56%) ERwin
4 1 (1.56%) HP UFT
4 1 (1.56%) Liquibase
4 1 (1.56%) PowerDesigner
4 1 (1.56%) ProC
4 1 (1.56%) SQL Server Management Studio (SSMS)
4 1 (1.56%) Subversion
4 1 (1.56%) Toad
4 1 (1.56%) Visual Studio
General
1 40 (62.50%) Finance
2 18 (28.13%) Banking
3 5 (7.81%) Marketing
3 5 (7.81%) Retail
4 3 (4.69%) International Banking
5 2 (3.13%) Pharmaceutical
6 1 (1.56%) Front Office
6 1 (1.56%) Investment Banking
6 1 (1.56%) Legal
6 1 (1.56%) Public Sector
Job Titles
1 32 (50.00%) Developer
2 11 (17.19%) Architect
2 11 (17.19%) Data Architect
3 9 (14.06%) Consultant
3 9 (14.06%) SQL Developer
4 7 (10.94%) .NET Developer
4 7 (10.94%) C# .NET Developer
4 7 (10.94%) C# Developer
4 7 (10.94%) Junior
4 7 (10.94%) Junior Developer
5 6 (9.38%) Business Intelligence Developer
5 6 (9.38%) Junior .NET Developer
5 6 (9.38%) Junior C# .NET Developer
5 6 (9.38%) Junior C# Developer
5 6 (9.38%) Junior SQL Developer
6 4 (6.25%) Data Analytics Architect
6 4 (6.25%) DevOps Manager
6 4 (6.25%) Junior VBA Developer
6 4 (6.25%) SAP BusinessObjects (BO) Consultant
6 4 (6.25%) VBA Developer
Libraries, Frameworks & Software Standards
1 18 (28.13%) .NET
2 14 (21.88%) CSS
2 14 (21.88%) HTML
3 13 (20.31%) ASP.NET
4 6 (9.38%) MDX
5 2 (3.13%) XML
5 2 (3.13%) YAML
6 1 (1.56%) DHTML
6 1 (1.56%) FIX Protocol
6 1 (1.56%) JSON
6 1 (1.56%) Kafka
6 1 (1.56%) Matplotlib
6 1 (1.56%) Node.js
6 1 (1.56%) NumPy
6 1 (1.56%) Pandas
6 1 (1.56%) SciPy
6 1 (1.56%) Seaborn
6 1 (1.56%) Vue.js
Miscellaneous
1 13 (20.31%) Analytical Skills
2 8 (12.50%) Management Information System
3 4 (6.25%) Algorithms
4 3 (4.69%) Data Structures
4 3 (4.69%) Foreign Exchange (FX)
4 3 (4.69%) Self-Motivation
4 3 (4.69%) Taxonomies
4 3 (4.69%) User Experience
5 2 (3.13%) Fixed Income
6 1 (1.56%) BBC
6 1 (1.56%) Clustering
6 1 (1.56%) Credit Risk
6 1 (1.56%) FMCG
6 1 (1.56%) NHS
6 1 (1.56%) Reference Data
6 1 (1.56%) Social Media
Operating Systems
1 3 (4.69%) Windows
2 1 (1.56%) Linux
2 1 (1.56%) Unix
Processes & Methodologies
1 38 (59.38%) Business Intelligence
2 27 (42.19%) Analytics
3 19 (29.69%) ETL
4 18 (28.13%) Agile Software Development
5 14 (21.88%) Business Analysis
6 13 (20.31%) DevOps
7 12 (18.75%) Data Modelling
7 12 (18.75%) Visualisation
8 11 (17.19%) Kimball Methodology
9 8 (12.50%) Stakeholder Management
9 8 (12.50%) User Acceptance Testing
10 7 (10.94%) Scrum
10 7 (10.94%) Test Automation
11 6 (9.38%) Computer Science
11 6 (9.38%) Data Analytics
11 6 (9.38%) Data Integration
11 6 (9.38%) Dimensional Modelling
11 6 (9.38%) Migration
11 6 (9.38%) Waterfall
12 5 (7.81%) Risk Management
Programming Languages
1 48 (75.00%) SQL
2 19 (29.69%) C#
3 16 (25.00%) VBA
4 15 (23.44%) JavaScript
5 13 (20.31%) T-SQL
6 6 (9.38%) ABAP
6 6 (9.38%) Python
7 4 (6.25%) Scala
7 4 (6.25%) U-SQL
8 3 (4.69%) Data Analysis Expressions (DAX)
9 2 (3.13%) Bash Shell
9 2 (3.13%) C
9 2 (3.13%) Java
9 2 (3.13%) PowerShell
10 1 (1.56%) PHP
10 1 (1.56%) PROC SQL
10 1 (1.56%) SAS Macro
10 1 (1.56%) VB
Qualifications
1 5 (7.81%) Degree
2 2 (3.13%) Computer Science Degree
2 2 (3.13%) SAP Certification
3 1 (1.56%) AWS Certification
3 1 (1.56%) Master's Degree
3 1 (1.56%) Microsoft Certification
Quality Assurance & Compliance
1 17 (26.56%) QA
2 2 (3.13%) Data Quality
3 1 (1.56%) GDPR
System Software
1 4 (6.25%) Active Directory
2 1 (1.56%) Virtual Machines
Systems Management
1 1 (1.56%) HP Quality Center
1 1 (1.56%) Kubernetes
1 1 (1.56%) Microsoft Clustering
Vendors
1 16 (25.00%) Microsoft
2 15 (23.44%) Oracle
3 14 (21.88%) Cognos
4 9 (14.06%) SAP
5 7 (10.94%) IBM
6 5 (7.81%) Teradata
7 4 (6.25%) Databricks
8 1 (1.56%) Birst
8 1 (1.56%) HP
8 1 (1.56%) Hyperion
8 1 (1.56%) Infor
8 1 (1.56%) Tableau