Period
to 23 February 2020

The following table provides summary statistics for permanent job vacancies advertised in London 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)
England > London
6 months to
23 Feb 2020
Same period 2019 Same period 2018
Rank 586 598 595
Rank change year-on-year +12 -3 +32
Permanent jobs citing OLAP 127 180 256
As % of all permanent IT jobs advertised in London 0.25% 0.29% 0.37%
As % of the Database & Business Intelligence category 0.92% 0.98% 1.20%
Number of salaries quoted 103 137 179
London median annual salary £65,000 £60,000 £55,000
Median salary % change year-on-year +8.33% +9.09% -8.33%
10th Percentile £37,500 £38,250 £41,250
90th Percentile £120,000 £81,500 £77,500
England median annual salary £55,000 £53,500 £50,000
% change year-on-year +2.80% +7.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 London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 13,862 18,402 21,288
As % of all permanent IT jobs advertised in London 27.64% 29.51% 30.38%
Number of salaries quoted 11,399 15,233 17,595
London median annual salary £65,000 £62,500 £60,000
Median salary % change year-on-year +4.00% +4.17% +4.35%
10th Percentile £38,750 £37,500 £37,500
90th Percentile £105,000 £95,000 £90,000
England median annual salary £53,869 £52,500 £50,000
% change year-on-year +2.61% +5.00% +5.26%

OLAP
Job Vacancy Trend in London

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

Job vacancy trend for OLAP in London

OLAP
Salary Trend in London

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

Salary trend for OLAP in London

OLAP
Salary Histogram in London

The salary distribution of IT jobs citing OLAP in London over the 6 months to 23 February 2020.

Salary histogram for OLAP in London

OLAP
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the London region 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
Central London +34 26 £73,750 +18.00% 9
North London - 10 £40,000 -
West London +11 5 £32,500 -47.15% 1
South London - 4 £43,800 - 1
East London +12 1 £65,000 -
OLAP
England

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 across the London region with a requirement for OLAP.

1 100 (78.74%) SQL Server
2 88 (69.29%) Business Intelligence
3 82 (64.57%) SQL
4 66 (51.97%) Data Warehouse
5 62 (48.82%) Analytics
6 51 (40.16%) Data Modelling
7 45 (35.43%) Analytical Skills
8 43 (33.86%) ETL
8 43 (33.86%) Tableau
9 40 (31.50%) Finance
10 38 (29.92%) Degree
11 37 (29.13%) SQL Server Integration Services
11 37 (29.13%) Relational Database
12 36 (28.35%) Microsoft
13 33 (25.98%) SQL Server Analysis Services
14 32 (25.20%) Oracle
14 32 (25.20%) Power BI
14 32 (25.20%) Power Platform
15 31 (24.41%) Computer Science
15 31 (24.41%) Oracle OLAP
16 30 (23.62%) NoSQL
16 30 (23.62%) Agile Software Development
17 29 (22.83%) T-SQL
17 29 (22.83%) Cognos
18 26 (20.47%) Problem-Solving
19 25 (19.69%) Python
19 25 (19.69%) Validation
19 25 (19.69%) Azure
20 24 (18.90%) Snowflake Schema
21 23 (18.11%) C#

OLAP
Co-occurring IT Skills in London 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 (11.02%) Apache Spark
2 8 (6.30%) Apache Airflow
3 4 (3.15%) Elasticsearch
4 2 (1.57%) SharePoint
5 1 (0.79%) SAS
Applications
1 6 (4.72%) Microsoft Excel
2 3 (2.36%) SPSS
3 2 (1.57%) Microsoft Office
4 1 (0.79%) SPSS Modeler
Business Applications
1 9 (7.09%) Cognos Business Intelligence
2 3 (2.36%) Cognos TM1
3 2 (1.57%) Dynamics CRM
4 1 (0.79%) Cognos Planning
4 1 (0.79%) HFM
Cloud Services
1 32 (25.20%) Power Platform
2 25 (19.69%) Azure
3 20 (15.75%) AWS
3 20 (15.75%) GCP
4 13 (10.24%) Cloud Computing
5 6 (4.72%) Amazon EMR
6 5 (3.94%) Azure Data Factory
7 4 (3.15%) Serverless
8 3 (2.36%) Amazon Kinesis
8 3 (2.36%) Amazon S3
8 3 (2.36%) AWS IoT
8 3 (2.36%) SaaS
9 2 (1.57%) Data Lake Analytics
10 1 (0.79%) WhatsApp
Communications & Networking
1 1 (0.79%) Unified Communications
Database & Business Intelligence
1 100 (78.74%) SQL Server
2 66 (51.97%) Data Warehouse
3 37 (29.13%) Relational Database
3 37 (29.13%) SQL Server Integration Services
4 33 (25.98%) SQL Server Analysis Services
5 32 (25.20%) Power BI
6 31 (24.41%) Oracle OLAP
7 30 (23.62%) NoSQL
8 24 (18.90%) Snowflake Schema
9 21 (16.54%) SQL Server Reporting Services
10 19 (14.96%) Hadoop
10 19 (14.96%) OLAP Cube
10 19 (14.96%) QlikView
11 18 (14.17%) OLTP
12 14 (11.02%) Big Data
13 13 (10.24%) Cognos Framework Manager
13 13 (10.24%) Data Lake
14 11 (8.66%) Amazon Redshift
14 11 (8.66%) Apache Cassandra
14 11 (8.66%) BigQuery
Development Applications
1 13 (10.24%) Git (software)
2 7 (5.51%) ERwin
2 7 (5.51%) Octopus Deploy
2 7 (5.51%) PowerDesigner
2 7 (5.51%) TeamCity
3 4 (3.15%) Visual Studio
4 3 (2.36%) Subversion
4 3 (2.36%) Visual Studio Team System
5 1 (0.79%) Flyway
5 1 (0.79%) Jenkins
5 1 (0.79%) JIRA
5 1 (0.79%) Liquibase
5 1 (0.79%) SQL Server Management Studio (SSMS)
General
1 40 (31.50%) Finance
2 7 (5.51%) Legal
3 6 (4.72%) Games
4 3 (2.36%) Law
4 3 (2.36%) Marketing
4 3 (2.36%) Telecoms
5 1 (0.79%) Banking
5 1 (0.79%) Financial Institution
5 1 (0.79%) Investment Banking
Job Titles
1 41 (32.28%) Developer
2 34 (26.77%) Analyst
3 25 (19.69%) Architect
3 25 (19.69%) Business Intelligence Developer
4 21 (16.54%) Data Architect
5 20 (15.75%) Business Intelligence Analyst
6 15 (11.81%) Administrator
6 15 (11.81%) DBA
6 15 (11.81%) SQL DBA
7 12 (9.45%) Data Engineer
7 12 (9.45%) Report Analyst
8 9 (7.09%) Big Data Architect
8 9 (7.09%) SQL Developer
9 8 (6.30%) Cloud Architect
10 7 (5.51%) Cognos Specialist
10 7 (5.51%) Report Specialist
11 6 (4.72%) Database Developer
11 6 (4.72%) Senior Developer
11 6 (4.72%) SQL Analyst
11 6 (4.72%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 22 (17.32%) Kafka
2 17 (13.39%) .NET
3 13 (10.24%) ASP.NET
4 9 (7.09%) HTML
4 9 (7.09%) XML
5 7 (5.51%) AngularJS
5 7 (5.51%) CSS
5 7 (5.51%) FIX Protocol
5 7 (5.51%) JSON
5 7 (5.51%) React
6 6 (4.72%) MDX
7 4 (3.15%) Apache NiFi
8 3 (2.36%) Node.js
8 3 (2.36%) RabbitMQ
8 3 (2.36%) REST
9 1 (0.79%) COM
9 1 (0.79%) Natural Language Processing
Miscellaneous
1 45 (35.43%) Analytical Skills
2 16 (12.60%) Management Information System
3 13 (10.24%) Data Structures
4 7 (5.51%) Foreign Exchange (FX)
4 7 (5.51%) Hedge funds
4 7 (5.51%) Reference Data
5 5 (3.94%) Self-Motivation
6 4 (3.15%) Algorithms
7 3 (2.36%) Public Cloud
7 3 (2.36%) User Experience
8 1 (0.79%) Greenfield Project
8 1 (0.79%) Virtual Team
Processes & Methodologies
1 88 (69.29%) Business Intelligence
2 62 (48.82%) Analytics
3 51 (40.16%) Data Modelling
4 43 (33.86%) ETL
5 31 (24.41%) Computer Science
6 30 (23.62%) Agile Software Development
7 26 (20.47%) Problem-Solving
8 25 (19.69%) Validation
9 23 (18.11%) Visualisation
10 20 (15.75%) Data Science
11 19 (14.96%) Migration
12 18 (14.17%) Data Analytics
13 17 (13.39%) Machine Learning
13 17 (13.39%) Performance Tuning
14 15 (11.81%) Dashboard Development
15 14 (11.02%) Data Management
15 14 (11.02%) Data Visualisation
16 13 (10.24%) Kimball Methodology
16 13 (10.24%) Software Engineering
17 12 (9.45%) Data Analysis
Programming Languages
1 82 (64.57%) SQL
2 29 (22.83%) T-SQL
3 25 (19.69%) Python
4 23 (18.11%) C#
5 21 (16.54%) Java
6 13 (10.24%) PL/SQL
7 10 (7.87%) Scala
8 8 (6.30%) VB
9 7 (5.51%) PowerShell
10 6 (4.72%) VBA
11 5 (3.94%) R
12 4 (3.15%) Data Analysis Expressions (DAX)
Qualifications
1 38 (29.92%) Degree
2 19 (14.96%) Computer Science Degree
3 12 (9.45%) MBA
4 11 (8.66%) Master's Degree
5 7 (5.51%) AWS Certification
6 3 (2.36%) MCSE
6 3 (2.36%) Microsoft Certification
7 1 (0.79%) Numerate Degree
7 1 (0.79%) PhD
Quality Assurance & Compliance
1 11 (8.66%) Data Quality
2 7 (5.51%) QA
System Software
1 7 (5.51%) Docker
Systems Management
1 4 (3.15%) Terraform
2 3 (2.36%) Kubernetes
Vendors
1 43 (33.86%) Tableau
2 36 (28.35%) Microsoft
3 32 (25.20%) Oracle
4 29 (22.83%) Cognos
5 20 (15.75%) Google
6 18 (14.17%) IBM
7 12 (9.45%) Sybase
8 10 (7.87%) MicroStrategy
9 9 (7.09%) WorldPay
10 7 (5.51%) Netezza
10 7 (5.51%) PeopleSoft
10 7 (5.51%) SAP
10 7 (5.51%) Vertica
11 6 (4.72%) Teradata
12 4 (3.15%) SnapLogic
13 3 (2.36%) Hyperion
13 3 (2.36%) Perforce
13 3 (2.36%) Salesforce.com
13 3 (2.36%) Tagetik
14 1 (0.79%) TIBCO