Period
to 23 February 2018

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

Online Analytical Processing (OLAP)
UK > England
6 months to
23 Feb 2018
Same period 2017 Same period 2016
Rank 670 653 557
Rank change year-on-year -17 -96 -20
Permanent jobs citing OLAP 526 554 926
As % of all permanent IT jobs advertised in England 0.32% 0.33% 0.47%
As % of the Database & Business Intelligence category 1.04% 1.12% 1.47%
Number of salaries quoted 418 464 758
England median annual salary £50,000 £50,000 £50,000
10th Percentile £31,250 £35,000 £34,000
90th Percentile £70,375 £72,500 £70,250
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 50,490 49,545 63,156
As % of all permanent IT jobs advertised in England 30.62% 29.92% 31.78%
Number of salaries quoted 42,473 42,617 53,945
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £30,500 £30,000 £28,750
90th Percentile £79,750 £77,500 £75,000
UK median annual salary £49,000 £47,500 £45,500
% change year-on-year +3.16% +4.40% +1.11%

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 23 February 2018.

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 23 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
London +31 256 £55,000 -8.33% 25
North of England +23 89 £42,500 -2.86% 11
South East -62 79 £52,500 +5.00% 12
Midlands +14 47 £34,000 -22.29%
North West +2 45 £45,000 +16.13% 8
Yorkshire +16 33 £30,000 -33.33% 2
West Midlands -1 33 £38,250 -10.00%
East of England -32 29 £45,000 +4.65% 6
South West +29 26 £40,000 -20.00% 2
East Midlands +7 14 £30,000 -33.33%
North East -16 11 £35,595 -20.90% 1
OLAP
UK

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

1 407 (77.38%) SQL
2 403 (76.62%) Business Intelligence
3 304 (57.79%) SQL Server
4 303 (57.60%) Data Warehouse
5 299 (56.84%) SQL Server Integration Services
6 271 (51.52%) SQL Server Reporting Services
7 264 (50.19%) ETL
8 262 (49.81%) SQL Server Analysis Services
9 233 (44.30%) Microsoft
10 172 (32.70%) T-SQL
11 157 (29.85%) Agile Software Development
12 152 (28.90%) Power BI
13 137 (26.05%) Finance
14 133 (25.29%) Analytics
15 126 (23.95%) Oracle OLAP
15 126 (23.95%) Oracle
16 116 (22.05%) Data Modelling
16 116 (22.05%) OLAP Cube
17 113 (21.48%) MDX
18 109 (20.72%) Analytical Skills
19 108 (20.53%) OLTP
20 103 (19.58%) Kimball Methodology
21 91 (17.30%) C#
22 84 (15.97%) Microsoft Azure
23 81 (15.40%) .NET
24 80 (15.21%) Java
25 78 (14.83%) Dimensional Modelling
26 75 (14.26%) Visualisation
27 72 (13.69%) Degree
28 71 (13.50%) Python

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 26 (4.94%) SharePoint
2 22 (4.18%) Apache Spark
3 20 (3.80%) SAS
4 18 (3.42%) Apache
5 11 (2.09%) Elasticsearch
6 10 (1.90%) IIS
7 8 (1.52%) Skype for Business
8 4 (0.76%) Apache Solr
9 3 (0.57%) Oracle Application Server
9 3 (0.57%) SharePoint 2010
9 3 (0.57%) WordPress
10 2 (0.38%) Tomcat
11 1 (0.19%) Apache Pig
11 1 (0.19%) SharePoint 2013
Applications
1 64 (12.17%) Microsoft Excel
2 14 (2.66%) Microsoft Office
3 10 (1.90%) Microsoft PowerPoint
4 4 (0.76%) Microsoft Project
5 3 (0.57%) MS Visio
6 2 (0.38%) Spreadsheet
Business Applications
1 29 (5.51%) Cognos TM1
2 9 (1.71%) Cognos Planning
3 8 (1.52%) SAP BPC
4 7 (1.33%) Dynamics AX
4 7 (1.33%) Dynamics CRM
5 6 (1.14%) Cognos Business Intelligence
5 6 (1.14%) HFM
6 4 (0.76%) Hyperion Planning
6 4 (0.76%) SAP ERP
7 3 (0.57%) NetSuite
8 2 (0.38%) Remedy ITSM
9 1 (0.19%) Infor SunSystems
9 1 (0.19%) Oracle Applications
9 1 (0.19%) Oracle Financials
Cloud Services
1 84 (15.97%) Microsoft Azure
2 21 (3.99%) Amazon AWS
3 14 (2.66%) Azure Data Factory
4 9 (1.71%) Google Cloud Platform
5 8 (1.52%) SaaS
6 7 (1.33%) Dynamics 365
7 3 (0.57%) PaaS
8 2 (0.38%) Amazon EMR
8 2 (0.38%) Amazon S3
8 2 (0.38%) Azure Active Directory
8 2 (0.38%) Data Lake Analytics
9 1 (0.19%) AWS Lambda
9 1 (0.19%) Cloud Computing
9 1 (0.19%) GitHub
9 1 (0.19%) IaaS
9 1 (0.19%) Office 365
9 1 (0.19%) Serverless
Communications & Networking
1 12 (2.28%) SSL
2 10 (1.90%) SAN
3 8 (1.52%) HTTPS
3 8 (1.52%) ISDN
4 2 (0.38%) Kerberos
4 2 (0.38%) NAS
5 1 (0.19%) HTTP
5 1 (0.19%) SMS
Database & Business Intelligence
1 304 (57.79%) SQL Server
2 303 (57.60%) Data Warehouse
3 299 (56.84%) SQL Server Integration Services
4 271 (51.52%) SQL Server Reporting Services
5 262 (49.81%) SQL Server Analysis Services
6 152 (28.90%) Power BI
7 126 (23.95%) Oracle OLAP
8 116 (22.05%) OLAP Cube
9 108 (20.53%) OLTP
10 66 (12.55%) Relational Database
11 63 (11.98%) Big Data
12 61 (11.60%) SQL Server 2008
13 50 (9.51%) QlikView
14 47 (8.94%) MySQL
15 42 (7.98%) SQL Server 2016
16 38 (7.22%) Microsoft Analysis Services
17 37 (7.03%) Hadoop
18 34 (6.46%) SQL Server 2012
19 29 (5.51%) NoSQL
19 29 (5.51%) SQL Server 2014
Development Applications
1 36 (6.84%) SQL Server Management Studio (SSMS)
2 25 (4.75%) Team Foundation Server
3 23 (4.37%) Visual Studio
4 19 (3.61%) Eclipse
5 14 (2.66%) ERwin
5 14 (2.66%) JUnit
5 14 (2.66%) Maven
6 8 (1.52%) Git (software)
7 5 (0.95%) Visual Studio Team System
8 4 (0.76%) Jenkins
9 3 (0.57%) JIRA
9 3 (0.57%) TeamCity
10 2 (0.38%) LINQPad
11 1 (0.19%) Bitbucket
11 1 (0.19%) Octopus Deploy
11 1 (0.19%) TestNG
11 1 (0.19%) Toad
11 1 (0.19%) tSQLt
General
1 137 (26.05%) Finance
2 55 (10.46%) Advertising
3 52 (9.89%) Banking
4 26 (4.94%) Marketing
5 25 (4.75%) Investment Banking
6 24 (4.56%) Retail Banking
7 23 (4.37%) Retail
8 7 (1.33%) Front Office
9 6 (1.14%) Publishing
10 5 (0.95%) Back Office
10 5 (0.95%) Billing
11 4 (0.76%) Games
11 4 (0.76%) Pharmaceutical
11 4 (0.76%) Telecoms
12 3 (0.57%) Financial Institution
13 1 (0.19%) International Banking
13 1 (0.19%) Law
13 1 (0.19%) Manufacturing
Job Titles
1 286 (54.37%) Developer
2 162 (30.80%) Business Intelligence Developer
3 100 (19.01%) SQL Developer
4 68 (12.93%) Analyst
5 63 (11.98%) SQL BI Developer
6 51 (9.70%) Architect
7 47 (8.94%) SSRS Developer
8 45 (8.56%) SSIS Developer
9 36 (6.84%) SQL Server Developer
10 34 (6.46%) SSAS Developer
11 33 (6.27%) Data Warehouse Developer
12 32 (6.08%) Business Intelligence Analyst
12 32 (6.08%) Business Intelligence Lead
13 31 (5.89%) Consultant
14 28 (5.32%) DBA
15 27 (5.13%) Business Developer
15 27 (5.13%) SQL DBA
15 27 (5.13%) T-SQL Developer
16 25 (4.75%) Senior Developer
17 23 (4.37%) Data Analyst
Libraries, Frameworks & Software Standards
1 113 (21.48%) MDX
2 81 (15.40%) .NET
3 37 (7.03%) XML
4 33 (6.27%) Web Services
4 33 (6.27%) WPF
5 23 (4.37%) ASP.NET
6 21 (3.99%) SOAP
7 19 (3.61%) JSON
8 14 (2.66%) HTML
9 13 (2.47%) ASP.NET Web API
9 13 (2.47%) Spring
9 13 (2.47%) WSDL
10 11 (2.09%) AngularJS
11 10 (1.90%) Oracle GoldenGate
11 10 (1.90%) REST
12 8 (1.52%) .NET Framework
12 8 (1.52%) Angular 2
12 8 (1.52%) ASP.NET Core
12 8 (1.52%) Entity Framework
13 5 (0.95%) Pandas
Miscellaneous
1 109 (20.72%) Analytical Skills
2 28 (5.32%) Management Information System
3 27 (5.13%) Computer Science
4 23 (4.37%) Fintech
5 21 (3.99%) Enterprise Software
6 16 (3.04%) Replication
7 12 (2.28%) Data Centre
7 12 (2.28%) Mobile App
7 12 (2.28%) PMI
8 11 (2.09%) Clustering
9 8 (1.52%) Cyberattack
9 8 (1.52%) Data Structures
9 8 (1.52%) Reinsurance
9 8 (1.52%) Taxonomies
9 8 (1.52%) Virtual Team
10 7 (1.33%) iPhone
11 6 (1.14%) Greenfield Project
11 6 (1.14%) Hedge funds
11 6 (1.14%) Hybrid Cloud
11 6 (1.14%) User Experience
Operating Systems
1 37 (7.03%) Linux
2 35 (6.65%) Unix
3 23 (4.37%) Windows
4 13 (2.47%) Windows Server
5 4 (0.76%) Red Hat Enterprise Linux
6 3 (0.57%) CentOS
6 3 (0.57%) Windows Server 2008
6 3 (0.57%) Windows Server 2012
7 2 (0.38%) Solaris
8 1 (0.19%) HPUX
8 1 (0.19%) Windows Server 2003
Processes & Methodologies
1 403 (76.62%) Business Intelligence
2 264 (50.19%) ETL
3 157 (29.85%) Agile Software Development
4 133 (25.29%) Analytics
5 116 (22.05%) Data Modelling
6 103 (19.58%) Kimball Methodology
7 78 (14.83%) Dimensional Modelling
8 75 (14.26%) Visualisation
9 62 (11.79%) Data Visualisation
9 62 (11.79%) Performance Tuning
10 56 (10.65%) Data Management
11 45 (8.56%) Data Analytics
11 45 (8.56%) ETL Development
12 44 (8.37%) Data Architecture
13 42 (7.98%) Data Analysis
13 42 (7.98%) Data Integration
13 42 (7.98%) Master Data Management
14 39 (7.41%) Scrum
15 34 (6.46%) Business Continuity
16 33 (6.27%) ERP
Programming Languages
1 407 (77.38%) SQL
2 172 (32.70%) T-SQL
3 91 (17.30%) C#
4 80 (15.21%) Java
5 71 (13.50%) Python
6 56 (10.65%) PL/SQL
7 43 (8.17%) PowerShell
8 39 (7.41%) R
9 29 (5.51%) Perl
10 22 (4.18%) VBA
11 21 (3.99%) C++
12 18 (3.42%) Data Analysis Expressions (DAX)
13 16 (3.04%) VB.NET
14 14 (2.66%) JavaScript
15 11 (2.09%) Scala
16 8 (1.52%) TypeScript
16 8 (1.52%) VB
17 7 (1.33%) C
17 7 (1.33%) Shell Script
18 4 (0.76%) VB6
Qualifications
1 72 (13.69%) Degree
2 12 (2.28%) MBA
2 12 (2.28%) PMI Certification
3 9 (1.71%) Security Cleared
4 8 (1.52%) Computer Science Degree
4 8 (1.52%) Microsoft Certification
5 5 (0.95%) SC Cleared
6 4 (0.76%) MCSA
6 4 (0.76%) MCSD
6 4 (0.76%) Microsoft Certified Architect
7 2 (0.38%) ACCA
7 2 (0.38%) MCDBA
7 2 (0.38%) MCSE
8 1 (0.19%) CIMA
8 1 (0.19%) OCP
8 1 (0.19%) Oracle Certification
8 1 (0.19%) PhD
Quality Assurance & Compliance
1 51 (9.70%) Data Quality
2 28 (5.32%) QA
3 8 (1.52%) ISO/IEC 27001
4 4 (0.76%) GDPR
5 3 (0.57%) PMO
System Software
1 16 (3.04%) Active Directory
2 5 (0.95%) HDFS
3 4 (0.76%) Apache Flume
4 3 (0.57%) Docker
5 2 (0.38%) Firmware
5 2 (0.38%) Virtual Machines
5 2 (0.38%) VMware Infrastructure
6 1 (0.19%) Apache ZooKeeper
6 1 (0.19%) Hyper-V
Systems Management
1 10 (1.90%) Systems Management Server (SMS)
2 4 (0.76%) Puppet
2 4 (0.76%) Single Sign-On
3 3 (0.57%) Hadoop YARN
3 3 (0.57%) Oozie
4 2 (0.38%) Microsoft Clustering
4 2 (0.38%) Netcool
4 2 (0.38%) SCCM
4 2 (0.38%) SCOM
5 1 (0.19%) Control-M
5 1 (0.19%) Opscode Chef
Vendors
1 233 (44.30%) Microsoft
2 126 (23.95%) Oracle
3 56 (10.65%) Tableau
4 49 (9.32%) Cognos
5 19 (3.61%) SAP
6 18 (3.42%) Hyperion
7 17 (3.23%) MicroStrategy
8 15 (2.85%) Teradata
9 14 (2.66%) IBM
9 14 (2.66%) IFS
10 12 (2.28%) Cisco
11 10 (1.90%) Netezza
11 10 (1.90%) Tagetik
12 8 (1.52%) Apple
12 8 (1.52%) Avaya
12 8 (1.52%) Google
12 8 (1.52%) NetApp
13 7 (1.33%) Informatica
14 6 (1.14%) Salesforce.com
14 6 (1.14%) TIBCO