Period
to 18 February 2018

The following table provides summary statistics for contract job vacancies advertised in England with a requirement for OLAP skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited OLAP over the 6 months to 18 February 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Online Analytical Processing (OLAP)
UK > England
6 months to
18 Feb 2018
Same period 2017 Same period 2016
Rank 628 625 541
Rank change year-on-year -3 -84 -83
Contract jobs citing OLAP 218 205 325
As % of all contract IT jobs advertised in England 0.24% 0.23% 0.33%
As % of the Database & Business Intelligence category 1.09% 1.04% 1.43%
Number of daily rates quoted 159 163 232
England median daily rate £475 £425 £425
Median daily rate % change year-on-year +11.76% - -
10th Percentile £325 £313 £300
90th Percentile £675 £575 £589
UK median daily rate £475 £425 £425
% change year-on-year +11.76% - -
Number of hourly rates quoted 1 0 0
England median hourly rate £55.00 - -
UK median hourly rate £55.00 - -

OLAP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Contract vacancies with a requirement for database or business intelligence skills 20,033 19,789 22,736
As % of all contract IT jobs advertised in England 21.84% 22.42% 22.94%
Number of daily rates quoted 14,108 13,338 15,360
England median daily rate £475 £438 £425
Median daily rate % change year-on-year +8.57% +2.94% +6.25%
10th Percentile £313 £295 £278
90th Percentile £635 £613 £588
UK median daily rate £463 £425 £420
% change year-on-year +8.82% +1.19% +5.00%
Number of hourly rates quoted 225 257 372
England median hourly rate £35.00 £26.50 £27.50
Median hourly rate % change year-on-year +32.08% -3.64% -
10th Percentile £15.25 £9.25 £11.53
90th Percentile £58.25 £47.00 £52.50
UK median hourly rate £34.25 £26.50 £28.00
% change year-on-year +29.25% -5.36% +1.82%

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
Contractor Daily Rate Trend in England

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing OLAP in England.

Contractor daily rate trend for OLAP in England

OLAP
Contractor Daily Rate Histogram in England

The daily rate distribution of IT jobs citing OLAP in England over the 6 months to 18 February 2018.

Contractor daily rate histogram for OLAP in England

OLAP
Contractor Hourly Rate Trend in England

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing OLAP in England.

Contractor hourly rate trend for OLAP in England

OLAP
Contract Job Locations in England

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the England region over the 6 months to 18 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
London +4 133 £500 +11.11% 26
North of England +12 28 £475 +26.67% 9
South East -17 26 £438 -7.06% 6
North West +14 16 £550 +27.91% 7
West Midlands +8 16 £400 +23.08% 2
Midlands +5 16 £400 +23.08% 3
East of England -14 10 £438 +6.71% 7
Yorkshire -14 7 £475 +37.68% 1
North East +38 5 £475 +26.67% 1
South West -5 5 £475 +11.76% 1
OLAP
UK

For the 6 months to 18 February 2018, IT contractor 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 contract job ads across the England region with a requirement for OLAP.

1 139 (63.76%) SQL
2 131 (60.09%) Business Intelligence
3 105 (48.17%) SQL Server
4 103 (47.25%) Data Warehouse
5 90 (41.28%) SQL Server Integration Services
6 88 (40.37%) ETL
7 86 (39.45%) Finance
8 77 (35.32%) Microsoft
9 72 (33.03%) SQL Server Analysis Services
10 71 (32.57%) SQL Server Reporting Services
11 63 (28.90%) Agile Software Development
12 60 (27.52%) Oracle
12 60 (27.52%) Oracle OLAP
13 55 (25.23%) Data Modelling
14 52 (23.85%) OLAP Cube
15 48 (22.02%) T-SQL
16 47 (21.56%) Analytics
17 46 (21.10%) Java
18 41 (18.81%) MDX
19 37 (16.97%) Power BI
20 34 (15.60%) Migration
20 34 (15.60%) C#
20 34 (15.60%) Analytical Skills
21 31 (14.22%) Performance Tuning
21 31 (14.22%) Linux
22 30 (13.76%) Banking
23 28 (12.84%) Data Analysis
24 26 (11.93%) Cognos
24 26 (11.93%) .NET
24 26 (11.93%) OLTP

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 23 (10.55%) SAS
2 16 (7.34%) Apache Spark
3 8 (3.67%) Apache
3 8 (3.67%) IIS
4 6 (2.75%) ArcGIS
5 4 (1.83%) Confluence
6 3 (1.38%) SharePoint
7 1 (0.46%) Elasticsearch
Applications
1 19 (8.72%) Microsoft Excel
2 5 (2.29%) MS Visio
3 1 (0.46%) Microsoft Office
3 1 (0.46%) Microsoft PowerPoint
3 1 (0.46%) Spreadsheet
Business Applications
1 7 (3.21%) Dynamics AX
2 5 (2.29%) Cognos TM1
3 4 (1.83%) Dynamics CRM
4 3 (1.38%) Cognos Business Intelligence
4 3 (1.38%) Cognos Planning
4 3 (1.38%) Dynamics NAV
4 3 (1.38%) ION MarketView
5 2 (0.92%) Oracle Financials
5 2 (0.92%) Oracle Retail
5 2 (0.92%) Summit
6 1 (0.46%) Dynamics GP
6 1 (0.46%) Hyperion Planning
6 1 (0.46%) Oracle General Ledger
6 1 (0.46%) SAP BPC
Cloud Services
1 22 (10.09%) Microsoft Azure
2 9 (4.13%) Amazon AWS
3 7 (3.21%) IaaS
3 7 (3.21%) PaaS
4 5 (2.29%) Dynamics 365
5 3 (1.38%) OpenShift
6 2 (0.92%) Adobe Analytics
6 2 (0.92%) Azure Data Factory
6 2 (0.92%) Google Analytics
6 2 (0.92%) SaaS
7 1 (0.46%) Amazon EMR
7 1 (0.46%) Amazon S3
7 1 (0.46%) Cloud Computing
7 1 (0.46%) Data Lake Analytics
Communications & Networking
1 3 (1.38%) SSL
2 2 (0.92%) SAN
3 1 (0.46%) ATM
3 1 (0.46%) Ethernet
3 1 (0.46%) FCoE
3 1 (0.46%) Fibre Channel
3 1 (0.46%) HTTP
3 1 (0.46%) InfiniBand
3 1 (0.46%) Internet
3 1 (0.46%) iSCSI
3 1 (0.46%) LAN
3 1 (0.46%) SMS
3 1 (0.46%) WAN
Database & Business Intelligence
1 105 (48.17%) SQL Server
2 103 (47.25%) Data Warehouse
3 90 (41.28%) SQL Server Integration Services
4 72 (33.03%) SQL Server Analysis Services
5 71 (32.57%) SQL Server Reporting Services
6 60 (27.52%) Oracle OLAP
7 52 (23.85%) OLAP Cube
8 37 (16.97%) Power BI
9 26 (11.93%) OLTP
10 25 (11.47%) SQL Server 2016
11 24 (11.01%) Relational Database
12 23 (10.55%) Hadoop
12 23 (10.55%) SQL Server 2012
13 22 (10.09%) Big Data
14 19 (8.72%) SQL Server 2008
15 18 (8.26%) Oracle BI EE
16 14 (6.42%) Microsoft Analysis Services
16 14 (6.42%) Oracle Database
16 14 (6.42%) SQL Server 2014
17 13 (5.96%) MongoDB
Development Applications
1 12 (5.50%) Git (software)
1 12 (5.50%) JIRA
2 10 (4.59%) Bitbucket
3 9 (4.13%) Visual Studio
4 7 (3.21%) TeamCity
5 6 (2.75%) ERwin
6 5 (2.29%) Team Foundation Server
7 4 (1.83%) Jenkins
8 3 (1.38%) Cucumber
9 2 (0.92%) IntelliJ
9 2 (0.92%) JUnit
9 2 (0.92%) Maven
9 2 (0.92%) SonarQube
9 2 (0.92%) Toad
10 1 (0.46%) Eclipse
10 1 (0.46%) git-flow
10 1 (0.46%) PyCharm
10 1 (0.46%) SQL Server Management Studio (SSMS)
10 1 (0.46%) Sublime Text
General
1 86 (39.45%) Finance
2 30 (13.76%) Banking
3 13 (5.96%) Investment Banking
4 11 (5.05%) Front Office
5 7 (3.21%) Marketing
6 6 (2.75%) Retail
7 4 (1.83%) Back Office
7 4 (1.83%) Electronics
7 4 (1.83%) Manufacturing
7 4 (1.83%) Telecoms
8 3 (1.38%) Financial Institution
9 2 (0.92%) German Language
9 2 (0.92%) Legal
10 1 (0.46%) Advertising
10 1 (0.46%) Dutch Language
10 1 (0.46%) French Language
10 1 (0.46%) General Ledger
10 1 (0.46%) Italian Language
10 1 (0.46%) Law
10 1 (0.46%) Spanish Language
Job Titles
1 124 (56.88%) Developer
2 38 (17.43%) Business Intelligence Developer
3 35 (16.06%) SQL Developer
4 26 (11.93%) Analyst
5 24 (11.01%) Architect
6 21 (9.63%) Senior Developer
6 21 (9.63%) SSAS Developer
7 15 (6.88%) Consultant
7 15 (6.88%) Data Warehouse Developer
8 14 (6.42%) SSIS Developer
9 13 (5.96%) DBA
9 13 (5.96%) SQL BI Developer
10 10 (4.59%) Data Architect
11 9 (4.13%) Administrator
11 9 (4.13%) Business Intelligence Analyst
11 9 (4.13%) Business Intelligence Consultant
12 8 (3.67%) Data Analyst
13 7 (3.21%) Oracle DBA
13 7 (3.21%) Scrum Master
13 7 (3.21%) SQL Analyst
Libraries, Frameworks & Software Standards
1 41 (18.81%) MDX
2 26 (11.93%) .NET
3 23 (10.55%) XML
4 14 (6.42%) HTML
5 13 (5.96%) AngularJS
5 13 (5.96%) SOAP
6 11 (5.05%) Web Services
7 9 (4.13%) Kafka
7 9 (4.13%) XSD
7 9 (4.13%) XSLT
8 8 (3.67%) CSS
8 8 (3.67%) HTML5
8 8 (3.67%) JSON
8 8 (3.67%) REST
9 7 (3.21%) Apache Camel
9 7 (3.21%) ASP.NET
10 6 (2.75%) Angular 2
10 6 (2.75%) Twitter Bootstrap
11 5 (2.29%) PySpark
11 5 (2.29%) Socket.IO
Miscellaneous
1 34 (15.60%) Analytical Skills
2 15 (6.88%) Computer Science
3 13 (5.96%) Market Risk
4 9 (4.13%) Greenfield Project
5 8 (3.67%) Data Centre
5 8 (3.67%) Fixed Income
6 7 (3.21%) Credit Risk
7 5 (2.29%) Derivative
7 5 (2.29%) Hedge funds
7 5 (2.29%) Management Information System
7 5 (2.29%) N-Tier
7 5 (2.29%) Reinsurance
8 4 (1.83%) Client/Server
8 4 (1.83%) Equities
8 4 (1.83%) Reference Data
8 4 (1.83%) Replication
9 3 (1.38%) Foreign Exchange (FX)
9 3 (1.38%) Mobile App
10 2 (0.92%) Clustering
10 2 (0.92%) NHS
Operating Systems
1 31 (14.22%) Linux
2 16 (7.34%) Unix
3 4 (1.83%) Red Hat Enterprise Linux
4 3 (1.38%) Windows
5 1 (0.46%) AIX
5 1 (0.46%) Solaris
Processes & Methodologies
1 131 (60.09%) Business Intelligence
2 88 (40.37%) ETL
3 63 (28.90%) Agile Software Development
4 55 (25.23%) Data Modelling
5 47 (21.56%) Analytics
6 34 (15.60%) Migration
7 31 (14.22%) Performance Tuning
8 28 (12.84%) Data Analysis
9 26 (11.93%) Visualisation
10 24 (11.01%) Dimensional Modelling
10 24 (11.01%) Kimball Methodology
11 23 (10.55%) Scrum
12 22 (10.09%) Data Management
13 19 (8.72%) Data Architecture
13 19 (8.72%) Data Integration
14 18 (8.26%) Unit Testing
15 17 (7.80%) Data Migration
16 16 (7.34%) Data Visualisation
17 14 (6.42%) SDLC
18 12 (5.50%) ETL Development
Programming Languages
1 139 (63.76%) SQL
2 48 (22.02%) T-SQL
3 46 (21.10%) Java
4 34 (15.60%) C#
5 20 (9.17%) JavaScript
6 18 (8.26%) Python
7 12 (5.50%) Shell Script
7 12 (5.50%) VBA
8 10 (4.59%) PL/SQL
9 8 (3.67%) Data Analysis Expressions (DAX)
10 5 (2.29%) XMLA
11 4 (1.83%) R
11 4 (1.83%) VB.NET
11 4 (1.83%) VBScript
11 4 (1.83%) XPath
12 3 (1.38%) Scala
12 3 (1.38%) VB
12 3 (1.38%) VB6
13 2 (0.92%) SAS Macro
14 1 (0.46%) PowerShell
Qualifications
1 17 (7.80%) Degree
2 15 (6.88%) Security Cleared
3 12 (5.50%) SC Cleared
4 6 (2.75%) MCSA
4 6 (2.75%) Microsoft Certification
5 5 (2.29%) MCSE
6 4 (1.83%) Computer Science Degree
7 3 (1.38%) BPSS Clearance
8 1 (0.46%) DBS Check
8 1 (0.46%) ISEB
8 1 (0.46%) Numerate Degree
Quality Assurance & Compliance
1 16 (7.34%) QA
2 9 (4.13%) Data Quality
3 2 (0.92%) IFRS
3 2 (0.92%) PMO
4 1 (0.46%) Basel II
4 1 (0.46%) IFRS 9
4 1 (0.46%) ISO/IEC 27001
4 1 (0.46%) PCI DSS
4 1 (0.46%) SAS 70
4 1 (0.46%) SLA
System Software
1 15 (6.88%) Docker
2 8 (3.67%) Active Directory
3 7 (3.21%) Virtual Machines
3 7 (3.21%) VMware Infrastructure
4 3 (1.38%) Oracle RAC
5 2 (0.92%) HDFS
6 1 (0.46%) Apache Flume
6 1 (0.46%) Hyper-V
Systems Management
1 9 (4.13%) Data Guard
2 6 (2.75%) Oracle EDQ
2 6 (2.75%) Oracle RMAN
3 1 (0.46%) Hadoop YARN
3 1 (0.46%) Oracle Identity Management
3 1 (0.46%) Oracle Identity Manager
Vendors
1 77 (35.32%) Microsoft
2 60 (27.52%) Oracle
3 26 (11.93%) Cognos
3 26 (11.93%) Tableau
4 20 (9.17%) IBM
5 11 (5.05%) SAP
6 8 (3.67%) Informatica
7 7 (3.21%) VMware
8 6 (2.75%) Netezza
8 6 (2.75%) Twitter
9 5 (2.29%) Cloudera
9 5 (2.29%) Hortonworks
9 5 (2.29%) MicroStrategy
9 5 (2.29%) Salesforce.com
10 4 (1.83%) EnterpriseDB
10 4 (1.83%) InterSystems
10 4 (1.83%) Red Hat
10 4 (1.83%) Sencha
10 4 (1.83%) Teradata
11 3 (1.38%) Ab Initio