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 24 July 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
24 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 489 416 426
Rank change year-on-year
-73 +10
Contract jobs citing OLAP 154 239 180
As % of all contract IT jobs located in the UK 0.28% 0.42% 0.34%
As % of the Database & Business Intelligence category 1.28% 1.80% 1.54%
Number of daily rates quoted 107 168 120
Median daily rate £413 £425 £425
Median daily rate % change year-on-year
-2.94% -
90% offered a daily rate of more than £313 £325 £275
10% offered a daily rate of more than £575 £550 £575
UK excluding London median daily rate £409 £413 £331
% change year-on-year
-0.84% +24.52%
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
12041 13256 11691
As % of all contract IT jobs located in the UK 22.25% 23.28% 22.00%
Number of daily rates quoted 8017 8622 7219
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 £575 £550 £550
UK excluding London median daily rate £375 £355 £350
% change year-on-year
+5.63% +1.42%
Number of hourly rates quoted 210 187 196
Median hourly rate £30.50 £27.78 £27.50
Median hourly rate % change year-on-year
+9.79% +1.01%
90% offered a hourly rate of more than £12.00 £16.80 £13.00
10% offered a hourly rate of more than £49.00 £52.17 £53.00
UK excluding London median hourly rate £31.00 £28.50 £25.00
% change year-on-year
+8.77% +14.00%

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 24 July 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 24 July 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 -79 147 £418 -1.70% 45
London -42 65 £458 +4.57% 15
Cheshire +18 21 £413 -12.00% 3
North West -5 21 £413 -8.33% 10
City of London +12 15 £475 +7.04% 6
Chester +7 15 £413 -24.13%
Yorkshire -5 13 £544 +16.93% 1
South East -19 13 £345 -11.82% 4
East of England +13 11 £375 -9.63%
South West +3 9 £258 -20.76% 8
West Yorkshire -8 9 £538 +13.15%
West Midlands -24 8 £356 -24.00% 2
Scotland +6 6 £313 -37.50% 2
Glasgow - 6 £313 - 1
Slough +4 5 £313 -6.01% 1
Bristol +2 5 - - 1
Berkshire -5 5 £313 -6.01% 1
Hertfordshire - 5 £410 -
Cambridgeshire +19 4 £305 -19.73%
Macclesfield +6 4 £513 -
Bradford +4 4 £538 +26.47%
East Midlands -2 4 £350 -22.22% 4
Coventry - 4 - -
Cambridge - 4 £305 -
South Yorkshire -1 3 £600 +60.00%
Sheffield -13 3 £600 +60.00%
Canary Wharf - 3 £475 -
West Sussex - 3 £315 -
Somerset +15 2 £328 +0.76%
Buckinghamshire +10 2 £375 -4.76%

OLAP
Top 30 Related IT Skills

For the 6 months to 24 July 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 177 (67.56%) Business Intelligence
2 161 (61.45%) SQL
3 145 (55.34%) SQL Server
4 131 (50.00%) ETL
5 130 (49.62%) SQL Server Analysis Services
6 117 (44.66%) Data Warehouse
7 106 (40.46%) Microsoft
7 106 (40.46%) SQL Server Integration Services
8 98 (37.40%) OLAP Cube
9 91 (34.73%) SQL Server Reporting Services
10 74 (28.24%) Agile Software Development
11 73 (27.86%) Finance
12 62 (23.66%) Kimball Methodology
13 59 (22.52%) Dimensional Modelling
14 56 (21.37%) MDX
15 55 (20.99%) Analytics
16 47 (17.94%) T-SQL
17 46 (17.56%) Java
17 46 (17.56%) SQL Server 2008
18 44 (16.79%) Oracle
19 41 (15.65%) Data Modelling
19 41 (15.65%) SQL Server 2012
20 40 (15.27%) Analytical Skills
21 39 (14.89%) Big Data
21 39 (14.89%) Oracle OLAP
22 37 (14.12%) MS Excel
22 37 (14.12%) OLTP
23 36 (13.74%) Continuous Integration
24 33 (12.60%) Performance Tuning
25 32 (12.21%) Linux

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 13 (4.96%) SAS
2 12 (4.58%) SharePoint
3 10 (3.82%) IIS
4 5 (1.91%) Apache Spark
5 3 (1.15%) Apache
5 3 (1.15%) Apache Pig
5 3 (1.15%) Oracle Coherence
6 2 (0.76%) BizTalk Server
6 2 (0.76%) Confluence
6 2 (0.76%) Oracle Application Server
6 2 (0.76%) SharePoint 2010
7 1 (0.38%) CMS
7 1 (0.38%) Commerce Server
7 1 (0.38%) Facebook Platform
7 1 (0.38%) Oracle HTTP Server
7 1 (0.38%) SharePoint 2013
7 1 (0.38%) Sitecore CMS
7 1 (0.38%) Tomcat
7 1 (0.38%) WebLogic
7 1 (0.38%) WebSphere
Applications
1 37 (14.12%) MS Excel
2 8 (3.05%) MS Office
3 4 (1.53%) MS PowerPoint
4 3 (1.15%) MS Visio
5 2 (0.76%) Spreadsheet
5 2 (0.76%) SPSS
6 1 (0.38%) MS Project
Business Applications
1 8 (3.05%) Dynamics CRM
2 6 (2.29%) Cognos Business Intelligence
3 5 (1.91%) Global One
4 4 (1.53%) Cognos TM1
5 2 (0.76%) 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 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%) WebTrends
Cloud Services
1 22 (8.40%) Microsoft Azure
2 11 (4.20%) IaaS
2 11 (4.20%) PaaS
3 9 (3.44%) Amazon AWS
4 3 (1.15%) SaaS
5 1 (0.38%) AdWords
5 1 (0.38%) Azure Machine Learning
5 1 (0.38%) Cloud Computing
5 1 (0.38%) Data Lake Analytics
5 1 (0.38%) Google Analytics
Communications & Networking
1 16 (6.11%) Network Security
2 7 (2.67%) SAN
3 6 (2.29%) Extranet
3 6 (2.29%) Intranet
4 2 (0.76%) 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.34%) SQL Server
2 130 (49.62%) SQL Server Analysis Services
3 117 (44.66%) Data Warehouse
4 106 (40.46%) SQL Server Integration Services
5 98 (37.40%) OLAP Cube
6 91 (34.73%) SQL Server Reporting Services
7 46 (17.56%) SQL Server 2008
8 41 (15.65%) SQL Server 2012
9 39 (14.89%) Big Data
9 39 (14.89%) Oracle OLAP
10 37 (14.12%) OLTP
11 27 (10.31%) Microsoft Analysis Services
12 26 (9.92%) SQL Server 2014
13 25 (9.54%) BusinessObjects
14 21 (8.02%) Relational Database
15 19 (7.25%) Power BI
16 15 (5.73%) Data Mart
17 14 (5.34%) Oracle BI EE
17 14 (5.34%) SQL Server 2005
17 14 (5.34%) SQL Server 2016
Development Applications
1 29 (11.07%) Jenkins
2 24 (9.16%) Talend Open Studio
3 9 (3.44%) Visual Studio
4 8 (3.05%) Team Foundation Server
5 7 (2.67%) ERwin
6 5 (1.91%) NUnit
6 5 (1.91%) SpecFlow
6 5 (1.91%) SQL Server Management Studio (SSMS)
7 4 (1.53%) Toad
8 3 (1.15%) Git (software)
8 3 (1.15%) JIRA
8 3 (1.15%) JUnit
9 2 (0.76%) Bitbucket
10 1 (0.38%) tSQLt
10 1 (0.38%) Visual Studio Tools for Office
General
1 73 (27.86%) Finance
2 29 (11.07%) Banking
3 10 (3.82%) Investment Banking
4 8 (3.05%) Advertising
5 6 (2.29%) Front Office
5 6 (2.29%) Retail
6 4 (1.53%) Financial Institution
6 4 (1.53%) Marketing
7 3 (1.15%) Back Office
8 2 (0.76%) French Language
8 2 (0.76%) Pharmaceutical
8 2 (0.76%) Publishing
8 2 (0.76%) Telecoms
9 1 (0.38%) Electronics
9 1 (0.38%) International Banking
9 1 (0.38%) Legal
9 1 (0.38%) Manufacturing
Job Titles
1 157 (59.92%) Developer
2 68 (25.95%) Business Intelligence Developer
3 55 (20.99%) SQL Developer
4 30 (11.45%) Analyst
5 29 (11.07%) SQL BI Developer
6 27 (10.31%) SSAS Developer
7 26 (9.92%) DBA
8 25 (9.54%) Architect
9 23 (8.78%) Data Warehouse Developer
9 23 (8.78%) SSIS Developer
9 23 (8.78%) SSRS Developer
10 16 (6.11%) Business Developer
11 14 (5.34%) Business Intelligence Analyst
11 14 (5.34%) ETL Developer
11 14 (5.34%) Senior Developer
12 13 (4.96%) SQL DBA
13 12 (4.58%) Consultant
13 12 (4.58%) Oracle Developer
13 12 (4.58%) Talend Developer
14 11 (4.20%) Java Developer
Libraries, Frameworks & Software Standards
1 56 (21.37%) MDX
2 14 (5.34%) .NET
3 8 (3.05%) ASP.NET
3 8 (3.05%) REST
3 8 (3.05%) Web Services
4 6 (2.29%) HTML
4 6 (2.29%) XML
5 5 (1.91%) HTML5
5 5 (1.91%) Middleware
6 4 (1.53%) Hibernate
6 4 (1.53%) Java Concurrency
7 3 (1.15%) J2EE
7 3 (1.15%) JSON
8 2 (0.76%) AngularJS
8 2 (0.76%) Apache Camel
8 2 (0.76%) Kafka
8 2 (0.76%) Oracle GoldenGate
8 2 (0.76%) Oracle Streams
8 2 (0.76%) XSD
8 2 (0.76%) XSLT
Miscellaneous
1 40 (15.27%) Analytical Skills
2 16 (6.11%) Visualisation
3 13 (4.96%) Data Integration
4 12 (4.58%) Replication
5 11 (4.20%) Credit Risk
5 11 (4.20%) Digital Media
6 10 (3.82%) Data Structures
7 9 (3.44%) Management Information System
8 6 (2.29%) Clustering
8 6 (2.29%) Computer Science
9 5 (1.91%) Foreign Exchange (FX)
10 4 (1.53%) Algorithms
10 4 (1.53%) Client/Server
10 4 (1.53%) NHS
10 4 (1.53%) Statistics
11 3 (1.15%) Enterprise Software
11 3 (1.15%) iPad
11 3 (1.15%) Market Risk
12 2 (0.76%) Data Protection Act
12 2 (0.76%) Fixed Income
Operating Systems
1 32 (12.21%) Linux
2 9 (3.44%) VMS
3 6 (2.29%) Unix
3 6 (2.29%) Windows
4 2 (0.76%) Windows Server
4 2 (0.76%) Windows Server 2008
4 2 (0.76%) Windows Server 2012
5 1 (0.38%) AIX
5 1 (0.38%) Solaris
Processes & Methodologies
1 177 (67.56%) Business Intelligence
2 131 (50.00%) ETL
3 74 (28.24%) Agile Software Development
4 62 (23.66%) Kimball Methodology
5 59 (22.52%) Dimensional Modelling
6 55 (20.99%) Analytics
7 41 (15.65%) Data Modelling
8 36 (13.74%) Continuous Integration
9 33 (12.60%) Performance Tuning
10 29 (11.07%) E-Commerce
11 20 (7.63%) CRM
12 19 (7.25%) Scrum
13 17 (6.49%) Data Management
13 17 (6.49%) SDLC
14 16 (6.11%) Migration
15 14 (5.34%) Mentoring
16 13 (4.96%) Stakeholder Management
17 12 (4.58%) ERP
17 12 (4.58%) ITIL
17 12 (4.58%) Low Latency
Programming Languages
1 161 (61.45%) SQL
2 47 (17.94%) T-SQL
3 46 (17.56%) Java
4 16 (6.11%) C#
5 9 (3.44%) JavaScript
6 8 (3.05%) VBA
7 7 (2.67%) PHP
7 7 (2.67%) PL/SQL
7 7 (2.67%) PowerShell
8 5 (1.91%) MATLAB
8 5 (1.91%) VB.NET
9 4 (1.53%) Data Analysis Expressions (DAX)
10 3 (1.15%) HiveQL
10 3 (1.15%) Python
10 3 (1.15%) R
10 3 (1.15%) Shell Script
11 1 (0.38%) Scala
11 1 (0.38%) VB
Qualifications
1 6 (2.29%) Degree
2 2 (0.76%) DV Cleared
2 2 (0.76%) Microsoft Certification
2 2 (0.76%) Security Cleared
3 1 (0.38%) MBA
3 1 (0.38%) MCDBA
3 1 (0.38%) MCP
3 1 (0.38%) MCSA
3 1 (0.38%) MCSE
3 1 (0.38%) MCTS
3 1 (0.38%) Microsoft Certified Architect
Quality Assurance & Compliance
1 22 (8.40%) 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.44%) Virtual Servers
2 8 (3.05%) Microsoft Virtual Server
3 3 (1.15%) HDFS
3 3 (1.15%) Oracle RAC
4 2 (0.76%) Docker
5 1 (0.38%) Active Directory
5 1 (0.38%) Hyper-V
5 1 (0.38%) KVM
5 1 (0.38%) NFS
5 1 (0.38%) SRDF
5 1 (0.38%) Virtual Machines
5 1 (0.38%) VMware Infrastructure
5 1 (0.38%) Xen
Systems Management
1 2 (0.76%) Data Guard
1 2 (0.76%) Oracle RMAN
2 1 (0.38%) HP Quality Center
2 1 (0.38%) Microsoft Clustering
2 1 (0.38%) Nagios
2 1 (0.38%) Puppet
Vendors
1 106 (40.46%) Microsoft
2 44 (16.79%) Oracle
3 25 (9.54%) Vertica
4 24 (9.16%) Tableau
4 24 (9.16%) Talend
5 16 (6.11%) Cognos
5 16 (6.11%) Informatica
6 11 (4.20%) SAP
7 9 (3.44%) Teradata
8 8 (3.05%) MicroStrategy
9 6 (2.29%) Hyperion
10 5 (1.91%) IBM
11 4 (1.53%) Sybase
12 3 (1.15%) EMC
12 3 (1.15%) Red Hat
13 2 (0.76%) Cadence
13 2 (0.76%) Sitecore
13 2 (0.76%) VMware
14 1 (0.38%) hybris
14 1 (0.38%) Twitter
London
McGregor Boyall
Rate: £450 per day
Posted: 2 days ago
Cheshire
Vivid Resourcing
Posted: 4 days ago
Gloucestershire
TEKsystems
Rate: £349 - £451 per day
Posted: Yesterday
Gloucester, Gloucestershire
ANSON MCCADE
Rate: £450 per day
Posted: 2 days ago
Bristol Area
ANSON MCCADE
Rate: £350 - £450 Per Day
Posted: 2 days ago
Swindon, Wiltshire
ANSON MCCADE
Rate: £350 - £450 Per Day
Posted: 2 days ago
Worcester, Worcestershire
ANSON MCCADE
Rate: £350 - £450 Per Day
Posted: 2 days ago
Cheltenham, Gloucestershire
ANSON MCCADE
Rate: £350 - £450 Per Day
Posted: 2 days ago
Gloucester, Gloucestershire
ANSON MCCADE
Rate: £350 - £450 Per Day
Posted: 2 days ago
London
Opilio Recruitment
Rate: From £50,000 to £60,000 per annum
Posted: 3 days ago