Period
to 26 July 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 26 July 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
26 Jul 2021
Same period 2020 Same period 2019
Rank 63 49 64
Rank change year-on-year -14 +15 +18
Contract jobs citing Data Warehouse 121 103 256
As % of all contract jobs advertised in the City of London 3.57% 4.25% 3.86%
As % of the Database & Business Intelligence category 16.58% 16.78% 14.07%
Number of daily rates quoted 82 76 195
10th Percentile £414 £369 £407
25th Percentile £463 £413 £413
Median daily rate (50th Percentile) £550 £481 £513
Median % change year-on-year +14.29% -6.10% +7.89%
75th Percentile £625 £575 £575
90th Percentile £709 £675 £622
Central London median daily rate £550 £481 £525
% change year-on-year +14.29% -8.33% +8.25%
Number of hourly rates quoted 4 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 730 614 1,820
As % of all contract IT jobs advertised in the City of London 21.51% 25.33% 27.43%
Number of daily rates quoted 504 460 1,447
10th Percentile £406 £381 £399
25th Percentile £463 £425 £456
Median daily rate (50th Percentile) £550 £514 £525
Median % change year-on-year +7.06% -2.14% -
75th Percentile £650 £601 £613
90th Percentile £713 £688 £675
Central London median daily rate £550 £519 £525
% change year-on-year +6.02% -1.19% -
Number of hourly rates quoted 7 6 12
Median hourly rate £8.00 £38.00 £35.00
Median % change year-on-year -78.95% +8.57% +59.09%
Central London median hourly rate £14.00 £38.00 £35.00
% change year-on-year -63.16% +8.57% +57.30%

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 26 July 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
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 26 July 2021. 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 -4 4 £600 +50.00%
Data Warehouse
Central London

For the 6 months to 26 July 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 80 (66.12%) Business Intelligence
2 78 (64.46%) SQL
3 64 (52.89%) Finance
4 53 (43.80%) Analytics
5 49 (40.50%) Agile Software Development
6 43 (35.54%) Azure
7 35 (28.93%) Python
8 32 (26.45%) Power BI
8 32 (26.45%) Power Platform
9 31 (25.62%) Data Modelling
10 29 (23.97%) SQL Server Integration Services
10 29 (23.97%) Degree
10 29 (23.97%) Problem-Solving
11 28 (23.14%) Analytical Skills
12 27 (22.31%) AWS
12 27 (22.31%) Microsoft
13 26 (21.49%) Management Information System
13 26 (21.49%) Data Analysis
13 26 (21.49%) Decision-Making
14 25 (20.66%) Visualisation
14 25 (20.66%) ETL
15 23 (19.01%) SQL Server
16 22 (18.18%) CRM
16 22 (18.18%) Mentoring
16 22 (18.18%) Algorithms
16 22 (18.18%) Machine Learning
17 21 (17.36%) Data Science
17 21 (17.36%) Asset Management
18 20 (16.53%) Marketing
18 20 (16.53%) QlikView

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 (14.05%) Jupyter
2 7 (5.79%) Apache Spark
3 4 (3.31%) Apache Airflow
4 2 (1.65%) Apache
4 2 (1.65%) IIS
4 2 (1.65%) Oracle SOA Suite
4 2 (1.65%) SharePoint
5 1 (0.83%) Confluence
5 1 (0.83%) SAS
Applications
1 18 (14.88%) Microsoft Excel
2 17 (14.05%) Microsoft PowerPoint
3 1 (0.83%) SPSS
Business Applications
1 2 (1.65%) Markit EDM
2 1 (0.83%) Oracle BPM
2 1 (0.83%) Salesforce.com CRM
2 1 (0.83%) SAP MDG
2 1 (0.83%) SAP MDM
Cloud Services
1 43 (35.54%) Azure
2 32 (26.45%) Power Platform
3 27 (22.31%) AWS
4 12 (9.92%) Azure Data Factory
5 5 (4.13%) Amazon S3
5 5 (4.13%) GCP
6 4 (3.31%) Amazon Kinesis
6 4 (3.31%) Snowflake
7 3 (2.48%) Amazon EC2
7 3 (2.48%) Azure Data Lake Analytics
8 2 (1.65%) Azure Synapse Analytics
8 2 (1.65%) GitHub
8 2 (1.65%) PaaS
9 1 (0.83%) Amazon CloudWatch
9 1 (0.83%) Amazon EMR
9 1 (0.83%) Amazon SQS
9 1 (0.83%) AWS CloudFormation
9 1 (0.83%) Datadog
9 1 (0.83%) IaaS
9 1 (0.83%) Virtual Private Cloud
Communications & Networking
1 6 (4.96%) HTTP
2 1 (0.83%) DNS
2 1 (0.83%) FTP
2 1 (0.83%) Kerberos
2 1 (0.83%) SMTP
Database & Business Intelligence
1 32 (26.45%) Power BI
2 29 (23.97%) SQL Server Integration Services
3 23 (19.01%) SQL Server
4 20 (16.53%) QlikView
5 17 (14.05%) Data Lake
6 15 (12.40%) Big Data
7 14 (11.57%) SQL Server Analysis Services
8 9 (7.44%) Amazon Redshift
8 9 (7.44%) SQL Server Reporting Services
9 8 (6.61%) Azure SQL Database
10 7 (5.79%) Azure SQL Data Warehouse
11 6 (4.96%) DB2
12 5 (4.13%) Microsoft Analysis Services
12 5 (4.13%) Star Schema
12 5 (4.13%) Tableau
13 4 (3.31%) Electronic Patient Records
13 4 (3.31%) Hadoop
13 4 (3.31%) Parquet
13 4 (3.31%) PostgreSQL
14 3 (2.48%) BusinessObjects
Development Applications
1 5 (4.13%) JIRA
1 5 (4.13%) Visual Studio
2 4 (3.31%) Git (software)
3 3 (2.48%) Cucumber
3 3 (2.48%) Jenkins
3 3 (2.48%) Selenium
3 3 (2.48%) SpecFlow
3 3 (2.48%) Team Foundation Server
4 2 (1.65%) FitNesse
5 1 (0.83%) ERwin
5 1 (0.83%) GoCD
5 1 (0.83%) Oracle APEX
5 1 (0.83%) Subversion
General
1 64 (52.89%) Finance
2 28 (23.14%) Analytical Skills
3 20 (16.53%) Marketing
3 20 (16.53%) Social Skills
4 19 (15.70%) Presentation Skills
5 18 (14.88%) Banking
6 6 (4.96%) Public Sector
7 4 (3.31%) Financial Institution
7 4 (3.31%) Investment Banking
8 3 (2.48%) Legal
9 2 (1.65%) Law
10 1 (0.83%) Back Office
10 1 (0.83%) Documentation Skills
10 1 (0.83%) Front Office
10 1 (0.83%) General Ledger
10 1 (0.83%) Influencing Skills
10 1 (0.83%) Manufacturing
10 1 (0.83%) Organisational Skills
10 1 (0.83%) Pharmaceutical
10 1 (0.83%) Private Banking
Job Titles
1 32 (26.45%) Developer
2 20 (16.53%) Analyst
3 18 (14.88%) Data Scientist
4 13 (10.74%) Architect
5 11 (9.09%) Data Engineer
6 8 (6.61%) Project Manager
7 7 (5.79%) Azure Developer
7 7 (5.79%) Business Systems Analyst
7 7 (5.79%) SQL Analyst
8 6 (4.96%) Data Architect
8 6 (4.96%) Systems Analyst
9 5 (4.13%) Business Intelligence Analyst
9 5 (4.13%) Business Intelligence Developer
9 5 (4.13%) ETL Developer
9 5 (4.13%) SSIS Developer
9 5 (4.13%) Technical Manager
10 4 (3.31%) Banking Project Manager
10 4 (3.31%) Delivery Manager
10 4 (3.31%) Python Engineer
10 4 (3.31%) Technical Delivery Manager
Libraries, Frameworks & Software Standards
1 17 (14.05%) D3.js
1 17 (14.05%) Shiny
2 10 (8.26%) XML
3 8 (6.61%) .NET
4 6 (4.96%) HTML
5 5 (4.13%) JSON
5 5 (4.13%) Kafka
5 5 (4.13%) SOAP
5 5 (4.13%) Spring
5 5 (4.13%) Web Services
6 4 (3.31%) MDX
6 4 (3.31%) PostGIS
6 4 (3.31%) REST
7 3 (2.48%) Gherkin
8 2 (1.65%) ASP.NET
8 2 (1.65%) PySpark
8 2 (1.65%) RESTful
8 2 (1.65%) Spring Boot
9 1 (0.83%) LDAP
9 1 (0.83%) Web Dynpro
Miscellaneous
1 26 (21.49%) Management Information System
2 22 (18.18%) Algorithms
3 17 (14.05%) Social Media
4 14 (11.57%) Credit Risk
5 7 (5.79%) Data Structures
6 6 (4.96%) iSeries
7 5 (4.13%) Market Risk
7 5 (4.13%) Self-Motivation
8 4 (3.31%) Enterprise Cloud
8 4 (3.31%) PMI
9 2 (1.65%) New Media
9 2 (1.65%) Video\Live Streaming
9 2 (1.65%) Virtual Team
10 1 (0.83%) BYOD
10 1 (0.83%) Data Centre
10 1 (0.83%) Enterprise Software
10 1 (0.83%) Legacy Applications
10 1 (0.83%) Legacy Systems
10 1 (0.83%) Linux Command Line
10 1 (0.83%) Reinsurance
Operating Systems
1 3 (2.48%) Linux
1 3 (2.48%) Unix
1 3 (2.48%) Windows
2 1 (0.83%) Red Hat Enterprise Linux
2 1 (0.83%) Windows Server 2012
Processes & Methodologies
1 80 (66.12%) Business Intelligence
2 53 (43.80%) Analytics
3 49 (40.50%) Agile Software Development
4 31 (25.62%) Data Modelling
5 29 (23.97%) Problem-Solving
6 26 (21.49%) Data Analysis
6 26 (21.49%) Decision-Making
7 25 (20.66%) ETL
7 25 (20.66%) Visualisation
8 22 (18.18%) CRM
8 22 (18.18%) Machine Learning
8 22 (18.18%) Mentoring
9 21 (17.36%) Asset Management
9 21 (17.36%) Data Science
10 20 (16.53%) Investment Management
11 19 (15.70%) DevOps
11 19 (15.70%) Mathematics
12 18 (14.88%) Bayesian Methods
12 18 (14.88%) Data Sharing
12 18 (14.88%) Digital Analytics
Programming Languages
1 78 (64.46%) SQL
2 35 (28.93%) Python
3 17 (14.05%) R
3 17 (14.05%) VBA
4 9 (7.44%) Java
5 8 (6.61%) C#
5 8 (6.61%) T-SQL
6 5 (4.13%) Data Analysis Expressions (DAX)
7 3 (2.48%) PowerShell
8 2 (1.65%) PL/SQL
9 1 (0.83%) ABAP
9 1 (0.83%) JavaScript
9 1 (0.83%) Shell Script
Qualifications
1 29 (23.97%) Degree
2 7 (5.79%) Computer Science Degree
2 7 (5.79%) ITIL Certification
3 4 (3.31%) PMI Certification
4 1 (0.83%) Master's Degree
4 1 (0.83%) SC Cleared
4 1 (0.83%) Security Cleared
4 1 (0.83%) TOGAF Certification
Quality Assurance & Compliance
1 5 (4.13%) QA
2 3 (2.48%) Data Quality
2 3 (2.48%) GRC
3 1 (0.83%) Accessibility
3 1 (0.83%) COBIT
3 1 (0.83%) GDPR
3 1 (0.83%) Sarbanes-Oxley
3 1 (0.83%) Solvency II
System Software
1 2 (1.65%) Docker
2 1 (0.83%) Active Directory
Systems Management
1 1 (0.83%) Control-M
1 1 (0.83%) Terraform
Vendors
1 27 (22.31%) Microsoft
2 20 (16.53%) Salesforce.com
3 18 (14.88%) Alteryx
4 13 (10.74%) Oracle
5 9 (7.44%) Databricks
6 3 (2.48%) SAP
6 3 (2.48%) Talend
7 2 (1.65%) Informatica
8 1 (0.83%) Cognos
8 1 (0.83%) Google
8 1 (0.83%) IBM
8 1 (0.83%) Red Hat
8 1 (0.83%) Salesforce Marketing Cloud
8 1 (0.83%) ServiceNow
8 1 (0.83%) StreamSets
8 1 (0.83%) Teradata