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 4 September 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
4 Sep 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 163 181 148
Rank change year-on-year
+18 -33
Contract jobs citing OLAP 33 23 78
As % of all contract IT jobs located in the City of London 0.63% 0.40% 1.09%
As % of the Database & Business Intelligence category 2.41% 1.73% 4.63%
Number of daily rates quoted 30 17 60
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£438 £425 £450
Average daily rate % change year-on-year
+2.94% -5.55%
90% offered a daily rate of more than £325 £325 £300
10% offered a daily rate of more than £500 £635 £550
UK excluding London average daily rate £400 £350 £363
% change year-on-year
+14.28% -3.44%
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
1372 1331 1683
As % of all contract IT jobs located in the City of London 26.08% 22.92% 23.55%
Number of daily rates quoted 1082 992 1246
Average daily rate £475 £450 £450
Average daily rate % change year-on-year
+5.55% -
90% offered a daily rate of more than £325 £325 £315
10% offered a daily rate of more than £625 £575 £600
UK excluding London average daily rate £375 £350 £350
% change year-on-year
+7.14% -
Number of hourly rates quoted 6 6 13
Average hourly rate £25.00 £38.66 £35.00
Average hourly rate % change year-on-year
-35.33% +10.45%
90% offered a hourly rate of more than £19.90 £24.40 £18.80
10% offered a hourly rate of more than £99.00 £47.07 £59.87
UK excluding London average hourly rate £33.55 £31.80 £32.50
% change year-on-year
+5.51% -2.16%

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 4 September 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 4 September 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 72 (76.60%) Business Intelligence
2 67 (71.28%) SQL
3 65 (69.15%) SQL Server Integration Services
4 63 (67.02%) ETL
5 60 (63.83%) Data Warehouse
5 60 (63.83%) SQL Server
6 58 (61.70%) SQL Server Analysis Services
7 57 (60.64%) SQL Server Reporting Services
8 44 (46.81%) T-SQL
9 39 (41.49%) Microsoft
10 33 (35.11%) Finance
11 27 (28.72%) MDX
12 25 (26.60%) Agile Software Development
12 25 (26.60%) C#
13 23 (24.47%) OLAP Cube
14 21 (22.34%) SQL Server 2012
14 21 (22.34%) .NET
15 19 (20.21%) Data Modelling
15 19 (20.21%) MS Excel
15 19 (20.21%) Kimball Methodology
16 18 (19.15%) BusinessObjects
17 16 (17.02%) Oracle
17 16 (17.02%) Relational Database
17 16 (17.02%) Oracle OLAP
18 15 (15.96%) Solvency II
19 13 (13.83%) Banking
20 12 (12.77%) Microsoft Analysis Services
20 12 (12.77%) NHS
20 12 (12.77%) Oracle Database
21 11 (11.70%) ETL Development

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

For the 6 months to 4 September 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 (7.45%) SharePoint
2 4 (4.26%) SAS
3 2 (2.13%) SharePoint Server
3 2 (2.13%) Oracle Coherence
3 2 (2.13%) Apache Spark
4 1 (1.06%) IIS
4 1 (1.06%) GemFire
Applications
1 19 (20.21%) MS Excel
2 10 (10.64%) PowerPivot
3 6 (6.38%) MS Office
4 2 (2.13%) Spreadsheet
5 1 (1.06%) MS Visio
Business Applications
1 4 (4.26%) Oracle Applications
2 2 (2.13%) Dynamics AX
3 1 (1.06%) ION MarketView
3 1 (1.06%) HFM
3 1 (1.06%) Endur
Database & Business Intelligence
1 65 (69.15%) SQL Server Integration Services
2 60 (63.83%) SQL Server
2 60 (63.83%) Data Warehouse
3 58 (61.70%) SQL Server Analysis Services
4 57 (60.64%) SQL Server Reporting Services
5 23 (24.47%) OLAP Cube
6 21 (22.34%) SQL Server 2012
7 18 (19.15%) BusinessObjects
8 16 (17.02%) Relational Database
8 16 (17.02%) Oracle OLAP
9 12 (12.77%) Oracle Database
9 12 (12.77%) Microsoft Analysis Services
10 10 (10.64%) OLTP
10 10 (10.64%) QlikView
11 9 (9.57%) SQL Server 2008
11 9 (9.57%) Data Mart
12 8 (8.51%) Data Mining
12 8 (8.51%) Oracle Database 11g
12 8 (8.51%) Oracle Database 12c
12 8 (8.51%) Microsoft Power View
Development Applications
1 7 (7.45%) Visual Studio
1 7 (7.45%) Team Foundation Server
2 6 (6.38%) ERwin
3 2 (2.13%) Maven
4 1 (1.06%) JIRA
4 1 (1.06%) Oracle Forms
4 1 (1.06%) Visual Studio Tools for Office
4 1 (1.06%) SQL Server Management Studio (SSMS)
4 1 (1.06%) JUnit
General
1 33 (35.11%) Finance
2 13 (13.83%) Banking
3 10 (10.64%) Retail
3 10 (10.64%) Advertising
4 8 (8.51%) Marketing
4 8 (8.51%) Legal
5 4 (4.26%) Investment Banking
6 3 (3.19%) Financial Institution
7 2 (2.13%) Law
Job Titles
1 86 (91.49%) Developer
2 50 (53.19%) Business Intelligence Developer
3 20 (21.28%) SQL Developer
4 12 (12.77%) Data Warehouse Developer
5 11 (11.70%) Senior Developer
6 9 (9.57%) Business Developer
7 8 (8.51%) Oracle Developer
7 8 (8.51%) Microsoft Developer
7 8 (8.51%) TM1 Developer
8 7 (7.45%) Senior Business Intelligence Developer
8 7 (7.45%) SQL Server Developer
9 3 (3.19%) Business Objects Developer
9 3 (3.19%) SAS Developer
9 3 (3.19%) Senior Oracle Developer
9 3 (3.19%) ETL Developer
9 3 (3.19%) Java Developer
9 3 (3.19%) Analyst
10 2 (2.13%) Technical Analyst
10 2 (2.13%) Report Developer
10 2 (2.13%) SAS BI Developer
Libraries, Frameworks & Software Standards
1 27 (28.72%) MDX
2 21 (22.34%) .NET
3 4 (4.26%) XML
4 3 (3.19%) HTML
4 3 (3.19%) Spring
5 2 (2.13%) ActiveMQ
5 2 (2.13%) WPF
6 1 (1.06%) jQuery
6 1 (1.06%) ASP.NET 2.0
6 1 (1.06%) HTML5
6 1 (1.06%) REST
6 1 (1.06%) Akka
6 1 (1.06%) Play Framework
6 1 (1.06%) JSON
6 1 (1.06%) XSD
6 1 (1.06%) XSLT
6 1 (1.06%) ASP.NET
Miscellaneous
1 12 (12.77%) NHS
2 7 (7.45%) Analytical Skills
3 6 (6.38%) Clustering
4 4 (4.26%) Credit Risk
4 4 (4.26%) Market Risk
5 3 (3.19%) Data Structures
5 3 (3.19%) Foreign Exchange (FX)
6 2 (2.13%) Visualisation
6 2 (2.13%) Digital Media
6 2 (2.13%) Contract for Difference
6 2 (2.13%) Equities
6 2 (2.13%) Management Information System
7 1 (1.06%) Replication
7 1 (1.06%) Fixed Income
7 1 (1.06%) Grid Computing
7 1 (1.06%) Credit Derivative
7 1 (1.06%) Derivative
7 1 (1.06%) Informatics
7 1 (1.06%) Computer Science
7 1 (1.06%) N-Tier
Operating Systems
1 8 (8.51%) Windows
2 6 (6.38%) Linux
3 3 (3.19%) UNIX
4 1 (1.06%) Windows Server 2008
4 1 (1.06%) Windows Server 2012
Processes & Methodologies
1 72 (76.60%) Business Intelligence
2 63 (67.02%) ETL
3 25 (26.60%) Agile Software Development
4 19 (20.21%) Data Modelling
4 19 (20.21%) Kimball Methodology
5 11 (11.70%) ETL Development
5 11 (11.70%) Scrum
6 10 (10.64%) Stakeholder Management
6 10 (10.64%) Dimensional Modelling
7 9 (9.57%) Data Architecture
7 9 (9.57%) Performance Tuning
8 8 (8.51%) Migration
8 8 (8.51%) Change Management
9 7 (7.45%) Test Automation
10 6 (6.38%) Data Management
10 6 (6.38%) TDD
11 5 (5.32%) Data Migration
11 5 (5.32%) Master Data Management
12 4 (4.26%) Inmon Methodology
12 4 (4.26%) Database Security
Programming Languages
1 67 (71.28%) SQL
2 44 (46.81%) T-SQL
3 25 (26.60%) C#
4 9 (9.57%) PL/SQL
5 8 (8.51%) C
5 8 (8.51%) VB.NET
6 6 (6.38%) PowerShell
6 6 (6.38%) Data Analysis Expressions (DAX)
6 6 (6.38%) Java
7 4 (4.26%) VBA
8 2 (2.13%) VB
9 1 (1.06%) JavaScript
9 1 (1.06%) Perl
9 1 (1.06%) C++
9 1 (1.06%) Python
9 1 (1.06%) Shell Script
9 1 (1.06%) Data Mining Extensions (DMX)
9 1 (1.06%) Scala
Qualifications
1 4 (4.26%) Microsoft Certification
1 4 (4.26%) OCP
1 4 (4.26%) Oracle Certification
2 1 (1.06%) PMI Certification
Quality Assurance & Compliance
1 15 (15.96%) Solvency II
2 6 (6.38%) Data Quality
3 2 (2.13%) QA
4 1 (1.06%) Basel III
4 1 (1.06%) Dodd-Frank
4 1 (1.06%) PMBOK
System Software
1 1 (1.06%) Apache Flume
1 1 (1.06%) HDFS
Systems Management
1 1 (1.06%) Oozie
Vendors
1 39 (41.49%) Microsoft
2 16 (17.02%) Oracle
3 8 (8.51%) SAP
4 7 (7.45%) Tableau
5 3 (3.19%) Cognos
5 3 (3.19%) Informatica
5 3 (3.19%) MicroStrategy
6 2 (2.13%) Teradata
6 2 (2.13%) IBM
7 1 (1.06%) Sybase
7 1 (1.06%) ION Trading
7 1 (1.06%) Netezza
7 1 (1.06%) FactSet
7 1 (1.06%) Actian
7 1 (1.06%) Hyperion
City of London
Nigel Frank International Limited - Newcastle
Rate: £400 - £550 per day
Posted: 17 days ago
City of London
Venturi
Rate: £250 - £350 per day + DOE
Posted: 25 days ago