Period
to 20 February 2018

The following table provides summary statistics for contract job vacancies 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 20 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
6 months to
20 Feb 2018
Same period 2017 Same period 2016
Rank 637 630 562
Rank change year-on-year -7 -68 -100
Contract jobs citing OLAP 234 214 336
As % of all contract IT jobs advertised in the UK 0.23% 0.22% 0.31%
As % of the Database & Business Intelligence category 1.06% 1.00% 1.37%
Number of daily rates quoted 163 169 239
UK median daily rate £475 £425 £425
Median daily rate % change year-on-year +11.76% - -
10th Percentile £325 £313 £293
90th Percentile £675 £575 £578
UK excluding London median daily rate £460 £410 £400
% change year-on-year +12.20% +2.50% -5.88%
Number of hourly rates quoted 1 0 0
UK median hourly rate £55.00 - -
UK excluding London 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 with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 22,166 21,343 24,516
As % of all contract IT jobs advertised in the UK 21.83% 22.40% 22.89%
Number of daily rates quoted 15,430 14,273 16,408
UK median daily rate £463 £425 £420
Median daily rate % change year-on-year +8.82% +1.19% +5.00%
10th Percentile £313 £289 £275
90th Percentile £625 £613 £588
UK excluding London median daily rate £401 £393 £375
% change year-on-year +2.04% +4.67% +4.17%
Number of hourly rates quoted 257 299 404
UK median hourly rate £34.50 £26.50 £27.50
Median hourly rate % change year-on-year +30.19% -3.64% -
10th Percentile £15.11 £9.37 £12.00
90th Percentile £56.80 £48.75 £52.50
UK excluding London median hourly rate £38.25 £24.00 £26.50
% change year-on-year +59.38% -9.43% +0.95%

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

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

Contractor daily rate trend for OLAP in the UK

OLAP
Contractor Daily Rate Histogram

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

Contractor daily rate histogram for OLAP in the UK

OLAP
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for OLAP in the UK

OLAP
Top 15 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the UK over the 6 months to 20 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
England -32 218 £475 +11.76% 52
London +21 133 £500 +11.11% 22
UK excluding London -33 99 £460 +12.20% 34
North of England +16 28 £475 +26.67% 9
South East -19 26 £438 -7.06% 11
North West +11 16 £550 +27.91% 7
West Midlands +10 16 £400 +23.08% 2
Midlands +2 16 £400 +23.08% 3
East of England -9 10 £438 +6.71% 6
Wales -2 8 £388 -8.82%
Yorkshire -14 7 £475 +37.68% 1
North East +44 5 £475 +26.67% 1
South West +2 5 £475 +11.76% 1
Scotland -13 3 £338 - 4
Northern Ireland - 3 - -

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

1 148 (63.25%) SQL
2 143 (61.11%) Business Intelligence
3 112 (47.86%) Data Warehouse
4 106 (45.30%) SQL Server
5 101 (43.16%) ETL
6 92 (39.32%) SQL Server Integration Services
7 91 (38.89%) Finance
8 78 (33.33%) Microsoft
9 77 (32.91%) SQL Server Reporting Services
10 73 (31.20%) SQL Server Analysis Services
11 66 (28.21%) Agile Software Development
12 61 (26.07%) Oracle
12 61 (26.07%) Oracle OLAP
13 57 (24.36%) OLAP Cube
13 57 (24.36%) Data Modelling
14 53 (22.65%) T-SQL
15 49 (20.94%) Analytics
16 46 (19.66%) Java
17 42 (17.95%) MDX
18 38 (16.24%) Power BI
19 36 (15.38%) Analytical Skills
20 35 (14.96%) Migration
21 34 (14.53%) C#
22 32 (13.68%) OLTP
22 32 (13.68%) Banking
23 31 (13.25%) Linux
23 31 (13.25%) Performance Tuning
24 28 (11.97%) Data Analysis
25 27 (11.54%) Tableau
26 26 (11.11%) Visualisation

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 23 (9.83%) SAS
2 16 (6.84%) Apache Spark
3 8 (3.42%) Apache
3 8 (3.42%) IIS
4 6 (2.56%) ArcGIS
5 4 (1.71%) Confluence
6 3 (1.28%) SharePoint
7 1 (0.43%) Elasticsearch
Applications
1 20 (8.55%) Microsoft Excel
2 5 (2.14%) MS Visio
3 2 (0.85%) Spreadsheet
4 1 (0.43%) Microsoft Office
4 1 (0.43%) Microsoft PowerPoint
Business Applications
1 12 (5.13%) Dynamics AX
2 5 (2.14%) Cognos TM1
3 4 (1.71%) Dynamics CRM
4 3 (1.28%) Cognos Business Intelligence
4 3 (1.28%) Cognos Planning
4 3 (1.28%) Dynamics NAV
4 3 (1.28%) ION MarketView
5 2 (0.85%) Oracle Financials
5 2 (0.85%) Oracle Retail
5 2 (0.85%) Summit
6 1 (0.43%) Dynamics GP
6 1 (0.43%) Hyperion Planning
6 1 (0.43%) Oracle General Ledger
6 1 (0.43%) SAP BPC
Cloud Services
1 22 (9.40%) Microsoft Azure
2 9 (3.85%) Amazon AWS
3 7 (2.99%) IaaS
3 7 (2.99%) PaaS
4 5 (2.14%) Dynamics 365
5 3 (1.28%) OpenShift
6 2 (0.85%) Adobe Analytics
6 2 (0.85%) Azure Data Factory
6 2 (0.85%) Google Analytics
6 2 (0.85%) SaaS
7 1 (0.43%) Amazon EMR
7 1 (0.43%) Amazon S3
7 1 (0.43%) Cloud Computing
7 1 (0.43%) Data Lake Analytics
Communications & Networking
1 3 (1.28%) SSL
2 2 (0.85%) SAN
3 1 (0.43%) ATM
3 1 (0.43%) Ethernet
3 1 (0.43%) FCoE
3 1 (0.43%) Fibre Channel
3 1 (0.43%) HTTP
3 1 (0.43%) InfiniBand
3 1 (0.43%) Internet
3 1 (0.43%) iSCSI
3 1 (0.43%) LAN
3 1 (0.43%) SMS
3 1 (0.43%) WAN
Database & Business Intelligence
1 112 (47.86%) Data Warehouse
2 106 (45.30%) SQL Server
3 92 (39.32%) SQL Server Integration Services
4 77 (32.91%) SQL Server Reporting Services
5 73 (31.20%) SQL Server Analysis Services
6 61 (26.07%) Oracle OLAP
7 57 (24.36%) OLAP Cube
8 38 (16.24%) Power BI
9 32 (13.68%) OLTP
10 25 (10.68%) Relational Database
10 25 (10.68%) SQL Server 2016
11 24 (10.26%) Hadoop
12 23 (9.83%) Big Data
12 23 (9.83%) SQL Server 2012
13 19 (8.12%) SQL Server 2008
14 18 (7.69%) Oracle BI EE
15 15 (6.41%) Microsoft Analysis Services
16 14 (5.98%) Oracle Database
16 14 (5.98%) SQL Server 2014
17 13 (5.56%) MongoDB
Development Applications
1 12 (5.13%) Git (software)
1 12 (5.13%) JIRA
2 10 (4.27%) Bitbucket
3 9 (3.85%) Visual Studio
4 7 (2.99%) ERwin
4 7 (2.99%) TeamCity
5 5 (2.14%) Team Foundation Server
6 4 (1.71%) Jenkins
7 3 (1.28%) Cucumber
8 2 (0.85%) IntelliJ
8 2 (0.85%) JUnit
8 2 (0.85%) Maven
8 2 (0.85%) SonarQube
8 2 (0.85%) Toad
9 1 (0.43%) Eclipse
9 1 (0.43%) git-flow
9 1 (0.43%) PyCharm
9 1 (0.43%) SQL Server Management Studio (SSMS)
9 1 (0.43%) Sublime Text
General
1 91 (38.89%) Finance
2 32 (13.68%) Banking
3 13 (5.56%) Investment Banking
4 11 (4.70%) Front Office
5 7 (2.99%) Marketing
6 6 (2.56%) Retail
7 4 (1.71%) Back Office
7 4 (1.71%) Electronics
7 4 (1.71%) Manufacturing
7 4 (1.71%) Telecoms
8 3 (1.28%) Financial Institution
9 2 (0.85%) German Language
9 2 (0.85%) Legal
10 1 (0.43%) Advertising
10 1 (0.43%) Dutch Language
10 1 (0.43%) French Language
10 1 (0.43%) General Ledger
10 1 (0.43%) Italian Language
10 1 (0.43%) Law
10 1 (0.43%) Spanish Language
Job Titles
1 132 (56.41%) Developer
2 38 (16.24%) Business Intelligence Developer
2 38 (16.24%) SQL Developer
3 28 (11.97%) Analyst
4 24 (10.26%) Architect
5 23 (9.83%) Senior Developer
6 21 (8.97%) SSAS Developer
7 15 (6.41%) Consultant
7 15 (6.41%) Data Warehouse Developer
7 15 (6.41%) SSIS Developer
8 13 (5.56%) DBA
8 13 (5.56%) SQL BI Developer
9 10 (4.27%) Data Architect
10 9 (3.85%) Administrator
10 9 (3.85%) Business Intelligence Analyst
10 9 (3.85%) Business Intelligence Consultant
10 9 (3.85%) Data Analyst
11 7 (2.99%) ETL Developer
11 7 (2.99%) Oracle DBA
11 7 (2.99%) Scrum Master
Libraries, Frameworks & Software Standards
1 42 (17.95%) MDX
2 26 (11.11%) .NET
3 23 (9.83%) XML
4 14 (5.98%) HTML
5 13 (5.56%) AngularJS
5 13 (5.56%) SOAP
6 11 (4.70%) Web Services
7 9 (3.85%) Kafka
7 9 (3.85%) XSD
7 9 (3.85%) XSLT
8 8 (3.42%) CSS
8 8 (3.42%) HTML5
8 8 (3.42%) JSON
8 8 (3.42%) REST
9 7 (2.99%) Apache Camel
9 7 (2.99%) ASP.NET
10 6 (2.56%) Angular 2
10 6 (2.56%) Twitter Bootstrap
11 5 (2.14%) PySpark
11 5 (2.14%) Socket.IO
Miscellaneous
1 36 (15.38%) Analytical Skills
2 15 (6.41%) Computer Science
3 13 (5.56%) Market Risk
4 9 (3.85%) Greenfield Project
5 8 (3.42%) Data Centre
5 8 (3.42%) Fixed Income
6 7 (2.99%) Credit Risk
7 5 (2.14%) Derivative
7 5 (2.14%) Hedge funds
7 5 (2.14%) Management Information System
7 5 (2.14%) N-Tier
7 5 (2.14%) Reinsurance
8 4 (1.71%) Client/Server
8 4 (1.71%) Equities
8 4 (1.71%) Reference Data
8 4 (1.71%) Replication
9 3 (1.28%) Foreign Exchange (FX)
9 3 (1.28%) Mobile App
10 2 (0.85%) Clustering
10 2 (0.85%) NHS
Operating Systems
1 31 (13.25%) Linux
2 16 (6.84%) Unix
3 4 (1.71%) Red Hat Enterprise Linux
4 3 (1.28%) Windows
5 1 (0.43%) AIX
5 1 (0.43%) Solaris
Processes & Methodologies
1 143 (61.11%) Business Intelligence
2 101 (43.16%) ETL
3 66 (28.21%) Agile Software Development
4 57 (24.36%) Data Modelling
5 49 (20.94%) Analytics
6 35 (14.96%) Migration
7 31 (13.25%) Performance Tuning
8 28 (11.97%) Data Analysis
9 26 (11.11%) Visualisation
10 24 (10.26%) Dimensional Modelling
10 24 (10.26%) Kimball Methodology
11 23 (9.83%) Scrum
12 22 (9.40%) Data Management
13 20 (8.55%) Data Integration
14 19 (8.12%) Data Architecture
15 18 (7.69%) Data Migration
15 18 (7.69%) Unit Testing
16 16 (6.84%) Data Visualisation
17 15 (6.41%) Business Analysis
17 15 (6.41%) SDLC
Programming Languages
1 148 (63.25%) SQL
2 53 (22.65%) T-SQL
3 46 (19.66%) Java
4 34 (14.53%) C#
5 22 (9.40%) Python
6 20 (8.55%) JavaScript
7 12 (5.13%) Shell Script
7 12 (5.13%) VBA
8 10 (4.27%) PL/SQL
9 8 (3.42%) Data Analysis Expressions (DAX)
10 5 (2.14%) XMLA
11 4 (1.71%) R
11 4 (1.71%) VB.NET
11 4 (1.71%) VBScript
11 4 (1.71%) XPath
12 3 (1.28%) Scala
12 3 (1.28%) VB
12 3 (1.28%) VB6
13 2 (0.85%) SAS Macro
14 1 (0.43%) PowerShell
Qualifications
1 17 (7.26%) Degree
2 16 (6.84%) Security Cleared
3 12 (5.13%) SC Cleared
4 6 (2.56%) MCSA
4 6 (2.56%) Microsoft Certification
5 5 (2.14%) MCSE
6 4 (1.71%) Computer Science Degree
7 3 (1.28%) BPSS Clearance
8 1 (0.43%) DBS Check
8 1 (0.43%) ISEB
8 1 (0.43%) Numerate Degree
Quality Assurance & Compliance
1 16 (6.84%) QA
2 9 (3.85%) Data Quality
3 2 (0.85%) IFRS
3 2 (0.85%) PMO
4 1 (0.43%) Basel II
4 1 (0.43%) IFRS 9
4 1 (0.43%) ISO/IEC 27001
4 1 (0.43%) PCI DSS
4 1 (0.43%) SAS 70
4 1 (0.43%) SLA
System Software
1 15 (6.41%) Docker
2 8 (3.42%) Active Directory
3 7 (2.99%) Virtual Machines
3 7 (2.99%) VMware Infrastructure
4 3 (1.28%) Oracle RAC
5 2 (0.85%) HDFS
6 1 (0.43%) Apache Flume
6 1 (0.43%) Hyper-V
Systems Management
1 9 (3.85%) Data Guard
2 6 (2.56%) Oracle EDQ
2 6 (2.56%) Oracle RMAN
3 1 (0.43%) Hadoop YARN
3 1 (0.43%) Oracle Identity Management
3 1 (0.43%) Oracle Identity Manager
Vendors
1 78 (33.33%) Microsoft
2 61 (26.07%) Oracle
3 27 (11.54%) Tableau
4 26 (11.11%) Cognos
5 21 (8.97%) IBM
6 11 (4.70%) SAP
7 8 (3.42%) Informatica
8 7 (2.99%) VMware
9 6 (2.56%) Netezza
9 6 (2.56%) Twitter
10 5 (2.14%) Cloudera
10 5 (2.14%) Hortonworks
10 5 (2.14%) MicroStrategy
10 5 (2.14%) Salesforce.com
11 4 (1.71%) EnterpriseDB
11 4 (1.71%) InterSystems
11 4 (1.71%) Red Hat
11 4 (1.71%) Sencha
11 4 (1.71%) Teradata
12 3 (1.28%) Infor