Period
to 28 May 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 28 May 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
28 May 2020
Same period 2019 Same period 2018
Rank 56 69 87
Rank change year-on-year +13 +18 -26
Contract jobs citing Data Warehouse 143 316 271
As % of all contract jobs advertised in Central London 3.78% 3.76% 2.97%
As % of the Database & Business Intelligence category 15.49% 14.60% 11.77%
Number of daily rates quoted 99 255 231
Median daily rate £475 £525 £500
Median daily rate % change year-on-year -9.52% +5.00% +5.26%
10th Percentile £349 £390 £375
90th Percentile £675 £616 £600
London median daily rate £500 £485 £500
% change year-on-year +3.09% -3.00% +5.26%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
London median hourly rate £35.00 £21.50 £26.60
% change year-on-year +62.79% -19.16% -11.35%

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 923 2,165 2,303
As % of all contract IT jobs advertised in Central London 24.39% 25.73% 25.26%
Number of daily rates quoted 660 1,694 1,860
Median daily rate £500 £525 £513
Median daily rate % change year-on-year -4.76% +2.44% +4.59%
10th Percentile £363 £388 £363
90th Percentile £675 £675 £650
London median daily rate £525 £525 £513
% change year-on-year - +2.44% +4.06%
Number of hourly rates quoted 13 13 13
Median hourly rate £35.00 £35.00 £30.00
Median hourly rate % change year-on-year - +16.67% +34.32%
10th Percentile £24.50 £20.00 £21.00
90th Percentile £38.40 £56.50 £37.60
Median hourly rate £35.00 £35.00 £30.00
% change year-on-year - +16.67% -3.23%

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 28 May 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 28 May 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 +13 116 £500 -1.96% 14
City of Westminster +25 3 £600 -
Southwark +11 2 £400 -27.27%
West End of London +17 1 £550 +10.00%
Data Warehouse
London

For the 6 months to 28 May 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 92 (64.34%) SQL
2 78 (54.55%) Business Intelligence
3 62 (43.36%) ETL
4 61 (42.66%) Finance
5 56 (39.16%) Agile Software Development
6 48 (33.57%) SQL Server Integration Services
7 41 (28.67%) SQL Server
8 38 (26.57%) Microsoft
8 38 (26.57%) Azure
9 35 (24.48%) SQL Server Reporting Services
9 35 (24.48%) Python
9 35 (24.48%) Analytics
10 33 (23.08%) Data Modelling
11 31 (21.68%) Kimball Methodology
12 29 (20.28%) Power BI
12 29 (20.28%) Power Platform
13 28 (19.58%) SQL Server Analysis Services
14 25 (17.48%) T-SQL
15 23 (16.08%) C#
15 23 (16.08%) Microsoft Excel
15 23 (16.08%) DevOps
16 22 (15.38%) .NET
17 20 (13.99%) Oracle
17 20 (13.99%) Banking
18 19 (13.29%) SDLC
19 17 (11.89%) Analytical Skills
19 17 (11.89%) AWS
19 17 (11.89%) JavaScript
19 17 (11.89%) Scrum
20 16 (11.19%) Change Management

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 (4.90%) SAS
2 5 (3.50%) Apache Spark
3 3 (2.10%) WebLogic
4 2 (1.40%) Anypoint
4 2 (1.40%) Apache Airflow
4 2 (1.40%) Apache Pig
4 2 (1.40%) Elasticsearch
4 2 (1.40%) Oracle Workflow
4 2 (1.40%) SharePoint
5 1 (0.70%) Apache Pulsar
Applications
1 23 (16.08%) Microsoft Excel
2 1 (0.70%) Microsoft Office
2 1 (0.70%) Microsoft PowerPoint
2 1 (0.70%) MS Visio
Business Applications
1 3 (2.10%) SAP Oil and Gas
2 1 (0.70%) Oracle General Ledger
2 1 (0.70%) Oracle Internet Expenses
2 1 (0.70%) Oracle iProcurement
2 1 (0.70%) Oracle Procure-to-Pay
2 1 (0.70%) SAP BPC
Cloud Services
1 38 (26.57%) Azure
2 29 (20.28%) Power Platform
3 17 (11.89%) AWS
4 11 (7.69%) Azure Data Factory
5 9 (6.29%) GCP
6 4 (2.80%) SaaS
7 3 (2.10%) Serverless
8 2 (1.40%) AWS Lambda
8 2 (1.40%) Azure Functions
8 2 (1.40%) Data Lake Analytics
8 2 (1.40%) Force.com
8 2 (1.40%) PaaS
9 1 (0.70%) Amazon EC2
9 1 (0.70%) Amazon Kinesis
9 1 (0.70%) Amazon S3
9 1 (0.70%) Azure Active Directory
9 1 (0.70%) IaaS
9 1 (0.70%) Slack
Communications & Networking
1 6 (4.20%) Firewall
Database & Business Intelligence
1 48 (33.57%) SQL Server Integration Services
2 41 (28.67%) SQL Server
3 35 (24.48%) SQL Server Reporting Services
4 29 (20.28%) Power BI
5 28 (19.58%) SQL Server Analysis Services
6 16 (11.19%) Azure SQL Data Warehouse
7 12 (8.39%) OLAP
8 11 (7.69%) Azure SQL Database
8 11 (7.69%) Big Data
8 11 (7.69%) Data Lake
9 10 (6.99%) NoSQL
10 9 (6.29%) SQL Server 2016
11 8 (5.59%) Hadoop
12 7 (4.90%) Microsoft Analysis Services
13 6 (4.20%) Relational Database
14 5 (3.50%) PowerPivot
14 5 (3.50%) SSDT
15 4 (2.80%) Amazon Redshift
15 4 (2.80%) BusinessObjects
15 4 (2.80%) SAS EBI
Development Applications
1 10 (6.99%) Team Foundation Server
2 9 (6.29%) Git (software)
3 7 (4.90%) SQL Server Management Studio (SSMS)
3 7 (4.90%) Visual Studio
4 6 (4.20%) JIRA
5 5 (3.50%) Eclipse
6 2 (1.40%) GitLab
6 2 (1.40%) Jenkins
6 2 (1.40%) PowerDesigner
6 2 (1.40%) Subversion
7 1 (0.70%) Atlassian Bamboo
7 1 (0.70%) Bitbucket
7 1 (0.70%) Sourcetree
7 1 (0.70%) Visual Studio Team System
General
1 61 (42.66%) Finance
2 20 (13.99%) Banking
3 8 (5.59%) Marketing
3 8 (5.59%) Retail
4 7 (4.90%) Law
5 6 (4.20%) Investment Banking
6 5 (3.50%) Front Office
7 3 (2.10%) Legal
7 3 (2.10%) Public Sector
8 2 (1.40%) Back Office
8 2 (1.40%) Financial Institution
8 2 (1.40%) International Banking
9 1 (0.70%) Billing
9 1 (0.70%) General Ledger
Job Titles
1 55 (38.46%) Developer
2 28 (19.58%) Analyst
3 22 (15.38%) SQL Developer
4 20 (13.99%) Architect
5 13 (9.09%) Business Intelligence Developer
5 13 (9.09%) Data Warehouse Analyst
5 13 (9.09%) Technical Analyst
6 12 (8.39%) Data Engineer
6 12 (8.39%) ETL Analyst
6 12 (8.39%) SQL Analyst
7 10 (6.99%) C# Developer
7 10 (6.99%) Senior Developer
8 9 (6.29%) Business Intelligence Analyst
8 9 (6.29%) Data Architect
9 8 (5.59%) Business Analyst
9 8 (5.59%) Data Warehouse Developer
9 8 (5.59%) SQL Data Analyst
10 7 (4.90%) Azure Engineer
10 7 (4.90%) SSIS Analyst
10 7 (4.90%) SSIS Developer
Libraries, Frameworks & Software Standards
1 22 (15.38%) .NET
2 13 (9.09%) ASP.NET
3 9 (6.29%) HTML
3 9 (6.29%) MDX
4 8 (5.59%) CSS
5 4 (2.80%) Kafka
5 4 (2.80%) Web Services
6 3 (2.10%) AngularJS
7 2 (1.40%) .NET Framework
7 2 (1.40%) ASP.NET MVC
7 2 (1.40%) D3.js
7 2 (1.40%) Oracle Fusion
7 2 (1.40%) SOAP
7 2 (1.40%) XML
8 1 (0.70%) Entity Framework
8 1 (0.70%) jQuery
8 1 (0.70%) Kendo UI
8 1 (0.70%) Node.js
8 1 (0.70%) Velocity
8 1 (0.70%) WinForms
Miscellaneous
1 17 (11.89%) Analytical Skills
2 8 (5.59%) Management Information System
3 4 (2.80%) Reinsurance
4 3 (2.10%) Credit Risk
4 3 (2.10%) Data Protection Act
4 3 (2.10%) Fat Client
4 3 (2.10%) Hedge funds
4 3 (2.10%) NHS
4 3 (2.10%) Thin Client
5 2 (1.40%) Enterprise Software
5 2 (1.40%) Equities
5 2 (1.40%) Fixed Income
5 2 (1.40%) Greenfield Project
6 1 (0.70%) Analytical Mindset
6 1 (0.70%) Cloud Native
6 1 (0.70%) Data Centre
6 1 (0.70%) Data Structures
6 1 (0.70%) Replication
6 1 (0.70%) Tandem
Operating Systems
1 7 (4.90%) Linux
1 7 (4.90%) Unix
2 5 (3.50%) Windows
3 2 (1.40%) Red Hat Enterprise Linux
4 1 (0.70%) Debian
4 1 (0.70%) Ubuntu
4 1 (0.70%) Windows Server
Processes & Methodologies
1 78 (54.55%) Business Intelligence
2 62 (43.36%) ETL
3 56 (39.16%) Agile Software Development
4 35 (24.48%) Analytics
5 33 (23.08%) Data Modelling
6 31 (21.68%) Kimball Methodology
7 23 (16.08%) DevOps
8 19 (13.29%) SDLC
9 17 (11.89%) Scrum
10 16 (11.19%) Change Management
10 16 (11.19%) Information Management
10 16 (11.19%) Requirements Gathering
11 15 (10.49%) Business Analysis
11 15 (10.49%) Data Development
12 13 (9.09%) Portfolio Management
13 12 (8.39%) Data Engineering
13 12 (8.39%) Visualisation
14 11 (7.69%) Data Analysis
14 11 (7.69%) Data Analytics
14 11 (7.69%) Problem-Solving
Programming Languages
1 92 (64.34%) SQL
2 35 (24.48%) Python
3 25 (17.48%) T-SQL
4 23 (16.08%) C#
5 17 (11.89%) JavaScript
6 14 (9.79%) Java
7 12 (8.39%) R
8 8 (5.59%) Perl
8 8 (5.59%) PL/SQL
8 8 (5.59%) VBA
9 7 (4.90%) Data Analysis Expressions (DAX)
9 7 (4.90%) Scala
10 6 (4.20%) Go
10 6 (4.20%) Groovy
10 6 (4.20%) PowerShell
10 6 (4.20%) Ruby
11 5 (3.50%) Shell Script
12 4 (2.80%) PHP
12 4 (2.80%) VB.NET
13 3 (2.10%) VB
Qualifications
1 4 (2.80%) Degree
1 4 (2.80%) MCITP
1 4 (2.80%) Microsoft Certification
2 2 (1.40%) SC Cleared
2 2 (1.40%) Security Cleared
3 1 (0.70%) ACCA
3 1 (0.70%) BPSS Clearance
3 1 (0.70%) CIMA
3 1 (0.70%) TOGAF Certification
Quality Assurance & Compliance
1 14 (9.79%) QA
2 9 (6.29%) Solvency II
3 6 (4.20%) Data Quality
4 4 (2.80%) IFRS
5 2 (1.40%) SLA
6 1 (0.70%) GDPR
System Software
1 2 (1.40%) Virtual Machines
2 1 (0.70%) Active Directory
2 1 (0.70%) Apache Flume
2 1 (0.70%) Docker
2 1 (0.70%) HDFS
Systems Management
1 6 (4.20%) Terraform
2 2 (1.40%) Control-M
3 1 (0.70%) HP ALM
3 1 (0.70%) Kubernetes
Vendors
1 38 (26.57%) Microsoft
2 20 (13.99%) Oracle
3 11 (7.69%) Cognos
4 9 (6.29%) Tableau
5 7 (4.90%) SAP
6 6 (4.20%) Databricks
6 6 (4.20%) Informatica
7 5 (3.50%) Sybase
8 4 (2.80%) Hyperion
9 3 (2.10%) Cloudera
9 3 (2.10%) MuleSoft
9 3 (2.10%) Salesforce.com
10 2 (1.40%) Alteryx
10 2 (1.40%) BMC
10 2 (1.40%) DocuSign
10 2 (1.40%) Google
10 2 (1.40%) IBM
11 1 (0.70%) Pega
11 1 (0.70%) Red Hat
11 1 (0.70%) Telerik