Period
to 19 February 2018

The following table provides summary statistics for contract job vacancies advertised in the City of London with a requirement for Data Warehouse skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Warehouse over the 6 months to 19 February 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Data Warehousing
Central London > City of London
6 months to
19 Feb 2018
Same period 2017 Same period 2016
Rank 82 49 33
Rank change year-on-year -33 -16 +14
Contract jobs citing Data Warehouse 212 258 340
As % of all contract IT jobs advertised in the City of London 3.00% 4.25% 5.04%
As % of the Database & Business Intelligence category 12.33% 15.20% 19.14%
Number of daily rates quoted 186 197 268
City of London median daily rate £485 £450 £475
Median daily rate % change year-on-year +7.78% -5.26% +8.20%
10th Percentile £400 £379 £363
90th Percentile £675 £638 £629
Central London median daily rate £480 £450 £475
% change year-on-year +6.67% -5.26% +8.57%
Number of hourly rates quoted 1 0 0
City of London median hourly rate £28.00 - -
Central London median hourly rate £28.00 - -

Data Warehouse is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Contract vacancies with a requirement for database or business intelligence skills 1,719 1,697 1,776
As % of all contract IT jobs advertised in the City of London 24.35% 27.93% 26.32%
Number of daily rates quoted 1,466 1,366 1,446
City of London median daily rate £525 £475 £475
Median daily rate % change year-on-year +10.53% - +11.44%
10th Percentile £363 £325 £313
90th Percentile £688 £663 £638
Central London median daily rate £513 £475 £475
% change year-on-year +7.89% - +11.76%
Number of hourly rates quoted 7 2 4
City of London median hourly rate £27.50 £33.67 £46.25
Median hourly rate % change year-on-year -18.32% -27.21% +28.47%
10th Percentile £19.37 £23.75 £24.35
90th Percentile £48.76 £45.05 £60.00
Central London median hourly rate £27.50 £33.67 £29.74
% change year-on-year -18.32% +13.22% +14.38%

Data Warehouse
Job Vacancy Trend in the City of London

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for Data Warehouse in the City of London

Data Warehouse
Contractor Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Data Warehouse in the City of London.

Contractor daily rate trend for Data Warehouse in the City of London

Data Warehouse
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing Data Warehouse in the City of London over the 6 months to 19 February 2018.

Contractor daily rate histogram for Data Warehouse in the City of London

Data Warehouse
Contractor Hourly Rate Trend in the City of London

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

Contractor hourly rate trend for Data Warehouse in the City of London

For the 6 months to 19 February 2018, IT contractor jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the City of London region with a requirement for Data Warehouse.

1 151 (71.23%) Business Intelligence
2 142 (66.98%) SQL
3 97 (45.75%) ETL
4 90 (42.45%) SQL Server
5 79 (37.26%) SQL Server Integration Services
6 66 (31.13%) Finance
7 59 (27.83%) Microsoft
7 59 (27.83%) SQL Server Reporting Services
8 52 (24.53%) SQL Server Analysis Services
9 47 (22.17%) Agile Software Development
10 46 (21.70%) Data Modelling
11 39 (18.40%) T-SQL
11 39 (18.40%) Big Data
12 37 (17.45%) Hadoop
13 36 (16.98%) Analytics
13 36 (16.98%) Oracle
14 35 (16.51%) Python
15 33 (15.57%) Kimball Methodology
16 31 (14.62%) Microsoft Azure
17 29 (13.68%) Power BI
18 26 (12.26%) ETL Development
18 26 (12.26%) Relational Database
19 25 (11.79%) Apache Spark
20 24 (11.32%) Analytical Skills
20 24 (11.32%) Migration
21 23 (10.85%) Java
22 22 (10.38%) Stakeholder Management
22 22 (10.38%) Tableau
23 20 (9.43%) Data Engineering
23 20 (9.43%) DevOps

Data Warehouse
Co-occurring IT Skills in the City of 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 25 (11.79%) Apache Spark
2 8 (3.77%) Apache Pig
3 7 (3.30%) Apache
3 7 (3.30%) SAS
4 6 (2.83%) SharePoint
5 1 (0.47%) Apache Solr
5 1 (0.47%) BizTalk Server
5 1 (0.47%) Confluence
5 1 (0.47%) Elasticsearch
Applications
1 7 (3.30%) Microsoft Excel
2 6 (2.83%) Microsoft Office
3 2 (0.94%) MS Visio
4 1 (0.47%) Microsoft PowerPoint
Business Applications
1 2 (0.94%) Dynamics AX
1 2 (0.94%) Dynamics CRM
1 2 (0.94%) Dynamics NAV
1 2 (0.94%) Markit EDM
2 1 (0.47%) Dynamics GP
2 1 (0.47%) Eagle PACE
2 1 (0.47%) HFM
2 1 (0.47%) thinkFolio
2 1 (0.47%) Unit4 Business World
Cloud Services
1 31 (14.62%) Microsoft Azure
2 11 (5.19%) Amazon AWS
3 5 (2.36%) Google Cloud Platform
3 5 (2.36%) PaaS
4 4 (1.89%) Amazon S3
4 4 (1.89%) GitHub
4 4 (1.89%) SaaS
5 2 (0.94%) Amazon EMR
5 2 (0.94%) AWS Data Pipeline
5 2 (0.94%) Cloud Computing
6 1 (0.47%) Amazon Kinesis
6 1 (0.47%) Azure Data Factory
6 1 (0.47%) Dynamics 365
6 1 (0.47%) IaaS
6 1 (0.47%) Office 365
Communications & Networking
1 4 (1.89%) Intranet
2 2 (0.94%) Wireshark
3 1 (0.47%) Internet
3 1 (0.47%) SMS
Database & Business Intelligence
1 90 (42.45%) SQL Server
2 79 (37.26%) SQL Server Integration Services
3 59 (27.83%) SQL Server Reporting Services
4 52 (24.53%) SQL Server Analysis Services
5 39 (18.40%) Big Data
6 37 (17.45%) Hadoop
7 29 (13.68%) Power BI
8 26 (12.26%) Relational Database
9 20 (9.43%) Apache Hive
10 18 (8.49%) BusinessObjects
10 18 (8.49%) QlikView
11 16 (7.55%) RDBMS
12 14 (6.60%) Oracle Database
13 13 (6.13%) Data Lake
13 13 (6.13%) OLAP
13 13 (6.13%) PostgreSQL
13 13 (6.13%) SQL Server 2008
14 12 (5.66%) MongoDB
14 12 (5.66%) SQL Server 2014
14 12 (5.66%) SQL Server 2016
Development Applications
1 12 (5.66%) Team Foundation Server
2 8 (3.77%) Git (software)
2 8 (3.77%) Jenkins
3 6 (2.83%) ERwin
3 6 (2.83%) TeamCity
4 5 (2.36%) JIRA
4 5 (2.36%) JUnit
4 5 (2.36%) Visual Studio
5 4 (1.89%) Subversion
6 2 (0.94%) Cucumber
6 2 (0.94%) SoapUI
6 2 (0.94%) Toad
7 1 (0.47%) Bitbucket
7 1 (0.47%) Eclipse
7 1 (0.47%) FitNesse
7 1 (0.47%) HP UFT
7 1 (0.47%) Selenium
7 1 (0.47%) SQL Server Management Studio (SSMS)
7 1 (0.47%) WebDriver
7 1 (0.47%) XMLSpy
General
1 66 (31.13%) Finance
2 19 (8.96%) Retail
3 15 (7.08%) Banking
4 8 (3.77%) Marketing
5 6 (2.83%) Investment Banking
6 4 (1.89%) Advertising
6 4 (1.89%) Legal
6 4 (1.89%) Publishing
7 3 (1.42%) Front Office
8 2 (0.94%) Back Office
8 2 (0.94%) Law
9 1 (0.47%) Financial Institution
9 1 (0.47%) General Ledger
9 1 (0.47%) German Language
9 1 (0.47%) International Banking
9 1 (0.47%) Retail Banking
Job Titles
1 84 (39.62%) Developer
2 42 (19.81%) Business Intelligence Developer
3 39 (18.40%) Analyst
4 26 (12.26%) SQL Developer
5 21 (9.91%) SSIS Developer
6 20 (9.43%) Architect
6 20 (9.43%) Business Intelligence Analyst
7 18 (8.49%) Business Analyst
8 16 (7.55%) Data Architect
8 16 (7.55%) Data Engineer
9 15 (7.08%) SSRS Developer
10 13 (6.13%) Consultant
10 13 (6.13%) SSAS Developer
11 12 (5.66%) Data Warehouse Developer
11 12 (5.66%) SQL BI Developer
12 11 (5.19%) Business Developer
13 10 (4.72%) Business Intelligence Business Analyst
13 10 (4.72%) Project Manager
14 9 (4.25%) SQL Analyst
15 8 (3.77%) Data Consultant
Libraries, Frameworks & Software Standards
1 16 (7.55%) MDX
2 15 (7.08%) .NET
3 14 (6.60%) Kafka
4 12 (5.66%) PySpark
5 9 (4.25%) XML
6 5 (2.36%) Keras
6 5 (2.36%) MLlib
6 5 (2.36%) scikit-learn
6 5 (2.36%) TensorFlow
7 4 (1.89%) JSON
7 4 (1.89%) SOAP
8 3 (1.42%) Web Services
9 2 (0.94%) CSS
9 2 (0.94%) D3.js
9 2 (0.94%) HTML
9 2 (0.94%) jQuery
9 2 (0.94%) Natural Language Processing
9 2 (0.94%) XSD
10 1 (0.47%) WCF
10 1 (0.47%) WPF
Miscellaneous
1 24 (11.32%) Analytical Skills
2 9 (4.25%) Reinsurance
3 8 (3.77%) Greenfield Project
4 7 (3.30%) Computer Science
5 5 (2.36%) Fixed Income
6 4 (1.89%) Data Centre
6 4 (1.89%) Data Structures
7 3 (1.42%) Derivative
7 3 (1.42%) Equities
7 3 (1.42%) Mobile App
7 3 (1.42%) NHS
8 2 (0.94%) Credit Risk
8 2 (0.94%) Foreign Exchange (FX)
8 2 (0.94%) Hedge funds
8 2 (0.94%) iPad
8 2 (0.94%) Management Information System
8 2 (0.94%) Market Risk
8 2 (0.94%) Replication
8 2 (0.94%) User Experience
9 1 (0.47%) Social Media
Operating Systems
1 10 (4.72%) Linux
2 9 (4.25%) Unix
3 8 (3.77%) Windows
4 5 (2.36%) Windows Server
5 1 (0.47%) CentOS
5 1 (0.47%) Red Hat Enterprise Linux
5 1 (0.47%) Windows Server 2008
5 1 (0.47%) Windows Server 2012
Processes & Methodologies
1 151 (71.23%) Business Intelligence
2 97 (45.75%) ETL
3 47 (22.17%) Agile Software Development
4 46 (21.70%) Data Modelling
5 36 (16.98%) Analytics
6 33 (15.57%) Kimball Methodology
7 26 (12.26%) ETL Development
8 24 (11.32%) Migration
9 22 (10.38%) Stakeholder Management
10 20 (9.43%) Data Engineering
10 20 (9.43%) DevOps
11 19 (8.96%) Data Analysis
11 19 (8.96%) Data Migration
11 19 (8.96%) Dimensional Modelling
12 17 (8.02%) Data Management
13 14 (6.60%) Visualisation
14 13 (6.13%) Continuous Integration
14 13 (6.13%) Data Visualisation
14 13 (6.13%) SDLC
15 12 (5.66%) Open Source
Programming Languages
1 142 (66.98%) SQL
2 39 (18.40%) T-SQL
3 35 (16.51%) Python
4 23 (10.85%) Java
5 19 (8.96%) PL/SQL
5 19 (8.96%) Shell Script
6 12 (5.66%) C#
7 9 (4.25%) R
8 7 (3.30%) Scala
9 4 (1.89%) Data Analysis Expressions (DAX)
9 4 (1.89%) VB.NET
10 3 (1.42%) C
10 3 (1.42%) JavaScript
10 3 (1.42%) VB
11 2 (0.94%) Bash Shell
11 2 (0.94%) C++
11 2 (0.94%) Perl
11 2 (0.94%) SAS Macro
12 1 (0.47%) Groovy
12 1 (0.47%) PHP
Qualifications
1 10 (4.72%) Degree
2 3 (1.42%) Computer Science Degree
2 3 (1.42%) ITIL Certification
2 3 (1.42%) PMP
3 2 (0.94%) PMI Certification
4 1 (0.47%) ACCA
4 1 (0.47%) CIMA
4 1 (0.47%) ISEB
4 1 (0.47%) Numerate Degree
4 1 (0.47%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 13 (6.13%) QA
2 8 (3.77%) Data Quality
3 3 (1.42%) GCP
3 3 (1.42%) GDPR
4 2 (0.94%) Solvency II
System Software
1 20 (9.43%) Apache Flume
2 18 (8.49%) HDFS
3 9 (4.25%) Docker
Systems Management
1 13 (6.13%) Oozie
2 10 (4.72%) Ambari
3 7 (3.30%) Puppet
4 6 (2.83%) Ansible
5 5 (2.36%) Hadoop YARN
5 5 (2.36%) Terraform
6 4 (1.89%) Opscode Chef
7 2 (0.94%) Control-M
7 2 (0.94%) Rundeck
8 1 (0.47%) Systems Management Server (SMS)
Vendors
1 59 (27.83%) Microsoft
2 36 (16.98%) Oracle
3 22 (10.38%) Tableau
4 18 (8.49%) Informatica
5 11 (5.19%) IBM
6 9 (4.25%) Hortonworks
7 8 (3.77%) Cloudera
8 6 (2.83%) Cognos
8 6 (2.83%) Google
9 5 (2.36%) MapR
10 4 (1.89%) Netezza
10 4 (1.89%) Salesforce.com
10 4 (1.89%) Vertica
11 3 (1.42%) CheckPoint
11 3 (1.42%) F5
11 3 (1.42%) SAP
12 2 (0.94%) BMC
12 2 (0.94%) PeopleSoft
12 2 (0.94%) Sybase
12 2 (0.94%) Talend