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 3 months to 26 June 2017 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
3 months to
26 Jun 2017
Same period 2016 Same period 2015
Rank 517 509 414
Rank change year-on-year -8 -95  
Contract jobs citing OLAP 90 142 240
As % of all contract IT jobs advertised in the UK 0.19% 0.27% 0.43%
As % of the Database & Business Intelligence category 0.86% 1.23% 1.82%
Number of daily rates quoted 65 102 164
Median daily rate £435 £413 £438
Median daily rate % change year-on-year +5.45% -5.71%  
90% offered a daily rate of more than £331 £313 £325
10% offered a daily rate of more than £600 £550 £550
UK excluding London median daily rate £378 £413 £413
% change year-on-year -8.48% -  
Number of hourly rates quoted 1 0 0
Median hourly rate £52.50 - -
UK excluding London median hourly rate £52.50 - -

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills
UK
Contract job vacancies with a requirement for database and business intelligence skills 10522 11586 13184
As % of all contract IT job vacancies advertised in the UK 22.38% 21.83% 23.57%
Number of daily rates quoted 6876 7850 8612
Median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25%  
90% offered a daily rate of more than £325 £300 £275
10% offered a daily rate of more than £600 £600 £550
UK excluding London median daily rate £400 £383 £350
% change year-on-year +4.57% +9.28%  
Number of hourly rates quoted 142 193 183
Median hourly rate £31.50 £31.27 £27.50
Median hourly rate % change year-on-year +0.73% +13.70%  
90% offered a hourly rate of more than £13.20 £12.00 £16.00
10% offered a hourly rate of more than £50.00 £49.00 £52.17
UK excluding London median hourly rate £38.00 £30.50 £26.00
% change year-on-year +24.59% +17.30%  

OLAP
Job Vacancy Trend

The job posting trend of jobs advertised citing OLAP as a proportion of all contract or permanent IT jobs with a match in the Database & Business Intelligence category.

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 3 months to 26 June 2017.

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 30 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 3 months to 26 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -14 87 £444 +7.57% 30
London -22 48 £550 +25.00% 11
South East +31 14 £413 +10.00% 6
Yorkshire +24 7 £375 -30.23% 3
West Yorkshire +14 6 £375 -30.23% 1
North West +8 6 £419 +1.51% 1
City of London -14 6 £431 -9.21% 4
West Midlands +21 5 £340 -6.20% 1
Leeds +26 4 £375 -
Berkshire +20 4 £463 +31.67%
Cheshire +9 4 £413 -
Surrey +8 4 £475 - 2
West Sussex - 4 £290 -
Reading - 4 £463 -
Scotland +31 3 £350 +12.00% 2
Birmingham +22 3 £445 +36.92% 1
East of England -8 3 £353 -14.54% 5
Edinburgh - 3 £350 - 1
Horsham - 3 £290 -
Manchester +14 2 £469 +113.06%
Bradford +8 2 - - 1
Hampshire +7 2 £500 +48.14% 1
Watford -3 2 £353 -
Nottinghamshire -4 2 £390 -13.33%
Hertfordshire -6 2 £353 -6.00%
East Midlands -15 2 £390 -2.50% 1
Guildford - 2 £475 -
Portsmouth - 2 £500 -
Macclesfield +2 1 £550 +4.76%
Nottingham -1 1 £380 -15.55%

For the 6 months to 26 June 2017, IT contractor jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for OLAP.

1 113 (61.41%) SQL
2 108 (58.70%) Business Intelligence
3 100 (54.35%) SQL Server
4 97 (52.72%) Data Warehouse
5 85 (46.20%) SQL Server Integration Services
6 82 (44.57%) ETL
7 79 (42.93%) SQL Server Reporting Services
7 79 (42.93%) SQL Server Analysis Services
8 65 (35.33%) Finance
9 63 (34.24%) Microsoft
10 51 (27.72%) MDX
11 47 (25.54%) OLAP Cube
12 46 (25.00%) Data Modelling
13 39 (21.20%) T-SQL
13 39 (21.20%) Oracle
13 39 (21.20%) Agile Software Development
13 39 (21.20%) Power BI
14 38 (20.65%) Oracle OLAP
15 35 (19.02%) Analytics
16 34 (18.48%) Analytical Skills
17 32 (17.39%) Microsoft Excel
18 31 (16.85%) OLTP
19 29 (15.76%) C#
19 29 (15.76%) Banking
20 27 (14.67%) Kimball Methodology
21 26 (14.13%) SQL Server 2008
22 25 (13.59%) SQL Server 2012
23 24 (13.04%) Performance Tuning
23 24 (13.04%) Tableau
24 23 (12.50%) SQL Server 2016

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 18 (9.78%) SAS
2 10 (5.43%) SharePoint
3 5 (2.72%) Apache Solr
4 3 (1.63%) Oracle SOA Suite
5 2 (1.09%) CMS
5 2 (1.09%) Drupal
5 2 (1.09%) SharePoint 2010
6 1 (0.54%) Apache
6 1 (0.54%) Confluence
6 1 (0.54%) DataSynapse
6 1 (0.54%) Exchange Server 2007
6 1 (0.54%) Exchange Server 2013
6 1 (0.54%) MS Exchange
6 1 (0.54%) Oracle 10gAS
6 1 (0.54%) Oracle Application Server
6 1 (0.54%) Oracle Coherence
Applications
1 32 (17.39%) Microsoft Excel
2 2 (1.09%) Microsoft Office
2 2 (1.09%) MS Visio
2 2 (1.09%) Spreadsheet
3 1 (0.54%) Microsoft PowerPoint
3 1 (0.54%) Microsoft Project
Business Applications
1 3 (1.63%) Cognos Business Intelligence
2 2 (1.09%) Hyperion Planning
2 2 (1.09%) ION MarketView
2 2 (1.09%) Oracle Retail
2 2 (1.09%) SAP BPC
2 2 (1.09%) SAP R/3
3 1 (0.54%) BPCS
3 1 (0.54%) Cognos TM1
3 1 (0.54%) Dynamics AX
3 1 (0.54%) Dynamics CRM
3 1 (0.54%) Global One
3 1 (0.54%) Oracle EBS
3 1 (0.54%) Oracle Financials
3 1 (0.54%) Oracle General Ledger
3 1 (0.54%) Oracle Payables
3 1 (0.54%) Oracle Receivables
3 1 (0.54%) PeopleSoft HCM
3 1 (0.54%) SunGard Martini
Cloud Services
1 18 (9.78%) Microsoft Azure
2 7 (3.80%) Amazon AWS
3 5 (2.72%) Azure Data Factory
3 5 (2.72%) Data Lake Analytics
3 5 (2.72%) IaaS
3 5 (2.72%) PaaS
4 1 (0.54%) Google Analytics
4 1 (0.54%) Office 365
Communications & Networking
1 4 (2.17%) Extranet
1 4 (2.17%) Intranet
Database & Business Intelligence
1 100 (54.35%) SQL Server
2 97 (52.72%) Data Warehouse
3 85 (46.20%) SQL Server Integration Services
4 79 (42.93%) SQL Server Analysis Services
4 79 (42.93%) SQL Server Reporting Services
5 47 (25.54%) OLAP Cube
6 39 (21.20%) Power BI
7 38 (20.65%) Oracle OLAP
8 31 (16.85%) OLTP
9 26 (14.13%) SQL Server 2008
10 25 (13.59%) SQL Server 2012
11 23 (12.50%) SQL Server 2016
12 19 (10.33%) QlikView
13 18 (9.78%) Microsoft Analysis Services
14 16 (8.70%) SQL Server 2014
15 15 (8.15%) Hadoop
16 14 (7.61%) PowerPivot
16 14 (7.61%) Relational Database
17 11 (5.98%) Big Data
17 11 (5.98%) Data Lake
Development Applications
1 11 (5.98%) Visual Studio
2 8 (4.35%) Subversion
2 8 (4.35%) Team Foundation Server
3 6 (3.26%) ERwin
4 5 (2.72%) MagicDraw
5 3 (1.63%) TeamCity
6 2 (1.09%) Git (software)
6 2 (1.09%) JIRA
6 2 (1.09%) Octopus Deploy
6 2 (1.09%) Visual Studio Tools for Office
7 1 (0.54%) Bitbucket
7 1 (0.54%) Eclipse
7 1 (0.54%) Jenkins
7 1 (0.54%) SQL Server Management Studio (SSMS)
7 1 (0.54%) Talend Open Studio
7 1 (0.54%) Toad
General
1 65 (35.33%) Finance
2 29 (15.76%) Banking
3 15 (8.15%) Retail
4 10 (5.43%) Front Office
5 8 (4.35%) Investment Banking
6 7 (3.80%) Advertising
7 4 (2.17%) Retail Banking
8 3 (1.63%) Publishing
9 2 (1.09%) Automotive
9 2 (1.09%) Back Office
9 2 (1.09%) General Ledger
9 2 (1.09%) Legal
9 2 (1.09%) Spanish Language
9 2 (1.09%) Wholesale Banking
10 1 (0.54%) Local Government
10 1 (0.54%) Telecoms
Job Titles
1 110 (59.78%) Developer
2 39 (21.20%) Business Intelligence Developer
3 34 (18.48%) SQL Developer
4 22 (11.96%) Analyst
5 21 (11.41%) Architect
6 18 (9.78%) ETL Developer
7 16 (8.70%) SSAS Developer
8 14 (7.61%) Consultant
9 13 (7.07%) SSIS Developer
10 12 (6.52%) SSRS Developer
11 10 (5.43%) Data Architect
11 10 (5.43%) Data Warehouse Developer
12 9 (4.89%) Business Developer
12 9 (4.89%) C# Developer
12 9 (4.89%) SQL BI Developer
13 8 (4.35%) Business Analyst
13 8 (4.35%) Business Intelligence Analyst
13 8 (4.35%) OLAP Developer
14 7 (3.80%) Oracle Developer
15 6 (3.26%) Database Developer
Libraries, Frameworks & Software Standards
1 51 (27.72%) MDX
2 23 (12.50%) .NET
3 10 (5.43%) Web Services
4 9 (4.89%) XML
5 7 (3.80%) ASP.NET
5 7 (3.80%) D3.js
6 5 (2.72%) HTML
6 5 (2.72%) Lucene
6 5 (2.72%) WCF
6 5 (2.72%) WPF
7 3 (1.63%) .NET Framework
7 3 (1.63%) ASP.NET MVC
7 3 (1.63%) HTML5
7 3 (1.63%) REST
7 3 (1.63%) SOAP
8 2 (1.09%) AngularJS
8 2 (1.09%) Node.js
8 2 (1.09%) WF
8 2 (1.09%) Windows Identity Foundation
8 2 (1.09%) XSD
Miscellaneous
1 34 (18.48%) Analytical Skills
2 11 (5.98%) Fixed Income
3 8 (4.35%) Hedge funds
4 7 (3.80%) Taxonomies
5 6 (3.26%) Credit Risk
6 5 (2.72%) Data Structures
6 5 (2.72%) Management Information System
6 5 (2.72%) Reference Data
7 3 (1.63%) Enterprise Software
7 3 (1.63%) Foreign Exchange (FX)
7 3 (1.63%) Greenfield Project
7 3 (1.63%) Replication
8 2 (1.09%) Data Protection Act
9 1 (0.54%) Computer Science
9 1 (0.54%) Derivative
9 1 (0.54%) Interest Rate Derivative
9 1 (0.54%) Market Risk
9 1 (0.54%) Mobile App
9 1 (0.54%) Reinsurance
9 1 (0.54%) User Experience
Operating Systems
1 2 (1.09%) Linux
1 2 (1.09%) Windows
1 2 (1.09%) Windows Server
2 1 (0.54%) HPUX
2 1 (0.54%) Red Hat Enterprise Linux
2 1 (0.54%) Unix
2 1 (0.54%) Windows 10
2 1 (0.54%) Windows 7
2 1 (0.54%) Windows Server 2003
2 1 (0.54%) Windows Server 2008
2 1 (0.54%) Windows Server 2012
Processes & Methodologies
1 108 (58.70%) Business Intelligence
2 82 (44.57%) ETL
3 46 (25.00%) Data Modelling
4 39 (21.20%) Agile Software Development
5 35 (19.02%) Analytics
6 27 (14.67%) Kimball Methodology
7 24 (13.04%) Performance Tuning
8 21 (11.41%) Data Management
8 21 (11.41%) Migration
9 19 (10.33%) Visualisation
10 16 (8.70%) Continuous Integration
10 16 (8.70%) Data Analysis
10 16 (8.70%) Dimensional Modelling
11 14 (7.61%) Data Integration
11 14 (7.61%) Data Visualisation
12 13 (7.07%) Data Architecture
13 12 (6.52%) Data Migration
14 11 (5.98%) DevOps
15 10 (5.43%) SDLC
15 10 (5.43%) User Acceptance Testing
Programming Languages
1 113 (61.41%) SQL
2 39 (21.20%) T-SQL
3 29 (15.76%) C#
4 16 (8.70%) Java
5 13 (7.07%) JavaScript
6 12 (6.52%) VBA
7 10 (5.43%) PL/SQL
8 9 (4.89%) Data Analysis Expressions (DAX)
9 7 (3.80%) Python
10 6 (3.26%) Lisp
10 6 (3.26%) PowerShell
11 5 (2.72%) R
11 5 (2.72%) VB.NET
11 5 (2.72%) VBScript
12 4 (2.17%) VB
13 2 (1.09%) ABAP
13 2 (1.09%) C
13 2 (1.09%) SPARQL
14 1 (0.54%) COBOL
14 1 (0.54%) XMLA
Qualifications
1 14 (7.61%) Degree
2 5 (2.72%) Microsoft Certification
3 2 (1.09%) MCITP
3 2 (1.09%) MCSE
3 2 (1.09%) Numerate Degree
4 1 (0.54%) ACCA
4 1 (0.54%) CIMA
4 1 (0.54%) MBA
4 1 (0.54%) Security Cleared
Quality Assurance & Compliance
1 21 (11.41%) Data Quality
2 6 (3.26%) QA
3 4 (2.17%) IFRS
3 4 (2.17%) IFRS 9
4 2 (1.09%) PCI DSS
4 2 (1.09%) Solvency II
5 1 (0.54%) Cyber Essentials
5 1 (0.54%) Cyber Essentials PLUS
5 1 (0.54%) GDPR
System Software
1 5 (2.72%) Virtual Machines
2 1 (0.54%) Docker
2 1 (0.54%) Hyper-V
2 1 (0.54%) VMware Infrastructure
Systems Management
1 1 (0.54%) Oracle RMAN
1 1 (0.54%) Symantec Enterprise Vault
Vendors
1 63 (34.24%) Microsoft
2 39 (21.20%) Oracle
3 24 (13.04%) Tableau
4 11 (5.98%) SAP
5 8 (4.35%) Cognos
6 7 (3.80%) IBM
6 7 (3.80%) Informatica
7 6 (3.26%) Teradata
8 4 (2.17%) Hyperion
9 3 (1.63%) RedGate
10 2 (1.09%) Cloudera
10 2 (1.09%) ION Trading
11 1 (0.54%) Google
11 1 (0.54%) MicroStrategy
11 1 (0.54%) Netezza
11 1 (0.54%) Red Hat
11 1 (0.54%) Salesforce.com
11 1 (0.54%) Sophis
11 1 (0.54%) Symantec
11 1 (0.54%) VMware
Yorkshire
Nigel Frank International Ltd
Rate: £400 - £450 per annum
Posted: 48 minutes ago
City, London
Devonshire Hayes Recruitment Specialists Ltd
Rate: From £380 to £410 per day
Posted: 3 days ago
London
Nigel Frank International
Rate: £400 - £500 per month
Posted: 7 days ago