Period
to 20 January 2020

The following table provides summary statistics for permanent job vacancies advertised in England 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 20 January 2020 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK > England
6 months to
20 Jan 2020
Same period 2019 Same period 2018
Rank 760 764 651
Rank change year-on-year +4 -113 +46
Permanent jobs citing OLAP 229 322 568
As % of all permanent IT jobs advertised in England 0.20% 0.23% 0.35%
As % of the Database & Business Intelligence category 0.74% 0.81% 1.15%
Number of salaries quoted 178 251 426
England median annual salary £57,500 £55,000 £50,000
Median salary % change year-on-year +4.55% +10.00% -
10th Percentile £37,223 £38,250 £31,250
90th Percentile £100,000 £76,250 £72,500
UK median annual salary £55,000 £55,000 £50,000
% change year-on-year - +10.00% -

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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 31,047 39,706 49,552
As % of all permanent IT jobs advertised in England 26.78% 28.55% 30.57%
Number of salaries quoted 25,693 32,845 41,466
England median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% +5.26%
10th Percentile £32,500 £31,250 £30,500
90th Percentile £90,000 £85,000 £77,500
UK median annual salary £52,500 £52,500 £48,000
% change year-on-year - +9.38% +1.05%

OLAP
Job Vacancy Trend in England

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

Job vacancy trend for OLAP in England

OLAP
Salary Trend in England

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

Salary trend for OLAP in England

OLAP
Salary Histogram in England

The salary distribution of IT jobs citing OLAP in England over the 6 months to 20 January 2020.

Salary histogram for OLAP in England

OLAP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the England region over the 6 months to 20 January 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
London -18 135 £65,000 +8.33% 18
East of England +83 30 £40,000 -33.33% 3
Midlands +49 24 £45,000 -5.26% 4
North of England +35 17 £53,750 +19.44% 10
East Midlands +24 15 £47,500 +11.76% 3
South East +31 13 £57,500 +10.05% 6
North West +30 12 £43,750 +4.17% 6
South West +24 9 £53,750 +37.82% 4
West Midlands +17 9 £37,050 -35.57% 1
Yorkshire +23 5 £56,250 +2.27% 3
OLAP
UK

For the 6 months to 20 January 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 across the England region with a requirement for OLAP.

1 170 (74.24%) SQL Server
2 165 (72.05%) SQL
3 157 (68.56%) Business Intelligence
4 131 (57.21%) Data Warehouse
5 118 (51.53%) ETL
6 103 (44.98%) Microsoft
7 100 (43.67%) SQL Server Integration Services
8 87 (37.99%) Analytics
9 85 (37.12%) SQL Server Reporting Services
10 81 (35.37%) T-SQL
11 78 (34.06%) Power BI
11 78 (34.06%) Power Platform
12 77 (33.62%) SQL Server Analysis Services
13 67 (29.26%) Azure
14 63 (27.51%) Finance
14 63 (27.51%) Data Modelling
15 57 (24.89%) Analytical Skills
16 50 (21.83%) OLAP Cube
17 47 (20.52%) Relational Database
18 46 (20.09%) OLTP
19 43 (18.78%) Visualisation
19 43 (18.78%) Tableau
20 39 (17.03%) Problem-Solving
20 39 (17.03%) Agile Software Development
21 36 (15.72%) Performance Tuning
22 34 (14.85%) SQL Server 2016
23 33 (14.41%) Degree
24 32 (13.97%) Cognos
25 31 (13.54%) Oracle
26 29 (12.66%) Oracle OLAP

OLAP
Co-occurring IT Skills in England 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 14 (6.11%) SharePoint
2 12 (5.24%) Apache Spark
3 8 (3.49%) Apache Airflow
4 3 (1.31%) Elasticsearch
4 3 (1.31%) SAS
5 1 (0.44%) Apache
5 1 (0.44%) CMS
5 1 (0.44%) Confluence
Applications
1 26 (11.35%) Microsoft Excel
2 5 (2.18%) Microsoft Office
3 3 (1.31%) SPSS
4 2 (0.87%) Spreadsheet
5 1 (0.44%) SPSS Modeler
Business Applications
1 11 (4.80%) Cognos Business Intelligence
1 11 (4.80%) Dynamics CRM
2 6 (2.62%) OPENHousing
3 4 (1.75%) Cognos TM1
4 3 (1.31%) NetSuite
5 2 (0.87%) Dynamics AX
6 1 (0.44%) Cognos Planning
6 1 (0.44%) Dynamics NAV
6 1 (0.44%) HFM
6 1 (0.44%) Hyperion Planning
6 1 (0.44%) Lawson
6 1 (0.44%) Oracle EBS
6 1 (0.44%) Oracle ERP
6 1 (0.44%) SAP BPC
6 1 (0.44%) SAP Business One
Cloud Services
1 78 (34.06%) Power Platform
2 67 (29.26%) Azure
3 29 (12.66%) AWS
4 18 (7.86%) GCP
5 11 (4.80%) Cloud Computing
6 10 (4.37%) Dynamics 365
7 8 (3.49%) Azure Data Factory
8 6 (2.62%) Data Lake Analytics
8 6 (2.62%) SaaS
9 5 (2.18%) Amazon EMR
10 4 (1.75%) Amazon S3
10 4 (1.75%) Office 365
10 4 (1.75%) Serverless
11 2 (0.87%) Amazon Kinesis
11 2 (0.87%) AWS IoT
12 1 (0.44%) Azure Functions
12 1 (0.44%) WhatsApp
Communications & Networking
1 2 (0.87%) LAN
1 2 (0.87%) PPP
1 2 (0.87%) WAN
2 1 (0.44%) SAN
2 1 (0.44%) Unified Communications
Database & Business Intelligence
1 170 (74.24%) SQL Server
2 131 (57.21%) Data Warehouse
3 100 (43.67%) SQL Server Integration Services
4 85 (37.12%) SQL Server Reporting Services
5 78 (34.06%) Power BI
6 77 (33.62%) SQL Server Analysis Services
7 50 (21.83%) OLAP Cube
8 47 (20.52%) Relational Database
9 46 (20.09%) OLTP
10 34 (14.85%) SQL Server 2016
11 29 (12.66%) Oracle OLAP
12 22 (9.61%) Data Lake
12 22 (9.61%) Data Mining
12 22 (9.61%) Microsoft Analysis Services
12 22 (9.61%) NoSQL
13 21 (9.17%) Big Data
13 21 (9.17%) QlikView
14 20 (8.73%) Enterprise Data Warehouse
15 18 (7.86%) Hadoop
15 18 (7.86%) PostgreSQL
Development Applications
1 11 (4.80%) Git (software)
2 9 (3.93%) Visual Studio
3 4 (1.75%) JIRA
3 4 (1.75%) Visual Studio Team System
4 3 (1.31%) ERwin
4 3 (1.31%) Octopus Deploy
4 3 (1.31%) PowerDesigner
4 3 (1.31%) SQL Server Management Studio (SSMS)
4 3 (1.31%) Subversion
4 3 (1.31%) TeamCity
5 2 (0.87%) Liquibase
5 2 (0.87%) Zephyr
6 1 (0.44%) Flyway
6 1 (0.44%) Jenkins
General
1 63 (27.51%) Finance
2 7 (3.06%) Games
2 7 (3.06%) Marketing
3 6 (2.62%) Social Housing
4 4 (1.75%) Law
4 4 (1.75%) Legal
5 3 (1.31%) Banking
5 3 (1.31%) Investment Banking
5 3 (1.31%) Retail
5 3 (1.31%) Telecoms
6 2 (0.87%) Front Office
7 1 (0.44%) Public Sector
Job Titles
1 79 (34.50%) Developer
2 59 (25.76%) Business Intelligence Developer
3 45 (19.65%) DBA
4 43 (18.78%) Administrator
5 38 (16.59%) Analyst
6 34 (14.85%) SQL DBA
7 24 (10.48%) Business Intelligence Analyst
8 23 (10.04%) SQL Developer
9 21 (9.17%) Architect
10 17 (7.42%) Data Engineer
11 15 (6.55%) Business Developer
12 14 (6.11%) Data Architect
13 13 (5.68%) SQL BI Developer
14 12 (5.24%) Senior Developer
14 12 (5.24%) SSRS Developer
15 11 (4.80%) Business Intelligence Specialist
16 10 (4.37%) Data Visualisation Developer
17 9 (3.93%) Business Intelligence Manager
17 9 (3.93%) Senior Business Intelligence Developer
17 9 (3.93%) VBA Developer
Libraries, Frameworks & Software Standards
1 26 (11.35%) .NET
2 24 (10.48%) MDX
3 17 (7.42%) ASP.NET
4 16 (6.99%) Web Services
5 14 (6.11%) Kafka
6 9 (3.93%) XML
7 6 (2.62%) HTML
8 4 (1.75%) RabbitMQ
8 4 (1.75%) REST
9 3 (1.31%) AngularJS
9 3 (1.31%) Apache NiFi
9 3 (1.31%) CSS
9 3 (1.31%) FIX Protocol
9 3 (1.31%) JSON
9 3 (1.31%) React
10 2 (0.87%) Node.js
11 1 (0.44%) Apache Beam
11 1 (0.44%) Natural Language Processing
11 1 (0.44%) Pandas
11 1 (0.44%) SciPy
Miscellaneous
1 57 (24.89%) Analytical Skills
2 24 (10.48%) Management Information System
3 17 (7.42%) Data Structures
4 15 (6.55%) Replication
5 10 (4.37%) Self-Motivation
6 6 (2.62%) Public Cloud
7 5 (2.18%) User Experience
8 4 (1.75%) Algorithms
9 3 (1.31%) Foreign Exchange (FX)
9 3 (1.31%) Hedge funds
9 3 (1.31%) Reference Data
9 3 (1.31%) Taxonomies
10 2 (0.87%) Client/Server
11 1 (0.44%) AS400
11 1 (0.44%) Data Centre
11 1 (0.44%) FMCG
11 1 (0.44%) Virtual Team
11 1 (0.44%) W3C
Operating Systems
1 16 (6.99%) Linux
Processes & Methodologies
1 157 (68.56%) Business Intelligence
2 118 (51.53%) ETL
3 87 (37.99%) Analytics
4 63 (27.51%) Data Modelling
5 43 (18.78%) Visualisation
6 39 (17.03%) Agile Software Development
6 39 (17.03%) Problem-Solving
7 36 (15.72%) Performance Tuning
8 29 (12.66%) Kimball Methodology
9 28 (12.23%) Data Analytics
10 27 (11.79%) Data Visualisation
10 27 (11.79%) ITIL
11 24 (10.48%) Computer Science
11 24 (10.48%) Continuous Improvement
12 23 (10.04%) Capacity Planning
12 23 (10.04%) Data Protection
12 23 (10.04%) Data Science
12 23 (10.04%) Database Security
13 22 (9.61%) Data Integration
14 21 (9.17%) SDLC
Programming Languages
1 165 (72.05%) SQL
2 81 (35.37%) T-SQL
3 23 (10.04%) C#
4 21 (9.17%) Python
5 18 (7.86%) Data Analysis Expressions (DAX)
6 15 (6.55%) VB
7 14 (6.11%) Java
8 12 (5.24%) VBA
9 11 (4.80%) PL/SQL
10 8 (3.49%) PowerShell
11 7 (3.06%) R
11 7 (3.06%) Scala
12 2 (0.87%) VB.NET
13 1 (0.44%) JavaScript
Qualifications
1 33 (14.41%) Degree
2 14 (6.11%) Computer Science Degree
3 9 (3.93%) MBA
4 7 (3.06%) Master's Degree
5 5 (2.18%) Microsoft Certification
6 3 (1.31%) AWS Certification
6 3 (1.31%) MCSE
7 2 (0.87%) ACCA
8 1 (0.44%) Numerate Degree
8 1 (0.44%) PhD
8 1 (0.44%) PMI Certification
8 1 (0.44%) PMP
8 1 (0.44%) PRINCE2 Certification
Quality Assurance & Compliance
1 17 (7.42%) SLA
2 14 (6.11%) Data Quality
3 3 (1.31%) QA
System Software
1 6 (2.62%) Docker
Systems Management
1 15 (6.55%) Foglight
1 15 (6.55%) LiteSpeed
2 10 (4.37%) SCOM
3 3 (1.31%) Kubernetes
3 3 (1.31%) Terraform
4 2 (0.87%) HP ALM
5 1 (0.44%) Oozie
Vendors
1 103 (44.98%) Microsoft
2 43 (18.78%) Tableau
3 32 (13.97%) Cognos
4 31 (13.54%) Oracle
5 18 (7.86%) IBM
6 16 (6.99%) Google
7 11 (4.80%) SAP
8 9 (3.93%) Sybase
8 9 (3.93%) WorldPay
9 6 (2.62%) Capita
10 5 (2.18%) MicroStrategy
11 4 (1.75%) Hyperion
11 4 (1.75%) Salesforce.com
12 3 (1.31%) JD Edwards
12 3 (1.31%) Netezza
12 3 (1.31%) PeopleSoft
12 3 (1.31%) Perforce
12 3 (1.31%) SnapLogic
12 3 (1.31%) Teradata
12 3 (1.31%) Vertica