The table below looks at the statistics for OLAP skills in IT contracts advertised across the UK. Included is a guide to the average contractor rates offered in IT contracts that have cited OLAP over the 3 months to 5 February 2016 with a comparison to the same period in the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

Location
3 months to
5 Feb 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 465 382 346
Rank change year-on-year
-83 -36
Contract jobs citing OLAP 154 227 247
As % of all contract IT jobs located in the UK 0.30% 0.45% 0.51%
As % of the Database & Business Intelligence category 1.35% 2.05% 2.21%
Number of daily rates quoted 103 166 153
Average daily rate £425 £425 £400
Average daily rate % change year-on-year
- +6.25%
90% offered a daily rate of more than £300 £345 £285
10% offered a daily rate of more than £598 £535 £525
UK excluding London average daily rate £400 £425 £350
% change year-on-year
-5.88% +21.42%
Number of hourly rates quoted 0 0 1
Average hourly rate - - £33.00
UK excluding London average hourly rate - - £33.00

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in contract jobs advertised across the UK.

Database & Business Intelligence Category
UK
Contract IT job ads with a match in the
Database & Business Intelligence category
11440 11053 11185
As % of all contract IT jobs located in the UK 22.24% 21.82% 23.03%
Number of daily rates quoted 7707 7170 6776
Average daily rate £425 £400 £388
Average daily rate % change year-on-year
+6.25% +3.22%
90% offered a daily rate of more than £300 £275 £254
10% offered a daily rate of more than £575 £550 £550
UK excluding London average daily rate £375 £368 £350
% change year-on-year
+2.04% +5.00%
Number of hourly rates quoted 225 164 225
Average hourly rate £30.00 £30.00 £28.00
Average hourly rate % change year-on-year
- +7.14%
90% offered a hourly rate of more than £14.00 £15.00 £13.62
10% offered a hourly rate of more than £60.62 £47.75 £45.00
UK excluding London average hourly rate £29.00 £32.50 £28.00
% change year-on-year
-10.76% +16.07%

OLAP
Jobs Demand Trend

This chart provides the 3-month moving total of IT contractor jobs citing OLAP within the UK as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in the UK

OLAP
Daily Rate Trend

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

OLAP Daily Rate Trend in the UK

OLAP
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing OLAP within the UK over the 3 months to 5 February 2016.

OLAP Daily Rate Histogram in the UK

OLAP
Hourly Rate Trend

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

OLAP Hourly Rate Trend in the UK

OLAP
Top 30 Contract Locations

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing OLAP within the UK over the 3 months to 5 February 2016. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -64 145 £438 +1.74% 71
London -43 67 £450 +4.34% 41
West Midlands -4 19 £381 +8.92% 3
South East +3 15 £450 +12.50% 8
City of London +17 14 £525 +29.23% 7
North West -12 14 £375 -16.66% 7
Manchester -10 13 £375 -16.66% 4
Yorkshire -32 13 £450 -5.26% 4
East Midlands 0 11 £500 +42.85% 5
West Yorkshire -26 10 £450 -5.26% 2
Berkshire +7 8 £400 +8.47% 1
Reading -8 8 £400 +8.47% 1
Birmingham 0 7 £389 +5.78%
Northamptonshire - 7 £500 - 2
Northampton - 6 £500 - 1
Leeds -28 5 £450 -15.88% 2
Halifax -3 4 £450 -2.70%
Sutton Coldfield - 4 - -
Suffolk +5 3 £400 -
East of England -19 3 £400 -8.57% 3
Hampshire - 3 £460 -
Belfast - 3 - -
County Antrim - 3 - -
Northern Ireland - 3 - -
Ipswich +10 2 - -
South Yorkshire -12 2 £450 -5.26% 2
Sheffield -14 2 £450 -5.26% 2
Oxford - 2 £450 -
Farnborough - 2 £460 -
Midlands - 2 £325 -

OLAP
Top 30 Related IT Skills

For the 6 months to 5 February 2016, IT contractor jobs within the UK citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited OLAP.

1 214 (61.49%) Business Intelligence
2 209 (60.06%) SQL
3 186 (53.45%) Data Warehouse
4 176 (50.57%) SQL Server Analysis Services
5 174 (50.00%) SQL Server
6 169 (48.56%) SQL Server Integration Services
7 152 (43.68%) ETL
8 149 (42.82%) SQL Server Reporting Services
9 146 (41.95%) OLAP Cube
10 115 (33.05%) Finance
11 104 (29.89%) T-SQL
12 102 (29.31%) Microsoft
13 93 (26.72%) MDX
14 79 (22.70%) Data Modelling
15 62 (17.82%) Agile Software Development
16 61 (17.53%) SQL Server 2008
17 58 (16.67%) Oracle
18 56 (16.09%) Kimball Methodology
18 56 (16.09%) Analytics
19 53 (15.23%) SQL Server 2012
19 53 (15.23%) Oracle OLAP
20 47 (13.51%) SAS
21 41 (11.78%) Dimensional Modelling
22 40 (11.49%) Analytical Skills
23 39 (11.21%) MS Excel
24 38 (10.92%) OLTP
25 37 (10.63%) C#
26 35 (10.06%) Relational Database
27 33 (9.48%) Migration
28 30 (8.62%) .NET

OLAP
Top Related IT Skills by Category

For the 6 months to 5 February 2016, IT contractor jobs within the UK citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 47 (13.51%) SAS
2 20 (5.75%) SharePoint
3 14 (4.02%) Apache Spark
4 12 (3.45%) Apache
5 8 (2.30%) IIS
6 6 (1.72%) Node.js
6 6 (1.72%) Oracle Coherence
7 4 (1.15%) Apache Pig
7 4 (1.15%) GemFire
8 2 (0.57%) SharePoint 2010
8 2 (0.57%) SharePoint 2013
9 1 (0.29%) CICS
9 1 (0.29%) Oracle Application Server
9 1 (0.29%) Tomcat
9 1 (0.29%) WebLogic
Applications
1 39 (11.21%) MS Excel
2 16 (4.60%) PowerPivot
3 14 (4.02%) MS Office
4 5 (1.44%) MS Visio
5 2 (0.57%) Spreadsheet
6 1 (0.29%) MS PowerPoint
Business Applications
1 7 (2.01%) Oracle EBS
2 5 (1.44%) SAP BPC
3 3 (0.86%) Cognos Business Intelligence
3 3 (0.86%) Global One
3 3 (0.86%) Oracle EBS R12
3 3 (0.86%) SAP FSCM
4 2 (0.57%) Dynamics AX
4 2 (0.57%) Dynamics CRM
4 2 (0.57%) SAP Oil and Gas
5 1 (0.29%) Cognos Controller
5 1 (0.29%) Cognos TM1
5 1 (0.29%) Dynamics GP
5 1 (0.29%) Markit EDM
5 1 (0.29%) Oracle 11i
5 1 (0.29%) Oracle ERP
5 1 (0.29%) SunGard Martini
5 1 (0.29%) SystmOne
5 1 (0.29%) Unit4 Business World
Cloud Services
1 10 (2.87%) Amazon AWS
2 8 (2.30%) Microsoft Azure
3 6 (1.72%) GitHub
4 2 (0.57%) SaaS
Communications & Networking
1 4 (1.15%) Extranet
1 4 (1.15%) Intranet
2 1 (0.29%) HTTP
2 1 (0.29%) HTTPS
2 1 (0.29%) SAN
2 1 (0.29%) TCP/IP
Database & Business Intelligence
1 186 (53.45%) Data Warehouse
2 176 (50.57%) SQL Server Analysis Services
3 174 (50.00%) SQL Server
4 169 (48.56%) SQL Server Integration Services
5 149 (42.82%) SQL Server Reporting Services
6 146 (41.95%) OLAP Cube
7 61 (17.53%) SQL Server 2008
8 53 (15.23%) Oracle OLAP
8 53 (15.23%) SQL Server 2012
9 38 (10.92%) OLTP
10 35 (10.06%) Relational Database
11 29 (8.33%) Oracle Database
11 29 (8.33%) SAS Data Integration Studio
11 29 (8.33%) SQL Server 2005
12 27 (7.76%) BusinessObjects
13 25 (7.18%) Microsoft Analysis Services
14 20 (5.75%) Star Schema
15 19 (5.46%) SQL Server 2014
16 17 (4.89%) Oracle Reports
16 17 (4.89%) Power BI
Development Applications
1 23 (6.61%) Team Foundation Server
2 15 (4.31%) Visual Studio
3 11 (3.16%) SQL Server Management Studio (SSMS)
4 4 (1.15%) ERwin
4 4 (1.15%) Hudson
4 4 (1.15%) JUnit
4 4 (1.15%) Toad
5 3 (0.86%) Maven
6 2 (0.57%) JIRA
7 1 (0.29%) Oracle Forms
General
1 115 (33.05%) Finance
2 20 (5.75%) Banking
3 19 (5.46%) Advertising
4 11 (3.16%) Retail
5 8 (2.30%) Front Office
6 7 (2.01%) Financial Institution
6 7 (2.01%) Investment Banking
6 7 (2.01%) Legal
6 7 (2.01%) Marketing
7 6 (1.72%) Publishing
8 5 (1.44%) Back Office
8 5 (1.44%) Telecoms
9 4 (1.15%) Billing
10 3 (0.86%) Manufacturing
11 2 (0.57%) Electronics
11 2 (0.57%) Pharmaceutical
11 2 (0.57%) Retail Banking
12 1 (0.29%) German Language
12 1 (0.29%) International Banking
12 1 (0.29%) Law
Job Titles
1 228 (65.52%) Developer
2 105 (30.17%) Business Intelligence Developer
3 63 (18.10%) SQL Developer
4 45 (12.93%) Analyst
5 40 (11.49%) SQL BI Developer
6 29 (8.33%) Business Developer
7 24 (6.90%) Architect
7 24 (6.90%) SAS Developer
8 23 (6.61%) Business Intelligence Analyst
8 23 (6.61%) Data Warehouse Developer
9 22 (6.32%) Microsoft Developer
10 21 (6.03%) Senior Developer
11 20 (5.75%) Microsoft BI Developer
12 19 (5.46%) Consultant
12 19 (5.46%) OLAP Developer
13 17 (4.89%) Data Analyst
14 16 (4.60%) Java Developer
15 15 (4.31%) DBA
16 13 (3.74%) Oracle Developer
17 11 (3.16%) ETL Developer
Libraries, Frameworks & Software Standards
1 93 (26.72%) MDX
2 30 (8.62%) .NET
3 17 (4.89%) XML
4 14 (4.02%) HTML
5 13 (3.74%) Web Services
6 8 (2.30%) AngularJS
6 8 (2.30%) Spring
7 7 (2.01%) CSS
8 6 (1.72%) ASP.NET
8 6 (1.72%) Backbone.js
8 6 (1.72%) Ember.js
8 6 (1.72%) Kafka
8 6 (1.72%) React
9 5 (1.44%) Ajax
9 5 (1.44%) ASP.NET MVC
9 5 (1.44%) REST
9 5 (1.44%) WPF
9 5 (1.44%) XSL
10 4 (1.15%) ActiveMQ
11 3 (0.86%) SOAP
Miscellaneous
1 40 (11.49%) Analytical Skills
2 17 (4.89%) NHS
3 15 (4.31%) Management Information System
3 15 (4.31%) Visualisation
4 11 (3.16%) Credit Risk
4 11 (3.16%) Statistics
5 9 (2.59%) Data Integration
5 9 (2.59%) Market Risk
6 8 (2.30%) Mathematics
6 8 (2.30%) Replication
7 7 (2.01%) Data Structures
8 6 (1.72%) Reference Data
9 5 (1.44%) Client/Server
9 5 (1.44%) Computer Science
9 5 (1.44%) Hedge funds
9 5 (1.44%) N-Tier
10 4 (1.15%) Data Centre
11 3 (0.86%) Fixed Income
11 3 (0.86%) Foreign Exchange (FX)
11 3 (0.86%) Grid Computing
Operating Systems
1 16 (4.60%) Unix
2 8 (2.30%) Linux
3 5 (1.44%) Windows
4 4 (1.15%) AIX
5 2 (0.57%) Windows Server
6 1 (0.29%) Windows Server 2012
6 1 (0.29%) zOS
Processes & Methodologies
1 214 (61.49%) Business Intelligence
2 152 (43.68%) ETL
3 79 (22.70%) Data Modelling
4 62 (17.82%) Agile Software Development
5 56 (16.09%) Analytics
5 56 (16.09%) Kimball Methodology
6 41 (11.78%) Dimensional Modelling
7 33 (9.48%) Migration
8 24 (6.90%) Data Management
9 23 (6.61%) Continuous Integration
9 23 (6.61%) Scrum
10 20 (5.75%) Data Analysis
11 19 (5.46%) TDD
12 18 (5.17%) ETL Development
12 18 (5.17%) Stakeholder Management
13 16 (4.60%) Data Validation
13 16 (4.60%) SDLC
13 16 (4.60%) Validation
14 15 (4.31%) Performance Tuning
15 14 (4.02%) BDD
Programming Languages
1 209 (60.06%) SQL
2 104 (29.89%) T-SQL
3 37 (10.63%) C#
4 26 (7.47%) PL/SQL
5 20 (5.75%) Java
6 15 (4.31%) JavaScript
7 14 (4.02%) Data Analysis Expressions (DAX)
7 14 (4.02%) Python
8 12 (3.45%) VBA
9 8 (2.30%) Shell Script
10 7 (2.01%) Scala
11 6 (1.72%) ES6
11 6 (1.72%) Ruby
12 3 (0.86%) ABAP
12 3 (0.86%) VB.NET
13 2 (0.57%) PowerShell
13 2 (0.57%) VB
13 2 (0.57%) XMLA
14 1 (0.29%) C-shell
14 1 (0.29%) X++
Qualifications
1 26 (7.47%) Security Cleared
2 19 (5.46%) SC Cleared
3 16 (4.60%) Degree
4 10 (2.87%) Microsoft Certification
5 4 (1.15%) ITIL Certification
5 4 (1.15%) SAS Certification
6 3 (0.86%) DV Cleared
6 3 (0.86%) PRINCE2 Certification
7 1 (0.29%) BC Cleared
7 1 (0.29%) Chartered Engineer
7 1 (0.29%) ISEB
7 1 (0.29%) MCDBA
7 1 (0.29%) MCP
7 1 (0.29%) MCTS
7 1 (0.29%) Microsoft Certified Architect
7 1 (0.29%) Oracle Certification
Quality Assurance & Compliance
1 28 (8.05%) Data Quality
2 5 (1.44%) QA
3 3 (0.86%) Disclosure Scotland
4 2 (0.57%) PCI DSS
4 2 (0.57%) SLA
5 1 (0.29%) Basel II
5 1 (0.29%) Basel III
5 1 (0.29%) ISO 9001
System Software
1 5 (1.44%) VMware Infrastructure
2 4 (1.15%) HDFS
3 3 (0.86%) Oracle RAC
4 2 (0.57%) Active Directory
Systems Management
1 3 (0.86%) Data Guard
1 3 (0.86%) Oracle EDQ
1 3 (0.86%) Oracle Enterprise Manager
1 3 (0.86%) Systems Management Server (SMS)
2 1 (0.29%) Oracle RMAN
Vendors
1 102 (29.31%) Microsoft
2 58 (16.67%) Oracle
3 28 (8.05%) Tableau
4 18 (5.17%) Cognos
5 17 (4.89%) Informatica
6 14 (4.02%) SAP
7 12 (3.45%) IBM
8 5 (1.44%) MicroStrategy
8 5 (1.44%) VMware
9 2 (0.57%) Ab Initio
9 2 (0.57%) Actian
10 1 (0.29%) Cadence
10 1 (0.29%) Fidessa
10 1 (0.29%) Google
10 1 (0.29%) Red Hat
10 1 (0.29%) Siebel
10 1 (0.29%) Sophis
10 1 (0.29%) SunGard
10 1 (0.29%) Sybase
Northamptonshire
ReThink Recruitment
Rate: £0.00 per annum
Posted: 2 days ago
City, London
Westbourne Partners
Rate: From £500 to £700 per day
Posted: 2 days ago
London
Nigel Frank International
Rate: £320 - £375 per day
Posted: 3 days ago
London
Nigel Frank International
Rate: £300 - £375 per day
Posted: 4 days ago
London
Nigel Frank International
Rate: £350 - £420 per day
Posted: 8 days ago
London
Nigel Frank International
Rate: £300 - £350 per day
Posted: 9 days ago
London
Nigel Frank International
Rate: £300 - £320 per day
Posted: 9 days ago
London
Nigel Frank International
Rate: £320 - £380 per day
Posted: 9 days ago
City of London
Nigel Frank International
Rate: £420 - £500 per day
Posted: 9 days ago
City of London
Nigel Frank International
Rate: £375 - £420 per day
Posted: 9 days ago
London
Nigel Frank International
Rate: £330 - £400 per day
Posted: 10 days ago
London
Nigel Frank International
Rate: £375 - £450 per day
Posted: 10 days ago
Oxfordshire
Nigel Frank International
Rate: £350 - £385 per day
Posted: 11 days ago
London
Nigel Frank International
Rate: £375 - £420 per day
Posted: 11 days ago
Cambridge
Nigel Frank International
Rate: £350 - £400 per day
Posted: 11 days ago
City of London
Nigel Frank International
Rate: £425 - £500 per day
Posted: 11 days ago
Glasgow
Hays Specialist Recruitment Ltd
Rate: £300.00 - £350 per day
Posted: 11 days ago
London
Nigel Frank International
Rate: £375 - £400 per day
Posted: 12 days ago
London
Nigel Frank International
Rate: £365 - £400 per day
Posted: 12 days ago
London
Nigel Frank International
Rate: £425 - £500 per day
Posted: 12 days ago
Sheffield
Hays Specialist Recruitment
Rate: negotiable
Posted: 16 days ago
Liverpool
Nigel Frank International
Rate: £425 - £525 per day
Posted: 19 days ago
Hertfordshire
Nigel Frank International
Rate: £350 - £400 per day
Posted: 24 days ago