Period
to 28 March 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 28 March 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
28 Mar 2020
Same period 2019 Same period 2018
Rank 563 642 638
Rank change year-on-year +79 -4 -10
Contract jobs citing OLAP 110 197 221
As % of all contract jobs advertised in England 0.19% 0.22% 0.24%
As % of the Database & Business Intelligence category 0.92% 0.99% 1.07%
Number of daily rates quoted 94 140 158
Median daily rate £475 £500 £500
Median daily rate % change year-on-year -5.00% - +17.65%
10th Percentile £341 £363 £325
90th Percentile £800 £590 £650
UK median daily rate £469 £500 £500
% change year-on-year -6.25% - +17.65%
Number of hourly rates quoted 0 2 1
Median hourly rate - £15.06 £55.00
Median hourly rate % change year-on-year - -72.61% -
UK median hourly rate - £15.06 £55.00
% change year-on-year - -72.61% -

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 12,018 19,892 20,616
As % of all contract IT jobs advertised in England 21.15% 22.51% 22.13%
Number of daily rates quoted 7,968 13,860 14,411
Median daily rate £488 £488 £475
Median daily rate % change year-on-year - +2.63% +5.56%
10th Percentile £325 £325 £313
90th Percentile £675 £650 £638
UK median daily rate £475 £475 £470
% change year-on-year - +1.06% +7.43%
Number of hourly rates quoted 209 224 219
Median hourly rate £35.00 £35.00 £35.00
10th Percentile £15.00 £14.19 £14.72
90th Percentile £58.30 £56.50 £54.00
Median hourly rate £35.00 £35.00 £35.00

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 28 March 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 28 March 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 +95 65 £550 - 7
South East +104 27 £413 -5.71% 7
East of England +36 9 £413 -2.94%
Midlands +61 6 £463 +2.78% 7
West Midlands +54 5 £463 +5.71% 3
North of England +44 3 £325 -27.78% 2
North East +21 2 £325 -27.78%
Yorkshire +50 1 - -
East Midlands +32 1 £500 -16.67% 4
OLAP
UK

For the 6 months to 28 March 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 88 (80.00%) Business Intelligence
2 78 (70.91%) SQL
3 67 (60.91%) Power BI
3 67 (60.91%) Power Platform
4 60 (54.55%) SQL Server
5 56 (50.91%) Data Warehouse
5 56 (50.91%) Agile Software Development
6 50 (45.45%) ETL
7 49 (44.55%) SQL Server Analysis Services
8 47 (42.73%) Finance
9 43 (39.09%) Microsoft
10 40 (36.36%) Tableau
11 39 (35.45%) Visualisation
11 39 (35.45%) Analytics
12 37 (33.64%) C#
13 35 (31.82%) .NET
14 34 (30.91%) Analytical Skills
15 32 (29.09%) SQL Server Reporting Services
15 32 (29.09%) Cognos
16 29 (26.36%) T-SQL
17 28 (25.45%) Data Visualisation
18 27 (24.55%) Azure
18 27 (24.55%) SQL Server Integration Services
18 27 (24.55%) ASP.NET
19 24 (21.82%) CSS
19 24 (21.82%) HTML
20 23 (20.91%) Python
20 23 (20.91%) Data Lake
21 22 (20.00%) Git (software)
22 21 (19.09%) PowerShell

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 6 (5.45%) SAS
2 5 (4.55%) Apache Spark
3 2 (1.82%) SharePoint
Applications
1 21 (19.09%) Microsoft Excel
2 2 (1.82%) Microsoft Office
2 2 (1.82%) Microsoft PowerPoint
2 2 (1.82%) Spreadsheet
Business Applications
1 11 (10.00%) SAP S/4HANA
2 7 (6.36%) SAP Oil and Gas
3 2 (1.82%) thinkFolio
Cloud Services
1 67 (60.91%) Power Platform
2 27 (24.55%) Azure
3 20 (18.18%) AWS
4 9 (8.18%) Azure Data Factory
5 3 (2.73%) PaaS
6 2 (1.82%) Office 365
7 1 (0.91%) Amazon Kinesis
7 1 (0.91%) AWS Lambda
7 1 (0.91%) Serverless
Communications & Networking
1 2 (1.82%) FTP
Database & Business Intelligence
1 67 (60.91%) Power BI
2 60 (54.55%) SQL Server
3 56 (50.91%) Data Warehouse
4 49 (44.55%) SQL Server Analysis Services
5 32 (29.09%) SQL Server Reporting Services
6 27 (24.55%) SQL Server Integration Services
7 23 (20.91%) Data Lake
8 21 (19.09%) QlikView
9 17 (15.45%) OLAP Cube
10 16 (14.55%) Oracle OLAP
11 13 (11.82%) SAP BW
12 12 (10.91%) Relational Database
13 11 (10.00%) Azure SQL Data Warehouse
13 11 (10.00%) Hadoop
14 9 (8.18%) Amazon Redshift
15 8 (7.27%) OLTP
16 7 (6.36%) Data Mining
17 6 (5.45%) Big Data
17 6 (5.45%) Snowflake Schema
17 6 (5.45%) SQL Server 2008
Development Applications
1 22 (20.00%) Git (software)
2 21 (19.09%) Octopus Deploy
3 20 (18.18%) TeamCity
4 7 (6.36%) Visual Studio Team System
5 4 (3.64%) Team Foundation Server
6 3 (2.73%) Visual Studio
7 2 (1.82%) ERwin
7 2 (1.82%) SQL Server Management Studio (SSMS)
7 2 (1.82%) tSQLt
8 1 (0.91%) JIRA
8 1 (0.91%) PHPUnit
8 1 (0.91%) PowerDesigner
8 1 (0.91%) Subversion
8 1 (0.91%) Vagrant
General
1 47 (42.73%) Finance
2 12 (10.91%) Banking
3 10 (9.09%) Retail
4 8 (7.27%) Legal
5 3 (2.73%) Manufacturing
6 2 (1.82%) International Banking
6 2 (1.82%) Marketing
7 1 (0.91%) Back Office
7 1 (0.91%) Front Office
Job Titles
1 70 (63.64%) Developer
2 34 (30.91%) Business Intelligence Developer
3 18 (16.36%) SQL Developer
4 15 (13.64%) Analyst
5 14 (12.73%) C# Developer
6 13 (11.82%) Data Engineer
7 10 (9.09%) Business Analyst
8 9 (8.18%) Architect
8 9 (8.18%) Azure Developer
9 7 (6.36%) AWS Engineer
9 7 (6.36%) Data Architect
9 7 (6.36%) Junior
9 7 (6.36%) Junior Developer
9 7 (6.36%) SQL Server Developer
10 6 (5.45%) .NET Developer
10 6 (5.45%) C# .NET Developer
10 6 (5.45%) Junior .NET Developer
10 6 (5.45%) Junior C# .NET Developer
10 6 (5.45%) Junior C# Developer
10 6 (5.45%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 35 (31.82%) .NET
2 27 (24.55%) ASP.NET
3 24 (21.82%) CSS
3 24 (21.82%) HTML
4 16 (14.55%) AngularJS
4 16 (14.55%) React
5 11 (10.00%) XML
6 8 (7.27%) MDX
7 6 (5.45%) Web Services
8 3 (2.73%) RabbitMQ
9 2 (1.82%) JSON
9 2 (1.82%) Kafka
9 2 (1.82%) Node.js
9 2 (1.82%) Vue.js
10 1 (0.91%) Apache NiFi
10 1 (0.91%) FIX Protocol
10 1 (0.91%) REST
Miscellaneous
1 34 (30.91%) Analytical Skills
2 20 (18.18%) Hedge funds
3 7 (6.36%) Data Structures
4 6 (5.45%) Management Information System
5 5 (4.55%) Equities
6 3 (2.73%) Fat Client
6 3 (2.73%) Foreign Exchange (FX)
6 3 (2.73%) Greenfield Project
6 3 (2.73%) Thin Client
7 2 (1.82%) Derivative
7 2 (1.82%) Equity Derivative
7 2 (1.82%) Fixed Income
8 1 (0.91%) Cloud Native
8 1 (0.91%) Public Cloud
8 1 (0.91%) Reference Data
8 1 (0.91%) RIA
8 1 (0.91%) User Experience
Operating Systems
1 1 (0.91%) Unix
Processes & Methodologies
1 88 (80.00%) Business Intelligence
2 56 (50.91%) Agile Software Development
3 50 (45.45%) ETL
4 39 (35.45%) Analytics
4 39 (35.45%) Visualisation
5 28 (25.45%) Data Visualisation
6 20 (18.18%) Data Modelling
7 19 (17.27%) Data Analysis
7 19 (17.27%) TDD
8 18 (16.36%) Dimensional Modelling
9 17 (15.45%) Web Development
10 16 (14.55%) Business Analysis
11 15 (13.64%) Kimball Methodology
12 13 (11.82%) Data Analytics
12 13 (11.82%) Stakeholder Management
13 11 (10.00%) Data Management
13 11 (10.00%) Problem-Solving
14 10 (9.09%) Change Management
15 9 (8.18%) Performance Tuning
16 8 (7.27%) Data Architecture
Programming Languages
1 78 (70.91%) SQL
2 37 (33.64%) C#
3 29 (26.36%) T-SQL
4 23 (20.91%) Python
5 21 (19.09%) PowerShell
6 10 (9.09%) Data Analysis Expressions (DAX)
6 10 (9.09%) JavaScript
7 8 (7.27%) VBA
8 4 (3.64%) Scala
8 4 (3.64%) U-SQL
9 3 (2.73%) Java
9 3 (2.73%) VB
9 3 (2.73%) VB.NET
10 1 (0.91%) PHP
10 1 (0.91%) PHP 7
10 1 (0.91%) PL/SQL
Qualifications
1 12 (10.91%) Degree
2 3 (2.73%) Computer Science Degree
2 3 (2.73%) MCITP
2 3 (2.73%) Microsoft Certification
3 1 (0.91%) AWS Certification
3 1 (0.91%) CHECK Team Member
3 1 (0.91%) Master's Degree
Quality Assurance & Compliance
1 10 (9.09%) QA
2 4 (3.64%) Data Quality
3 1 (0.91%) GDPR
3 1 (0.91%) PMO
System Software
1 2 (1.82%) VMware Infrastructure
2 1 (0.91%) Apache Flume
2 1 (0.91%) Docker
2 1 (0.91%) HDFS
Systems Management
1 3 (2.73%) Control-M
1 3 (2.73%) Opscode Chef
1 3 (2.73%) Puppet
2 1 (0.91%) Terraform
Vendors
1 43 (39.09%) Microsoft
2 40 (36.36%) Tableau
3 32 (29.09%) Cognos
4 19 (17.27%) MicroStrategy
5 16 (14.55%) Oracle
5 16 (14.55%) SAP
6 7 (6.36%) Databricks
7 5 (4.55%) Cloudera
8 4 (3.64%) Hyperion
8 4 (3.64%) Salesforce.com
8 4 (3.64%) Talend
9 3 (2.73%) IBM
9 3 (2.73%) Sybase
9 3 (2.73%) Teradata
10 2 (1.82%) Birst
10 2 (1.82%) Citrix
10 2 (1.82%) Infor
10 2 (1.82%) VMware
11 1 (0.91%) Anaplan
11 1 (0.91%) Salesforce Marketing Cloud