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 31 August 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
31 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 512 434 459
Rank change year-on-year
-78 +25
Contract jobs citing OLAP 134 234 180
As % of all contract IT jobs located in the UK 0.25% 0.40% 0.32%
As % of the Database & Business Intelligence category 1.09% 1.71% 1.46%
Number of daily rates quoted 94 173 107
Median daily rate £448 £415 £400
Median daily rate % change year-on-year
+7.83% +3.75%
90% offered a daily rate of more than £313 £325 £236
10% offered a daily rate of more than £575 £546 £575
UK excluding London median daily rate £400 £400 £325
% change year-on-year
- +23.07%
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
12242 13686 12319
As % of all contract IT jobs located in the UK 22.66% 23.36% 22.13%
Number of daily rates quoted 8082 8970 7599
Median daily rate £425 £400 £400
Median daily rate % change year-on-year
+6.25% -
90% offered a daily rate of more than £300 £288 £263
10% offered a daily rate of more than £575 £550 £550
UK excluding London median daily rate £375 £375 £350
% change year-on-year
- +7.14%
Number of hourly rates quoted 209 210 206
Median hourly rate £28.50 £30.00 £28.00
Median hourly rate % change year-on-year
-5.00% +7.14%
90% offered a hourly rate of more than £12.00 £14.00 £13.00
10% offered a hourly rate of more than £48.00 £53.27 £55.00
UK excluding London median hourly rate £28.50 £33.00 £28.50
% change year-on-year
-13.63% +15.78%

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 31 August 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 31 August 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 133 £450 +9.09% 21
London -73 52 £475 +11.76% 11
Yorkshire +10 18 £450 +5.88% 2
North West +3 17 £500 +14.28% 1
Cheshire +18 15 £525 +40.00%
West Yorkshire +6 14 £432 -2.76% 1
South East -9 13 £315 -20.25% 3
South West +27 12 £400 +23.07% 1
East of England +10 9 £375 -3.84% 1
West Midlands -21 9 £325 -13.33% 1
Leeds +5 7 £375 +8.94%
City of London -6 7 £519 +15.27%
Bristol 0 6 £300 -4.00%
Macclesfield +6 5 £500 -
Slough 0 5 £313 -6.01%
Berkshire -7 5 £313 -6.01%
Cambridgeshire +23 4 £305 -19.73%
Bradford +10 4 £538 +24.63% 1
Chester +3 4 £600 +11.62%
Coventry -13 4 £325 -10.34%
Cambridge - 4 £305 -
West Sussex - 4 £315 -
Gloucestershire - 4 £425 -
Hertfordshire +9 3 £410 +17.14% 1
South Yorkshire -5 3 £600 +60.00%
Birmingham -9 3 £413 -25.00%
Sheffield -9 3 £600 +60.00%
Crawley - 3 £315 -
Luton -6 2 £575 -2.12%
East Midlands -7 2 £400 -11.11% 1

OLAP
Top 30 Related IT Skills

For the 6 months to 31 August 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 (68.38%) Business Intelligence
2 165 (65.22%) SQL
3 143 (56.52%) SQL Server
4 134 (52.96%) ETL
4 134 (52.96%) SQL Server Analysis Services
5 121 (47.83%) Data Warehouse
6 104 (41.11%) SQL Server Integration Services
7 101 (39.92%) OLAP Cube
8 93 (36.76%) Microsoft
9 88 (34.78%) SQL Server Reporting Services
10 80 (31.62%) Finance
11 65 (25.69%) Agile Software Development
12 62 (24.51%) Kimball Methodology
13 60 (23.72%) Dimensional Modelling
14 58 (22.92%) Analytics
15 56 (22.13%) MDX
16 48 (18.97%) T-SQL
17 45 (17.79%) Oracle
18 44 (17.39%) Data Modelling
18 44 (17.39%) Oracle OLAP
19 43 (17.00%) Big Data
20 42 (16.60%) Java
21 40 (15.81%) SQL Server 2012
22 38 (15.02%) SQL Server 2008
23 37 (14.62%) Continuous Integration
24 36 (14.23%) Linux
24 36 (14.23%) OLTP
25 35 (13.83%) E-Commerce
25 35 (13.83%) Jenkins
25 35 (13.83%) 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.91%) SAS
2 11 (4.35%) SharePoint
3 7 (2.77%) IIS
4 5 (1.98%) Apache Spark
5 3 (1.19%) Apache
5 3 (1.19%) Apache Pig
6 2 (0.79%) Confluence
6 2 (0.79%) Oracle Application Server
7 1 (0.40%) BizTalk Server
7 1 (0.40%) CMS
7 1 (0.40%) Commerce Server
7 1 (0.40%) Facebook Platform
7 1 (0.40%) Oracle Coherence
7 1 (0.40%) Oracle HTTP Server
7 1 (0.40%) SharePoint 2010
7 1 (0.40%) SharePoint 2013
7 1 (0.40%) Sitecore CMS
7 1 (0.40%) Tomcat
7 1 (0.40%) WebSphere
Applications
1 33 (13.04%) MS Excel
2 9 (3.56%) MS Office
3 6 (2.37%) MS Visio
4 5 (1.98%) MS PowerPoint
5 2 (0.79%) SPSS
6 1 (0.40%) MS Project
6 1 (0.40%) Spreadsheet
Business Applications
1 9 (3.56%) Dynamics CRM
2 6 (2.37%) Cognos Business Intelligence
3 5 (1.98%) Cognos TM1
4 1 (0.40%) Cognos Planning
4 1 (0.40%) Dynamics AX
4 1 (0.40%) Global One
4 1 (0.40%) Oracle EBS
4 1 (0.40%) Radian6
4 1 (0.40%) SAP CRM
4 1 (0.40%) SAP ERP
4 1 (0.40%) SAP Oil and Gas
4 1 (0.40%) SAP R/3
4 1 (0.40%) SAP SCM
4 1 (0.40%) SystmOne
4 1 (0.40%) WebTrends
Cloud Services
1 24 (9.49%) Microsoft Azure
2 11 (4.35%) Amazon AWS
2 11 (4.35%) IaaS
2 11 (4.35%) PaaS
3 4 (1.58%) SaaS
4 1 (0.40%) AdWords
4 1 (0.40%) Azure Machine Learning
4 1 (0.40%) Cloud Computing
4 1 (0.40%) Data Lake Analytics
4 1 (0.40%) Google Analytics
4 1 (0.40%) Office 365
Communications & Networking
1 16 (6.32%) Network Security
2 6 (2.37%) Extranet
2 6 (2.37%) Intranet
3 4 (1.58%) SAN
4 2 (0.79%) Internet
5 1 (0.40%) FCoE
5 1 (0.40%) Fibre Channel
5 1 (0.40%) HTTP
5 1 (0.40%) iSCSI
5 1 (0.40%) LAN
5 1 (0.40%) Multicast
5 1 (0.40%) NAS
5 1 (0.40%) WAN
Database & Business Intelligence
1 143 (56.52%) SQL Server
2 134 (52.96%) SQL Server Analysis Services
3 121 (47.83%) Data Warehouse
4 104 (41.11%) SQL Server Integration Services
5 101 (39.92%) OLAP Cube
6 88 (34.78%) SQL Server Reporting Services
7 44 (17.39%) Oracle OLAP
8 43 (17.00%) Big Data
9 40 (15.81%) SQL Server 2012
10 38 (15.02%) SQL Server 2008
11 36 (14.23%) OLTP
12 29 (11.46%) Microsoft Analysis Services
13 28 (11.07%) SQL Server 2014
14 26 (10.28%) BusinessObjects
15 20 (7.91%) Relational Database
16 17 (6.72%) Data Mart
17 16 (6.32%) Power BI
17 16 (6.32%) SQL Server 2016
18 15 (5.93%) Star Schema
19 13 (5.14%) SQL Server 2005
Development Applications
1 35 (13.83%) Jenkins
2 28 (11.07%) Talend Open Studio
3 9 (3.56%) Team Foundation Server
3 9 (3.56%) Visual Studio
4 8 (3.16%) ERwin
5 6 (2.37%) SQL Server Management Studio (SSMS)
6 5 (1.98%) NUnit
6 5 (1.98%) SpecFlow
7 4 (1.58%) Toad
7 4 (1.58%) Visual Studio Tools for Office
8 3 (1.19%) Git (software)
9 2 (0.79%) Bitbucket
9 2 (0.79%) JIRA
9 2 (0.79%) JUnit
9 2 (0.79%) PowerDesigner
10 1 (0.40%) tSQLt
General
1 80 (31.62%) Finance
2 26 (10.28%) Banking
3 8 (3.16%) Retail
4 7 (2.77%) Advertising
5 6 (2.37%) Investment Banking
6 3 (1.19%) Financial Institution
6 3 (1.19%) Marketing
7 2 (0.79%) Back Office
7 2 (0.79%) French Language
7 2 (0.79%) Front Office
7 2 (0.79%) Manufacturing
7 2 (0.79%) Pharmaceutical
7 2 (0.79%) Telecoms
8 1 (0.40%) Electronics
8 1 (0.40%) International Banking
8 1 (0.40%) Legal
8 1 (0.40%) Publishing
Job Titles
1 138 (54.55%) Developer
2 57 (22.53%) Business Intelligence Developer
3 46 (18.18%) SQL Developer
4 28 (11.07%) DBA
5 27 (10.67%) Analyst
6 24 (9.49%) Architect
6 24 (9.49%) Data Warehouse Developer
6 24 (9.49%) SSAS Developer
7 23 (9.09%) SQL BI Developer
8 18 (7.11%) Consultant
9 17 (6.72%) ETL Developer
10 16 (6.32%) SSRS Developer
11 15 (5.93%) SSIS Developer
12 12 (4.74%) Business Intelligence Analyst
12 12 (4.74%) SQL DBA
12 12 (4.74%) Talend Developer
13 10 (3.95%) Senior Developer
13 10 (3.95%) SQL Server Developer
13 10 (3.95%) Support Engineer
14 9 (3.56%) Data Architect
Libraries, Frameworks & Software Standards
1 56 (22.13%) MDX
2 13 (5.14%) .NET
3 11 (4.35%) ASP.NET
4 7 (2.77%) Web Services
5 5 (1.98%) XML
6 4 (1.58%) HTML
7 3 (1.19%) ASP.NET MVC
7 3 (1.19%) Hibernate
7 3 (1.19%) HTML5
7 3 (1.19%) J2EE
7 3 (1.19%) JSON
7 3 (1.19%) REST
7 3 (1.19%) WCF
8 2 (0.79%) Apache Camel
8 2 (0.79%) Kafka
8 2 (0.79%) Middleware
8 2 (0.79%) Oracle GoldenGate
8 2 (0.79%) Oracle Streams
9 1 (0.40%) RESTful
9 1 (0.40%) SAP PI
Miscellaneous
1 35 (13.83%) Analytical Skills
2 13 (5.14%) Data Integration
3 12 (4.74%) Visualisation
4 11 (4.35%) Digital Media
5 10 (3.95%) Credit Risk
5 10 (3.95%) Replication
6 9 (3.56%) Management Information System
7 6 (2.37%) Clustering
7 6 (2.37%) Computer Science
8 4 (1.58%) Data Structures
8 4 (1.58%) Statistics
9 3 (1.19%) Algorithms
9 3 (1.19%) Foreign Exchange (FX)
9 3 (1.19%) iPad
9 3 (1.19%) NHS
10 2 (0.79%) Data Protection Act
10 2 (0.79%) Enterprise Software
10 2 (0.79%) Market Risk
10 2 (0.79%) Virtual Team
11 1 (0.40%) Mobile App
Operating Systems
1 36 (14.23%) Linux
2 9 (3.56%) VMS
3 8 (3.16%) Unix
3 8 (3.16%) Windows
4 2 (0.79%) Windows Server
4 2 (0.79%) Windows Server 2008
4 2 (0.79%) Windows Server 2012
5 1 (0.40%) AIX
5 1 (0.40%) Solaris
Processes & Methodologies
1 173 (68.38%) Business Intelligence
2 134 (52.96%) ETL
3 65 (25.69%) Agile Software Development
4 62 (24.51%) Kimball Methodology
5 60 (23.72%) Dimensional Modelling
6 58 (22.92%) Analytics
7 44 (17.39%) Data Modelling
8 37 (14.62%) Continuous Integration
9 35 (13.83%) E-Commerce
10 33 (13.04%) Performance Tuning
11 22 (8.70%) CRM
12 19 (7.51%) Scrum
13 15 (5.93%) Data Management
14 14 (5.53%) Mentoring
14 14 (5.53%) SDLC
15 12 (4.74%) ETL Development
15 12 (4.74%) Migration
16 11 (4.35%) ERP
16 11 (4.35%) ITIL
16 11 (4.35%) SOA
Programming Languages
1 165 (65.22%) SQL
2 48 (18.97%) T-SQL
3 42 (16.60%) Java
4 13 (5.14%) C#
5 11 (4.35%) PL/SQL
6 10 (3.95%) VBA
7 9 (3.56%) JavaScript
7 9 (3.56%) PowerShell
8 7 (2.77%) PHP
9 5 (1.98%) MATLAB
9 5 (1.98%) VB.NET
10 4 (1.58%) Python
11 3 (1.19%) HiveQL
11 3 (1.19%) R
12 2 (0.79%) Data Analysis Expressions (DAX)
12 2 (0.79%) VB
13 1 (0.40%) Bash Shell
13 1 (0.40%) Scala
13 1 (0.40%) Shell Script
Qualifications
1 12 (4.74%) Degree
2 4 (1.58%) HNC
2 4 (1.58%) HND
3 2 (0.79%) Security Cleared
4 1 (0.40%) MBA
4 1 (0.40%) MCP
4 1 (0.40%) MCSA
4 1 (0.40%) MCSE
4 1 (0.40%) Microsoft Certification
Quality Assurance & Compliance
1 18 (7.11%) Data Quality
2 4 (1.58%) QA
3 3 (1.19%) SLA
4 1 (0.40%) PCI DSS
4 1 (0.40%) Solvency II
System Software
1 9 (3.56%) Virtual Servers
2 8 (3.16%) Microsoft Virtual Server
3 3 (1.19%) HDFS
3 3 (1.19%) Oracle RAC
4 2 (0.79%) Docker
5 1 (0.40%) Active Directory
5 1 (0.40%) Hyper-V
5 1 (0.40%) KVM
5 1 (0.40%) NFS
5 1 (0.40%) SRDF
5 1 (0.40%) Virtual Machines
5 1 (0.40%) VMware Infrastructure
5 1 (0.40%) Xen
Systems Management
1 2 (0.79%) Data Guard
1 2 (0.79%) Oracle RMAN
2 1 (0.40%) HP Quality Center
2 1 (0.40%) Microsoft Clustering
2 1 (0.40%) Nagios
2 1 (0.40%) Puppet
Vendors
1 93 (36.76%) Microsoft
2 45 (17.79%) Oracle
3 31 (12.25%) Vertica
4 28 (11.07%) Talend
5 20 (7.91%) Tableau
6 16 (6.32%) Cognos
7 14 (5.53%) Teradata
8 13 (5.14%) Informatica
9 11 (4.35%) MicroStrategy
10 8 (3.16%) Hyperion
10 8 (3.16%) SAP
11 4 (1.58%) IBM
11 4 (1.58%) Sybase
12 3 (1.19%) EMC
13 2 (0.79%) Netezza
13 2 (0.79%) Sitecore
13 2 (0.79%) VMware
14 1 (0.40%) Facebook
14 1 (0.40%) hybris
14 1 (0.40%) Splunk
Edinburgh, Midlothian
Cathcart Associates Ltd
Rate: £350 - £400 per day
Posted: Yesterday
UK
Oscar
Rate: £300 - £600 per day
Posted: 6 days ago
London
Rullion IT Plus
Posted: 6 days ago
Holborn, London, UK
Reed Business Information
Rate: £350 - £450 per day
Posted: 16 days ago