Period
to 18 August 2018

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 18 August 2018 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK > England
6 months to
18 Aug 2018
Same period 2017 Same period 2016
Rank 693 616 647
Rank change year-on-year -77 +31 -121
Permanent jobs citing OLAP 480 660 691
As % of all permanent IT jobs advertised in England 0.30% 0.40% 0.37%
As % of the Database & Business Intelligence category 1.00% 1.30% 1.24%
Number of salaries quoted 391 473 568
England median annual salary £55,000 £50,000 £50,000
Median salary % change year-on-year +10.00% - -2.91%
10th Percentile £33,500 £32,600 £36,250
90th Percentile £80,000 £73,750 £79,650
UK median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.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 47,835 50,746 55,938
As % of all permanent IT jobs advertised in England 30.09% 30.46% 30.04%
Number of salaries quoted 39,124 42,677 48,379
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £82,500 £77,500 £75,000
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

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 18 August 2018.

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 18 August 2018. 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 -64 259 £65,000 +13.04% 19
North of England +50 76 £45,000 +1.19% 14
South East -2 73 £45,000 -10.00% 4
North West +32 46 £45,000 +12.50% 7
East of England -20 31 £55,000 +29.41% 2
Yorkshire +36 24 £50,750 +1.50% 6
South West +4 21 £40,000 +3.23% 3
Midlands -29 19 £42,500 +19.72% 3
East Midlands -18 13 £40,000 +6.67% 2
West Midlands +15 6 £47,500 +41.79% 1
North East - 6 £36,500 - 1
OLAP
UK

For the 6 months to 18 August 2018, 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 390 (81.25%) SQL
2 375 (78.13%) Business Intelligence
3 324 (67.50%) Data Warehouse
4 307 (63.96%) SQL Server
5 304 (63.33%) SQL Server Integration Services
6 300 (62.50%) ETL
7 274 (57.08%) SQL Server Reporting Services
8 250 (52.08%) Microsoft
9 242 (50.42%) SQL Server Analysis Services
10 164 (34.17%) Agile Software Development
11 162 (33.75%) Power BI
12 145 (30.21%) T-SQL
13 138 (28.75%) Data Modelling
14 135 (28.13%) Analytics
15 126 (26.25%) Finance
16 124 (25.83%) OLAP Cube
17 123 (25.63%) OLTP
18 120 (25.00%) Analytical Skills
19 116 (24.17%) Oracle
19 116 (24.17%) Oracle OLAP
20 97 (20.21%) C#
21 96 (20.00%) Microsoft Azure
22 93 (19.38%) Kimball Methodology
23 84 (17.50%) Visualisation
24 83 (17.29%) MDX
25 80 (16.67%) Big Data
26 74 (15.42%) Dimensional Modelling
27 72 (15.00%) Relational Database
28 69 (14.38%) .NET
29 68 (14.17%) Problem-Solving

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 34 (7.08%) SAS
2 27 (5.63%) Apache Spark
3 15 (3.13%) SharePoint
4 12 (2.50%) Apache
5 8 (1.67%) Oracle Application Server
6 7 (1.46%) Elasticsearch
7 6 (1.25%) Confluence
8 3 (0.63%) IIS
8 3 (0.63%) JBoss
8 3 (0.63%) Tomcat
8 3 (0.63%) WebLogic
8 3 (0.63%) WebSphere
9 2 (0.42%) Oracle SOA Suite
9 2 (0.42%) SugarCRM
10 1 (0.21%) Apache Pig
10 1 (0.21%) Apache Solr
10 1 (0.21%) OpenStack
10 1 (0.21%) SharePoint 2010
10 1 (0.21%) WordPress
Applications
1 57 (11.88%) Microsoft Excel
2 17 (3.54%) Microsoft Office
3 8 (1.67%) MS Visio
4 4 (0.83%) Spreadsheet
5 3 (0.63%) SPSS
6 1 (0.21%) InfoPath
6 1 (0.21%) Microsoft Project
6 1 (0.21%) S-PLUS
Business Applications
1 11 (2.29%) Cognos TM1
2 5 (1.04%) Cognos Planning
2 5 (1.04%) Dynamics AX
3 4 (0.83%) HFM
3 4 (0.83%) SAP Forecasting and Replenishment
3 4 (0.83%) SAP Retail
3 4 (0.83%) SAP S/4HANA
3 4 (0.83%) SunGard GMI
4 3 (0.63%) Maximo
4 3 (0.63%) SAP ERP
5 2 (0.42%) Dynamics CRM
5 2 (0.42%) SAP BPC
6 1 (0.21%) Dynamics NAV
6 1 (0.21%) Hyperion Planning
6 1 (0.21%) Infor SunSystems
6 1 (0.21%) NetSuite
Cloud Services
1 96 (20.00%) Microsoft Azure
2 18 (3.75%) Amazon AWS
2 18 (3.75%) Azure Data Factory
3 12 (2.50%) SaaS
4 10 (2.08%) Data Lake Analytics
5 9 (1.88%) Google Cloud Platform
5 9 (1.88%) PaaS
6 5 (1.04%) IaaS
7 3 (0.63%) Amazon EMR
7 3 (0.63%) Amazon S3
7 3 (0.63%) Cloud Computing
8 1 (0.21%) AWS Lambda
8 1 (0.21%) Boomi
8 1 (0.21%) Dynamics 365
8 1 (0.21%) Serverless
Communications & Networking
1 9 (1.88%) SAN
1 9 (1.88%) SSL
2 1 (0.21%) DNS
2 1 (0.21%) Firewall
2 1 (0.21%) HTTP
Database & Business Intelligence
1 324 (67.50%) Data Warehouse
2 307 (63.96%) SQL Server
3 304 (63.33%) SQL Server Integration Services
4 274 (57.08%) SQL Server Reporting Services
5 242 (50.42%) SQL Server Analysis Services
6 162 (33.75%) Power BI
7 124 (25.83%) OLAP Cube
8 123 (25.63%) OLTP
9 116 (24.17%) Oracle OLAP
10 80 (16.67%) Big Data
11 72 (15.00%) Relational Database
12 56 (11.67%) Hadoop
13 49 (10.21%) MySQL
14 41 (8.54%) Microsoft Analysis Services
15 39 (8.13%) QlikView
16 37 (7.71%) SQL Server 2012
17 36 (7.50%) BusinessObjects
17 36 (7.50%) Oracle Database
18 35 (7.29%) SQL Server 2008
18 35 (7.29%) Star Schema
Development Applications
1 37 (7.71%) Visual Studio
2 23 (4.79%) ERwin
3 20 (4.17%) Team Foundation Server
4 19 (3.96%) Git (software)
5 18 (3.75%) JIRA
6 14 (2.92%) SQL Server Management Studio (SSMS)
6 14 (2.92%) Visual Studio Team System
7 7 (1.46%) Octopus Deploy
7 7 (1.46%) Toad
8 6 (1.25%) ER Studio
9 5 (1.04%) Maven
10 4 (0.83%) Jenkins
10 4 (0.83%) TeamCity
11 3 (0.63%) Ant
11 3 (0.63%) Gradle
11 3 (0.63%) JUnit
12 2 (0.42%) Bitbucket
13 1 (0.21%) Cucumber
13 1 (0.21%) Mockito
13 1 (0.21%) TestNG
General
1 126 (26.25%) Finance
2 45 (9.38%) Advertising
3 41 (8.54%) Banking
4 22 (4.58%) Marketing
5 21 (4.38%) Games
6 14 (2.92%) Retail
7 9 (1.88%) Front Office
7 9 (1.88%) Investment Banking
8 8 (1.67%) General Ledger
9 6 (1.25%) Back Office
10 5 (1.04%) Legal
10 5 (1.04%) Manufacturing
10 5 (1.04%) Pharmaceutical
11 4 (0.83%) Financial Institution
11 4 (0.83%) International Banking
11 4 (0.83%) Law
11 4 (0.83%) Russian Language
12 2 (0.42%) Dutch Language
12 2 (0.42%) French Language
12 2 (0.42%) German Language
Job Titles
1 244 (50.83%) Developer
2 147 (30.63%) Business Intelligence Developer
3 82 (17.08%) SQL Developer
4 60 (12.50%) Architect
5 51 (10.63%) Analyst
6 44 (9.17%) Data Architect
6 44 (9.17%) SQL BI Developer
7 42 (8.75%) SSRS Developer
8 41 (8.54%) SSIS Developer
9 39 (8.13%) Senior Developer
10 38 (7.92%) DBA
11 35 (7.29%) Business Developer
11 35 (7.29%) Consultant
12 34 (7.08%) Data Warehouse Developer
13 30 (6.25%) Business Intelligence Analyst
13 30 (6.25%) SQL Server Developer
14 26 (5.42%) Senior Business Intelligence Developer
15 25 (5.21%) SQL Server BI Developer
16 23 (4.79%) C# Developer
17 20 (4.17%) Administrator
Libraries, Frameworks & Software Standards
1 83 (17.29%) MDX
2 69 (14.38%) .NET
3 34 (7.08%) XML
4 31 (6.46%) Web Services
5 28 (5.83%) JSON
5 28 (5.83%) Kafka
6 27 (5.63%) WPF
7 24 (5.00%) SOAP
8 17 (3.54%) ASP.NET
9 16 (3.33%) Oracle GoldenGate
10 15 (3.13%) REST
11 9 (1.88%) .NET Framework
11 9 (1.88%) HTML
11 9 (1.88%) WSDL
12 8 (1.67%) Angular 2
12 8 (1.67%) AngularJS
12 8 (1.67%) ASP.NET Core
12 8 (1.67%) ASP.NET Web API
12 8 (1.67%) Entity Framework
13 4 (0.83%) .NET Core
Miscellaneous
1 120 (25.00%) Analytical Skills
2 30 (6.25%) Replication
3 25 (5.21%) Computer Science
4 20 (4.17%) Data Structures
5 14 (2.92%) Self-Motivation
6 13 (2.71%) Hybrid Cloud
7 12 (2.50%) Data Centre
7 12 (2.50%) Management Information System
8 11 (2.29%) Fintech
9 9 (1.88%) Clustering
9 9 (1.88%) Mobile App
10 8 (1.67%) Enterprise Software
10 8 (1.67%) Reference Data
11 7 (1.46%) Greenfield Project
11 7 (1.46%) Tandem
12 6 (1.25%) Virtual Team
13 5 (1.04%) Data Protection Act
13 5 (1.04%) Derivative
13 5 (1.04%) Reinsurance
14 4 (0.83%) Taxonomies
Operating Systems
1 26 (5.42%) Linux
2 15 (3.13%) Unix
3 14 (2.92%) Windows
4 12 (2.50%) Windows Server
5 4 (0.83%) Windows Server 2012
6 1 (0.21%) CentOS
6 1 (0.21%) Debian
Processes & Methodologies
1 375 (78.13%) Business Intelligence
2 300 (62.50%) ETL
3 164 (34.17%) Agile Software Development
4 138 (28.75%) Data Modelling
5 135 (28.13%) Analytics
6 93 (19.38%) Kimball Methodology
7 84 (17.50%) Visualisation
8 74 (15.42%) Dimensional Modelling
9 68 (14.17%) Problem-Solving
10 65 (13.54%) Performance Tuning
11 62 (12.92%) Data Architecture
12 58 (12.08%) Data Analysis
13 54 (11.25%) Data Visualisation
14 50 (10.42%) Data Integration
15 43 (8.96%) Data Analytics
15 43 (8.96%) Data Science
16 37 (7.71%) Migration
17 36 (7.50%) Data Management
18 32 (6.67%) Change Management
19 31 (6.46%) Logical Data Model
Programming Languages
1 390 (81.25%) SQL
2 145 (30.21%) T-SQL
3 97 (20.21%) C#
4 62 (12.92%) Python
5 53 (11.04%) PL/SQL
6 50 (10.42%) Java
7 42 (8.75%) PowerShell
8 27 (5.63%) Data Analysis Expressions (DAX)
9 23 (4.79%) R
9 23 (4.79%) VBA
10 15 (3.13%) JavaScript
11 12 (2.50%) Perl
12 10 (2.08%) Go
12 10 (2.08%) Scala
13 8 (1.67%) TypeScript
13 8 (1.67%) U-SQL
13 8 (1.67%) VB.NET
14 7 (1.46%) MATLAB
15 6 (1.25%) Shell Script
16 5 (1.04%) C
Qualifications
1 65 (13.54%) Degree
2 15 (3.13%) Microsoft Certification
3 12 (2.50%) Computer Science Degree
4 9 (1.88%) TOGAF Certification
5 5 (1.04%) Master's Degree
6 4 (0.83%) MCSD
6 4 (0.83%) Microsoft Certified Architect
6 4 (0.83%) Security Cleared
7 3 (0.63%) SC Cleared
8 2 (0.42%) OCP
8 2 (0.42%) Oracle Certification
8 2 (0.42%) PhD
9 1 (0.21%) ACCA
9 1 (0.21%) MBA
9 1 (0.21%) MCP
9 1 (0.21%) MCSE
9 1 (0.21%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 43 (8.96%) Data Quality
2 17 (3.54%) QA
3 6 (1.25%) GDPR
4 4 (0.83%) EMIR
4 4 (0.83%) FATCA
4 4 (0.83%) MiFID
4 4 (0.83%) SLA
5 3 (0.63%) EFQM
System Software
1 7 (1.46%) HDFS
2 6 (1.25%) Apache Flume
3 2 (0.42%) Docker
4 1 (0.21%) Apache ZooKeeper
4 1 (0.21%) VMware Infrastructure
Systems Management
1 13 (2.71%) Systems Management Server (SMS)
2 10 (2.08%) Data Guard
3 5 (1.04%) Control-M
3 5 (1.04%) Hadoop YARN
4 4 (0.83%) Oozie
4 4 (0.83%) Single Sign-On
5 2 (0.42%) Ansible
6 1 (0.21%) HP Fortify
6 1 (0.21%) Kibana
6 1 (0.21%) Nagios
6 1 (0.21%) Puppet
6 1 (0.21%) Terraform
Vendors
1 250 (52.08%) Microsoft
2 116 (24.17%) Oracle
3 67 (13.96%) Tableau
4 41 (8.54%) SAP
5 37 (7.71%) Cognos
6 21 (4.38%) Informatica
7 17 (3.54%) IBM
7 17 (3.54%) MicroStrategy
8 11 (2.29%) Netezza
9 9 (1.88%) Cisco
9 9 (1.88%) Cloudera
9 9 (1.88%) Talend
9 9 (1.88%) Teradata
10 8 (1.67%) Alteryx
10 8 (1.67%) Google
10 8 (1.67%) Tagetik
11 7 (1.46%) Hyperion
12 6 (1.25%) Salesforce.com
13 5 (1.04%) BMC
13 5 (1.04%) TIBCO