The table below looks at the statistics for OLAP skills in IT contracts advertised across the UK. Included is a guide to the contractor rates offered in IT contracts that have cited OLAP over the 3 months to 25 June 2016 with a comparison to the same period over 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.

3 months to
25 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 501 408 420
Rank change year-on-year
-93 +12
Contract jobs citing OLAP 142 235 209
As % of all contract IT jobs located in the UK 0.27% 0.42% 0.39%
As % of the Database & Business Intelligence category 1.23% 1.79% 1.73%
Number of daily rates quoted 102 160 142
Median daily rate £413 £438 £405
Median daily rate % change year-on-year
-5.71% +8.02%
90% offered a daily rate of more than £313 £325 £292
10% offered a daily rate of more than £550 £550 £548
UK excluding London median daily rate £413 £425 £338
% change year-on-year
-2.94% +25.92%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -

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
11578 13148 12063
As % of all contract IT jobs located in the UK 21.82% 23.47% 22.30%
Number of daily rates quoted 7850 8593 7561
Median daily rate £425 £400 £400
Median daily rate % change year-on-year
+6.25% -
90% offered a daily rate of more than £300 £275 £270
10% offered a daily rate of more than £588 £550 £550
UK excluding London median daily rate £380 £350 £350
% change year-on-year
+8.57% -
Number of hourly rates quoted 192 187 200
Median hourly rate £31.00 £27.78 £29.00
Median hourly rate % change year-on-year
+11.59% -4.20%
90% offered a hourly rate of more than £12.00 £16.00 £13.50
10% offered a hourly rate of more than £49.00 £52.17 £52.50
UK excluding London median hourly rate £30.75 £26.00 £30.00
% change year-on-year
+18.26% -13.33%

OLAP
Jobs Demand Trend

The demand trend of contract jobs citing OLAP as a proportion of all IT contracts with a match in 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 25 June 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 median contractor rates quoted in IT jobs citing OLAP within the UK over the 3 months to 25 June 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
(Click see detailed
statistics and trends)
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 -72 135 £413 -7.04% 33
London -27 64 £440 -2.22% 11
North West -5 21 £413 -10.32% 4
Cheshire +14 20 £413 -13.15% 2
City of London -1 16 £475 +8.57%
Chester +6 15 £413 -25.00%
South East -4 13 £375 -11.76% 7
East Midlands +7 9 £400 -15.78% 2
Yorkshire -17 9 £538 +26.47% 2
West Yorkshire -22 9 £538 +26.47% 2
West Midlands -26 7 £363 +11.53% 2
East of England +15 6 £413 +8.55% 3
Scotland -13 6 £313 -37.50% 1
Glasgow - 6 £313 -
Northamptonshire +5 5 - -
Bradford +14 4 £538 - 2
Buckinghamshire +14 4 £375 -16.66% 1
Slough +8 4 £351 -7.56%
South West +3 4 £288 -12.21% 1
Berkshire -6 4 £351 -0.35% 1
Hertfordshire - 4 £375 -
Coventry - 4 - -
Milton Keynes +11 3 £375 -16.66% 1
Hampshire +2 3 £338 -11.47% 4
Northampton -1 3 - -
Canary Wharf - 3 £475 -
Bedfordshire +4 2 £575 - 1
Luton +1 2 £575 -
Macclesfield +1 2 £525 -
Dorset -10 2 £225 -25.61%

OLAP
Top 30 Related IT Skills

For the 6 months to 25 June 2016, 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 175 (67.05%) Business Intelligence
2 161 (61.69%) SQL
3 145 (55.56%) SQL Server
4 134 (51.34%) ETL
5 129 (49.43%) SQL Server Analysis Services
6 125 (47.89%) Data Warehouse
7 106 (40.61%) SQL Server Integration Services
8 105 (40.23%) Microsoft
9 101 (38.70%) OLAP Cube
10 94 (36.02%) SQL Server Reporting Services
11 75 (28.74%) Agile Software Development
12 70 (26.82%) Finance
13 59 (22.61%) Analytics
14 58 (22.22%) Kimball Methodology
15 57 (21.84%) MDX
16 55 (21.07%) Dimensional Modelling
17 48 (18.39%) T-SQL
17 48 (18.39%) SQL Server 2008
18 44 (16.86%) Oracle
19 42 (16.09%) Data Modelling
20 39 (14.94%) Oracle OLAP
21 38 (14.56%) SQL Server 2012
22 37 (14.18%) Continuous Integration
22 37 (14.18%) Java
23 35 (13.41%) MS Excel
24 34 (13.03%) OLTP
25 33 (12.64%) Big Data
26 30 (11.49%) Banking
26 30 (11.49%) Analytical Skills
27 28 (10.73%) E-Commerce

OLAP
Top Related 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 15 (5.75%) SAS
2 13 (4.98%) SharePoint
3 11 (4.21%) IIS
4 3 (1.15%) Apache
4 3 (1.15%) Apache Spark
4 3 (1.15%) Oracle Coherence
5 2 (0.77%) BizTalk Server
5 2 (0.77%) Oracle Application Server
5 2 (0.77%) SharePoint 2010
6 1 (0.38%) CMS
6 1 (0.38%) Commerce Server
6 1 (0.38%) Confluence
6 1 (0.38%) Facebook Platform
6 1 (0.38%) Oracle HTTP Server
6 1 (0.38%) SharePoint 2013
6 1 (0.38%) Sitecore CMS
6 1 (0.38%) Tomcat
6 1 (0.38%) WebLogic
6 1 (0.38%) WebSphere
Applications
1 35 (13.41%) MS Excel
2 6 (2.30%) MS Office
3 4 (1.53%) MS Visio
4 3 (1.15%) MS PowerPoint
5 2 (0.77%) Spreadsheet
6 1 (0.38%) MS Project
6 1 (0.38%) SPSS
Business Applications
1 8 (3.07%) Dynamics CRM
2 5 (1.92%) Global One
3 4 (1.53%) Cognos Business Intelligence
4 3 (1.15%) Cognos TM1
5 2 (0.77%) Oracle EBS
6 1 (0.38%) Cognos Planning
6 1 (0.38%) Markit EDM
6 1 (0.38%) Oracle 11i
6 1 (0.38%) Oracle EBS R12
6 1 (0.38%) Radian6
6 1 (0.38%) SAP BPC
6 1 (0.38%) SAP CRM
6 1 (0.38%) SAP ERP
6 1 (0.38%) SAP Oil and Gas
6 1 (0.38%) SAP R/3
6 1 (0.38%) SAP SCM
6 1 (0.38%) SunGard Martini
6 1 (0.38%) SystmOne
6 1 (0.38%) Unit4 Business World
6 1 (0.38%) WebTrends
Cloud Services
1 23 (8.81%) Microsoft Azure
2 11 (4.21%) IaaS
2 11 (4.21%) PaaS
3 7 (2.68%) Amazon AWS
4 3 (1.15%) SaaS
5 2 (0.77%) GitHub
6 1 (0.38%) AdWords
6 1 (0.38%) Azure Machine Learning
6 1 (0.38%) Cloud Computing
6 1 (0.38%) Google Analytics
Communications & Networking
1 16 (6.13%) Network Security
2 6 (2.30%) Extranet
2 6 (2.30%) Intranet
3 5 (1.92%) SAN
4 2 (0.77%) Internet
5 1 (0.38%) DNS
5 1 (0.38%) FCoE
5 1 (0.38%) Fibre Channel
5 1 (0.38%) HTTP
5 1 (0.38%) iSCSI
5 1 (0.38%) LAN
5 1 (0.38%) Multicast
5 1 (0.38%) NAS
5 1 (0.38%) WAN
Database & Business Intelligence
1 145 (55.56%) SQL Server
2 129 (49.43%) SQL Server Analysis Services
3 125 (47.89%) Data Warehouse
4 106 (40.61%) SQL Server Integration Services
5 101 (38.70%) OLAP Cube
6 94 (36.02%) SQL Server Reporting Services
7 48 (18.39%) SQL Server 2008
8 39 (14.94%) Oracle OLAP
9 38 (14.56%) SQL Server 2012
10 34 (13.03%) OLTP
11 33 (12.64%) Big Data
12 27 (10.34%) BusinessObjects
13 26 (9.96%) Microsoft Analysis Services
14 19 (7.28%) Relational Database
14 19 (7.28%) SQL Server 2014
15 17 (6.51%) Power BI
15 17 (6.51%) SQL Server 2005
16 14 (5.36%) QlikView
16 14 (5.36%) SQL Server 2016
17 13 (4.98%) Oracle Database
Development Applications
1 24 (9.20%) Jenkins
2 17 (6.51%) Talend Open Studio
3 9 (3.45%) Visual Studio
4 8 (3.07%) Team Foundation Server
5 5 (1.92%) NUnit
5 5 (1.92%) SpecFlow
5 5 (1.92%) SQL Server Management Studio (SSMS)
6 4 (1.53%) ERwin
7 3 (1.15%) JUnit
7 3 (1.15%) Toad
8 2 (0.77%) Git (software)
8 2 (0.77%) JIRA
9 1 (0.38%) Visual Studio Tools for Office
General
1 70 (26.82%) Finance
2 30 (11.49%) Banking
3 10 (3.83%) Investment Banking
4 8 (3.07%) Advertising
5 6 (2.30%) Front Office
5 6 (2.30%) Retail
6 5 (1.92%) Financial Institution
7 4 (1.53%) Back Office
7 4 (1.53%) Marketing
8 3 (1.15%) Billing
8 3 (1.15%) Publishing
9 2 (0.77%) French Language
9 2 (0.77%) International Banking
9 2 (0.77%) Telecoms
10 1 (0.38%) Electronics
10 1 (0.38%) Legal
10 1 (0.38%) Manufacturing
10 1 (0.38%) Pharmaceutical
Job Titles
1 161 (61.69%) Developer
2 71 (27.20%) Business Intelligence Developer
3 55 (21.07%) SQL Developer
4 31 (11.88%) Analyst
5 30 (11.49%) SQL BI Developer
6 29 (11.11%) SSAS Developer
7 26 (9.96%) DBA
7 26 (9.96%) SSIS Developer
8 25 (9.58%) SSRS Developer
9 23 (8.81%) Data Warehouse Developer
10 22 (8.43%) Architect
11 17 (6.51%) ETL Developer
12 16 (6.13%) Business Developer
13 15 (5.75%) Business Intelligence Analyst
13 15 (5.75%) Senior Developer
14 13 (4.98%) Java Developer
15 11 (4.21%) Consultant
16 10 (3.83%) Microsoft Developer
17 9 (3.45%) SQL DBA
17 9 (3.45%) Talend Developer
Libraries, Frameworks & Software Standards
1 57 (21.84%) MDX
2 17 (6.51%) .NET
3 11 (4.21%) Web Services
4 9 (3.45%) HTML
4 9 (3.45%) XML
5 8 (3.07%) ASP.NET
5 8 (3.07%) REST
6 5 (1.92%) AngularJS
6 5 (1.92%) HTML5
6 5 (1.92%) Middleware
7 4 (1.53%) Java Concurrency
7 4 (1.53%) JSON
8 3 (1.15%) XSD
8 3 (1.15%) XSLT
9 2 (0.77%) Backbone.js
9 2 (0.77%) Ember.js
9 2 (0.77%) Kafka
9 2 (0.77%) Node.js
9 2 (0.77%) Oracle Streams
9 2 (0.77%) RESTful
Miscellaneous
1 30 (11.49%) Analytical Skills
2 14 (5.36%) Visualisation
3 11 (4.21%) Credit Risk
3 11 (4.21%) Data Integration
3 11 (4.21%) Replication
4 10 (3.83%) Digital Media
5 9 (3.45%) Data Structures
5 9 (3.45%) NHS
6 8 (3.07%) Management Information System
7 5 (1.92%) Foreign Exchange (FX)
7 5 (1.92%) Reference Data
8 4 (1.53%) Algorithms
8 4 (1.53%) Client/Server
8 4 (1.53%) Clustering
8 4 (1.53%) Computer Science
9 3 (1.15%) Data Centre
9 3 (1.15%) Enterprise Software
9 3 (1.15%) Market Risk
9 3 (1.15%) Statistics
10 2 (0.77%) Hedge funds
Operating Systems
1 25 (9.58%) Linux
2 9 (3.45%) VMS
3 6 (2.30%) Unix
4 3 (1.15%) Windows
5 1 (0.38%) AIX
5 1 (0.38%) Solaris
5 1 (0.38%) Windows Server 2008
5 1 (0.38%) Windows Server 2012
Processes & Methodologies
1 175 (67.05%) Business Intelligence
2 134 (51.34%) ETL
3 75 (28.74%) Agile Software Development
4 59 (22.61%) Analytics
5 58 (22.22%) Kimball Methodology
6 55 (21.07%) Dimensional Modelling
7 42 (16.09%) Data Modelling
8 37 (14.18%) Continuous Integration
9 28 (10.73%) E-Commerce
10 25 (9.58%) Data Management
10 25 (9.58%) Performance Tuning
11 23 (8.81%) Migration
12 20 (7.66%) CRM
13 16 (6.13%) Scrum
13 16 (6.13%) Stakeholder Management
14 15 (5.75%) Mentoring
15 14 (5.36%) SDLC
16 13 (4.98%) Low Latency
17 12 (4.60%) Business Analysis
17 12 (4.60%) TDD
Programming Languages
1 161 (61.69%) SQL
2 48 (18.39%) T-SQL
3 37 (14.18%) Java
4 21 (8.05%) C#
5 12 (4.60%) JavaScript
6 11 (4.21%) PL/SQL
7 10 (3.83%) VBA
8 7 (2.68%) PHP
9 5 (1.92%) MATLAB
9 5 (1.92%) PowerShell
9 5 (1.92%) VB.NET
10 4 (1.53%) Data Analysis Expressions (DAX)
11 3 (1.15%) Python
11 3 (1.15%) R
11 3 (1.15%) Shell Script
12 2 (0.77%) ES6
12 2 (0.77%) Ruby
12 2 (0.77%) Scala
12 2 (0.77%) VB
13 1 (0.38%) VBScript
Qualifications
1 8 (3.07%) Security Cleared
2 7 (2.68%) Degree
3 5 (1.92%) SC Cleared
4 3 (1.15%) ITIL Certification
5 2 (0.77%) DV Cleared
6 1 (0.38%) MBA
6 1 (0.38%) MCDBA
6 1 (0.38%) MCTS
6 1 (0.38%) Microsoft Certification
6 1 (0.38%) Microsoft Certified Architect
Quality Assurance & Compliance
1 27 (10.34%) Data Quality
2 4 (1.53%) QA
3 3 (1.15%) SLA
4 1 (0.38%) PCI DSS
4 1 (0.38%) Solvency II
System Software
1 9 (3.45%) Virtual Servers
2 8 (3.07%) Microsoft Virtual Server
3 3 (1.15%) Oracle RAC
4 1 (0.38%) Active Directory
4 1 (0.38%) Hyper-V
4 1 (0.38%) KVM
4 1 (0.38%) NFS
4 1 (0.38%) SRDF
4 1 (0.38%) Virtual Machines
4 1 (0.38%) VMware Infrastructure
4 1 (0.38%) Xen
Systems Management
1 3 (1.15%) Oracle EDQ
2 2 (0.77%) Data Guard
2 2 (0.77%) Oracle RMAN
3 1 (0.38%) HP Quality Center
3 1 (0.38%) Microsoft Clustering
3 1 (0.38%) Puppet
Vendors
1 105 (40.23%) Microsoft
2 44 (16.86%) Oracle
3 25 (9.58%) Tableau
4 20 (7.66%) Vertica
5 17 (6.51%) Talend
6 15 (5.75%) Cognos
7 14 (5.36%) Informatica
8 12 (4.60%) SAP
9 9 (3.45%) MicroStrategy
10 7 (2.68%) Teradata
11 6 (2.30%) IBM
12 4 (1.53%) Sybase
13 3 (1.15%) EMC
13 3 (1.15%) Hyperion
13 3 (1.15%) Red Hat
14 2 (0.77%) Cadence
14 2 (0.77%) Sitecore
14 2 (0.77%) VMware
15 1 (0.38%) DoubleClick
15 1 (0.38%) Omniture
Lincolnshire
Nigel Frank International Ltd
Rate: £275 per day
Posted: Yesterday
Bristol
Vivid Resourcing
Posted: 2 days ago
London
Salt
Rate: £350.00 - £450.00 per day
Posted: 4 days ago
Cheshire
Oscar
Rate: £350 - £550 per day
Posted: 3 days ago
Cheshire
Vivid Resourcing
Posted: 26 days ago