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

Online Analytical Processing (OLAP)
UK
6 months to
28 Jan 2021
Same period 2020 Same period 2019
Rank 687 783 780
Rank change year-on-year +96 -3 -92
Permanent jobs citing OLAP 85 249 342
As % of all permanent jobs advertised in the UK 0.13% 0.20% 0.23%
As % of the Database & Business Intelligence category 0.47% 0.73% 0.79%
Number of salaries quoted 72 199 270
Median annual salary £55,000 £52,500 £55,000
Median salary % change year-on-year +4.76% -4.55% +10.00%
10th Percentile £31,250 £35,000 £37,500
90th Percentile £73,750 £101,000 £76,375
UK excluding London median annual salary £52,500 £45,000 £50,000
% change year-on-year +16.67% -10.00% +11.11%

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,905 34,029 43,511
As % of all permanent IT jobs advertised in the UK 27.33% 27.09% 28.80%
Number of salaries quoted 15,005 28,168 36,136
Median annual salary £55,000 £52,500 £52,500
Median salary % change year-on-year +4.76% - +8.25%
10th Percentile £33,750 £32,000 £31,250
90th Percentile £87,500 £88,750 £85,000
UK excluding London median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - +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 28 January 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 28 January 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 +100 76 £53,750 -2.27% 10
UK excluding London +128 45 £52,500 +16.67% 7
London +112 34 £58,000 -10.77% 3
North of England +87 16 £42,500 -20.93% 2
South East +146 13 £52,500 -4.55% 1
Midlands +68 12 £53,750 +19.44% 2
Yorkshire +53 11 £38,375 -30.23%
Work from Home - 7 £47,500 - 2
West Midlands +59 6 £57,500 +55.20% 1
East Midlands +52 6 £52,500 +5.00% 1
North West +68 3 £55,000 +10.00% 2
Scotland +31 2 - -
North East - 2 £42,500 -
East of England +66 1 £57,500 +43.75% 1
South West +61 1 £50,000 +5.26% 1

For the 6 months to 28 January 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 63 (74.12%) SQL
2 60 (70.59%) Business Intelligence
3 54 (63.53%) SQL Server
4 52 (61.18%) SQL Server Reporting Services
5 51 (60.00%) ETL
6 50 (58.82%) SQL Server Integration Services
7 45 (52.94%) Data Warehouse
8 43 (50.59%) Analytical Skills
9 38 (44.71%) Power Platform
10 37 (43.53%) Power BI
11 32 (37.65%) Azure
12 30 (35.29%) Data Modelling
13 24 (28.24%) Microsoft
14 23 (27.06%) Data Analysis
14 23 (27.06%) Analytics
15 22 (25.88%) Visualisation
15 22 (25.88%) Finance
15 22 (25.88%) T-SQL
16 20 (23.53%) Azure SQL Data Warehouse
17 19 (22.35%) OLTP
18 18 (21.18%) ERP
18 18 (21.18%) Problem-Solving
19 17 (20.00%) Decision-Making
19 17 (20.00%) Microsoft Excel
19 17 (20.00%) Data Extraction
20 15 (17.65%) Relational Database
20 15 (17.65%) CRM
21 14 (16.47%) Agile Software Development
21 14 (16.47%) Data Architecture
21 14 (16.47%) Degree

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 5 (5.88%) SharePoint
2 2 (2.35%) Apache Spark
3 1 (1.18%) Apache Airflow
3 1 (1.18%) Apache Pig
3 1 (1.18%) CMS
3 1 (1.18%) Jupyter
Applications
1 17 (20.00%) Microsoft Excel
2 7 (8.24%) Microsoft Office
3 1 (1.18%) MS Visio
Business Applications
1 8 (9.41%) Dynamics CRM
2 4 (4.71%) NetSuite
3 3 (3.53%) Remedy ITSM
3 3 (3.53%) SAP IS-U
4 2 (2.35%) Sparx Enterprise Architect
5 1 (1.18%) Dynamics AX
5 1 (1.18%) Dynamics NAV
5 1 (1.18%) Infor M3
5 1 (1.18%) SAP Business One
Cloud Services
1 38 (44.71%) Power Platform
2 32 (37.65%) Azure
3 8 (9.41%) Power Automate
3 8 (9.41%) PowerApps
4 5 (5.88%) Google Play
5 4 (4.71%) Dynamics 365
6 3 (3.53%) AWS
6 3 (3.53%) GCP
7 2 (2.35%) Azure Data Factory
8 1 (1.18%) Amazon EMR
8 1 (1.18%) Azure Active Directory
8 1 (1.18%) Azure Functions
8 1 (1.18%) Azure Machine Learning
8 1 (1.18%) Cloud Computing
8 1 (1.18%) Data Lake Analytics
8 1 (1.18%) IaaS
8 1 (1.18%) Logic Apps
8 1 (1.18%) PaaS
8 1 (1.18%) Serverless
Communications & Networking
1 2 (2.35%) HTTP
1 2 (2.35%) LAN
1 2 (2.35%) WAN
Database & Business Intelligence
1 54 (63.53%) SQL Server
2 52 (61.18%) SQL Server Reporting Services
3 50 (58.82%) SQL Server Integration Services
4 45 (52.94%) Data Warehouse
5 37 (43.53%) Power BI
6 20 (23.53%) Azure SQL Data Warehouse
7 19 (22.35%) OLTP
8 15 (17.65%) Relational Database
9 14 (16.47%) Data Lake
10 11 (12.94%) Big Data
10 11 (12.94%) Oracle OLAP
11 10 (11.76%) SQL Server Analysis Services
12 9 (10.59%) Data Mining
12 9 (10.59%) MySQL
13 8 (9.41%) OLAP Cube
13 8 (9.41%) PostgreSQL
14 7 (8.24%) Crystal Reports
14 7 (8.24%) Hadoop
15 6 (7.06%) DTS
16 5 (5.88%) HBase
Development Applications
1 6 (7.06%) ERwin
2 5 (5.88%) Git (software)
3 4 (4.71%) Visual Studio
4 3 (3.53%) Jenkins
4 3 (3.53%) JIRA
5 2 (2.35%) ER Studio
5 2 (2.35%) Gradle
5 2 (2.35%) Visual Studio Code
6 1 (1.18%) PowerDesigner
6 1 (1.18%) SQL Server Management Studio (SSMS)
6 1 (1.18%) Team Foundation Server
6 1 (1.18%) TeamCity
6 1 (1.18%) Visual Studio Team System
General
1 22 (25.88%) Finance
2 11 (12.94%) Retail
3 9 (10.59%) Manufacturing
4 5 (5.88%) Legal
5 3 (3.53%) Advertising
6 1 (1.18%) Banking
6 1 (1.18%) Dutch Language
6 1 (1.18%) French Language
6 1 (1.18%) German Language
6 1 (1.18%) Italian Language
6 1 (1.18%) Pharmaceutical
6 1 (1.18%) Spanish Language
Job Titles
1 41 (48.24%) Developer
2 32 (37.65%) Business Intelligence Developer
3 21 (24.71%) Analyst
4 13 (15.29%) DBA
5 11 (12.94%) Analyst Developer
5 11 (12.94%) Business Intelligence Lead
5 11 (12.94%) Developer Analyst
5 11 (12.94%) Lead Developer
5 11 (12.94%) Power BI Developer
6 10 (11.76%) Architect
7 9 (10.59%) Azure Developer
7 9 (10.59%) Business Intelligence Analyst
8 8 (9.41%) Senior Developer
9 7 (8.24%) Data Architect
9 7 (8.24%) Power BI Analyst
9 7 (8.24%) Senior Business Intelligence Developer
10 6 (7.06%) Business Developer
10 6 (7.06%) Data Engineer
11 5 (5.88%) Data Analyst
11 5 (5.88%) Development Manager
Libraries, Frameworks & Software Standards
1 8 (9.41%) Web Services
2 4 (4.71%) REST
2 4 (4.71%) XML
3 3 (3.53%) AngularJS
3 3 (3.53%) Hibernate
3 3 (3.53%) JSON
3 3 (3.53%) SOAP
4 2 (2.35%) .NET
4 2 (2.35%) Spring
5 1 (1.18%) .NET Core
5 1 (1.18%) Anaconda
5 1 (1.18%) Apache Tez
5 1 (1.18%) ASP.NET
5 1 (1.18%) Kafka
5 1 (1.18%) MDX
5 1 (1.18%) Natural Language Processing
5 1 (1.18%) TensorFlow
Miscellaneous
1 43 (50.59%) Analytical Skills
2 9 (10.59%) Replication
3 8 (9.41%) NHS
4 7 (8.24%) Virtual Team
5 5 (5.88%) Management Information System
5 5 (5.88%) Smart Meter
6 3 (3.53%) CMDB
6 3 (3.53%) Data Structures
6 3 (3.53%) EPoS
7 1 (1.18%) Hybrid Cloud
7 1 (1.18%) User Experience
Operating Systems
1 3 (3.53%) Linux
Processes & Methodologies
1 60 (70.59%) Business Intelligence
2 51 (60.00%) ETL
3 30 (35.29%) Data Modelling
4 23 (27.06%) Analytics
4 23 (27.06%) Data Analysis
5 22 (25.88%) Visualisation
6 18 (21.18%) ERP
6 18 (21.18%) Problem-Solving
7 17 (20.00%) Data Extraction
7 17 (20.00%) Decision-Making
8 15 (17.65%) CRM
9 14 (16.47%) Agile Software Development
9 14 (16.47%) Data Architecture
10 13 (15.29%) Stakeholder Management
11 12 (14.12%) Digital Transformation Programme
11 12 (14.12%) ITIL
12 11 (12.94%) Computer Science
13 10 (11.76%) DevOps
13 10 (11.76%) Software Engineering
14 9 (10.59%) Mentoring
Programming Languages
1 63 (74.12%) SQL
2 22 (25.88%) T-SQL
3 9 (10.59%) PL/SQL
4 6 (7.06%) Java
4 6 (7.06%) Python
5 4 (4.71%) Data Analysis Expressions (DAX)
6 3 (3.53%) Bash Shell
6 3 (3.53%) Perl
6 3 (3.53%) PHP
7 2 (2.35%) Java 8
7 2 (2.35%) VBA
8 1 (1.18%) C#
8 1 (1.18%) C++
8 1 (1.18%) R
8 1 (1.18%) VB.NET
Qualifications
1 14 (16.47%) Degree
2 8 (9.41%) DBS Check
3 2 (2.35%) SC Cleared
3 2 (2.35%) Security Cleared
4 1 (1.18%) Microsoft Certification
Quality Assurance & Compliance
1 5 (5.88%) Data Quality
1 5 (5.88%) SLA
2 2 (2.35%) ISO/IEC 20000
3 1 (1.18%) PMO
3 1 (1.18%) QA
System Software
1 3 (3.53%) HDFS
2 1 (1.18%) Active Directory
2 1 (1.18%) Docker
Systems Management
1 5 (5.88%) Ansible
2 3 (3.53%) Data Guard
2 3 (3.53%) Opscode Chef
2 3 (3.53%) Oracle RMAN
2 3 (3.53%) Puppet
3 1 (1.18%) Kubernetes
Vendors
1 24 (28.24%) Microsoft
2 11 (12.94%) Oracle
3 9 (10.59%) Databricks
3 9 (10.59%) Google
4 7 (8.24%) IBM
5 5 (5.88%) Cognos
5 5 (5.88%) SAP
6 4 (4.71%) JD Edwards
7 3 (3.53%) BMC
7 3 (3.53%) Facebook
7 3 (3.53%) Marin
7 3 (3.53%) Remedy
8 2 (2.35%) Capita
8 2 (2.35%) Greenplum
8 2 (2.35%) IFS
8 2 (2.35%) RedGate
8 2 (2.35%) Sparx
9 1 (1.18%) Epicor
9 1 (1.18%) Infor
9 1 (1.18%) Informatica