Period
to 17 April 2021

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 17 April 2021 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK
6 months to
17 Apr 2021
Same period 2020 Same period 2019
Rank 771 716 753
Rank change year-on-year -55 +37 -51
Permanent jobs citing OLAP 92 254 369
As % of all permanent jobs advertised in the UK 0.11% 0.23% 0.25%
As % of the Database & Business Intelligence category 0.41% 0.85% 0.87%
Number of salaries quoted 62 220 305
10th Percentile £37,500 £36,250 £37,050
25th Percentile £48,125 £40,000 £42,000
Median annual salary (50th Percentile) £55,000 £51,500 £52,500
Median % change year-on-year +6.80% -1.90% +5.00%
75th Percentile £63,359 £76,250 £63,750
90th Percentile £68,375 £115,000 £80,000
UK excluding London median annual salary £52,500 £47,500 £47,500
% change year-on-year +10.53% - +5.56%

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 22,242 29,947 42,222
As % of all permanent IT jobs advertised in the UK 26.43% 26.95% 28.40%
Number of salaries quoted 17,916 24,714 34,903
10th Percentile £33,750 £32,500 £31,250
25th Percentile £41,250 £40,000 £37,500
Median annual salary (50th Percentile) £55,000 £52,500 £52,500
Median % change year-on-year +4.76% - +5.00%
75th Percentile £73,750 £72,500 £70,000
90th Percentile £88,750 £88,750 £85,000
UK excluding London median annual salary £48,500 £45,000 £45,000
% change year-on-year +7.78% - +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 17 April 2021.

Salary histogram for OLAP in the UK

OLAP
Top 16 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 17 April 2021. 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 -20 77 £55,000 +5.77% 30
UK excluding London +34 51 £52,500 +10.53% 23
London +26 35 £60,282 -3.55% 9
Midlands +35 15 £52,500 +2.94% 7
North of England +36 13 £38,375 -47.07% 8
West Midlands +23 12 £53,750 +5.39% 7
Work from Home -135 12 £60,563 +63.46% 9
South East +70 11 £52,500 +10.53% 3
Yorkshire +2 9 £38,375 -30.23% 4
South West +1 7 £40,000 -15.79% 2
North West +26 3 £55,000 -24.14% 4
Scotland +3 3 - - 2
East Midlands +1 3 £46,000 -8.00%
Northern Ireland -5 1 - -
Wales - 1 - -
North East - 1 £40,000 -

For the 6 months to 17 April 2021, 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 71 (77.17%) SQL
1 71 (77.17%) Business Intelligence
2 62 (67.39%) Power Platform
3 61 (66.30%) Power BI
4 57 (61.96%) SQL Server
5 55 (59.78%) ETL
6 49 (53.26%) Data Warehouse
7 48 (52.17%) SQL Server Integration Services
7 48 (52.17%) Analytical Skills
8 36 (39.13%) SQL Server Reporting Services
9 34 (36.96%) Azure
10 32 (34.78%) Data Modelling
11 31 (33.70%) Finance
12 30 (32.61%) Visualisation
13 29 (31.52%) Microsoft
14 28 (30.43%) Analytics
15 27 (29.35%) Agile Software Development
16 25 (27.17%) Data Analysis
17 24 (26.09%) Problem-Solving
18 22 (23.91%) T-SQL
19 18 (19.57%) ITIL
19 18 (19.57%) SQL Server Analysis Services
20 17 (18.48%) Data Analysis Expressions (DAX)
20 17 (18.48%) Python
20 17 (18.48%) ERP
20 17 (18.48%) OLTP
21 16 (17.39%) Decision-Making
22 15 (16.30%) Business Analysis
22 15 (16.30%) Relational Database
22 15 (16.30%) Data Extraction

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 8 (8.70%) SharePoint
2 4 (4.35%) SharePoint Server
3 2 (2.17%) Apache Spark
4 1 (1.09%) Apache Airflow
4 1 (1.09%) GemFire
Applications
1 11 (11.96%) Microsoft Office
2 8 (8.70%) Microsoft Excel
3 4 (4.35%) InfoPath
4 2 (2.17%) Spreadsheet
Business Applications
1 7 (7.61%) NetSuite
2 6 (6.52%) Remedy ITSM
3 4 (4.35%) Dynamics AX
4 2 (2.17%) Dynamics CRM
4 2 (2.17%) Dynamics NAV
4 2 (2.17%) Infor M3
4 2 (2.17%) SAP Business One
4 2 (2.17%) Sparx Enterprise Architect
5 1 (1.09%) SAP ERP
5 1 (1.09%) SAP IS-U
Cloud Services
1 62 (67.39%) Power Platform
2 34 (36.96%) Azure
3 7 (7.61%) Power Automate
3 7 (7.61%) PowerApps
4 6 (6.52%) Dynamics 365
4 6 (6.52%) Microsoft 365
5 5 (5.43%) GCP
6 4 (4.35%) AWS
6 4 (4.35%) Google Play
7 3 (3.26%) Azure Data Factory
8 2 (2.17%) Azure Stack
8 2 (2.17%) Serverless
9 1 (1.09%) Azure Functions
9 1 (1.09%) Cloud Computing
9 1 (1.09%) SaaS
Database & Business Intelligence
1 61 (66.30%) Power BI
2 57 (61.96%) SQL Server
3 49 (53.26%) Data Warehouse
4 48 (52.17%) SQL Server Integration Services
5 36 (39.13%) SQL Server Reporting Services
6 18 (19.57%) SQL Server Analysis Services
7 17 (18.48%) OLTP
8 15 (16.30%) Relational Database
9 14 (15.22%) Big Data
10 13 (14.13%) Tableau
11 12 (13.04%) OLAP Cube
12 11 (11.96%) Data Mining
12 11 (11.96%) Hadoop
12 11 (11.96%) Microsoft Analysis Services
12 11 (11.96%) MySQL
13 9 (9.78%) Azure SQL Data Warehouse
14 8 (8.70%) Data Lake
14 8 (8.70%) Oracle OLAP
15 7 (7.61%) Crystal Reports
16 6 (6.52%) InterSystems Cache
Development Applications
1 4 (4.35%) JIRA
2 2 (2.17%) ERwin
2 2 (2.17%) Team Foundation Server
3 1 (1.09%) Git (software)
3 1 (1.09%) SQL Server Management Studio (SSMS)
3 1 (1.09%) TeamCity
General
1 31 (33.70%) Finance
2 11 (11.96%) Manufacturing
3 6 (6.52%) Advertising
3 6 (6.52%) Legal
4 5 (5.43%) Retail
5 3 (3.26%) Publishing
6 2 (2.17%) Law
6 2 (2.17%) Marketing
7 1 (1.09%) Aerospace
7 1 (1.09%) Front Office
Job Titles
1 39 (42.39%) Developer
2 26 (28.26%) Business Intelligence Developer
3 24 (26.09%) Analyst
4 14 (15.22%) Business Intelligence Analyst
5 11 (11.96%) Analyst Developer
5 11 (11.96%) Developer Analyst
5 11 (11.96%) Power BI Developer
6 10 (10.87%) Power BI Analyst
7 9 (9.78%) Business Intelligence Lead
7 9 (9.78%) Lead Developer
8 8 (8.70%) Architect
8 8 (8.70%) DBA
9 7 (7.61%) Data Engineer
10 6 (6.52%) Administrator
10 6 (6.52%) Data Warehouse Developer
10 6 (6.52%) Senior DBA
11 5 (5.43%) ITSM Architect
11 5 (5.43%) Technical Architect
12 4 (4.35%) Database Manager
12 4 (4.35%) SharePoint Developer
Libraries, Frameworks & Software Standards
1 7 (7.61%) HTML
2 6 (6.52%) AngularJS
2 6 (6.52%) Hibernate
2 6 (6.52%) Web Services
3 5 (5.43%) .NET
4 4 (4.35%) CSS
4 4 (4.35%) jQuery
5 2 (2.17%) MDX
5 2 (2.17%) XML
6 1 (1.09%) Kafka
6 1 (1.09%) PySpark
6 1 (1.09%) React
6 1 (1.09%) REST
6 1 (1.09%) Serverless Framework
Miscellaneous
1 48 (52.17%) Analytical Skills
2 12 (13.04%) Virtual Team
3 8 (8.70%) NHS
4 6 (6.52%) CMDB
4 6 (6.52%) Replication
5 5 (5.43%) Management Information System
6 4 (4.35%) Data Structures
6 4 (4.35%) FMCG
6 4 (4.35%) Smart Meter
7 1 (1.09%) Client/Server
Operating Systems
1 6 (6.52%) Linux
Processes & Methodologies
1 71 (77.17%) Business Intelligence
2 55 (59.78%) ETL
3 32 (34.78%) Data Modelling
4 30 (32.61%) Visualisation
5 28 (30.43%) Analytics
6 27 (29.35%) Agile Software Development
7 25 (27.17%) Data Analysis
8 24 (26.09%) Problem-Solving
9 18 (19.57%) ITIL
10 17 (18.48%) ERP
11 16 (17.39%) Decision-Making
12 15 (16.30%) Business Analysis
12 15 (16.30%) Data Extraction
13 13 (14.13%) Data Analytics
14 12 (13.04%) Continuous Improvement
14 12 (13.04%) Data Architecture
14 12 (13.04%) Dimensional Modelling
15 11 (11.96%) Sprint Planning
16 10 (10.87%) Dashboard Development
16 10 (10.87%) DevOps
Programming Languages
1 71 (77.17%) SQL
2 22 (23.91%) T-SQL
3 17 (18.48%) Data Analysis Expressions (DAX)
3 17 (18.48%) Python
4 10 (10.87%) Bash Shell
4 10 (10.87%) PL/SQL
5 7 (7.61%) Java
6 6 (6.52%) Perl
6 6 (6.52%) PHP
7 5 (5.43%) JavaScript
7 5 (5.43%) PowerShell
8 4 (4.35%) R
9 1 (1.09%) ABAP
9 1 (1.09%) C
9 1 (1.09%) Java 8
9 1 (1.09%) Scala
9 1 (1.09%) TypeScript
9 1 (1.09%) U-SQL
9 1 (1.09%) VB.NET
9 1 (1.09%) VBA
Qualifications
1 13 (14.13%) Degree
2 8 (8.70%) DBS Check
3 7 (7.61%) Security Cleared
4 6 (6.52%) SC Cleared
5 5 (5.43%) DV Cleared
6 4 (4.35%) Microsoft Certification
Quality Assurance & Compliance
1 3 (3.26%) GDPR
2 2 (2.17%) ISO/IEC 20000
2 2 (2.17%) SLA
3 1 (1.09%) QA
System Software
1 6 (6.52%) HDFS
2 4 (4.35%) Active Directory
3 1 (1.09%) Docker
Systems Management
1 6 (6.52%) Ansible
1 6 (6.52%) Opscode Chef
1 6 (6.52%) Puppet
2 4 (4.35%) Single Sign-On
3 1 (1.09%) Kubernetes
Vendors
1 29 (31.52%) Microsoft
2 11 (11.96%) Google
2 11 (11.96%) SAP
3 9 (9.78%) Salesforce.com
4 8 (8.70%) Oracle
5 7 (7.61%) Databricks
5 7 (7.61%) JD Edwards
6 6 (6.52%) BMC
6 6 (6.52%) Facebook
6 6 (6.52%) Marin
6 6 (6.52%) Remedy
7 5 (5.43%) Cognos
7 5 (5.43%) Infor
8 4 (4.35%) IBM
8 4 (4.35%) Splunk
9 3 (3.26%) Alteryx
9 3 (3.26%) Birst
9 3 (3.26%) IFS
10 2 (2.17%) Capita
10 2 (2.17%) Salesforce Marketing Cloud