Period
to 24 May 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 24 May 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
24 May 2018
Same period 2017 Same period 2016
Rank 83 58 45
Rank change year-on-year -25 -13 -8
Contract jobs citing Data Warehouse 203 232 272
As % of all contract IT jobs advertised in the City of London 2.93% 3.77% 4.21%
As % of the Database & Business Intelligence category 11.59% 13.61% 16.17%
Number of daily rates quoted 173 180 204
City of London median daily rate £485 £475 £475
Median daily rate % change year-on-year +2.11% - +5.56%
10th Percentile £375 £387 £363
90th Percentile £610 £651 £659
Central London median daily rate £500 £475 £475
% change year-on-year +5.26% - +5.56%
Number of hourly rates quoted 0 0 0
City of London median hourly rate - - -
Central London median hourly rate - - -

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,751 1,705 1,682
As % of all contract IT jobs advertised in the City of London 25.27% 27.69% 26.00%
Number of daily rates quoted 1,442 1,351 1,330
City of London median daily rate £525 £500 £475
Median daily rate % change year-on-year +5.00% +5.26% +5.56%
10th Percentile £363 £330 £313
90th Percentile £675 £650 £638
Central London median daily rate £513 £490 £475
% change year-on-year +4.59% +3.16% +5.56%
Number of hourly rates quoted 10 1 10
City of London median hourly rate £22.25 £22.34 £19.00
Median hourly rate % change year-on-year -0.38% +17.55% -47.22%
10th Percentile £20.63 £21.67 £16.03
90th Percentile £36.90 £23.00 £60.00
Central London median hourly rate £30.00 £22.34 £19.00
% change year-on-year +34.32% +17.55% -30.44%

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 24 May 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

Data Warehouse
Contract Job Locations in the City of London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Data Warehouse within the City of London region over the 6 months to 24 May 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
London Bridge - 1 £575 -
Data Warehouse
Central London

For the 6 months to 24 May 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 123 (60.59%) SQL
2 115 (56.65%) Business Intelligence
3 108 (53.20%) ETL
4 89 (43.84%) SQL Server Integration Services
5 78 (38.42%) Finance
5 78 (38.42%) SQL Server
6 77 (37.93%) SQL Server Reporting Services
7 60 (29.56%) Microsoft
8 56 (27.59%) Agile Software Development
9 53 (26.11%) T-SQL
10 49 (24.14%) Analytics
11 46 (22.66%) SQL Server Analysis Services
12 36 (17.73%) Data Modelling
12 36 (17.73%) Microsoft Azure
13 31 (15.27%) Hadoop
13 31 (15.27%) Power BI
14 30 (14.78%) C#
14 30 (14.78%) Big Data
15 29 (14.29%) Tableau
16 27 (13.30%) .NET
17 25 (12.32%) Oracle
18 24 (11.82%) Relational Database
19 22 (10.84%) Migration
20 21 (10.34%) Python
20 21 (10.34%) Analytical Skills
21 20 (9.85%) ETL Development
21 20 (9.85%) Team Foundation Server
21 20 (9.85%) Data Integration
21 20 (9.85%) Problem-Solving
22 19 (9.36%) Visualisation

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 17 (8.37%) Apache Spark
2 7 (3.45%) Apache
2 7 (3.45%) Apache Pig
3 5 (2.46%) SAS
4 4 (1.97%) SharePoint
5 3 (1.48%) Apache Solr
6 2 (0.99%) IIS
7 1 (0.49%) Alfresco
7 1 (0.49%) Confluence
7 1 (0.49%) Oracle Workflow
Applications
1 11 (5.42%) Microsoft Excel
2 4 (1.97%) Microsoft Office
3 2 (0.99%) Microsoft PowerPoint
4 1 (0.49%) Stata
Business Applications
1 4 (1.97%) Dynamics AX
2 1 (0.49%) Dynamics CRM
2 1 (0.49%) Dynamics GP
2 1 (0.49%) SAP HCM
2 1 (0.49%) SAP HR
2 1 (0.49%) Unit4 Business World
Cloud Services
1 36 (17.73%) Microsoft Azure
2 14 (6.90%) Amazon AWS
3 10 (4.93%) PaaS
4 6 (2.96%) Google Cloud Platform
5 5 (2.46%) Amazon S3
5 5 (2.46%) Azure Data Factory
6 2 (0.99%) Data Lake Analytics
6 2 (0.99%) Dynamics 365
6 2 (0.99%) SaaS
7 1 (0.49%) Amazon EMR
7 1 (0.49%) Amazon Kinesis
7 1 (0.49%) Azure Machine Learning
7 1 (0.49%) Google Analytics
7 1 (0.49%) Serverless
7 1 (0.49%) Slack
7 1 (0.49%) SuccessFactors
7 1 (0.49%) Trello
Communications & Networking
1 4 (1.97%) Intranet
2 3 (1.48%) SMS
Database & Business Intelligence
1 89 (43.84%) SQL Server Integration Services
2 78 (38.42%) SQL Server
3 77 (37.93%) SQL Server Reporting Services
4 46 (22.66%) SQL Server Analysis Services
5 31 (15.27%) Hadoop
5 31 (15.27%) Power BI
6 30 (14.78%) Big Data
7 24 (11.82%) Relational Database
8 17 (8.37%) Enterprise Data Warehouse
9 16 (7.88%) Azure SQL Data Warehouse
10 15 (7.39%) Data Lake
11 13 (6.40%) Amazon Redshift
11 13 (6.40%) Apache Hive
11 13 (6.40%) NoSQL
11 13 (6.40%) SQL Server 2012
12 11 (5.42%) QlikView
13 10 (4.93%) Apache Cassandra
14 9 (4.43%) BusinessObjects
14 9 (4.43%) MongoDB
14 9 (4.43%) Sqoop
Development Applications
1 20 (9.85%) Team Foundation Server
2 9 (4.43%) Git (software)
3 7 (3.45%) Jenkins
3 7 (3.45%) JIRA
3 7 (3.45%) TeamCity
4 6 (2.96%) ERwin
5 5 (2.46%) JUnit
5 5 (2.46%) SQL Server Management Studio (SSMS)
6 4 (1.97%) Visual Studio
7 2 (0.99%) Visual Studio Team System
8 1 (0.49%) GitLab
8 1 (0.49%) Mercurial
8 1 (0.49%) RStudio
8 1 (0.49%) Selenium
8 1 (0.49%) SoapUI
8 1 (0.49%) SpecFlow
8 1 (0.49%) Subversion
8 1 (0.49%) WebDriver
8 1 (0.49%) XMLSpy
General
1 78 (38.42%) Finance
2 16 (7.88%) Retail
3 15 (7.39%) Banking
4 9 (4.43%) Marketing
5 5 (2.46%) Investment Banking
6 4 (1.97%) Advertising
6 4 (1.97%) Back Office
7 3 (1.48%) Legal
7 3 (1.48%) Publishing
8 2 (0.99%) Front Office
8 2 (0.99%) Law
8 2 (0.99%) Pharmaceutical
8 2 (0.99%) Telecoms
9 1 (0.49%) Electronics
9 1 (0.49%) General Ledger
9 1 (0.49%) German Language
9 1 (0.49%) Manufacturing
9 1 (0.49%) Retail Banking
Job Titles
1 100 (49.26%) Developer
2 41 (20.20%) Business Intelligence Developer
3 31 (15.27%) Analyst
4 30 (14.78%) SQL Developer
5 20 (9.85%) Architect
6 18 (8.87%) SSIS Developer
7 16 (7.88%) SSRS Developer
8 15 (7.39%) Data Engineer
9 14 (6.90%) Data Architect
10 12 (5.91%) Azure Developer
11 11 (5.42%) Business Analyst
11 11 (5.42%) Consultant
11 11 (5.42%) SSAS Developer
12 10 (4.93%) Business Developer
12 10 (4.93%) Business Intelligence Analyst
12 10 (4.93%) Data Warehouse Developer
13 8 (3.94%) Data Warehouse Manager
13 8 (3.94%) ETL Developer
13 8 (3.94%) Power BI Developer
14 7 (3.45%) C# Developer
Libraries, Frameworks & Software Standards
1 27 (13.30%) .NET
2 10 (4.93%) XML
3 9 (4.43%) MDX
4 5 (2.46%) Keras
4 5 (2.46%) MLlib
4 5 (2.46%) scikit-learn
4 5 (2.46%) TensorFlow
5 4 (1.97%) JSON
5 4 (1.97%) Web Services
5 4 (1.97%) WPF
6 3 (1.48%) Kafka
6 3 (1.48%) REST
6 3 (1.48%) XSD
7 2 (0.99%) .NET Framework
7 2 (0.99%) Entity Framework
7 2 (0.99%) Middleware
7 2 (0.99%) Natural Language Processing
7 2 (0.99%) SOAP
8 1 (0.49%) FIX Protocol
8 1 (0.49%) Spring
Miscellaneous
1 21 (10.34%) Analytical Skills
2 10 (4.93%) Reinsurance
3 8 (3.94%) Greenfield Project
4 5 (2.46%) Self-Motivation
5 4 (1.97%) Data Centre
6 3 (1.48%) Computer Science
6 3 (1.48%) Data Structures
6 3 (1.48%) Management Information System
6 3 (1.48%) NHS
6 3 (1.48%) Private Cloud
6 3 (1.48%) Replication
6 3 (1.48%) User Experience
7 2 (0.99%) Hedge funds
7 2 (0.99%) iPad
7 2 (0.99%) Life Science
7 2 (0.99%) Tandem
8 1 (0.49%) Algorithms
8 1 (0.49%) Credit Risk
8 1 (0.49%) Reference Data
8 1 (0.49%) Wiki
Operating Systems
1 8 (3.94%) Linux
2 7 (3.45%) Windows
3 5 (2.46%) Windows Server
4 2 (0.99%) Unix
5 1 (0.49%) CentOS
5 1 (0.49%) Ubuntu
5 1 (0.49%) Windows Server 2008
5 1 (0.49%) Windows Server 2012
Processes & Methodologies
1 115 (56.65%) Business Intelligence
2 108 (53.20%) ETL
3 56 (27.59%) Agile Software Development
4 49 (24.14%) Analytics
5 36 (17.73%) Data Modelling
6 22 (10.84%) Migration
7 20 (9.85%) Data Integration
7 20 (9.85%) ETL Development
7 20 (9.85%) Problem-Solving
8 19 (9.36%) Visualisation
9 18 (8.87%) Data Analysis
9 18 (8.87%) Scrum
10 17 (8.37%) Stakeholder Management
11 16 (7.88%) Performance Tuning
12 15 (7.39%) Kimball Methodology
13 14 (6.90%) Data Migration
14 13 (6.40%) E-Commerce
15 12 (5.91%) Continuous Integration
15 12 (5.91%) Data Engineering
15 12 (5.91%) Data Visualisation
Programming Languages
1 123 (60.59%) SQL
2 53 (26.11%) T-SQL
3 30 (14.78%) C#
4 21 (10.34%) Python
5 18 (8.87%) Java
6 13 (6.40%) VB.NET
7 11 (5.42%) PL/SQL
8 10 (4.93%) Scala
9 8 (3.94%) Data Analysis Expressions (DAX)
9 8 (3.94%) Shell Script
10 5 (2.46%) VB
11 4 (1.97%) PHP
11 4 (1.97%) VBA
12 3 (1.48%) JavaScript
13 2 (0.99%) R
13 2 (0.99%) U-SQL
14 1 (0.49%) Bash Shell
14 1 (0.49%) HiveQL
14 1 (0.49%) Perl
14 1 (0.49%) PowerShell
Qualifications
1 4 (1.97%) SC Cleared
1 4 (1.97%) Security Cleared
2 3 (1.48%) Degree
2 3 (1.48%) PMP
3 2 (0.99%) DV Cleared
3 2 (0.99%) PMI Certification
4 1 (0.49%) ACCA
4 1 (0.49%) CIMA
4 1 (0.49%) Computer Science Degree
4 1 (0.49%) Microsoft Certification
4 1 (0.49%) Numerate Degree
Quality Assurance & Compliance
1 15 (7.39%) QA
2 8 (3.94%) Data Quality
3 5 (2.46%) GCP
4 4 (1.97%) GDPR
5 1 (0.49%) HL7
5 1 (0.49%) Solvency II
System Software
1 10 (4.93%) Docker
2 8 (3.94%) Apache Flume
2 8 (3.94%) HDFS
3 1 (0.49%) Apache ZooKeeper
Systems Management
1 6 (2.96%) Oozie
2 5 (2.46%) Hadoop YARN
2 5 (2.46%) Terraform
3 4 (1.97%) Ansible
3 4 (1.97%) Opscode Chef
3 4 (1.97%) Puppet
4 1 (0.49%) Kibana
4 1 (0.49%) Systems Management Server (SMS)
Vendors
1 60 (29.56%) Microsoft
2 29 (14.29%) Tableau
3 25 (12.32%) Oracle
4 18 (8.87%) Informatica
5 12 (5.91%) Cloudera
6 11 (5.42%) IBM
7 9 (4.43%) Hortonworks
8 7 (3.45%) Cognos
8 7 (3.45%) Google
8 7 (3.45%) SAP
9 5 (2.46%) Ab Initio
9 5 (2.46%) MapR
9 5 (2.46%) Talend
10 3 (1.48%) CheckPoint
10 3 (1.48%) Embarcadero
10 3 (1.48%) F5
11 2 (0.99%) CA
11 2 (0.99%) Citrix
11 2 (0.99%) PeopleSoft
11 2 (0.99%) Red Hat