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

Online Analytical Processing (OLAP)
UK
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 610 670 535
Rank change year-on-year +60 -135 -54
Permanent jobs citing OLAP 668 630 1089
As % of all permanent IT jobs advertised in the UK 0.37% 0.33% 0.50%
As % of the Database & Business Intelligence category 1.22% 1.12% 1.60%
Number of salaries quoted 451 511 863
UK median annual salary £50,000 £50,000 £50,000
10th Percentile £31,250 £33,750 £32,500
90th Percentile £73,750 £78,750 £72,500
UK excluding London median annual salary £45,000 £47,500 £43,250
% change year-on-year -5.26% +9.83% +1.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 54610 56430 67973
As % of all permanent IT jobs advertised in the UK 30.24% 29.67% 31.50%
Number of salaries quoted 44953 48258 57223
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

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 November 2017.

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 22 November 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 +61 646 £50,000 - 30
London +108 387 £57,500 -4.17% 11
UK excluding London -49 276 £45,000 -5.26% 20
South East -11 78 £50,000 - 3
Midlands +43 55 £29,500 -30.59% 2
North of England -49 51 £42,000 -6.67% 12
East of England +11 41 £40,000 -15.79% 2
West Midlands +12 35 £33,000 -20.00% 1
South West +23 31 £40,000 -20.00%
Yorkshire -6 25 £38,486 -14.48% 4
North West -35 23 £42,500 +6.25% 4
East Midlands +43 20 £28,000 -41.05% 1
Scotland -29 13 £42,500 -22.73% 1
Wales +8 7 £60,000 +71.43%
North East +5 3 £35,690 -10.78% 4
Channel Islands - 1 £52,500 -

For the 6 months to 22 November 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 549 (82.19%) SQL
2 448 (67.07%) Data Warehouse
3 426 (63.77%) Business Intelligence
4 385 (57.63%) SQL Server
5 347 (51.95%) ETL
5 347 (51.95%) SQL Server Integration Services
6 328 (49.10%) SQL Server Analysis Services
7 301 (45.06%) SQL Server Reporting Services
8 259 (38.77%) Microsoft
9 238 (35.63%) Agile Software Development
10 233 (34.88%) Finance
11 209 (31.29%) T-SQL
12 205 (30.69%) Oracle
12 205 (30.69%) Oracle OLAP
13 191 (28.59%) Analytics
14 178 (26.65%) Analytical Skills
15 173 (25.90%) OLAP Cube
16 162 (24.25%) MDX
17 154 (23.05%) Kimball Methodology
18 152 (22.75%) Java
19 151 (22.60%) PL/SQL
20 147 (22.01%) Power BI
21 139 (20.81%) Banking
22 134 (20.06%) OLTP
23 132 (19.76%) Python
24 119 (17.81%) Dimensional Modelling
25 114 (17.07%) Data Modelling
26 113 (16.92%) Relational Database
27 112 (16.77%) Unix
28 111 (16.62%) 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 51 (7.63%) SharePoint
2 23 (3.44%) SAS
3 17 (2.54%) Apache Spark
4 12 (1.80%) IIS
5 10 (1.50%) Apache
6 9 (1.35%) Skype for Business
7 8 (1.20%) Elasticsearch
8 4 (0.60%) SharePoint 2010
9 2 (0.30%) GemFire
9 2 (0.30%) Oracle SOA Suite
10 1 (0.15%) Apache Solr
10 1 (0.15%) SharePoint 2013
10 1 (0.15%) Tomcat
Applications
1 60 (8.98%) Microsoft Excel
2 11 (1.65%) MS Visio
3 10 (1.50%) Microsoft Office
4 7 (1.05%) Microsoft PowerPoint
5 4 (0.60%) Microsoft Project
Business Applications
1 19 (2.84%) Cognos Business Intelligence
2 18 (2.69%) Cognos TM1
3 8 (1.20%) Cognos Planning
4 5 (0.75%) HFM
5 4 (0.60%) Dynamics AX
5 4 (0.60%) Dynamics CRM
6 2 (0.30%) SAP ERP
7 1 (0.15%) Adobe Campaign
7 1 (0.15%) Oracle Applications
7 1 (0.15%) Oracle Financials
7 1 (0.15%) Remedy ITSM
Cloud Services
1 68 (10.18%) Microsoft Azure
2 24 (3.59%) Amazon AWS
3 15 (2.25%) Azure Data Factory
4 9 (1.35%) GitHub
5 6 (0.90%) Office 365
6 4 (0.60%) Dynamics 365
6 4 (0.60%) Google Cloud Platform
7 2 (0.30%) Amazon EMR
7 2 (0.30%) Amazon S3
8 1 (0.15%) Cloud Computing
8 1 (0.15%) SaaS
Communications & Networking
1 14 (2.10%) SAN
2 9 (1.35%) HTTPS
2 9 (1.35%) ISDN
3 6 (0.90%) Extranet
3 6 (0.90%) Intranet
3 6 (0.90%) SSL
4 5 (0.75%) NAS
5 4 (0.60%) Internet
5 4 (0.60%) Kerberos
6 2 (0.30%) DNS
7 1 (0.15%) DHCP
7 1 (0.15%) Firewall
7 1 (0.15%) HTTP
7 1 (0.15%) SMS
Database & Business Intelligence
1 448 (67.07%) Data Warehouse
2 385 (57.63%) SQL Server
3 347 (51.95%) SQL Server Integration Services
4 328 (49.10%) SQL Server Analysis Services
5 301 (45.06%) SQL Server Reporting Services
6 205 (30.69%) Oracle OLAP
7 173 (25.90%) OLAP Cube
8 147 (22.01%) Power BI
9 134 (20.06%) OLTP
10 113 (16.92%) Relational Database
11 89 (13.32%) QlikView
12 78 (11.68%) SQL Server 2008
13 76 (11.38%) Big Data
14 62 (9.28%) SQL Server 2012
15 61 (9.13%) MySQL
16 57 (8.53%) Microsoft Analysis Services
17 48 (7.19%) BusinessObjects
17 48 (7.19%) SQL Server 2014
17 48 (7.19%) SQL Server 2016
18 44 (6.59%) Oracle Database
Development Applications
1 41 (6.14%) Team Foundation Server
2 40 (5.99%) Visual Studio
3 16 (2.40%) SQL Server Management Studio (SSMS)
4 15 (2.25%) JIRA
5 11 (1.65%) Eclipse
6 9 (1.35%) tSQLt
7 8 (1.20%) Git (software)
7 8 (1.20%) Maven
8 7 (1.05%) Octopus Deploy
9 5 (0.75%) JUnit
10 4 (0.60%) PowerDesigner
11 3 (0.45%) Talend Open Studio
12 2 (0.30%) ERwin
12 2 (0.30%) Xcode
13 1 (0.15%) Bitbucket
13 1 (0.15%) MSI
13 1 (0.15%) TeamCity
13 1 (0.15%) Toad
13 1 (0.15%) Visual Studio Team System
General
1 233 (34.88%) Finance
2 139 (20.81%) Banking
3 101 (15.12%) Investment Banking
4 100 (14.97%) Retail Banking
5 42 (6.29%) Advertising
6 26 (3.89%) Retail
7 25 (3.74%) Marketing
8 18 (2.69%) Publishing
9 9 (1.35%) Legal
10 6 (0.90%) Front Office
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%) Telecoms
13 2 (0.30%) Financial Institution
14 1 (0.15%) Games
14 1 (0.15%) International Banking
14 1 (0.15%) Manufacturing
Job Titles
1 366 (54.79%) Developer
2 185 (27.69%) Business Intelligence Developer
3 122 (18.26%) SQL Developer
4 88 (13.17%) Analyst
5 72 (10.78%) Quantitative Developer
6 70 (10.48%) SQL BI Developer
7 50 (7.49%) SSIS Developer
8 48 (7.19%) Consultant
9 47 (7.04%) Data Warehouse Developer
9 47 (7.04%) SSRS Developer
10 43 (6.44%) Business Developer
10 43 (6.44%) DBA
11 39 (5.84%) SSAS Developer
12 32 (4.79%) Business Intelligence Analyst
12 32 (4.79%) Senior Developer
13 31 (4.64%) Architect
13 31 (4.64%) Business Intelligence Consultant
13 31 (4.64%) SQL DBA
14 29 (4.34%) Administrator
15 28 (4.19%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 162 (24.25%) MDX
2 67 (10.03%) .NET
3 48 (7.19%) XML
4 39 (5.84%) Web Services
5 25 (3.74%) Oracle GoldenGate
6 23 (3.44%) HTML
7 17 (2.54%) WPF
8 12 (1.80%) SOAP
9 11 (1.65%) JSON
9 11 (1.65%) WSDL
10 8 (1.20%) REST
10 8 (1.20%) Spring
11 7 (1.05%) ASP.NET
12 5 (0.75%) Pandas
12 5 (0.75%) RESTful
12 5 (0.75%) XML Messaging
12 5 (0.75%) XSD
13 4 (0.60%) AngularJS
13 4 (0.60%) CSS
13 4 (0.60%) RabbitMQ
Miscellaneous
1 178 (26.65%) Analytical Skills
2 96 (14.37%) Enterprise Software
3 32 (4.79%) Replication
4 29 (4.34%) Management Information System
5 19 (2.84%) Computer Science
6 11 (1.65%) Fintech
7 10 (1.50%) Clustering
8 9 (1.35%) Credit Risk
8 9 (1.35%) Cyber Attack
8 9 (1.35%) Reinsurance
9 8 (1.20%) Mobile App
9 8 (1.20%) PMI
10 7 (1.05%) Data Centre
10 7 (1.05%) Data Structures
10 7 (1.05%) Foreign Exchange (FX)
10 7 (1.05%) iPad
10 7 (1.05%) iPhone
11 6 (0.90%) Equities
11 6 (0.90%) Greenfield Project
12 5 (0.75%) Renewable Energy
Operating Systems
1 112 (16.77%) Unix
2 35 (5.24%) Windows
3 30 (4.49%) Linux
4 14 (2.10%) Windows Server
5 6 (0.90%) Solaris
6 2 (0.30%) Windows Server 2008
7 1 (0.15%) HPUX
7 1 (0.15%) Red Hat Enterprise Linux
7 1 (0.15%) Windows Server 2003
7 1 (0.15%) Windows Server 2012
Processes & Methodologies
1 426 (63.77%) Business Intelligence
2 347 (51.95%) ETL
3 238 (35.63%) Agile Software Development
4 191 (28.59%) Analytics
5 154 (23.05%) Kimball Methodology
6 119 (17.81%) Dimensional Modelling
7 114 (17.07%) Data Modelling
8 111 (16.62%) Data Analytics
9 102 (15.27%) Asset Management
10 101 (15.12%) Performance Tuning
11 99 (14.82%) Release Management
12 92 (13.77%) Wealth Management
13 89 (13.32%) Quantitative Research
14 69 (10.33%) ETL Development
15 54 (8.08%) Data Management
16 49 (7.34%) Visualisation
17 47 (7.04%) Data Integration
18 45 (6.74%) ITIL
19 44 (6.59%) E-Commerce
19 44 (6.59%) Scrum
Programming Languages
1 549 (82.19%) SQL
2 209 (31.29%) T-SQL
3 152 (22.75%) Java
4 151 (22.60%) PL/SQL
5 132 (19.76%) Python
6 101 (15.12%) R
7 91 (13.62%) Perl
8 89 (13.32%) C++
9 86 (12.87%) C#
10 37 (5.54%) PowerShell
11 29 (4.34%) Data Analysis Expressions (DAX)
12 20 (2.99%) VB.NET
13 12 (1.80%) VB
13 12 (1.80%) VBA
14 8 (1.20%) C
15 7 (1.05%) JavaScript
16 5 (0.75%) Scala
16 5 (0.75%) VBScript
17 4 (0.60%) Go
17 4 (0.60%) PHP
Qualifications
1 84 (12.57%) Degree
2 24 (3.59%) Microsoft Certification
3 10 (1.50%) MCSA
4 9 (1.35%) MCSE
5 8 (1.20%) MBA
5 8 (1.20%) MCDBA
5 8 (1.20%) PMI Certification
5 8 (1.20%) Security Cleared
6 7 (1.05%) MCITP
6 7 (1.05%) Oracle Certification
7 6 (0.90%) SC Cleared
8 3 (0.45%) Computer Science Degree
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%) OCP
Quality Assurance & Compliance
1 70 (10.48%) Data Quality
2 40 (5.99%) QA
3 9 (1.35%) ISO/IEC 27001
4 5 (0.75%) GDPR
5 2 (0.30%) GCP
6 1 (0.15%) SLA
System Software
1 16 (2.40%) Active Directory
2 6 (0.90%) Oracle RAC
2 6 (0.90%) VMware Infrastructure
3 5 (0.75%) Firmware
4 2 (0.30%) Apache Flume
4 2 (0.30%) Docker
4 2 (0.30%) HDFS
4 2 (0.30%) KVM
5 1 (0.15%) Hyper-V
5 1 (0.15%) VMware ESXi
Systems Management
1 8 (1.20%) Microsoft Clustering
2 5 (0.75%) SCCM
2 5 (0.75%) SCOM
3 4 (0.60%) Systems Management Server (SMS)
4 3 (0.45%) Ansible
5 2 (0.30%) Hadoop YARN
5 2 (0.30%) Kubernetes
6 1 (0.15%) Netcool
6 1 (0.15%) Oozie
6 1 (0.15%) Opscode Chef
6 1 (0.15%) Puppet
6 1 (0.15%) vCenter Server
Vendors
1 259 (38.77%) Microsoft
2 205 (30.69%) Oracle
3 81 (12.13%) Tableau
4 50 (7.49%) Cognos
5 25 (3.74%) MicroStrategy
6 23 (3.44%) Informatica
6 23 (3.44%) RedGate
7 21 (3.14%) SAP
8 16 (2.40%) IBM
9 14 (2.10%) NetApp
10 12 (1.80%) Teradata
11 11 (1.65%) Hyperion
11 11 (1.65%) VMware
12 9 (1.35%) Apple
12 9 (1.35%) Avaya
12 9 (1.35%) Tagetik
13 8 (1.20%) IFS
14 7 (1.05%) TIBCO
15 6 (0.90%) Cisco
16 5 (0.75%) Netezza