Online Analytical Processing (OLAP)
UK

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 18 May 2024 with a comparison to the same period in the previous 2 years.

6 months to
18 May 2024
Same period 2023 Same period 2022
Rank 537 627 756
Rank change year-on-year +90 +129 -110
Contract jobs citing OLAP 34 60 88
As % of all contract jobs advertised in the UK 0.080% 0.11% 0.10%
As % of the Database & Business Intelligence category 0.47% 0.59% 0.50%
Number of daily rates quoted 26 33 72
10th Percentile £396 £451 £338
25th Percentile £450 £563 £427
Median daily rate (50th Percentile) £492 £720 £538
Median % change year-on-year -31.70% +33.95% +5.13%
75th Percentile £587 £975 £638
90th Percentile £719 £1,013 £694
UK excluding London median daily rate £489 £450 £365
% change year-on-year +8.67% +23.29% -20.87%
Number of hourly rates quoted 0 1 0
Median hourly rate - £34.80 -
UK excluding London median hourly rate - £34.80 -

All Database and Business Intelligence Skills
UK

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.

Contract vacancies with a requirement for database or business intelligence skills 7,304 10,170 17,461
As % of all contract IT jobs advertised in the UK 17.15% 17.86% 19.95%
Number of daily rates quoted 5,237 7,238 12,433
10th Percentile £350 £375 £375
25th Percentile £425 £450 £450
Median daily rate (50th Percentile) £525 £545 £549
Median % change year-on-year -3.67% -0.73% +9.80%
75th Percentile £650 £663 £650
90th Percentile £775 £751 £750
UK excluding London median daily rate £475 £500 £495
% change year-on-year -5.00% +1.01% +11.55%
Number of hourly rates quoted 148 178 185
10th Percentile £14.00 £21.24 £15.00
25th Percentile £20.98 £32.30 £22.50
Median hourly rate £40.00 £58.59 £46.00
Median % change year-on-year -31.73% +27.37% +75.24%
75th Percentile £61.53 £73.41 £65.00
90th Percentile £73.25 £79.28 £75.00
UK excluding London median hourly rate £40.00 £56.40 £35.00
% change year-on-year -29.08% +61.14% +45.83%

OLAP
Job Vacancy Trend

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

Job vacancy trend for OLAP in the UK

OLAP
Contractor Daily Rate Trend

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

Daily rate trend for OLAP in the UK

OLAP
Daily Rate Histogram

Daily rate distribution for jobs citing OLAP over the 6 months to 18 May 2024.

Daily rate histogram for OLAP in the UK

OLAP
Contractor Hourly Rate Trend

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

Hourly rate trend for OLAP in the UK

OLAP
Top 12 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 18 May 2024. 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
Jobs
England +87 34 £492 -31.94% 25
UK excluding London +68 18 £489 +8.67% 17
Work from Home +92 17 £489 -32.32% 18
London +69 15 £500 -35.48% 16
North of England +39 9 £489 +8.67% 1
North West +27 8 £489 +5.73% 1
Midlands +27 5 £516 +7.55% 5
West Midlands +25 3 £573 +19.27% 5
South East +32 2 £475 - 6
South West +8 2 £675 -
East Midlands - 2 £444 -
Yorkshire - 1 £325 -

OLAP
Co-occurring Skills and Capabilities by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same employment type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 6 (17.65%) Confluence
1 6 (17.65%) Oracle SOA Suite
Applications
1 7 (20.59%) MS Visio
2 2 (5.88%) Microsoft Excel
Business Applications
1 7 (20.59%) Temenos T24
2 1 (2.94%) Epicor Tropos
Cloud Services
1 21 (61.76%) Azure
2 13 (38.24%) Power Platform
3 11 (32.35%) AWS
4 7 (20.59%) Apigee
4 7 (20.59%) Kong
5 6 (17.65%) GCP
6 3 (8.82%) IaaS
6 3 (8.82%) PaaS
6 3 (8.82%) SaaS
6 3 (8.82%) Serverless
7 2 (5.88%) Azure Data Factory
8 1 (2.94%) Amazon EC2
8 1 (2.94%) AWS CodeBuild
8 1 (2.94%) AWS CodeCommit
8 1 (2.94%) AWS Lambda
8 1 (2.94%) AWS Step Functions
8 1 (2.94%) Azure Synapse Analytics
8 1 (2.94%) Matillion
8 1 (2.94%) Snowflake
Communications & Networking
1 1 (2.94%) Internet
Database & Business Intelligence
1 25 (73.53%) OLTP
2 13 (38.24%) Data Warehouse
2 13 (38.24%) Power BI
3 9 (26.47%) Data Lake
4 8 (23.53%) Oracle OLAP
5 7 (20.59%) MongoDB
5 7 (20.59%) SQL Server
6 6 (17.65%) Big Data
7 4 (11.76%) Metadata
8 3 (8.82%) Enterprise Data Warehouse
8 3 (8.82%) Microsoft Analysis Services
8 3 (8.82%) NoSQL
8 3 (8.82%) Relational Database
8 3 (8.82%) SQL Server Analysis Services
8 3 (8.82%) SQL Server Reporting Services
8 3 (8.82%) Tableau
9 2 (5.88%) OLAP Cube
9 2 (5.88%) SQL Server Integration Services
10 1 (2.94%) Oracle Database
10 1 (2.94%) Oracle Database 12c
Development Applications
1 7 (20.59%) JIRA
2 2 (5.88%) kappa
General
1 19 (55.88%) Finance
2 13 (38.24%) Banking
3 9 (26.47%) Social Skills
4 3 (8.82%) Analytical Skills
4 3 (8.82%) Documentation Skills
4 3 (8.82%) Financial Institution
5 2 (5.88%) Public Sector
6 1 (2.94%) Manufacturing
6 1 (2.94%) Retail Banking
Job Titles
1 24 (70.59%) Architect
2 16 (47.06%) Data Architect
3 7 (20.59%) AWS Architect
3 7 (20.59%) Cloud Architect
4 5 (14.71%) Solutions Architect
5 4 (11.76%) Azure Architect
5 4 (11.76%) Azure Data Architect
5 4 (11.76%) Cloud Solutions Architect
5 4 (11.76%) Data Engineer
5 4 (11.76%) Senior
5 4 (11.76%) Senior Architect
5 4 (11.76%) Senior Data Architect
6 3 (8.82%) Developer
6 3 (8.82%) Enterprise Architect
6 3 (8.82%) Enterprise Data Architect
7 2 (5.88%) Administrator
7 2 (5.88%) Azure Data Engineer
7 2 (5.88%) Azure Engineer
7 2 (5.88%) Business Intelligence Developer
7 2 (5.88%) DBA
Libraries, Frameworks & Software Standards
1 12 (35.29%) Kafka
2 8 (23.53%) SOAP
3 7 (20.59%) IBM Integration Bus
3 7 (20.59%) J2EE
3 7 (20.59%) RabbitMQ
3 7 (20.59%) Web Services
4 6 (17.65%) Apache Camel
4 6 (17.65%) Spring
4 6 (17.65%) Spring Boot
4 6 (17.65%) Spring Integration
5 3 (8.82%) Middleware
6 1 (2.94%) .NET
6 1 (2.94%) PySpark
6 1 (2.94%) RESTful
Miscellaneous
1 7 (20.59%) DataPower
2 3 (8.82%) Product Ownership
2 3 (8.82%) Taxonomies
3 2 (5.88%) Enterprise Software
3 2 (5.88%) Legacy Systems
4 1 (2.94%) Cloud Native
4 1 (2.94%) Legacy Applications
4 1 (2.94%) Self-Motivation
Processes & Methodologies
1 18 (52.94%) Data Modelling
2 14 (41.18%) Analytics
3 11 (32.35%) Migration
4 10 (29.41%) Enterprise Architecture
4 10 (29.41%) Roadmaps
4 10 (29.41%) Visualisation
5 9 (26.47%) Design Patterns
5 9 (26.47%) Stakeholder Management
6 8 (23.53%) Business Intelligence
6 8 (23.53%) Data Governance
6 8 (23.53%) DevOps
7 7 (20.59%) API Management
7 7 (20.59%) CQRS
7 7 (20.59%) Data Engineering
7 7 (20.59%) Data Visualisation
7 7 (20.59%) Event-Driven
7 7 (20.59%) Event-Driven Architecture
7 7 (20.59%) Identity Access Management
7 7 (20.59%) Microservices
7 7 (20.59%) Problem-Solving
Programming Languages
1 11 (32.35%) SQL
2 8 (23.53%) Java
3 3 (8.82%) T-SQL
4 2 (5.88%) Python
5 1 (2.94%) Bash
5 1 (2.94%) Data Analysis Expressions
5 1 (2.94%) PL/SQL
5 1 (2.94%) PowerShell
5 1 (2.94%) VBScript
Qualifications
1 4 (11.76%) SC Cleared
1 4 (11.76%) Security Cleared
2 2 (5.88%) Computer Science Degree
2 2 (5.88%) Degree
3 1 (2.94%) AWS Certification
Quality Assurance & Compliance
1 6 (17.65%) Data Quality
2 2 (5.88%) Accessibility
3 1 (2.94%) QA
System Software
1 3 (8.82%) Docker
Systems Management
1 6 (17.65%) Single Sign-On
2 1 (2.94%) Terraform
Vendors
1 9 (26.47%) Microsoft
2 8 (23.53%) Oracle
3 7 (20.59%) IBM
3 7 (20.59%) TSYS
4 5 (14.71%) Databricks
4 5 (14.71%) Google
5 1 (2.94%) Jedox
5 1 (2.94%) Salesforce