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

Online Analytical Processing (OLAP)
UK > England
6 months to
18 Feb 2019
Same period 2018 Same period 2017
Rank 781 697 671
Rank change year-on-year -84 -26 -106
Permanent jobs citing OLAP 309 519 544
As % of all permanent IT jobs advertised in England 0.22% 0.32% 0.33%
As % of the Database & Business Intelligence category 0.77% 1.04% 1.11%
Number of salaries quoted 243 407 454
England median annual salary £53,500 £48,500 £50,000
Median salary % change year-on-year +10.31% -3.00% -
10th Percentile £37,500 £31,250 £35,000
90th Percentile £76,250 £70,000 £72,125
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 39,919 50,034 49,207
As % of all permanent IT jobs advertised in England 28.53% 30.68% 29.86%
Number of salaries quoted 33,059 42,010 42,364
England median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £30,500 £29,750
90th Percentile £85,000 £78,750 £77,500
UK median annual salary £52,500 £48,500 £47,500
% change year-on-year +8.25% +2.11% +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 February 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 18 February 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 -16 185 £60,000 +9.09% 15
South East -9 40 £55,000 +4.76% 10
North of England -12 39 £42,500 - 11
Midlands +15 28 £50,000 +47.06% 10
North West +21 24 £42,000 -6.67% 7
Yorkshire +21 14 £52,500 +75.00% 3
East Midlands +17 14 £42,500 +51.79% 6
West Midlands +11 14 £57,500 +35.29% 4
East of England +30 10 £56,250 +18.42% 1
South West 0 7 £52,000 +30.00% 2
North East +10 1 £37,500 +5.35% 1
OLAP
UK

For the 6 months to 18 February 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 251 (81.23%) SQL
2 235 (76.05%) Business Intelligence
3 221 (71.52%) Data Warehouse
4 190 (61.49%) SQL Server
5 179 (57.93%) SQL Server Integration Services
6 176 (56.96%) SQL Server Analysis Services
7 175 (56.63%) ETL
8 155 (50.16%) SQL Server Reporting Services
9 135 (43.69%) Microsoft
10 121 (39.16%) Analytics
11 118 (38.19%) T-SQL
12 112 (36.25%) Agile Software Development
13 111 (35.92%) Power BI
14 107 (34.63%) OLAP Cube
15 84 (27.18%) Microsoft Azure
16 79 (25.57%) Data Modelling
17 74 (23.95%) Analytical Skills
18 70 (22.65%) Tableau
19 69 (22.33%) Kimball Methodology
19 69 (22.33%) C#
20 61 (19.74%) Finance
21 60 (19.42%) Oracle
21 60 (19.42%) Oracle OLAP
21 60 (19.42%) Dimensional Modelling
22 57 (18.45%) Visualisation
23 54 (17.48%) .NET
24 52 (16.83%) MDX
24 52 (16.83%) Microsoft Analysis Services
24 52 (16.83%) Data Quality
25 48 (15.53%) Performance Tuning

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 42 (13.59%) SharePoint
2 32 (10.36%) SAS
3 21 (6.80%) Apache Spark
4 15 (4.85%) WebLogic
5 14 (4.53%) IIS
6 11 (3.56%) Apache
7 4 (1.29%) Oracle SOA Suite
8 2 (0.65%) Apache Pig
8 2 (0.65%) Apache Solr
8 2 (0.65%) Jupyter
8 2 (0.65%) NServiceBus
8 2 (0.65%) SharePoint 2010
9 1 (0.32%) GemFire
Applications
1 48 (15.53%) Microsoft Excel
2 12 (3.88%) Microsoft Project
3 9 (2.91%) Microsoft Office
4 4 (1.29%) Microsoft PowerPoint
5 3 (0.97%) SPSS
Business Applications
1 18 (5.83%) Cognos TM1
2 12 (3.88%) Dynamics AX
3 6 (1.94%) Cognos Planning
4 5 (1.62%) HFM
5 4 (1.29%) Cognos Business Intelligence
5 4 (1.29%) NetSuite
6 2 (0.65%) SAP Business One
7 1 (0.32%) Cognos Controller
7 1 (0.32%) Dynamics CRM
7 1 (0.32%) Elite 3E
Cloud Services
1 84 (27.18%) Microsoft Azure
2 34 (11.00%) Amazon AWS
3 18 (5.83%) Azure Data Factory
3 18 (5.83%) Data Lake Analytics
4 12 (3.88%) SaaS
5 9 (2.91%) Cloud Computing
5 9 (2.91%) PaaS
6 7 (2.27%) Amazon EMR
6 7 (2.27%) Amazon S3
7 6 (1.94%) GitHub
8 5 (1.62%) Azure Machine Learning
9 4 (1.29%) Office 365
10 2 (0.65%) Apigee
10 2 (0.65%) Azure Active Directory
10 2 (0.65%) Boomi
10 2 (0.65%) IaaS
10 2 (0.65%) iPaaS
11 1 (0.32%) Dynamics 365
11 1 (0.32%) Google Analytics
Communications & Networking
1 2 (0.65%) Firewall
1 2 (0.65%) LAN
1 2 (0.65%) VoIP
1 2 (0.65%) WAN
2 1 (0.32%) CTI
2 1 (0.32%) PBX
2 1 (0.32%) WebEx
Database & Business Intelligence
1 221 (71.52%) Data Warehouse
2 190 (61.49%) SQL Server
3 179 (57.93%) SQL Server Integration Services
4 176 (56.96%) SQL Server Analysis Services
5 155 (50.16%) SQL Server Reporting Services
6 111 (35.92%) Power BI
7 107 (34.63%) OLAP Cube
8 60 (19.42%) Oracle OLAP
9 52 (16.83%) Microsoft Analysis Services
10 46 (14.89%) Big Data
11 45 (14.56%) Azure SQL Database
12 37 (11.97%) SQL Server 2016
13 34 (11.00%) OLTP
14 32 (10.36%) QlikView
14 32 (10.36%) Relational Database
15 28 (9.06%) Hadoop
16 26 (8.41%) BusinessObjects
17 25 (8.09%) SQL Server 2008
18 24 (7.77%) Star Schema
19 23 (7.44%) Snowflake Schema
Development Applications
1 14 (4.53%) SQL Server Management Studio (SSMS)
2 10 (3.24%) Visual Studio
3 7 (2.27%) Git (software)
4 4 (1.29%) Team Foundation Server
4 4 (1.29%) Toad
5 3 (0.97%) ERwin
5 3 (0.97%) Visual Studio Team System
6 2 (0.65%) ER Studio
6 2 (0.65%) Jenkins
6 2 (0.65%) Maven
6 2 (0.65%) Subversion
7 1 (0.32%) Octopus Deploy
7 1 (0.32%) TeamCity
General
1 61 (19.74%) Finance
2 34 (11.00%) Retail
3 17 (5.50%) Banking
3 17 (5.50%) Marketing
4 14 (4.53%) Games
5 13 (4.21%) Legal
6 12 (3.88%) Investment Banking
7 11 (3.56%) Manufacturing
8 7 (2.27%) Advertising
9 6 (1.94%) Financial Institution
10 4 (1.29%) Automotive
11 3 (0.97%) Back Office
11 3 (0.97%) Corporate Banking
12 2 (0.65%) Billing
13 1 (0.32%) French Language
13 1 (0.32%) Front Office
13 1 (0.32%) German Language
13 1 (0.32%) Law
13 1 (0.32%) Polish Language
13 1 (0.32%) Russian Language
Job Titles
1 183 (59.22%) Developer
2 105 (33.98%) Business Intelligence Developer
3 77 (24.92%) SQL Developer
4 56 (18.12%) SQL BI Developer
5 42 (13.59%) SSIS Developer
6 40 (12.94%) Data Warehouse Developer
7 31 (10.03%) Analyst
8 30 (9.71%) Senior Developer
8 30 (9.71%) SSRS Developer
9 28 (9.06%) Consultant
10 24 (7.77%) SSAS Developer
11 23 (7.44%) SQL Server Developer
12 21 (6.80%) Business Developer
12 21 (6.80%) SQL Server BI Developer
13 19 (6.15%) Data Engineer
14 18 (5.83%) Architect
14 18 (5.83%) T-SQL Developer
15 16 (5.18%) Microsoft Consultant
15 16 (5.18%) SAS Developer
16 15 (4.85%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 54 (17.48%) .NET
2 52 (16.83%) MDX
3 22 (7.12%) Kafka
4 14 (4.53%) Web Services
5 13 (4.21%) LAMP
6 12 (3.88%) Oracle GoldenGate
7 6 (1.94%) ASP.NET
7 6 (1.94%) LAPP Stack
7 6 (1.94%) XML
8 5 (1.62%) JSON
9 4 (1.29%) jQuery
10 3 (0.97%) AngularJS
10 3 (0.97%) HTML
11 2 (0.65%) .NET Framework
11 2 (0.65%) Anaconda
11 2 (0.65%) Apache NiFi
11 2 (0.65%) Apache Tez
11 2 (0.65%) ASP.NET MVC
11 2 (0.65%) OAuth
11 2 (0.65%) Twitter Bootstrap
Miscellaneous
1 74 (23.95%) Analytical Skills
2 19 (6.15%) Data Structures
3 17 (5.50%) Greenfield Project
4 16 (5.18%) Replication
5 10 (3.24%) Management Information System
6 6 (1.94%) Self-Motivation
7 5 (1.62%) EPoS
7 5 (1.62%) Market Risk
8 4 (1.29%) Public Cloud
9 3 (0.97%) Hedge funds
9 3 (0.97%) Mobile App
9 3 (0.97%) Renewable Energy
10 2 (0.65%) Cloud Native
10 2 (0.65%) Enterprise Software
10 2 (0.65%) NHS
10 2 (0.65%) PMI
10 2 (0.65%) RIA
10 2 (0.65%) User Experience
10 2 (0.65%) Virtual Team
11 1 (0.32%) Derivative
Operating Systems
1 15 (4.85%) Solaris
2 14 (4.53%) Linux
3 3 (0.97%) Windows
4 2 (0.65%) Windows Server
Processes & Methodologies
1 235 (76.05%) Business Intelligence
2 175 (56.63%) ETL
3 121 (39.16%) Analytics
4 112 (36.25%) Agile Software Development
5 79 (25.57%) Data Modelling
6 69 (22.33%) Kimball Methodology
7 60 (19.42%) Dimensional Modelling
8 57 (18.45%) Visualisation
9 48 (15.53%) Performance Tuning
10 34 (11.00%) Business Analysis
11 33 (10.68%) Data Science
11 33 (10.68%) Problem-Solving
12 30 (9.71%) Machine Learning
13 29 (9.39%) ETL Development
13 29 (9.39%) Scrum
14 27 (8.74%) Data Analytics
15 26 (8.41%) Data Analysis
16 25 (8.09%) Dashboard Development
16 25 (8.09%) Data Integration
17 24 (7.77%) Statistics
Programming Languages
1 251 (81.23%) SQL
2 118 (38.19%) T-SQL
3 69 (22.33%) C#
4 47 (15.21%) Python
5 29 (9.39%) Java
6 28 (9.06%) R
7 20 (6.47%) PL/SQL
8 17 (5.50%) U-SQL
9 16 (5.18%) VBA
10 13 (4.21%) PowerShell
10 13 (4.21%) SAS Macro
10 13 (4.21%) Shell Script
11 11 (3.56%) Data Analysis Expressions (DAX)
12 7 (2.27%) HiveQL
13 6 (1.94%) JavaScript
13 6 (1.94%) Scala
14 3 (0.97%) C++
14 3 (0.97%) PHP
14 3 (0.97%) Tcl
14 3 (0.97%) VB
Qualifications
1 40 (12.94%) Degree
2 17 (5.50%) Microsoft Certification
3 4 (1.29%) Postgraduate
4 3 (0.97%) Computer Science Degree
5 2 (0.65%) AWS Certification
5 2 (0.65%) CEH
5 2 (0.65%) PMI Certification
5 2 (0.65%) TOGAF Certification
6 1 (0.32%) ACCA
6 1 (0.32%) CCNA
6 1 (0.32%) CIMA
6 1 (0.32%) Cisco Certification
Quality Assurance & Compliance
1 52 (16.83%) Data Quality
2 17 (5.50%) QA
3 14 (4.53%) SLA
4 7 (2.27%) GDPR
System Software
1 13 (4.21%) Apache Flume
2 7 (2.27%) HDFS
3 2 (0.65%) Active Directory
3 2 (0.65%) Docker
Systems Management
1 7 (2.27%) Hadoop YARN
2 2 (0.65%) Ambari
2 2 (0.65%) Ansible
2 2 (0.65%) Consul
2 2 (0.65%) Kubernetes
2 2 (0.65%) Opscode Chef
2 2 (0.65%) Puppet
2 2 (0.65%) Salt
2 2 (0.65%) Terraform
Vendors
1 135 (43.69%) Microsoft
2 70 (22.65%) Tableau
3 60 (19.42%) Oracle
4 31 (10.03%) Cognos
5 21 (6.80%) Talend
6 20 (6.47%) Informatica
7 16 (5.18%) IBM
7 16 (5.18%) Teradata
8 13 (4.21%) Cloudera
9 11 (3.56%) Alteryx
9 11 (3.56%) Hyperion
10 9 (2.91%) MicroStrategy
11 8 (2.59%) SAP
12 7 (2.27%) Tagetik
13 6 (1.94%) Greenplum
14 5 (1.62%) JD Edwards
15 4 (1.29%) Cisco
16 3 (0.97%) Databricks
16 3 (0.97%) RedGate
16 3 (0.97%) TIBCO