Period
to 22 September 2018

The following table provides summary statistics for permanent job vacancies 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 22 September 2018 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK
6 months to
22 Sep 2018
Same period 2017 Same period 2016
Rank 737 619 633
Rank change year-on-year -118 +14 -99
Permanent jobs citing OLAP 444 701 741
As % of all permanent IT jobs advertised in the UK 0.27% 0.40% 0.38%
As % of the Database & Business Intelligence category 0.90% 1.30% 1.28%
Number of salaries quoted 352 473 605
UK median annual salary £52,500 £50,000 £50,000
Median salary % change year-on-year +5.00% - -
10th Percentile £35,000 £32,500 £35,500
90th Percentile £77,500 £73,750 £78,250
UK excluding London median annual salary £45,000 £42,500 £47,500
% change year-on-year +5.88% -10.53% +18.75%

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 with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 49,463 54,014 57,723
As % of all permanent IT jobs advertised in the UK 29.71% 30.57% 29.76%
Number of salaries quoted 40,346 44,477 49,194
UK 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,250
UK excluding London median annual salary £45,000 £42,500 £41,500
% change year-on-year +5.88% +2.41% +3.75%

OLAP
Job Vacancy Trend

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

Job vacancy trend for OLAP in the UK

OLAP
Salary Trend

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

Salary trend for OLAP in the UK

OLAP
Salary Histogram

The salary distribution of IT jobs citing OLAP over the 6 months to 22 September 2018.

Salary histogram for OLAP in the UK

OLAP
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the UK over the 6 months to 22 September 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
England -113 430 £52,500 +5.00% 40
London -112 229 £62,500 +8.70% 18
UK excluding London -46 204 £45,000 +5.88% 25
North of England +56 74 £45,000 - 11
South East +2 60 £45,000 -10.00% 2
North West +28 41 £42,500 +6.25% 6
East of England -15 28 £55,000 +29.41% 3
Yorkshire +43 27 £52,500 +5.00% 3
Midlands -4 20 £42,500 +20.57% 5
South West -1 18 £40,000 - 1
East Midlands -15 16 £42,500 +20.57% 3
North East - 6 £37,000 - 2
West Midlands +18 4 £47,500 +43.94% 2
Scotland -9 4 £48,750 +21.88% 1

For the 6 months to 22 September 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 with a requirement for OLAP.

1 361 (81.31%) Business Intelligence
2 345 (77.70%) SQL
3 319 (71.85%) Data Warehouse
4 288 (64.86%) SQL Server Integration Services
5 278 (62.61%) ETL
6 274 (61.71%) SQL Server
7 265 (59.68%) SQL Server Reporting Services
8 238 (53.60%) SQL Server Analysis Services
9 229 (51.58%) Microsoft
10 163 (36.71%) Agile Software Development
11 155 (34.91%) Power BI
12 137 (30.86%) OLAP Cube
13 131 (29.50%) T-SQL
14 127 (28.60%) Analytics
15 123 (27.70%) Finance
16 122 (27.48%) Data Modelling
17 110 (24.77%) Oracle
17 110 (24.77%) Oracle OLAP
18 107 (24.10%) Analytical Skills
19 95 (21.40%) OLTP
20 94 (21.17%) Dimensional Modelling
20 94 (21.17%) Kimball Methodology
21 87 (19.59%) C#
22 80 (18.02%) Big Data
23 77 (17.34%) Microsoft Azure
23 77 (17.34%) Visualisation
24 70 (15.77%) MDX
24 70 (15.77%) Tableau
25 65 (14.64%) Relational Database
26 63 (14.19%) Microsoft Excel

OLAP
Co-occurring IT Skills 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 28 (6.31%) SAS
2 25 (5.63%) SharePoint
3 22 (4.95%) Apache Spark
4 11 (2.48%) Apache
5 8 (1.80%) Oracle Application Server
6 4 (0.90%) Confluence
6 4 (0.90%) Elasticsearch
6 4 (0.90%) IIS
6 4 (0.90%) Oracle SOA Suite
7 2 (0.45%) JBoss
7 2 (0.45%) Tomcat
7 2 (0.45%) WebLogic
7 2 (0.45%) WebSphere
8 1 (0.23%) Apache Pig
8 1 (0.23%) Apache Solr
8 1 (0.23%) OpenStack
8 1 (0.23%) SugarCRM
Applications
1 63 (14.19%) Microsoft Excel
2 13 (2.93%) Microsoft Office
3 8 (1.80%) MS Visio
4 3 (0.68%) SPSS
5 2 (0.45%) InfoPath
5 2 (0.45%) Spreadsheet
Business Applications
1 16 (3.60%) Cognos TM1
2 10 (2.25%) Dynamics AX
3 6 (1.35%) Cognos Planning
4 5 (1.13%) HFM
5 4 (0.90%) Maximo
5 4 (0.90%) SAP Forecasting and Replenishment
5 4 (0.90%) SAP Retail
5 4 (0.90%) SAP S/4HANA
5 4 (0.90%) SunGard GMI
6 3 (0.68%) Cognos Business Intelligence
6 3 (0.68%) NetSuite
6 3 (0.68%) SAP ERP
7 2 (0.45%) SAP Business One
8 1 (0.23%) Dynamics CRM
8 1 (0.23%) Dynamics NAV
8 1 (0.23%) Elite 3E
8 1 (0.23%) Hyperion Planning
8 1 (0.23%) SAP BPC
Cloud Services
1 77 (17.34%) Microsoft Azure
2 23 (5.18%) Azure Data Factory
3 18 (4.05%) Data Lake Analytics
4 16 (3.60%) Amazon AWS
5 11 (2.48%) PaaS
6 9 (2.03%) SaaS
7 5 (1.13%) Google Cloud Platform
8 4 (0.90%) IaaS
9 3 (0.68%) Amazon EMR
9 3 (0.68%) Amazon S3
10 2 (0.45%) Cloud Computing
10 2 (0.45%) GitHub
11 1 (0.23%) AWS Lambda
11 1 (0.23%) Boomi
11 1 (0.23%) Office 365
11 1 (0.23%) Serverless
Communications & Networking
1 9 (2.03%) SAN
2 6 (1.35%) SSL
3 1 (0.23%) DNS
3 1 (0.23%) Firewall
3 1 (0.23%) HTTP
Database & Business Intelligence
1 319 (71.85%) Data Warehouse
2 288 (64.86%) SQL Server Integration Services
3 274 (61.71%) SQL Server
4 265 (59.68%) SQL Server Reporting Services
5 238 (53.60%) SQL Server Analysis Services
6 155 (34.91%) Power BI
7 137 (30.86%) OLAP Cube
8 110 (24.77%) Oracle OLAP
9 95 (21.40%) OLTP
10 80 (18.02%) Big Data
11 65 (14.64%) Relational Database
12 56 (12.61%) Hadoop
13 53 (11.94%) Microsoft Analysis Services
14 43 (9.68%) QlikView
15 42 (9.46%) MySQL
16 39 (8.78%) SQL Server 2012
17 38 (8.56%) SQL Server 2014
18 35 (7.88%) Oracle Database
19 34 (7.66%) BusinessObjects
20 30 (6.76%) Star Schema
Development Applications
1 36 (8.11%) Visual Studio
2 18 (4.05%) ERwin
3 16 (3.60%) JIRA
4 15 (3.38%) Git (software)
5 14 (3.15%) SQL Server Management Studio (SSMS)
6 11 (2.48%) Team Foundation Server
7 8 (1.80%) Octopus Deploy
7 8 (1.80%) Visual Studio Team System
8 7 (1.58%) Toad
9 5 (1.13%) TeamCity
10 4 (0.90%) Jenkins
10 4 (0.90%) Maven
11 3 (0.68%) ER Studio
11 3 (0.68%) JUnit
12 2 (0.45%) Ant
12 2 (0.45%) Bitbucket
12 2 (0.45%) Gradle
13 1 (0.23%) Artifactory
13 1 (0.23%) Mockito
13 1 (0.23%) TestNG
General
1 123 (27.70%) Finance
2 44 (9.91%) Banking
3 32 (7.21%) Advertising
4 24 (5.41%) Marketing
5 20 (4.50%) Games
6 17 (3.83%) Retail
7 13 (2.93%) Investment Banking
8 11 (2.48%) Manufacturing
9 9 (2.03%) Back Office
10 8 (1.80%) General Ledger
11 7 (1.58%) Financial Institution
11 7 (1.58%) Front Office
12 6 (1.35%) Legal
13 5 (1.13%) Corporate Banking
14 4 (0.90%) Russian Language
15 3 (0.68%) Law
16 2 (0.45%) Pharmaceutical
17 1 (0.23%) Automotive
17 1 (0.23%) Electronics
17 1 (0.23%) Telecoms
Job Titles
1 219 (49.32%) Developer
2 141 (31.76%) Business Intelligence Developer
3 66 (14.86%) SQL Developer
4 51 (11.49%) Analyst
5 49 (11.04%) Architect
6 44 (9.91%) Consultant
6 44 (9.91%) Data Warehouse Developer
7 42 (9.46%) Business Developer
8 40 (9.01%) SQL BI Developer
9 37 (8.33%) Data Architect
10 33 (7.43%) Senior Developer
10 33 (7.43%) SSRS Developer
11 30 (6.76%) DBA
12 29 (6.53%) Business Intelligence Analyst
13 28 (6.31%) SSIS Developer
14 27 (6.08%) Business Intelligence Consultant
15 22 (4.95%) Senior Business Intelligence Developer
16 21 (4.73%) SQL Server Developer
16 21 (4.73%) SSAS Developer
17 19 (4.28%) Oracle Developer
Libraries, Frameworks & Software Standards
1 70 (15.77%) MDX
2 56 (12.61%) .NET
3 31 (6.98%) XML
4 29 (6.53%) Kafka
5 28 (6.31%) Web Services
6 27 (6.08%) JSON
7 20 (4.50%) WPF
8 18 (4.05%) Oracle GoldenGate
9 13 (2.93%) SOAP
10 9 (2.03%) ASP.NET
10 9 (2.03%) REST
11 7 (1.58%) HTML
12 6 (1.35%) WSDL
13 5 (1.13%) .NET Framework
14 4 (0.90%) AngularJS
14 4 (0.90%) Entity Framework
14 4 (0.90%) FIX Protocol
14 4 (0.90%) HTML5
14 4 (0.90%) Middleware
14 4 (0.90%) XSD
Miscellaneous
1 107 (24.10%) Analytical Skills
2 28 (6.31%) Replication
3 20 (4.50%) Computer Science
4 18 (4.05%) Data Structures
5 13 (2.93%) Self-Motivation
6 11 (2.48%) Hybrid Cloud
7 10 (2.25%) Management Information System
8 9 (2.03%) Greenfield Project
9 8 (1.80%) Clustering
9 8 (1.80%) Enterprise Software
9 8 (1.80%) Reference Data
10 7 (1.58%) Data Centre
10 7 (1.58%) Fintech
10 7 (1.58%) Tandem
11 6 (1.35%) Derivative
11 6 (1.35%) Mobile App
12 4 (0.90%) Equities
12 4 (0.90%) Fixed Income
12 4 (0.90%) Online Games
12 4 (0.90%) Taxonomies
Operating Systems
1 21 (4.73%) Linux
2 14 (3.15%) Windows
3 12 (2.70%) Windows Server
4 11 (2.48%) Unix
5 4 (0.90%) Windows Server 2012
6 1 (0.23%) CentOS
6 1 (0.23%) Debian
Processes & Methodologies
1 361 (81.31%) Business Intelligence
2 278 (62.61%) ETL
3 163 (36.71%) Agile Software Development
4 127 (28.60%) Analytics
5 122 (27.48%) Data Modelling
6 94 (21.17%) Dimensional Modelling
6 94 (21.17%) Kimball Methodology
7 77 (17.34%) Visualisation
8 60 (13.51%) Problem-Solving
9 58 (13.06%) Performance Tuning
10 57 (12.84%) Data Architecture
11 54 (12.16%) Data Analysis
12 47 (10.59%) Data Science
13 44 (9.91%) Data Analytics
13 44 (9.91%) Data Visualisation
14 42 (9.46%) Data Integration
15 36 (8.11%) Change Management
16 35 (7.88%) Migration
17 29 (6.53%) Machine Learning
18 28 (6.31%) Dashboard Development
Programming Languages
1 345 (77.70%) SQL
2 131 (29.50%) T-SQL
3 87 (19.59%) C#
4 58 (13.06%) Python
5 50 (11.26%) PL/SQL
6 41 (9.23%) Java
7 26 (5.86%) Data Analysis Expressions (DAX)
8 22 (4.95%) R
9 21 (4.73%) VBA
10 19 (4.28%) PowerShell
11 18 (4.05%) U-SQL
12 12 (2.70%) Go
13 10 (2.25%) Scala
14 9 (2.03%) JavaScript
15 7 (1.58%) Perl
15 7 (1.58%) Tcl
16 5 (1.13%) C
17 4 (0.90%) MATLAB
17 4 (0.90%) Ruby
17 4 (0.90%) VB.NET
Qualifications
1 57 (12.84%) Degree
2 17 (3.83%) Microsoft Certification
3 10 (2.25%) Computer Science Degree
4 6 (1.35%) TOGAF Certification
5 5 (1.13%) Master's Degree
5 5 (1.13%) Security Cleared
6 4 (0.90%) SC Cleared
7 2 (0.45%) PhD
8 1 (0.23%) MCP
8 1 (0.23%) MCSD
8 1 (0.23%) MCSE
8 1 (0.23%) Microsoft Certified Architect
8 1 (0.23%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 42 (9.46%) Data Quality
2 21 (4.73%) QA
3 9 (2.03%) SLA
4 4 (0.90%) EMIR
4 4 (0.90%) FATCA
4 4 (0.90%) GDPR
4 4 (0.90%) MiFID
5 3 (0.68%) EFQM
System Software
1 7 (1.58%) HDFS
2 6 (1.35%) Apache Flume
3 4 (0.90%) Docker
4 1 (0.23%) Apache ZooKeeper
4 1 (0.23%) VMware Infrastructure
Systems Management
1 9 (2.03%) Systems Management Server (SMS)
2 8 (1.80%) Data Guard
3 4 (0.90%) Hadoop YARN
3 4 (0.90%) Oozie
4 3 (0.68%) Control-M
4 3 (0.68%) Terraform
5 2 (0.45%) Ansible
5 2 (0.45%) Consul
5 2 (0.45%) Kubernetes
6 1 (0.23%) HP Fortify
6 1 (0.23%) Kibana
6 1 (0.23%) Nagios
6 1 (0.23%) Puppet
6 1 (0.23%) Single Sign-On
Vendors
1 229 (51.58%) Microsoft
2 110 (24.77%) Oracle
3 70 (15.77%) Tableau
4 46 (10.36%) Cognos
5 42 (9.46%) SAP
6 20 (4.50%) IBM
7 19 (4.28%) Informatica
8 16 (3.60%) MicroStrategy
9 10 (2.25%) Netezza
10 9 (2.03%) Tagetik
10 9 (2.03%) Talend
11 8 (1.80%) Cloudera
11 8 (1.80%) Teradata
12 7 (1.58%) Hyperion
13 6 (1.35%) Alteryx
13 6 (1.35%) Cisco
13 6 (1.35%) TIBCO
14 5 (1.13%) EXASOL
14 5 (1.13%) Salesforce.com
15 4 (0.90%) FIS