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 4 May 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
4 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 545 400 386
Rank change year-on-year
-145 -14
Contract jobs citing OLAP 102 250 243
As % of all contract IT jobs located in the UK 0.18% 0.45% 0.45%
As % of the Database & Business Intelligence category 0.84% 1.95% 1.96%
Number of daily rates quoted 73 177 162
Median daily rate £413 £430 £422
Median daily rate % change year-on-year
-4.06% +1.89%
90% offered a daily rate of more than £353 £300 £288
10% offered a daily rate of more than £598 £505 £525
UK excluding London median daily rate £413 £375 £350
% change year-on-year
+10.00% +7.14%
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
12105 12807 12401
As % of all contract IT jobs located in the UK 21.78% 22.93% 22.74%
Number of daily rates quoted 8213 8278 7816
Median daily rate £425 £400 £388
Median daily rate % change year-on-year
+6.25% +3.22%
90% offered a daily rate of more than £300 £280 £260
10% offered a daily rate of more than £600 £550 £538
UK excluding London median daily rate £388 £375 £350
% change year-on-year
+3.33% +7.14%
Number of hourly rates quoted 164 171 212
Median hourly rate £34.50 £32.10 £35.00
Median hourly rate % change year-on-year
+7.47% -8.28%
90% offered a hourly rate of more than £13.85 £15.44 £13.65
10% offered a hourly rate of more than £48.65 £46.09 £55.00
UK excluding London median hourly rate £35.00 £32.10 £35.00
% change year-on-year
+9.03% -8.28%

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 4 May 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 4 May 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 -141 97 £425 -2.85% 51
London -67 49 £450 +2.27% 24
East Midlands +15 12 £425 -10.52% 5
North West -4 11 £413 -8.33% 3
Northamptonshire +13 9 £425 -12.82% 2
Cheshire -4 9 £413 -8.33% 2
South East -27 9 £375 +11.11% 7
Northampton +11 8 £425 -10.52% 2
Chester +9 7 £413 -8.33%
City of London -7 6 £425 -2.85% 9
South West +1 5 £338 -10.00%
West Midlands -18 5 £450 +38.46% 4
Buckinghamshire +10 4 £375 -
Milton Keynes +8 3 £375 -
South Wales 0 3 £390 -
Bristol -5 3 £300 -20.00%
Wales -9 3 £390 +29.56%
Yorkshire -40 3 £413 -5.71% 3
East of England +6 2 £525 -16.00% 2
Nottingham +5 2 £450 -
Bedfordshire +2 2 £525 -17.64%
Nottinghamshire -2 2 £450 -
Hampshire -4 2 £338 +35.00% 5
Edinburgh -15 2 £375 +76.47% 1
Scotland -23 2 £375 +46.34% 8
West Yorkshire -31 2 £413 -5.71% 2
Coventry - 2 - -
Berkshire +6 1 £263 - 2
Midlands -6 1 £350 -6.66% 1
Manchester -15 1 £220 -41.33%

OLAP
Top 30 Related IT Skills

For the 6 months to 4 May 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 157 (59.92%) Business Intelligence
2 150 (57.25%) SQL
3 130 (49.62%) SQL Server
4 119 (45.42%) Data Warehouse
5 114 (43.51%) ETL
5 114 (43.51%) SQL Server Analysis Services
6 98 (37.40%) SQL Server Integration Services
6 98 (37.40%) OLAP Cube
7 85 (32.44%) SQL Server Reporting Services
8 84 (32.06%) Microsoft
9 71 (27.10%) Finance
10 66 (25.19%) Analytics
11 64 (24.43%) Agile Software Development
12 50 (19.08%) MDX
13 48 (18.32%) T-SQL
14 46 (17.56%) Oracle
15 43 (16.41%) SQL Server 2008
16 41 (15.65%) Dimensional Modelling
16 41 (15.65%) Oracle OLAP
16 41 (15.65%) Kimball Methodology
17 40 (15.27%) Data Modelling
18 33 (12.60%) MS Excel
18 33 (12.60%) Continuous Integration
19 32 (12.21%) Analytical Skills
20 31 (11.83%) SAS
20 31 (11.83%) Migration
21 29 (11.07%) Java
21 29 (11.07%) SQL Server 2012
21 29 (11.07%) Data Quality
22 28 (10.69%) BusinessObjects

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 31 (11.83%) SAS
2 16 (6.11%) SharePoint
3 10 (3.82%) Apache Spark
4 5 (1.91%) IIS
4 5 (1.91%) Oracle Coherence
5 4 (1.53%) Apache
5 4 (1.53%) Apache Pig
6 3 (1.15%) GemFire
6 3 (1.15%) Node.js
6 3 (1.15%) SharePoint 2010
6 3 (1.15%) SharePoint 2013
7 2 (0.76%) Oracle Application Server
8 1 (0.38%) BizTalk Server
8 1 (0.38%) CICS
8 1 (0.38%) Commerce Server
8 1 (0.38%) Confluence
8 1 (0.38%) Facebook Platform
8 1 (0.38%) Tomcat
8 1 (0.38%) WebLogic
Applications
1 33 (12.60%) MS Excel
2 10 (3.82%) MS Office
3 6 (2.29%) MS Visio
4 3 (1.15%) MS PowerPoint
5 2 (0.76%) Spreadsheet
6 1 (0.38%) MS Project
6 1 (0.38%) SPSS
Business Applications
1 5 (1.91%) Global One
1 5 (1.91%) SAP BPC
2 3 (1.15%) Oracle EBS
3 2 (0.76%) Oracle EBS R12
4 1 (0.38%) Cognos TM1
4 1 (0.38%) Dynamics AX
4 1 (0.38%) Markit EDM
4 1 (0.38%) Oracle 11i
4 1 (0.38%) Oracle ERP
4 1 (0.38%) Radian6
4 1 (0.38%) SAP CRM
4 1 (0.38%) SAP ERP
4 1 (0.38%) SAP Oil and Gas
4 1 (0.38%) SAP R/3
4 1 (0.38%) SAP SCM
4 1 (0.38%) SunGard Martini
4 1 (0.38%) Unit4 Business World
4 1 (0.38%) WebTrends
Cloud Services
1 19 (7.25%) Microsoft Azure
2 10 (3.82%) IaaS
2 10 (3.82%) PaaS
3 5 (1.91%) Amazon AWS
4 3 (1.15%) GitHub
5 2 (0.76%) SaaS
6 1 (0.38%) AdWords
6 1 (0.38%) Google Analytics
Communications & Networking
1 14 (5.34%) Network Security
2 4 (1.53%) SAN
3 1 (0.38%) DNS
3 1 (0.38%) HTTP
3 1 (0.38%) HTTPS
3 1 (0.38%) Internet
3 1 (0.38%) TCP/IP
Database & Business Intelligence
1 130 (49.62%) SQL Server
2 119 (45.42%) Data Warehouse
3 114 (43.51%) SQL Server Analysis Services
4 98 (37.40%) OLAP Cube
4 98 (37.40%) SQL Server Integration Services
5 85 (32.44%) SQL Server Reporting Services
6 43 (16.41%) SQL Server 2008
7 41 (15.65%) Oracle OLAP
8 29 (11.07%) SQL Server 2012
9 28 (10.69%) BusinessObjects
10 26 (9.92%) Big Data
11 22 (8.40%) Microsoft Analysis Services
12 20 (7.63%) OLTP
12 20 (7.63%) Relational Database
13 15 (5.73%) Oracle Database
13 15 (5.73%) Oracle Reports
13 15 (5.73%) QlikView
13 15 (5.73%) SAS Data Integration Studio
14 14 (5.34%) Power BI
14 14 (5.34%) RDBMS
Development Applications
1 10 (3.82%) Jenkins
1 10 (3.82%) Team Foundation Server
2 9 (3.44%) Talend Open Studio
3 5 (1.91%) ERwin
4 4 (1.53%) JIRA
4 4 (1.53%) JUnit
5 3 (1.15%) Hudson
6 2 (0.76%) Maven
6 2 (0.76%) SQL Server Management Studio (SSMS)
7 1 (0.38%) Git (software)
7 1 (0.38%) Toad
7 1 (0.38%) Visual Studio
General
1 71 (27.10%) Finance
2 25 (9.54%) Banking
3 10 (3.82%) Front Office
4 9 (3.44%) Retail
5 7 (2.67%) Financial Institution
6 6 (2.29%) Back Office
7 5 (1.91%) Marketing
8 4 (1.53%) Billing
8 4 (1.53%) Investment Banking
9 3 (1.15%) Advertising
9 3 (1.15%) Publishing
10 2 (0.76%) French Language
10 2 (0.76%) International Banking
10 2 (0.76%) Legal
10 2 (0.76%) Telecoms
11 1 (0.38%) Electronics
11 1 (0.38%) Games
11 1 (0.38%) Law
11 1 (0.38%) Manufacturing
11 1 (0.38%) Retail Banking
Job Titles
1 156 (59.54%) Developer
2 53 (20.23%) Business Intelligence Developer
3 45 (17.18%) SQL Developer
4 32 (12.21%) Analyst
5 24 (9.16%) SSIS Developer
6 21 (8.02%) SQL BI Developer
7 20 (7.63%) SSAS Developer
8 19 (7.25%) Data Warehouse Developer
9 18 (6.87%) Architect
9 18 (6.87%) Java Developer
9 18 (6.87%) Senior Developer
9 18 (6.87%) SSRS Developer
10 17 (6.49%) Business Developer
10 17 (6.49%) DBA
11 15 (5.73%) Business Intelligence Analyst
11 15 (5.73%) SAS Developer
12 13 (4.96%) Consultant
13 12 (4.58%) Data Analyst
14 11 (4.20%) ETL Developer
15 10 (3.82%) OLAP Developer
Libraries, Frameworks & Software Standards
1 50 (19.08%) MDX
2 16 (6.11%) .NET
3 10 (3.82%) XML
4 8 (3.05%) HTML
5 7 (2.67%) Web Services
6 6 (2.29%) AngularJS
6 6 (2.29%) REST
6 6 (2.29%) Spring
7 4 (1.53%) Java Concurrency
7 4 (1.53%) Middleware
8 3 (1.15%) ActiveMQ
8 3 (1.15%) ASP.NET
8 3 (1.15%) Backbone.js
8 3 (1.15%) Ember.js
8 3 (1.15%) HTML5
8 3 (1.15%) Kafka
8 3 (1.15%) Oracle GoldenGate
8 3 (1.15%) React
8 3 (1.15%) XSD
8 3 (1.15%) XSLT
Miscellaneous
1 32 (12.21%) Analytical Skills
2 21 (8.02%) Visualisation
3 14 (5.34%) Data Integration
4 11 (4.20%) NHS
5 10 (3.82%) Credit Risk
6 9 (3.44%) Data Structures
6 9 (3.44%) Digital Media
6 9 (3.44%) Management Information System
7 7 (2.67%) Client/Server
7 7 (2.67%) Market Risk
7 7 (2.67%) Replication
8 6 (2.29%) Reference Data
9 5 (1.91%) Hedge funds
10 4 (1.53%) Computer Science
10 4 (1.53%) Data Centre
10 4 (1.53%) Foreign Exchange (FX)
10 4 (1.53%) Mathematics
10 4 (1.53%) Statistics
11 3 (1.15%) Social Media
12 2 (0.76%) Algorithms
Operating Systems
1 18 (6.87%) Linux
2 13 (4.96%) Unix
3 9 (3.44%) VMS
4 3 (1.15%) AIX
4 3 (1.15%) Windows
5 2 (0.76%) Windows Server
5 2 (0.76%) Windows Server 2012
6 1 (0.38%) Windows Server 2008
6 1 (0.38%) zOS
Processes & Methodologies
1 157 (59.92%) Business Intelligence
2 114 (43.51%) ETL
3 66 (25.19%) Analytics
4 64 (24.43%) Agile Software Development
5 41 (15.65%) Dimensional Modelling
5 41 (15.65%) Kimball Methodology
6 40 (15.27%) Data Modelling
7 33 (12.60%) Continuous Integration
8 31 (11.83%) Migration
9 27 (10.31%) Data Management
10 23 (8.78%) Stakeholder Management
11 18 (6.87%) Performance Tuning
12 17 (6.49%) Data Analysis
12 17 (6.49%) Scrum
13 15 (5.73%) Mentoring
14 14 (5.34%) Risk Management
15 13 (4.96%) E-Commerce
15 13 (4.96%) Low Latency
16 12 (4.58%) Data Architecture
16 12 (4.58%) User Acceptance Testing
Programming Languages
1 150 (57.25%) SQL
2 48 (18.32%) T-SQL
3 29 (11.07%) Java
4 26 (9.92%) C#
5 18 (6.87%) PL/SQL
6 15 (5.73%) VBA
7 11 (4.20%) JavaScript
8 7 (2.67%) Python
9 5 (1.91%) PHP
9 5 (1.91%) PowerShell
10 4 (1.53%) Data Analysis Expressions (DAX)
10 4 (1.53%) Shell Script
11 3 (1.15%) ES6
11 3 (1.15%) Ruby
11 3 (1.15%) Scala
12 2 (0.76%) R
12 2 (0.76%) VB
13 1 (0.38%) VBScript
Qualifications
1 9 (3.44%) Security Cleared
2 7 (2.67%) Degree
2 7 (2.67%) Microsoft Certification
3 5 (1.91%) SC Cleared
4 4 (1.53%) ITIL Certification
5 3 (1.15%) PRINCE2 Certification
6 2 (0.76%) DV Cleared
7 1 (0.38%) BC Cleared
7 1 (0.38%) Chartered Engineer
7 1 (0.38%) MCDBA
7 1 (0.38%) MCP
7 1 (0.38%) MCTS
7 1 (0.38%) Microsoft Certified Architect
7 1 (0.38%) SAS Certification
Quality Assurance & Compliance
1 29 (11.07%) Data Quality
2 4 (1.53%) QA
3 2 (0.76%) Disclosure Scotland
4 1 (0.38%) ISO 9001
4 1 (0.38%) PCI DSS
4 1 (0.38%) Solvency II
System Software
1 8 (3.05%) Microsoft Virtual Server
2 4 (1.53%) HDFS
3 3 (1.15%) Oracle RAC
Systems Management
1 3 (1.15%) Data Guard
1 3 (1.15%) Oracle EDQ
2 2 (0.76%) Oracle RMAN
3 1 (0.38%) HP Quality Center
3 1 (0.38%) Oracle Enterprise Manager
3 1 (0.38%) Puppet
Vendors
1 84 (32.06%) Microsoft
2 46 (17.56%) Oracle
3 24 (9.16%) Tableau
4 14 (5.34%) Cognos
5 12 (4.58%) SAP
6 10 (3.82%) MicroStrategy
6 10 (3.82%) Vertica
7 9 (3.44%) Talend
8 6 (2.29%) Informatica
9 5 (1.91%) IBM
10 3 (1.15%) Red Hat
10 3 (1.15%) Sybase
10 3 (1.15%) Teradata
11 2 (0.76%) Ab Initio
11 2 (0.76%) Cadence
11 2 (0.76%) EMC
12 1 (0.38%) Fidessa
12 1 (0.38%) Hyperion
12 1 (0.38%) Siebel
12 1 (0.38%) SunGard
City, London
Nigel Frank International Ltd
Rate: £550 - £600 per day
Posted: 2 hours ago
Cheshire
Vivid Resourcing
Posted: 15 hours ago
London
Vivid Resourcing
Posted: 15 hours ago
City, London
Salt
Rate: £675 - £775 per day
Posted: Yesterday
London
Joseph Harry Ltd
Posted: 3 days ago
Midlands
Venturi
Rate: £300 - £400 per day
Posted: 5 days ago
East Midlands
Venturi
Rate: £300 - £400 per day
Posted: 5 days ago
Glasgow, Lanarkshire
HAYS INFORMATION TECHNOLOGY
Rate: £300.00 - £400.00 per day
Posted: 6 days ago
Glasgow, Lanarkshire
Search Consultancy
Rate: Excellent rate plus benefits
Posted: 6 days ago
Glasgow, Lanarkshire
HAYS INFORMATION TECHNOLOGY
Rate: £300.00 - £350 per day
Posted: 6 days ago
Glasgow, Lanarkshire
Net Talent
Rate: Excellent day rate on offer
Posted: 6 days ago
Derbyshire
Vivid Resourcing
Rate: Market related
Posted: 9 days ago
Leeds
Real Staffing
Rate: £375 - £400 per day
Posted: 16 days ago
Cheshire
Vivid Resourcing
Rate: £400 - 450 per day
Posted: 16 days ago
Slough
Vivid Resourcing
Rate: £450 - 500 per day
Posted: 16 days ago
London
Vivid Resourcing
Rate: £55k - 70k per year + pa + Benefits.
Posted: 25 days ago