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

Online Analytical Processing (OLAP)
UK
6 months to
18 Jun 2018
Same period 2017 Same period 2016
Rank 698 637 634
Rank change year-on-year -61 -3 -103
Permanent jobs citing OLAP 521 614 781
As % of all permanent IT jobs advertised in the UK 0.30% 0.36% 0.39%
As % of the Database & Business Intelligence category 0.99% 1.16% 1.28%
Number of salaries quoted 433 496 626
UK median annual salary £48,500 £50,000 £51,500
Median salary % change year-on-year -3.00% -2.91% -1.90%
10th Percentile £32,000 £33,000 £35,000
90th Percentile £77,500 £72,500 £72,500
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 52,683 52,992 61,077
As % of all permanent IT jobs advertised in the UK 30.65% 30.81% 30.59%
Number of salaries quoted 43,210 44,804 51,962
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £29,500 £28,750
90th Percentile £80,000 £77,500 £75,000
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 18 June 2018.

Salary histogram for OLAP in the UK

OLAP
Top 15 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 June 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 -63 500 £47,500 -9.52% 41
UK excluding London -28 264 £45,000 - 22
London -51 244 £55,000 -8.33% 23
South East -30 92 £45,000 -18.18% 1
North of England +31 75 £46,250 +12.12% 8
North West +24 47 £47,500 +26.67% 4
Midlands -23 31 £35,000 -9.09%
East of England -26 30 £47,500 +10.47% 5
South West +10 28 £40,000 - 4
Yorkshire +19 20 £45,000 +5.88% 4
West Midlands +6 17 £34,000 -2.86%
East Midlands -22 14 £35,000 -12.50%
North East - 8 £37,000 -
Scotland -29 6 £52,500 +38.16% 3
Wales +8 2 £42,500 +21.43% 1

For the 6 months to 18 June 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 416 (79.85%) Business Intelligence
2 413 (79.27%) SQL
3 338 (64.88%) SQL Server
4 331 (63.53%) SQL Server Integration Services
5 311 (59.69%) Data Warehouse
6 310 (59.50%) ETL
7 304 (58.35%) SQL Server Reporting Services
8 281 (53.93%) Microsoft
9 259 (49.71%) SQL Server Analysis Services
10 174 (33.40%) Power BI
11 164 (31.48%) T-SQL
12 163 (31.29%) Agile Software Development
13 149 (28.60%) Analytics
14 145 (27.83%) OLTP
15 143 (27.45%) Data Modelling
16 127 (24.38%) Microsoft Azure
17 120 (23.03%) Analytical Skills
18 119 (22.84%) Oracle OLAP
18 119 (22.84%) Oracle
19 116 (22.26%) OLAP Cube
20 113 (21.69%) C#
20 113 (21.69%) Finance
21 104 (19.96%) .NET
22 100 (19.19%) Visualisation
23 89 (17.08%) Kimball Methodology
24 78 (14.97%) Problem-Solving
25 76 (14.59%) MDX
26 75 (14.40%) Relational Database
27 73 (14.01%) Degree
27 73 (14.01%) Big Data

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 36 (6.91%) SAS
2 24 (4.61%) Apache Spark
3 17 (3.26%) Apache
4 15 (2.88%) Elasticsearch
4 15 (2.88%) SharePoint
5 8 (1.54%) Oracle Application Server
6 5 (0.96%) Confluence
7 4 (0.77%) Apache Solr
7 4 (0.77%) Tomcat
7 4 (0.77%) WordPress
8 3 (0.58%) JBoss
8 3 (0.58%) WebLogic
8 3 (0.58%) WebSphere
9 2 (0.38%) Apache Pig
9 2 (0.38%) SharePoint 2010
9 2 (0.38%) SugarCRM
10 1 (0.19%) IIS
10 1 (0.19%) Oracle SOA Suite
Applications
1 60 (11.52%) Microsoft Excel
2 21 (4.03%) Microsoft Office
3 6 (1.15%) MS Visio
4 4 (0.77%) Microsoft PowerPoint
4 4 (0.77%) Spreadsheet
5 1 (0.19%) Microsoft Project
5 1 (0.19%) S-PLUS
Business Applications
1 16 (3.07%) Cognos TM1
2 8 (1.54%) Dynamics AX
2 8 (1.54%) Dynamics CRM
3 7 (1.34%) SAP BPC
3 7 (1.34%) SAP ERP
4 5 (0.96%) Cognos Planning
5 4 (0.77%) HFM
5 4 (0.77%) SAP Forecasting and Replenishment
5 4 (0.77%) SAP Retail
6 3 (0.58%) Hyperion Planning
6 3 (0.58%) SAP S/4HANA
7 2 (0.38%) NetSuite
8 1 (0.19%) Cognos Business Intelligence
8 1 (0.19%) Dynamics NAV
8 1 (0.19%) Infor SunSystems
8 1 (0.19%) Remedy ITSM
Cloud Services
1 127 (24.38%) Microsoft Azure
2 35 (6.72%) Amazon AWS
3 17 (3.26%) Azure Data Factory
4 16 (3.07%) Google Cloud Platform
4 16 (3.07%) SaaS
5 8 (1.54%) PaaS
6 6 (1.15%) Data Lake Analytics
6 6 (1.15%) Dynamics 365
6 6 (1.15%) IaaS
7 4 (0.77%) Cloud Computing
8 3 (0.58%) Amazon S3
9 2 (0.38%) Amazon EMR
9 2 (0.38%) AWS Lambda
9 2 (0.38%) Azure Active Directory
9 2 (0.38%) Serverless
10 1 (0.19%) Boomi
Communications & Networking
1 16 (3.07%) SSL
2 5 (0.96%) SAN
3 1 (0.19%) HTTP
Database & Business Intelligence
1 338 (64.88%) SQL Server
2 331 (63.53%) SQL Server Integration Services
3 311 (59.69%) Data Warehouse
4 304 (58.35%) SQL Server Reporting Services
5 259 (49.71%) SQL Server Analysis Services
6 174 (33.40%) Power BI
7 145 (27.83%) OLTP
8 119 (22.84%) Oracle OLAP
9 116 (22.26%) OLAP Cube
10 75 (14.40%) Relational Database
11 73 (14.01%) Big Data
12 57 (10.94%) MySQL
13 55 (10.56%) Hadoop
14 48 (9.21%) QlikView
15 45 (8.64%) Microsoft Analysis Services
16 44 (8.45%) SQL Server 2016
17 42 (8.06%) SQL Server 2008
18 36 (6.91%) Star Schema
19 34 (6.53%) SQL Server 2012
20 33 (6.33%) NoSQL
Development Applications
1 33 (6.33%) SQL Server Management Studio (SSMS)
2 27 (5.18%) ERwin
3 25 (4.80%) Visual Studio
4 21 (4.03%) Team Foundation Server
5 17 (3.26%) Git (software)
5 17 (3.26%) Visual Studio Team System
6 10 (1.92%) JIRA
7 9 (1.73%) Maven
8 8 (1.54%) ER Studio
9 7 (1.34%) Jenkins
10 6 (1.15%) JUnit
10 6 (1.15%) Toad
11 4 (0.77%) Eclipse
12 3 (0.58%) Ant
12 3 (0.58%) Gradle
12 3 (0.58%) TeamCity
13 2 (0.38%) Bitbucket
13 2 (0.38%) LINQPad
13 2 (0.38%) TestNG
14 1 (0.19%) Subversion
General
1 113 (21.69%) Finance
2 69 (13.24%) Advertising
3 30 (5.76%) Banking
4 25 (4.80%) Retail
5 23 (4.41%) Marketing
6 14 (2.69%) Games
7 9 (1.73%) Investment Banking
7 9 (1.73%) Pharmaceutical
8 8 (1.54%) Front Office
9 5 (0.96%) Billing
9 5 (0.96%) Manufacturing
10 4 (0.77%) International Banking
10 4 (0.77%) Law
10 4 (0.77%) Russian Language
11 3 (0.58%) Back Office
11 3 (0.58%) General Ledger
11 3 (0.58%) Legal
12 2 (0.38%) Dutch Language
12 2 (0.38%) Financial Institution
12 2 (0.38%) Publishing
Job Titles
1 283 (54.32%) Developer
2 167 (32.05%) Business Intelligence Developer
3 99 (19.00%) SQL Developer
4 78 (14.97%) Architect
5 56 (10.75%) Analyst
5 56 (10.75%) SSRS Developer
6 53 (10.17%) SQL BI Developer
7 52 (9.98%) SSIS Developer
8 48 (9.21%) Data Architect
9 41 (7.87%) SQL Server Developer
10 37 (7.10%) Business Intelligence Analyst
10 37 (7.10%) DBA
11 35 (6.72%) Senior Developer
12 30 (5.76%) Business Developer
12 30 (5.76%) Consultant
13 29 (5.57%) C# Developer
14 28 (5.37%) SQL DBA
15 27 (5.18%) SQL Server BI Developer
16 26 (4.99%) Senior Business Intelligence Developer
16 26 (4.99%) Solutions Architect
Libraries, Frameworks & Software Standards
1 104 (19.96%) .NET
2 76 (14.59%) MDX
3 42 (8.06%) WPF
3 42 (8.06%) XML
4 38 (7.29%) Web Services
5 35 (6.72%) SOAP
6 28 (5.37%) JSON
7 27 (5.18%) ASP.NET
8 17 (3.26%) AngularJS
8 17 (3.26%) ASP.NET Web API
8 17 (3.26%) Kafka
9 16 (3.07%) WSDL
10 15 (2.88%) REST
11 14 (2.69%) .NET Framework
11 14 (2.69%) Angular 2
11 14 (2.69%) ASP.NET Core
11 14 (2.69%) Entity Framework
12 11 (2.11%) HTML
13 9 (1.73%) CSS
14 8 (1.54%) Sphinx
Miscellaneous
1 120 (23.03%) Analytical Skills
2 38 (7.29%) Computer Science
3 25 (4.80%) Replication
4 21 (4.03%) Fintech
4 21 (4.03%) Self-Motivation
5 18 (3.45%) Data Centre
6 16 (3.07%) Hybrid Cloud
6 16 (3.07%) Management Information System
6 16 (3.07%) Mobile App
7 14 (2.69%) Data Structures
8 11 (2.11%) Clustering
8 11 (2.11%) Virtual Team
9 10 (1.92%) Greenfield Project
9 10 (1.92%) Taxonomies
10 8 (1.54%) Enterprise Software
10 8 (1.54%) iPad
10 8 (1.54%) Life Science
11 6 (1.15%) User Experience
12 5 (0.96%) Data Protection Act
12 5 (0.96%) Reinsurance
Operating Systems
1 36 (6.91%) Linux
2 18 (3.45%) Windows
3 16 (3.07%) Unix
4 9 (1.73%) Windows Server
5 6 (1.15%) CentOS
6 3 (0.58%) Debian
6 3 (0.58%) Red Hat Enterprise Linux
6 3 (0.58%) Ubuntu
6 3 (0.58%) Windows Server 2012
7 2 (0.38%) Windows Server 2008
8 1 (0.19%) Solaris
Processes & Methodologies
1 416 (79.85%) Business Intelligence
2 310 (59.50%) ETL
3 163 (31.29%) Agile Software Development
4 149 (28.60%) Analytics
5 143 (27.45%) Data Modelling
6 100 (19.19%) Visualisation
7 89 (17.08%) Kimball Methodology
8 78 (14.97%) Problem-Solving
9 72 (13.82%) Data Visualisation
10 69 (13.24%) Data Architecture
11 66 (12.67%) Performance Tuning
12 58 (11.13%) Data Integration
12 58 (11.13%) Dimensional Modelling
13 51 (9.79%) Data Analytics
14 49 (9.40%) Data Analysis
15 41 (7.87%) Migration
16 37 (7.10%) SDLC
17 36 (6.91%) Logical Data Model
18 35 (6.72%) Data Management
18 35 (6.72%) Scrum
Programming Languages
1 413 (79.27%) SQL
2 164 (31.48%) T-SQL
3 113 (21.69%) C#
4 60 (11.52%) PowerShell
5 59 (11.32%) Python
6 54 (10.36%) Java
7 37 (7.10%) PL/SQL
8 28 (5.37%) VBA
9 24 (4.61%) JavaScript
10 21 (4.03%) Perl
11 20 (3.84%) R
12 16 (3.07%) Data Analysis Expressions (DAX)
13 15 (2.88%) VB.NET
14 14 (2.69%) TypeScript
15 12 (2.30%) Scala
15 12 (2.30%) Shell Script
16 10 (1.92%) C
17 9 (1.73%) VB
18 8 (1.54%) MATLAB
19 5 (0.96%) PHP
Qualifications
1 73 (14.01%) Degree
2 16 (3.07%) TOGAF Certification
3 12 (2.30%) Computer Science Degree
3 12 (2.30%) Microsoft Certification
4 8 (1.54%) MCSD
4 8 (1.54%) Microsoft Certified Architect
5 7 (1.34%) Security Cleared
6 5 (0.96%) SC Cleared
7 4 (0.77%) MBA
8 3 (0.58%) Master's Degree
8 3 (0.58%) PMI Certification
9 2 (0.38%) ACCA
9 2 (0.38%) OCP
9 2 (0.38%) Oracle Certification
9 2 (0.38%) PhD
10 1 (0.19%) CIMA
10 1 (0.19%) MCP
10 1 (0.19%) MCSE
10 1 (0.19%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 38 (7.29%) Data Quality
2 17 (3.26%) QA
3 9 (1.73%) GDPR
4 4 (0.77%) SLA
5 3 (0.58%) EFQM
5 3 (0.58%) PMO
System Software
1 10 (1.92%) HDFS
2 8 (1.54%) Apache Flume
3 5 (0.96%) Docker
3 5 (0.96%) Virtual Machines
4 2 (0.38%) Active Directory
4 2 (0.38%) Apache ZooKeeper
Systems Management
1 14 (2.69%) Systems Management Server (SMS)
2 8 (1.54%) Single Sign-On
3 7 (1.34%) Data Guard
3 7 (1.34%) Puppet
4 6 (1.15%) Control-M
4 6 (1.15%) Hadoop YARN
4 6 (1.15%) Oozie
5 4 (0.77%) Opscode Chef
6 3 (0.58%) Ansible
6 3 (0.58%) Salt
7 1 (0.19%) Kibana
7 1 (0.19%) Netcool
Vendors
1 281 (53.93%) Microsoft
2 119 (22.84%) Oracle
3 59 (11.32%) Tableau
4 45 (8.64%) SAP
5 42 (8.06%) Cognos
6 24 (4.61%) MicroStrategy
7 20 (3.84%) Informatica
8 16 (3.07%) Cisco
8 16 (3.07%) Hyperion
9 14 (2.69%) Google
9 14 (2.69%) Netezza
10 13 (2.50%) IBM
11 11 (2.11%) Teradata
12 10 (1.92%) Cloudera
12 10 (1.92%) Tagetik
12 10 (1.92%) Talend
13 8 (1.54%) Alteryx
14 7 (1.34%) CA
14 7 (1.34%) Salesforce.com
15 5 (0.96%) BMC