Period
to 24 June 2019

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

Online Analytical Processing (OLAP)
UK > England
6 months to
24 Jun 2019
Same period 2018 Same period 2017
Rank 707 708 634
Rank change year-on-year +1 -74 +14
Permanent jobs citing OLAP 354 502 597
As % of all permanent IT jobs advertised in England 0.27% 0.31% 0.37%
As % of the Database & Business Intelligence category 0.96% 1.01% 1.20%
Number of salaries quoted 298 416 475
England median annual salary £55,000 £48,750 £52,500
Median salary % change year-on-year +12.82% -7.14% -
10th Percentile £37,500 £32,000 £32,700
90th Percentile £95,000 £77,500 £72,500
UK median annual salary £55,000 £50,000 £50,000
% change year-on-year +10.00% - -1.48%

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 36,923 49,881 49,731
As % of all permanent IT jobs advertised in England 27.71% 30.69% 30.50%
Number of salaries quoted 30,460 40,981 42,494
England median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £31,250 £29,750
90th Percentile £86,250 £81,250 £77,500
UK median annual salary £51,500 £50,000 £47,500
% change year-on-year +3.00% +5.26% -

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 24 June 2019.

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 24 June 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
London +17 177 £60,000 +9.09% 2
Midlands +71 62 £43,250 +23.57% 1
South East -23 49 £55,000 +22.22% 1
West Midlands +59 44 £40,000 +17.65%
North of England -13 41 £45,000 -5.26%
North West +11 26 £45,000 -5.26%
East Midlands +27 18 £46,250 +32.14% 1
East of England +74 14 £55,000 +15.79%
Yorkshire -3 14 £42,500 -10.53%
South West -9 11 £62,500 +56.25%
North East +10 1 £35,000 -4.11%
OLAP
UK

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

1 261 (73.73%) SQL
2 252 (71.19%) Business Intelligence
3 240 (67.80%) Data Warehouse
4 235 (66.38%) SQL Server
5 218 (61.58%) SQL Server Integration Services
6 196 (55.37%) SQL Server Analysis Services
7 187 (52.82%) SQL Server Reporting Services
8 162 (45.76%) Microsoft
9 157 (44.35%) ETL
10 141 (39.83%) T-SQL
11 126 (35.59%) Agile Software Development
12 106 (29.94%) Power BI
12 106 (29.94%) Power Platform
13 94 (26.55%) Analytics
14 92 (25.99%) Degree
15 90 (25.42%) Microsoft Azure
16 83 (23.45%) C#
17 81 (22.88%) OLAP Cube
18 76 (21.47%) Finance
19 73 (20.62%) Data Modelling
20 70 (19.77%) Analytical Skills
21 68 (19.21%) .NET
22 61 (17.23%) MDX
23 53 (14.97%) Microsoft Excel
24 49 (13.84%) DevOps
24 49 (13.84%) Tableau
25 47 (13.28%) Visualisation
25 47 (13.28%) SQL Server 2016
26 45 (12.71%) Kimball Methodology
27 44 (12.43%) Big Data

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 25 (7.06%) SharePoint
2 22 (6.21%) SAS
3 15 (4.24%) Apache Spark
3 15 (4.24%) WebLogic
4 14 (3.95%) IIS
5 4 (1.13%) Apache
6 2 (0.56%) SharePoint 2010
7 1 (0.28%) Confluence
7 1 (0.28%) GemFire
7 1 (0.28%) NServiceBus
7 1 (0.28%) Oracle SOA Suite
7 1 (0.28%) Oracle Workflow
Applications
1 53 (14.97%) Microsoft Excel
2 22 (6.21%) Microsoft Project
3 16 (4.52%) Microsoft PowerPoint
4 11 (3.11%) Microsoft Office
5 1 (0.28%) SPSS
Business Applications
1 12 (3.39%) Cognos TM1
2 5 (1.41%) Cognos Planning
2 5 (1.41%) HFM
3 4 (1.13%) Dynamics AX
4 3 (0.85%) Cognos Business Intelligence
4 3 (0.85%) NetSuite
5 2 (0.56%) Dynamics CRM
5 2 (0.56%) Infor M3
5 2 (0.56%) Remedy ITSM
6 1 (0.28%) Dynamics GP
6 1 (0.28%) Oracle EBS
6 1 (0.28%) Oracle EBS R12
6 1 (0.28%) Oracle Financials
Cloud Services
1 106 (29.94%) Power Platform
2 90 (25.42%) Microsoft Azure
3 39 (11.02%) Amazon AWS
4 20 (5.65%) Serverless
5 14 (3.95%) Data Lake Analytics
5 14 (3.95%) PaaS
5 14 (3.95%) SaaS
6 8 (2.26%) Cloud Computing
7 6 (1.69%) Azure Data Factory
8 5 (1.41%) Amazon S3
9 3 (0.85%) Amazon EMR
9 3 (0.85%) Dynamics 365
9 3 (0.85%) OpenShift
10 2 (0.56%) Office 365
11 1 (0.28%) Azure Stack
11 1 (0.28%) Google Analytics
11 1 (0.28%) IaaS
11 1 (0.28%) PowerApps
Communications & Networking
1 3 (0.85%) SAN
2 1 (0.28%) CTI
2 1 (0.28%) LAN
2 1 (0.28%) PBX
2 1 (0.28%) VoIP
2 1 (0.28%) WAN
Database & Business Intelligence
1 240 (67.80%) Data Warehouse
2 235 (66.38%) SQL Server
3 218 (61.58%) SQL Server Integration Services
4 196 (55.37%) SQL Server Analysis Services
5 187 (52.82%) SQL Server Reporting Services
6 106 (29.94%) Power BI
7 81 (22.88%) OLAP Cube
8 47 (13.28%) SQL Server 2016
9 44 (12.43%) Big Data
9 44 (12.43%) Relational Database
10 35 (9.89%) OLTP
11 33 (9.32%) Microsoft Analysis Services
12 31 (8.76%) Oracle OLAP
13 29 (8.19%) BusinessObjects
14 28 (7.91%) SQL Server 2012
15 23 (6.50%) Data Lake
15 23 (6.50%) MongoDB
16 22 (6.21%) Star Schema
17 21 (5.93%) Azure SQL Database
17 21 (5.93%) QlikView
Development Applications
1 28 (7.91%) Team Foundation Server
2 23 (6.50%) Visual Studio
3 16 (4.52%) SQL Server Management Studio (SSMS)
4 4 (1.13%) Toad
5 3 (0.85%) Git (software)
6 2 (0.56%) ERwin
6 2 (0.56%) VSS/SourceSafe
7 1 (0.28%) Artifactory
7 1 (0.28%) Jenkins
7 1 (0.28%) JIRA
7 1 (0.28%) Maven
7 1 (0.28%) Sonatype Nexus
7 1 (0.28%) Subversion
General
1 76 (21.47%) Finance
2 19 (5.37%) Legal
3 18 (5.08%) Retail
4 13 (3.67%) Banking
5 8 (2.26%) Automotive
5 8 (2.26%) Games
5 8 (2.26%) Investment Banking
6 6 (1.69%) Front Office
6 6 (1.69%) Law
7 5 (1.41%) Marketing
8 4 (1.13%) Manufacturing
9 3 (0.85%) Advertising
9 3 (0.85%) Pharmaceutical
10 1 (0.28%) Aerospace
10 1 (0.28%) Back Office
10 1 (0.28%) Electronics
10 1 (0.28%) French Language
10 1 (0.28%) German Language
10 1 (0.28%) Polish Language
10 1 (0.28%) Telecoms
Job Titles
1 224 (63.28%) Developer
2 125 (35.31%) Business Intelligence Developer
3 102 (28.81%) SQL Developer
4 65 (18.36%) SQL BI Developer
5 51 (14.41%) SQL Server Developer
6 40 (11.30%) SQL Server BI Developer
7 39 (11.02%) Senior Developer
8 34 (9.60%) Data Warehouse Developer
9 33 (9.32%) SSRS Developer
10 31 (8.76%) SSIS Developer
11 27 (7.63%) Analyst
12 26 (7.34%) T-SQL Developer
13 23 (6.50%) Business Developer
14 22 (6.21%) C# Developer
15 21 (5.93%) .NET Developer
15 21 (5.93%) C# .NET Developer
16 20 (5.65%) Consultant
17 19 (5.37%) Database Developer
17 19 (5.37%) Senior Business Intelligence Developer
17 19 (5.37%) Senior SQL Developer
Libraries, Frameworks & Software Standards
1 68 (19.21%) .NET
2 61 (17.23%) MDX
3 32 (9.04%) Web Services
4 20 (5.65%) .NET Core
4 20 (5.65%) WCF
5 12 (3.39%) HTML
5 12 (3.39%) JSON
5 12 (3.39%) XML
6 11 (3.11%) CSS
6 11 (3.11%) jQuery
6 11 (3.11%) Twitter Bootstrap
7 10 (2.82%) Ajax
7 10 (2.82%) ASP.NET
8 7 (1.98%) Kafka
9 5 (1.41%) LAMP
10 3 (0.85%) ASP.NET MVC
10 3 (0.85%) Redux
10 3 (0.85%) Spring
11 2 (0.56%) AngularJS
11 2 (0.56%) LAPP Stack
Miscellaneous
1 70 (19.77%) Analytical Skills
2 27 (7.63%) Self-Motivation
3 21 (5.93%) Driving Licence
4 20 (5.65%) Greenfield Project
5 16 (4.52%) Data Structures
6 14 (3.95%) Hedge funds
7 13 (3.67%) Management Information System
8 11 (3.11%) Virtual Team
9 10 (2.82%) Algorithms
10 9 (2.54%) Replication
11 8 (2.26%) NHS
12 7 (1.98%) Cloud Native
13 6 (1.69%) EPoS
14 5 (1.41%) Market Risk
14 5 (1.41%) User Experience
15 3 (0.85%) Credit Risk
16 2 (0.56%) CMDB
16 2 (0.56%) N-Tier
16 2 (0.56%) Public Cloud
16 2 (0.56%) RIA
Operating Systems
1 15 (4.24%) Solaris
2 11 (3.11%) Linux
3 6 (1.69%) Windows
4 2 (0.56%) Windows Server
5 1 (0.28%) Unix
Processes & Methodologies
1 252 (71.19%) Business Intelligence
2 157 (44.35%) ETL
3 126 (35.59%) Agile Software Development
4 94 (26.55%) Analytics
5 73 (20.62%) Data Modelling
6 49 (13.84%) DevOps
7 47 (13.28%) Visualisation
8 45 (12.71%) Kimball Methodology
9 41 (11.58%) Dimensional Modelling
10 40 (11.30%) Software Engineering
11 38 (10.73%) Computer Science
12 36 (10.17%) Mathematics
12 36 (10.17%) Problem-Solving
12 36 (10.17%) Statistics
13 35 (9.89%) Data Analysis
13 35 (9.89%) Data Management
14 33 (9.32%) Performance Tuning
14 33 (9.32%) Scrum
15 32 (9.04%) Project Management
16 31 (8.76%) Data Analytics
Programming Languages
1 261 (73.73%) SQL
2 141 (39.83%) T-SQL
3 83 (23.45%) C#
4 43 (12.15%) Data Analysis Expressions (DAX)
5 31 (8.76%) Python
6 25 (7.06%) Java
7 19 (5.37%) VBA
8 16 (4.52%) JavaScript
9 15 (4.24%) SAS Macro
10 13 (3.67%) PowerShell
10 13 (3.67%) R
11 9 (2.54%) PL/SQL
12 8 (2.26%) VB.NET
13 6 (1.69%) Shell Script
14 4 (1.13%) Go
14 4 (1.13%) Scala
15 3 (0.85%) ES6
15 3 (0.85%) TypeScript
16 2 (0.56%) HiveQL
16 2 (0.56%) VB
Qualifications
1 92 (25.99%) Degree
2 15 (4.24%) Microsoft Certification
3 7 (1.98%) Computer Science Degree
4 6 (1.69%) Numerate Degree
5 5 (1.41%) PhD
6 4 (1.13%) MCSE
6 4 (1.13%) Postgraduate
7 2 (0.56%) ACCA
7 2 (0.56%) AWS Certification
7 2 (0.56%) CIMA
7 2 (0.56%) SC Cleared
7 2 (0.56%) Security Cleared
8 1 (0.28%) CCAB
8 1 (0.28%) CCNA
8 1 (0.28%) Cisco Certification
8 1 (0.28%) Master's Degree
Quality Assurance & Compliance
1 39 (11.02%) Data Quality
2 14 (3.95%) QA
3 11 (3.11%) SLA
4 5 (1.41%) GDPR
5 2 (0.56%) COBIT
System Software
1 24 (6.78%) Docker
2 6 (1.69%) Apache Flume
3 4 (1.13%) HDFS
4 2 (0.56%) VMware Infrastructure
5 1 (0.28%) Apache ZooKeeper
Systems Management
1 4 (1.13%) Hadoop YARN
1 4 (1.13%) Kubernetes
2 2 (0.56%) Ansible
2 2 (0.56%) Oozie
3 1 (0.28%) WebSphere Cast Iron
Vendors
1 162 (45.76%) Microsoft
2 49 (13.84%) Tableau
3 32 (9.04%) Oracle
4 20 (5.65%) Cognos
5 14 (3.95%) Hyperion
5 14 (3.95%) Talend
6 12 (3.39%) Tagetik
7 11 (3.11%) Informatica
8 8 (2.26%) Alteryx
8 8 (2.26%) SAP
9 6 (1.69%) IBM
9 6 (1.69%) MicroStrategy
9 6 (1.69%) Teradata
10 5 (1.41%) Cloudera
11 4 (1.13%) Databricks
11 4 (1.13%) HP
11 4 (1.13%) Vertica
12 3 (0.85%) Greenplum
12 3 (0.85%) JD Edwards
13 2 (0.56%) RedGate