Period
to 22 September 2019

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 22 September 2019 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
22 Sep 2019
Same period 2018 Same period 2017
Rank 60 87 85
Rank change year-on-year +27 -2 -26
Contract jobs citing Data Warehouse 239 200 199
As % of all contract IT jobs advertised in the City of London 3.88% 2.89% 2.93%
As % of the Database & Business Intelligence category 15.22% 11.18% 11.61%
Number of daily rates quoted 178 165 170
City of London median daily rate £524 £475 £475
Median daily rate % change year-on-year +10.26% - +5.56%
10th Percentile £410 £363 £381
90th Percentile £625 £616 £650
Central London median daily rate £525 £480 £475
% change year-on-year +9.38% +1.05% +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,570 1,789 1,714
As % of all contract IT jobs advertised in the City of London 25.46% 25.82% 25.27%
Number of daily rates quoted 1,250 1,417 1,349
City of London median daily rate £525 £525 £525
10th Percentile £388 £370 £363
90th Percentile £688 £675 £675
Central London median daily rate £525 £525 £500
% change year-on-year - +5.00% +11.11%
Number of hourly rates quoted 9 14 8
City of London median hourly rate £44.57 £22.25 £25.99
Median hourly rate % change year-on-year +100.29% -14.40% +36.80%
10th Percentile £21.23 £19.50 £20.75
90th Percentile £70.10 £37.09 £33.25
Central London median hourly rate £44.57 £22.25 £25.99
% change year-on-year +100.29% -14.40% +36.80%

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 22 September 2019.

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 22 September 2019. 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 +8 27 £550 -
Data Warehouse
Central London

For the 6 months to 22 September 2019, 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 154 (64.44%) SQL
2 117 (48.95%) Business Intelligence
3 112 (46.86%) ETL
4 101 (42.26%) SQL Server
5 97 (40.59%) Finance
6 86 (35.98%) Data Modelling
7 81 (33.89%) SQL Server Integration Services
8 70 (29.29%) Azure
9 66 (27.62%) Power BI
9 66 (27.62%) Power Platform
10 63 (26.36%) Analytics
11 59 (24.69%) Microsoft
12 58 (24.27%) Agile Software Development
13 52 (21.76%) SQL Server Reporting Services
14 50 (20.92%) Big Data
15 48 (20.08%) Python
15 48 (20.08%) Data Science
16 45 (18.83%) SQL Server Analysis Services
16 45 (18.83%) Data Quality
17 43 (17.99%) T-SQL
18 41 (17.15%) Hadoop
19 39 (16.32%) Apache Spark
20 34 (14.23%) Star Schema
20 34 (14.23%) Data Lake
21 32 (13.39%) Machine Learning
21 32 (13.39%) Migration
22 31 (12.97%) Apache Hive
23 30 (12.55%) AWS
23 30 (12.55%) Kafka
23 30 (12.55%) Kimball Methodology

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 39 (16.32%) Apache Spark
2 12 (5.02%) SharePoint
3 6 (2.51%) WebLogic
3 6 (2.51%) WebLogic Integration
4 5 (2.09%) Apache Airflow
4 5 (2.09%) SAS
5 3 (1.26%) Confluence
6 2 (0.84%) Apache Pig
6 2 (0.84%) Jupyter
7 1 (0.42%) Apache
7 1 (0.42%) CMS
7 1 (0.42%) Oracle Workflow
7 1 (0.42%) Sitecore CMS
Applications
1 18 (7.53%) Microsoft Excel
2 4 (1.67%) Microsoft Office
3 2 (0.84%) MS Visio
4 1 (0.42%) Chatbot
4 1 (0.42%) Microsoft Project
Business Applications
1 10 (4.18%) Dynamics CRM
2 6 (2.51%) Oracle Financials
2 6 (2.51%) Unit4 Business World
3 4 (1.67%) Dynamics AX
3 4 (1.67%) Dynamics NAV
4 3 (1.26%) Oracle Procure-to-Pay
5 2 (0.84%) Markit EDM
5 2 (0.84%) Oracle Assets
5 2 (0.84%) Oracle Cash Management
5 2 (0.84%) Oracle FAH
5 2 (0.84%) Oracle General Ledger
5 2 (0.84%) Oracle Internet Expenses
5 2 (0.84%) Oracle iProcurement
5 2 (0.84%) Oracle Payables
5 2 (0.84%) Oracle Receivables
5 2 (0.84%) Oracle Subledger Accounting
6 1 (0.42%) Cognos TM1
6 1 (0.42%) Eagle PACE
6 1 (0.42%) SAP Oil and Gas
Cloud Services
1 70 (29.29%) Azure
2 66 (27.62%) Power Platform
3 30 (12.55%) AWS
4 25 (10.46%) Azure Data Factory
5 18 (7.53%) GCP
6 11 (4.60%) Amazon S3
7 9 (3.77%) Amazon EMR
7 9 (3.77%) Serverless
8 8 (3.35%) PaaS
9 7 (2.93%) Data Lake Analytics
10 5 (2.09%) Azure Functions
10 5 (2.09%) Cloud Computing
10 5 (2.09%) Dynamics 365
10 5 (2.09%) IaaS
11 4 (1.67%) AWS CloudFormation
11 4 (1.67%) AWS Lambda
11 4 (1.67%) Office 365
11 4 (1.67%) Tricentis Tosca
12 3 (1.26%) Amazon Kinesis
12 3 (1.26%) GitHub
Communications & Networking
1 2 (0.84%) DNS
1 2 (0.84%) SAN
2 1 (0.42%) Firewall
2 1 (0.42%) Internet
2 1 (0.42%) VoIP
Database & Business Intelligence
1 101 (42.26%) SQL Server
2 81 (33.89%) SQL Server Integration Services
3 66 (27.62%) Power BI
4 52 (21.76%) SQL Server Reporting Services
5 50 (20.92%) Big Data
6 45 (18.83%) SQL Server Analysis Services
7 41 (17.15%) Hadoop
8 34 (14.23%) Data Lake
8 34 (14.23%) Star Schema
9 31 (12.97%) Apache Hive
10 28 (11.72%) Azure SQL Data Warehouse
10 28 (11.72%) OLAP
11 27 (11.30%) Enterprise Data Warehouse
12 24 (10.04%) Azure SQL Database
12 24 (10.04%) OLAP Cube
13 17 (7.11%) Amazon Redshift
13 17 (7.11%) SQL Server 2017
14 16 (6.69%) SQL Server 2016
15 15 (6.28%) BigQuery
16 11 (4.60%) Microsoft Analysis Services
Development Applications
1 22 (9.21%) Git (software)
2 14 (5.86%) Jenkins
3 12 (5.02%) Visual Studio
4 7 (2.93%) Eclipse
4 7 (2.93%) JIRA
5 6 (2.51%) Selenium
5 6 (2.51%) Team Foundation Server
6 3 (1.26%) Atlassian Bamboo
6 3 (1.26%) Cucumber
6 3 (1.26%) SpecFlow
6 3 (1.26%) SQL Server Management Studio (SSMS)
6 3 (1.26%) TeamCity
6 3 (1.26%) Visual Studio Team System
7 2 (0.84%) Octopus Deploy
7 2 (0.84%) tSQLt
8 1 (0.42%) Bitbucket Server
8 1 (0.42%) Maven
8 1 (0.42%) WebDriver
General
1 97 (40.59%) Finance
2 22 (9.21%) Banking
2 22 (9.21%) Retail
3 14 (5.86%) Investment Banking
4 7 (2.93%) Front Office
5 4 (1.67%) Public Sector
6 3 (1.26%) Advertising
6 3 (1.26%) Back Office
7 2 (0.84%) Environmental Health
7 2 (0.84%) Financial Institution
7 2 (0.84%) International Banking
8 1 (0.42%) Games
8 1 (0.42%) Law
8 1 (0.42%) Marketing
8 1 (0.42%) Retail Banking
Job Titles
1 71 (29.71%) Developer
2 45 (18.83%) Data Engineer
3 37 (15.48%) Business Intelligence Developer
4 32 (13.39%) Analyst
5 31 (12.97%) Architect
6 26 (10.88%) SQL Developer
7 25 (10.46%) Hadoop Engineer
8 22 (9.21%) Data Architect
9 17 (7.11%) SQL BI Developer
10 15 (6.28%) Business Analyst
11 12 (5.02%) Data Analyst
11 12 (5.02%) ETL Developer
12 11 (4.60%) Power BI Developer
13 9 (3.77%) Azure Developer
13 9 (3.77%) Consultant
13 9 (3.77%) Data Warehouse Developer
13 9 (3.77%) SSRS Developer
14 8 (3.35%) Azure Architect
14 8 (3.35%) Data Modeller
15 7 (2.93%) Cloud Architect
Libraries, Frameworks & Software Standards
1 30 (12.55%) Kafka
2 14 (5.86%) .NET
3 12 (5.02%) XML
4 8 (3.35%) Web Services
5 7 (2.93%) JSON
5 7 (2.93%) Middleware
6 6 (2.51%) J2EE
6 6 (2.51%) MSMQ
7 5 (2.09%) MDX
8 4 (1.67%) REST
8 4 (1.67%) XBRL
9 3 (1.26%) LAMP
9 3 (1.26%) Pandas
10 2 (0.84%) LDAP
10 2 (0.84%) Oracle Fusion
10 2 (0.84%) Regular Expression
10 2 (0.84%) Velocity
11 1 (0.42%) Apache Avro
11 1 (0.42%) Gherkin
11 1 (0.42%) Natural Language Processing
Miscellaneous
1 18 (7.53%) Analytical Skills
2 9 (3.77%) Data Structures
3 6 (2.51%) Reinsurance
4 4 (1.67%) Replication
4 4 (1.67%) User Experience
5 3 (1.26%) Greenfield Project
5 3 (1.26%) Virtual Team
6 2 (0.84%) Cloud Native
6 2 (0.84%) Equities
6 2 (0.84%) Fixed Income
6 2 (0.84%) Tandem
6 2 (0.84%) Taxonomies
7 1 (0.42%) Client/Server
7 1 (0.42%) Data Centre
7 1 (0.42%) Linux Command Line
7 1 (0.42%) Reference Data
7 1 (0.42%) Robotics
7 1 (0.42%) Self-Motivation
Operating Systems
1 13 (5.44%) Unix
2 11 (4.60%) Linux
3 9 (3.77%) Windows
4 2 (0.84%) Red Hat Enterprise Linux
4 2 (0.84%) Solaris
Processes & Methodologies
1 117 (48.95%) Business Intelligence
2 112 (46.86%) ETL
3 86 (35.98%) Data Modelling
4 63 (26.36%) Analytics
5 58 (24.27%) Agile Software Development
6 48 (20.08%) Data Science
7 32 (13.39%) Machine Learning
7 32 (13.39%) Migration
8 30 (12.55%) Dimensional Modelling
8 30 (12.55%) Kimball Methodology
9 25 (10.46%) SQL Optimisation
10 21 (8.79%) Data Integration
11 19 (7.95%) Data Analysis
11 19 (7.95%) Problem-Solving
12 18 (7.53%) Data Architecture
12 18 (7.53%) Data Migration
13 17 (7.11%) DevOps
14 14 (5.86%) Decision-Making
14 14 (5.86%) ETL Development
14 14 (5.86%) Stakeholder Management
Programming Languages
1 154 (64.44%) SQL
2 48 (20.08%) Python
3 43 (17.99%) T-SQL
4 26 (10.88%) Java
5 15 (6.28%) C#
5 15 (6.28%) Scala
6 10 (4.18%) Data Analysis Expressions (DAX)
7 9 (3.77%) Perl
8 7 (2.93%) PowerShell
9 6 (2.51%) VBA
10 5 (2.09%) PL/SQL
10 5 (2.09%) Shell Script
11 4 (1.67%) Bash Shell
12 3 (1.26%) R
12 3 (1.26%) U-SQL
13 2 (0.84%) Go
13 2 (0.84%) JavaScript
13 2 (0.84%) Ruby
14 1 (0.42%) C
14 1 (0.42%) Groovy
Qualifications
1 5 (2.09%) SC Cleared
1 5 (2.09%) Security Cleared
2 1 (0.42%) AWS Certification
2 1 (0.42%) ISEB
2 1 (0.42%) PMI Certification
2 1 (0.42%) PMP
Quality Assurance & Compliance
1 45 (18.83%) Data Quality
2 10 (4.18%) QA
3 2 (0.84%) GDPR
4 1 (0.42%) MiFID
4 1 (0.42%) PMO
System Software
1 5 (2.09%) HDFS
2 4 (1.67%) Oracle RAC
3 3 (1.26%) Apache Flume
4 2 (0.84%) Cronacle
4 2 (0.84%) Docker
4 2 (0.84%) Veritas File System
4 2 (0.84%) Veritas Volume Manager
Systems Management
1 24 (10.04%) Oozie
2 8 (3.35%) Ansible
3 6 (2.51%) Kubernetes
3 6 (2.51%) Terraform
4 5 (2.09%) Hadoop YARN
5 1 (0.42%) HP Quality Center
Vendors
1 59 (24.69%) Microsoft
2 26 (10.88%) Oracle
3 19 (7.95%) Tableau
4 14 (5.86%) Google
5 8 (3.35%) Informatica
6 7 (2.93%) Teradata
7 6 (2.51%) CODA
7 6 (2.51%) Cognos
8 5 (2.09%) Databricks
8 5 (2.09%) Talend
9 4 (1.67%) Ab Initio
10 3 (1.26%) Cloudera
10 3 (1.26%) SAP
11 2 (0.84%) Birst
11 2 (0.84%) Cisco
11 2 (0.84%) IBM
11 2 (0.84%) Red Hat
11 2 (0.84%) Twitter
11 2 (0.84%) Veritas
11 2 (0.84%) VMware