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 30 July 2016 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
30 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 369 324 334
Rank change year-on-year
-45 +10
Contract jobs citing OLAP 67 110 96
As % of all contract IT jobs located in London 0.30% 0.47% 0.41%
As % of the Database & Business Intelligence category 1.34% 1.98% 1.73%
Number of daily rates quoted 55 83 66
Median daily rate £450 £438 £438
Median daily rate % change year-on-year
+2.85% -
90% offered a daily rate of more than £335 £325 £316
10% offered a daily rate of more than £590 £610 £600
UK excluding London median daily rate £406 £425 £338
% change year-on-year
-4.52% +25.92%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -
OLAP
England

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
5007 5546 5540
As % of all contract IT jobs located in London 22.62% 23.55% 23.47%
Number of daily rates quoted 3612 3874 3762
Median daily rate £475 £450 £438
Median daily rate % change year-on-year
+5.55% +2.85%
90% offered a daily rate of more than £330 £308 £300
10% offered a daily rate of more than £615 £600 £600
UK excluding London median daily rate £375 £363 £350
% change year-on-year
+3.44% +3.57%
Number of hourly rates quoted 15 55 36
Median hourly rate £29.88 £25.00 £27.50
Median hourly rate % change year-on-year
+19.52% -9.09%
90% offered a hourly rate of more than £20.12 £16.25 £15.00
10% offered a hourly rate of more than £180.90 £52.17 £125.00
UK excluding London median hourly rate £28.50 £28.06 £28.50
% change year-on-year
+1.55% -1.53%

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 30 July 2016.

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 30 July 2016. 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
(Click see detailed
statistics and trends)
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 +15 14 £475 +7.04% 4
Canary Wharf - 3 £475 -
Paddington - 1 £198 -
OLAP
England

OLAP
Top 30 Related IT Skills in London

For the 6 months to 30 July 2016, 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 85 (69.67%) Business Intelligence
2 79 (64.75%) SQL
3 76 (62.30%) SQL Server
4 60 (49.18%) Data Warehouse
4 60 (49.18%) SQL Server Analysis Services
5 57 (46.72%) Microsoft
6 54 (44.26%) SQL Server Integration Services
7 51 (41.80%) ETL
8 46 (37.70%) Finance
8 46 (37.70%) SQL Server Reporting Services
9 43 (35.25%) Agile Software Development
10 35 (28.69%) MDX
11 34 (27.87%) OLAP Cube
12 29 (23.77%) Oracle
13 27 (22.13%) SQL Server 2012
14 25 (20.49%) Oracle OLAP
15 24 (19.67%) Banking
15 24 (19.67%) Data Modelling
15 24 (19.67%) MS Excel
16 22 (18.03%) SQL Server 2008
17 21 (17.21%) Java
17 21 (17.21%) Microsoft Analysis Services
18 19 (15.57%) Performance Tuning
19 18 (14.75%) Analytics
19 18 (14.75%) SQL Server 2014
20 16 (13.11%) Tableau
20 16 (13.11%) Kimball Methodology
20 16 (13.11%) BusinessObjects
21 15 (12.30%) T-SQL
21 15 (12.30%) 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 9 (7.38%) IIS
2 7 (5.74%) SharePoint
3 3 (2.46%) Apache
3 3 (2.46%) Oracle Coherence
4 2 (1.64%) Apache Spark
4 2 (1.64%) Oracle Application Server
4 2 (1.64%) SAS
4 2 (1.64%) SharePoint 2010
5 1 (0.82%) Confluence
5 1 (0.82%) Facebook Platform
5 1 (0.82%) Oracle HTTP Server
5 1 (0.82%) Tomcat
5 1 (0.82%) WebSphere
Applications
1 24 (19.67%) MS Excel
2 3 (2.46%) MS Visio
3 2 (1.64%) MS PowerPoint
3 2 (1.64%) SPSS
4 1 (0.82%) MS Office
4 1 (0.82%) Spreadsheet
Business Applications
1 4 (3.28%) Global One
2 2 (1.64%) Cognos TM1
3 1 (0.82%) Oracle EBS
3 1 (0.82%) Radian6
3 1 (0.82%) SAP Oil and Gas
3 1 (0.82%) SunGard Martini
3 1 (0.82%) SystmOne
3 1 (0.82%) WebTrends
Cloud Services
1 14 (11.48%) Microsoft Azure
2 11 (9.02%) IaaS
2 11 (9.02%) PaaS
3 2 (1.64%) Amazon AWS
4 1 (0.82%) AdWords
4 1 (0.82%) Azure Machine Learning
4 1 (0.82%) Cloud Computing
4 1 (0.82%) Data Lake Analytics
4 1 (0.82%) Google Analytics
Communications & Networking
1 10 (8.20%) Network Security
2 6 (4.92%) SAN
3 2 (1.64%) Internet
4 1 (0.82%) FCoE
4 1 (0.82%) Fibre Channel
4 1 (0.82%) HTTP
4 1 (0.82%) iSCSI
4 1 (0.82%) LAN
4 1 (0.82%) Multicast
4 1 (0.82%) NAS
4 1 (0.82%) WAN
Database & Business Intelligence
1 76 (62.30%) SQL Server
2 60 (49.18%) Data Warehouse
2 60 (49.18%) SQL Server Analysis Services
3 54 (44.26%) SQL Server Integration Services
4 46 (37.70%) SQL Server Reporting Services
5 34 (27.87%) OLAP Cube
6 27 (22.13%) SQL Server 2012
7 25 (20.49%) Oracle OLAP
8 22 (18.03%) SQL Server 2008
9 21 (17.21%) Microsoft Analysis Services
10 18 (14.75%) SQL Server 2014
11 16 (13.11%) BusinessObjects
12 14 (11.48%) OLTP
13 13 (10.66%) Power BI
14 10 (8.20%) SQL Server 2016
15 9 (7.38%) Big Data
15 9 (7.38%) PowerPivot
15 9 (7.38%) Relational Database
16 8 (6.56%) Oracle Database
16 8 (6.56%) Star Schema
Development Applications
1 8 (6.56%) Jenkins
2 6 (4.92%) Visual Studio
3 5 (4.10%) NUnit
3 5 (4.10%) SpecFlow
4 3 (2.46%) JUnit
4 3 (2.46%) Team Foundation Server
5 2 (1.64%) Bitbucket
5 2 (1.64%) PowerDesigner
5 2 (1.64%) Talend Open Studio
6 1 (0.82%) Git (software)
6 1 (0.82%) JIRA
6 1 (0.82%) Visual Studio Tools for Office
General
1 46 (37.70%) Finance
2 24 (19.67%) Banking
3 10 (8.20%) Investment Banking
4 4 (3.28%) Advertising
4 4 (3.28%) Financial Institution
4 4 (3.28%) Front Office
4 4 (3.28%) Retail
5 3 (2.46%) Marketing
6 2 (1.64%) Back Office
6 2 (1.64%) French Language
6 2 (1.64%) Publishing
6 2 (1.64%) Telecoms
7 1 (0.82%) Electronics
7 1 (0.82%) International Banking
7 1 (0.82%) Legal
7 1 (0.82%) Manufacturing
Job Titles
1 78 (63.93%) Developer
2 35 (28.69%) Business Intelligence Developer
3 28 (22.95%) SQL Developer
4 22 (18.03%) SSAS Developer
5 17 (13.93%) SQL BI Developer
6 13 (10.66%) Senior Developer
7 12 (9.84%) Data Warehouse Developer
7 12 (9.84%) DBA
7 12 (9.84%) SSIS Developer
8 11 (9.02%) Analyst
8 11 (9.02%) SSRS Developer
9 10 (8.20%) Architect
9 10 (8.20%) Java Developer
10 9 (7.38%) Senior Support Engineer
10 9 (7.38%) Support Engineer
11 7 (5.74%) Business Developer
11 7 (5.74%) Microsoft Developer
11 7 (5.74%) Oracle Developer
11 7 (5.74%) Senior Java Developer
12 6 (4.92%) .NET Developer
Libraries, Frameworks & Software Standards
1 35 (28.69%) MDX
2 13 (10.66%) .NET
3 8 (6.56%) ASP.NET
4 6 (4.92%) HTML
4 6 (4.92%) REST
5 5 (4.10%) HTML5
5 5 (4.10%) Middleware
6 4 (3.28%) Java Concurrency
7 2 (1.64%) AngularJS
7 2 (1.64%) Apache Camel
7 2 (1.64%) Kafka
7 2 (1.64%) Oracle GoldenGate
7 2 (1.64%) Oracle Streams
7 2 (1.64%) Web Services
7 2 (1.64%) XML
8 1 (0.82%) ActiveMQ
8 1 (0.82%) FIX Protocol
8 1 (0.82%) Hibernate
8 1 (0.82%) JSON
8 1 (0.82%) Spring
Miscellaneous
1 15 (12.30%) Analytical Skills
2 8 (6.56%) Data Structures
3 7 (5.74%) Data Integration
3 7 (5.74%) Replication
4 6 (4.92%) Credit Risk
4 6 (4.92%) Visualisation
5 5 (4.10%) Digital Media
5 5 (4.10%) Foreign Exchange (FX)
6 4 (3.28%) Management Information System
7 3 (2.46%) Algorithms
7 3 (2.46%) Client/Server
7 3 (2.46%) Clustering
8 2 (1.64%) Computer Science
8 2 (1.64%) Enterprise Software
8 2 (1.64%) Fixed Income
8 2 (1.64%) Virtual Team
9 1 (0.82%) Economics
9 1 (0.82%) Market Risk
9 1 (0.82%) Mathematics
9 1 (0.82%) Statistics
Operating Systems
1 9 (7.38%) Linux
1 9 (7.38%) VMS
2 4 (3.28%) Unix
2 4 (3.28%) Windows
3 2 (1.64%) Windows Server
4 1 (0.82%) Solaris
4 1 (0.82%) Windows Server 2008
4 1 (0.82%) Windows Server 2012
Processes & Methodologies
1 85 (69.67%) Business Intelligence
2 51 (41.80%) ETL
3 43 (35.25%) Agile Software Development
4 24 (19.67%) Data Modelling
5 19 (15.57%) Performance Tuning
6 18 (14.75%) Analytics
7 16 (13.11%) Kimball Methodology
8 15 (12.30%) Dimensional Modelling
9 12 (9.84%) Migration
10 11 (9.02%) Low Latency
11 9 (7.38%) Load Balancing
11 9 (7.38%) TDD
12 8 (6.56%) Risk Management
13 7 (5.74%) Continuous Integration
13 7 (5.74%) Scrum
13 7 (5.74%) Stakeholder Management
14 6 (4.92%) Business Analysis
14 6 (4.92%) Dashboard Development
14 6 (4.92%) Line Management
15 5 (4.10%) Incident Management
Programming Languages
1 79 (64.75%) SQL
2 21 (17.21%) Java
3 15 (12.30%) T-SQL
4 14 (11.48%) C#
5 6 (4.92%) PL/SQL
6 5 (4.10%) MATLAB
6 5 (4.10%) VB.NET
7 4 (3.28%) PowerShell
7 4 (3.28%) Shell Script
8 3 (2.46%) Data Analysis Expressions (DAX)
8 3 (2.46%) JavaScript
8 3 (2.46%) VBA
9 2 (1.64%) R
10 1 (0.82%) PHP
10 1 (0.82%) Python
10 1 (0.82%) Scala
Qualifications
1 4 (3.28%) Degree
2 2 (1.64%) DV Cleared
2 2 (1.64%) Security Cleared
3 1 (0.82%) MBA
Quality Assurance & Compliance
1 9 (7.38%) Data Quality
2 4 (3.28%) QA
3 1 (0.82%) PCI DSS
3 1 (0.82%) SLA
System Software
1 9 (7.38%) Virtual Servers
2 8 (6.56%) Microsoft Virtual Server
3 3 (2.46%) Oracle RAC
4 2 (1.64%) Docker
5 1 (0.82%) Hyper-V
5 1 (0.82%) KVM
5 1 (0.82%) NFS
5 1 (0.82%) SRDF
5 1 (0.82%) Virtual Machines
5 1 (0.82%) VMware Infrastructure
5 1 (0.82%) Xen
Systems Management
1 2 (1.64%) Data Guard
1 2 (1.64%) Oracle RMAN
2 1 (0.82%) HP Quality Center
2 1 (0.82%) Puppet
Vendors
1 57 (46.72%) Microsoft
2 29 (23.77%) Oracle
3 16 (13.11%) Tableau
4 10 (8.20%) Informatica
5 9 (7.38%) SAP
6 6 (4.92%) Sybase
7 5 (4.10%) Teradata
8 4 (3.28%) MicroStrategy
9 3 (2.46%) Cognos
9 3 (2.46%) EMC
9 3 (2.46%) IBM
9 3 (2.46%) Red Hat
9 3 (2.46%) Vertica
10 2 (1.64%) Cadence
10 2 (1.64%) Talend
11 1 (0.82%) DoubleClick
11 1 (0.82%) ION Trading
11 1 (0.82%) Omniture
11 1 (0.82%) Sophis
11 1 (0.82%) VMware
London
McGregor Boyall
Rate: £450 per day
Posted: 3 days ago
London
TEKsystems
Rate: £500 - £600 per day
Posted: 4 days ago