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

Online Analytical Processing (OLAP)
UK
6 months to
22 Aug 2017
Same period 2016 Same period 2015
Rank 616 636 521
Rank change year-on-year +20 -115 -63
Permanent jobs citing OLAP 672 744 1140
As % of all permanent IT jobs advertised in the UK 0.38% 0.38% 0.52%
As % of the Database & Business Intelligence category 1.24% 1.26% 1.65%
Number of salaries quoted 474 608 896
UK median annual salary £50,000 £50,000 £50,000
10th Percentile £32,500 £35,875 £32,000
90th Percentile £73,925 £77,875 £77,500
UK excluding London median annual salary £42,500 £47,500 £40,000
% change year-on-year -10.53% +18.75% -5.88%

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 54097 59129 69289
As % of all permanent IT job vacancies advertised in the UK 30.73% 30.01% 31.77%
Number of salaries quoted 44898 50490 58447
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £28,750 £27,500
90th Percentile £77,500 £75,000 £72,500
UK excluding London median annual salary £42,500 £41,000 £40,000
% change year-on-year +3.66% +2.50% -

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 August 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 22 August 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 +54 661 £50,000 - 28
London +83 399 £59,500 -0.83% 10
UK excluding London -71 268 £42,500 -10.53% 22
South East +39 71 £50,000 +0.00% 5
Midlands +12 60 £35,500 -21.11% 8
East of England +4 53 £42,500 -15.00% 2
North of England -66 45 £45,000 +5.88% 3
East Midlands +36 38 £35,500 -29.00% 2
South West 0 29 £38,750 -8.82%
North West -33 23 £41,250 +10.00% 2
West Midlands -12 22 £33,500 -25.56% 6
Yorkshire -14 22 £50,000 +11.11% 1
Scotland -13 10 £40,000 -27.27% 3
Wales -11 1 £35,000 -1.75% 1

For the 6 months to 22 August 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 541 (80.51%) SQL
2 482 (71.73%) Data Warehouse
3 429 (63.84%) Business Intelligence
4 416 (61.90%) SQL Server
5 390 (58.04%) ETL
6 360 (53.57%) SQL Server Integration Services
7 347 (51.64%) SQL Server Analysis Services
8 301 (44.79%) SQL Server Reporting Services
9 268 (39.88%) Microsoft
10 227 (33.78%) T-SQL
11 225 (33.48%) OLAP Cube
12 212 (31.55%) Finance
13 203 (30.21%) Agile Software Development
14 167 (24.85%) Oracle OLAP
14 167 (24.85%) Oracle
15 162 (24.11%) Analytical Skills
16 154 (22.92%) Analytics
17 150 (22.32%) MDX
18 144 (21.43%) Kimball Methodology
19 141 (20.98%) Power BI
20 133 (19.79%) Relational Database
20 133 (19.79%) OLTP
21 128 (19.05%) PL/SQL
22 126 (18.75%) Java
23 125 (18.60%) Dimensional Modelling
24 123 (18.30%) Data Modelling
25 111 (16.52%) Banking
25 111 (16.52%) Retail
26 110 (16.37%) Python
27 99 (14.73%) Performance Tuning

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 44 (6.55%) SharePoint
2 23 (3.42%) Apache Spark
2 23 (3.42%) Elasticsearch
3 16 (2.38%) SAS
4 12 (1.79%) Apache
5 11 (1.64%) Apache Airflow
6 4 (0.60%) Oracle SOA Suite
7 3 (0.45%) SharePoint 2010
8 2 (0.30%) GemFire
8 2 (0.30%) Tomcat
8 2 (0.30%) WebSphere
9 1 (0.15%) BizTalk Server
9 1 (0.15%) IIS
9 1 (0.15%) OpenStack
9 1 (0.15%) Oracle Coherence
9 1 (0.15%) Oracle Service Bus
9 1 (0.15%) Skype for Business
Applications
1 57 (8.48%) Microsoft Excel
2 31 (4.61%) MS Visio
3 6 (0.89%) Microsoft Office
4 5 (0.74%) Microsoft PowerPoint
5 1 (0.15%) SPSS
Business Applications
1 21 (3.13%) Cognos Business Intelligence
1 21 (3.13%) Cognos TM1
2 11 (1.64%) Infor SunSystems
3 10 (1.49%) Dynamics CRM
4 3 (0.45%) Oracle Applications
4 3 (0.45%) SAP BPC
5 2 (0.30%) Dynamics AX
5 2 (0.30%) Hyperion Planning
5 2 (0.30%) SAP ERP
6 1 (0.15%) Cognos Planning
6 1 (0.15%) HFM
6 1 (0.15%) ION MarketView
6 1 (0.15%) PeopleSoft HRMS
Cloud Services
1 46 (6.85%) Microsoft Azure
2 42 (6.25%) Amazon AWS
3 11 (1.64%) Amazon Kinesis
4 8 (1.19%) GitHub
5 7 (1.04%) Azure Data Factory
6 6 (0.89%) Office 365
7 4 (0.60%) Google Cloud Platform
7 4 (0.60%) IaaS
7 4 (0.60%) SaaS
8 1 (0.15%) Adobe Analytics
8 1 (0.15%) Amazon EMR
8 1 (0.15%) Amazon S3
8 1 (0.15%) Cloud Computing
8 1 (0.15%) Data Lake Analytics
8 1 (0.15%) Datadog
8 1 (0.15%) Dynamics 365
8 1 (0.15%) Google Analytics
Communications & Networking
1 7 (1.04%) Intranet
1 7 (1.04%) SAN
2 6 (0.89%) Extranet
2 6 (0.89%) NAS
3 5 (0.74%) SSL
4 4 (0.60%) Kerberos
5 3 (0.45%) Internet
6 1 (0.15%) DNS
6 1 (0.15%) Firewall
6 1 (0.15%) HTTPS
6 1 (0.15%) ISDN
Database & Business Intelligence
1 482 (71.73%) Data Warehouse
2 416 (61.90%) SQL Server
3 360 (53.57%) SQL Server Integration Services
4 347 (51.64%) SQL Server Analysis Services
5 301 (44.79%) SQL Server Reporting Services
6 225 (33.48%) OLAP Cube
7 167 (24.85%) Oracle OLAP
8 141 (20.98%) Power BI
9 133 (19.79%) OLTP
9 133 (19.79%) Relational Database
10 92 (13.69%) QlikView
11 85 (12.65%) SQL Server 2012
12 84 (12.50%) MySQL
13 80 (11.90%) Big Data
13 80 (11.90%) SQL Server 2008
14 59 (8.78%) RDBMS
15 54 (8.04%) BusinessObjects
16 49 (7.29%) SQL Server 2014
17 47 (6.99%) Microsoft Analysis Services
18 45 (6.70%) Oracle Database
Development Applications
1 26 (3.87%) Team Foundation Server
1 26 (3.87%) Visual Studio
2 20 (2.98%) JIRA
2 20 (2.98%) PowerDesigner
3 10 (1.49%) Octopus Deploy
4 8 (1.19%) Git (software)
4 8 (1.19%) SQL Server Management Studio (SSMS)
4 8 (1.19%) tSQLt
5 5 (0.74%) Maven
6 4 (0.60%) Eclipse
7 3 (0.45%) Liquibase
8 2 (0.30%) JUnit
8 2 (0.30%) Talend Open Studio
8 2 (0.30%) TeamCity
8 2 (0.30%) Visual Studio Team System
8 2 (0.30%) Xcode
9 1 (0.15%) Grunt
9 1 (0.15%) gulp
9 1 (0.15%) MSTest
9 1 (0.15%) SpecFlow
General
1 212 (31.55%) Finance
2 111 (16.52%) Banking
2 111 (16.52%) Retail
3 83 (12.35%) Investment Banking
4 76 (11.31%) Retail Banking
5 44 (6.55%) Advertising
6 35 (5.21%) Marketing
7 24 (3.57%) Legal
8 12 (1.79%) Publishing
9 10 (1.49%) Front Office
10 6 (0.89%) Law
11 4 (0.60%) Dutch Language
11 4 (0.60%) French Language
11 4 (0.60%) German Language
11 4 (0.60%) Italian Language
11 4 (0.60%) Spanish Language
12 3 (0.45%) Financial Institution
13 2 (0.30%) Manufacturing
14 1 (0.15%) Games
14 1 (0.15%) Telecoms
Job Titles
1 355 (52.83%) Developer
2 182 (27.08%) Business Intelligence Developer
3 128 (19.05%) SQL Developer
4 121 (18.01%) Analyst
5 63 (9.38%) SQL BI Developer
6 62 (9.23%) Business Intelligence Analyst
7 61 (9.08%) Data Warehouse Developer
8 56 (8.33%) DBA
8 56 (8.33%) SQL Analyst
9 54 (8.04%) SSAS Developer
9 54 (8.04%) SSIS Developer
10 52 (7.74%) Quantitative Developer
10 52 (7.74%) SSRS Developer
11 44 (6.55%) Architect
11 44 (6.55%) Senior Developer
12 40 (5.95%) SQL Server Developer
13 38 (5.65%) Senior Business Intelligence Developer
14 35 (5.21%) Business Developer
14 35 (5.21%) Consultant
15 32 (4.76%) Administrator
Libraries, Frameworks & Software Standards
1 150 (22.32%) MDX
2 64 (9.52%) .NET
3 44 (6.55%) XML
4 39 (5.80%) Web Services
5 29 (4.32%) HTML
6 28 (4.17%) Oracle GoldenGate
7 14 (2.08%) SOAP
7 14 (2.08%) WSDL
8 12 (1.79%) Kafka
9 11 (1.64%) Scrapy
10 10 (1.49%) REST
10 10 (1.49%) XSD
11 9 (1.34%) GraphX
11 9 (1.34%) Serverless Framework
11 9 (1.34%) XML Messaging
12 8 (1.19%) AngularJS
13 7 (1.04%) CSS
13 7 (1.04%) RESTful
14 6 (0.89%) HTML5
14 6 (0.89%) JSON
Miscellaneous
1 162 (24.11%) Analytical Skills
2 75 (11.16%) Enterprise Software
3 38 (5.65%) Management Information System
4 27 (4.02%) Replication
5 24 (3.57%) Computer Science
6 23 (3.42%) Data Structures
7 20 (2.98%) Fintech
8 16 (2.38%) Greenfield Project
9 12 (1.79%) Renewable Energy
10 11 (1.64%) Foreign Exchange (FX)
11 10 (1.49%) Mobile App
12 8 (1.19%) iPad
13 7 (1.04%) Clustering
13 7 (1.04%) Reinsurance
14 6 (0.89%) Data Centre
14 6 (0.89%) NHS
15 5 (0.74%) Data Protection Act
16 4 (0.60%) Credit Risk
16 4 (0.60%) N-Tier
17 3 (0.45%) Client/Server
Operating Systems
1 89 (13.24%) Unix
2 36 (5.36%) Windows
3 19 (2.83%) Linux
4 12 (1.79%) Solaris
5 9 (1.34%) Windows Server
Processes & Methodologies
1 429 (63.84%) Business Intelligence
2 390 (58.04%) ETL
3 203 (30.21%) Agile Software Development
4 154 (22.92%) Analytics
5 144 (21.43%) Kimball Methodology
6 125 (18.60%) Dimensional Modelling
7 123 (18.30%) Data Modelling
8 99 (14.73%) Performance Tuning
9 93 (13.84%) Data Analytics
10 80 (11.90%) Release Management
11 79 (11.76%) Asset Management
12 71 (10.57%) Wealth Management
13 69 (10.27%) Quantitative Research
14 64 (9.52%) ITIL
15 60 (8.93%) Data Analysis
16 59 (8.78%) Visualisation
17 58 (8.63%) ETL Development
18 52 (7.74%) Data Management
19 48 (7.14%) Data Visualisation
20 45 (6.70%) Scrum
Programming Languages
1 541 (80.51%) SQL
2 227 (33.78%) T-SQL
3 128 (19.05%) PL/SQL
4 126 (18.75%) Java
5 110 (16.37%) Python
6 82 (12.20%) R
7 71 (10.57%) Perl
8 68 (10.12%) C#
8 68 (10.12%) C++
9 34 (5.06%) PowerShell
10 23 (3.42%) Data Analysis Expressions (DAX)
11 18 (2.68%) VB.NET
12 13 (1.93%) JavaScript
13 12 (1.79%) VB
13 12 (1.79%) VBA
14 9 (1.34%) PHP
15 8 (1.19%) VBScript
16 5 (0.74%) C
17 4 (0.60%) Bash Shell
18 3 (0.45%) VB6
Qualifications
1 70 (10.42%) Degree
2 24 (3.57%) Microsoft Certification
3 9 (1.34%) Oracle Certification
4 8 (1.19%) ITIL Certification
4 8 (1.19%) MCSE
5 7 (1.04%) MCITP
6 5 (0.74%) MCDBA
6 5 (0.74%) MCSA
7 4 (0.60%) Computer Science Degree
8 3 (0.45%) SC Cleared
8 3 (0.45%) Security Cleared
9 2 (0.30%) MCSD
9 2 (0.30%) MCTS
10 1 (0.15%) APMP
10 1 (0.15%) Numerate Degree
10 1 (0.15%) PMI Certification
Quality Assurance & Compliance
1 71 (10.57%) Data Quality
2 50 (7.44%) QA
3 3 (0.45%) GDPR
4 2 (0.30%) GCP
5 1 (0.15%) EFQM
5 1 (0.15%) ISO/IEC 27001
5 1 (0.15%) PCI DSS
5 1 (0.15%) Sarbanes-Oxley
5 1 (0.15%) SLA
System Software
1 10 (1.49%) Oracle RAC
1 10 (1.49%) VMware Infrastructure
2 9 (1.34%) KVM
3 3 (0.45%) Firmware
4 2 (0.30%) Active Directory
4 2 (0.30%) Docker
5 1 (0.15%) Apache Flume
5 1 (0.15%) HDFS
Systems Management
1 12 (1.79%) Kibana
2 5 (0.74%) Microsoft Clustering
3 4 (0.60%) Ansible
3 4 (0.60%) Opscode Chef
3 4 (0.60%) Puppet
4 3 (0.45%) Oozie
4 3 (0.45%) SCCM
4 3 (0.45%) SCOM
5 2 (0.30%) Kubernetes
6 1 (0.15%) Cobbler
6 1 (0.15%) Control-M
6 1 (0.15%) Enterprise Manager Cloud Control
6 1 (0.15%) Hadoop YARN
6 1 (0.15%) Nagios
6 1 (0.15%) Oracle Enterprise Manager
6 1 (0.15%) Oracle RMAN
6 1 (0.15%) PowerCLI
6 1 (0.15%) Rundeck
6 1 (0.15%) Systems Management Server (SMS)
6 1 (0.15%) ZABBIX
Vendors
1 268 (39.88%) Microsoft
2 167 (24.85%) Oracle
3 84 (12.50%) Tableau
4 55 (8.18%) Cognos
5 35 (5.21%) SAP
6 33 (4.91%) MicroStrategy
7 22 (3.27%) Informatica
7 22 (3.27%) RedGate
7 22 (3.27%) VMware
8 20 (2.98%) Sybase
9 14 (2.08%) Hyperion
9 14 (2.08%) IBM
10 13 (1.93%) NetApp
11 12 (1.79%) Infor
12 11 (1.64%) Jedox
13 9 (1.34%) Callidus
13 9 (1.34%) Guidewire
13 9 (1.34%) Percona
14 8 (1.19%) Cognizant
15 7 (1.04%) Sun