Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 25 October 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 25 October 2021 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK
6 months to
25 Oct 2021		 Same period 2020 Same period 2019
Rank 795 568 777
Rank change year-on-year -227 +209 +9
Permanent jobs citing OLAP 257 120 308
As % of all permanent jobs advertised in the UK 0.20% 0.25% 0.23%
As % of the Database & Business Intelligence category 0.73% 0.86% 0.83%
Number of salaries quoted 201 90 240
10th Percentile £39,387 £31,250 £34,195
25th Percentile £41,250 £45,313 £42,500
Median annual salary (50th Percentile) £50,000 £57,500 £60,000
Median % change year-on-year -13.04% -4.17% +9.09%
75th Percentile £67,500 £74,688 £72,500
90th Percentile £80,000 £101,250 £95,000
UK excluding London median annual salary £45,000 £51,750 £46,000
% change year-on-year -13.04% +12.50% +2.22%

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 35,185 14,024 37,154
As % of all permanent IT jobs advertised in the UK 27.85% 28.69% 27.27%
Number of salaries quoted 22,520 11,928 30,811
10th Percentile £35,000 £33,750 £31,250
25th Percentile £42,500 £42,000 £38,250
Median annual salary (50th Percentile) £57,500 £55,000 £52,500
Median % change year-on-year +4.55% +4.76% +5.00%
75th Percentile £77,500 £72,500 £70,000
90th Percentile £95,000 £88,750 £86,250
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

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 25 October 2021.

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 25 October 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 -197 253 £50,000 -13.04% 43
UK excluding London -127 166 £45,000 -13.04% 18
Work from Home -188 89 £45,000 -5.26% 10
London -240 82 £65,000 -10.34% 26
South East -130 49 £60,000 +20.00% 4
North of England -94 48 £45,000 -18.18% 3
Midlands -97 31 £47,500 -17.39% 4
South West -76 30 £42,000 -16.00% 4
Yorkshire -81 21 £45,000 -21.74%
North West -79 20 £45,000 +5.88% 2
West Midlands -95 16 £45,000 -21.74% 2
East Midlands -72 15 £47,500 -9.52% 2
East of England -103 8 £60,000 +4.35% 1
North East -29 7 £45,000 +16.13% 1
Scotland -84 3 £42,500 - 2

For the 6 months to 25 October 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 198 (77.04%) Business Intelligence
2 197 (76.65%) SQL
3 159 (61.87%) Data Warehouse
4 138 (53.70%) ETL
5 136 (52.92%) Power BI
5 136 (52.92%) Power Platform
6 134 (52.14%) Microsoft
7 131 (50.97%) SQL Server
8 126 (49.03%) SQL Server Reporting Services
9 121 (47.08%) SQL Server Integration Services
10 117 (45.53%) Azure
11 91 (35.41%) Problem-Solving
12 87 (33.85%) Analytics
13 76 (29.57%) SQL Server Analysis Services
14 75 (29.18%) Data Modelling
15 66 (25.68%) Python
16 63 (24.51%) OLTP
17 61 (23.74%) MDX
18 59 (22.96%) Oracle OLAP
18 59 (22.96%) Agile Software Development
18 59 (22.96%) Oracle
19 58 (22.57%) Data Lake
20 57 (22.18%) AWS
21 54 (21.01%) Social Skills
22 53 (20.62%) Data Analysis Expressions (DAX)
23 52 (20.23%) Finance
24 50 (19.46%) C#
25 47 (18.29%) T-SQL
26 46 (17.90%) Data Architecture
27 45 (17.51%) Visualisation

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 12 (4.67%) Apache Spark
2 7 (2.72%) Apache
2 7 (2.72%) Apache Synapse
3 3 (1.17%) Oracle 9iAS
3 3 (1.17%) Oracle Application Server
4 2 (0.78%) Oracle Workflow
4 2 (0.78%) SAS
4 2 (0.78%) SharePoint
5 1 (0.39%) Apache Airflow
Applications
1 15 (5.84%) Microsoft Excel
2 5 (1.95%) Microsoft Office
3 4 (1.56%) Spreadsheet
3 4 (1.56%) SPSS
Business Applications
1 11 (4.28%) Dynamics AX
2 5 (1.95%) IBM Planning Analytics
3 4 (1.56%) NetSuite
3 4 (1.56%) Unit4 Business World
4 3 (1.17%) Cognos Business Intelligence
4 3 (1.17%) Oracle 11i
4 3 (1.17%) Oracle Applications
4 3 (1.17%) Oracle EBS
5 2 (0.78%) Hyperion Planning
6 1 (0.39%) ResourceLink
6 1 (0.39%) Sage 200
6 1 (0.39%) Sage X3
6 1 (0.39%) SAP Oil and Gas
6 1 (0.39%) SAP S/4HANA
Cloud Services
1 136 (52.92%) Power Platform
2 117 (45.53%) Azure
3 57 (22.18%) AWS
4 31 (12.06%) GCP
5 30 (11.67%) Azure Data Factory
6 23 (8.95%) Azure Synapse Analytics
7 16 (6.23%) PaaS
8 15 (5.84%) IaaS
9 11 (4.28%) Dynamics 365
10 7 (2.72%) Azure Logic Apps
10 7 (2.72%) PowerApps
11 5 (1.95%) Serverless
11 5 (1.95%) Snowflake
12 4 (1.56%) Azure Cosmos DB
13 3 (1.17%) Azure Stack
13 3 (1.17%) Matillion
13 3 (1.17%) Microsoft 365
13 3 (1.17%) SaaS
14 2 (0.78%) GitHub
15 1 (0.39%) Amazon S3
Communications & Networking
1 8 (3.11%) LAN
1 8 (3.11%) WAN
2 2 (0.78%) Firewall
2 2 (0.78%) HTTP
3 1 (0.39%) HTTPS
Database & Business Intelligence
1 159 (61.87%) Data Warehouse
2 136 (52.92%) Power BI
3 131 (50.97%) SQL Server
4 126 (49.03%) SQL Server Reporting Services
5 121 (47.08%) SQL Server Integration Services
6 76 (29.57%) SQL Server Analysis Services
7 63 (24.51%) OLTP
8 59 (22.96%) Oracle OLAP
9 58 (22.57%) Data Lake
10 44 (17.12%) Big Data
11 42 (16.34%) PostgreSQL
12 38 (14.79%) Tableau
13 37 (14.40%) Relational Database
14 27 (10.51%) SQL Server 2016
15 26 (10.12%) Oracle Reports
16 25 (9.73%) Azure SQL Database
16 25 (9.73%) RDBMS
16 25 (9.73%) SSDT
17 24 (9.34%) Microsoft Analysis Services
18 22 (8.56%) MySQL
Development Applications
1 38 (14.79%) Visual Studio
2 33 (12.84%) Git (software)
3 25 (9.73%) VSS/SourceSafe
4 10 (3.89%) MorphX
5 4 (1.56%) Visual Studio Code
6 3 (1.17%) JIRA
6 3 (1.17%) Oracle Forms
6 3 (1.17%) SQL Server Management Studio (SSMS)
6 3 (1.17%) Team Foundation Server
7 2 (0.78%) Visual Studio Team System
8 1 (0.39%) Cucumber
8 1 (0.39%) ER Studio
8 1 (0.39%) Selenium
General
1 54 (21.01%) Social Skills
2 52 (20.23%) Finance
3 44 (17.12%) Analytical Skills
4 12 (4.67%) Banking
5 10 (3.89%) Law
6 9 (3.50%) Presentation Skills
7 7 (2.72%) Electronics
7 7 (2.72%) Retail
8 6 (2.33%) Marketing
9 5 (1.95%) Advertising
9 5 (1.95%) Public Sector
10 4 (1.56%) Games
10 4 (1.56%) Investment Banking
10 4 (1.56%) Legal
11 3 (1.17%) Inclusion and Diversity
12 2 (0.78%) Organisational Skills
12 2 (0.78%) Pharmaceutical
12 2 (0.78%) Private Banking
12 2 (0.78%) Publishing
13 1 (0.39%) General Ledger
Job Titles
1 128 (49.81%) Developer
2 59 (22.96%) Business Intelligence Developer
3 53 (20.62%) Data Engineer
4 41 (15.95%) Senior Developer
5 23 (8.95%) Architect
6 17 (6.61%) SSIS Developer
7 16 (6.23%) DBA
8 14 (5.45%) Data Architect
9 13 (5.06%) SQL Developer
10 11 (4.28%) Azure Engineer
10 11 (4.28%) Backend Developer
10 11 (4.28%) Data Warehouse Developer
11 10 (3.89%) Analyst
11 10 (3.89%) Business Developer
11 10 (3.89%) Business Intelligence Lead
11 10 (3.89%) SQL DBA
12 9 (3.50%) Lead Developer
12 9 (3.50%) Python Engineer
12 9 (3.50%) SQL BI Developer
12 9 (3.50%) SSRS Developer
Libraries, Frameworks & Software Standards
1 61 (23.74%) MDX
2 32 (12.45%) .NET
3 20 (7.78%) HTML
4 17 (6.61%) .NET Core
4 17 (6.61%) HTML5
4 17 (6.61%) XML
5 13 (5.06%) Web Services
6 11 (4.28%) PostGIS
7 6 (2.33%) JSON
7 6 (2.33%) Velocity
8 4 (1.56%) .NET Framework
8 4 (1.56%) Middleware
8 4 (1.56%) REST
8 4 (1.56%) RESTful
9 3 (1.17%) Oracle Fusion
10 2 (0.78%) AngularJS
10 2 (0.78%) ASP.NET
10 2 (0.78%) Keras
10 2 (0.78%) scikit-learn
10 2 (0.78%) TensorFlow
Miscellaneous
1 25 (9.73%) Data Protection Act
2 24 (9.34%) User Experience
3 19 (7.39%) Management Information System
4 17 (6.61%) Cloud Native
5 12 (4.67%) Data Structures
6 11 (4.28%) Mobile App
7 10 (3.89%) Legacy Systems
8 8 (3.11%) Video\Live Streaming
9 7 (2.72%) Blog
9 7 (2.72%) Tandem
10 4 (1.56%) Foreign Exchange (FX)
10 4 (1.56%) Online Games
10 4 (1.56%) Replication
11 3 (1.17%) Greenfield Project
11 3 (1.17%) N-Tier
12 2 (0.78%) Algorithms
12 2 (0.78%) Credit Risk
12 2 (0.78%) FMCG
12 2 (0.78%) Reinsurance
12 2 (0.78%) Social Network
Operating Systems
1 6 (2.33%) Linux
2 3 (1.17%) Solaris
2 3 (1.17%) Unix
3 2 (0.78%) Windows
3 2 (0.78%) Windows Server
4 1 (0.39%) Android
4 1 (0.39%) Apple iOS
Processes & Methodologies
1 198 (77.04%) Business Intelligence
2 138 (53.70%) ETL
3 91 (35.41%) Problem-Solving
4 87 (33.85%) Analytics
5 75 (29.18%) Data Modelling
6 59 (22.96%) Agile Software Development
7 46 (17.90%) Data Architecture
8 45 (17.51%) Visualisation
9 44 (17.12%) Data Management
10 40 (15.56%) DevOps
11 35 (13.62%) Data Analysis
12 30 (11.67%) Data Engineering
13 29 (11.28%) Data Protection
13 29 (11.28%) Data Visualisation
14 28 (10.89%) Migration
15 26 (10.12%) Data Extraction
15 26 (10.12%) Kimball Methodology
16 25 (9.73%) Artificial Intelligence
16 25 (9.73%) Data Governance
17 24 (9.34%) Commercial Awareness
Programming Languages
1 197 (76.65%) SQL
2 66 (25.68%) Python
3 53 (20.62%) Data Analysis Expressions (DAX)
4 50 (19.46%) C#
5 47 (18.29%) T-SQL
6 29 (11.28%) R
7 24 (9.34%) Java
8 14 (5.45%) X++
9 11 (4.28%) Go
10 10 (3.89%) ActionScript
10 10 (3.89%) ActionScript 2.0
10 10 (3.89%) PowerShell
11 6 (2.33%) JavaScript
11 6 (2.33%) PL/SQL
12 5 (1.95%) Shell Script
13 4 (1.56%) C++
13 4 (1.56%) VB.NET
14 2 (0.78%) C
14 2 (0.78%) PHP
15 1 (0.39%) Perl
Qualifications
1 9 (3.50%) Degree
2 7 (2.72%) Security Cleared
3 5 (1.95%) SC Cleared
4 3 (1.17%) ISEB
5 2 (0.78%) DV Cleared
5 2 (0.78%) ITIL Certification
5 2 (0.78%) PMP
6 1 (0.39%) ISTQB
6 1 (0.39%) ISTQB Foundation Certification
6 1 (0.39%) PMI Certification
6 1 (0.39%) TOGAF Certification
Quality Assurance & Compliance
1 35 (13.62%) GDPR
2 20 (7.78%) Data Quality
3 11 (4.28%) SLA
4 8 (3.11%) QA
5 4 (1.56%) PCI DSS
5 4 (1.56%) SOC 2
6 3 (1.17%) PMO
System Software
1 18 (7.00%) Docker
2 3 (1.17%) Oracle RAC
3 2 (0.78%) HDFS
4 1 (0.39%) Active Directory
Systems Management
1 18 (7.00%) Kubernetes
2 3 (1.17%) Data Guard
3 2 (0.78%) Terraform
4 1 (0.39%) Control-M
4 1 (0.39%) Failover Clustering
Vendors
1 134 (52.14%) Microsoft
2 59 (22.96%) Oracle
3 26 (10.12%) Databricks
4 12 (4.67%) IBM
5 11 (4.28%) SAP
6 10 (3.89%) RedGate
7 8 (3.11%) Cognos
7 8 (3.11%) Informatica
8 7 (2.72%) NVIDIA
9 6 (2.33%) Talend
10 5 (1.95%) Hyperion
10 5 (1.95%) Salesforce.com
11 4 (1.56%) Alteryx
11 4 (1.56%) Remedy
12 3 (1.17%) JD Edwards
12 3 (1.17%) Red Hat
12 3 (1.17%) Saba
13 2 (0.78%) TARGIT
14 1 (0.39%) Anaplan
14 1 (0.39%) Birst
50 OLAP job vacancies Nationwide