Period
to 22 October 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 22 October 2020 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK
6 months to
22 Oct 2020
Same period 2019 Same period 2018
Rank 567 757 788
Rank change year-on-year +190 +31 -137
Permanent jobs citing OLAP 121 313 407
As % of all permanent jobs advertised in the UK 0.25% 0.23% 0.25%
As % of the Database & Business Intelligence category 0.87% 0.84% 0.83%
Number of salaries quoted 93 248 325
Median annual salary £57,500 £60,000 £55,000
Median salary % change year-on-year -4.17% +9.09% +10.00%
10th Percentile £31,250 £34,775 £36,250
90th Percentile £82,500 £95,000 £77,500
UK excluding London median annual salary £50,500 £47,250 £45,000
% change year-on-year +6.88% +5.00% +1.19%

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 13,943 37,169 48,866
As % of all permanent IT jobs advertised in the UK 28.47% 27.17% 29.65%
Number of salaries quoted 11,750 30,536 39,873
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +4.17%
10th Percentile £33,750 £31,250 £31,250
90th Percentile £88,750 £86,250 £82,500
UK excluding London median annual salary £48,000 £45,000 £45,000
% change year-on-year +6.67% - +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 22 October 2020.

Salary histogram for OLAP in the UK

OLAP
Top 15 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 22 October 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 +220 118 £57,500 -4.17% 13
London +117 64 £72,500 +11.54% 4
UK excluding London +295 56 £50,500 +6.88% 9
South East +226 19 £50,000 -2.44% 2
Midlands +115 13 £57,500 +35.29% 5
North of England +171 11 £56,250 +32.35% 2
Work from Home +23 9 £47,500 -13.64%
South West +121 8 £50,000 -35.48%
West Midlands +95 7 £57,500 +55.20% 4
Yorkshire +129 6 £57,500 +21.05%
East Midlands +88 6 £52,500 +5.00% 1
East of England +127 3 £57,500 +15.00%
North West +118 3 £42,500 - 2
Scotland +80 2 - -
North East - 2 £38,750 -

For the 6 months to 22 October 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 90 (74.38%) Business Intelligence
2 87 (71.90%) SQL
3 78 (64.46%) SQL Server Reporting Services
4 74 (61.16%) SQL Server
5 73 (60.33%) Data Warehouse
5 73 (60.33%) ETL
6 71 (58.68%) SQL Server Integration Services
7 62 (51.24%) Power BI
7 62 (51.24%) Power Platform
8 54 (44.63%) Analytics
9 49 (40.50%) Azure
9 49 (40.50%) Data Modelling
10 44 (36.36%) SQL Server Analysis Services
11 39 (32.23%) OLTP
12 37 (30.58%) Microsoft
13 34 (28.10%) Microsoft Excel
14 33 (27.27%) Finance
15 31 (25.62%) Analytical Skills
16 30 (24.79%) Problem-Solving
16 30 (24.79%) Visualisation
17 29 (23.97%) Azure SQL Data Warehouse
18 28 (23.14%) T-SQL
19 27 (22.31%) Agile Software Development
20 25 (20.66%) Data Analysis
20 25 (20.66%) Data Architecture
21 22 (18.18%) OLAP Cube
21 22 (18.18%) Data Analytics
22 21 (17.36%) Performance Tuning
22 21 (17.36%) Data Lake
22 21 (17.36%) XML

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 4 (3.31%) Apache Spark
2 3 (2.48%) SharePoint
3 1 (0.83%) Apache
3 1 (0.83%) Apache Pig
3 1 (0.83%) Apache Synapse
3 1 (0.83%) CMS
3 1 (0.83%) Jupyter
Applications
1 34 (28.10%) Microsoft Excel
2 2 (1.65%) MS Visio
2 2 (1.65%) S-PLUS
Business Applications
1 8 (6.61%) Dynamics CRM
2 5 (4.13%) SAP IS-U
3 1 (0.83%) Remedy ITSM
Cloud Services
1 62 (51.24%) Power Platform
2 49 (40.50%) Azure
3 10 (8.26%) AWS
4 3 (2.48%) Azure Data Factory
4 3 (2.48%) GCP
4 3 (2.48%) Google Play
4 3 (2.48%) SaaS
5 2 (1.65%) Amazon EMR
5 2 (1.65%) Azure Machine Learning
5 2 (1.65%) IaaS
5 2 (1.65%) PaaS
5 2 (1.65%) Power Automate
5 2 (1.65%) PowerApps
6 1 (0.83%) Amazon S3
6 1 (0.83%) Azure Functions
6 1 (0.83%) Cloud Computing
6 1 (0.83%) Data Lake Analytics
6 1 (0.83%) Logic Apps
6 1 (0.83%) Serverless
6 1 (0.83%) WhatsApp
Communications & Networking
1 2 (1.65%) HTTP
1 2 (1.65%) LAN
1 2 (1.65%) WAN
2 1 (0.83%) Internet
Database & Business Intelligence
1 78 (64.46%) SQL Server Reporting Services
2 74 (61.16%) SQL Server
3 73 (60.33%) Data Warehouse
4 71 (58.68%) SQL Server Integration Services
5 62 (51.24%) Power BI
6 44 (36.36%) SQL Server Analysis Services
7 39 (32.23%) OLTP
8 29 (23.97%) Azure SQL Data Warehouse
9 22 (18.18%) OLAP Cube
10 21 (17.36%) Data Lake
11 19 (15.70%) Oracle OLAP
11 19 (15.70%) Tableau
12 18 (14.88%) Big Data
13 15 (12.40%) Relational Database
14 14 (11.57%) Data Mining
15 10 (8.26%) RDBMS
16 9 (7.44%) NoSQL
17 8 (6.61%) Azure SQL Database
18 7 (5.79%) Hadoop
18 7 (5.79%) Star Schema
Development Applications
1 12 (9.92%) ERwin
2 10 (8.26%) Git (software)
3 7 (5.79%) Visual Studio
4 6 (4.96%) PowerDesigner
5 5 (4.13%) JIRA
6 4 (3.31%) Jenkins
7 2 (1.65%) ER Studio
7 2 (1.65%) Gradle
7 2 (1.65%) Visual Studio Code
8 1 (0.83%) GitLab
8 1 (0.83%) Octopus Deploy
8 1 (0.83%) SQL Server Management Studio (SSMS)
8 1 (0.83%) TeamCity
8 1 (0.83%) Visual Studio Team System
General
1 33 (27.27%) Finance
2 14 (11.57%) Retail
3 9 (7.44%) Marketing
4 5 (4.13%) Manufacturing
4 5 (4.13%) Telecoms
5 4 (3.31%) Electronics
5 4 (3.31%) Public Sector
6 3 (2.48%) Law
6 3 (2.48%) Legal
7 1 (0.83%) Back Office
7 1 (0.83%) Banking
7 1 (0.83%) Dutch Language
7 1 (0.83%) French Language
7 1 (0.83%) German Language
7 1 (0.83%) Italian Language
7 1 (0.83%) Pharmaceutical
7 1 (0.83%) Police
7 1 (0.83%) Spanish Language
Job Titles
1 59 (48.76%) Developer
2 50 (41.32%) Business Intelligence Developer
3 26 (21.49%) Azure Developer
4 23 (19.01%) SQL Developer
5 22 (18.18%) SQL BI Developer
6 19 (15.70%) OLAP Developer
6 19 (15.70%) SSAS Developer
7 18 (14.88%) SSIS Developer
8 16 (13.22%) Architect
8 16 (13.22%) ETL Developer
8 16 (13.22%) Excel Developer
8 16 (13.22%) Microsoft BI Developer
8 16 (13.22%) SQL Server BI Developer
8 16 (13.22%) SQL Server Developer
9 15 (12.40%) Data Architect
9 15 (12.40%) Data Warehouse Developer
10 14 (11.57%) Business Developer
10 14 (11.57%) Senior Developer
10 14 (11.57%) SQL Server Data Warehouse Developer
11 13 (10.74%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 21 (17.36%) XML
2 20 (16.53%) JSON
3 16 (13.22%) REST
3 16 (13.22%) SOAP
4 9 (7.44%) .NET
5 6 (4.96%) ASP.NET
5 6 (4.96%) MDX
5 6 (4.96%) Web Services
6 5 (4.13%) AngularJS
6 5 (4.13%) CSS
6 5 (4.13%) HTML
6 5 (4.13%) Kafka
6 5 (4.13%) React
7 4 (3.31%) FIX Protocol
8 3 (2.48%) Spring
9 2 (1.65%) D3.js
9 2 (1.65%) Natural Language Processing
9 2 (1.65%) Scilab
10 1 (0.83%) Matplotlib
10 1 (0.83%) Node.js
Miscellaneous
1 31 (25.62%) Analytical Skills
2 17 (14.05%) Management Information System
3 7 (5.79%) Replication
4 5 (4.13%) Equities
4 5 (4.13%) Hedge funds
5 4 (3.31%) Data Structures
5 4 (3.31%) Foreign Exchange (FX)
5 4 (3.31%) Reference Data
6 3 (2.48%) EPoS
6 3 (2.48%) Smart Meter
6 3 (2.48%) User Experience
7 2 (1.65%) Hybrid Cloud
7 2 (1.65%) Linux Command Line
7 2 (1.65%) Virtual Team
8 1 (0.83%) Algorithms
8 1 (0.83%) CMDB
8 1 (0.83%) Greenfield Project
8 1 (0.83%) Internet of Things
8 1 (0.83%) Public Cloud
8 1 (0.83%) Taxonomies
Operating Systems
1 2 (1.65%) Linux
1 2 (1.65%) Unix
Processes & Methodologies
1 90 (74.38%) Business Intelligence
2 73 (60.33%) ETL
3 54 (44.63%) Analytics
4 49 (40.50%) Data Modelling
5 30 (24.79%) Problem-Solving
5 30 (24.79%) Visualisation
6 27 (22.31%) Agile Software Development
7 25 (20.66%) Data Analysis
7 25 (20.66%) Data Architecture
8 22 (18.18%) Data Analytics
9 21 (17.36%) Performance Tuning
10 19 (15.70%) Data Visualisation
11 16 (13.22%) Artificial Intelligence
11 16 (13.22%) Dashboard Development
11 16 (13.22%) Data Governance
12 15 (12.40%) Data Science
12 15 (12.40%) Decision-Making
13 14 (11.57%) Mathematics
14 13 (10.74%) Migration
15 12 (9.92%) Software Engineering
Programming Languages
1 87 (71.90%) SQL
2 28 (23.14%) T-SQL
3 19 (15.70%) Python
4 11 (9.09%) C#
4 11 (9.09%) Java
5 8 (6.61%) Data Analysis Expressions (DAX)
5 8 (6.61%) PowerShell
6 6 (4.96%) JavaScript
7 3 (2.48%) PL/SQL
7 3 (2.48%) R
8 2 (1.65%) Bash Shell
8 2 (1.65%) Java 8
8 2 (1.65%) Perl
8 2 (1.65%) Shell Script
9 1 (0.83%) ABAP
9 1 (0.83%) C++
9 1 (0.83%) VBA
Qualifications
1 18 (14.88%) Degree
2 4 (3.31%) AWS Certification
2 4 (3.31%) Computer Science Degree
2 4 (3.31%) Master's Degree
3 3 (2.48%) SC Cleared
3 3 (2.48%) Security Cleared
4 2 (1.65%) DV Cleared
5 1 (0.83%) Microsoft Certification
Quality Assurance & Compliance
1 12 (9.92%) Data Quality
2 9 (7.44%) SLA
3 4 (3.31%) GDPR
3 4 (3.31%) QA
4 1 (0.83%) PMO
System Software
1 3 (2.48%) Docker
2 1 (0.83%) Active Directory
Systems Management
1 4 (3.31%) Data Guard
1 4 (3.31%) Oracle RMAN
2 3 (2.48%) Kubernetes
3 2 (1.65%) Ansible
4 1 (0.83%) Control-M
4 1 (0.83%) Opscode Chef
4 1 (0.83%) Puppet
Vendors
1 37 (30.58%) Microsoft
2 19 (15.70%) Oracle
3 13 (10.74%) Databricks
4 11 (9.09%) IBM
5 10 (8.26%) SAP
6 8 (6.61%) Cognos
7 4 (3.31%) Google
8 2 (1.65%) Greenplum
8 2 (1.65%) MicroStrategy
8 2 (1.65%) RedGate
8 2 (1.65%) Sybase
9 1 (0.83%) BMC
9 1 (0.83%) Informatica
9 1 (0.83%) MuleSoft
9 1 (0.83%) Remedy
9 1 (0.83%) Snapchat
9 1 (0.83%) Teradata