Period
to 19 October 2019

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

Online Analytical Processing (OLAP)
UK
6 months to
19 Oct 2019
Same period 2018 Same period 2017
Rank 764 774 639
Rank change year-on-year +10 -135 +24
Permanent jobs citing OLAP 311 410 675
As % of all permanent IT jobs advertised in the UK 0.23% 0.25% 0.39%
As % of the Database & Business Intelligence category 0.85% 0.84% 1.27%
Number of salaries quoted 243 323 448
UK median annual salary £60,000 £55,000 £50,000
Median salary % change year-on-year +9.09% +10.00% +0.00%
10th Percentile £34,400 £36,250 £32,500
90th Percentile £95,000 £77,500 £73,825
UK excluding London median annual salary £46,000 £45,000 £44,471
% change year-on-year +2.22% +1.19% -6.38%

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 36,780 48,591 53,271
As % of all permanent IT jobs advertised in the UK 27.00% 29.49% 30.47%
Number of salaries quoted 30,172 39,638 43,769
UK median annual salary £52,500 £50,000 £48,000
Median salary % change year-on-year +5.00% +4.17% +1.05%
10th Percentile £31,250 £31,250 £30,000
90th Percentile £86,250 £82,500 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +2.41%

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 19 October 2019.

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 19 October 2019. 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 278 £60,000 +9.09% 36
London +64 195 £65,000 +4.00% 14
UK excluding London 0 97 £46,000 +2.22% 24
Midlands +47 25 £37,750 -11.18% 6
East of England +67 21 £50,000 -9.09% 1
South East +16 17 £51,250 +13.89% 8
North of England -19 15 £42,500 -5.56% 6
East Midlands +26 13 £46,250 +8.82% 1
North West +15 13 £42,500 - 3
West Midlands +48 12 £37,050 -35.57% 5
Scotland +21 12 £54,000 +2.86% 2
South West +11 5 £77,500 +93.75% 1
Yorkshire -16 2 £47,500 -9.52% 2
Wales +3 1 £32,500 -7.14%
Channel Islands - 1 £52,500 -

For the 6 months to 19 October 2019, 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 211 (67.85%) Business Intelligence
2 202 (64.95%) SQL Server
3 201 (64.63%) SQL
4 195 (62.70%) SQL Server Integration Services
5 183 (58.84%) Data Warehouse
6 170 (54.66%) SQL Server Analysis Services
7 164 (52.73%) SQL Server Reporting Services
8 140 (45.02%) Microsoft
9 135 (43.41%) ETL
10 124 (39.87%) T-SQL
11 95 (30.55%) Finance
12 89 (28.62%) Power BI
12 89 (28.62%) Power Platform
13 86 (27.65%) Analytics
14 82 (26.37%) Azure
15 72 (23.15%) Data Modelling
16 70 (22.51%) SQL Server 2016
17 68 (21.86%) OLAP Cube
17 68 (21.86%) C#
18 64 (20.58%) .NET
19 60 (19.29%) Microsoft Excel
19 60 (19.29%) Analytical Skills
20 59 (18.97%) Agile Software Development
21 55 (17.68%) Degree
22 52 (16.72%) MDX
22 52 (16.72%) Problem-Solving
23 51 (16.40%) OLTP
23 51 (16.40%) Relational Database
24 48 (15.43%) Tableau
25 46 (14.79%) 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 22 (7.07%) SharePoint
2 9 (2.89%) Apache Spark
3 2 (0.64%) SAS
4 1 (0.32%) Apache
4 1 (0.32%) Apache Airflow
4 1 (0.32%) Confluence
Applications
1 60 (19.29%) Microsoft Excel
2 7 (2.25%) Microsoft PowerPoint
3 6 (1.93%) Microsoft Project
4 5 (1.61%) Microsoft Office
5 3 (0.96%) SPSS
6 2 (0.64%) Spreadsheet
7 1 (0.32%) SPSS Modeler
Business Applications
1 12 (3.86%) Remedy ITSM
2 11 (3.54%) Cognos Business Intelligence
3 9 (2.89%) Dynamics CRM
4 6 (1.93%) Cognos TM1
4 6 (1.93%) OPENHousing
5 3 (0.96%) Cognos Planning
5 3 (0.96%) HFM
6 2 (0.64%) Dynamics AX
6 2 (0.64%) NetSuite
7 1 (0.32%) Dynamics GP
7 1 (0.32%) Hyperion Planning
7 1 (0.32%) Infor M3
7 1 (0.32%) Oracle EBS R12
7 1 (0.32%) Oracle Financials
7 1 (0.32%) SAP BPC
7 1 (0.32%) Sparx Enterprise Architect
Cloud Services
1 89 (28.62%) Power Platform
2 82 (26.37%) Azure
3 25 (8.04%) AWS
4 16 (5.14%) Data Lake Analytics
5 12 (3.86%) Azure Data Factory
6 9 (2.89%) PaaS
7 7 (2.25%) Cloud Computing
7 7 (2.25%) GCP
7 7 (2.25%) SaaS
8 5 (1.61%) Dynamics 365
9 3 (0.96%) Amazon S3
9 3 (0.96%) Office 365
9 3 (0.96%) OpenShift
9 3 (0.96%) PowerApps
10 1 (0.32%) Amazon EMR
10 1 (0.32%) Azure Functions
10 1 (0.32%) Serverless
Communications & Networking
1 4 (1.29%) PPP
1 4 (1.29%) SAN
2 2 (0.64%) Intranet
2 2 (0.64%) LAN
2 2 (0.64%) WAN
Database & Business Intelligence
1 202 (64.95%) SQL Server
2 195 (62.70%) SQL Server Integration Services
3 183 (58.84%) Data Warehouse
4 170 (54.66%) SQL Server Analysis Services
5 164 (52.73%) SQL Server Reporting Services
6 89 (28.62%) Power BI
7 70 (22.51%) SQL Server 2016
8 68 (21.86%) OLAP Cube
9 51 (16.40%) OLTP
9 51 (16.40%) Relational Database
10 39 (12.54%) SQL Server 2012
11 35 (11.25%) Microsoft Analysis Services
12 33 (10.61%) Big Data
13 32 (10.29%) Data Lake
14 19 (6.11%) Enterprise Data Warehouse
15 17 (5.47%) PostgreSQL
16 16 (5.14%) PowerPivot
17 15 (4.82%) Data Mining
17 15 (4.82%) Oracle OLAP
18 14 (4.50%) Azure SQL Database
Development Applications
1 13 (4.18%) Visual Studio
2 8 (2.57%) Git (software)
3 6 (1.93%) Team Foundation Server
4 4 (1.29%) JIRA
4 4 (1.29%) SQL Server Management Studio (SSMS)
5 3 (0.96%) VSS/SourceSafe
6 2 (0.64%) Visual Studio Team System
6 2 (0.64%) Zephyr
7 1 (0.32%) Artifactory
7 1 (0.32%) Jenkins
7 1 (0.32%) Liquibase
7 1 (0.32%) Maven
7 1 (0.32%) Sonatype Nexus
7 1 (0.32%) Subversion
General
1 95 (30.55%) Finance
2 15 (4.82%) Law
3 13 (4.18%) Front Office
4 8 (2.57%) Games
4 8 (2.57%) Retail
5 6 (1.93%) Marketing
5 6 (1.93%) Social Housing
6 5 (1.61%) Back Office
6 5 (1.61%) Banking
6 5 (1.61%) Investment Banking
7 4 (1.29%) Legal
7 4 (1.29%) Public Sector
8 1 (0.32%) Aerospace
8 1 (0.32%) Electronics
8 1 (0.32%) Housing Association
8 1 (0.32%) Manufacturing
8 1 (0.32%) Pharmaceutical
8 1 (0.32%) Telecoms
Job Titles
1 157 (50.48%) Developer
2 97 (31.19%) Business Intelligence Developer
3 83 (26.69%) SQL Developer
4 45 (14.47%) DBA
4 45 (14.47%) SQL BI Developer
5 40 (12.86%) Administrator
5 40 (12.86%) SQL Server Developer
6 33 (10.61%) Analyst
6 33 (10.61%) SQL DBA
6 33 (10.61%) SQL Server BI Developer
7 30 (9.65%) Consultant
7 30 (9.65%) SSRS Developer
8 23 (7.40%) Senior Developer
9 21 (6.75%) Business Developer
10 20 (6.43%) T-SQL Developer
11 17 (5.47%) Business Intelligence Analyst
12 16 (5.14%) Data Warehouse Developer
12 16 (5.14%) Database Developer
12 16 (5.14%) OLAP Developer
12 16 (5.14%) SSAS Developer
Libraries, Frameworks & Software Standards
1 64 (20.58%) .NET
2 52 (16.72%) MDX
3 41 (13.18%) ASP.NET
4 29 (9.32%) Web Services
5 4 (1.29%) Kafka
6 3 (0.96%) ASP.NET MVC
6 3 (0.96%) Redux
6 3 (0.96%) Spring
6 3 (0.96%) XML
7 2 (0.64%) .NET Framework
7 2 (0.64%) Entity Framework
7 2 (0.64%) Pandas
7 2 (0.64%) RabbitMQ
8 1 (0.32%) ASP.NET Web API
8 1 (0.32%) Keras
8 1 (0.32%) REST
8 1 (0.32%) scikit-learn
8 1 (0.32%) Spark Streaming
8 1 (0.32%) Swagger
8 1 (0.32%) TensorFlow
Miscellaneous
1 60 (19.29%) Analytical Skills
2 19 (6.11%) Replication
3 16 (5.14%) Self-Motivation
4 15 (4.82%) Data Structures
4 15 (4.82%) Virtual Team
5 14 (4.50%) Algorithms
5 14 (4.50%) Management Information System
6 12 (3.86%) CMDB
7 11 (3.54%) Market Risk
8 8 (2.57%) Greenfield Project
9 7 (2.25%) Hedge funds
10 4 (1.29%) Reinsurance
10 4 (1.29%) User Experience
11 3 (0.96%) Credit Risk
11 3 (0.96%) Taxonomies
12 2 (0.64%) Driving Licence
12 2 (0.64%) Enterprise Software
12 2 (0.64%) N-Tier
13 1 (0.32%) Cloud Native
13 1 (0.32%) Industry 4.0
Operating Systems
1 17 (5.47%) Linux
2 11 (3.54%) Windows
3 2 (0.64%) Windows Server
4 1 (0.32%) Unix
Processes & Methodologies
1 211 (67.85%) Business Intelligence
2 135 (43.41%) ETL
3 86 (27.65%) Analytics
4 72 (23.15%) Data Modelling
5 59 (18.97%) Agile Software Development
6 52 (16.72%) Problem-Solving
7 46 (14.79%) Visualisation
8 42 (13.50%) DevOps
8 42 (13.50%) Kimball Methodology
9 39 (12.54%) ITIL
9 39 (12.54%) Performance Tuning
10 35 (11.25%) Data Science
11 32 (10.29%) Disaster Recovery
12 31 (9.97%) Data Management
13 30 (9.65%) Data Visualisation
14 28 (9.00%) Deployment Automation
15 26 (8.36%) Computer Science
15 26 (8.36%) Refactoring
15 26 (8.36%) Statistics
16 23 (7.40%) Machine Learning
Programming Languages
1 201 (64.63%) SQL
2 124 (39.87%) T-SQL
3 68 (21.86%) C#
4 44 (14.15%) Data Analysis Expressions (DAX)
5 30 (9.65%) Python
5 30 (9.65%) VBA
6 19 (6.11%) VB
7 14 (4.50%) VB.NET
8 13 (4.18%) Java
9 10 (3.22%) PowerShell
10 8 (2.57%) PL/SQL
10 8 (2.57%) R
11 5 (1.61%) JavaScript
12 3 (0.96%) ES6
12 3 (0.96%) Go
12 3 (0.96%) Scala
12 3 (0.96%) TypeScript
12 3 (0.96%) U-SQL
13 2 (0.64%) C
14 1 (0.32%) Shell Script
Qualifications
1 55 (17.68%) Degree
2 17 (5.47%) Microsoft Certification
3 12 (3.86%) MCSE
4 5 (1.61%) Computer Science Degree
4 5 (1.61%) MBA
5 4 (1.29%) Numerate Degree
6 3 (0.96%) PhD
7 2 (0.64%) SC Cleared
7 2 (0.64%) Security Cleared
8 1 (0.32%) CCAB
8 1 (0.32%) PRINCE2 Certification
Quality Assurance & Compliance
1 17 (5.47%) SLA
2 14 (4.50%) Data Quality
3 11 (3.54%) QA
4 1 (0.32%) COBIT
System Software
1 5 (1.61%) Docker
2 2 (0.64%) VMware Infrastructure
3 1 (0.32%) Apache Flume
3 1 (0.32%) Apache ZooKeeper
3 1 (0.32%) HDFS
Systems Management
1 15 (4.82%) Foglight
1 15 (4.82%) LiteSpeed
2 10 (3.22%) SCOM
3 5 (1.61%) Kubernetes
4 3 (0.96%) Oozie
5 2 (0.64%) Ansible
5 2 (0.64%) HP ALM
6 1 (0.32%) Hadoop YARN
Vendors
1 140 (45.02%) Microsoft
2 48 (15.43%) Tableau
3 30 (9.65%) Cognos
4 18 (5.79%) Oracle
5 12 (3.86%) BMC
5 12 (3.86%) Remedy
6 11 (3.54%) Alteryx
7 10 (3.22%) IBM
8 9 (2.89%) SAP
9 8 (2.57%) Hyperion
10 7 (2.25%) Sybase
10 7 (2.25%) Tagetik
11 6 (1.93%) Capita
11 6 (1.93%) Google
12 4 (1.29%) MicroStrategy
12 4 (1.29%) WorldPay
13 3 (0.96%) Databricks
14 2 (0.64%) Infor
14 2 (0.64%) JD Edwards
14 2 (0.64%) VMware