Period
to 28 February 2020

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 28 February 2020 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
28 Feb 2020
Same period 2019 Same period 2018
Rank 58 68 85
Rank change year-on-year +10 +17 -38
Contract jobs citing Data Warehouse 164 242 207
As % of all contract IT jobs advertised in the City of London 3.52% 3.55% 2.91%
As % of the Database & Business Intelligence category 15.28% 14.18% 11.82%
Number of daily rates quoted 124 200 182
City of London median daily rate £505 £484 £486
Median daily rate % change year-on-year +4.39% -0.51% +8.06%
10th Percentile £400 £368 £401
90th Percentile £634 £625 £675
Central London median daily rate £510 £500 £485
% change year-on-year +2.00% +3.09% +7.78%
Number of hourly rates quoted 0 0 1
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,073 1,707 1,752
As % of all contract IT jobs advertised in the City of London 23.03% 25.04% 24.66%
Number of daily rates quoted 823 1,371 1,490
City of London median daily rate £513 £538 £525
Median daily rate % change year-on-year -4.65% +2.38% +10.53%
10th Percentile £363 £400 £363
90th Percentile £675 £675 £688
Central London median daily rate £500 £525 £513
% change year-on-year -4.76% +2.44% +7.89%
Number of hourly rates quoted 4 6 7
City of London median hourly rate £25.00 £37.09 £27.50
Median hourly rate % change year-on-year -32.60% +34.87% -18.32%
10th Percentile £22.17 £28.13 £19.37
90th Percentile £35.13 £71.47 £48.76
Central London median hourly rate £35.00 £37.09 £27.50
% change year-on-year -5.63% +34.87% -18.32%

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 28 February 2020.

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 28 February 2020. 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 +14 4 £400 -27.27%
Data Warehouse
Central London

For the 6 months to 28 February 2020, 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 102 (62.20%) SQL
2 91 (55.49%) Business Intelligence
3 72 (43.90%) ETL
4 58 (35.37%) Agile Software Development
5 52 (31.71%) SQL Server Integration Services
6 51 (31.10%) Finance
7 50 (30.49%) SQL Server
8 38 (23.17%) Microsoft
8 38 (23.17%) Azure
9 34 (20.73%) Data Modelling
9 34 (20.73%) Power BI
9 34 (20.73%) Power Platform
10 33 (20.12%) Python
11 32 (19.51%) Kimball Methodology
12 31 (18.90%) Analytics
13 29 (17.68%) SQL Server Reporting Services
14 26 (15.85%) Oracle
14 26 (15.85%) T-SQL
15 22 (13.41%) Scrum
15 22 (13.41%) SQL Server Analysis Services
16 21 (12.80%) Analytical Skills
16 21 (12.80%) GCP
16 21 (12.80%) Decision-Making
17 17 (10.37%) Dimensional Modelling
17 17 (10.37%) QA
17 17 (10.37%) Dashboard Development
18 16 (9.76%) Continuous Delivery
18 16 (9.76%) DevOps
18 16 (9.76%) Azure SQL Data Warehouse
19 15 (9.15%) Continuous Improvement

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 9 (5.49%) Apache Airflow
2 6 (3.66%) Apache Spark
3 5 (3.05%) SAS
4 2 (1.22%) SharePoint
5 1 (0.61%) Apache Pig
5 1 (0.61%) Confluence
5 1 (0.61%) Oracle Workflow
Applications
1 11 (6.71%) Microsoft Excel
2 1 (0.61%) Microsoft Office
2 1 (0.61%) Spreadsheet
Business Applications
1 2 (1.22%) Cognos TM1
2 1 (0.61%) FastStats
2 1 (0.61%) HFM
2 1 (0.61%) Oracle FAH
2 1 (0.61%) SAP BPC
2 1 (0.61%) SAP Oil and Gas
2 1 (0.61%) Sparx Enterprise Architect
Cloud Services
1 38 (23.17%) Azure
2 34 (20.73%) Power Platform
3 21 (12.80%) GCP
4 14 (8.54%) AWS
5 8 (4.88%) Azure Data Factory
6 7 (4.27%) Tricentis Tosca
7 4 (2.44%) Data Lake Analytics
7 4 (2.44%) Serverless
8 3 (1.83%) Amazon S3
9 2 (1.22%) Amazon EMR
9 2 (1.22%) Amazon Kinesis
9 2 (1.22%) AWS Lambda
9 2 (1.22%) Azure Functions
9 2 (1.22%) SaaS
10 1 (0.61%) Amazon EC2
10 1 (0.61%) AWS CloudFormation
10 1 (0.61%) Cloud Computing
10 1 (0.61%) GitHub
10 1 (0.61%) PaaS
10 1 (0.61%) Virtual Private Cloud
Communications & Networking
1 7 (4.27%) Firewall
2 1 (0.61%) 3G
2 1 (0.61%) 4G
2 1 (0.61%) 5G
2 1 (0.61%) SAN
Database & Business Intelligence
1 52 (31.71%) SQL Server Integration Services
2 50 (30.49%) SQL Server
3 34 (20.73%) Power BI
4 29 (17.68%) SQL Server Reporting Services
5 22 (13.41%) SQL Server Analysis Services
6 16 (9.76%) Azure SQL Data Warehouse
7 14 (8.54%) NoSQL
8 13 (7.93%) Azure SQL Database
8 13 (7.93%) BigQuery
9 12 (7.32%) Data Lake
10 11 (6.71%) Big Data
10 11 (6.71%) Hadoop
11 10 (6.10%) Snowflake Schema
12 8 (4.88%) Amazon Redshift
12 8 (4.88%) SQL Server 2008
12 8 (4.88%) SQL Server 2016
13 7 (4.27%) Star Schema
14 6 (3.66%) BusinessObjects
14 6 (3.66%) OLAP
14 6 (3.66%) SAP Data Services
Development Applications
1 10 (6.10%) Selenium
2 9 (5.49%) Jenkins
3 7 (4.27%) Team Foundation Server
4 5 (3.05%) Visual Studio
5 4 (2.44%) Git (software)
5 4 (2.44%) JIRA
6 2 (1.22%) Eclipse
6 2 (1.22%) SQL Server Management Studio (SSMS)
7 1 (0.61%) Cucumber
7 1 (0.61%) JUnit
7 1 (0.61%) PowerDesigner
7 1 (0.61%) WebDriver
General
1 51 (31.10%) Finance
2 11 (6.71%) Banking
3 7 (4.27%) Law
4 5 (3.05%) Retail
5 3 (1.83%) Financial Institution
5 3 (1.83%) Investment Banking
5 3 (1.83%) Marketing
5 3 (1.83%) Public Sector
6 2 (1.22%) Billing
6 2 (1.22%) Legal
7 1 (0.61%) Front Office
7 1 (0.61%) General Ledger
7 1 (0.61%) Telecoms
Job Titles
1 58 (35.37%) Developer
2 26 (15.85%) Analyst
3 25 (15.24%) Architect
4 21 (12.80%) Business Intelligence Developer
5 19 (11.59%) SQL Developer
6 15 (9.15%) Data Architect
7 11 (6.71%) Business Analyst
7 11 (6.71%) Data Engineer
7 11 (6.71%) Technical Analyst
8 10 (6.10%) Data Warehouse Developer
9 9 (5.49%) Business Intelligence Analyst
9 9 (5.49%) Consultant
9 9 (5.49%) Data Warehouse Analyst
9 9 (5.49%) Power BI Developer
9 9 (5.49%) SQL Analyst
9 9 (5.49%) SSIS Developer
10 8 (4.88%) Dashboard Developer
10 8 (4.88%) ETL Analyst
10 8 (4.88%) Python Engineer
11 7 (4.27%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 13 (7.93%) .NET
2 7 (4.27%) MDX
3 4 (2.44%) ASP.NET
3 4 (2.44%) Kafka
3 4 (2.44%) XML
4 2 (1.22%) AngularJS
4 2 (1.22%) D3.js
4 2 (1.22%) HTML
4 2 (1.22%) Web Services
5 1 (0.61%) .NET Framework
5 1 (0.61%) Apache NiFi
5 1 (0.61%) ASP.NET MVC
5 1 (0.61%) JSON
5 1 (0.61%) Node.js
5 1 (0.61%) PySpark
5 1 (0.61%) SOAP
5 1 (0.61%) WinForms
5 1 (0.61%) XBRL
5 1 (0.61%) XSD
Miscellaneous
1 21 (12.80%) Analytical Skills
2 5 (3.05%) Data Structures
2 5 (3.05%) Management Information System
2 5 (3.05%) Reinsurance
3 4 (2.44%) Equities
4 3 (1.83%) Data Protection Act
4 3 (1.83%) Fat Client
4 3 (1.83%) Fixed Income
4 3 (1.83%) Greenfield Project
4 3 (1.83%) Replication
4 3 (1.83%) Thin Client
5 2 (1.22%) Credit Risk
5 2 (1.22%) Reference Data
6 1 (0.61%) Clustering
6 1 (0.61%) Data Centre
6 1 (0.61%) Derivative
6 1 (0.61%) Equity Derivative
6 1 (0.61%) NHS
6 1 (0.61%) Self-Motivation
6 1 (0.61%) User Experience
Operating Systems
1 8 (4.88%) Windows
2 5 (3.05%) Unix
3 2 (1.22%) Linux
Processes & Methodologies
1 91 (55.49%) Business Intelligence
2 72 (43.90%) ETL
3 58 (35.37%) Agile Software Development
4 34 (20.73%) Data Modelling
5 32 (19.51%) Kimball Methodology
6 31 (18.90%) Analytics
7 22 (13.41%) Scrum
8 21 (12.80%) Decision-Making
9 17 (10.37%) Dashboard Development
9 17 (10.37%) Dimensional Modelling
10 16 (9.76%) Continuous Delivery
10 16 (9.76%) DevOps
11 15 (9.15%) Continuous Improvement
12 13 (7.93%) Problem-Solving
12 13 (7.93%) SDLC
13 12 (7.32%) Data Analysis
14 11 (6.71%) Business Analysis
14 11 (6.71%) Data Architecture
14 11 (6.71%) Information Management
15 10 (6.10%) Data Transformation
Programming Languages
1 102 (62.20%) SQL
2 33 (20.12%) Python
3 26 (15.85%) T-SQL
4 14 (8.54%) Java
5 12 (7.32%) C#
5 12 (7.32%) PL/SQL
6 10 (6.10%) Scala
7 8 (4.88%) JavaScript
7 8 (4.88%) PowerShell
8 7 (4.27%) Go
8 7 (4.27%) Groovy
8 7 (4.27%) Ruby
9 6 (3.66%) Perl
10 5 (3.05%) Data Analysis Expressions (DAX)
11 4 (2.44%) R
11 4 (2.44%) Shell Script
11 4 (2.44%) VB.NET
12 3 (1.83%) VB
13 2 (1.22%) C++
13 2 (1.22%) PHP
Qualifications
1 6 (3.66%) Degree
2 5 (3.05%) MCITP
2 5 (3.05%) Microsoft Certification
3 3 (1.83%) SC Cleared
3 3 (1.83%) Security Cleared
4 1 (0.61%) ACCA
4 1 (0.61%) CIMA
Quality Assurance & Compliance
1 17 (10.37%) QA
2 8 (4.88%) Data Quality
3 6 (3.66%) IFRS
4 5 (3.05%) Solvency II
5 1 (0.61%) Basel III
5 1 (0.61%) GAAP
5 1 (0.61%) IFRS 9
5 1 (0.61%) MiFID
System Software
1 3 (1.83%) Oracle RAC
2 2 (1.22%) Docker
3 1 (0.61%) Apache Flume
3 1 (0.61%) HDFS
3 1 (0.61%) Virtual Machines
Systems Management
1 14 (8.54%) Terraform
2 8 (4.88%) Ansible
3 7 (4.27%) Kubernetes
4 1 (0.61%) Control-M
4 1 (0.61%) HP Quality Center
Vendors
1 38 (23.17%) Microsoft
2 26 (15.85%) Oracle
3 12 (7.32%) Tableau
4 11 (6.71%) Google
5 9 (5.49%) SAP
6 6 (3.66%) Cognos
6 6 (3.66%) Sybase
7 5 (3.05%) Hyperion
8 4 (2.44%) Databricks
8 4 (2.44%) Teradata
9 2 (1.22%) DocuSign
9 2 (1.22%) Informatica
9 2 (1.22%) Netezza
10 1 (0.61%) Alteryx
10 1 (0.61%) BMC
10 1 (0.61%) Greenplum
10 1 (0.61%) Infragistics
10 1 (0.61%) Reuters
10 1 (0.61%) Sparx
10 1 (0.61%) Talend