Period
to 21 November 2017

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 21 November 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
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 603 614 500
Rank change year-on-year +11 -114 -13
Contract jobs citing OLAP 256 263 404
As % of all contract IT jobs advertised in England 0.27% 0.27% 0.39%
As % of the Database & Business Intelligence category 1.22% 1.20% 1.67%
Number of daily rates quoted 180 202 303
England median daily rate £475 £425 £425
Median daily rate % change year-on-year +11.76% - -
10th Percentile £345 £310 £300
90th Percentile £650 £588 £575
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 20955 21940 24263
As % of all contract IT jobs advertised in England 22.09% 22.55% 23.38%
Number of daily rates quoted 14517 14699 16156
England median daily rate £460 £425 £413
Median daily rate % change year-on-year +8.24% +3.03% +3.13%
10th Percentile £313 £288 £275
90th Percentile £638 £600 £588
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% +0.63%
Number of hourly rates quoted 264 319 384
England median hourly rate £31.75 £28.00 £27.78
Median hourly rate % change year-on-year +13.39% +0.79% +12.24%
10th Percentile £14.34 £11.20 £12.00
90th Percentile £56.41 £48.15 £52.17
UK median hourly rate £31.23 £28.00 £28.50
% change year-on-year +11.54% -1.75% +14.00%

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 21 November 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 6 months to 21 November 2017. 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 +26 145 £525 +10.53% 14
South East +14 44 £390 -13.33% 5
North of England +11 33 £425 +5.92% 12
Midlands +20 22 £400 +23.08% 3
Yorkshire +15 22 £350 -6.67% 5
West Midlands +24 20 £400 +23.08% 1
North West +1 10 £538 +7.50% 5
East of England -10 7 - -
East Midlands -2 2 £390 +6.85% 2
South West -26 2 £475 +17.28%
North East +53 1 £438 +16.67% 2
OLAP
UK

For the 6 months to 21 November 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 160 (62.50%) SQL
2 154 (60.16%) Business Intelligence
3 149 (58.20%) SQL Server
4 140 (54.69%) Data Warehouse
5 137 (53.52%) ETL
6 128 (50.00%) SQL Server Integration Services
7 121 (47.27%) Microsoft
8 109 (42.58%) SQL Server Analysis Services
9 103 (40.23%) SQL Server Reporting Services
10 84 (32.81%) Finance
11 78 (30.47%) Agile Software Development
12 73 (28.52%) T-SQL
13 72 (28.13%) MDX
13 72 (28.13%) OLAP Cube
14 61 (23.83%) Data Modelling
15 58 (22.66%) Kimball Methodology
16 54 (21.09%) C#
17 52 (20.31%) Oracle
17 52 (20.31%) Oracle OLAP
18 51 (19.92%) Power BI
19 49 (19.14%) Java
20 46 (17.97%) Analytics
20 46 (17.97%) SQL Server 2008
21 43 (16.80%) SQL Server 2012
22 40 (15.63%) Performance Tuning
22 40 (15.63%) Banking
23 37 (14.45%) Migration
23 37 (14.45%) JavaScript
23 37 (14.45%) Analytical Skills
24 36 (14.06%) SQL Server 2016

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 20 (7.81%) SAS
2 13 (5.08%) SharePoint
3 10 (3.91%) ArcGIS
4 7 (2.73%) Apache Spark
4 7 (2.73%) IIS
5 5 (1.95%) Apache
6 2 (0.78%) SharePoint 2010
7 1 (0.39%) Apache Pig
7 1 (0.39%) Exchange Server 2007
7 1 (0.39%) Exchange Server 2013
7 1 (0.39%) MS Exchange
7 1 (0.39%) Oracle 10gAS
7 1 (0.39%) Oracle Application Server
Applications
1 31 (12.11%) Microsoft Excel
2 7 (2.73%) Microsoft Office
3 6 (2.34%) Microsoft PowerPoint
4 5 (1.95%) MS Visio
5 1 (0.39%) Microsoft Project
5 1 (0.39%) Spreadsheet
Business Applications
1 9 (3.52%) ION MarketView
2 6 (2.34%) Cognos TM1
3 5 (1.95%) Cognos Business Intelligence
3 5 (1.95%) Dynamics AX
4 3 (1.17%) Cognos Planning
4 3 (1.17%) Dynamics CRM
5 2 (0.78%) Oracle Retail
5 2 (0.78%) SAP R/3
Cloud Services
1 33 (12.89%) Microsoft Azure
2 13 (5.08%) Amazon AWS
3 7 (2.73%) IaaS
3 7 (2.73%) PaaS
4 4 (1.56%) Dynamics 365
5 2 (0.78%) Azure Data Factory
5 2 (0.78%) SaaS
6 1 (0.39%) Cloud Computing
6 1 (0.39%) Data Lake Analytics
Communications & Networking
1 6 (2.34%) Extranet
1 6 (2.34%) Intranet
2 5 (1.95%) DNS
2 5 (1.95%) Firewall
3 1 (0.39%) Kerberos
3 1 (0.39%) SMS
Database & Business Intelligence
1 149 (58.20%) SQL Server
2 140 (54.69%) Data Warehouse
3 128 (50.00%) SQL Server Integration Services
4 109 (42.58%) SQL Server Analysis Services
5 103 (40.23%) SQL Server Reporting Services
6 72 (28.13%) OLAP Cube
7 52 (20.31%) Oracle OLAP
8 51 (19.92%) Power BI
9 46 (17.97%) SQL Server 2008
10 43 (16.80%) SQL Server 2012
11 36 (14.06%) SQL Server 2016
12 35 (13.67%) OLTP
13 30 (11.72%) Relational Database
14 25 (9.77%) Microsoft Analysis Services
15 23 (8.98%) SQL Server 2014
16 20 (7.81%) Oracle BI EE
17 19 (7.42%) Oracle Database
17 19 (7.42%) PowerPivot
18 18 (7.03%) BusinessObjects
19 17 (6.64%) RDBMS
Development Applications
1 24 (9.38%) Visual Studio
2 16 (6.25%) Team Foundation Server
3 9 (3.52%) JIRA
4 8 (3.13%) Subversion
5 7 (2.73%) Git (software)
6 6 (2.34%) Bitbucket
6 6 (2.34%) ERwin
6 6 (2.34%) Octopus Deploy
7 5 (1.95%) TeamCity
8 3 (1.17%) Toad
9 2 (0.78%) SQL Server Management Studio (SSMS)
10 1 (0.39%) Cucumber
10 1 (0.39%) Eclipse
General
1 84 (32.81%) Finance
2 40 (15.63%) Banking
3 19 (7.42%) Front Office
4 17 (6.64%) Investment Banking
5 10 (3.91%) Back Office
6 9 (3.52%) Retail
7 6 (2.34%) Publishing
8 5 (1.95%) Marketing
9 4 (1.56%) Retail Banking
9 4 (1.56%) Telecoms
10 3 (1.17%) Electronics
10 3 (1.17%) Manufacturing
11 1 (0.39%) Advertising
11 1 (0.39%) Dutch Language
11 1 (0.39%) Legal
11 1 (0.39%) Local Government
Job Titles
1 176 (68.75%) Developer
2 61 (23.83%) Business Intelligence Developer
3 56 (21.88%) SQL Developer
4 26 (10.16%) SSAS Developer
5 23 (8.98%) Senior Developer
6 22 (8.59%) Analyst
7 21 (8.20%) JavaScript Developer
8 19 (7.42%) Architect
9 18 (7.03%) Data Warehouse Developer
9 18 (7.03%) DBA
9 18 (7.03%) SSIS Developer
10 17 (6.64%) ETL Developer
10 17 (6.64%) SQL BI Developer
11 16 (6.25%) C# Developer
11 16 (6.25%) SQL Server Developer
12 14 (5.47%) Business Intelligence Analyst
13 12 (4.69%) Business Developer
14 11 (4.30%) Consultant
14 11 (4.30%) HTML Developer
14 11 (4.30%) Oracle DBA
Libraries, Frameworks & Software Standards
1 72 (28.13%) MDX
2 35 (13.67%) .NET
3 34 (13.28%) XML
4 21 (8.20%) HTML
5 17 (6.64%) AngularJS
6 16 (6.25%) XSD
6 16 (6.25%) XSLT
7 15 (5.86%) HTML5
7 15 (5.86%) Web Services
8 13 (5.08%) Node.js
9 12 (4.69%) SOAP
10 10 (3.91%) Kendo UI
11 9 (3.52%) D3.js
12 8 (3.13%) ASP.NET
12 8 (3.13%) CSS
13 7 (2.73%) REST
14 6 (2.34%) Angular 2
14 6 (2.34%) JSON
14 6 (2.34%) Kafka
14 6 (2.34%) Twitter Bootstrap
Miscellaneous
1 37 (14.45%) Analytical Skills
2 21 (8.20%) Fixed Income
3 11 (4.30%) Greenfield Project
4 10 (3.91%) Foreign Exchange (FX)
5 8 (3.13%) Hedge funds
6 6 (2.34%) Market Risk
7 5 (1.95%) Computer Science
7 5 (1.95%) Data Centre
7 5 (1.95%) N-Tier
7 5 (1.95%) Reference Data
7 5 (1.95%) Reinsurance
8 4 (1.56%) Credit Risk
8 4 (1.56%) Equities
8 4 (1.56%) Replication
9 2 (0.78%) Clustering
9 2 (0.78%) Data Structures
9 2 (0.78%) User Experience
10 1 (0.39%) Grid Computing
10 1 (0.39%) RIA
Operating Systems
1 27 (10.55%) Linux
2 21 (8.20%) Unix
3 8 (3.13%) Windows
4 4 (1.56%) Red Hat Enterprise Linux
5 2 (0.78%) Windows Server
6 1 (0.39%) HPUX
6 1 (0.39%) Windows 10
6 1 (0.39%) Windows 7
6 1 (0.39%) Windows Server 2003
6 1 (0.39%) Windows Server 2008
6 1 (0.39%) Windows Server 2012
Processes & Methodologies
1 154 (60.16%) Business Intelligence
2 137 (53.52%) ETL
3 78 (30.47%) Agile Software Development
4 61 (23.83%) Data Modelling
5 58 (22.66%) Kimball Methodology
6 46 (17.97%) Analytics
7 40 (15.63%) Performance Tuning
8 37 (14.45%) Migration
9 31 (12.11%) Dimensional Modelling
10 27 (10.55%) Data Analysis
11 24 (9.38%) Visualisation
12 23 (8.98%) Scrum
13 22 (8.59%) Continuous Integration
14 20 (7.81%) Data Visualisation
14 20 (7.81%) ETL Development
15 17 (6.64%) Data Integration
15 17 (6.64%) Data Management
16 16 (6.25%) DevOps
16 16 (6.25%) Open Source
17 15 (5.86%) Data Architecture
Programming Languages
1 160 (62.50%) SQL
2 73 (28.52%) T-SQL
3 54 (21.09%) C#
4 49 (19.14%) Java
5 37 (14.45%) JavaScript
6 22 (8.59%) Data Analysis Expressions (DAX)
7 15 (5.86%) Python
8 13 (5.08%) PL/SQL
9 10 (3.91%) PowerShell
10 8 (3.13%) Lisp
11 7 (2.73%) Shell Script
12 5 (1.95%) VB.NET
13 4 (1.56%) C
13 4 (1.56%) VB
14 3 (1.17%) R
14 3 (1.17%) VBA
14 3 (1.17%) XPath
15 2 (0.78%) ABAP
15 2 (0.78%) SAS Macro
16 1 (0.39%) Tcl
Qualifications
1 15 (5.86%) Security Cleared
2 13 (5.08%) SC Cleared
3 12 (4.69%) Degree
4 8 (3.13%) MCSE
4 8 (3.13%) Microsoft Certification
5 6 (2.34%) MCITP
6 3 (1.17%) ISEB
7 2 (0.78%) BPSS Clearance
7 2 (0.78%) MCSA
8 1 (0.39%) Computer Science Degree
8 1 (0.39%) DBS Check
8 1 (0.39%) Numerate Degree
Quality Assurance & Compliance
1 12 (4.69%) QA
2 10 (3.91%) Data Quality
3 1 (0.39%) Cyber Essentials
3 1 (0.39%) Cyber Essentials PLUS
3 1 (0.39%) GDPR
3 1 (0.39%) PCI DSS
3 1 (0.39%) Solvency II
System Software
1 13 (5.08%) Docker
2 12 (4.69%) Active Directory
3 11 (4.30%) VMware Infrastructure
4 7 (2.73%) Virtual Machines
5 4 (1.56%) Oracle RAC
6 1 (0.39%) HDFS
6 1 (0.39%) Hyper-V
Systems Management
1 13 (5.08%) Data Guard
2 11 (4.30%) Oracle RMAN
3 10 (3.91%) Oracle EDQ
4 1 (0.39%) Enterprise Manager Cloud Control
4 1 (0.39%) Oracle Enterprise Manager
4 1 (0.39%) Oracle Identity Management
4 1 (0.39%) Oracle Identity Manager
4 1 (0.39%) Symantec Enterprise Vault
Vendors
1 121 (47.27%) Microsoft
2 52 (20.31%) Oracle
3 35 (13.67%) Tableau
4 27 (10.55%) Cognos
5 15 (5.86%) IBM
6 11 (4.30%) SAP
6 11 (4.30%) VMware
7 10 (3.91%) Red Hat
8 9 (3.52%) ION Trading
9 8 (3.13%) RedGate
10 6 (2.34%) Informatica
10 6 (2.34%) Jaspersoft
10 6 (2.34%) Twitter
11 5 (1.95%) InterSystems
11 5 (1.95%) Netezza
11 5 (1.95%) Sencha
12 3 (1.17%) EnterpriseDB
13 2 (0.78%) JD Edwards
13 2 (0.78%) Salesforce.com
13 2 (0.78%) Teradata