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 29 September 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
29 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 524 441 431
Rank change year-on-year
-83 -10
Contract jobs citing OLAP 129 229 215
As % of all contract IT jobs located in the UK 0.24% 0.39% 0.37%
As % of the Database & Business Intelligence category 1.07% 1.72% 1.72%
Number of daily rates quoted 97 178 132
Median daily rate £425 £425 £425
90% offered a daily rate of more than £315 £325 £260
10% offered a daily rate of more than £585 £525 £575
UK excluding London median daily rate £381 £400 £371
% change year-on-year
-4.68% +7.74%
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
12107 13315 12485
As % of all contract IT jobs located in the UK 22.68% 22.96% 21.49%
Number of daily rates quoted 8012 8809 7930
Median daily rate £425 £415 £400
Median daily rate % change year-on-year
+2.40% +3.75%
90% offered a daily rate of more than £300 £295 £270
10% offered a daily rate of more than £575 £575 £550
UK excluding London median daily rate £380 £375 £350
% change year-on-year
+1.33% +7.14%
Number of hourly rates quoted 191 194 202
Median hourly rate £38.00 £33.55 £25.00
Median hourly rate % change year-on-year
+13.26% +34.20%
90% offered a hourly rate of more than £13.00 £12.50 £12.50
10% offered a hourly rate of more than £48.00 £45.00 £55.00
UK excluding London median hourly rate £37.50 £33.55 £22.50
% change year-on-year
+11.77% +49.11%

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 29 September 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 29 September 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 -77 125 £425 - 31
London -65 40 £500 +15.60% 9
Yorkshire +18 19 £340 -21.15% 3
North West -11 18 £500 +17.64% 5
South West +28 16 £400 +23.07% 2
Leeds +22 14 £340 +8.80% 2
Cheshire +20 14 £550 +37.50%
West Yorkshire +18 14 £340 -23.38% 2
South East -9 9 £388 +6.89% 2
West Midlands -31 9 £325 +1.96% 2
Bristol +6 7 £313 -3.84% 2
East of England +4 6 £305 -23.75% 5
Gloucestershire - 5 £400 -
West Sussex +7 4 £315 -
Manchester -14 4 £400 -5.88% 4
Cambridge - 4 £305 - 1
Cambridgeshire - 4 £305 - 1
Chester +4 3 £600 +21.51%
Sheffield +2 3 £600 +60.00%
South Yorkshire -3 3 £600 +60.00%
Coventry -10 3 £325 -3.70% 1
City of London -18 3 £538 +22.85% 3
North East - 3 £350 - 2
Tyne and Wear - 3 £350 -
Crawley - 3 £315 -
Gloucester - 3 £400 -
Newcastle upon Tyne - 3 £350 -
Macclesfield - 3 £500 -
Wales +20 2 £456 -8.85%
South Wales +19 2 £456 -8.85%

OLAP
Top 30 Related IT Skills

For the 6 months to 29 September 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 173 (64.07%) Business Intelligence
2 170 (62.96%) SQL
3 148 (54.81%) SQL Server
3 148 (54.81%) ETL
4 146 (54.07%) SQL Server Analysis Services
5 125 (46.30%) Data Warehouse
6 115 (42.59%) SQL Server Integration Services
7 101 (37.41%) OLAP Cube
8 94 (34.81%) SQL Server Reporting Services
9 85 (31.48%) Microsoft
10 84 (31.11%) Finance
11 70 (25.93%) MDX
12 67 (24.81%) Kimball Methodology
13 62 (22.96%) Analytics
14 58 (21.48%) Agile Software Development
15 57 (21.11%) Oracle
15 57 (21.11%) Oracle OLAP
15 57 (21.11%) Dimensional Modelling
16 47 (17.41%) Big Data
16 47 (17.41%) T-SQL
17 46 (17.04%) Data Modelling
18 44 (16.30%) Java
19 42 (15.56%) Linux
20 41 (15.19%) Performance Tuning
21 39 (14.44%) SQL Server 2012
21 39 (14.44%) Continuous Integration
22 37 (13.70%) OLTP
23 36 (13.33%) Microsoft Analysis Services
23 36 (13.33%) Jenkins
23 36 (13.33%) Analytical Skills

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 20 (7.41%) SAS
2 10 (3.70%) Apache Spark
3 8 (2.96%) SharePoint
4 7 (2.59%) Apache Pig
5 6 (2.22%) IIS
6 3 (1.11%) Apache
7 2 (0.74%) Confluence
8 1 (0.37%) BizTalk Server
8 1 (0.37%) CMS
8 1 (0.37%) Commerce Server
8 1 (0.37%) Facebook Platform
8 1 (0.37%) Oracle Application Server
8 1 (0.37%) Oracle Coherence
8 1 (0.37%) Oracle HTTP Server
8 1 (0.37%) SharePoint 2013
8 1 (0.37%) Sitecore CMS
8 1 (0.37%) Tomcat
8 1 (0.37%) WebSphere
Applications
1 30 (11.11%) MS Excel
2 10 (3.70%) MS Office
3 6 (2.22%) MS Visio
4 3 (1.11%) MS PowerPoint
5 2 (0.74%) Spreadsheet
5 2 (0.74%) SPSS
Business Applications
1 9 (3.33%) Dynamics CRM
2 6 (2.22%) Cognos Business Intelligence
2 6 (2.22%) Cognos TM1
3 2 (0.74%) Oracle EBS
4 1 (0.37%) Cognos Planning
4 1 (0.37%) Dynamics AX
4 1 (0.37%) Oracle Financials
4 1 (0.37%) Oracle General Ledger
4 1 (0.37%) Oracle Payables
4 1 (0.37%) Oracle Receivables
4 1 (0.37%) Radian6
4 1 (0.37%) SAP CRM
4 1 (0.37%) SAP ERP
4 1 (0.37%) SAP R/3
4 1 (0.37%) SAP SCM
4 1 (0.37%) SystmOne
4 1 (0.37%) WebTrends
Cloud Services
1 15 (5.56%) Amazon AWS
1 15 (5.56%) Microsoft Azure
2 7 (2.59%) SaaS
3 5 (1.85%) IaaS
3 5 (1.85%) PaaS
4 4 (1.48%) Amazon EMR
4 4 (1.48%) Amazon S3
4 4 (1.48%) AWS Lambda
5 1 (0.37%) AdWords
5 1 (0.37%) Azure Machine Learning
5 1 (0.37%) Cloud Computing
5 1 (0.37%) Data Lake Analytics
5 1 (0.37%) Google Analytics
5 1 (0.37%) Office 365
Communications & Networking
1 9 (3.33%) Network Security
2 6 (2.22%) Extranet
2 6 (2.22%) Intranet
3 4 (1.48%) SAN
4 2 (0.74%) Internet
5 1 (0.37%) FCoE
5 1 (0.37%) Fibre Channel
5 1 (0.37%) HTTP
5 1 (0.37%) iSCSI
5 1 (0.37%) LAN
5 1 (0.37%) Multicast
5 1 (0.37%) NAS
5 1 (0.37%) WAN
Database & Business Intelligence
1 148 (54.81%) SQL Server
2 146 (54.07%) SQL Server Analysis Services
3 125 (46.30%) Data Warehouse
4 115 (42.59%) SQL Server Integration Services
5 101 (37.41%) OLAP Cube
6 94 (34.81%) SQL Server Reporting Services
7 57 (21.11%) Oracle OLAP
8 47 (17.41%) Big Data
9 39 (14.44%) SQL Server 2012
10 37 (13.70%) OLTP
11 36 (13.33%) Microsoft Analysis Services
12 31 (11.48%) BusinessObjects
13 30 (11.11%) SQL Server 2008
14 28 (10.37%) SQL Server 2014
15 22 (8.15%) Relational Database
16 18 (6.67%) Data Mart
16 18 (6.67%) Power BI
17 16 (5.93%) Star Schema
18 15 (5.56%) SQL Server 2005
19 14 (5.19%) Oracle BI EE
Development Applications
1 36 (13.33%) Jenkins
2 27 (10.00%) Talend Open Studio
3 9 (3.33%) Visual Studio
4 8 (2.96%) Team Foundation Server
5 7 (2.59%) ERwin
6 5 (1.85%) NUnit
6 5 (1.85%) SpecFlow
6 5 (1.85%) Visual Studio Tools for Office
7 4 (1.48%) SQL Server Management Studio (SSMS)
7 4 (1.48%) Toad
8 3 (1.11%) Git (software)
8 3 (1.11%) JUnit
9 2 (0.74%) Bitbucket
9 2 (0.74%) JIRA
9 2 (0.74%) PowerDesigner
10 1 (0.37%) tSQLt
General
1 84 (31.11%) Finance
2 22 (8.15%) Banking
3 7 (2.59%) Advertising
3 7 (2.59%) Investment Banking
4 5 (1.85%) Retail
5 3 (1.11%) Marketing
6 2 (0.74%) Back Office
6 2 (0.74%) Financial Institution
6 2 (0.74%) General Ledger
6 2 (0.74%) Pharmaceutical
7 1 (0.37%) French Language
7 1 (0.37%) Front Office
7 1 (0.37%) Legal
7 1 (0.37%) Manufacturing
Job Titles
1 145 (53.70%) Developer
2 59 (21.85%) Business Intelligence Developer
3 43 (15.93%) SQL Developer
4 34 (12.59%) Analyst
5 30 (11.11%) DBA
6 28 (10.37%) Architect
7 27 (10.00%) SSAS Developer
8 26 (9.63%) Data Warehouse Developer
9 22 (8.15%) Consultant
10 19 (7.04%) ETL Developer
10 19 (7.04%) SQL BI Developer
11 17 (6.30%) SSIS Developer
12 16 (5.93%) SSRS Developer
13 15 (5.56%) Business Intelligence Analyst
14 13 (4.81%) Business Intelligence Consultant
15 12 (4.44%) Senior Developer
15 12 (4.44%) SQL DBA
16 11 (4.07%) Data Architect
16 11 (4.07%) Talend Developer
17 9 (3.33%) OBIEE Developer
Libraries, Frameworks & Software Standards
1 70 (25.93%) MDX
2 13 (4.81%) .NET
3 10 (3.70%) ASP.NET
4 8 (2.96%) Web Services
5 6 (2.22%) XML
6 5 (1.85%) WCF
7 4 (1.48%) ASP.NET MVC
7 4 (1.48%) HTML
7 4 (1.48%) HTML5
7 4 (1.48%) REST
8 3 (1.11%) Hibernate
8 3 (1.11%) J2EE
9 2 (0.74%) Apache Camel
9 2 (0.74%) JSON
9 2 (0.74%) Kafka
10 1 (0.37%) Leaflet
10 1 (0.37%) ODBC
10 1 (0.37%) Oracle GoldenGate
10 1 (0.37%) SAP Basis
10 1 (0.37%) SOAP
Miscellaneous
1 36 (13.33%) Analytical Skills
2 14 (5.19%) Data Integration
2 14 (5.19%) Visualisation
3 13 (4.81%) Management Information System
4 11 (4.07%) Credit Risk
4 11 (4.07%) Replication
5 10 (3.70%) Digital Media
6 8 (2.96%) NHS
7 6 (2.22%) Clustering
8 5 (1.85%) Computer Science
8 5 (1.85%) Data Centre
8 5 (1.85%) Data Structures
9 4 (1.48%) Client/Server
9 4 (1.48%) Foreign Exchange (FX)
10 3 (1.11%) Algorithms
10 3 (1.11%) iPad
10 3 (1.11%) Statistics
11 2 (0.74%) Data Protection Act
11 2 (0.74%) Market Risk
11 2 (0.74%) Virtual Team
Operating Systems
1 42 (15.56%) Linux
2 12 (4.44%) Windows
3 11 (4.07%) Unix
4 3 (1.11%) HPUX
4 3 (1.11%) Red Hat Enterprise Linux
5 2 (0.74%) Windows Server
5 2 (0.74%) Windows Server 2008
5 2 (0.74%) Windows Server 2012
6 1 (0.37%) AIX
6 1 (0.37%) Solaris
6 1 (0.37%) VMS
Processes & Methodologies
1 173 (64.07%) Business Intelligence
2 148 (54.81%) ETL
3 67 (24.81%) Kimball Methodology
4 62 (22.96%) Analytics
5 58 (21.48%) Agile Software Development
6 57 (21.11%) Dimensional Modelling
7 46 (17.04%) Data Modelling
8 41 (15.19%) Performance Tuning
9 39 (14.44%) Continuous Integration
10 35 (12.96%) E-Commerce
11 22 (8.15%) CRM
12 18 (6.67%) Scrum
13 16 (5.93%) ETL Development
13 16 (5.93%) ITIL
14 14 (5.19%) SDLC
15 13 (4.81%) Data Management
15 13 (4.81%) Migration
16 11 (4.07%) Data Analysis
16 11 (4.07%) ERP
16 11 (4.07%) Stakeholder Management
Programming Languages
1 170 (62.96%) SQL
2 47 (17.41%) T-SQL
3 44 (16.30%) Java
4 14 (5.19%) C#
5 13 (4.81%) PL/SQL
6 9 (3.33%) JavaScript
7 8 (2.96%) PHP
7 8 (2.96%) Python
8 6 (2.22%) PowerShell
8 6 (2.22%) VBA
9 5 (1.85%) MATLAB
9 5 (1.85%) VB.NET
10 4 (1.48%) C
10 4 (1.48%) Perl
10 4 (1.48%) Shell Script
11 3 (1.11%) HiveQL
12 2 (0.74%) Data Analysis Expressions (DAX)
12 2 (0.74%) R
13 1 (0.37%) Bash Shell
13 1 (0.37%) Scala
Qualifications
1 15 (5.56%) Degree
2 5 (1.85%) Security Cleared
3 4 (1.48%) HNC
3 4 (1.48%) HND
4 1 (0.37%) BC Cleared
4 1 (0.37%) BPSS Clearance
4 1 (0.37%) ITIL Certification
4 1 (0.37%) MBA
4 1 (0.37%) MCP
4 1 (0.37%) MCSA
4 1 (0.37%) MCSE
4 1 (0.37%) Microsoft Certification
4 1 (0.37%) OCP
4 1 (0.37%) Oracle Certification
Quality Assurance & Compliance
1 21 (7.78%) Data Quality
2 4 (1.48%) Disclosure Scotland
2 4 (1.48%) SLA
3 3 (1.11%) QA
4 1 (0.37%) PCI DSS
System Software
1 3 (1.11%) HDFS
2 2 (0.74%) Docker
2 2 (0.74%) Oracle RAC
3 1 (0.37%) Active Directory
3 1 (0.37%) Hyper-V
3 1 (0.37%) KVM
3 1 (0.37%) Microsoft Virtual Server
3 1 (0.37%) NFS
3 1 (0.37%) SRDF
3 1 (0.37%) Virtual Machines
3 1 (0.37%) Virtual Servers
3 1 (0.37%) VMware Infrastructure
3 1 (0.37%) Xen
Systems Management
1 4 (1.48%) Oracle RMAN
2 2 (0.74%) Data Guard
3 1 (0.37%) HP Quality Center
3 1 (0.37%) Microsoft Clustering
3 1 (0.37%) Nagios
3 1 (0.37%) Puppet
Vendors
1 85 (31.48%) Microsoft
2 57 (21.11%) Oracle
3 31 (11.48%) Vertica
4 27 (10.00%) Talend
5 19 (7.04%) Tableau
6 17 (6.30%) Cognos
6 17 (6.30%) Informatica
7 16 (5.93%) Teradata
8 15 (5.56%) MicroStrategy
9 13 (4.81%) SAP
10 8 (2.96%) Hyperion
10 8 (2.96%) Sybase
11 4 (1.48%) Ab Initio
11 4 (1.48%) Actian
11 4 (1.48%) IBM
11 4 (1.48%) ParAccel
12 3 (1.11%) Red Hat
13 2 (0.74%) EMC
13 2 (0.74%) Sitecore
13 2 (0.74%) VMware
Durham, County Durham
Spring Technology
Rate: £350.00 - £400.00 per day
Posted: 4 hours ago
Durham, County Durham
Experis Ltd
Rate: £350.00 - £400 per day
Posted: 3 hours ago
Edinburgh
Nigel Frank International
Posted: Yesterday
Fleet, Hampshire
Icore Tech
Rate: £350 - £450 per day
Posted: 3 days ago
Manchester
Robert Walters UK
Rate: £350 - £400 per day
Posted: 7 days ago
Bristol, Avon
Hargreaves Lansdown
Rate: Competitive
Posted: 23 days ago
Hertfordshire
Partnerships in Care
Rate: £40,000 + Excellent benefits
Posted: 27 days ago
Borehamwood, Hertfordshire
Partnerships in Care
Rate: £28,000 to £30,000 + Excellent benefits
Posted: 27 days ago