Period
to 3 June 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 3 June 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
3 Jun 2020
Same period 2019 Same period 2018
Rank 52 66 84
Rank change year-on-year +14 +18 -25
Contract jobs citing Data Warehouse 108 225 198
As % of all contract jobs advertised in the City of London 3.63% 3.55% 2.87%
As % of the Database & Business Intelligence category 15.15% 13.91% 11.37%
Number of daily rates quoted 71 176 168
Median daily rate £475 £505 £485
Median daily rate % change year-on-year -5.94% +4.12% +2.11%
10th Percentile £375 £390 £375
90th Percentile £675 £613 £613
Central London median daily rate £475 £525 £500
% change year-on-year -9.52% +5.00% +5.26%
Number of hourly rates quoted 0 0 0
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 713 1,618 1,741
As % of all contract IT jobs advertised in the City of London 23.95% 25.54% 25.20%
Number of daily rates quoted 511 1,275 1,425
Median daily rate £500 £525 £525
Median daily rate % change year-on-year -4.76% - +5.00%
10th Percentile £363 £406 £363
90th Percentile £675 £675 £675
Central London median daily rate £500 £525 £513
% change year-on-year -4.76% +2.44% +4.06%
Number of hourly rates quoted 8 9 10
Median hourly rate £35.00 £44.57 £22.25
Median hourly rate % change year-on-year -21.46% +100.29% -0.38%
10th Percentile £23.60 £30.45 £20.63
90th Percentile £41.80 £57.35 £36.90
Median hourly rate £35.00 £35.00 £30.00
% change year-on-year - +16.67% +34.32%

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 3 June 2020.

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 3 June 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 +16 2 £400 -27.27%
Data Warehouse
Central London

For the 6 months to 3 June 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 69 (63.89%) SQL
2 60 (55.56%) Business Intelligence
3 51 (47.22%) ETL
4 45 (41.67%) Finance
5 43 (39.81%) SQL Server Integration Services
6 42 (38.89%) Agile Software Development
7 32 (29.63%) SQL Server
8 30 (27.78%) Kimball Methodology
9 29 (26.85%) Microsoft
9 29 (26.85%) SQL Server Reporting Services
9 29 (26.85%) Azure
10 25 (23.15%) SQL Server Analysis Services
11 23 (21.30%) Analytics
12 22 (20.37%) Data Modelling
12 22 (20.37%) Python
12 22 (20.37%) Microsoft Excel
13 21 (19.44%) Power BI
13 21 (19.44%) Power Platform
14 20 (18.52%) T-SQL
15 19 (17.59%) SDLC
16 16 (14.81%) DevOps
16 16 (14.81%) Oracle
16 16 (14.81%) Information Management
17 15 (13.89%) Banking
18 14 (12.96%) Change Management
18 14 (12.96%) .NET
19 13 (12.04%) C#
19 13 (12.04%) Portfolio Management
19 13 (12.04%) Analytical Skills
20 12 (11.11%) Data Development

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 6 (5.56%) SAS
2 3 (2.78%) Apache Spark
3 2 (1.85%) Elasticsearch
3 2 (1.85%) Oracle Workflow
4 1 (0.93%) Apache Airflow
4 1 (0.93%) Apache Pig
4 1 (0.93%) Apache Pulsar
4 1 (0.93%) SharePoint
4 1 (0.93%) WebLogic
Applications
1 22 (20.37%) Microsoft Excel
2 1 (0.93%) Microsoft Office
2 1 (0.93%) Microsoft PowerPoint
2 1 (0.93%) MS Visio
Business Applications
1 1 (0.93%) Infor SunSystems
1 1 (0.93%) Oracle General Ledger
1 1 (0.93%) Oracle Internet Expenses
1 1 (0.93%) Oracle iProcurement
1 1 (0.93%) Oracle Procure-to-Pay
1 1 (0.93%) SAP BPC
Cloud Services
1 29 (26.85%) Azure
2 21 (19.44%) Power Platform
3 12 (11.11%) AWS
4 6 (5.56%) Azure Data Factory
4 6 (5.56%) GCP
5 2 (1.85%) SaaS
5 2 (1.85%) Serverless
6 1 (0.93%) Amazon Kinesis
6 1 (0.93%) AWS Lambda
6 1 (0.93%) Azure Functions
6 1 (0.93%) Data Lake Analytics
6 1 (0.93%) PaaS
Communications & Networking
1 5 (4.63%) Firewall
Database & Business Intelligence
1 43 (39.81%) SQL Server Integration Services
2 32 (29.63%) SQL Server
3 29 (26.85%) SQL Server Reporting Services
4 25 (23.15%) SQL Server Analysis Services
5 21 (19.44%) Power BI
6 10 (9.26%) Azure SQL Data Warehouse
7 7 (6.48%) Azure SQL Database
7 7 (6.48%) Microsoft Analysis Services
7 7 (6.48%) OLAP
8 6 (5.56%) Big Data
8 6 (5.56%) NoSQL
9 5 (4.63%) BusinessObjects
9 5 (4.63%) Hadoop
9 5 (4.63%) PowerPivot
9 5 (4.63%) SQL Server 2016
9 5 (4.63%) SSDT
10 4 (3.70%) Data Lake
10 4 (3.70%) Star Schema
11 3 (2.78%) Relational Database
11 3 (2.78%) SAS EBI
Development Applications
1 8 (7.41%) Team Foundation Server
2 6 (5.56%) SQL Server Management Studio (SSMS)
2 6 (5.56%) Visual Studio
3 5 (4.63%) Eclipse
4 1 (0.93%) Git (software)
4 1 (0.93%) GitLab
4 1 (0.93%) Jenkins
4 1 (0.93%) JIRA
4 1 (0.93%) Subversion
General
1 45 (41.67%) Finance
2 15 (13.89%) Banking
3 7 (6.48%) Law
4 6 (5.56%) Investment Banking
5 4 (3.70%) Front Office
6 3 (2.78%) Retail
7 2 (1.85%) Back Office
7 2 (1.85%) Financial Institution
7 2 (1.85%) General Ledger
7 2 (1.85%) International Banking
7 2 (1.85%) Legal
7 2 (1.85%) Marketing
7 2 (1.85%) Public Sector
8 1 (0.93%) Billing
Job Titles
1 40 (37.04%) Developer
2 24 (22.22%) Analyst
3 15 (13.89%) Architect
4 13 (12.04%) Data Warehouse Analyst
4 13 (12.04%) Technical Analyst
5 12 (11.11%) ETL Analyst
5 12 (11.11%) SQL Analyst
5 12 (11.11%) SQL Developer
6 11 (10.19%) Business Intelligence Developer
7 8 (7.41%) SQL Data Analyst
8 7 (6.48%) Business Intelligence Analyst
8 7 (6.48%) SSIS Analyst
9 6 (5.56%) Data Architect
9 6 (5.56%) Data Engineer
9 6 (5.56%) Data Warehouse Developer
9 6 (5.56%) Senior Developer
9 6 (5.56%) SSIS Developer
10 5 (4.63%) Business Analyst
10 5 (4.63%) Consultant
10 5 (4.63%) Platform Engineer
Libraries, Frameworks & Software Standards
1 14 (12.96%) .NET
2 8 (7.41%) MDX
3 7 (6.48%) ASP.NET
4 4 (3.70%) HTML
5 3 (2.78%) CSS
5 3 (2.78%) Web Services
6 2 (1.85%) AngularJS
6 2 (1.85%) D3.js
6 2 (1.85%) Kafka
6 2 (1.85%) Oracle Fusion
6 2 (1.85%) SOAP
6 2 (1.85%) XML
7 1 (0.93%) .NET Framework
7 1 (0.93%) Anaconda
7 1 (0.93%) Apache NiFi
7 1 (0.93%) ASP.NET MVC
7 1 (0.93%) Node.js
7 1 (0.93%) PySpark
7 1 (0.93%) Velocity
7 1 (0.93%) WinForms
Miscellaneous
1 13 (12.04%) Analytical Skills
2 6 (5.56%) Management Information System
3 4 (3.70%) Reinsurance
4 3 (2.78%) Credit Risk
4 3 (2.78%) Data Protection Act
4 3 (2.78%) Fat Client
4 3 (2.78%) Thin Client
5 2 (1.85%) Equities
5 2 (1.85%) Fixed Income
5 2 (1.85%) NHS
6 1 (0.93%) Data Centre
6 1 (0.93%) Data Structures
6 1 (0.93%) Tandem
Operating Systems
1 5 (4.63%) Unix
2 2 (1.85%) Linux
2 2 (1.85%) Windows
3 1 (0.93%) Red Hat Enterprise Linux
Processes & Methodologies
1 60 (55.56%) Business Intelligence
2 51 (47.22%) ETL
3 42 (38.89%) Agile Software Development
4 30 (27.78%) Kimball Methodology
5 23 (21.30%) Analytics
6 22 (20.37%) Data Modelling
7 19 (17.59%) SDLC
8 16 (14.81%) DevOps
8 16 (14.81%) Information Management
9 14 (12.96%) Change Management
10 13 (12.04%) Portfolio Management
11 12 (11.11%) Data Development
11 12 (11.11%) Requirements Gathering
12 11 (10.19%) Scrum
13 10 (9.26%) Data Analysis
13 10 (9.26%) Data Protection
13 10 (9.26%) Problem-Solving
14 9 (8.33%) Machine Learning
15 8 (7.41%) Business Analysis
15 8 (7.41%) Migration
Programming Languages
1 69 (63.89%) SQL
2 22 (20.37%) Python
3 20 (18.52%) T-SQL
4 13 (12.04%) C#
5 10 (9.26%) Java
5 10 (9.26%) R
6 9 (8.33%) JavaScript
7 7 (6.48%) Data Analysis Expressions (DAX)
7 7 (6.48%) PL/SQL
8 6 (5.56%) Scala
9 5 (4.63%) Go
9 5 (4.63%) Groovy
9 5 (4.63%) Ruby
10 4 (3.70%) Shell Script
10 4 (3.70%) VB.NET
11 3 (2.78%) Perl
11 3 (2.78%) PowerShell
11 3 (2.78%) VB
11 3 (2.78%) VBA
12 2 (1.85%) SAS Macro
Qualifications
1 4 (3.70%) Degree
2 3 (2.78%) MCITP
2 3 (2.78%) Microsoft Certification
3 2 (1.85%) SC Cleared
3 2 (1.85%) Security Cleared
4 1 (0.93%) ACCA
4 1 (0.93%) CIMA
4 1 (0.93%) TOGAF Certification
Quality Assurance & Compliance
1 9 (8.33%) Solvency II
2 7 (6.48%) QA
3 5 (4.63%) Data Quality
4 3 (2.78%) IFRS
5 1 (0.93%) GDPR
System Software
1 1 (0.93%) Apache Flume
1 1 (0.93%) Docker
1 1 (0.93%) HDFS
1 1 (0.93%) Virtual Machines
Systems Management
1 5 (4.63%) Terraform
2 2 (1.85%) Control-M
3 1 (0.93%) HP ALM
Vendors
1 29 (26.85%) Microsoft
2 16 (14.81%) Oracle
3 7 (6.48%) Tableau
4 6 (5.56%) Cognos
5 5 (4.63%) Informatica
6 4 (3.70%) SAP
7 3 (2.78%) Databricks
7 3 (2.78%) Hyperion
7 3 (2.78%) Sybase
8 2 (1.85%) BMC
8 2 (1.85%) Cloudera
8 2 (1.85%) DocuSign
8 2 (1.85%) IBM
9 1 (0.93%) Citrix
9 1 (0.93%) Google
9 1 (0.93%) HP
9 1 (0.93%) Infragistics
9 1 (0.93%) Pega
9 1 (0.93%) Sun
9 1 (0.93%) Talend