Period
to 10 August 2020

The following table provides summary statistics for permanent job vacancies with a requirement for OLAP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLAP over the 6 months to 10 August 2020 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK
6 months to
10 Aug 2020
Same period 2019 Same period 2018
Rank 596 732 721
Rank change year-on-year +136 -11 -75
Permanent jobs citing OLAP 184 392 500
As % of all permanent jobs advertised in the UK 0.29% 0.27% 0.29%
As % of the Database & Business Intelligence category 1.04% 1.00% 0.97%
Number of salaries quoted 147 358 425
Median annual salary £51,000 £55,000 £50,000
Median salary % change year-on-year -7.27% +10.00% -
10th Percentile £35,100 £36,425 £31,750
90th Percentile £97,000 £87,500 £77,500
UK excluding London median annual salary £50,000 £47,000 £45,000
% change year-on-year +6.38% +4.44% +5.88%

OLAP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 17,614 39,281 51,795
As % of all permanent IT jobs advertised in the UK 27.39% 27.34% 30.20%
Number of salaries quoted 14,328 32,219 42,200
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £32,500 £31,250 £31,250
90th Percentile £88,750 £85,000 £82,500
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

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
Salary Trend

3-month moving average salary quoted in jobs citing OLAP.

Salary trend for OLAP in the UK

OLAP
Salary Histogram

Salary distribution for jobs citing OLAP over the 6 months to 10 August 2020.

Salary histogram for OLAP in the UK

OLAP
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the UK over the 6 months to 10 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +170 182 £51,000 -7.27% 10
London +114 102 £60,000 - 5
UK excluding London +184 80 £50,000 +6.38% 5
Midlands +68 22 £51,000 +20.00% 2
South East +175 19 £47,500 -6.86% 1
Work from Home +53 16 £47,500 -9.52% 2
South West +113 14 £47,500 -25.49% 1
East of England +104 13 £40,000 +18.52%
North of England +132 12 £60,000 +33.33% 1
East Midlands +69 12 £50,000 +5.26% 2
West Midlands +65 10 £51,000 +27.50%
North West +114 8 £66,250 +47.22%
Yorkshire +134 3 £65,000 +52.94%
North East +28 1 £32,500 -7.14% 1

For the 6 months to 10 August 2020, IT 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 permanent job ads with a requirement for OLAP.

1 129 (70.11%) SQL Server
1 129 (70.11%) Business Intelligence
2 119 (64.67%) SQL
3 105 (57.07%) Data Warehouse
4 102 (55.43%) ETL
4 102 (55.43%) SQL Server Integration Services
5 90 (48.91%) SQL Server Analysis Services
6 87 (47.28%) Power BI
6 87 (47.28%) Power Platform
7 83 (45.11%) Microsoft
7 83 (45.11%) SQL Server Reporting Services
8 82 (44.57%) Analytics
9 75 (40.76%) Analytical Skills
10 69 (37.50%) Data Modelling
11 57 (30.98%) Agile Software Development
11 57 (30.98%) OLTP
12 56 (30.43%) Finance
12 56 (30.43%) Azure
13 47 (25.54%) T-SQL
14 46 (25.00%) Tableau
15 42 (22.83%) Visualisation
16 41 (22.28%) Python
17 40 (21.74%) Data Management
17 40 (21.74%) Problem-Solving
18 39 (21.20%) Relational Database
19 35 (19.02%) Degree
20 34 (18.48%) Oracle OLAP
20 34 (18.48%) RDBMS
20 34 (18.48%) Oracle
21 32 (17.39%) C#

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 6 (3.26%) Apache Airflow
2 5 (2.72%) Elasticsearch
3 4 (2.17%) Apache
3 4 (2.17%) Apache Spark
3 4 (2.17%) Apache Synapse
4 3 (1.63%) SharePoint
5 1 (0.54%) CMS
5 1 (0.54%) Oracle SOA Suite
Applications
1 25 (13.59%) Microsoft Excel
2 2 (1.09%) MS Visio
2 2 (1.09%) S-PLUS
3 1 (0.54%) Microsoft Office
Business Applications
1 5 (2.72%) Dynamics CRM
2 4 (2.17%) SAP IS-U
3 2 (1.09%) Hyperion Planning
3 2 (1.09%) Remedy ITSM
3 2 (1.09%) SAP BPC
4 1 (0.54%) Cognos Business Intelligence
4 1 (0.54%) Cognos TM1
4 1 (0.54%) Dynamics NAV
4 1 (0.54%) Lawson
4 1 (0.54%) NetSuite
4 1 (0.54%) SAP Business One
Cloud Services
1 87 (47.28%) Power Platform
2 56 (30.43%) Azure
3 19 (10.33%) AWS
4 8 (4.35%) Azure Data Factory
5 7 (3.80%) SaaS
6 5 (2.72%) Power Automate
6 5 (2.72%) PowerApps
7 4 (2.17%) Azure Machine Learning
7 4 (2.17%) Dynamics 365
7 4 (2.17%) GCP
8 2 (1.09%) Cloud Computing
9 1 (0.54%) Amazon EMR
9 1 (0.54%) Amazon S3
9 1 (0.54%) IaaS
9 1 (0.54%) PaaS
9 1 (0.54%) Serverless
9 1 (0.54%) WhatsApp
Communications & Networking
1 1 (0.54%) Internet
Database & Business Intelligence
1 129 (70.11%) SQL Server
2 105 (57.07%) Data Warehouse
3 102 (55.43%) SQL Server Integration Services
4 90 (48.91%) SQL Server Analysis Services
5 87 (47.28%) Power BI
6 83 (45.11%) SQL Server Reporting Services
7 57 (30.98%) OLTP
8 39 (21.20%) Relational Database
9 34 (18.48%) Oracle OLAP
9 34 (18.48%) RDBMS
10 31 (16.85%) OLAP Cube
11 28 (15.22%) NoSQL
12 27 (14.67%) SQL Server 2016
13 22 (11.96%) Azure SQL Data Warehouse
13 22 (11.96%) Snowflake Schema
14 20 (10.87%) Microsoft Analysis Services
15 19 (10.33%) MongoDB
16 17 (9.24%) Apache Cassandra
17 16 (8.70%) Big Data
17 16 (8.70%) Data Lake
Development Applications
1 18 (9.78%) ERwin
2 14 (7.61%) PowerDesigner
3 9 (4.89%) Git (software)
4 8 (4.35%) SQL Server Management Studio (SSMS)
5 6 (3.26%) Jenkins
5 6 (3.26%) Visual Studio
6 5 (2.72%) JIRA
6 5 (2.72%) Liquibase
7 4 (2.17%) Flyway
7 4 (2.17%) Octopus Deploy
7 4 (2.17%) Team Foundation Server
7 4 (2.17%) TeamCity
8 1 (0.54%) GitLab
General
1 56 (30.43%) Finance
2 11 (5.98%) Marketing
3 5 (2.72%) Manufacturing
3 5 (2.72%) Retail
3 5 (2.72%) Telecoms
4 4 (2.17%) Electronics
4 4 (2.17%) Public Sector
5 3 (1.63%) Law
6 2 (1.09%) Back Office
6 2 (1.09%) Banking
6 2 (1.09%) Investment Banking
6 2 (1.09%) Legal
6 2 (1.09%) Police
7 1 (0.54%) Games
Job Titles
1 90 (48.91%) Developer
2 65 (35.33%) Business Intelligence Developer
3 32 (17.39%) SQL Developer
4 27 (14.67%) Data Warehouse Developer
5 24 (13.04%) Data Engineer
5 24 (13.04%) SSAS Developer
6 23 (12.50%) SQL BI Developer
6 23 (12.50%) SSIS Developer
7 22 (11.96%) Architect
8 20 (10.87%) Azure Developer
8 20 (10.87%) Data Architect
8 20 (10.87%) OLAP Developer
9 19 (10.33%) SQL Server Developer
10 15 (8.15%) Analyst
10 15 (8.15%) DBA
10 15 (8.15%) ETL Developer
11 14 (7.61%) Excel Developer
11 14 (7.61%) Microsoft BI Developer
11 14 (7.61%) SQL DBA
11 14 (7.61%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 26 (14.13%) JSON
1 26 (14.13%) XML
2 20 (10.87%) MDX
3 15 (8.15%) Kafka
4 14 (7.61%) .NET
4 14 (7.61%) REST
4 14 (7.61%) SOAP
5 12 (6.52%) FIX Protocol
6 9 (4.89%) AngularJS
6 9 (4.89%) React
7 8 (4.35%) ASP.NET
7 8 (4.35%) CSS
7 8 (4.35%) HTML
8 7 (3.80%) D3.js
9 5 (2.72%) Apache NiFi
9 5 (2.72%) J2EE
9 5 (2.72%) JSP
9 5 (2.72%) Servlets
10 4 (2.17%) RESTful
11 2 (1.09%) Scilab
Miscellaneous
1 75 (40.76%) Analytical Skills
2 23 (12.50%) Management Information System
3 21 (11.41%) Greenfield Project
4 13 (7.07%) Data Structures
5 12 (6.52%) Reference Data
6 9 (4.89%) Foreign Exchange (FX)
7 8 (4.35%) Hedge funds
8 6 (3.26%) Algorithms
9 5 (2.72%) Equities
10 3 (1.63%) Self-Motivation
11 2 (1.09%) CMDB
11 2 (1.09%) Linux Command Line
11 2 (1.09%) User Experience
11 2 (1.09%) Virtual Team
12 1 (0.54%) AS400
12 1 (0.54%) Enterprise Software
12 1 (0.54%) Hybrid Cloud
12 1 (0.54%) Internet of Things
12 1 (0.54%) Replication
12 1 (0.54%) Taxonomies
Operating Systems
1 2 (1.09%) Linux
1 2 (1.09%) Unix
Processes & Methodologies
1 129 (70.11%) Business Intelligence
2 102 (55.43%) ETL
3 82 (44.57%) Analytics
4 69 (37.50%) Data Modelling
5 57 (30.98%) Agile Software Development
6 42 (22.83%) Visualisation
7 40 (21.74%) Data Management
7 40 (21.74%) Problem-Solving
8 31 (16.85%) Performance Tuning
9 30 (16.30%) Data Visualisation
10 29 (15.76%) Data Analytics
11 28 (15.22%) Data Analysis
12 27 (14.67%) Artificial Intelligence
12 27 (14.67%) DevOps
13 25 (13.59%) Data Architecture
13 25 (13.59%) Software Engineering
14 24 (13.04%) Computer Science
15 22 (11.96%) Machine Learning
16 21 (11.41%) Data Governance
17 20 (10.87%) Migration
Programming Languages
1 119 (64.67%) SQL
2 47 (25.54%) T-SQL
3 41 (22.28%) Python
4 32 (17.39%) C#
5 31 (16.85%) Java
6 11 (5.98%) PowerShell
6 11 (5.98%) Scala
7 9 (4.89%) Data Analysis Expressions (DAX)
7 9 (4.89%) JavaScript
8 8 (4.35%) C++
9 7 (3.80%) R
10 5 (2.72%) ABAP
10 5 (2.72%) Go
11 3 (1.63%) PL/SQL
12 2 (1.09%) Bash Shell
12 2 (1.09%) Perl
12 2 (1.09%) Shell Script
13 1 (0.54%) PHP
13 1 (0.54%) Ruby
Qualifications
1 35 (19.02%) Degree
2 15 (8.15%) Computer Science Degree
3 12 (6.52%) AWS Certification
3 12 (6.52%) Master's Degree
4 3 (1.63%) SC Cleared
4 3 (1.63%) Security Cleared
5 2 (1.09%) DV Cleared
6 1 (0.54%) ACCA
6 1 (0.54%) MBA
6 1 (0.54%) PhD
6 1 (0.54%) PMI Certification
6 1 (0.54%) PMP
Quality Assurance & Compliance
1 17 (9.24%) Data Quality
2 16 (8.70%) QA
3 9 (4.89%) GDPR
4 6 (3.26%) SLA
5 1 (0.54%) PMO
System Software
1 7 (3.80%) Docker
Systems Management
1 5 (2.72%) Terraform
2 2 (1.09%) Kubernetes
3 1 (0.54%) Control-M
3 1 (0.54%) Data Guard
3 1 (0.54%) Opscode Chef
3 1 (0.54%) Oracle RMAN
3 1 (0.54%) Puppet
Vendors
1 83 (45.11%) Microsoft
2 46 (25.00%) Tableau
3 34 (18.48%) Oracle
4 17 (9.24%) Cognos
5 16 (8.70%) SAP
6 13 (7.07%) IBM
7 7 (3.80%) Databricks
8 6 (3.26%) MicroStrategy
9 5 (2.72%) SnapLogic
10 4 (2.17%) Google
11 3 (1.63%) Birst
11 3 (1.63%) Infor
11 3 (1.63%) Sybase
12 2 (1.09%) Anaplan
12 2 (1.09%) BMC
12 2 (1.09%) Hyperion
12 2 (1.09%) PeopleSoft
12 2 (1.09%) Remedy
12 2 (1.09%) Teradata
12 2 (1.09%) Vertica