Period
to 18 October 2021

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 18 October 2021 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
18 Oct 2021
Same period 2020 Same period 2019
Rank 53 46 61
Rank change year-on-year -7 +15 +26
Contract jobs citing Data Warehouse 149 85 229
As % of all contract jobs advertised in the City of London 3.86% 4.80% 3.84%
As % of the Database & Business Intelligence category 16.95% 18.24% 15.10%
Number of daily rates quoted 106 62 180
10th Percentile £444 £413 £406
25th Percentile £502 £463 £455
Median daily rate (50th Percentile) £563 £483 £521
Median % change year-on-year +16.42% -7.31% +9.74%
75th Percentile £632 £538 £575
90th Percentile £713 £650 £618
Central London median daily rate £550 £500 £525
% change year-on-year +10.00% -4.76% +10.53%
Number of hourly rates quoted 5 0 0
Median hourly rate £8.00 - -
Central London median hourly rate £8.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 879 466 1,517
As % of all contract IT jobs advertised in the City of London 22.78% 26.30% 25.41%
Number of daily rates quoted 660 351 1,218
10th Percentile £381 £363 £388
25th Percentile £487 £425 £463
Median daily rate (50th Percentile) £570 £525 £525
Median % change year-on-year +8.57% - -
75th Percentile £663 £600 £612
90th Percentile £738 £675 £688
Central London median daily rate £570 £525 £525
% change year-on-year +8.57% - -
Number of hourly rates quoted 8 5 5
10th Percentile " £18.20 £21.20
25th Percentile £8.00 £20.00 £21.25
Median hourly rate £15.25 £22.00 £44.57
Median % change year-on-year -30.68% -50.63% +39.27%
75th Percentile £33.69 £38.25 £49.13
90th Percentile £43.33 £38.85 £52.95
Central London median hourly rate £15.25 £22.00 £44.57
% change year-on-year -30.68% -50.63% +39.27%

Data Warehouse
Job Vacancy Trend in the City of London

Job postings citing Data Warehouse as a proportion 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

3-month moving average daily rate quoted in jobs citing Data Warehouse in the City of London.

Daily rate trend for Data Warehouse in the City of London

Data Warehouse
Daily Rate Histogram in the City of London

Daily rate distribution for jobs citing Data Warehouse in the City of London over the 6 months to 18 October 2021.

Daily rate histogram for Data Warehouse in the City of London

Data Warehouse
Contractor Hourly Rate Trend in the City of London

3-month moving average hourly rates quoted in jobs citing Data Warehouse in the City of London.

Hourly rate trend for Data Warehouse in the City of London

Data Warehouse
Hourly Rate Histogram in the City of London

Hourly rate distribution of jobs citing Data Warehouse in the City of London over the 6 months to 18 October 2021.

Hourly rate histogram for Data Warehouse in the City of London

For the 6 months to 18 October 2021, 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 99 (66.44%) SQL
2 85 (57.05%) Business Intelligence
3 78 (52.35%) Finance
4 57 (38.26%) Azure
5 54 (36.24%) Analytics
6 52 (34.90%) Agile Software Development
7 43 (28.86%) SQL Server
8 40 (26.85%) SQL Server Integration Services
9 39 (26.17%) Microsoft
9 39 (26.17%) Python
10 37 (24.83%) ETL
10 37 (24.83%) Power BI
10 37 (24.83%) Power Platform
11 33 (22.15%) Data Modelling
11 33 (22.15%) Problem-Solving
12 31 (20.81%) Social Skills
12 31 (20.81%) Degree
13 30 (20.13%) Analytical Skills
14 27 (18.12%) DevOps
15 26 (17.45%) Data Analysis
15 26 (17.45%) Management Information System
16 25 (16.78%) Visualisation
17 23 (15.44%) AWS
17 23 (15.44%) Banking
17 23 (15.44%) Microsoft Excel
17 23 (15.44%) CRM
18 22 (14.77%) Mathematics
19 21 (14.09%) SQL Server Analysis Services
19 21 (14.09%) Mentoring
19 21 (14.09%) Decision-Making

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 15 (10.07%) Jupyter
2 5 (3.36%) Apache Spark
3 2 (1.34%) Apache
3 2 (1.34%) Confluence
3 2 (1.34%) IIS
4 1 (0.67%) Apache Airflow
4 1 (0.67%) SAS
4 1 (0.67%) SharePoint
Applications
1 23 (15.44%) Microsoft Excel
2 16 (10.74%) Microsoft PowerPoint
Business Applications
1 1 (0.67%) NetSuite
1 1 (0.67%) Salesforce.com CRM
Cloud Services
1 57 (38.26%) Azure
2 37 (24.83%) Power Platform
3 23 (15.44%) AWS
4 13 (8.72%) Azure Data Factory
5 6 (4.03%) Amazon S3
5 6 (4.03%) GCP
6 4 (2.68%) GitHub
6 4 (2.68%) Matillion
6 4 (2.68%) PaaS
7 3 (2.01%) Amazon EC2
7 3 (2.01%) Amazon EMR
7 3 (2.01%) Azure Logic Apps
7 3 (2.01%) Datadog
7 3 (2.01%) IaaS
8 2 (1.34%) Azure Data Lake Analytics
8 2 (1.34%) Azure Stack
8 2 (1.34%) Azure Storage
8 2 (1.34%) Azure Synapse Analytics
8 2 (1.34%) Cloud Computing
8 2 (1.34%) Google Data Studio
Communications & Networking
1 1 (0.67%) DNS
1 1 (0.67%) FTP
1 1 (0.67%) HTTP
1 1 (0.67%) Intranet
1 1 (0.67%) Kerberos
1 1 (0.67%) SMTP
Database & Business Intelligence
1 43 (28.86%) SQL Server
2 40 (26.85%) SQL Server Integration Services
3 37 (24.83%) Power BI
4 21 (14.09%) SQL Server Analysis Services
5 17 (11.41%) Data Lake
5 17 (11.41%) QlikView
6 15 (10.07%) SQL Server Reporting Services
7 11 (7.38%) Big Data
8 10 (6.71%) Azure SQL Data Warehouse
8 10 (6.71%) Azure SQL Database
9 8 (5.37%) Amazon Redshift
9 8 (5.37%) Tableau
10 7 (4.70%) Microsoft Analysis Services
11 6 (4.03%) Hadoop
12 5 (3.36%) DB2
12 5 (3.36%) MongoDB
12 5 (3.36%) PostgreSQL
13 4 (2.68%) Amazon Athena
13 4 (2.68%) Relational Database
13 4 (2.68%) SSDT
Development Applications
1 11 (7.38%) Team Foundation Server
1 11 (7.38%) Visual Studio
2 6 (4.03%) JIRA
2 6 (4.03%) Selenium
2 6 (4.03%) SpecFlow
3 5 (3.36%) Git (software)
4 3 (2.01%) Appium
4 3 (2.01%) Cucumber
4 3 (2.01%) Jenkins
4 3 (2.01%) Maven
4 3 (2.01%) Octopus Deploy
4 3 (2.01%) TeamCity
4 3 (2.01%) TestNG
4 3 (2.01%) WebDriver
4 3 (2.01%) Zephyr
5 1 (0.67%) GoCD
5 1 (0.67%) Subversion
5 1 (0.67%) Visual Studio Team System
General
1 78 (52.35%) Finance
2 31 (20.81%) Social Skills
3 30 (20.13%) Analytical Skills
4 23 (15.44%) Banking
5 20 (13.42%) Marketing
5 20 (13.42%) Presentation Skills
6 8 (5.37%) Investment Banking
7 7 (4.70%) Law
8 6 (4.03%) Legal
9 5 (3.36%) Financial Institution
10 3 (2.01%) Manufacturing
11 2 (1.34%) Documentation Skills
11 2 (1.34%) Front Office
11 2 (1.34%) International Banking
11 2 (1.34%) Organisational Skills
12 1 (0.67%) Corporate Banking
12 1 (0.67%) Influencing Skills
12 1 (0.67%) Private Banking
12 1 (0.67%) Public Sector
12 1 (0.67%) Retail Banking
Job Titles
1 37 (24.83%) Developer
2 36 (24.16%) Analyst
3 17 (11.41%) Data Scientist
4 15 (10.07%) Architect
5 14 (9.40%) Data Engineer
6 12 (8.05%) Data Analyst
7 11 (7.38%) Azure Developer
8 10 (6.71%) Analyst Developer
9 8 (5.37%) Data Warehouse Analyst
9 8 (5.37%) Project Manager
10 7 (4.70%) Business Intelligence Developer
11 6 (4.03%) Business Analyst
11 6 (4.03%) Data Warehouse Developer
11 6 (4.03%) Senior Analyst
12 5 (3.36%) Business Intelligence Analyst
12 5 (3.36%) SSIS Developer
12 5 (3.36%) Test Analyst
13 4 (2.68%) IT Analyst
13 4 (2.68%) Senior Test Analyst
13 4 (2.68%) SQL Analyst
Libraries, Frameworks & Software Standards
1 15 (10.07%) .NET
1 15 (10.07%) D3.js
1 15 (10.07%) Shiny
2 5 (3.36%) ASP.NET
2 5 (3.36%) Spring
3 4 (2.68%) JSON
3 4 (2.68%) MDX
3 4 (2.68%) XML
4 3 (2.01%) .NET Framework
4 3 (2.01%) Gherkin
4 3 (2.01%) HTML
4 3 (2.01%) Kafka
5 2 (1.34%) LINQ
5 2 (1.34%) PySpark
5 2 (1.34%) REST
5 2 (1.34%) RESTful
5 2 (1.34%) SOAP
5 2 (1.34%) Spring Boot
5 2 (1.34%) WCF
5 2 (1.34%) Web Services
Miscellaneous
1 26 (17.45%) Management Information System
2 17 (11.41%) Algorithms
3 16 (10.74%) Social Media
4 12 (8.05%) Credit Risk
5 7 (4.70%) Market Risk
6 5 (3.36%) Reinsurance
7 3 (2.01%) Data Centre
7 3 (2.01%) iSeries
7 3 (2.01%) Self-Motivation
8 2 (1.34%) Data Structures
8 2 (1.34%) Enterprise Cloud
8 2 (1.34%) Hedge funds
8 2 (1.34%) Legacy Systems
8 2 (1.34%) New Media
8 2 (1.34%) NHS
8 2 (1.34%) PMI
8 2 (1.34%) Replication
8 2 (1.34%) Video\Live Streaming
9 1 (0.67%) Enterprise Software
9 1 (0.67%) Legacy Applications
Operating Systems
1 4 (2.68%) Linux
2 2 (1.34%) Unix
2 2 (1.34%) Windows
3 1 (0.67%) Windows Server 2012
Processes & Methodologies
1 85 (57.05%) Business Intelligence
2 54 (36.24%) Analytics
3 52 (34.90%) Agile Software Development
4 37 (24.83%) ETL
5 33 (22.15%) Data Modelling
5 33 (22.15%) Problem-Solving
6 27 (18.12%) DevOps
7 26 (17.45%) Data Analysis
8 25 (16.78%) Visualisation
9 23 (15.44%) CRM
10 22 (14.77%) Mathematics
11 21 (14.09%) Decision-Making
11 21 (14.09%) Mentoring
12 20 (13.42%) Data Management
12 20 (13.42%) Data Science
13 19 (12.75%) Asset Management
14 17 (11.41%) Data Sharing
14 17 (11.41%) Digital Analytics
14 17 (11.41%) Investment Management
14 17 (11.41%) Statistics
Programming Languages
1 99 (66.44%) SQL
2 39 (26.17%) Python
3 20 (13.42%) C#
4 16 (10.74%) T-SQL
4 16 (10.74%) VBA
5 15 (10.07%) R
6 12 (8.05%) Java
7 7 (4.70%) Data Analysis Expressions (DAX)
8 3 (2.01%) PowerShell
8 3 (2.01%) VBScript
9 2 (1.34%) JavaScript
9 2 (1.34%) PHP
9 2 (1.34%) PL/SQL
10 1 (0.67%) C
10 1 (0.67%) VB
Qualifications
1 31 (20.81%) Degree
2 10 (6.71%) Computer Science Degree
3 3 (2.01%) ISTQB
3 3 (2.01%) ISTQB Foundation Certification
3 3 (2.01%) ITIL Certification
3 3 (2.01%) Numerate Degree
4 2 (1.34%) AWS Certification
4 2 (1.34%) ISTQB Advanced Certification
4 2 (1.34%) PMI Certification
5 1 (0.67%) Security Cleared
5 1 (0.67%) TOGAF Certification
Quality Assurance & Compliance
1 10 (6.71%) Data Quality
1 10 (6.71%) QA
2 5 (3.36%) GDPR
3 2 (1.34%) GRC
3 2 (1.34%) Sarbanes-Oxley
3 2 (1.34%) Solvency II
4 1 (0.67%) Accessibility
4 1 (0.67%) COBIT
4 1 (0.67%) GMP
4 1 (0.67%) IFRS
4 1 (0.67%) SLA
System Software
1 5 (3.36%) Docker
2 1 (0.67%) Active Directory
2 1 (0.67%) HDFS
2 1 (0.67%) Oracle RAC
Systems Management
1 2 (1.34%) Terraform
2 1 (0.67%) Control-M
2 1 (0.67%) Enterprise Manager Cloud Control
2 1 (0.67%) Foglight
2 1 (0.67%) Oracle Enterprise Manager
Vendors
1 39 (26.17%) Microsoft
2 20 (13.42%) Salesforce.com
3 16 (10.74%) Alteryx
4 12 (8.05%) Oracle
5 10 (6.71%) Databricks
6 5 (3.36%) Google
7 3 (2.01%) Guidewire
7 3 (2.01%) SAP
7 3 (2.01%) StreamSets
8 2 (1.34%) Ab Initio
8 2 (1.34%) AppDynamics
8 2 (1.34%) Splunk
9 1 (0.67%) Cognos
9 1 (0.67%) Informatica
9 1 (0.67%) MapR
9 1 (0.67%) Pega
9 1 (0.67%) Salesforce Marketing Cloud
9 1 (0.67%) ServiceNow
9 1 (0.67%) Teradata
9 1 (0.67%) Yardi