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

Online Analytical Processing (OLAP)
UK
6 months to
23 Feb 2020
Same period 2019 Same period 2018
Rank 782 797 710
Rank change year-on-year +15 -87 -40
Permanent jobs citing OLAP 239 328 551
As % of all permanent IT jobs advertised in the UK 0.20% 0.22% 0.31%
As % of the Database & Business Intelligence category 0.73% 0.76% 1.02%
Number of salaries quoted 200 256 436
UK median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% -
10th Percentile £35,100 £36,500 £31,250
90th Percentile £115,000 £76,250 £71,250
UK excluding London median annual salary £45,000 £50,000 £45,000
% change year-on-year -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 32,660 43,047 53,848
As % of all permanent IT jobs advertised in the UK 26.81% 28.61% 30.56%
Number of salaries quoted 26,794 35,375 44,928
UK median annual salary £52,500 £52,095 £49,000
Median salary % change year-on-year +0.78% +6.32% +3.16%
10th Percentile £32,500 £31,250 £30,000
90th Percentile £88,750 £85,000 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

OLAP
Job Vacancy Trend

Job postings citing OLAP as a percentage of all IT jobs advertised.

Job vacancy trend for OLAP in the UK

OLAP
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP.

Salary trend for OLAP in the UK

OLAP
Salary Histogram

The salary distribution of IT jobs citing OLAP over the 6 months to 23 February 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 23 February 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 +18 216 £55,000 +2.80% 40
London +12 127 £65,000 +8.33% 16
UK excluding London +59 107 £45,000 -10.00% 27
East of England +78 27 £40,000 -28.89% 2
North of England +49 20 £57,500 +35.29% 4
South East +27 15 £55,000 - 7
Midlands +12 15 £55,000 +10.00% 9
North West +41 14 £72,500 +72.62% 3
Scotland +32 13 £40,000 -13.51% 2
East Midlands +25 12 £52,500 +23.53% 8
South West +44 10 £47,500 -8.65% 2
Northern Ireland - 7 £45,000 -
Yorkshire +37 6 £55,000 +4.76%
West Midlands +11 3 £70,000 +21.74% 1

For the 6 months to 23 February 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 182 (76.15%) SQL Server
2 179 (74.90%) SQL
3 141 (59.00%) Business Intelligence
4 122 (51.05%) Data Warehouse
5 114 (47.70%) ETL
6 97 (40.59%) Microsoft
7 96 (40.17%) T-SQL
8 89 (37.24%) Analytics
9 87 (36.40%) SQL Server Integration Services
10 82 (34.31%) SQL Server Analysis Services
11 75 (31.38%) Finance
12 70 (29.29%) Power BI
12 70 (29.29%) Power Platform
13 67 (28.03%) SQL Server Reporting Services
14 66 (27.62%) Analytical Skills
15 64 (26.78%) Data Modelling
16 56 (23.43%) Azure
17 52 (21.76%) OLTP
18 49 (20.50%) Tableau
19 46 (19.25%) Oracle
20 45 (18.83%) Agile Software Development
20 45 (18.83%) Oracle OLAP
21 44 (18.41%) Java
21 44 (18.41%) Relational Database
22 43 (17.99%) Degree
23 41 (17.15%) Visualisation
24 37 (15.48%) Python
25 36 (15.06%) Cognos
25 36 (15.06%) Performance Tuning
26 34 (14.23%) Problem-Solving

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 15 (6.28%) Apache Spark
2 10 (4.18%) SharePoint
3 8 (3.35%) Apache Airflow
4 7 (2.93%) Tomcat
5 4 (1.67%) Elasticsearch
6 2 (0.84%) SAS
7 1 (0.42%) CMS
7 1 (0.42%) Confluence
7 1 (0.42%) Oracle SOA Suite
Applications
1 25 (10.46%) Microsoft Excel
2 6 (2.51%) Microsoft Office
3 3 (1.26%) SPSS
4 2 (0.84%) Spreadsheet
5 1 (0.42%) SPSS Modeler
Business Applications
1 10 (4.18%) Cognos Business Intelligence
2 9 (3.77%) Dynamics CRM
3 5 (2.09%) Cognos TM1
4 4 (1.67%) NetSuite
5 2 (0.84%) Dynamics AX
5 2 (0.84%) Dynamics NAV
5 2 (0.84%) Lawson
5 2 (0.84%) SAP Business One
6 1 (0.42%) Cognos Planning
6 1 (0.42%) HFM
6 1 (0.42%) Oracle EBS
6 1 (0.42%) Oracle ERP
6 1 (0.42%) Remedy ITSM
Cloud Services
1 70 (29.29%) Power Platform
2 56 (23.43%) Azure
3 31 (12.97%) AWS
4 21 (8.79%) GCP
5 16 (6.69%) Cloud Computing
6 11 (4.60%) Dynamics 365
7 7 (2.93%) SaaS
8 6 (2.51%) Amazon EMR
8 6 (2.51%) Azure Data Factory
9 4 (1.67%) Amazon S3
9 4 (1.67%) Office 365
9 4 (1.67%) Serverless
10 3 (1.26%) Amazon Kinesis
10 3 (1.26%) AWS IoT
11 2 (0.84%) Data Lake Analytics
12 1 (0.42%) Google Analytics
12 1 (0.42%) WhatsApp
Communications & Networking
1 3 (1.26%) PPP
2 1 (0.42%) Unified Communications
Database & Business Intelligence
1 182 (76.15%) SQL Server
2 122 (51.05%) Data Warehouse
3 87 (36.40%) SQL Server Integration Services
4 82 (34.31%) SQL Server Analysis Services
5 70 (29.29%) Power BI
6 67 (28.03%) SQL Server Reporting Services
7 52 (21.76%) OLTP
8 45 (18.83%) Oracle OLAP
9 44 (18.41%) Relational Database
10 33 (13.81%) OLAP Cube
11 32 (13.39%) NoSQL
12 31 (12.97%) QlikView
13 25 (10.46%) Snowflake Schema
14 22 (9.21%) Data Mining
15 20 (8.37%) Hadoop
16 19 (7.95%) Microsoft Analysis Services
17 18 (7.53%) Big Data
17 18 (7.53%) DB2
18 17 (7.11%) BusinessObjects
19 14 (5.86%) SQL Server 2016
Development Applications
1 13 (5.44%) Git (software)
2 8 (3.35%) Visual Studio
3 7 (2.93%) ERwin
3 7 (2.93%) Octopus Deploy
3 7 (2.93%) PowerDesigner
3 7 (2.93%) TeamCity
4 4 (1.67%) JIRA
5 3 (1.26%) SQL Server Management Studio (SSMS)
5 3 (1.26%) Subversion
5 3 (1.26%) Visual Studio Team System
6 2 (0.84%) Zephyr
7 1 (0.42%) Flyway
7 1 (0.42%) Jenkins
7 1 (0.42%) Liquibase
General
1 75 (31.38%) Finance
2 8 (3.35%) Legal
2 8 (3.35%) Marketing
3 6 (2.51%) Games
4 4 (1.67%) Law
5 3 (1.26%) Retail
5 3 (1.26%) Telecoms
6 1 (0.42%) Banking
6 1 (0.42%) Financial Institution
6 1 (0.42%) Investment Banking
6 1 (0.42%) Public Sector
Job Titles
1 89 (37.24%) Developer
2 48 (20.08%) Business Intelligence Developer
3 44 (18.41%) Analyst
4 39 (16.32%) DBA
5 38 (15.90%) Administrator
6 33 (13.81%) SQL DBA
7 29 (12.13%) Architect
7 29 (12.13%) SQL Developer
8 25 (10.46%) Business Intelligence Analyst
9 21 (8.79%) Data Architect
10 15 (6.28%) Business Intelligence Specialist
11 14 (5.86%) Data Engineer
12 13 (5.44%) Database Developer
12 13 (5.44%) Report Analyst
12 13 (5.44%) Senior Developer
13 12 (5.02%) Business Developer
14 11 (4.60%) Business Intelligence Manager
14 11 (4.60%) Business Manager
15 10 (4.18%) Business Intelligence Lead
15 10 (4.18%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 33 (13.81%) .NET
2 24 (10.04%) MDX
3 22 (9.21%) Kafka
4 16 (6.69%) HTML
5 15 (6.28%) AngularJS
6 13 (5.44%) ASP.NET
6 13 (5.44%) XML
7 8 (3.35%) React
7 8 (3.35%) Web Services
8 7 (2.93%) CSS
8 7 (2.93%) FIX Protocol
8 7 (2.93%) HTML5
8 7 (2.93%) jQuery
8 7 (2.93%) JSON
9 4 (1.67%) Apache NiFi
9 4 (1.67%) J2EE
9 4 (1.67%) JSP
9 4 (1.67%) Servlets
10 3 (1.26%) ASP.NET Web API
10 3 (1.26%) RabbitMQ
Miscellaneous
1 66 (27.62%) Analytical Skills
2 20 (8.37%) Management Information System
3 16 (6.69%) Data Structures
4 9 (3.77%) Self-Motivation
5 7 (2.93%) Foreign Exchange (FX)
5 7 (2.93%) Hedge funds
5 7 (2.93%) Reference Data
5 7 (2.93%) Replication
6 6 (2.51%) Public Cloud
7 5 (2.09%) Algorithms
8 4 (1.67%) User Experience
9 2 (0.84%) AS400
9 2 (0.84%) Client/Server
9 2 (0.84%) Virtual Team
10 1 (0.42%) CMDB
10 1 (0.42%) Enterprise Software
10 1 (0.42%) FMCG
10 1 (0.42%) Greenfield Project
10 1 (0.42%) Smartphone
Operating Systems
1 7 (2.93%) Linux
Processes & Methodologies
1 141 (59.00%) Business Intelligence
2 114 (47.70%) ETL
3 89 (37.24%) Analytics
4 64 (26.78%) Data Modelling
5 45 (18.83%) Agile Software Development
6 41 (17.15%) Visualisation
7 36 (15.06%) Performance Tuning
8 34 (14.23%) Computer Science
8 34 (14.23%) Problem-Solving
9 32 (13.39%) Migration
10 29 (12.13%) Continuous Improvement
11 28 (11.72%) Capacity Planning
11 28 (11.72%) Data Analytics
11 28 (11.72%) Database Security
12 27 (11.30%) Validation
13 26 (10.88%) Data Analysis
13 26 (10.88%) Data Visualisation
14 24 (10.04%) Data Science
15 20 (8.37%) Dimensional Modelling
16 19 (7.95%) Data Management
Programming Languages
1 179 (74.90%) SQL
2 96 (40.17%) T-SQL
3 44 (18.41%) Java
4 37 (15.48%) Python
5 26 (10.88%) C#
6 21 (8.79%) PL/SQL
7 12 (5.02%) Data Analysis Expressions (DAX)
7 12 (5.02%) Scala
8 11 (4.60%) PowerShell
9 8 (3.35%) R
9 8 (3.35%) VB
9 8 (3.35%) VBA
10 1 (0.42%) C++
10 1 (0.42%) Go
10 1 (0.42%) JavaScript
10 1 (0.42%) PHP
10 1 (0.42%) Ruby
Qualifications
1 43 (17.99%) Degree
2 21 (8.79%) Computer Science Degree
3 12 (5.02%) MBA
4 11 (4.60%) Master's Degree
5 7 (2.93%) AWS Certification
6 5 (2.09%) Microsoft Certification
7 4 (1.67%) ACCA
8 3 (1.26%) MCSE
9 2 (0.84%) PMI Certification
9 2 (0.84%) PMP
10 1 (0.42%) CIMA
10 1 (0.42%) Numerate Degree
10 1 (0.42%) PhD
Quality Assurance & Compliance
1 14 (5.86%) Data Quality
2 9 (3.77%) SLA
3 8 (3.35%) QA
4 1 (0.42%) PMO
System Software
1 7 (2.93%) Docker
Systems Management
1 7 (2.93%) Foglight
1 7 (2.93%) LiteSpeed
2 5 (2.09%) SCOM
3 4 (1.67%) Terraform
4 3 (1.26%) Kubernetes
5 2 (0.84%) HP ALM
Vendors
1 97 (40.59%) Microsoft
2 49 (20.50%) Tableau
3 46 (19.25%) Oracle
4 36 (15.06%) Cognos
5 29 (12.13%) IBM
6 21 (8.79%) Google
7 19 (7.95%) SAP
7 19 (7.95%) Sybase
8 10 (4.18%) MicroStrategy
9 9 (3.77%) WorldPay
10 7 (2.93%) Netezza
10 7 (2.93%) PeopleSoft
10 7 (2.93%) Vertica
11 6 (2.51%) Teradata
12 4 (1.67%) Hyperion
12 4 (1.67%) JD Edwards
12 4 (1.67%) SnapLogic
12 4 (1.67%) Tagetik
13 3 (1.26%) Anaplan
13 3 (1.26%) Salesforce.com