Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in England 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 November 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK > England
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 605 685 535
Rank change year-on-year +80 -150 -71
Permanent jobs citing OLAP 646 570 1052
As % of all permanent IT jobs advertised in England 0.38% 0.32% 0.51%
As % of the Database & Business Intelligence category 1.27% 1.09% 1.62%
Number of salaries quoted 437 466 852
England median annual salary £50,000 £50,000 £50,000
10th Percentile £31,250 £36,250 £32,500
90th Percentile £73,750 £80,000 £72,500
UK median annual salary £50,000 £50,000 £50,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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 50861 52245 64966
As % of all permanent IT jobs advertised in England 30.19% 29.59% 31.58%
Number of salaries quoted 42283 45101 55204
England median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £30,000 £29,000 £28,500
90th Percentile £77,500 £77,500 £75,000
UK median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% +2.27%

OLAP
Job Vacancy Trend in England

Job postings citing OLAP as a percentage of all IT jobs advertised in England.

Job vacancy trend for OLAP in England

OLAP
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP in England.

Salary trend for OLAP in England

OLAP
Salary Histogram in England

The salary distribution of IT jobs citing OLAP in England over the 6 months to 20 November 2017.

Salary histogram for OLAP in England

OLAP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the England region over the 6 months to 20 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
London +113 387 £57,500 -4.17% 15
South East -11 78 £50,000 - 5
Midlands +26 55 £29,500 -30.59% 3
North of England -34 49 £42,250 -6.11% 12
East of England +2 43 £40,000 -15.79%
West Midlands +17 35 £33,000 -20.00% 1
South West +23 31 £40,000 -20.00%
Yorkshire -17 24 £44,471 -1.18% 5
North West -24 23 £42,500 +6.25% 5
East Midlands +31 20 £28,000 -41.05% 2
North East -5 2 £37,845 -5.39% 2
OLAP
UK

For the 6 months to 20 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 across the England region with a requirement for OLAP.

1 528 (81.73%) SQL
2 447 (69.20%) Data Warehouse
3 405 (62.69%) Business Intelligence
4 371 (57.43%) SQL Server
5 336 (52.01%) ETL
6 334 (51.70%) SQL Server Integration Services
7 314 (48.61%) SQL Server Analysis Services
8 287 (44.43%) SQL Server Reporting Services
9 243 (37.62%) Microsoft
10 236 (36.53%) Agile Software Development
11 227 (35.14%) Finance
12 207 (32.04%) T-SQL
13 198 (30.65%) Oracle
13 198 (30.65%) Oracle OLAP
14 187 (28.95%) Analytics
15 175 (27.09%) Analytical Skills
16 164 (25.39%) OLAP Cube
17 163 (25.23%) MDX
18 156 (24.15%) Kimball Methodology
19 152 (23.53%) Java
20 151 (23.37%) PL/SQL
21 143 (22.14%) Power BI
22 140 (21.67%) Banking
23 132 (20.43%) OLTP
24 129 (19.97%) Python
25 116 (17.96%) Dimensional Modelling
26 113 (17.49%) Data Modelling
27 111 (17.18%) Data Analytics
28 109 (16.87%) Unix
28 109 (16.87%) Relational Database

OLAP
Co-occurring IT Skills in England 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 50 (7.74%) SharePoint
2 17 (2.63%) Apache Spark
3 12 (1.86%) SAS
4 11 (1.70%) IIS
5 10 (1.55%) Apache
6 9 (1.39%) Skype for Business
7 8 (1.24%) Elasticsearch
8 4 (0.62%) SharePoint 2010
9 2 (0.31%) GemFire
9 2 (0.31%) Oracle SOA Suite
10 1 (0.15%) Apache Solr
10 1 (0.15%) SharePoint 2013
10 1 (0.15%) Tomcat
Applications
1 58 (8.98%) Microsoft Excel
2 11 (1.70%) MS Visio
3 8 (1.24%) Microsoft Office
4 6 (0.93%) Microsoft PowerPoint
5 4 (0.62%) Microsoft Project
Business Applications
1 18 (2.79%) Cognos TM1
2 16 (2.48%) Cognos Business Intelligence
3 8 (1.24%) Cognos Planning
4 5 (0.77%) Dynamics CRM
4 5 (0.77%) HFM
5 2 (0.31%) Dynamics AX
5 2 (0.31%) SAP ERP
6 1 (0.15%) Oracle Applications
6 1 (0.15%) Oracle Financials
6 1 (0.15%) Remedy ITSM
Cloud Services
1 64 (9.91%) Microsoft Azure
2 24 (3.72%) Amazon AWS
3 15 (2.32%) Azure Data Factory
4 9 (1.39%) GitHub
5 6 (0.93%) Office 365
6 4 (0.62%) Google Cloud Platform
7 2 (0.31%) Amazon EMR
7 2 (0.31%) Amazon S3
8 1 (0.15%) Cloud Computing
8 1 (0.15%) Dynamics 365
8 1 (0.15%) SaaS
Communications & Networking
1 14 (2.17%) SAN
2 9 (1.39%) HTTPS
2 9 (1.39%) ISDN
3 6 (0.93%) Extranet
3 6 (0.93%) Intranet
4 5 (0.77%) NAS
4 5 (0.77%) SSL
5 4 (0.62%) Kerberos
6 3 (0.46%) Internet
7 2 (0.31%) DNS
8 1 (0.15%) DHCP
8 1 (0.15%) Firewall
8 1 (0.15%) HTTP
8 1 (0.15%) SMS
Database & Business Intelligence
1 447 (69.20%) Data Warehouse
2 371 (57.43%) SQL Server
3 334 (51.70%) SQL Server Integration Services
4 314 (48.61%) SQL Server Analysis Services
5 287 (44.43%) SQL Server Reporting Services
6 198 (30.65%) Oracle OLAP
7 164 (25.39%) OLAP Cube
8 143 (22.14%) Power BI
9 132 (20.43%) OLTP
10 109 (16.87%) Relational Database
11 82 (12.69%) QlikView
12 79 (12.23%) SQL Server 2008
13 71 (10.99%) Big Data
14 60 (9.29%) MySQL
15 57 (8.82%) SQL Server 2012
16 54 (8.36%) Microsoft Analysis Services
17 47 (7.28%) BusinessObjects
17 47 (7.28%) SQL Server 2016
18 45 (6.97%) SQL Server 2014
19 44 (6.81%) Oracle Database
Development Applications
1 37 (5.73%) Team Foundation Server
2 35 (5.42%) Visual Studio
3 16 (2.48%) SQL Server Management Studio (SSMS)
4 15 (2.32%) JIRA
5 11 (1.70%) Eclipse
6 9 (1.39%) tSQLt
7 8 (1.24%) Git (software)
7 8 (1.24%) Maven
8 7 (1.08%) Octopus Deploy
9 5 (0.77%) JUnit
10 4 (0.62%) PowerDesigner
11 3 (0.46%) Talend Open Studio
12 2 (0.31%) ERwin
12 2 (0.31%) 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 227 (35.14%) Finance
2 140 (21.67%) Banking
3 102 (15.79%) Investment Banking
4 101 (15.63%) Retail Banking
5 39 (6.04%) Advertising
6 27 (4.18%) Retail
7 23 (3.56%) Marketing
8 17 (2.63%) Publishing
9 10 (1.55%) Legal
10 6 (0.93%) Front Office
11 4 (0.62%) Dutch Language
11 4 (0.62%) French Language
11 4 (0.62%) German Language
11 4 (0.62%) Italian Language
11 4 (0.62%) Spanish Language
12 2 (0.31%) Financial Institution
13 1 (0.15%) International Banking
13 1 (0.15%) Manufacturing
13 1 (0.15%) Telecoms
Job Titles
1 358 (55.42%) Developer
2 177 (27.40%) Business Intelligence Developer
3 124 (19.20%) SQL Developer
4 83 (12.85%) Analyst
5 73 (11.30%) Quantitative Developer
6 70 (10.84%) SQL BI Developer
7 48 (7.43%) Data Warehouse Developer
8 47 (7.28%) SSRS Developer
9 44 (6.81%) Business Developer
9 44 (6.81%) DBA
10 43 (6.66%) Consultant
10 43 (6.66%) SSIS Developer
11 38 (5.88%) SSAS Developer
12 32 (4.95%) SQL DBA
13 30 (4.64%) Architect
13 30 (4.64%) Business Intelligence Consultant
13 30 (4.64%) Senior Developer
14 29 (4.49%) Administrator
14 29 (4.49%) SQL Server Developer
15 28 (4.33%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 163 (25.23%) MDX
2 66 (10.22%) .NET
3 46 (7.12%) XML
4 38 (5.88%) Web Services
5 25 (3.87%) Oracle GoldenGate
6 22 (3.41%) HTML
7 17 (2.63%) WPF
8 11 (1.70%) SOAP
9 10 (1.55%) JSON
9 10 (1.55%) WSDL
10 8 (1.24%) REST
10 8 (1.24%) Spring
11 6 (0.93%) ASP.NET
12 5 (0.77%) Pandas
12 5 (0.77%) RESTful
12 5 (0.77%) XML Messaging
12 5 (0.77%) XSD
13 4 (0.62%) .NET Framework
13 4 (0.62%) AngularJS
13 4 (0.62%) RabbitMQ
Miscellaneous
1 175 (27.09%) Analytical Skills
2 97 (15.02%) Enterprise Software
3 32 (4.95%) Replication
4 29 (4.49%) Management Information System
5 17 (2.63%) Computer Science
6 11 (1.70%) Fintech
7 10 (1.55%) Clustering
8 9 (1.39%) Credit Risk
8 9 (1.39%) Cyber Attack
8 9 (1.39%) Reinsurance
9 8 (1.24%) PMI
10 7 (1.08%) Data Structures
10 7 (1.08%) Foreign Exchange (FX)
10 7 (1.08%) iPad
10 7 (1.08%) iPhone
10 7 (1.08%) Mobile App
11 6 (0.93%) Data Centre
11 6 (0.93%) Equities
12 5 (0.77%) N-Tier
12 5 (0.77%) Renewable Energy
Operating Systems
1 109 (16.87%) Unix
2 35 (5.42%) Windows
3 30 (4.64%) Linux
4 15 (2.32%) Windows Server
5 6 (0.93%) Solaris
6 2 (0.31%) 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 405 (62.69%) Business Intelligence
2 336 (52.01%) ETL
3 236 (36.53%) Agile Software Development
4 187 (28.95%) Analytics
5 156 (24.15%) Kimball Methodology
6 116 (17.96%) Dimensional Modelling
7 113 (17.49%) Data Modelling
8 111 (17.18%) Data Analytics
9 103 (15.94%) Asset Management
10 99 (15.33%) Release Management
11 95 (14.71%) Performance Tuning
12 93 (14.40%) Wealth Management
13 90 (13.93%) Quantitative Research
14 69 (10.68%) ETL Development
15 50 (7.74%) Data Management
16 48 (7.43%) Visualisation
17 45 (6.97%) ITIL
18 44 (6.81%) E-Commerce
18 44 (6.81%) Scrum
19 42 (6.50%) Data Analysis
Programming Languages
1 528 (81.73%) SQL
2 207 (32.04%) T-SQL
3 152 (23.53%) Java
4 151 (23.37%) PL/SQL
5 129 (19.97%) Python
6 100 (15.48%) R
7 92 (14.24%) Perl
8 90 (13.93%) C++
9 86 (13.31%) C#
10 31 (4.80%) PowerShell
11 29 (4.49%) Data Analysis Expressions (DAX)
12 20 (3.10%) VB.NET
13 11 (1.70%) VB
14 9 (1.39%) VBA
15 8 (1.24%) C
16 6 (0.93%) JavaScript
17 5 (0.77%) Scala
17 5 (0.77%) VBScript
18 4 (0.62%) Go
18 4 (0.62%) PHP
Qualifications
1 79 (12.23%) Degree
2 24 (3.72%) Microsoft Certification
3 10 (1.55%) MCSA
4 9 (1.39%) MCSE
5 8 (1.24%) MBA
5 8 (1.24%) MCDBA
5 8 (1.24%) PMI Certification
5 8 (1.24%) Security Cleared
6 7 (1.08%) MCITP
6 7 (1.08%) Oracle Certification
7 6 (0.93%) SC Cleared
8 2 (0.31%) Computer Science Degree
8 2 (0.31%) MCSD
8 2 (0.31%) MCTS
9 1 (0.15%) APMP
9 1 (0.15%) Numerate Degree
9 1 (0.15%) OCP
Quality Assurance & Compliance
1 69 (10.68%) Data Quality
2 39 (6.04%) QA
3 9 (1.39%) ISO/IEC 27001
4 4 (0.62%) GDPR
5 2 (0.31%) GCP
6 1 (0.15%) SLA
System Software
1 16 (2.48%) Active Directory
2 6 (0.93%) Oracle RAC
2 6 (0.93%) VMware Infrastructure
3 5 (0.77%) Firmware
4 2 (0.31%) Apache Flume
4 2 (0.31%) Docker
4 2 (0.31%) HDFS
4 2 (0.31%) KVM
5 1 (0.15%) Hyper-V
5 1 (0.15%) VMware ESXi
Systems Management
1 8 (1.24%) Microsoft Clustering
2 5 (0.77%) SCCM
2 5 (0.77%) SCOM
3 3 (0.46%) Ansible
3 3 (0.46%) Systems Management Server (SMS)
4 2 (0.31%) Hadoop YARN
4 2 (0.31%) Kubernetes
5 1 (0.15%) Netcool
5 1 (0.15%) Oozie
5 1 (0.15%) Opscode Chef
5 1 (0.15%) Puppet
5 1 (0.15%) vCenter Server
Vendors
1 243 (37.62%) Microsoft
2 198 (30.65%) Oracle
3 79 (12.23%) Tableau
4 47 (7.28%) Cognos
5 24 (3.72%) RedGate
6 19 (2.94%) MicroStrategy
7 18 (2.79%) SAP
8 16 (2.48%) IBM
9 14 (2.17%) Informatica
9 14 (2.17%) NetApp
10 11 (1.70%) Hyperion
10 11 (1.70%) VMware
11 9 (1.39%) Apple
11 9 (1.39%) Avaya
11 9 (1.39%) Tagetik
11 9 (1.39%) Teradata
12 7 (1.08%) IFS
12 7 (1.08%) TIBCO
13 5 (0.77%) Cisco
13 5 (0.77%) Pega