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 27 March 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
27 Mar 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 141 166 155
Rank change year-on-year
+25 -11
Contract jobs citing OLAP 48 39 40
As % of all contract IT jobs located in the City of London 0.93% 0.64% 0.68%
As % of the Database & Business Intelligence category 3.87% 2.95% 2.93%
Number of daily rates quoted 42 26 34
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£431 £450 £438
Average daily rate % change year-on-year
-4.16% +2.85%
90% offered a daily rate of more than £351 £325 £375
10% offered a daily rate of more than £465 £600 £635
UK excluding London average daily rate £415 £375 £325
% change year-on-year
+10.66% +15.38%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate - £33.00 £36.50
% change year-on-year
- -9.58%
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
1241 1322 1367
As % of all contract IT jobs located in the City of London 24.17% 21.79% 23.15%
Number of daily rates quoted 972 954 1072
Average daily rate £450 £450 £450
90% offered a daily rate of more than £313 £300 £325
10% offered a daily rate of more than £588 £575 £575
UK excluding London average daily rate £375 £350 £330
% change year-on-year
+7.14% +6.06%
Number of hourly rates quoted 5 7 2
Average hourly rate £50.00 £33.75 £52.50
Average hourly rate % change year-on-year
+48.14% -35.71%
UK excluding London average hourly rate £34.00 £34.38 £28.00
% change year-on-year
-1.09% +22.76%

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 27 March 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 27 March 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 66 (84.62%) Business Intelligence
2 55 (70.51%) SQL
3 53 (67.95%) ETL
4 46 (58.97%) SQL Server Integration Services
5 43 (55.13%) Data Warehouse
6 40 (51.28%) SQL Server
6 40 (51.28%) SQL Server Analysis Services
7 37 (47.44%) Microsoft
8 36 (46.15%) SQL Server Reporting Services
9 32 (41.03%) T-SQL
10 23 (29.49%) OLAP Cube
11 19 (24.36%) Finance
12 18 (23.08%) Data Modelling
13 16 (20.51%) SQL Server 2008
14 14 (17.95%) MDX
15 13 (16.67%) C#
15 13 (16.67%) Oracle
15 13 (16.67%) Oracle OLAP
16 12 (15.38%) Data Mining
17 11 (14.10%) Banking
17 11 (14.10%) MS Excel
18 10 (12.82%) OLTP
18 10 (12.82%) NHS
18 10 (12.82%) Analytics
19 9 (11.54%) Oracle Database
19 9 (11.54%) Microsoft Analysis Services
19 9 (11.54%) Linux
19 9 (11.54%) PL/SQL
20 8 (10.26%) UNIX
20 8 (10.26%) Windows

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

For the 6 months to 27 March 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 (8.97%) SAS
2 6 (7.69%) SharePoint
3 3 (3.85%) SharePoint Server
4 1 (1.28%) Oracle Coherence
4 1 (1.28%) GemFire
4 1 (1.28%) Apache Spark
4 1 (1.28%) NetWeaver
Applications
1 11 (14.10%) MS Excel
2 8 (10.26%) PowerPivot
3 3 (3.85%) MS Office
4 2 (2.56%) MS Visio
5 1 (1.28%) MS Project
Business Applications
1 4 (5.13%) Oracle Applications
1 4 (5.13%) Cognos Business Intelligence
2 2 (2.56%) Cognos TM1
2 2 (2.56%) Dynamics AX
3 1 (1.28%) HFM
3 1 (1.28%) ION MarketView
3 1 (1.28%) SAP BPC
3 1 (1.28%) SAP R/3
Database & Business Intelligence
1 46 (58.97%) SQL Server Integration Services
2 43 (55.13%) Data Warehouse
3 40 (51.28%) SQL Server
3 40 (51.28%) SQL Server Analysis Services
4 36 (46.15%) SQL Server Reporting Services
5 23 (29.49%) OLAP Cube
6 16 (20.51%) SQL Server 2008
7 13 (16.67%) Oracle OLAP
8 12 (15.38%) Data Mining
9 10 (12.82%) OLTP
10 9 (11.54%) Microsoft Analysis Services
10 9 (11.54%) Oracle Database
11 8 (10.26%) Star Schema
12 7 (8.97%) Oracle Database 12c
12 7 (8.97%) Oracle Database 11g
13 6 (7.69%) Microsoft Power View
13 6 (7.69%) SQL Server 2012
14 4 (5.13%) Base SAS
15 3 (3.85%) MySQL
15 3 (3.85%) SQL Server 2005
Development Applications
1 4 (5.13%) SQL Server Management Studio (SSMS)
2 3 (3.85%) Talend Open Studio
3 2 (2.56%) Oracle Forms
4 1 (1.28%) ERwin
4 1 (1.28%) Maven
General
1 19 (24.36%) Finance
2 11 (14.10%) Banking
3 5 (6.41%) Retail
3 5 (6.41%) Advertising
4 2 (2.56%) Games
4 2 (2.56%) Telecoms
4 2 (2.56%) Legal
5 1 (1.28%) Law
5 1 (1.28%) Investment Banking
5 1 (1.28%) Retail Banking
5 1 (1.28%) Marketing
Job Titles
1 61 (78.21%) Developer
2 39 (50.00%) Business Intelligence Developer
3 13 (16.67%) SQL Developer
4 10 (12.82%) Microsoft Developer
4 10 (12.82%) Business Developer
5 8 (10.26%) Analyst
6 7 (8.97%) Oracle Developer
7 6 (7.69%) Senior Developer
8 5 (6.41%) Data Warehouse Developer
9 3 (3.85%) SAS Developer
9 3 (3.85%) Senior Oracle Developer
9 3 (3.85%) ETL Developer
9 3 (3.85%) Business Intelligence Analyst
9 3 (3.85%) Technical Analyst
9 3 (3.85%) Consultant
9 3 (3.85%) Business Intelligence Consultant
9 3 (3.85%) Senior Business Intelligence Developer
10 2 (2.56%) Microsoft BI Consultant
10 2 (2.56%) Microsoft Consultant
10 2 (2.56%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 14 (17.95%) MDX
2 8 (10.26%) XML
3 7 (8.97%) .NET
4 5 (6.41%) HTML
4 5 (6.41%) HTML5
5 4 (5.13%) ASP.NET
6 1 (1.28%) J2EE
6 1 (1.28%) XSD
6 1 (1.28%) XSLT
6 1 (1.28%) SAP XI
6 1 (1.28%) Spring
Miscellaneous
1 10 (12.82%) NHS
2 7 (8.97%) Analytical Skills
3 5 (6.41%) Visualisation
4 3 (3.85%) Digital Media
5 2 (2.56%) Social Network
5 2 (2.56%) Credit Risk
5 2 (2.56%) Data Integration
6 1 (1.28%) N-Tier
6 1 (1.28%) Market Risk
6 1 (1.28%) Fixed Income
6 1 (1.28%) Mathematics
6 1 (1.28%) Computer Science
6 1 (1.28%) Open Source
Operating Systems
1 9 (11.54%) Linux
2 8 (10.26%) UNIX
2 8 (10.26%) Windows
Processes & Methodologies
1 66 (84.62%) Business Intelligence
2 53 (67.95%) ETL
3 18 (23.08%) Data Modelling
4 10 (12.82%) Analytics
5 8 (10.26%) Data Architecture
6 7 (8.97%) Performance Tuning
7 6 (7.69%) Data Analysis
8 5 (6.41%) Kimball Methodology
9 4 (5.13%) Data Transformation
9 4 (5.13%) Database Security
9 4 (5.13%) Database Tuning
10 3 (3.85%) User Acceptance Testing
10 3 (3.85%) Migration
10 3 (3.85%) Stakeholder Management
10 3 (3.85%) PDM
10 3 (3.85%) Agile Software Development
10 3 (3.85%) SOA
10 3 (3.85%) DevOps
11 2 (2.56%) Visual Analytics
11 2 (2.56%) Workflow
Programming Languages
1 55 (70.51%) SQL
2 32 (41.03%) T-SQL
3 13 (16.67%) C#
4 9 (11.54%) PL/SQL
5 6 (7.69%) C
5 6 (7.69%) Shell Script
6 5 (6.41%) Java
7 2 (2.56%) VBA
7 2 (2.56%) Python
8 1 (1.28%) Perl
8 1 (1.28%) C++
8 1 (1.28%) VB
8 1 (1.28%) ABAP
Qualifications
1 4 (5.13%) OCP
1 4 (5.13%) Oracle Certification
2 1 (1.28%) Degree
Quality Assurance & Compliance
1 5 (6.41%) Data Quality
2 2 (2.56%) Solvency II
3 1 (1.28%) QA
Vendors
1 37 (47.44%) Microsoft
2 13 (16.67%) Oracle
3 5 (6.41%) Cognos
3 5 (6.41%) Informatica
3 5 (6.41%) Tableau
4 4 (5.13%) SAP
5 3 (3.85%) Talend
5 3 (3.85%) Teradata
5 3 (3.85%) Business Objects
6 2 (2.56%) Hyperion
7 1 (1.28%) IBM
7 1 (1.28%) PeopleSoft
7 1 (1.28%) Sybase
7 1 (1.28%) ION Trading
7 1 (1.28%) MicroStrategy
City, London
Networking People
Rate: £600 - £750 per day
Posted: 2 days ago
City of London
Venturi
Rate: £300 - £400 per day
Posted: 2 days ago
City of London
Venturi
Rate: £350 - £425 per day
Posted: 2 days ago
City of London
Hays IT - Uk Posting account
Rate: £450.00 - £500.00 per day
Posted: 13 days ago
City of London
Huxley Banking & Financial Services
Rate: £600 - £700 per day + competitive
Posted: 25 days ago
City of London
Computer Futures
Rate: £390 - £460 per day
Posted: 27 days ago
City of London
Nigel Frank International Limited - Newcastle
Rate: £430 - £480 per day
Posted: 27 days ago