The table below looks at the statistics for OLAP skills in IT contracts advertised for the City of London region. Included is a guide to the average contractor rates offered in IT contracts that have cited OLAP over the 3 months to 31 July 2015 with a comparison to the same period in 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.

Location
3 months to
31 Jul 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 160 184 157
Rank change year-on-year
+24 -27
Contract jobs citing OLAP 48 15 69
As % of all contract IT jobs located in the City of London 0.82% 0.26% 0.97%
As % of the Database & Business Intelligence category 3.22% 1.13% 4.25%
Number of daily rates quoted 40 14 47
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£444 £475 £425
Average daily rate % change year-on-year
-6.57% +11.76%
90% offered a daily rate of more than £325 £358 £333
10% offered a daily rate of more than £503 £635 £550
UK excluding London average daily rate £425 £338 £388
% change year-on-year
+25.92% -12.90%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate - - £140.00
OLAP
London

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 City of London region.

Database & Business Intelligence Category
City of London
Contract IT job ads with a match in the
Database & Business Intelligence category
1493 1331 1622
As % of all contract IT jobs located in the City of London 25.50% 22.93% 22.88%
Number of daily rates quoted 1162 1010 1188
Average daily rate £458 £450 £430
Average daily rate % change year-on-year
+1.66% +4.65%
90% offered a daily rate of more than £325 £325 £320
10% offered a daily rate of more than £615 £575 £576
UK excluding London average daily rate £365 £350 £350
% change year-on-year
+4.28% -
Number of hourly rates quoted 8 5 18
Average hourly rate £21.50 £27.91 £51.00
Average hourly rate % change year-on-year
-22.96% -45.27%
90% offered a hourly rate of more than £17.40 £22.00 £12.90
10% offered a hourly rate of more than £69.50 £51.49 £52.50
UK excluding London average hourly rate £30.00 £28.50 £30.00
% change year-on-year
+5.26% -5.00%

OLAP
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of IT contractor jobs citing OLAP across the City of London region as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Jobs Demand Trend in the City of London

OLAP
Daily Rate Trend in the City of London

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

OLAP Daily Rate Trend in the City of London

OLAP
Daily Rate Histogram in the City of London

This chart provides a histogram of daily rates quoted in contract IT jobs citing OLAP across the City of London region over the 3 months to 31 July 2015.

OLAP Daily Rate Histogram in the City of London

OLAP
Hourly Rate Trend in the City of London

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

OLAP Hourly Rate Trend in the City of London

OLAP
Top 30 Related IT Skills in the City of London

For the 6 months to 31 July 2015, IT contractor jobs across the City of London region citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited OLAP.

1 79 (78.22%) Business Intelligence
2 69 (68.32%) ETL
2 69 (68.32%) SQL
3 67 (66.34%) SQL Server Integration Services
4 65 (64.36%) Data Warehouse
5 62 (61.39%) SQL Server
6 59 (58.42%) SQL Server Reporting Services
6 59 (58.42%) SQL Server Analysis Services
7 45 (44.55%) T-SQL
8 42 (41.58%) Microsoft
9 35 (34.65%) Finance
10 26 (25.74%) MDX
11 25 (24.75%) C#
12 24 (23.76%) OLAP Cube
13 23 (22.77%) Agile Software Development
14 22 (21.78%) .NET
14 22 (21.78%) Data Modelling
15 20 (19.80%) SQL Server 2012
16 19 (18.81%) Kimball Methodology
16 19 (18.81%) MS Excel
17 18 (17.82%) BusinessObjects
18 16 (15.84%) Oracle
18 16 (15.84%) Relational Database
18 16 (15.84%) Oracle OLAP
19 15 (14.85%) Solvency II
20 14 (13.86%) Banking
21 13 (12.87%) SQL Server 2008
22 12 (11.88%) Microsoft Analysis Services
22 12 (11.88%) Retail
23 11 (10.89%) NHS

OLAP
Top Related IT Skills in the City of London by Category

For the 6 months to 31 July 2015, IT contractor jobs across the City of London region citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 7 (6.93%) SharePoint
2 4 (3.96%) SAS
3 2 (1.98%) SharePoint Server
3 2 (1.98%) Oracle Coherence
3 2 (1.98%) Apache Spark
4 1 (0.99%) IIS
4 1 (0.99%) GemFire
Applications
1 19 (18.81%) MS Excel
2 10 (9.90%) PowerPivot
3 6 (5.94%) MS Office
4 2 (1.98%) Spreadsheet
5 1 (0.99%) MS Visio
Business Applications
1 4 (3.96%) Oracle Applications
2 2 (1.98%) Dynamics AX
3 1 (0.99%) Cognos Business Intelligence
3 1 (0.99%) ION MarketView
3 1 (0.99%) HFM
3 1 (0.99%) Cognos TM1
3 1 (0.99%) Endur
Database & Business Intelligence
1 67 (66.34%) SQL Server Integration Services
2 65 (64.36%) Data Warehouse
3 62 (61.39%) SQL Server
4 59 (58.42%) SQL Server Reporting Services
4 59 (58.42%) SQL Server Analysis Services
5 24 (23.76%) OLAP Cube
6 20 (19.80%) SQL Server 2012
7 18 (17.82%) BusinessObjects
8 16 (15.84%) Oracle OLAP
8 16 (15.84%) Relational Database
9 13 (12.87%) SQL Server 2008
10 12 (11.88%) Microsoft Analysis Services
11 11 (10.89%) Oracle Database
12 10 (9.90%) OLTP
13 9 (8.91%) Data Mart
13 9 (8.91%) Data Mining
13 9 (8.91%) QlikView
14 8 (7.92%) Oracle Database 11g
14 8 (7.92%) Oracle Database 12c
14 8 (7.92%) Microsoft Power View
Development Applications
1 6 (5.94%) Visual Studio
1 6 (5.94%) Team Foundation Server
2 5 (4.95%) ERwin
3 3 (2.97%) Talend Open Studio
4 2 (1.98%) Maven
4 2 (1.98%) Oracle Forms
4 2 (1.98%) SQL Server Management Studio (SSMS)
5 1 (0.99%) JIRA
5 1 (0.99%) JUnit
5 1 (0.99%) Visual Studio Tools for Office
General
1 35 (34.65%) Finance
2 14 (13.86%) Banking
3 12 (11.88%) Retail
4 10 (9.90%) Advertising
5 8 (7.92%) Marketing
5 8 (7.92%) Legal
6 4 (3.96%) Investment Banking
7 3 (2.97%) Financial Institution
8 2 (1.98%) Law
9 1 (0.99%) Retail Banking
9 1 (0.99%) Games
Job Titles
1 92 (91.09%) Developer
2 53 (52.48%) Business Intelligence Developer
3 18 (17.82%) SQL Developer
4 13 (12.87%) Business Developer
5 12 (11.88%) Data Warehouse Developer
6 11 (10.89%) Senior Developer
7 9 (8.91%) TM1 Developer
8 8 (7.92%) Oracle Developer
8 8 (7.92%) Microsoft Developer
9 7 (6.93%) Senior Business Intelligence Developer
10 6 (5.94%) SQL Server Developer
11 5 (4.95%) ETL Developer
12 4 (3.96%) Analyst
13 3 (2.97%) Business Objects Developer
13 3 (2.97%) Java Developer
13 3 (2.97%) SAS Developer
13 3 (2.97%) Senior Oracle Developer
14 2 (1.98%) Report Developer
14 2 (1.98%) SAS BI Developer
14 2 (1.98%) Technical Analyst
Libraries, Frameworks & Software Standards
1 26 (25.74%) MDX
2 22 (21.78%) .NET
3 5 (4.95%) XML
4 3 (2.97%) HTML
4 3 (2.97%) Spring
5 2 (1.98%) ActiveMQ
5 2 (1.98%) ASP.NET
6 1 (0.99%) XSD
6 1 (0.99%) XSLT
6 1 (0.99%) JSON
6 1 (0.99%) WPF
6 1 (0.99%) jQuery
6 1 (0.99%) ASP.NET 2.0
6 1 (0.99%) HTML5
6 1 (0.99%) REST
6 1 (0.99%) Akka
6 1 (0.99%) Play Framework
Miscellaneous
1 11 (10.89%) NHS
2 8 (7.92%) Analytical Skills
3 5 (4.95%) Clustering
4 4 (3.96%) Credit Risk
4 4 (3.96%) Market Risk
5 3 (2.97%) Visualisation
5 3 (2.97%) Data Structures
5 3 (2.97%) Foreign Exchange (FX)
6 2 (1.98%) Digital Media
6 2 (1.98%) Contract for Difference
6 2 (1.98%) Equities
6 2 (1.98%) Management Information System
7 1 (0.99%) Replication
7 1 (0.99%) Fixed Income
7 1 (0.99%) Grid Computing
7 1 (0.99%) Credit Derivative
7 1 (0.99%) Derivative
7 1 (0.99%) Informatics
7 1 (0.99%) Computer Science
7 1 (0.99%) N-Tier
Operating Systems
1 9 (8.91%) Linux
2 8 (7.92%) Windows
3 3 (2.97%) UNIX
4 1 (0.99%) Windows Server 2008
4 1 (0.99%) Windows Server 2012
Processes & Methodologies
1 79 (78.22%) Business Intelligence
2 69 (68.32%) ETL
3 23 (22.77%) Agile Software Development
4 22 (21.78%) Data Modelling
5 19 (18.81%) Kimball Methodology
6 11 (10.89%) ETL Development
7 10 (9.90%) Stakeholder Management
7 10 (9.90%) Scrum
8 9 (8.91%) Performance Tuning
8 9 (8.91%) Dimensional Modelling
8 9 (8.91%) Data Architecture
9 8 (7.92%) Migration
10 7 (6.93%) Change Management
10 7 (6.93%) Analytics
11 6 (5.94%) Test Automation
11 6 (5.94%) Data Management
12 5 (4.95%) TDD
12 5 (4.95%) Data Migration
12 5 (4.95%) Master Data Management
13 4 (3.96%) Inmon Methodology
Programming Languages
1 69 (68.32%) SQL
2 45 (44.55%) T-SQL
3 25 (24.75%) C#
4 9 (8.91%) PL/SQL
5 8 (7.92%) C
6 7 (6.93%) Java
6 7 (6.93%) VB.NET
7 6 (5.94%) Data Analysis Expressions (DAX)
8 5 (4.95%) PowerShell
9 4 (3.96%) VBA
10 3 (2.97%) VB
11 1 (0.99%) JavaScript
11 1 (0.99%) Perl
11 1 (0.99%) C++
11 1 (0.99%) Python
11 1 (0.99%) Shell Script
11 1 (0.99%) Scala
11 1 (0.99%) Data Mining Extensions (DMX)
Qualifications
1 4 (3.96%) Microsoft Certification
1 4 (3.96%) OCP
1 4 (3.96%) Oracle Certification
2 1 (0.99%) PMI Certification
Quality Assurance & Compliance
1 15 (14.85%) Solvency II
2 7 (6.93%) Data Quality
3 3 (2.97%) QA
4 1 (0.99%) Basel III
4 1 (0.99%) Dodd-Frank
4 1 (0.99%) PMBOK
System Software
1 1 (0.99%) Apache Flume
1 1 (0.99%) HDFS
Systems Management
1 1 (0.99%) Oozie
Vendors
1 42 (41.58%) Microsoft
2 16 (15.84%) Oracle
3 7 (6.93%) SAP
3 7 (6.93%) Tableau
4 4 (3.96%) Cognos
4 4 (3.96%) Informatica
4 4 (3.96%) MicroStrategy
5 3 (2.97%) Teradata
5 3 (2.97%) Talend
6 2 (1.98%) IBM
7 1 (0.99%) Sybase
7 1 (0.99%) ION Trading
7 1 (0.99%) Netezza
7 1 (0.99%) FactSet
7 1 (0.99%) Actian
7 1 (0.99%) Hyperion
City, London
Testing Circle Ltd
Rate: £200 per day
Posted: 2 days ago
City, London
Venturi
Rate: £350 - £425 per day
Posted: 5 days ago
City of London
Venturi
Rate: £400 - £450 per day
Posted: 13 days ago
City of London
Venturi
Rate: £450 - £525 per day
Posted: 26 days ago