Period
to 18 October 2017

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

Online Analytical Processing (OLAP)
UK
6 months to
18 Oct 2017
Same period 2016 Same period 2015
Rank 603 627 522
Rank change year-on-year +24 -105 -59
Permanent jobs citing OLAP 675 705 1113
As % of all permanent IT jobs advertised in the UK 0.39% 0.37% 0.51%
As % of the Database & Business Intelligence category 1.27% 1.24% 1.62%
Number of salaries quoted 443 570 875
UK median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% -5.00%
10th Percentile £32,500 £35,000 £32,000
90th Percentile £73,750 £78,750 £73,750
UK excluding London median annual salary £43,486 £47,500 £42,500
% change year-on-year -8.45% +11.76% -

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 53272 56785 68769
As % of all permanent IT jobs advertised in the UK 30.50% 29.62% 31.57%
Number of salaries quoted 43787 48331 58015
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% -
10th Percentile £30,000 £28,750 £28,000
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +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 18 October 2017.

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 18 October 2017. 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 +68 661 £50,000 - 41
London +103 416 £60,000 -7.69% 22
UK excluding London -68 254 £43,486 -8.45% 20
South East 0 65 £50,000 - 3
Midlands +21 53 £30,000 -36.84% 2
East of England +21 51 £40,000 -17.95% 6
North of England -44 38 £45,000 - 7
South West +20 34 £40,000 -20.00% 1
East Midlands +57 28 £29,000 -42.00% 1
West Midlands +4 25 £36,500 -23.16% 1
Yorkshire -12 20 £50,000 +11.11% 1
North West -20 18 £40,000 -11.11% 6
Scotland -23 12 £41,250 -25.00%
Wales +3 2 £60,000 +71.43% 1

For the 6 months to 18 October 2017, IT jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for OLAP.

1 561 (83.11%) SQL
2 486 (72.00%) Data Warehouse
3 417 (61.78%) Business Intelligence
4 407 (60.30%) SQL Server
5 377 (55.85%) ETL
6 356 (52.74%) SQL Server Integration Services
7 338 (50.07%) SQL Server Analysis Services
8 297 (44.00%) SQL Server Reporting Services
9 254 (37.63%) Microsoft
10 234 (34.67%) Agile Software Development
11 231 (34.22%) Finance
12 214 (31.70%) T-SQL
13 203 (30.07%) Oracle
13 203 (30.07%) Oracle OLAP
14 199 (29.48%) OLAP Cube
15 187 (27.70%) Analytics
16 180 (26.67%) Analytical Skills
17 165 (24.44%) MDX
18 162 (24.00%) Kimball Methodology
19 160 (23.70%) PL/SQL
20 154 (22.81%) Java
21 150 (22.22%) Power BI
22 141 (20.89%) OLTP
23 139 (20.59%) Banking
24 137 (20.30%) Retail
25 135 (20.00%) Dimensional Modelling
26 129 (19.11%) Python
27 125 (18.52%) Relational Database
28 124 (18.37%) Data Modelling
29 116 (17.19%) Data Analytics

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 52 (7.70%) SharePoint
2 21 (3.11%) SAS
3 17 (2.52%) Apache Spark
4 12 (1.78%) Elasticsearch
5 10 (1.48%) IIS
6 9 (1.33%) Apache
7 8 (1.19%) Skype for Business
8 3 (0.44%) Apache Airflow
8 3 (0.44%) Oracle SOA Suite
8 3 (0.44%) SharePoint 2010
9 2 (0.30%) GemFire
9 2 (0.30%) Tomcat
9 2 (0.30%) WebSphere
10 1 (0.15%) OpenStack
10 1 (0.15%) Oracle Coherence
Applications
1 51 (7.56%) Microsoft Excel
2 23 (3.41%) MS Visio
3 8 (1.19%) Microsoft Office
4 3 (0.44%) Microsoft PowerPoint
Business Applications
1 22 (3.26%) Cognos Business Intelligence
2 13 (1.93%) Cognos TM1
3 8 (1.19%) Dynamics CRM
4 5 (0.74%) Cognos Planning
5 4 (0.59%) HFM
6 2 (0.30%) Dynamics AX
6 2 (0.30%) Infor SunSystems
6 2 (0.30%) Oracle Applications
6 2 (0.30%) SAP ERP
7 1 (0.15%) Hyperion Planning
7 1 (0.15%) PeopleSoft HRMS
7 1 (0.15%) SAP BPC
Cloud Services
1 61 (9.04%) Microsoft Azure
2 31 (4.59%) Amazon AWS
3 13 (1.93%) Azure Data Factory
4 9 (1.33%) GitHub
5 7 (1.04%) Office 365
6 4 (0.59%) Google Cloud Platform
7 3 (0.44%) Amazon Kinesis
7 3 (0.44%) Serverless
8 2 (0.30%) Dynamics 365
8 2 (0.30%) IaaS
8 2 (0.30%) SaaS
9 1 (0.15%) Amazon EMR
9 1 (0.15%) Amazon S3
9 1 (0.15%) Cloud Computing
9 1 (0.15%) Data Lake Analytics
9 1 (0.15%) Datadog
Communications & Networking
1 13 (1.93%) SAN
2 8 (1.19%) HTTPS
2 8 (1.19%) ISDN
3 7 (1.04%) Intranet
4 6 (0.89%) Extranet
5 5 (0.74%) Kerberos
5 5 (0.74%) NAS
5 5 (0.74%) SSL
6 3 (0.44%) Internet
7 2 (0.30%) DNS
8 1 (0.15%) DHCP
8 1 (0.15%) Firewall
8 1 (0.15%) SMS
Database & Business Intelligence
1 486 (72.00%) Data Warehouse
2 407 (60.30%) SQL Server
3 356 (52.74%) SQL Server Integration Services
4 338 (50.07%) SQL Server Analysis Services
5 297 (44.00%) SQL Server Reporting Services
6 203 (30.07%) Oracle OLAP
7 199 (29.48%) OLAP Cube
8 150 (22.22%) Power BI
9 141 (20.89%) OLTP
10 125 (18.52%) Relational Database
11 101 (14.96%) QlikView
12 81 (12.00%) SQL Server 2008
13 78 (11.56%) Big Data
14 74 (10.96%) MySQL
15 72 (10.67%) SQL Server 2012
16 53 (7.85%) Microsoft Analysis Services
17 51 (7.56%) Oracle Database
18 48 (7.11%) BusinessObjects
18 48 (7.11%) RDBMS
19 43 (6.37%) SQL Server 2014
Development Applications
1 34 (5.04%) Team Foundation Server
2 28 (4.15%) Visual Studio
3 19 (2.81%) JIRA
4 13 (1.93%) PowerDesigner
4 13 (1.93%) SQL Server Management Studio (SSMS)
5 10 (1.48%) Octopus Deploy
6 9 (1.33%) tSQLt
7 8 (1.19%) Git (software)
8 7 (1.04%) Eclipse
8 7 (1.04%) Maven
9 4 (0.59%) JUnit
10 3 (0.44%) TeamCity
11 2 (0.30%) Talend Open Studio
11 2 (0.30%) Visual Studio Team System
11 2 (0.30%) Xcode
12 1 (0.15%) Bitbucket
12 1 (0.15%) ERwin
12 1 (0.15%) Grunt
12 1 (0.15%) gulp
12 1 (0.15%) Liquibase
General
1 231 (34.22%) Finance
2 139 (20.59%) Banking
3 137 (20.30%) Retail
4 104 (15.41%) Investment Banking
5 102 (15.11%) Retail Banking
6 37 (5.48%) Advertising
7 35 (5.19%) Marketing
8 18 (2.67%) Legal
9 15 (2.22%) Publishing
10 10 (1.48%) Front Office
11 4 (0.59%) Dutch Language
11 4 (0.59%) French Language
11 4 (0.59%) German Language
11 4 (0.59%) Italian Language
11 4 (0.59%) Spanish Language
12 2 (0.30%) Financial Institution
12 2 (0.30%) Law
13 1 (0.15%) Games
13 1 (0.15%) Manufacturing
13 1 (0.15%) Telecoms
Job Titles
1 380 (56.30%) Developer
2 188 (27.85%) Business Intelligence Developer
3 131 (19.41%) SQL Developer
4 96 (14.22%) Analyst
5 74 (10.96%) Quantitative Developer
6 66 (9.78%) SQL BI Developer
7 53 (7.85%) Data Warehouse Developer
8 49 (7.26%) DBA
9 48 (7.11%) SSIS Developer
10 45 (6.67%) Consultant
10 45 (6.67%) Senior Developer
11 43 (6.37%) Business Developer
11 43 (6.37%) SSRS Developer
12 42 (6.22%) SSAS Developer
13 41 (6.07%) SQL Analyst
14 37 (5.48%) Senior Business Intelligence Developer
15 36 (5.33%) Business Intelligence Analyst
16 35 (5.19%) SQL Server Developer
17 34 (5.04%) Architect
18 30 (4.44%) Administrator
Libraries, Frameworks & Software Standards
1 165 (24.44%) MDX
2 64 (9.48%) .NET
3 47 (6.96%) XML
4 42 (6.22%) Web Services
5 28 (4.15%) Oracle GoldenGate
6 26 (3.85%) HTML
7 12 (1.78%) SOAP
7 12 (1.78%) WSDL
8 11 (1.63%) WPF
9 8 (1.19%) REST
10 7 (1.04%) JSON
10 7 (1.04%) Spring
10 7 (1.04%) XML Messaging
10 7 (1.04%) XSD
11 6 (0.89%) AngularJS
11 6 (0.89%) RESTful
12 5 (0.74%) CSS
13 4 (0.59%) ASP.NET
13 4 (0.59%) Kafka
13 4 (0.59%) RabbitMQ
Miscellaneous
1 180 (26.67%) Analytical Skills
2 98 (14.52%) Enterprise Software
3 33 (4.89%) Replication
4 28 (4.15%) Management Information System
5 21 (3.11%) Computer Science
6 16 (2.37%) Fintech
7 14 (2.07%) Data Structures
8 10 (1.48%) Foreign Exchange (FX)
9 9 (1.33%) Clustering
9 9 (1.33%) Renewable Energy
10 8 (1.19%) Cyber Attack
10 8 (1.19%) iPad
10 8 (1.19%) Mobile App
11 7 (1.04%) Reinsurance
12 6 (0.89%) Data Centre
12 6 (0.89%) Greenfield Project
13 5 (0.74%) NHS
14 4 (0.59%) Credit Risk
14 4 (0.59%) iPhone
14 4 (0.59%) N-Tier
Operating Systems
1 115 (17.04%) Unix
2 41 (6.07%) Windows
3 28 (4.15%) Linux
4 16 (2.37%) Windows Server
5 9 (1.33%) Solaris
6 1 (0.15%) Windows Server 2008
Processes & Methodologies
1 417 (61.78%) Business Intelligence
2 377 (55.85%) ETL
3 234 (34.67%) Agile Software Development
4 187 (27.70%) Analytics
5 162 (24.00%) Kimball Methodology
6 135 (20.00%) Dimensional Modelling
7 124 (18.37%) Data Modelling
8 116 (17.19%) Data Analytics
9 110 (16.30%) Performance Tuning
10 104 (15.41%) Asset Management
11 103 (15.26%) Release Management
12 94 (13.93%) Wealth Management
13 92 (13.63%) Quantitative Research
14 71 (10.52%) ETL Development
15 59 (8.74%) Visualisation
16 55 (8.15%) ITIL
17 49 (7.26%) Data Management
18 48 (7.11%) Data Visualisation
19 47 (6.96%) Data Integration
19 47 (6.96%) E-Commerce
Programming Languages
1 561 (83.11%) SQL
2 214 (31.70%) T-SQL
3 160 (23.70%) PL/SQL
4 154 (22.81%) Java
5 129 (19.11%) Python
6 103 (15.26%) R
7 93 (13.78%) Perl
8 91 (13.48%) C++
9 77 (11.41%) C#
10 36 (5.33%) PowerShell
11 28 (4.15%) Data Analysis Expressions (DAX)
12 22 (3.26%) VB.NET
13 11 (1.63%) VB
14 8 (1.19%) JavaScript
14 8 (1.19%) VBA
14 8 (1.19%) VBScript
15 6 (0.89%) PHP
16 5 (0.74%) C
17 3 (0.44%) Bash Shell
17 3 (0.44%) Scala
Qualifications
1 81 (12.00%) Degree
2 26 (3.85%) Microsoft Certification
3 10 (1.48%) Oracle Certification
4 9 (1.33%) MCSA
5 8 (1.19%) MCDBA
5 8 (1.19%) MCSE
6 7 (1.04%) MCITP
7 5 (0.74%) MBA
7 5 (0.74%) SC Cleared
7 5 (0.74%) Security Cleared
8 4 (0.59%) Computer Science Degree
9 3 (0.44%) ITIL Certification
10 2 (0.30%) MCSD
10 2 (0.30%) MCTS
11 1 (0.15%) APMP
11 1 (0.15%) Numerate Degree
11 1 (0.15%) OCP
11 1 (0.15%) PMI Certification
Quality Assurance & Compliance
1 74 (10.96%) Data Quality
2 50 (7.41%) QA
3 8 (1.19%) ISO/IEC 27001
4 3 (0.44%) GDPR
5 2 (0.30%) GCP
6 1 (0.15%) PCI DSS
6 1 (0.15%) Sarbanes-Oxley
6 1 (0.15%) SLA
System Software
1 11 (1.63%) Active Directory
2 9 (1.33%) Oracle RAC
3 8 (1.19%) VMware Infrastructure
4 5 (0.74%) Firmware
4 5 (0.74%) KVM
5 2 (0.30%) Docker
6 1 (0.15%) Apache Flume
6 1 (0.15%) HDFS
6 1 (0.15%) VMware ESXi
Systems Management
1 8 (1.19%) Microsoft Clustering
2 5 (0.74%) SCCM
2 5 (0.74%) SCOM
3 4 (0.59%) Ansible
3 4 (0.59%) Kibana
3 4 (0.59%) Systems Management Server (SMS)
4 3 (0.44%) Opscode Chef
4 3 (0.44%) Puppet
5 2 (0.30%) Kubernetes
6 1 (0.15%) Cobbler
6 1 (0.15%) Control-M
6 1 (0.15%) Hadoop YARN
6 1 (0.15%) Nagios
6 1 (0.15%) Oozie
6 1 (0.15%) PowerCLI
6 1 (0.15%) Rundeck
6 1 (0.15%) vCenter Server
6 1 (0.15%) ZABBIX
Vendors
1 254 (37.63%) Microsoft
2 203 (30.07%) Oracle
3 96 (14.22%) Tableau
4 46 (6.81%) Cognos
5 28 (4.15%) SAP
6 26 (3.85%) MicroStrategy
7 25 (3.70%) RedGate
8 23 (3.41%) Informatica
9 17 (2.52%) NetApp
9 17 (2.52%) VMware
10 15 (2.22%) Hyperion
11 14 (2.07%) IBM
12 13 (1.93%) Sybase
13 9 (1.33%) Tagetik
14 8 (1.19%) Apple
14 8 (1.19%) Avaya
14 8 (1.19%) Teradata
14 8 (1.19%) TIBCO
15 7 (1.04%) Callidus
15 7 (1.04%) Guidewire