Period
to 28 January 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 January 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 Jan 2020
Same period 2019 Same period 2018
Rank 59 92 79
Rank change year-on-year +33 -13 -21
Contract jobs citing Data Warehouse 216 261 257
As % of all contract IT jobs advertised in Central London 3.48% 2.93% 2.96%
As % of the Database & Business Intelligence category 15.03% 12.39% 12.05%
Number of daily rates quoted 168 203 221
Central London median daily rate £511 £500 £475
Median daily rate % change year-on-year +2.25% +5.26% +5.56%
10th Percentile £390 £375 £375
90th Percentile £650 £625 £675
London median daily rate £500 £500 £475
% change year-on-year - +5.26% +5.56%
Number of hourly rates quoted 0 0 1
Central London median hourly rate - - £28.00
London median hourly rate £35.00 £21.50 £22.50
% change year-on-year +62.79% -4.44% -37.50%

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 1,437 2,107 2,133
As % of all contract IT jobs advertised in Central London 23.12% 23.64% 24.60%
Number of daily rates quoted 1,100 1,661 1,778
Central London median daily rate £500 £525 £513
Median daily rate % change year-on-year -4.76% +2.44% +7.89%
10th Percentile £363 £375 £363
90th Percentile £669 £675 £675
London median daily rate £525 £525 £500
% change year-on-year - +5.00% +5.26%
Number of hourly rates quoted 9 7 9
Central London median hourly rate £35.00 £37.09 £27.50
Median hourly rate % change year-on-year -5.63% +34.87% -38.89%
10th Percentile £23.83 £29.50 £20.75
90th Percentile £39.10 £65.61 £33.86
London median hourly rate £35.00 £32.48 £26.78
% change year-on-year +7.78% +21.29% -19.47%

Data Warehouse
Job Vacancy Trend in Central London

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

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Data Warehouse in Central London.

Contractor daily rate trend for Data Warehouse in Central London

Data Warehouse
Contractor Daily Rate Histogram in Central London

The daily rate distribution of IT jobs citing Data Warehouse in Central London over the 6 months to 28 January 2020.

Contractor daily rate histogram for Data Warehouse in Central London

Data Warehouse
Contractor Hourly Rate Trend in Central London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Data Warehouse in Central London.

Contractor 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 January 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 +17 168 £510 +2.00% 96
Southwark +24 5 £400 -27.27%
City of Westminster +9 4 £900 +53.85%
West End of London +30 2 £738 +13.46%
Data Warehouse
London

For the 6 months to 28 January 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 126 (58.33%) SQL
2 118 (54.63%) Business Intelligence
3 92 (42.59%) ETL
4 77 (35.65%) SQL Server Integration Services
5 71 (32.87%) SQL Server
6 70 (32.41%) Finance
7 67 (31.02%) Agile Software Development
8 61 (28.24%) Azure
9 53 (24.54%) Power BI
9 53 (24.54%) Power Platform
10 48 (22.22%) Python
11 46 (21.30%) Data Modelling
11 46 (21.30%) Analytics
12 45 (20.83%) Microsoft
13 42 (19.44%) SQL Server Reporting Services
14 41 (18.98%) SQL Server Analysis Services
15 33 (15.28%) T-SQL
16 32 (14.81%) Kimball Methodology
17 29 (13.43%) Scrum
17 29 (13.43%) Oracle
18 25 (11.57%) Migration
18 25 (11.57%) Dimensional Modelling
18 25 (11.57%) Analytical Skills
18 25 (11.57%) Azure SQL Data Warehouse
19 24 (11.11%) AWS
20 23 (10.65%) DevOps
21 22 (10.19%) GCP
21 22 (10.19%) Decision-Making
22 21 (9.72%) Data Lake
22 21 (9.72%) Big Data

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 13 (6.02%) Apache Spark
2 10 (4.63%) Apache Airflow
3 6 (2.78%) SharePoint
4 4 (1.85%) Anypoint
4 4 (1.85%) SAS
5 3 (1.39%) WebLogic
6 2 (0.93%) WebLogic Integration
7 1 (0.46%) Apache Pig
7 1 (0.46%) Confluence
7 1 (0.46%) Oracle Workflow
7 1 (0.46%) Pachyderm
Applications
1 5 (2.31%) Microsoft Excel
2 2 (0.93%) Chatbot
2 2 (0.93%) Spreadsheet
Business Applications
1 3 (1.39%) Dynamics CRM
2 2 (0.93%) Cognos TM1
2 2 (0.93%) Oracle Financials
2 2 (0.93%) SAP Oil and Gas
2 2 (0.93%) Unit4 Business World
3 1 (0.46%) Dynamics AX
3 1 (0.46%) Dynamics NAV
3 1 (0.46%) FastStats
3 1 (0.46%) HFM
3 1 (0.46%) Oracle Applications
3 1 (0.46%) Oracle FAH
3 1 (0.46%) SAP MDM
3 1 (0.46%) Sparx Enterprise Architect
Cloud Services
1 61 (28.24%) Azure
2 53 (24.54%) Power Platform
3 24 (11.11%) AWS
4 22 (10.19%) GCP
5 13 (6.02%) Azure Data Factory
6 7 (3.24%) Amazon S3
6 7 (3.24%) Serverless
6 7 (3.24%) Tricentis Tosca
7 6 (2.78%) Amazon EMR
7 6 (2.78%) SaaS
8 4 (1.85%) Azure Functions
8 4 (1.85%) Data Lake Analytics
8 4 (1.85%) Force.com
9 3 (1.39%) Cloud Computing
9 3 (1.39%) GitHub
9 3 (1.39%) PaaS
10 2 (0.93%) Amazon Kinesis
10 2 (0.93%) Azure Stack
11 1 (0.46%) Dynamics 365
11 1 (0.46%) Slack
Communications & Networking
1 5 (2.31%) Firewall
2 2 (0.93%) 3G
2 2 (0.93%) 4G
2 2 (0.93%) 5G
3 1 (0.46%) Internet
3 1 (0.46%) SAN
3 1 (0.46%) VoIP
Database & Business Intelligence
1 77 (35.65%) SQL Server Integration Services
2 71 (32.87%) SQL Server
3 53 (24.54%) Power BI
4 42 (19.44%) SQL Server Reporting Services
5 41 (18.98%) SQL Server Analysis Services
6 25 (11.57%) Azure SQL Data Warehouse
7 21 (9.72%) Big Data
7 21 (9.72%) Data Lake
8 20 (9.26%) Hadoop
9 16 (7.41%) Azure SQL Database
9 16 (7.41%) NoSQL
10 15 (6.94%) BigQuery
11 12 (5.56%) Snowflake Schema
12 11 (5.09%) Amazon Redshift
12 11 (5.09%) SQL Server 2016
13 10 (4.63%) MongoDB
14 9 (4.17%) Star Schema
15 7 (3.24%) BusinessObjects
15 7 (3.24%) Relational Database
15 7 (3.24%) SQL Server 2008
Development Applications
1 11 (5.09%) Jenkins
1 11 (5.09%) Selenium
2 8 (3.70%) Git (software)
3 6 (2.78%) Team Foundation Server
4 5 (2.31%) JIRA
5 4 (1.85%) Visual Studio
6 3 (1.39%) Eclipse
6 3 (1.39%) Visual Studio Team System
7 2 (0.93%) Cucumber
7 2 (0.93%) SQL Server Management Studio (SSMS)
7 2 (0.93%) WebDriver
8 1 (0.46%) Atlassian Bamboo
8 1 (0.46%) ER Studio
8 1 (0.46%) ERwin
8 1 (0.46%) JUnit
8 1 (0.46%) Maven
8 1 (0.46%) PowerDesigner
8 1 (0.46%) TeamCity
General
1 70 (32.41%) Finance
2 11 (5.09%) Front Office
3 9 (4.17%) Banking
4 7 (3.24%) Marketing
4 7 (3.24%) Retail
5 5 (2.31%) Legal
6 4 (1.85%) Law
7 3 (1.39%) Billing
7 3 (1.39%) Financial Institution
8 2 (0.93%) Manufacturing
8 2 (0.93%) Public Sector
8 2 (0.93%) Telecoms
9 1 (0.46%) Back Office
9 1 (0.46%) General Ledger
9 1 (0.46%) Investment Banking
Job Titles
1 76 (35.19%) Developer
2 39 (18.06%) Architect
3 31 (14.35%) Business Intelligence Developer
4 25 (11.57%) Analyst
4 25 (11.57%) Data Architect
4 25 (11.57%) SQL Developer
5 19 (8.80%) Data Engineer
6 14 (6.48%) Business Analyst
7 12 (5.56%) Consultant
7 12 (5.56%) SSIS Developer
8 11 (5.09%) Power BI Developer
8 11 (5.09%) SQL BI Developer
9 10 (4.63%) Data Warehouse Developer
10 9 (4.17%) Azure Engineer
10 9 (4.17%) Dashboard Developer
10 9 (4.17%) Project Manager
10 9 (4.17%) Python Engineer
11 8 (3.70%) Cloud Architect
11 8 (3.70%) SQL Server Developer
11 8 (3.70%) SSRS Developer
Libraries, Frameworks & Software Standards
1 14 (6.48%) .NET
2 8 (3.70%) MDX
3 6 (2.78%) Kafka
4 5 (2.31%) Node.js
4 5 (2.31%) XML
5 4 (1.85%) XBRL
6 3 (1.39%) ASP.NET
7 2 (0.93%) J2EE
7 2 (0.93%) JSON
7 2 (0.93%) Middleware
7 2 (0.93%) MSMQ
7 2 (0.93%) Natural Language Processing
7 2 (0.93%) PySpark
7 2 (0.93%) React Native
7 2 (0.93%) RESTful
7 2 (0.93%) Web Services
8 1 (0.46%) Apache NiFi
8 1 (0.46%) Gherkin
8 1 (0.46%) Pandas
8 1 (0.46%) XSD
Miscellaneous
1 25 (11.57%) Analytical Skills
2 12 (5.56%) Data Structures
3 9 (4.17%) Greenfield Project
4 5 (2.31%) Fixed Income
4 5 (2.31%) Reinsurance
4 5 (2.31%) Replication
5 4 (1.85%) Algorithms
5 4 (1.85%) Enterprise Software
5 4 (1.85%) Equities
5 4 (1.85%) Management Information System
5 4 (1.85%) User Experience
6 3 (1.39%) Fat Client
6 3 (1.39%) Hedge funds
6 3 (1.39%) Thin Client
6 3 (1.39%) Virtual Team
7 2 (0.93%) Cloud Native
7 2 (0.93%) Data Centre
7 2 (0.93%) Reference Data
7 2 (0.93%) Taxonomies
8 1 (0.46%) Self-Motivation
Operating Systems
1 9 (4.17%) Windows
2 5 (2.31%) Unix
3 3 (1.39%) Linux
4 2 (0.93%) Android
4 2 (0.93%) Apple iOS
5 1 (0.46%) Windows Server
Processes & Methodologies
1 118 (54.63%) Business Intelligence
2 92 (42.59%) ETL
3 67 (31.02%) Agile Software Development
4 46 (21.30%) Analytics
4 46 (21.30%) Data Modelling
5 32 (14.81%) Kimball Methodology
6 29 (13.43%) Scrum
7 25 (11.57%) Dimensional Modelling
7 25 (11.57%) Migration
8 23 (10.65%) DevOps
9 22 (10.19%) Decision-Making
10 19 (8.80%) Data Science
10 19 (8.80%) Stakeholder Management
11 16 (7.41%) Dashboard Development
11 16 (7.41%) Problem-Solving
12 15 (6.94%) Data Integration
12 15 (6.94%) Visualisation
13 14 (6.48%) Business Analysis
13 14 (6.48%) Continuous Improvement
14 13 (6.02%) Data Analysis
Programming Languages
1 126 (58.33%) SQL
2 48 (22.22%) Python
3 33 (15.28%) T-SQL
4 16 (7.41%) C#
5 14 (6.48%) Java
6 10 (4.63%) PL/SQL
6 10 (4.63%) Scala
7 9 (4.17%) JavaScript
7 9 (4.17%) PowerShell
8 8 (3.70%) Perl
9 6 (2.78%) Go
10 5 (2.31%) Data Analysis Expressions (DAX)
10 5 (2.31%) Groovy
10 5 (2.31%) Ruby
11 4 (1.85%) R
12 3 (1.39%) Shell Script
12 3 (1.39%) VB
12 3 (1.39%) VB.NET
13 2 (0.93%) C++
13 2 (0.93%) VBA
Qualifications
1 10 (4.63%) Degree
2 7 (3.24%) SC Cleared
2 7 (3.24%) Security Cleared
3 5 (2.31%) MCITP
3 5 (2.31%) Microsoft Certification
4 4 (1.85%) Computer Science Degree
Quality Assurance & Compliance
1 19 (8.80%) QA
2 13 (6.02%) Data Quality
3 6 (2.78%) IFRS
4 4 (1.85%) SLA
5 1 (0.46%) Basel III
5 1 (0.46%) GAAP
5 1 (0.46%) GDPR
5 1 (0.46%) IFRS 9
5 1 (0.46%) MiFID
5 1 (0.46%) PMO
System Software
1 9 (4.17%) Docker
2 4 (1.85%) Oracle RAC
3 2 (0.93%) HDFS
4 1 (0.46%) Apache Flume
4 1 (0.46%) Virtual Machines
Systems Management
1 13 (6.02%) Terraform
2 10 (4.63%) Kubernetes
3 9 (4.17%) Ansible
4 1 (0.46%) Automic
4 1 (0.46%) Control-M
4 1 (0.46%) HP Quality Center
4 1 (0.46%) Kubeflow
Vendors
1 45 (20.83%) Microsoft
2 29 (13.43%) Oracle
3 19 (8.80%) Tableau
4 15 (6.94%) Google
5 12 (5.56%) SAP
6 11 (5.09%) Databricks
7 9 (4.17%) Informatica
8 8 (3.70%) Talend
9 6 (2.78%) Alteryx
9 6 (2.78%) Sybase
10 5 (2.31%) Cognos
10 5 (2.31%) Hyperion
10 5 (2.31%) MuleSoft
11 4 (1.85%) Salesforce.com
11 4 (1.85%) Teradata
12 3 (1.39%) Ab Initio
12 3 (1.39%) Twitter
13 2 (0.93%) CODA
13 2 (0.93%) Netezza
14 1 (0.46%) Reuters