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 February 2017 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 Feb 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
UK
Rank 523 495 416
Rank change year-on-year
-28 -79
Contract jobs citing OLAP 79 132 218
As % of all contract IT jobs located in the UK 0.18% 0.25% 0.42%
As % of the Database & Business Intelligence category 0.79% 1.14% 1.87%
Number of daily rates quoted 60 83 156
Median daily rate £425 £425 £425
90% offered a daily rate of more than £336 £303 £325
10% offered a daily rate of more than £550 £582 £500
UK excluding London median daily rate £425 £400 £425
% change year-on-year
+6.25% -5.88%
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
10011 11624 11657
As % of all contract IT jobs located in the UK 22.36% 22.35% 22.22%
Number of daily rates quoted 6802 7829 7509
Median daily rate £439 £425 £400
Median daily rate % change year-on-year
+3.23% +6.25%
90% offered a daily rate of more than £300 £300 £275
10% offered a daily rate of more than £600 £575 £550
UK excluding London median daily rate £400 £375 £375
% change year-on-year
+6.66% -
Number of hourly rates quoted 131 199 169
Median hourly rate £35.00 £35.00 £32.10
Median hourly rate % change year-on-year
- +9.03%
90% offered a hourly rate of more than £12.00 £14.00 £15.75
10% offered a hourly rate of more than £45.20 £60.62 £50.00
UK excluding London median hourly rate £35.00 £32.50 £32.50
% change year-on-year
+7.69% -

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 February 2017.

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 February 2017. 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 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 -10 76 £425 - 29
London +4 42 £450 - 8
South East +16 9 £382 -15.11% 3
South West - 8 £425 - 1
Yorkshire +18 5 £481 +22.22% 2
City of London +5 5 £500 -4.76% 2
North West +15 4 £363 -9.37% 6
West Yorkshire +15 4 £500 +26.98% 2
West Midlands -4 4 £325 -16.66% 3
Wiltshire - 4 £425 -
Swindon - 4 £425 -
Bradford +9 3 - -
Berkshire +7 3 £382 -7.39% 1
Surrey - 3 - - 2
South Wales - 3 £425 -
Cardiff - 3 £425 -
Wales - 3 £425 -
Reading +10 2 £374 -9.45% 1
Manchester +3 2 £456 +17.74% 3
Merseyside +1 2 £363 -23.68%
East of England -1 2 £380 -5.00% 6
West Sussex -7 2 £525 -
Dorset - 2 £425 -
Coventry - 2 £363 -
Leeds +4 1 £500 +25.00% 2
Hampshire -1 1 £355 -22.89%
East Midlands -2 1 £475 +11.76%
Liverpool -7 1 £375 -21.05%
Suffolk -9 1 £350 -12.50%
Staffordshire - 1 £325 - 1

OLAP
Top 30 Related IT Skills

For the 6 months to 25 February 2017, 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 130 (60.47%) SQL
2 126 (58.60%) SQL Server
3 121 (56.28%) Business Intelligence
4 115 (53.49%) Data Warehouse
5 107 (49.77%) ETL
6 100 (46.51%) SQL Server Integration Services
7 97 (45.12%) SQL Server Analysis Services
8 81 (37.67%) SQL Server Reporting Services
9 75 (34.88%) Finance
10 63 (29.30%) Microsoft
11 62 (28.84%) OLAP Cube
12 55 (25.58%) MDX
13 52 (24.19%) Oracle OLAP
13 52 (24.19%) Oracle
14 50 (23.26%) T-SQL
15 45 (20.93%) Analytics
16 44 (20.47%) Data Modelling
17 37 (17.21%) MS Excel
18 34 (15.81%) Agile Software Development
18 34 (15.81%) Kimball Methodology
18 34 (15.81%) SQL Server 2012
19 33 (15.35%) OLTP
20 30 (13.95%) Performance Tuning
20 30 (13.95%) QlikView
21 28 (13.02%) C#
22 27 (12.56%) Power BI
23 26 (12.09%) Analytical Skills
23 26 (12.09%) Data Quality
24 25 (11.63%) .NET
24 25 (11.63%) 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 18 (8.37%) SAS
2 9 (4.19%) SharePoint
3 5 (2.33%) Apache Spark
4 4 (1.86%) Apache Pig
5 3 (1.40%) CMS
5 3 (1.40%) Oracle SOA Suite
6 2 (0.93%) Apache Solr
6 2 (0.93%) Drupal
7 1 (0.47%) Alfresco
7 1 (0.47%) Apache
7 1 (0.47%) Elasticsearch
7 1 (0.47%) Magnolia
7 1 (0.47%) SharePoint 2010
7 1 (0.47%) SharePoint 2013
7 1 (0.47%) Tomcat
7 1 (0.47%) TPMS
7 1 (0.47%) WebSphere
Applications
1 37 (17.21%) MS Excel
2 7 (3.26%) MS Office
3 5 (2.33%) Spreadsheet
4 3 (1.40%) MS PowerPoint
4 3 (1.40%) SPSS
5 2 (0.93%) MS Project
6 1 (0.47%) MS Visio
Business Applications
1 5 (2.33%) Oracle Financials
2 4 (1.86%) Dynamics AX
2 4 (1.86%) Oracle General Ledger
2 4 (1.86%) Oracle Payables
2 4 (1.86%) Oracle Receivables
3 3 (1.40%) Dynamics CRM
3 3 (1.40%) Oracle EBS
4 2 (0.93%) Cognos TM1
4 2 (0.93%) Hyperion Planning
5 1 (0.47%) BPCS
5 1 (0.47%) Oracle Retail
5 1 (0.47%) SAP Oil and Gas
5 1 (0.47%) SDL Web 8
5 1 (0.47%) SystmOne
Cloud Services
1 12 (5.58%) Microsoft Azure
2 9 (4.19%) Amazon AWS
3 8 (3.72%) IaaS
3 8 (3.72%) PaaS
4 6 (2.79%) Data Lake Analytics
5 4 (1.86%) Amazon EMR
5 4 (1.86%) Amazon S3
5 4 (1.86%) AWS Lambda
6 3 (1.40%) SaaS
7 2 (0.93%) Google Analytics
8 1 (0.47%) Cloud Computing
8 1 (0.47%) Office 365
Communications & Networking
1 8 (3.72%) Intranet
2 4 (1.86%) Extranet
3 1 (0.47%) HTTP
3 1 (0.47%) Network Security
Database & Business Intelligence
1 126 (58.60%) SQL Server
2 115 (53.49%) Data Warehouse
3 100 (46.51%) SQL Server Integration Services
4 97 (45.12%) SQL Server Analysis Services
5 81 (37.67%) SQL Server Reporting Services
6 62 (28.84%) OLAP Cube
7 52 (24.19%) Oracle OLAP
8 34 (15.81%) SQL Server 2012
9 33 (15.35%) OLTP
10 30 (13.95%) QlikView
11 27 (12.56%) Power BI
12 25 (11.63%) BusinessObjects
13 23 (10.70%) Microsoft Analysis Services
13 23 (10.70%) SQL Server 2014
14 21 (9.77%) Relational Database
15 15 (6.98%) Big Data
16 13 (6.05%) Hadoop
16 13 (6.05%) SQL Server 2005
17 12 (5.58%) SQL Server 2008
17 12 (5.58%) Star Schema
Development Applications
1 11 (5.12%) Visual Studio
2 9 (4.19%) Talend Open Studio
3 8 (3.72%) JIRA
4 7 (3.26%) Team Foundation Server
5 6 (2.79%) Git (software)
6 5 (2.33%) ERwin
6 5 (2.33%) Visual Studio Tools for Office
7 4 (1.86%) JUnit
7 4 (1.86%) Subversion
8 3 (1.40%) SQL Server Management Studio (SSMS)
8 3 (1.40%) TeamCity
9 2 (0.93%) MagicDraw
10 1 (0.47%) Bitbucket
10 1 (0.47%) Eclipse
10 1 (0.47%) Jenkins
10 1 (0.47%) Maven
General
1 75 (34.88%) Finance
2 18 (8.37%) Banking
3 12 (5.58%) Advertising
4 9 (4.19%) General Ledger
4 9 (4.19%) Retail
5 5 (2.33%) Marketing
6 4 (1.86%) Publishing
7 3 (1.40%) Investment Banking
7 3 (1.40%) Legal
8 2 (0.93%) Automotive
8 2 (0.93%) Manufacturing
8 2 (0.93%) Spanish Language
9 1 (0.47%) Electronics
9 1 (0.47%) Financial Institution
9 1 (0.47%) Telecoms
9 1 (0.47%) Wholesale Banking
Job Titles
1 112 (52.09%) Developer
2 44 (20.47%) Business Intelligence Developer
3 35 (16.28%) Architect
4 30 (13.95%) Analyst
5 29 (13.49%) SQL Developer
6 25 (11.63%) Data Architect
7 23 (10.70%) Data Warehouse Developer
8 22 (10.23%) ETL Developer
9 19 (8.84%) SSIS Developer
10 18 (8.37%) Consultant
10 18 (8.37%) SSAS Developer
11 13 (6.05%) SSRS Developer
12 12 (5.58%) Business Analyst
12 12 (5.58%) Business Intelligence Consultant
12 12 (5.58%) OLAP Developer
13 10 (4.65%) DBA
14 9 (4.19%) Business Intelligence Manager
14 9 (4.19%) SQL BI Developer
15 8 (3.72%) Data Analyst
15 8 (3.72%) Microsoft BI Developer
Libraries, Frameworks & Software Standards
1 55 (25.58%) MDX
2 25 (11.63%) .NET
3 10 (4.65%) XML
4 7 (3.26%) ASP.NET
4 7 (3.26%) WCF
4 7 (3.26%) Web Services
5 5 (2.33%) ASP.NET MVC
6 4 (1.86%) .NET Framework
6 4 (1.86%) HTML
6 4 (1.86%) REST
6 4 (1.86%) WPF
7 3 (1.40%) HTML5
8 2 (0.93%) AngularJS
8 2 (0.93%) CSS
8 2 (0.93%) Hibernate
8 2 (0.93%) J2EE
8 2 (0.93%) Lucene
8 2 (0.93%) SAP XI
8 2 (0.93%) Spring
9 1 (0.47%) JTA
Miscellaneous
1 26 (12.09%) Analytical Skills
2 13 (6.05%) Management Information System
3 8 (3.72%) Computer Science
3 8 (3.72%) Credit Risk
3 8 (3.72%) Data Structures
4 6 (2.79%) NHS
5 5 (2.33%) Data Centre
6 3 (1.40%) Client/Server
6 3 (1.40%) Replication
7 2 (0.93%) Algorithms
7 2 (0.93%) Clustering
7 2 (0.93%) Fixed Income
7 2 (0.93%) Foreign Exchange (FX)
7 2 (0.93%) N-Tier
7 2 (0.93%) Reference Data
7 2 (0.93%) Taxonomies
8 1 (0.47%) Driving Licence
8 1 (0.47%) Mobile App
8 1 (0.47%) Private Cloud
8 1 (0.47%) Reinsurance
Operating Systems
1 11 (5.12%) Windows
2 9 (4.19%) Linux
3 8 (3.72%) Unix
4 4 (1.86%) Windows Server
5 3 (1.40%) HPUX
5 3 (1.40%) Red Hat Enterprise Linux
6 1 (0.47%) Windows Server 2012
Processes & Methodologies
1 121 (56.28%) Business Intelligence
2 107 (49.77%) ETL
3 45 (20.93%) Analytics
4 44 (20.47%) Data Modelling
5 34 (15.81%) Agile Software Development
5 34 (15.81%) Kimball Methodology
6 30 (13.95%) Performance Tuning
7 22 (10.23%) Migration
8 21 (9.77%) Data Management
9 19 (8.84%) Dimensional Modelling
10 17 (7.91%) Project Management
11 16 (7.44%) Data Integration
12 15 (6.98%) Scrum
13 13 (6.05%) Change Management
13 13 (6.05%) Dashboard Development
13 13 (6.05%) Data Governance
14 12 (5.58%) Data Migration
15 11 (5.12%) Data Analysis
15 11 (5.12%) Data Architecture
16 10 (4.65%) Visualisation
Programming Languages
1 130 (60.47%) SQL
2 50 (23.26%) T-SQL
3 28 (13.02%) C#
4 16 (7.44%) VBA
5 9 (4.19%) Java
6 8 (3.72%) PL/SQL
7 7 (3.26%) C
8 6 (2.79%) JavaScript
8 6 (2.79%) Python
8 6 (2.79%) R
8 6 (2.79%) Shell Script
9 5 (2.33%) Perl
9 5 (2.33%) VB
10 3 (1.40%) Data Analysis Expressions (DAX)
11 2 (0.93%) ABAP
11 2 (0.93%) VB.NET
12 1 (0.47%) PHP
12 1 (0.47%) SPARQL
Qualifications
1 18 (8.37%) Degree
2 3 (1.40%) Security Cleared
3 2 (0.93%) MCITP
3 2 (0.93%) Microsoft Certification
4 1 (0.47%) ACCA
4 1 (0.47%) BC Cleared
4 1 (0.47%) BPSS Clearance
4 1 (0.47%) CIMA
4 1 (0.47%) ITIL Certification
4 1 (0.47%) OCP
4 1 (0.47%) Oracle Certification
Quality Assurance & Compliance
1 26 (12.09%) Data Quality
2 9 (4.19%) IFRS
2 9 (4.19%) IFRS 9
3 4 (1.86%) Disclosure Scotland
3 4 (1.86%) QA
4 1 (0.47%) SLA
System Software
1 5 (2.33%) Virtual Machines
2 1 (0.47%) Docker
2 1 (0.47%) Oracle RAC
Systems Management
1 3 (1.40%) Oracle RMAN
2 2 (0.93%) SQL Sentry
3 1 (0.47%) Data Guard
Vendors
1 63 (29.30%) Microsoft
2 52 (24.19%) Oracle
3 24 (11.16%) Tableau
4 21 (9.77%) SAP
5 20 (9.30%) Teradata
6 11 (5.12%) Cognos
6 11 (5.12%) Informatica
7 9 (4.19%) Talend
8 8 (3.72%) MicroStrategy
9 7 (3.26%) IBM
10 6 (2.79%) Ab Initio
10 6 (2.79%) Hyperion
11 4 (1.86%) Actian
11 4 (1.86%) ParAccel
11 4 (1.86%) Sybase
12 3 (1.40%) Google
12 3 (1.40%) Netezza
12 3 (1.40%) Red Hat
13 2 (0.93%) DataFlux
13 2 (0.93%) RedGate
Essex
Montash
Rate: Competetive
Posted: Yesterday
Essex
Montash
Rate: Competetive
Posted: Yesterday
Essex
Montash
Rate: Competetive
Posted: Yesterday
Manchester
Nigel Frank International
Rate: £400 - £450 per annum
Posted: 3 days ago
North West
Opus Recruitment Solutions Ltd
Rate: £350 - £400 per day
Posted: 3 days ago