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

Online Analytical Processing (OLAP)
UK > England
6 months to
20 May 2018
Same period 2017 Same period 2016
Rank 671 634 632
Rank change year-on-year -37 -2 -98
Permanent jobs citing OLAP 515 578 740
As % of all permanent IT jobs advertised in England 0.32% 0.36% 0.39%
As % of the Database & Business Intelligence category 1.04% 1.17% 1.26%
Number of salaries quoted 436 489 604
England median annual salary £47,500 £51,500 £52,500
Median salary % change year-on-year -7.77% -1.90% -
10th Percentile £31,250 £33,750 £36,250
90th Percentile £77,188 £72,500 £73,250
UK median annual salary £47,500 £50,000 £52,500
% change year-on-year -5.00% -4.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 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 49,438 49,284 58,690
As % of all permanent IT jobs advertised in England 30.72% 30.67% 31.05%
Number of salaries quoted 40,837 42,283 50,573
England median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £29,000
90th Percentile £81,250 £77,500 £75,000
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

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 May 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 20 May 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 -41 239 £55,000 -8.33% 26
North of England +45 92 £45,000 +12.50% 1
South East -36 89 £47,500 -13.64% 5
North West +14 47 £47,500 +31.94% 1
East of England -31 36 £47,500 +10.47%
Yorkshire +34 32 £42,500 -
Midlands -26 31 £35,000 -12.50%
South West +12 28 £40,000 -13.51% 2
West Midlands +5 18 £38,250 -4.38%
East Midlands -22 13 £35,000 -15.15%
North East - 13 £36,000 -
OLAP
UK

For the 6 months to 20 May 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 (79.03%) Business Intelligence
2 406 (78.83%) SQL
3 327 (63.50%) SQL Server
4 314 (60.97%) SQL Server Integration Services
5 295 (57.28%) ETL
6 288 (55.92%) SQL Server Reporting Services
7 285 (55.34%) Data Warehouse
8 279 (54.17%) Microsoft
9 242 (46.99%) SQL Server Analysis Services
10 172 (33.40%) Power BI
11 168 (32.62%) T-SQL
12 156 (30.29%) Analytics
13 152 (29.51%) Agile Software Development
14 135 (26.21%) OLTP
15 128 (24.85%) Data Modelling
16 125 (24.27%) Microsoft Azure
17 118 (22.91%) .NET
17 118 (22.91%) C#
18 113 (21.94%) Oracle
18 113 (21.94%) Oracle OLAP
19 109 (21.17%) Analytical Skills
20 108 (20.97%) Visualisation
21 103 (20.00%) OLAP Cube
22 100 (19.42%) Finance
23 82 (15.92%) MDX
24 81 (15.73%) Kimball Methodology
25 80 (15.53%) Data Visualisation
25 80 (15.53%) Advertising
26 76 (14.76%) Problem-Solving
27 75 (14.56%) Degree

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 38 (7.38%) SAS
2 24 (4.66%) Apache Spark
3 18 (3.50%) SharePoint
4 16 (3.11%) Apache
4 16 (3.11%) Elasticsearch
5 5 (0.97%) Confluence
5 5 (0.97%) Oracle Application Server
6 4 (0.78%) Apache Solr
6 4 (0.78%) Tomcat
6 4 (0.78%) WordPress
7 3 (0.58%) JBoss
7 3 (0.58%) WebLogic
7 3 (0.58%) WebSphere
8 2 (0.39%) Apache Pig
8 2 (0.39%) IIS
8 2 (0.39%) SharePoint 2010
8 2 (0.39%) SugarCRM
9 1 (0.19%) Oracle SOA Suite
9 1 (0.19%) Skype for Business
Applications
1 59 (11.46%) Microsoft Excel
2 18 (3.50%) Microsoft Office
3 6 (1.17%) Microsoft PowerPoint
4 5 (0.97%) Spreadsheet
5 3 (0.58%) MS Visio
6 1 (0.19%) Microsoft Project
6 1 (0.19%) S-PLUS
Business Applications
1 20 (3.88%) Cognos TM1
2 9 (1.75%) Dynamics AX
2 9 (1.75%) SAP BPC
3 8 (1.55%) Dynamics CRM
4 7 (1.36%) SAP ERP
5 5 (0.97%) Hyperion Planning
6 4 (0.78%) Cognos Planning
6 4 (0.78%) SAP Forecasting and Replenishment
6 4 (0.78%) SAP Retail
7 3 (0.58%) HFM
7 3 (0.58%) NetSuite
8 1 (0.19%) Dynamics NAV
8 1 (0.19%) Infor SunSystems
8 1 (0.19%) Remedy ITSM
Cloud Services
1 125 (24.27%) Microsoft Azure
2 33 (6.41%) Amazon AWS
3 17 (3.30%) SaaS
4 16 (3.11%) Google Cloud Platform
5 15 (2.91%) Azure Data Factory
6 7 (1.36%) Dynamics 365
7 5 (0.97%) IaaS
7 5 (0.97%) PaaS
8 4 (0.78%) Amazon S3
8 4 (0.78%) Data Lake Analytics
9 3 (0.58%) Amazon EMR
9 3 (0.58%) Cloud Computing
10 2 (0.39%) AWS Lambda
10 2 (0.39%) Azure Active Directory
10 2 (0.39%) Serverless
11 1 (0.19%) Boomi
Communications & Networking
1 21 (4.08%) SSL
2 3 (0.58%) SAN
3 1 (0.19%) HTTP
3 1 (0.19%) HTTPS
3 1 (0.19%) ISDN
Database & Business Intelligence
1 327 (63.50%) SQL Server
2 314 (60.97%) SQL Server Integration Services
3 288 (55.92%) SQL Server Reporting Services
4 285 (55.34%) Data Warehouse
5 242 (46.99%) SQL Server Analysis Services
6 172 (33.40%) Power BI
7 135 (26.21%) OLTP
8 113 (21.94%) Oracle OLAP
9 103 (20.00%) OLAP Cube
10 72 (13.98%) Big Data
11 61 (11.84%) Relational Database
12 60 (11.65%) MySQL
13 55 (10.68%) Hadoop
14 46 (8.93%) QlikView
15 44 (8.54%) SQL Server 2016
16 40 (7.77%) SQL Server 2008
17 34 (6.60%) Microsoft Analysis Services
18 32 (6.21%) Star Schema
19 31 (6.02%) NoSQL
20 30 (5.83%) SQL Server 2014
Development Applications
1 40 (7.77%) SQL Server Management Studio (SSMS)
2 23 (4.47%) ERwin
2 23 (4.47%) Visual Studio
3 21 (4.08%) Team Foundation Server
4 15 (2.91%) Git (software)
4 15 (2.91%) Visual Studio Team System
5 14 (2.72%) Maven
6 11 (2.14%) JUnit
7 9 (1.75%) Eclipse
8 8 (1.55%) ER Studio
9 7 (1.36%) Jenkins
9 7 (1.36%) JIRA
10 5 (0.97%) Toad
11 3 (0.58%) Ant
11 3 (0.58%) Gradle
11 3 (0.58%) TeamCity
12 2 (0.39%) Bitbucket
12 2 (0.39%) LINQPad
12 2 (0.39%) TestNG
13 1 (0.19%) Subversion
General
1 100 (19.42%) Finance
2 80 (15.53%) Advertising
3 24 (4.66%) Marketing
3 24 (4.66%) Retail
4 21 (4.08%) Banking
5 10 (1.94%) Front Office
5 10 (1.94%) Games
6 8 (1.55%) Pharmaceutical
7 5 (0.97%) Back Office
7 5 (0.97%) Billing
7 5 (0.97%) Investment Banking
8 4 (0.78%) Financial Institution
8 4 (0.78%) International Banking
8 4 (0.78%) Russian Language
9 3 (0.58%) Law
9 3 (0.58%) Publishing
9 3 (0.58%) Telecoms
10 2 (0.39%) Dutch Language
10 2 (0.39%) French Language
10 2 (0.39%) Manufacturing
Job Titles
1 270 (52.43%) Developer
2 150 (29.13%) Business Intelligence Developer
3 92 (17.86%) SQL Developer
4 80 (15.53%) Architect
5 60 (11.65%) Analyst
6 55 (10.68%) SSRS Developer
7 53 (10.29%) SSIS Developer
8 47 (9.13%) SQL BI Developer
9 42 (8.16%) SQL Server Developer
10 41 (7.96%) Data Architect
11 37 (7.18%) DBA
12 33 (6.41%) Business Intelligence Analyst
13 31 (6.02%) Senior Developer
13 31 (6.02%) SQL DBA
14 29 (5.63%) C# Developer
14 29 (5.63%) Solutions Architect
15 26 (5.05%) SQL Server BI Developer
16 22 (4.27%) Consultant
16 22 (4.27%) Database Developer
16 22 (4.27%) Technical Architect
Libraries, Frameworks & Software Standards
1 118 (22.91%) .NET
2 82 (15.92%) MDX
3 48 (9.32%) WPF
4 42 (8.16%) XML
5 40 (7.77%) SOAP
6 37 (7.18%) Web Services
7 30 (5.83%) JSON
8 28 (5.44%) ASP.NET
9 21 (4.08%) WSDL
10 17 (3.30%) AngularJS
10 17 (3.30%) ASP.NET Web API
11 15 (2.91%) REST
12 14 (2.72%) .NET Framework
12 14 (2.72%) Angular 2
12 14 (2.72%) ASP.NET Core
12 14 (2.72%) Entity Framework
13 13 (2.52%) Kafka
14 12 (2.33%) Spring
15 10 (1.94%) HTML
16 9 (1.75%) CSS
Miscellaneous
1 109 (21.17%) Analytical Skills
2 42 (8.16%) Computer Science
3 24 (4.66%) Fintech
3 24 (4.66%) Self-Motivation
4 23 (4.47%) Data Centre
4 23 (4.47%) Management Information System
5 21 (4.08%) Mobile App
6 17 (3.30%) Replication
7 13 (2.52%) Data Structures
8 12 (2.33%) Hybrid Cloud
8 12 (2.33%) Taxonomies
9 11 (2.14%) Virtual Team
10 10 (1.94%) Clustering
10 10 (1.94%) Greenfield Project
11 8 (1.55%) Enterprise Software
11 8 (1.55%) iPad
11 8 (1.55%) Life Science
12 7 (1.36%) User Experience
13 6 (1.17%) Hedge funds
13 6 (1.17%) Reinsurance
Operating Systems
1 32 (6.21%) Linux
2 14 (2.72%) Unix
3 13 (2.52%) Windows
4 6 (1.17%) Windows Server
5 3 (0.58%) CentOS
5 3 (0.58%) Red Hat Enterprise Linux
6 2 (0.39%) Windows Server 2008
6 2 (0.39%) Windows Server 2012
7 1 (0.19%) Solaris
Processes & Methodologies
1 407 (79.03%) Business Intelligence
2 295 (57.28%) ETL
3 156 (30.29%) Analytics
4 152 (29.51%) Agile Software Development
5 128 (24.85%) Data Modelling
6 108 (20.97%) Visualisation
7 81 (15.73%) Kimball Methodology
8 80 (15.53%) Data Visualisation
9 76 (14.76%) Problem-Solving
10 66 (12.82%) Data Architecture
11 65 (12.62%) Performance Tuning
12 57 (11.07%) Data Integration
13 55 (10.68%) Data Analytics
14 53 (10.29%) Dimensional Modelling
15 49 (9.51%) Data Analysis
16 36 (6.99%) ERP
17 35 (6.80%) Logical Data Model
17 35 (6.80%) Scrum
17 35 (6.80%) SDLC
18 33 (6.41%) Physical Data Model
Programming Languages
1 406 (78.83%) SQL
2 168 (32.62%) T-SQL
3 118 (22.91%) C#
4 66 (12.82%) PowerShell
5 60 (11.65%) Java
6 56 (10.87%) Python
7 32 (6.21%) VBA
8 24 (4.66%) PL/SQL
9 23 (4.47%) JavaScript
10 22 (4.27%) R
11 17 (3.30%) Perl
12 16 (3.11%) Data Analysis Expressions (DAX)
12 16 (3.11%) VB.NET
13 15 (2.91%) Scala
14 14 (2.72%) TypeScript
15 12 (2.33%) Shell Script
16 9 (1.75%) VB
17 8 (1.55%) C
17 8 (1.55%) MATLAB
18 5 (0.97%) VB6
Qualifications
1 75 (14.56%) Degree
2 21 (4.08%) TOGAF Certification
3 14 (2.72%) Computer Science Degree
4 9 (1.75%) Microsoft Certification
5 8 (1.55%) MCSD
5 8 (1.55%) Microsoft Certified Architect
6 7 (1.36%) Security Cleared
7 5 (0.97%) PMI Certification
7 5 (0.97%) SC Cleared
8 4 (0.78%) MBA
9 2 (0.39%) ACCA
9 2 (0.39%) OCP
9 2 (0.39%) Oracle Certification
9 2 (0.39%) 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 37 (7.18%) Data Quality
2 17 (3.30%) QA
3 8 (1.55%) GDPR
4 4 (0.78%) SLA
5 3 (0.58%) EFQM
5 3 (0.58%) PMO
6 1 (0.19%) ISO/IEC 27001
System Software
1 11 (2.14%) HDFS
2 9 (1.75%) Apache Flume
3 5 (0.97%) Docker
4 3 (0.58%) Active Directory
5 2 (0.39%) Apache ZooKeeper
5 2 (0.39%) Virtual Machines
Systems Management
1 14 (2.72%) Systems Management Server (SMS)
2 8 (1.55%) Single Sign-On
3 7 (1.36%) Hadoop YARN
4 6 (1.17%) Control-M
4 6 (1.17%) Oozie
5 4 (0.78%) Data Guard
5 4 (0.78%) Puppet
6 1 (0.19%) Kibana
6 1 (0.19%) Netcool
6 1 (0.19%) Opscode Chef
Vendors
1 279 (54.17%) Microsoft
2 113 (21.94%) Oracle
3 53 (10.29%) Tableau
4 45 (8.74%) Cognos
5 40 (7.77%) SAP
6 22 (4.27%) MicroStrategy
7 21 (4.08%) Cisco
8 17 (3.30%) Hyperion
8 17 (3.30%) Informatica
9 14 (2.72%) Google
10 13 (2.52%) Netezza
10 13 (2.52%) Teradata
11 10 (1.94%) IBM
11 10 (1.94%) Salesforce.com
12 9 (1.75%) Cloudera
12 9 (1.75%) Tagetik
13 8 (1.55%) Talend
14 7 (1.36%) Alteryx
14 7 (1.36%) CA
14 7 (1.36%) IFS