Period
to 7 August 2020

The following table provides summary statistics for contract job vacancies advertised in Central 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 7 August 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
London > Central London
6 months to
7 Aug 2020
Same period 2019 Same period 2018
Rank 48 62 86
Rank change year-on-year +14 +24 -11
Contract jobs citing Data Warehouse 120 334 267
As % of all contract jobs advertised in Central London 4.50% 3.99% 2.93%
As % of the Database & Business Intelligence category 17.47% 14.81% 11.31%
Number of daily rates quoted 83 264 221
Median daily rate £475 £525 £490
Median daily rate % change year-on-year -9.52% +7.14% +0.51%
10th Percentile £343 £407 £368
90th Percentile £675 £623 £613
London median daily rate £525 £500 £500
% change year-on-year +5.00% - +5.26%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
London median hourly rate £35.00 £35.00 £35.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 Central London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Central London
Contract vacancies with a requirement for database or business intelligence skills 687 2,255 2,361
As % of all contract IT jobs advertised in Central London 25.74% 26.94% 25.90%
Number of daily rates quoted 470 1,800 1,859
Median daily rate £518 £525 £525
Median daily rate % change year-on-year -1.43% - +5.00%
10th Percentile £363 £388 £363
90th Percentile £688 £675 £675
London median daily rate £525 £525 £525
Number of hourly rates quoted 11 16 15
Median hourly rate £35.00 £35.00 £22.00
Median hourly rate % change year-on-year - +59.09% -4.32%
10th Percentile £21.50 £20.00 £19.50
90th Percentile £39.25 £58.63 £33.00
Median hourly rate £35.00 £35.00 £28.75
% change year-on-year - +21.74% +5.85%

Data Warehouse
Job Vacancy Trend in Central London

Job postings citing Data Warehouse as a proportion of all IT jobs advertised in Central London.

Job vacancy trend for Data Warehouse in Central London

Data Warehouse
Contractor Daily Rate Trend in Central London

3-month moving average daily rate quoted in jobs citing Data Warehouse in Central London.

Daily rate trend for Data Warehouse in Central London

Data Warehouse
Daily Rate Histogram in Central London

Daily rate distribution for jobs citing Data Warehouse in Central London over the 6 months to 7 August 2020.

Daily rate histogram for Data Warehouse in Central London

Data Warehouse
Contractor Hourly Rate Trend in Central London

3-month moving average hourly rates quoted in jobs citing Data Warehouse in Central London.

Hourly rate trend for Data Warehouse in Central London

Data Warehouse
Contract Job Locations in Central 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 Central London region over the 6 months to 7 August 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
City of London +9 94 £475 -9.52% 26
City of Westminster +25 3 £600 -
Southwark +20 1 £400 -27.27%
West End of London +10 1 £550 -
Data Warehouse
London

For the 6 months to 7 August 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 Central London region with a requirement for Data Warehouse.

1 81 (67.50%) SQL
2 67 (55.83%) Business Intelligence
3 52 (43.33%) Finance
4 45 (37.50%) ETL
4 45 (37.50%) Agile Software Development
5 40 (33.33%) Azure
6 37 (30.83%) SQL Server Integration Services
7 36 (30.00%) Microsoft
8 34 (28.33%) SQL Server Reporting Services
9 33 (27.50%) Data Modelling
9 33 (27.50%) SQL Server
10 32 (26.67%) Power BI
10 32 (26.67%) Power Platform
11 29 (24.17%) Analytics
12 25 (20.83%) Kimball Methodology
13 23 (19.17%) SQL Server Analysis Services
14 20 (16.67%) T-SQL
14 20 (16.67%) C#
14 20 (16.67%) Python
14 20 (16.67%) Microsoft Excel
15 19 (15.83%) Banking
15 19 (15.83%) DevOps
15 19 (15.83%) Requirements Gathering
16 18 (15.00%) SDLC
16 18 (15.00%) .NET
17 17 (14.17%) Business Analysis
17 17 (14.17%) Data Lake
18 15 (12.50%) QA
18 15 (12.50%) AWS
19 14 (11.67%) Oracle

Data Warehouse
Co-occurring IT Skills in Central 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 7 (5.83%) SAS
2 5 (4.17%) Apache Spark
3 4 (3.33%) Elasticsearch
4 3 (2.50%) WebLogic
5 1 (0.83%) Apache Pig
5 1 (0.83%) Oracle Workflow
5 1 (0.83%) SharePoint
Applications
1 20 (16.67%) Microsoft Excel
2 1 (0.83%) Microsoft Office
2 1 (0.83%) Microsoft PowerPoint
2 1 (0.83%) MS Visio
Business Applications
1 3 (2.50%) SAP Oil and Gas
2 2 (1.67%) Dynamics CRM
3 1 (0.83%) Infor SunSystems
3 1 (0.83%) Oracle General Ledger
3 1 (0.83%) Oracle Internet Expenses
3 1 (0.83%) Oracle iProcurement
3 1 (0.83%) Oracle Procure-to-Pay
3 1 (0.83%) Salesforce.com CRM
3 1 (0.83%) SAP BPC
Cloud Services
1 40 (33.33%) Azure
2 32 (26.67%) Power Platform
3 15 (12.50%) AWS
4 10 (8.33%) Azure Data Factory
5 4 (3.33%) GCP
6 2 (1.67%) Data Lake Analytics
6 2 (1.67%) PaaS
6 2 (1.67%) Power Automate
6 2 (1.67%) PowerApps
6 2 (1.67%) Serverless
7 1 (0.83%) Amazon EC2
7 1 (0.83%) Amazon S3
7 1 (0.83%) AWS Lambda
7 1 (0.83%) Azure Active Directory
7 1 (0.83%) Azure Functions
7 1 (0.83%) IaaS
7 1 (0.83%) Salesforce Sales Cloud
7 1 (0.83%) Slack
Communications & Networking
1 2 (1.67%) Firewall
1 2 (1.67%) SSH
2 1 (0.83%) DNS
Database & Business Intelligence
1 37 (30.83%) SQL Server Integration Services
2 34 (28.33%) SQL Server Reporting Services
3 33 (27.50%) SQL Server
4 32 (26.67%) Power BI
5 23 (19.17%) SQL Server Analysis Services
6 17 (14.17%) Data Lake
7 13 (10.83%) Azure SQL Data Warehouse
8 11 (9.17%) Azure SQL Database
8 11 (9.17%) Big Data
8 11 (9.17%) OLAP
9 9 (7.50%) Hadoop
10 8 (6.67%) Microsoft Analysis Services
10 8 (6.67%) RDBMS
10 8 (6.67%) Relational Database
11 7 (5.83%) PowerPivot
12 6 (5.00%) NoSQL
12 6 (5.00%) Snowflake Schema
13 5 (4.17%) SAS EBI
13 5 (4.17%) SSDT
14 4 (3.33%) Star Schema
Development Applications
1 9 (7.50%) Team Foundation Server
2 7 (5.83%) Git (software)
2 7 (5.83%) Visual Studio
3 6 (5.00%) SQL Server Management Studio (SSMS)
4 5 (4.17%) Eclipse
4 5 (4.17%) JIRA
5 2 (1.67%) GitLab
5 2 (1.67%) Jenkins
5 2 (1.67%) PowerDesigner
5 2 (1.67%) Subversion
6 1 (0.83%) Atlassian Bamboo
6 1 (0.83%) Bitbucket
6 1 (0.83%) PowerBuilder
6 1 (0.83%) Sourcetree
General
1 52 (43.33%) Finance
2 19 (15.83%) Banking
3 7 (5.83%) Marketing
4 6 (5.00%) Retail
5 5 (4.17%) Investment Banking
6 4 (3.33%) Front Office
6 4 (3.33%) Law
7 3 (2.50%) Back Office
7 3 (2.50%) International Banking
7 3 (2.50%) Public Sector
8 2 (1.67%) General Ledger
9 1 (0.83%) Billing
9 1 (0.83%) Corporate Banking
9 1 (0.83%) Legal
9 1 (0.83%) Local Government
Job Titles
1 57 (47.50%) Developer
2 29 (24.17%) Analyst
3 17 (14.17%) Architect
3 17 (14.17%) Business Intelligence Developer
4 14 (11.67%) SQL Developer
4 14 (11.67%) Technical Analyst
5 13 (10.83%) Business Intelligence Analyst
6 12 (10.00%) Data Warehouse Analyst
7 11 (9.17%) C# Developer
7 11 (9.17%) SQL Analyst
8 10 (8.33%) ETL Analyst
9 8 (6.67%) .NET Developer
9 8 (6.67%) Data Warehouse Developer
10 7 (5.83%) C# .NET Developer
10 7 (5.83%) Junior
10 7 (5.83%) Junior Developer
10 7 (5.83%) Power BI Developer
10 7 (5.83%) Senior Developer
10 7 (5.83%) SQL Data Analyst
11 6 (5.00%) Junior C# .NET Developer
Libraries, Frameworks & Software Standards
1 18 (15.00%) .NET
2 11 (9.17%) ASP.NET
3 10 (8.33%) HTML
4 9 (7.50%) CSS
5 6 (5.00%) MDX
6 4 (3.33%) Kafka
6 4 (3.33%) Web Services
7 3 (2.50%) AngularJS
8 2 (1.67%) .NET Framework
8 2 (1.67%) ASP.NET MVC
8 2 (1.67%) D3.js
8 2 (1.67%) Node.js
8 2 (1.67%) Oracle Fusion
8 2 (1.67%) SOAP
8 2 (1.67%) XML
9 1 (0.83%) Entity Framework
9 1 (0.83%) jQuery
9 1 (0.83%) OAuth
9 1 (0.83%) Velocity
9 1 (0.83%) WinForms
Miscellaneous
1 11 (9.17%) Analytical Skills
2 10 (8.33%) Management Information System
3 6 (5.00%) Greenfield Project
4 3 (2.50%) Hedge funds
5 2 (1.67%) AS400
5 2 (1.67%) iSeries
5 2 (1.67%) NHS
5 2 (1.67%) Reference Data
5 2 (1.67%) User Experience
6 1 (0.83%) Analytical Mindset
6 1 (0.83%) Cloud Native
6 1 (0.83%) Credit Risk
6 1 (0.83%) Data Protection Act
6 1 (0.83%) Data Structures
6 1 (0.83%) Public Cloud
6 1 (0.83%) Reinsurance
6 1 (0.83%) Replication
6 1 (0.83%) SWIFT
6 1 (0.83%) Tandem
Operating Systems
1 6 (5.00%) Linux
1 6 (5.00%) Windows
2 5 (4.17%) Unix
3 2 (1.67%) Red Hat Enterprise Linux
4 1 (0.83%) Debian
4 1 (0.83%) Ubuntu
4 1 (0.83%) Windows Server
Processes & Methodologies
1 67 (55.83%) Business Intelligence
2 45 (37.50%) Agile Software Development
2 45 (37.50%) ETL
3 33 (27.50%) Data Modelling
4 29 (24.17%) Analytics
5 25 (20.83%) Kimball Methodology
6 19 (15.83%) DevOps
6 19 (15.83%) Requirements Gathering
7 18 (15.00%) SDLC
8 17 (14.17%) Business Analysis
9 13 (10.83%) Change Management
9 13 (10.83%) Data Development
9 13 (10.83%) Information Management
10 11 (9.17%) Dashboard Development
10 11 (9.17%) Problem-Solving
10 11 (9.17%) Visualisation
11 10 (8.33%) Migration
11 10 (8.33%) Portfolio Management
12 9 (7.50%) Data Architecture
12 9 (7.50%) Machine Learning
Programming Languages
1 81 (67.50%) SQL
2 20 (16.67%) C#
2 20 (16.67%) Python
2 20 (16.67%) T-SQL
3 14 (11.67%) JavaScript
4 10 (8.33%) Data Analysis Expressions (DAX)
4 10 (8.33%) R
5 9 (7.50%) VBA
6 8 (6.67%) Java
7 7 (5.83%) Perl
8 4 (3.33%) PHP
8 4 (3.33%) PL/SQL
8 4 (3.33%) Shell Script
9 3 (2.50%) Bash Shell
9 3 (2.50%) PowerShell
9 3 (2.50%) SAS Macro
10 1 (0.83%) Apex Code
10 1 (0.83%) Go
10 1 (0.83%) Groovy
10 1 (0.83%) Scala
Qualifications
1 7 (5.83%) Degree
2 3 (2.50%) TOGAF Certification
3 2 (1.67%) ACCA
3 2 (1.67%) CIMA
3 2 (1.67%) Computer Science Degree
3 2 (1.67%) ITIL Certification
3 2 (1.67%) SC Cleared
3 2 (1.67%) Security Cleared
4 1 (0.83%) BPSS Clearance
4 1 (0.83%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 15 (12.50%) QA
2 10 (8.33%) Data Quality
3 8 (6.67%) Solvency II
4 1 (0.83%) GDPR
System Software
1 1 (0.83%) Active Directory
1 1 (0.83%) Virtual Machines
Systems Management
1 1 (0.83%) Control-M
1 1 (0.83%) HP ALM
1 1 (0.83%) Kubernetes
1 1 (0.83%) Oozie
1 1 (0.83%) Terraform
Vendors
1 36 (30.00%) Microsoft
2 14 (11.67%) Oracle
3 12 (10.00%) Cognos
4 11 (9.17%) Tableau
5 8 (6.67%) SAP
6 6 (5.00%) Informatica
7 5 (4.17%) Cloudera
7 5 (4.17%) Databricks
8 4 (3.33%) Salesforce.com
9 3 (2.50%) Google
9 3 (2.50%) MuleSoft
10 2 (1.67%) IBM
10 2 (1.67%) Pega
11 1 (0.83%) Citrix
11 1 (0.83%) HP
11 1 (0.83%) Infragistics
11 1 (0.83%) Sun
11 1 (0.83%) Sybase
11 1 (0.83%) Telerik
11 1 (0.83%) Teradata