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

Online Analytical Processing (OLAP)
UK > England
6 months to
23 Oct 2018
Same period 2017 Same period 2016
Rank 748 604 678
Rank change year-on-year -144 +74 -151
Permanent jobs citing OLAP 388 664 629
As % of all permanent IT jobs advertised in England 0.25% 0.40% 0.35%
As % of the Database & Business Intelligence category 0.86% 1.33% 1.19%
Number of salaries quoted 306 445 514
England median annual salary £55,000 £50,001 £50,000
Median salary % change year-on-year +10.00% +0.00% -
10th Percentile £36,250 £32,500 £36,250
90th Percentile £77,500 £74,000 £80,000
UK median annual salary £55,000 £50,001 £50,000
% change year-on-year +10.00% +0.00% +5.26%

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 45,250 50,051 52,974
As % of all permanent IT jobs advertised in England 29.47% 30.37% 29.60%
Number of salaries quoted 37,076 41,539 45,625
England median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £83,875 £77,500 £76,750
UK median annual salary £50,000 £48,000 £47,500
% change year-on-year +4.17% +1.05% +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 23 October 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 23 October 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 -118 228 £62,500 +4.17% 17
North of England +52 65 £45,000 +1.19% 9
South East -19 40 £45,000 -10.00% 5
North West +20 38 £42,500 +5.59% 2
Yorkshire +22 24 £52,500 +5.00% 6
East of England -2 22 £55,000 +37.50% 6
Midlands -13 18 £42,500 +28.79% 1
South West -21 15 £40,000 -
East Midlands -14 14 £42,500 +46.55% 1
West Midlands +18 4 £57,500 +43.75%
North East -14 3 £37,500 -6.25% 1
OLAP
UK

For the 6 months to 23 October 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 321 (82.73%) Business Intelligence
2 312 (80.41%) SQL
3 296 (76.29%) Data Warehouse
4 258 (66.49%) SQL Server Integration Services
5 240 (61.86%) SQL Server
6 234 (60.31%) SQL Server Reporting Services
7 233 (60.05%) ETL
8 224 (57.73%) SQL Server Analysis Services
9 192 (49.48%) Microsoft
10 147 (37.89%) Agile Software Development
11 131 (33.76%) Power BI
12 125 (32.22%) T-SQL
13 122 (31.44%) Finance
13 122 (31.44%) OLAP Cube
14 112 (28.87%) Analytics
15 107 (27.58%) Analytical Skills
16 104 (26.80%) Data Modelling
17 97 (25.00%) Kimball Methodology
18 95 (24.48%) Dimensional Modelling
19 90 (23.20%) Oracle OLAP
19 90 (23.20%) Oracle
20 79 (20.36%) OLTP
21 74 (19.07%) MDX
22 67 (17.27%) C#
22 67 (17.27%) Tableau
23 64 (16.49%) Big Data
24 62 (15.98%) Visualisation
25 60 (15.46%) Microsoft Azure
25 60 (15.46%) Microsoft Analysis Services
26 59 (15.21%) Microsoft Excel

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 31 (7.99%) SharePoint
2 20 (5.15%) SAS
3 19 (4.90%) Apache Spark
4 8 (2.06%) Oracle Application Server
5 6 (1.55%) Apache
6 4 (1.03%) Oracle SOA Suite
7 3 (0.77%) IIS
8 2 (0.52%) Confluence
9 1 (0.26%) JBoss
9 1 (0.26%) OpenStack
9 1 (0.26%) SugarCRM
9 1 (0.26%) Tomcat
9 1 (0.26%) WebLogic
9 1 (0.26%) WebSphere
Applications
1 59 (15.21%) Microsoft Excel
2 13 (3.35%) Microsoft Office
3 8 (2.06%) MS Visio
4 3 (0.77%) SPSS
5 1 (0.26%) InfoPath
Business Applications
1 20 (5.15%) Cognos TM1
2 11 (2.84%) Dynamics AX
3 6 (1.55%) Cognos Planning
4 5 (1.29%) HFM
5 4 (1.03%) NetSuite
5 4 (1.03%) SAP S/4HANA
5 4 (1.03%) SunGard GMI
6 3 (0.77%) Cognos Business Intelligence
6 3 (0.77%) Maximo
7 2 (0.52%) Dynamics CRM
7 2 (0.52%) SAP Business One
8 1 (0.26%) Elite 3E
8 1 (0.26%) Hyperion Planning
8 1 (0.26%) SAP BPC
8 1 (0.26%) SAP ERP
8 1 (0.26%) SAP Forecasting and Replenishment
8 1 (0.26%) SAP Retail
Cloud Services
1 60 (15.46%) Microsoft Azure
2 22 (5.67%) Azure Data Factory
3 20 (5.15%) Data Lake Analytics
4 12 (3.09%) Amazon AWS
5 11 (2.84%) PaaS
6 10 (2.58%) SaaS
7 3 (0.77%) Azure Machine Learning
7 3 (0.77%) GitHub
8 2 (0.52%) Office 365
9 1 (0.26%) Amazon EMR
9 1 (0.26%) Boomi
9 1 (0.26%) Cloud Computing
9 1 (0.26%) IaaS
Communications & Networking
1 9 (2.32%) SAN
2 1 (0.26%) DNS
2 1 (0.26%) Firewall
2 1 (0.26%) SSL
2 1 (0.26%) WebEx
Database & Business Intelligence
1 296 (76.29%) Data Warehouse
2 258 (66.49%) SQL Server Integration Services
3 240 (61.86%) SQL Server
4 234 (60.31%) SQL Server Reporting Services
5 224 (57.73%) SQL Server Analysis Services
6 131 (33.76%) Power BI
7 122 (31.44%) OLAP Cube
8 90 (23.20%) Oracle OLAP
9 79 (20.36%) OLTP
10 64 (16.49%) Big Data
11 60 (15.46%) Microsoft Analysis Services
12 57 (14.69%) Relational Database
13 44 (11.34%) Hadoop
14 41 (10.57%) SQL Server 2012
15 37 (9.54%) QlikView
16 36 (9.28%) SQL Server 2008
17 34 (8.76%) Oracle Database
18 32 (8.25%) SQL Server 2014
19 31 (7.99%) Azure SQL Database
20 29 (7.47%) SQL Server 2016
Development Applications
1 33 (8.51%) Visual Studio
2 16 (4.12%) ERwin
3 14 (3.61%) JIRA
4 13 (3.35%) Git (software)
5 8 (2.06%) Octopus Deploy
5 8 (2.06%) Team Foundation Server
6 7 (1.80%) SQL Server Management Studio (SSMS)
7 6 (1.55%) Toad
8 5 (1.29%) TeamCity
8 5 (1.29%) Visual Studio Team System
9 3 (0.77%) ER Studio
10 2 (0.52%) Subversion
11 1 (0.26%) Ant
11 1 (0.26%) Flyway
11 1 (0.26%) IntelliJ
11 1 (0.26%) JUnit
11 1 (0.26%) Maven
11 1 (0.26%) RStudio
11 1 (0.26%) Selenium
11 1 (0.26%) SonarQube
General
1 122 (31.44%) Finance
2 48 (12.37%) Banking
3 26 (6.70%) Marketing
4 24 (6.19%) Games
5 17 (4.38%) Investment Banking
6 16 (4.12%) Retail
7 13 (3.35%) Advertising
8 9 (2.32%) Back Office
8 9 (2.32%) Manufacturing
9 8 (2.06%) General Ledger
10 6 (1.55%) Financial Institution
11 5 (1.29%) Corporate Banking
11 5 (1.29%) Front Office
11 5 (1.29%) Legal
12 2 (0.52%) Law
13 1 (0.26%) Automotive
13 1 (0.26%) Electronics
13 1 (0.26%) International Banking
13 1 (0.26%) Pharmaceutical
13 1 (0.26%) Telecoms
Job Titles
1 195 (50.26%) Developer
2 132 (34.02%) Business Intelligence Developer
3 70 (18.04%) SQL Developer
4 52 (13.40%) Data Warehouse Developer
5 50 (12.89%) Analyst
6 49 (12.63%) SQL BI Developer
7 44 (11.34%) Consultant
8 41 (10.57%) Architect
9 35 (9.02%) Business Developer
10 34 (8.76%) SSIS Developer
11 31 (7.99%) Data Architect
11 31 (7.99%) Senior Developer
12 29 (7.47%) SSRS Developer
13 28 (7.22%) Business Intelligence Consultant
13 28 (7.22%) SSAS Developer
14 27 (6.96%) Business Intelligence Analyst
15 23 (5.93%) DBA
15 23 (5.93%) Oracle Developer
16 22 (5.67%) Oracle Data Warehouse Developer
17 21 (5.41%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 74 (19.07%) MDX
2 38 (9.79%) .NET
3 25 (6.44%) Kafka
4 24 (6.19%) Web Services
5 23 (5.93%) XML
6 22 (5.67%) Oracle GoldenGate
7 18 (4.64%) JSON
8 7 (1.80%) ASP.NET
9 6 (1.55%) HTML
10 5 (1.29%) WPF
11 4 (1.03%) .NET Core
11 4 (1.03%) FIX Protocol
11 4 (1.03%) HTML5
11 4 (1.03%) Middleware
11 4 (1.03%) REST
12 3 (0.77%) SOAP
13 2 (0.52%) jQuery
13 2 (0.52%) LAMP
14 1 (0.26%) Hibernate
14 1 (0.26%) Spring
Miscellaneous
1 107 (27.58%) Analytical Skills
2 27 (6.96%) Replication
3 16 (4.12%) Data Structures
4 14 (3.61%) Greenfield Project
5 12 (3.09%) Computer Science
6 9 (2.32%) Hybrid Cloud
7 8 (2.06%) Clustering
7 8 (2.06%) Self-Motivation
8 7 (1.80%) Management Information System
9 6 (1.55%) Derivative
10 5 (1.29%) Reference Data
11 4 (1.03%) Equities
11 4 (1.03%) Fixed Income
11 4 (1.03%) Foreign Exchange (FX)
11 4 (1.03%) Mobile App
11 4 (1.03%) Online Games
11 4 (1.03%) Reinsurance
11 4 (1.03%) Tandem
12 3 (0.77%) Credit Risk
12 3 (0.77%) Data Protection Act
Operating Systems
1 15 (3.87%) Linux
2 13 (3.35%) Windows
2 13 (3.35%) Windows Server
3 8 (2.06%) Unix
4 4 (1.03%) Windows Server 2012
5 1 (0.26%) CentOS
5 1 (0.26%) Debian
Processes & Methodologies
1 321 (82.73%) Business Intelligence
2 233 (60.05%) ETL
3 147 (37.89%) Agile Software Development
4 112 (28.87%) Analytics
5 104 (26.80%) Data Modelling
6 97 (25.00%) Kimball Methodology
7 95 (24.48%) Dimensional Modelling
8 62 (15.98%) Visualisation
9 55 (14.18%) Problem-Solving
10 52 (13.40%) Performance Tuning
11 45 (11.60%) Data Analysis
12 44 (11.34%) Data Architecture
13 38 (9.79%) Data Science
14 36 (9.28%) ETL Development
15 35 (9.02%) Dashboard Development
16 34 (8.76%) Data Visualisation
16 34 (8.76%) Migration
17 32 (8.25%) Data Integration
18 30 (7.73%) Scrum
19 27 (6.96%) Machine Learning
Programming Languages
1 312 (80.41%) SQL
2 125 (32.22%) T-SQL
3 67 (17.27%) C#
4 50 (12.89%) PL/SQL
4 50 (12.89%) Python
5 27 (6.96%) R
6 25 (6.44%) Java
7 23 (5.93%) Data Analysis Expressions (DAX)
8 20 (5.15%) U-SQL
9 19 (4.90%) VBA
10 12 (3.09%) Go
10 12 (3.09%) PowerShell
11 7 (1.80%) JavaScript
11 7 (1.80%) Tcl
12 4 (1.03%) Perl
12 4 (1.03%) Ruby
12 4 (1.03%) XMLA
13 1 (0.26%) C++
13 1 (0.26%) Delphi
13 1 (0.26%) MATLAB
Qualifications
1 44 (11.34%) Degree
2 18 (4.64%) Microsoft Certification
3 8 (2.06%) Computer Science Degree
4 5 (1.29%) Master's Degree
5 2 (0.52%) Security Cleared
6 1 (0.26%) MCP
6 1 (0.26%) MCSE
6 1 (0.26%) PhD
6 1 (0.26%) SC Cleared
6 1 (0.26%) TOGAF Certification
Quality Assurance & Compliance
1 43 (11.08%) Data Quality
2 22 (5.67%) QA
3 8 (2.06%) SLA
4 4 (1.03%) EMIR
4 4 (1.03%) FATCA
4 4 (1.03%) MiFID
5 3 (0.77%) GDPR
System Software
1 2 (0.52%) Docker
2 1 (0.26%) VMware Infrastructure
Systems Management
1 8 (2.06%) Data Guard
2 5 (1.29%) Systems Management Server (SMS)
3 3 (0.77%) Terraform
4 2 (0.52%) Ansible
4 2 (0.52%) Consul
4 2 (0.52%) Kubernetes
5 1 (0.26%) Control-M
5 1 (0.26%) Hadoop YARN
5 1 (0.26%) HP Fortify
5 1 (0.26%) Nagios
5 1 (0.26%) Puppet
Vendors
1 192 (49.48%) Microsoft
2 90 (23.20%) Oracle
3 67 (17.27%) Tableau
4 44 (11.34%) Cognos
5 34 (8.76%) SAP
6 17 (4.38%) IBM
7 15 (3.87%) Informatica
8 10 (2.58%) MicroStrategy
9 9 (2.32%) Netezza
9 9 (2.32%) Tagetik
10 7 (1.80%) Hyperion
10 7 (1.80%) Talend
11 6 (1.55%) Alteryx
11 6 (1.55%) Teradata
11 6 (1.55%) TIBCO
12 5 (1.29%) EXASOL
12 5 (1.29%) JD Edwards
13 4 (1.03%) Cloudera
13 4 (1.03%) CQG
13 4 (1.03%) FIS