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 3 months to 29 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 > England
3 months to
29 Jun 2017
Same period 2016 Same period 2015
Rank 503 488 426
Rank change year-on-year -15 -62  
Contract jobs citing OLAP 91 134 221
As % of all contract IT jobs advertised in England 0.21% 0.27% 0.43%
As % of the Database & Business Intelligence category 0.94% 1.25% 1.83%
Number of daily rates quoted 68 96 161
England median daily rate £444 £413 £438
Median daily rate % change year-on-year +7.57% -5.71%  
10th Percentile £326 £306 £313
90th Percentile £625 £556 £575
UK median daily rate £435 £413 £431
% change year-on-year +5.45% -4.34%  
Number of hourly rates quoted 1 0 0
England median hourly rate £52.50 - -
UK 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 advertised in England with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills
England
Contract job vacancies with a requirement for database and business intelligence skills 9680 10741 12064
As % of all contract IT job vacancies advertised in England 22.39% 21.79% 23.65%
Number of daily rates quoted 14278 16260 18628
England median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25%  
10th Percentile £313 £300 £269
90th Percentile £625 £600 £575
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25%  
Number of hourly rates quoted 214 290 328
England median hourly rate £31.00 £30.75 £25.83
Median hourly rate % change year-on-year +0.81% +19.04%  
10th Percentile £12.00 £12.00 £15.00
90th Percentile £50.00 £51.00 £52.17
UK median hourly rate £31.25 £31.90 £26.75
% change year-on-year -2.03% +19.25%  

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

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 3 months to 29 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
London -5 51 £550 +27.90% 12
South East +18 15 £413 +10.00% 5
North of England +38 12 £375 -9.09% 3
Yorkshire +19 7 £375 -30.23% 1
Midlands +4 7 £380 -1.93% 3
West Midlands +19 5 £340 -12.25% 2
North West +9 5 £388 -6.06% 2
East of England -9 3 £353 -14.54% 7
East Midlands -11 2 £390 -2.50% 1
OLAP
UK

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

1 113 (62.78%) SQL
2 106 (58.89%) Business Intelligence
3 104 (57.78%) SQL Server
4 100 (55.56%) Data Warehouse
5 89 (49.44%) SQL Server Integration Services
6 85 (47.22%) ETL
7 83 (46.11%) SQL Server Analysis Services
8 81 (45.00%) SQL Server Reporting Services
9 65 (36.11%) Microsoft
10 62 (34.44%) Finance
11 54 (30.00%) MDX
12 44 (24.44%) OLAP Cube
13 43 (23.89%) Data Modelling
14 41 (22.78%) T-SQL
14 41 (22.78%) Oracle
15 40 (22.22%) Power BI
15 40 (22.22%) Oracle OLAP
16 38 (21.11%) Agile Software Development
17 35 (19.44%) OLTP
18 33 (18.33%) Analytical Skills
19 32 (17.78%) Analytics
20 31 (17.22%) Microsoft Excel
21 30 (16.67%) C#
21 30 (16.67%) Kimball Methodology
22 29 (16.11%) Performance Tuning
23 28 (15.56%) SQL Server 2012
24 27 (15.00%) SQL Server 2008
25 25 (13.89%) Tableau
25 25 (13.89%) SQL Server 2016
26 24 (13.33%) Banking

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 13 (7.22%) SAS
2 10 (5.56%) SharePoint
3 5 (2.78%) Apache Solr
4 3 (1.67%) Oracle SOA Suite
5 2 (1.11%) CMS
5 2 (1.11%) Drupal
5 2 (1.11%) SharePoint 2010
6 1 (0.56%) Apache
6 1 (0.56%) Confluence
6 1 (0.56%) DataSynapse
6 1 (0.56%) Exchange Server 2007
6 1 (0.56%) Exchange Server 2013
6 1 (0.56%) MS Exchange
6 1 (0.56%) Oracle 10gAS
6 1 (0.56%) Oracle Application Server
6 1 (0.56%) Oracle Coherence
Applications
1 31 (17.22%) Microsoft Excel
2 2 (1.11%) Microsoft Office
2 2 (1.11%) MS Visio
2 2 (1.11%) Spreadsheet
3 1 (0.56%) Microsoft PowerPoint
3 1 (0.56%) Microsoft Project
Business Applications
1 3 (1.67%) Cognos Business Intelligence
2 2 (1.11%) Hyperion Planning
2 2 (1.11%) ION MarketView
2 2 (1.11%) Oracle Retail
2 2 (1.11%) SAP BPC
2 2 (1.11%) SAP R/3
3 1 (0.56%) BPCS
3 1 (0.56%) Cognos TM1
3 1 (0.56%) Dynamics AX
3 1 (0.56%) Dynamics CRM
3 1 (0.56%) Global One
3 1 (0.56%) Oracle EBS
3 1 (0.56%) Oracle Financials
3 1 (0.56%) Oracle General Ledger
3 1 (0.56%) Oracle Payables
3 1 (0.56%) Oracle Receivables
3 1 (0.56%) PeopleSoft HCM
3 1 (0.56%) SunGard Martini
Cloud Services
1 19 (10.56%) Microsoft Azure
2 8 (4.44%) Amazon AWS
3 5 (2.78%) Azure Data Factory
3 5 (2.78%) Data Lake Analytics
3 5 (2.78%) IaaS
3 5 (2.78%) PaaS
4 1 (0.56%) Google Analytics
4 1 (0.56%) Office 365
Communications & Networking
1 4 (2.22%) Extranet
1 4 (2.22%) Intranet
Database & Business Intelligence
1 104 (57.78%) SQL Server
2 100 (55.56%) Data Warehouse
3 89 (49.44%) SQL Server Integration Services
4 83 (46.11%) SQL Server Analysis Services
5 81 (45.00%) SQL Server Reporting Services
6 44 (24.44%) OLAP Cube
7 40 (22.22%) Oracle OLAP
7 40 (22.22%) Power BI
8 35 (19.44%) OLTP
9 28 (15.56%) SQL Server 2012
10 27 (15.00%) SQL Server 2008
11 25 (13.89%) SQL Server 2016
12 20 (11.11%) QlikView
13 19 (10.56%) Microsoft Analysis Services
14 17 (9.44%) SQL Server 2014
15 14 (7.78%) PowerPivot
15 14 (7.78%) Relational Database
16 11 (6.11%) Data Lake
17 10 (5.56%) Hadoop
18 9 (5.00%) Azure SQL Database
Development Applications
1 12 (6.67%) Visual Studio
2 9 (5.00%) Subversion
2 9 (5.00%) Team Foundation Server
3 6 (3.33%) ERwin
4 5 (2.78%) MagicDraw
5 3 (1.67%) Git (software)
5 3 (1.67%) Octopus Deploy
5 3 (1.67%) TeamCity
6 2 (1.11%) JIRA
6 2 (1.11%) Visual Studio Tools for Office
7 1 (0.56%) Bitbucket
7 1 (0.56%) Eclipse
7 1 (0.56%) Jenkins
7 1 (0.56%) SQL Server Management Studio (SSMS)
7 1 (0.56%) Talend Open Studio
7 1 (0.56%) Toad
General
1 62 (34.44%) Finance
2 24 (13.33%) Banking
3 11 (6.11%) Front Office
3 11 (6.11%) Retail
4 8 (4.44%) Investment Banking
5 7 (3.89%) Advertising
6 3 (1.67%) Publishing
7 2 (1.11%) Automotive
7 2 (1.11%) Back Office
7 2 (1.11%) Legal
7 2 (1.11%) Spanish Language
7 2 (1.11%) Wholesale Banking
8 1 (0.56%) Dutch Language
8 1 (0.56%) General Ledger
8 1 (0.56%) Local Government
8 1 (0.56%) Telecoms
Job Titles
1 113 (62.78%) Developer
2 39 (21.67%) Business Intelligence Developer
3 36 (20.00%) SQL Developer
4 22 (12.22%) Architect
5 21 (11.67%) ETL Developer
6 17 (9.44%) SSAS Developer
7 16 (8.89%) Analyst
8 14 (7.78%) Consultant
8 14 (7.78%) SSIS Developer
9 13 (7.22%) SSRS Developer
10 11 (6.11%) Data Warehouse Developer
11 10 (5.56%) C# Developer
11 10 (5.56%) Data Architect
12 9 (5.00%) Business Developer
12 9 (5.00%) SQL BI Developer
13 8 (4.44%) Business Intelligence Analyst
13 8 (4.44%) OLAP Developer
13 8 (4.44%) SQL Server Developer
14 7 (3.89%) Business Analyst
14 7 (3.89%) Oracle Developer
Libraries, Frameworks & Software Standards
1 54 (30.00%) MDX
2 23 (12.78%) .NET
3 11 (6.11%) Web Services
4 9 (5.00%) XML
5 7 (3.89%) ASP.NET
5 7 (3.89%) D3.js
6 5 (2.78%) HTML
6 5 (2.78%) Lucene
6 5 (2.78%) WCF
6 5 (2.78%) WPF
7 3 (1.67%) .NET Framework
7 3 (1.67%) ASP.NET MVC
7 3 (1.67%) HTML5
7 3 (1.67%) REST
7 3 (1.67%) SOAP
8 2 (1.11%) AngularJS
8 2 (1.11%) JSON
8 2 (1.11%) Node.js
8 2 (1.11%) WF
8 2 (1.11%) Windows Identity Foundation
Miscellaneous
1 33 (18.33%) Analytical Skills
2 12 (6.67%) Fixed Income
3 8 (4.44%) Hedge funds
4 5 (2.78%) Reference Data
4 5 (2.78%) Taxonomies
5 4 (2.22%) Data Structures
5 4 (2.22%) Management Information System
5 4 (2.22%) Replication
6 3 (1.67%) Credit Risk
6 3 (1.67%) Enterprise Software
6 3 (1.67%) Foreign Exchange (FX)
6 3 (1.67%) Greenfield Project
7 2 (1.11%) Data Protection Act
8 1 (0.56%) Clustering
8 1 (0.56%) Computer Science
8 1 (0.56%) Grid Computing
8 1 (0.56%) Market Risk
8 1 (0.56%) Mobile App
8 1 (0.56%) Reinsurance
8 1 (0.56%) User Experience
Operating Systems
1 3 (1.67%) Linux
1 3 (1.67%) Unix
1 3 (1.67%) Windows
2 2 (1.11%) Windows Server
3 1 (0.56%) HPUX
3 1 (0.56%) Red Hat Enterprise Linux
3 1 (0.56%) Windows 10
3 1 (0.56%) Windows 7
3 1 (0.56%) Windows Server 2003
3 1 (0.56%) Windows Server 2008
3 1 (0.56%) Windows Server 2012
Processes & Methodologies
1 106 (58.89%) Business Intelligence
2 85 (47.22%) ETL
3 43 (23.89%) Data Modelling
4 38 (21.11%) Agile Software Development
5 32 (17.78%) Analytics
6 30 (16.67%) Kimball Methodology
7 29 (16.11%) Performance Tuning
8 22 (12.22%) Migration
9 20 (11.11%) Data Management
10 18 (10.00%) Visualisation
11 17 (9.44%) Continuous Integration
12 16 (8.89%) Dimensional Modelling
13 14 (7.78%) Data Integration
14 13 (7.22%) Data Analysis
15 12 (6.67%) Data Migration
15 12 (6.67%) Data Visualisation
15 12 (6.67%) DevOps
16 11 (6.11%) Data Architecture
16 11 (6.11%) SDLC
17 9 (5.00%) Dashboard Development
Programming Languages
1 113 (62.78%) SQL
2 41 (22.78%) T-SQL
3 30 (16.67%) C#
4 17 (9.44%) Java
5 13 (7.22%) JavaScript
6 12 (6.67%) PL/SQL
7 11 (6.11%) VBA
8 10 (5.56%) Data Analysis Expressions (DAX)
9 8 (4.44%) Python
10 7 (3.89%) Lisp
10 7 (3.89%) PowerShell
11 5 (2.78%) R
11 5 (2.78%) VB.NET
11 5 (2.78%) VBScript
12 4 (2.22%) VB
13 2 (1.11%) ABAP
13 2 (1.11%) C
13 2 (1.11%) SPARQL
14 1 (0.56%) COBOL
14 1 (0.56%) XMLA
Qualifications
1 14 (7.78%) Degree
2 6 (3.33%) Microsoft Certification
3 3 (1.67%) MCITP
3 3 (1.67%) MCSE
4 2 (1.11%) Numerate Degree
5 1 (0.56%) ACCA
5 1 (0.56%) CIMA
5 1 (0.56%) MBA
5 1 (0.56%) Security Cleared
Quality Assurance & Compliance
1 21 (11.67%) Data Quality
2 6 (3.33%) QA
3 3 (1.67%) IFRS
3 3 (1.67%) IFRS 9
4 2 (1.11%) PCI DSS
4 2 (1.11%) Solvency II
5 1 (0.56%) Cyber Essentials
5 1 (0.56%) Cyber Essentials PLUS
5 1 (0.56%) GDPR
System Software
1 5 (2.78%) Virtual Machines
2 1 (0.56%) Docker
2 1 (0.56%) Hyper-V
2 1 (0.56%) Oracle RAC
2 1 (0.56%) VMware Infrastructure
Systems Management
1 1 (0.56%) Enterprise Manager Cloud Control
1 1 (0.56%) Oracle Enterprise Manager
1 1 (0.56%) Oracle RMAN
1 1 (0.56%) Symantec Enterprise Vault
Vendors
1 65 (36.11%) Microsoft
2 41 (22.78%) Oracle
3 25 (13.89%) Tableau
4 9 (5.00%) SAP
5 8 (4.44%) IBM
6 7 (3.89%) Cognos
6 7 (3.89%) Informatica
7 4 (2.22%) Hyperion
7 4 (2.22%) RedGate
7 4 (2.22%) Teradata
8 2 (1.11%) ION Trading
8 2 (1.11%) Netezza
9 1 (0.56%) Fidessa
9 1 (0.56%) Google
9 1 (0.56%) MicroStrategy
9 1 (0.56%) Red Hat
9 1 (0.56%) Salesforce.com
9 1 (0.56%) Sophis
9 1 (0.56%) Symantec
9 1 (0.56%) VMware
Watford, Hertfordshire
TLP Consultancy Ltd.
Posted: 2 days ago
Yorkshire
Nigel Frank International Ltd
Rate: £400 - £450 per annum
Posted: 3 days ago
London
TEKsystems
Rate: £475 - £535 per day
Posted: 3 days ago