The table below looks at the statistics for OLAP skills in IT contracts advertised for the London region. Included is a guide to the contractor rates offered in IT contracts that have cited OLAP over the 3 months to 19 January 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
19 Jan 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
England / London
Rank 361 354 303
Rank change year-on-year
-7 -51
Contract jobs citing OLAP 37 61 105
As % of all contract IT jobs located in London 0.19% 0.29% 0.50%
As % of the Database & Business Intelligence category 0.78% 1.20% 2.11%
Number of daily rates quoted 26 47 68
Median daily rate £450 £470 £438
Median daily rate % change year-on-year
-4.25% +7.42%
90% offered a daily rate of more than £384 £300 £350
10% offered a daily rate of more than £550 £625 £600
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 in the London region.

Database & Business Intelligence Category
London
Contract IT job ads with a match in the
Database & Business Intelligence category
4764 5073 4976
As % of all contract IT jobs located in London 24.54% 24.21% 23.49%
Number of daily rates quoted 3410 3659 3543
Median daily rate £500 £475 £438
Median daily rate % change year-on-year
+5.26% +8.57%
90% offered a daily rate of more than £350 £325 £300
10% offered a daily rate of more than £625 £625 £600
UK excluding London median daily rate £400 £375 £363
% change year-on-year
+6.66% +3.44%
Number of hourly rates quoted 19 29 30
Median hourly rate £30.00 £34.00 £24.75
Median hourly rate % change year-on-year
-11.76% +37.37%
90% offered a hourly rate of more than £18.12 £17.75 £16.15
10% offered a hourly rate of more than £47.00 £53.00 £41.45
UK excluding London median hourly rate £38.00 £26.50 £32.50
% change year-on-year
+43.39% -18.46%

OLAP
Jobs Demand Trend in London

The demand trend of contract jobs across the London region citing OLAP as a proportion of all IT contracts with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in London

OLAP
Daily Rate Trend in London

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

OLAP Daily Rate Trend in London

OLAP
Daily Rate Histogram in London

This chart provides a histogram of daily rates quoted in contract IT jobs citing OLAP across the London region over the 3 months to 19 January 2017.

OLAP Daily Rate Histogram in London

OLAP
Hourly Rate Trend in London

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

OLAP Hourly Rate Trend 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 19 January 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 -16 5 £500 -4.76% 5
Canary Wharf - 1 £588 -
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 19 January 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 47 (61.84%) Business Intelligence
2 46 (60.53%) SQL Server
3 42 (55.26%) Data Warehouse
4 38 (50.00%) ETL
5 37 (48.68%) SQL
5 37 (48.68%) SQL Server Analysis Services
6 33 (43.42%) SQL Server Integration Services
7 31 (40.79%) SQL Server Reporting Services
8 30 (39.47%) Finance
9 26 (34.21%) Microsoft
10 24 (31.58%) OLAP Cube
11 19 (25.00%) SQL Server 2012
12 18 (23.68%) Oracle
12 18 (23.68%) MDX
12 18 (23.68%) Oracle OLAP
13 16 (21.05%) Agile Software Development
13 16 (21.05%) Data Modelling
13 16 (21.05%) Analytics
14 15 (19.74%) T-SQL
14 15 (19.74%) C#
15 13 (17.11%) .NET
16 12 (15.79%) Banking
16 12 (15.79%) Tableau
16 12 (15.79%) Analytical Skills
17 11 (14.47%) SQL Server 2014
17 11 (14.47%) MS Excel
18 10 (13.16%) Java
18 10 (13.16%) QlikView
18 10 (13.16%) Power BI
18 10 (13.16%) Performance Tuning

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 5 (6.58%) SAS
2 4 (5.26%) SharePoint
3 3 (3.95%) Apache
4 1 (1.32%) Alfresco
4 1 (1.32%) Apache Spark
4 1 (1.32%) CMS
4 1 (1.32%) Magnolia
4 1 (1.32%) Oracle SOA Suite
4 1 (1.32%) SharePoint 2010
4 1 (1.32%) SharePoint 2013
4 1 (1.32%) Tomcat
4 1 (1.32%) TPMS
4 1 (1.32%) WebSphere
Applications
1 11 (14.47%) MS Excel
2 4 (5.26%) MS Visio
3 3 (3.95%) SPSS
4 2 (2.63%) MS Office
4 2 (2.63%) MS PowerPoint
5 1 (1.32%) MS Project
5 1 (1.32%) Spreadsheet
Business Applications
1 1 (1.32%) Cognos TM1
1 1 (1.32%) Dynamics AX
1 1 (1.32%) SDL Web 8
Cloud Services
1 6 (7.89%) Microsoft Azure
2 3 (3.95%) Data Lake Analytics
3 2 (2.63%) Amazon AWS
3 2 (2.63%) IaaS
3 2 (2.63%) PaaS
4 1 (1.32%) Cloud Computing
4 1 (1.32%) Google Analytics
Communications & Networking
1 1 (1.32%) HTTP
Database & Business Intelligence
1 46 (60.53%) SQL Server
2 42 (55.26%) Data Warehouse
3 37 (48.68%) SQL Server Analysis Services
4 33 (43.42%) SQL Server Integration Services
5 31 (40.79%) SQL Server Reporting Services
6 24 (31.58%) OLAP Cube
7 19 (25.00%) SQL Server 2012
8 18 (23.68%) Oracle OLAP
9 11 (14.47%) SQL Server 2014
10 10 (13.16%) Power BI
10 10 (13.16%) QlikView
11 9 (11.84%) Microsoft Analysis Services
11 9 (11.84%) OLTP
12 8 (10.53%) Data Mining
13 7 (9.21%) Big Data
13 7 (9.21%) BusinessObjects
14 6 (7.89%) SQL Server 2008
15 5 (6.58%) BusinessObjects Web Intelligence
16 4 (5.26%) DataStage
16 4 (5.26%) SSDT
Development Applications
1 5 (6.58%) Visual Studio Tools for Office
2 4 (5.26%) JUnit
2 4 (5.26%) Visual Studio
3 3 (3.95%) Bitbucket
4 2 (2.63%) PowerDesigner
4 2 (2.63%) Team Foundation Server
5 1 (1.32%) Eclipse
5 1 (1.32%) Jenkins
5 1 (1.32%) JIRA
5 1 (1.32%) Maven
5 1 (1.32%) Subversion
5 1 (1.32%) TeamCity
General
1 30 (39.47%) Finance
2 12 (15.79%) Banking
3 6 (7.89%) Retail
4 5 (6.58%) Advertising
5 4 (5.26%) Marketing
6 3 (3.95%) Legal
7 2 (2.63%) Investment Banking
8 1 (1.32%) Financial Institution
Job Titles
1 40 (52.63%) Developer
2 18 (23.68%) Business Intelligence Developer
3 8 (10.53%) Analyst
3 8 (10.53%) SQL Developer
4 7 (9.21%) Architect
5 6 (7.89%) Data Warehouse Developer
6 5 (6.58%) Business Intelligence Manager
6 5 (6.58%) SQL Server Developer
7 4 (5.26%) Business Intelligence Consultant
7 4 (5.26%) Consultant
7 4 (5.26%) DBA
7 4 (5.26%) ETL Developer
7 4 (5.26%) Java Developer
7 4 (5.26%) Microsoft BI Developer
7 4 (5.26%) Senior Developer
8 3 (3.95%) Data Architect
8 3 (3.95%) Microsoft Developer
8 3 (3.95%) Report Analyst
8 3 (3.95%) SQL BI Developer
8 3 (3.95%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 18 (23.68%) MDX
2 13 (17.11%) .NET
3 5 (6.58%) ASP.NET
3 5 (6.58%) ASP.NET MVC
3 5 (6.58%) WCF
4 3 (3.95%) Apache Camel
4 3 (3.95%) HTML
4 3 (3.95%) HTML5
4 3 (3.95%) Kafka
4 3 (3.95%) REST
5 2 (2.63%) .NET Framework
5 2 (2.63%) AngularJS
5 2 (2.63%) Hibernate
5 2 (2.63%) J2EE
5 2 (2.63%) SAP XI
5 2 (2.63%) Spring
5 2 (2.63%) Web Services
6 1 (1.32%) CSS3
6 1 (1.32%) Node.js
6 1 (1.32%) Twitter Bootstrap
Miscellaneous
1 12 (15.79%) Analytical Skills
2 5 (6.58%) Data Integration
2 5 (6.58%) Data Structures
3 4 (5.26%) Replication
4 3 (3.95%) Computer Science
4 3 (3.95%) Data Conversion
4 3 (3.95%) Foreign Exchange (FX)
4 3 (3.95%) Visualisation
5 2 (2.63%) Client/Server
5 2 (2.63%) Clustering
5 2 (2.63%) Credit Risk
5 2 (2.63%) Mathematics
5 2 (2.63%) N-Tier
6 1 (1.32%) Algorithms
6 1 (1.32%) Data Centre
6 1 (1.32%) Data Extraction
6 1 (1.32%) Derivative
6 1 (1.32%) Management Information System
6 1 (1.32%) Statistics
6 1 (1.32%) Virtual Team
Operating Systems
1 5 (6.58%) Windows
2 3 (3.95%) Linux
2 3 (3.95%) Unix
3 1 (1.32%) Windows Server
3 1 (1.32%) Windows Server 2012
Processes & Methodologies
1 47 (61.84%) Business Intelligence
2 38 (50.00%) ETL
3 16 (21.05%) Agile Software Development
3 16 (21.05%) Analytics
3 16 (21.05%) Data Modelling
4 10 (13.16%) Performance Tuning
5 9 (11.84%) Kimball Methodology
6 8 (10.53%) Data Management
6 8 (10.53%) Scrum
7 7 (9.21%) Dimensional Modelling
7 7 (9.21%) Migration
8 5 (6.58%) Business Analysis
8 5 (6.58%) Master Data Management
8 5 (6.58%) MVC
8 5 (6.58%) Open Source
8 5 (6.58%) RAD
9 4 (5.26%) Dashboard Development
9 4 (5.26%) Data Analysis
9 4 (5.26%) Data Migration
9 4 (5.26%) ETL Development
Programming Languages
1 37 (48.68%) SQL
2 15 (19.74%) C#
2 15 (19.74%) T-SQL
3 10 (13.16%) Java
4 9 (11.84%) VBA
5 5 (6.58%) PL/SQL
6 3 (3.95%) JavaScript
6 3 (3.95%) R
7 2 (2.63%) Data Analysis Expressions (DAX)
7 2 (2.63%) Shell Script
8 1 (1.32%) Bash Shell
8 1 (1.32%) C
8 1 (1.32%) PowerShell
8 1 (1.32%) Python
8 1 (1.32%) VB.NET
Qualifications
1 8 (10.53%) Degree
2 2 (2.63%) MCITP
2 2 (2.63%) Microsoft Certification
3 1 (1.32%) ITIL Certification
3 1 (1.32%) OCP
3 1 (1.32%) Oracle Certification
3 1 (1.32%) Security Cleared
Quality Assurance & Compliance
1 5 (6.58%) Data Quality
2 3 (3.95%) QA
System Software
1 3 (3.95%) Docker
2 2 (2.63%) Virtual Machines
3 1 (1.32%) Oracle RAC
Systems Management
1 1 (1.32%) Data Guard
Vendors
1 26 (34.21%) Microsoft
2 18 (23.68%) Oracle
3 12 (15.79%) Tableau
4 7 (9.21%) Teradata
5 5 (6.58%) Cognos
5 5 (6.58%) SAP
6 4 (5.26%) IBM
6 4 (5.26%) Informatica
7 3 (3.95%) MicroStrategy
7 3 (3.95%) Sybase
8 2 (2.63%) Ab Initio
8 2 (2.63%) DataFlux
8 2 (2.63%) Netezza
8 2 (2.63%) RedGate
9 1 (1.32%) Google
9 1 (1.32%) Hyperion
9 1 (1.32%) Salesforce.com
9 1 (1.32%) Splunk
9 1 (1.32%) TARGIT
9 1 (1.32%) Vertica
London
Venturi
Rate: £500 - £700 per day
Posted: Yesterday