The following table provides summary statistics for contract job vacancies advertised in London with a requirement for OLAP skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited OLAP over the 3 months to 24 March 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
England / London
Rank 353 368 314
Rank change year-on-year +15 -54  
Contract jobs citing OLAP 47 60 95
As % of all contract IT jobs advertised in London 0.24% 0.27% 0.45%
As % of the Database & Business Intelligence category 0.97% 1.13% 1.88%
Number of daily rates quoted 36 41 79
Median daily rate £462 £450 £425
Median daily rate % change year-on-year +2.66% +5.88%  
90% offered a daily rate of more than £320 £375 £350
10% offered a daily rate of more than £575 £650 £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 - - -

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in London with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills
London
Contract job vacancies with a requirement for database and business intelligence skills 4858 5320 5042
As % of all contract IT job vacancies advertised in London 24.96% 24.13% 24.04%
Number of daily rates quoted 3508 3817 3483
Median daily rate £488 £475 £450
Median daily rate % change year-on-year +2.63% +5.55%  
90% offered a daily rate of more than £350 £325 £313
10% offered a daily rate of more than £625 £620 £588
UK excluding London median daily rate £400 £388 £375
% change year-on-year +3.22% +3.33%  
Number of hourly rates quoted 18 36 39
Median hourly rate £30.00 £43.00 £22.83
Median hourly rate % change year-on-year -30.23% +88.34%  
90% offered a hourly rate of more than £17.80 £19.00 £14.50
10% offered a hourly rate of more than £109.50 £50.00 £55.00
UK excluding London median hourly rate £31.00 £32.50 £32.50
% change year-on-year -4.61% -  

OLAP
Job Vacancy Trend in London

The job posting trend of jobs advertised in London citing OLAP as a proportion of all contract or permanent IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for OLAP in London

OLAP
Contractor Daily Rate Trend in London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing OLAP in London.

Contractor daily rate trend for OLAP in London

OLAP
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing OLAP in London over the 3 months to 24 March 2017.

Contractor daily rate histogram for OLAP in London

OLAP
Contractor Hourly Rate Trend in London

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing OLAP in London.

Contractor hourly rate trend for OLAP in London

OLAP
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLAP within the London region over the 3 months to 24 March 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
City of London +5 7 £500 +17.64% 5
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 24 March 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 across the London region with a requirement for OLAP.

1 62 (69.66%) SQL Server
2 58 (65.17%) Business Intelligence
3 56 (62.92%) SQL
4 54 (60.67%) Data Warehouse
5 49 (55.06%) SQL Server Analysis Services
6 46 (51.69%) SQL Server Integration Services
7 38 (42.70%) SQL Server Reporting Services
8 37 (41.57%) Finance
9 36 (40.45%) ETL
10 29 (32.58%) Microsoft
11 27 (30.34%) T-SQL
12 26 (29.21%) OLAP Cube
13 24 (26.97%) SQL Server 2012
14 23 (25.84%) Agile Software Development
14 23 (25.84%) MDX
15 22 (24.72%) C#
16 21 (23.60%) Oracle
17 20 (22.47%) Oracle OLAP
18 19 (21.35%) .NET
18 19 (21.35%) MS Excel
18 19 (21.35%) Analytics
18 19 (21.35%) Tableau
19 18 (20.22%) Power BI
20 17 (19.10%) Analytical Skills
21 16 (17.98%) Data Modelling
22 14 (15.73%) QlikView
22 14 (15.73%) Microsoft Azure
22 14 (15.73%) Kimball Methodology
23 13 (14.61%) Banking
24 12 (13.48%) Dimensional Modelling

OLAP
Top Related IT Skills in London 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 10 (11.24%) SAS
2 8 (8.99%) SharePoint
3 3 (3.37%) CMS
4 2 (2.25%) Drupal
5 1 (1.12%) Alfresco
5 1 (1.12%) Apache
5 1 (1.12%) Apache Spark
5 1 (1.12%) Confluence
5 1 (1.12%) Magnolia
5 1 (1.12%) Oracle Coherence
5 1 (1.12%) Oracle SOA Suite
5 1 (1.12%) SharePoint 2010
5 1 (1.12%) SharePoint 2013
5 1 (1.12%) Tomcat
5 1 (1.12%) TPMS
5 1 (1.12%) WebSphere
Applications
1 19 (21.35%) MS Excel
2 3 (3.37%) SPSS
3 2 (2.25%) MS Office
3 2 (2.25%) MS PowerPoint
3 2 (2.25%) MS Project
3 2 (2.25%) MS Visio
4 1 (1.12%) Spreadsheet
Business Applications
1 2 (2.25%) Dynamics AX
1 2 (2.25%) Hyperion Planning
1 2 (2.25%) Oracle Retail
2 1 (1.12%) Global One
2 1 (1.12%) Oracle EBS
2 1 (1.12%) SDL Web 8
2 1 (1.12%) SunGard Martini
Cloud Services
1 14 (15.73%) Microsoft Azure
2 6 (6.74%) Data Lake Analytics
3 5 (5.62%) IaaS
3 5 (5.62%) PaaS
4 3 (3.37%) Amazon AWS
5 1 (1.12%) Cloud Computing
5 1 (1.12%) Google Analytics
Communications & Networking
1 1 (1.12%) HTTP
Database & Business Intelligence
1 62 (69.66%) SQL Server
2 54 (60.67%) Data Warehouse
3 49 (55.06%) SQL Server Analysis Services
4 46 (51.69%) SQL Server Integration Services
5 38 (42.70%) SQL Server Reporting Services
6 26 (29.21%) OLAP Cube
7 24 (26.97%) SQL Server 2012
8 20 (22.47%) Oracle OLAP
9 18 (20.22%) Power BI
10 14 (15.73%) QlikView
11 11 (12.36%) OLTP
11 11 (12.36%) SQL Server 2014
12 10 (11.24%) Azure SQL Database
12 10 (11.24%) Microsoft Analysis Services
13 8 (8.99%) Data Mining
13 8 (8.99%) Oracle Database
13 8 (8.99%) SQL Server 2008
13 8 (8.99%) SQL Server 2016
14 7 (7.87%) Big Data
15 6 (6.74%) Relational Database
Development Applications
1 9 (10.11%) Visual Studio
2 3 (3.37%) JIRA
2 3 (3.37%) Subversion
2 3 (3.37%) TeamCity
2 3 (3.37%) Visual Studio Tools for Office
3 2 (2.25%) JUnit
3 2 (2.25%) Team Foundation Server
4 1 (1.12%) Bitbucket
4 1 (1.12%) Eclipse
4 1 (1.12%) Git (software)
4 1 (1.12%) Maven
General
1 37 (41.57%) Finance
2 13 (14.61%) Banking
3 11 (12.36%) Retail
4 6 (6.74%) Advertising
5 3 (3.37%) Investment Banking
5 3 (3.37%) Legal
5 3 (3.37%) Marketing
6 2 (2.25%) Automotive
6 2 (2.25%) Spanish Language
7 1 (1.12%) Financial Institution
Job Titles
1 56 (62.92%) Developer
2 22 (24.72%) Business Intelligence Developer
3 19 (21.35%) SQL Developer
4 12 (13.48%) Data Warehouse Developer
5 10 (11.24%) Analyst
6 8 (8.99%) Architect
7 7 (7.87%) Consultant
7 7 (7.87%) OLAP Developer
7 7 (7.87%) SSIS Developer
8 6 (6.74%) Business Analyst
8 6 (6.74%) Data Architect
9 5 (5.62%) Azure Consultant
9 5 (5.62%) Business Intelligence Consultant
9 5 (5.62%) Business Intelligence Manager
9 5 (5.62%) ETL Developer
9 5 (5.62%) Oracle Developer
9 5 (5.62%) SSAS Developer
10 4 (4.49%) Senior Business Intelligence Consultant
10 4 (4.49%) SQL BI Developer
10 4 (4.49%) SSRS Developer
Libraries, Frameworks & Software Standards
1 23 (25.84%) MDX
2 19 (21.35%) .NET
3 6 (6.74%) ASP.NET
4 5 (5.62%) .NET Framework
4 5 (5.62%) Web Services
4 5 (5.62%) WPF
5 4 (4.49%) ASP.NET MVC
5 4 (4.49%) WCF
6 3 (3.37%) AngularJS
6 3 (3.37%) Hibernate
6 3 (3.37%) Spring
7 2 (2.25%) CSS
7 2 (2.25%) HTML
7 2 (2.25%) J2EE
7 2 (2.25%) JMS
7 2 (2.25%) JPA
7 2 (2.25%) SAP XI
7 2 (2.25%) WinForms
7 2 (2.25%) XML
8 1 (1.12%) RESTful
Miscellaneous
1 17 (19.10%) Analytical Skills
2 4 (4.49%) Credit Risk
3 3 (3.37%) Computer Science
4 2 (2.25%) Clustering
4 2 (2.25%) Data Structures
4 2 (2.25%) Enterprise Software
4 2 (2.25%) Fixed Income
4 2 (2.25%) N-Tier
4 2 (2.25%) Replication
5 1 (1.12%) Algorithms
5 1 (1.12%) Hedge funds
5 1 (1.12%) Virtual Team
Operating Systems
1 3 (3.37%) Windows
2 1 (1.12%) Linux
2 1 (1.12%) Unix
2 1 (1.12%) Windows Server
2 1 (1.12%) Windows Server 2012
Processes & Methodologies
1 58 (65.17%) Business Intelligence
2 36 (40.45%) ETL
3 23 (25.84%) Agile Software Development
4 19 (21.35%) Analytics
5 16 (17.98%) Data Modelling
6 14 (15.73%) Kimball Methodology
7 12 (13.48%) Dimensional Modelling
7 12 (13.48%) Performance Tuning
8 11 (12.36%) Migration
9 9 (10.11%) Data Management
9 9 (10.11%) Scrum
10 8 (8.99%) Dashboard Development
11 7 (7.87%) OO
11 7 (7.87%) Waterfall
12 6 (6.74%) Data Analysis
12 6 (6.74%) Visualisation
13 5 (5.62%) Business Analysis
13 5 (5.62%) Data Integration
13 5 (5.62%) Data Migration
13 5 (5.62%) Unit Testing
Programming Languages
1 56 (62.92%) SQL
2 27 (30.34%) T-SQL
3 22 (24.72%) C#
4 11 (12.36%) VBA
5 7 (7.87%) Java
5 7 (7.87%) PL/SQL
6 6 (6.74%) JavaScript
6 6 (6.74%) R
7 3 (3.37%) Data Analysis Expressions (DAX)
8 2 (2.25%) C
9 1 (1.12%) Python
9 1 (1.12%) Shell Script
9 1 (1.12%) VB.NET
Qualifications
1 11 (12.36%) Degree
2 2 (2.25%) MCITP
2 2 (2.25%) Microsoft Certification
3 1 (1.12%) ACCA
3 1 (1.12%) CIMA
Quality Assurance & Compliance
1 7 (7.87%) QA
2 6 (6.74%) Data Quality
System Software
1 5 (5.62%) Virtual Machines
2 1 (1.12%) Docker
2 1 (1.12%) Oracle RAC
Systems Management
1 2 (2.25%) SQL Sentry
Vendors
1 29 (32.58%) Microsoft
2 21 (23.60%) Oracle
3 19 (21.35%) Tableau
4 9 (10.11%) Teradata
5 4 (4.49%) Cognos
5 4 (4.49%) IBM
5 4 (4.49%) Informatica
5 4 (4.49%) MicroStrategy
6 3 (3.37%) SAP
7 2 (2.25%) Ab Initio
7 2 (2.25%) DataFlux
7 2 (2.25%) Hyperion
7 2 (2.25%) Netezza
7 2 (2.25%) RedGate
8 1 (1.12%) Atlassian
8 1 (1.12%) Google
8 1 (1.12%) Jaspersoft
8 1 (1.12%) Solace
8 1 (1.12%) Sophis
8 1 (1.12%) TARGIT
London
Nigel Frank International
Posted: Yesterday
London
AMS contingency
Posted: 7 days ago
London
AMS contingency
Posted: 10 days ago