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

Online Analytical Processing (OLAP)
UK
6 months to
20 Feb 2018
Same period 2017 Same period 2016
Rank 687 677 561
Rank change year-on-year -10 -116 -28
Permanent jobs citing OLAP 557 570 978
As % of all permanent IT jobs advertised in the UK 0.32% 0.33% 0.47%
As % of the Database & Business Intelligence category 1.03% 1.09% 1.47%
Number of salaries quoted 435 471 797
UK median annual salary £50,000 £50,000 £50,000
10th Percentile £31,250 £33,750 £33,750
90th Percentile £70,000 £72,500 £70,000
UK excluding London median annual salary £45,000 £45,000 £45,000

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 54,197 52,412 66,522
As % of all permanent IT jobs advertised in the UK 30.66% 29.99% 31.73%
Number of salaries quoted 45,120 44,761 56,182
UK median annual salary £48,500 £47,500 £45,000
Median salary % change year-on-year +2.11% +5.56% -
10th Percentile £30,000 £29,685 £28,750
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £41,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 20 February 2018.

Salary histogram for OLAP in the UK

OLAP
Top 16 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 20 February 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 -11 532 £50,000 - 53
UK excluding London -62 287 £45,000 - 33
London +32 264 £55,000 -8.33% 24
North of England +12 87 £42,500 -5.56% 9
South East -54 81 £52,500 +5.00% 10
Midlands +10 48 £34,000 -22.29% 3
North West -3 43 £45,000 +12.50% 7
Yorkshire +11 33 £30,000 -33.33% 1
West Midlands -3 32 £42,500 - 2
East of England -32 28 £45,000 +4.65% 6
South West +24 24 £40,000 -20.00% 1
East Midlands +13 16 £28,000 -37.78% 1
North East -9 11 £35,595 -20.90% 1
Wales +11 10 £57,500 +64.29%
Scotland -40 8 £42,500 - 4
Channel Islands - 1 £52,500 -

For the 6 months to 20 February 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 435 (78.10%) SQL
2 421 (75.58%) Business Intelligence
3 321 (57.63%) Data Warehouse
4 319 (57.27%) SQL Server
5 315 (56.55%) SQL Server Integration Services
6 288 (51.71%) SQL Server Reporting Services
7 279 (50.09%) SQL Server Analysis Services
8 276 (49.55%) ETL
9 246 (44.17%) Microsoft
10 180 (32.32%) T-SQL
11 163 (29.26%) Agile Software Development
12 158 (28.37%) Power BI
13 151 (27.11%) Finance
14 136 (24.42%) Analytics
15 131 (23.52%) Oracle OLAP
15 131 (23.52%) Oracle
16 120 (21.54%) OLAP Cube
17 118 (21.18%) OLTP
18 114 (20.47%) Analytical Skills
19 113 (20.29%) Data Modelling
19 113 (20.29%) MDX
20 104 (18.67%) Kimball Methodology
21 93 (16.70%) C#
22 92 (16.52%) Microsoft Azure
23 89 (15.98%) Java
24 82 (14.72%) Dimensional Modelling
25 81 (14.54%) .NET
26 79 (14.18%) Python
27 75 (13.46%) Degree
28 72 (12.93%) Visualisation

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 25 (4.49%) SharePoint
2 20 (3.59%) Apache Spark
2 20 (3.59%) SAS
3 17 (3.05%) Apache
4 12 (2.15%) IIS
5 11 (1.97%) Elasticsearch
6 9 (1.62%) Skype for Business
7 4 (0.72%) Apache Solr
8 3 (0.54%) Oracle Application Server
8 3 (0.54%) WordPress
9 2 (0.36%) SharePoint 2010
9 2 (0.36%) Tomcat
10 1 (0.18%) Apache Pig
10 1 (0.18%) SharePoint 2013
Applications
1 63 (11.31%) Microsoft Excel
2 14 (2.51%) Microsoft Office
3 11 (1.97%) Microsoft PowerPoint
4 4 (0.72%) Microsoft Project
5 3 (0.54%) MS Visio
6 1 (0.18%) Spreadsheet
Business Applications
1 29 (5.21%) Cognos TM1
2 11 (1.97%) Dynamics AX
3 9 (1.62%) Cognos Planning
4 7 (1.26%) Dynamics CRM
4 7 (1.26%) SAP BPC
5 6 (1.08%) Cognos Business Intelligence
5 6 (1.08%) HFM
6 4 (0.72%) Hyperion Planning
6 4 (0.72%) SAP ERP
7 3 (0.54%) NetSuite
8 2 (0.36%) Remedy ITSM
9 1 (0.18%) Adobe Campaign
9 1 (0.18%) Infor SunSystems
9 1 (0.18%) Oracle Applications
9 1 (0.18%) Oracle Financials
Cloud Services
1 92 (16.52%) Microsoft Azure
2 25 (4.49%) Amazon AWS
3 14 (2.51%) Azure Data Factory
4 11 (1.97%) Dynamics 365
5 8 (1.44%) SaaS
6 7 (1.26%) Google Cloud Platform
7 3 (0.54%) PaaS
8 2 (0.36%) Amazon EMR
8 2 (0.36%) Amazon S3
8 2 (0.36%) Azure Active Directory
8 2 (0.36%) Data Lake Analytics
8 2 (0.36%) Office 365
9 1 (0.18%) AWS Lambda
9 1 (0.18%) Cloud Computing
9 1 (0.18%) GitHub
9 1 (0.18%) IaaS
9 1 (0.18%) Serverless
Communications & Networking
1 12 (2.15%) SSL
2 11 (1.97%) SAN
3 9 (1.62%) HTTPS
3 9 (1.62%) ISDN
4 2 (0.36%) Kerberos
4 2 (0.36%) NAS
5 1 (0.18%) DHCP
5 1 (0.18%) DNS
5 1 (0.18%) HTTP
5 1 (0.18%) Internet
5 1 (0.18%) SMS
Database & Business Intelligence
1 321 (57.63%) Data Warehouse
2 319 (57.27%) SQL Server
3 315 (56.55%) SQL Server Integration Services
4 288 (51.71%) SQL Server Reporting Services
5 279 (50.09%) SQL Server Analysis Services
6 158 (28.37%) Power BI
7 131 (23.52%) Oracle OLAP
8 120 (21.54%) OLAP Cube
9 118 (21.18%) OLTP
10 69 (12.39%) Relational Database
11 68 (12.21%) Big Data
12 62 (11.13%) SQL Server 2008
13 52 (9.34%) QlikView
14 50 (8.98%) MySQL
15 45 (8.08%) SQL Server 2016
16 44 (7.90%) SQL Server 2012
17 43 (7.72%) Microsoft Analysis Services
18 36 (6.46%) Hadoop
19 34 (6.10%) SQL Server 2014
20 29 (5.21%) NoSQL
Development Applications
1 37 (6.64%) SQL Server Management Studio (SSMS)
2 29 (5.21%) Team Foundation Server
3 28 (5.03%) Visual Studio
4 19 (3.41%) Eclipse
5 14 (2.51%) ERwin
5 14 (2.51%) JUnit
5 14 (2.51%) Maven
6 8 (1.44%) Git (software)
7 4 (0.72%) Jenkins
7 4 (0.72%) TeamCity
7 4 (0.72%) Visual Studio Team System
8 3 (0.54%) JIRA
8 3 (0.54%) Octopus Deploy
9 2 (0.36%) LINQPad
10 1 (0.18%) Bitbucket
10 1 (0.18%) MSI
10 1 (0.18%) TestNG
10 1 (0.18%) Toad
10 1 (0.18%) tSQLt
General
1 151 (27.11%) Finance
2 62 (11.13%) Banking
3 61 (10.95%) Advertising
4 34 (6.10%) Investment Banking
5 30 (5.39%) Retail Banking
6 27 (4.85%) Marketing
7 23 (4.13%) Retail
8 7 (1.26%) Front Office
9 6 (1.08%) Publishing
10 5 (0.90%) Back Office
10 5 (0.90%) Billing
11 4 (0.72%) Games
11 4 (0.72%) Pharmaceutical
11 4 (0.72%) Telecoms
12 3 (0.54%) Financial Institution
13 2 (0.36%) Manufacturing
14 1 (0.18%) International Banking
14 1 (0.18%) Law
Job Titles
1 301 (54.04%) Developer
2 167 (29.98%) Business Intelligence Developer
3 105 (18.85%) SQL Developer
4 72 (12.93%) Analyst
5 63 (11.31%) SQL BI Developer
6 51 (9.16%) Architect
7 48 (8.62%) SSRS Developer
8 46 (8.26%) SSIS Developer
9 37 (6.64%) SQL Server Developer
10 35 (6.28%) Consultant
10 35 (6.28%) SSAS Developer
11 34 (6.10%) Business Intelligence Analyst
12 33 (5.92%) Business Intelligence Lead
12 33 (5.92%) Data Warehouse Developer
13 29 (5.21%) DBA
14 28 (5.03%) Senior Developer
15 27 (4.85%) Business Developer
15 27 (4.85%) SQL DBA
15 27 (4.85%) T-SQL Developer
16 26 (4.67%) Quantitative Developer
Libraries, Frameworks & Software Standards
1 113 (20.29%) MDX
2 81 (14.54%) .NET
3 38 (6.82%) XML
4 34 (6.10%) WPF
5 33 (5.92%) Web Services
6 21 (3.77%) ASP.NET
7 20 (3.59%) SOAP
8 19 (3.41%) JSON
9 16 (2.87%) HTML
10 13 (2.33%) Spring
10 13 (2.33%) WSDL
11 11 (1.97%) ASP.NET Web API
12 10 (1.80%) Oracle GoldenGate
13 9 (1.62%) AngularJS
13 9 (1.62%) REST
14 6 (1.08%) .NET Framework
14 6 (1.08%) ASP.NET Core
14 6 (1.08%) CSS
14 6 (1.08%) Entity Framework
14 6 (1.08%) Pandas
Miscellaneous
1 114 (20.47%) Analytical Skills
2 30 (5.39%) Computer Science
3 28 (5.03%) Management Information System
4 27 (4.85%) Enterprise Software
5 22 (3.95%) Fintech
6 19 (3.41%) Replication
7 12 (2.15%) Clustering
7 12 (2.15%) Data Centre
7 12 (2.15%) Mobile App
7 12 (2.15%) PMI
8 9 (1.62%) Cyberattack
9 8 (1.44%) Greenfield Project
9 8 (1.44%) Reinsurance
9 8 (1.44%) Taxonomies
10 7 (1.26%) Data Structures
10 7 (1.26%) iPhone
11 6 (1.08%) Hedge funds
11 6 (1.08%) Hybrid Cloud
11 6 (1.08%) User Experience
11 6 (1.08%) Virtual Team
Operating Systems
1 42 (7.54%) Unix
2 40 (7.18%) Linux
3 29 (5.21%) Windows
4 14 (2.51%) Windows Server
5 6 (1.08%) CentOS
6 4 (0.72%) Red Hat Enterprise Linux
6 4 (0.72%) Windows Server 2008
7 3 (0.54%) Debian
7 3 (0.54%) Ubuntu
7 3 (0.54%) Windows Server 2012
8 2 (0.36%) Solaris
9 1 (0.18%) HPUX
9 1 (0.18%) Windows Server 2003
Processes & Methodologies
1 421 (75.58%) Business Intelligence
2 276 (49.55%) ETL
3 163 (29.26%) Agile Software Development
4 136 (24.42%) Analytics
5 113 (20.29%) Data Modelling
6 104 (18.67%) Kimball Methodology
7 82 (14.72%) Dimensional Modelling
8 72 (12.93%) Visualisation
9 67 (12.03%) Performance Tuning
10 61 (10.95%) Data Visualisation
11 54 (9.69%) Data Management
12 51 (9.16%) Data Analytics
13 46 (8.26%) ETL Development
14 45 (8.08%) Data Architecture
15 41 (7.36%) Data Analysis
15 41 (7.36%) Data Integration
15 41 (7.36%) Master Data Management
16 37 (6.64%) Scrum
17 35 (6.28%) Business Continuity
18 34 (6.10%) Asset Management
Programming Languages
1 435 (78.10%) SQL
2 180 (32.32%) T-SQL
3 93 (16.70%) C#
4 89 (15.98%) Java
5 79 (14.18%) Python
6 62 (11.13%) PL/SQL
7 46 (8.26%) R
8 44 (7.90%) PowerShell
9 38 (6.82%) Perl
10 30 (5.39%) C++
11 22 (3.95%) VBA
12 20 (3.59%) Data Analysis Expressions (DAX)
13 15 (2.69%) JavaScript
13 15 (2.69%) VB.NET
14 11 (1.97%) Scala
15 10 (1.80%) C
16 9 (1.62%) VB
17 7 (1.26%) Shell Script
18 6 (1.08%) TypeScript
19 5 (0.90%) PHP
Qualifications
1 75 (13.46%) Degree
2 12 (2.15%) PMI Certification
3 11 (1.97%) MBA
3 11 (1.97%) Microsoft Certification
4 9 (1.62%) Security Cleared
5 8 (1.44%) Computer Science Degree
6 5 (0.90%) MCSA
6 5 (0.90%) SC Cleared
7 4 (0.72%) MCSD
7 4 (0.72%) MCSE
7 4 (0.72%) Microsoft Certified Architect
8 3 (0.54%) MCDBA
9 2 (0.36%) ACCA
9 2 (0.36%) MCITP
10 1 (0.18%) CIMA
10 1 (0.18%) OCP
10 1 (0.18%) Oracle Certification
10 1 (0.18%) PhD
Quality Assurance & Compliance
1 50 (8.98%) Data Quality
2 28 (5.03%) QA
3 9 (1.62%) ISO/IEC 27001
4 5 (0.90%) GDPR
5 3 (0.54%) PMO
System Software
1 17 (3.05%) Active Directory
2 5 (0.90%) HDFS
2 5 (0.90%) Virtual Machines
3 4 (0.72%) Apache Flume
4 3 (0.54%) Docker
4 3 (0.54%) VMware Infrastructure
5 2 (0.36%) Firmware
6 1 (0.18%) Apache ZooKeeper
6 1 (0.18%) Hyper-V
6 1 (0.18%) VMware ESXi
Systems Management
1 9 (1.62%) Systems Management Server (SMS)
2 7 (1.26%) Puppet
3 4 (0.72%) Opscode Chef
3 4 (0.72%) Single Sign-On
4 3 (0.54%) Ansible
4 3 (0.54%) Hadoop YARN
4 3 (0.54%) Microsoft Clustering
4 3 (0.54%) Oozie
4 3 (0.54%) Salt
5 2 (0.36%) Netcool
5 2 (0.36%) SCCM
5 2 (0.36%) SCOM
6 1 (0.18%) Control-M
6 1 (0.18%) vCenter Server
Vendors
1 246 (44.17%) Microsoft
2 131 (23.52%) Oracle
3 57 (10.23%) Tableau
4 48 (8.62%) Cognos
5 17 (3.05%) Hyperion
5 17 (3.05%) MicroStrategy
5 17 (3.05%) SAP
6 14 (2.51%) IFS
6 14 (2.51%) Teradata
7 13 (2.33%) IBM
8 12 (2.15%) Cisco
9 10 (1.80%) Netezza
9 10 (1.80%) Tagetik
10 9 (1.62%) Apple
10 9 (1.62%) Avaya
10 9 (1.62%) NetApp
11 7 (1.26%) Informatica
12 6 (1.08%) Google
12 6 (1.08%) Salesforce.com
12 6 (1.08%) TIBCO