Period
to 19 June 2019

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 19 June 2019 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
19 Jun 2019
Same period 2018 Same period 2017
Rank 63 87 67
Rank change year-on-year +24 -20 -18
Contract jobs citing Data Warehouse 242 199 215
As % of all contract IT jobs advertised in the City of London 3.76% 2.88% 3.46%
As % of the Database & Business Intelligence category 14.52% 11.55% 12.94%
Number of daily rates quoted 183 168 166
City of London median daily rate £500 £480 £475
Median daily rate % change year-on-year +4.17% +1.05% -
10th Percentile £400 £363 £400
90th Percentile £613 £614 £650
Central London median daily rate £525 £500 £475
% change year-on-year +5.00% +5.26% +1.33%
Number of hourly rates quoted 0 0 0
City of London 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 1,667 1,723 1,662
As % of all contract IT jobs advertised in the City of London 25.88% 24.98% 26.78%
Number of daily rates quoted 1,310 1,417 1,315
City of London median daily rate £536 £525 £500
Median daily rate % change year-on-year +2.14% +5.00% +5.26%
10th Percentile £406 £363 £329
90th Percentile £682 £675 £650
Central London median daily rate £525 £515 £500
% change year-on-year +1.94% +3.00% +5.26%
Number of hourly rates quoted 10 10 3
City of London median hourly rate £39.78 £22.25 £21.50
Median hourly rate % change year-on-year +78.80% +3.49% +13.16%
10th Percentile £22.15 £20.63 £20.75
90th Percentile £56.93 £36.90 £22.85
Central London median hourly rate £35.00 £30.00 £21.50
% change year-on-year +16.67% +39.53% +13.16%

Data Warehouse
Job Vacancy Trend in the City of London

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

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

Contractor daily rate trend for Data Warehouse in the City of London

Data Warehouse
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing Data Warehouse in the City of London over the 6 months to 19 June 2019.

Contractor daily rate histogram for Data Warehouse in the City of London

Data Warehouse
Contractor Hourly Rate Trend in the City of London

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

Contractor 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 19 June 2019. 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 -8 45 £550 -4.35%
Data Warehouse
Central London

For the 6 months to 19 June 2019, 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 161 (66.53%) SQL
2 112 (46.28%) Finance
3 102 (42.15%) Data Modelling
4 100 (41.32%) Business Intelligence
5 94 (38.84%) SQL Server
6 92 (38.02%) Analytics
7 89 (36.78%) ETL
8 77 (31.82%) Big Data
9 66 (27.27%) Agile Software Development
10 65 (26.86%) Microsoft
11 62 (25.62%) Data Quality
12 61 (25.21%) SQL Server Integration Services
13 59 (24.38%) Microsoft Azure
14 57 (23.55%) Hadoop
14 57 (23.55%) Apache Spark
14 57 (23.55%) Data Science
15 54 (22.31%) Power Platform
15 54 (22.31%) Power BI
16 53 (21.90%) Star Schema
17 50 (20.66%) Kafka
18 49 (20.25%) Machine Learning
18 49 (20.25%) OLAP
19 48 (19.83%) Apache Hive
20 47 (19.42%) Enterprise Data Warehouse
21 43 (17.77%) SQL Optimisation
21 43 (17.77%) OLAP Cube
21 43 (17.77%) Oozie
22 42 (17.36%) T-SQL
23 39 (16.12%) SQL Server Reporting Services
24 38 (15.70%) Oracle

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 57 (23.55%) Apache Spark
2 13 (5.37%) SharePoint
3 3 (1.24%) Oracle Workflow
4 2 (0.83%) Apache Pig
4 2 (0.83%) Confluence
4 2 (0.83%) Oracle SOA Suite
4 2 (0.83%) SAS
4 2 (0.83%) SharePoint 2013
5 1 (0.41%) Anypoint
5 1 (0.41%) Apache
5 1 (0.41%) ArcGIS
5 1 (0.41%) CMS
5 1 (0.41%) Sitecore CMS
Applications
1 22 (9.09%) Microsoft Excel
2 3 (1.24%) Microsoft Office
2 3 (1.24%) Spreadsheet
3 2 (0.83%) MS Visio
4 1 (0.41%) Chatbot
4 1 (0.41%) Microsoft Project
Business Applications
1 4 (1.65%) Markit EDM
2 3 (1.24%) Dynamics AX
2 3 (1.24%) Dynamics CRM
2 3 (1.24%) Dynamics NAV
2 3 (1.24%) Oracle Procure-to-Pay
3 2 (0.83%) Oracle General Ledger
4 1 (0.41%) Eagle PACE
4 1 (0.41%) Oracle Cash Management
4 1 (0.41%) Oracle EBS
4 1 (0.41%) Oracle FAH
4 1 (0.41%) Oracle Financials
4 1 (0.41%) Oracle Internet Expenses
4 1 (0.41%) Oracle iProcurement
4 1 (0.41%) Oracle Payables
4 1 (0.41%) Oracle Receivables
4 1 (0.41%) SAP Oil and Gas
Cloud Services
1 59 (24.38%) Microsoft Azure
2 54 (22.31%) Power Platform
3 23 (9.50%) Azure Data Factory
4 21 (8.68%) Amazon AWS
5 7 (2.89%) Google Cloud Platform
6 6 (2.48%) Amazon S3
6 6 (2.48%) PaaS
7 5 (2.07%) Data Lake Analytics
7 5 (2.07%) Dynamics 365
8 4 (1.65%) Amazon EMR
8 4 (1.65%) Cloud Computing
8 4 (1.65%) IaaS
8 4 (1.65%) Office 365
8 4 (1.65%) Serverless
9 3 (1.24%) Azure Functions
10 2 (0.83%) Azure Active Directory
10 2 (0.83%) PowerApps
11 1 (0.41%) Amazon Kinesis
11 1 (0.41%) AWS Lambda
11 1 (0.41%) GitHub
Communications & Networking
1 2 (0.83%) DNS
1 2 (0.83%) SAN
2 1 (0.41%) Internet
Database & Business Intelligence
1 94 (38.84%) SQL Server
2 77 (31.82%) Big Data
3 61 (25.21%) SQL Server Integration Services
4 57 (23.55%) Hadoop
5 54 (22.31%) Power BI
6 53 (21.90%) Star Schema
7 49 (20.25%) OLAP
8 48 (19.83%) Apache Hive
9 47 (19.42%) Enterprise Data Warehouse
10 43 (17.77%) OLAP Cube
11 39 (16.12%) SQL Server Reporting Services
12 32 (13.22%) SQL Server Analysis Services
13 30 (12.40%) Data Lake
14 20 (8.26%) Azure SQL Data Warehouse
15 17 (7.02%) Azure SQL Database
16 14 (5.79%) Microsoft Analysis Services
16 14 (5.79%) Oracle Database
17 13 (5.37%) SQL Server 2012
18 12 (4.96%) SQL Server 2016
19 11 (4.55%) Oracle BI EE
Development Applications
1 15 (6.20%) Git (software)
2 9 (3.72%) Visual Studio
3 8 (3.31%) JIRA
4 7 (2.89%) Jenkins
5 6 (2.48%) Team Foundation Server
6 5 (2.07%) SpecFlow
6 5 (2.07%) Visual Studio Team System
7 3 (1.24%) Octopus Deploy
7 3 (1.24%) SQL Server Management Studio (SSMS)
7 3 (1.24%) TeamCity
7 3 (1.24%) tSQLt
8 2 (0.83%) ERwin
9 1 (0.41%) Cucumber
9 1 (0.41%) Eclipse
9 1 (0.41%) JDeveloper
9 1 (0.41%) JIRA Agile
9 1 (0.41%) NUnit
9 1 (0.41%) Oracle Forms
9 1 (0.41%) Selenium
9 1 (0.41%) Subversion
General
1 112 (46.28%) Finance
2 29 (11.98%) Banking
3 25 (10.33%) Retail
4 10 (4.13%) Investment Banking
5 4 (1.65%) Back Office
6 3 (1.24%) Advertising
6 3 (1.24%) General Ledger
6 3 (1.24%) Marketing
7 2 (0.83%) International Banking
8 1 (0.41%) Financial Institution
8 1 (0.41%) Front Office
8 1 (0.41%) Retail Banking
Job Titles
1 66 (27.27%) Developer
2 61 (25.21%) Data Engineer
3 44 (18.18%) Hadoop Engineer
4 32 (13.22%) Analyst
5 29 (11.98%) Business Intelligence Developer
6 26 (10.74%) Architect
7 19 (7.85%) Data Architect
7 19 (7.85%) SQL Developer
8 16 (6.61%) Business Analyst
9 13 (5.37%) Data Analyst
10 12 (4.96%) Consultant
11 11 (4.55%) Data Modeller
12 9 (3.72%) Data Business Analyst
13 8 (3.31%) ETL Developer
13 8 (3.31%) Power BI Developer
13 8 (3.31%) Solutions Architect
13 8 (3.31%) SQL BI Developer
14 7 (2.89%) DBA
14 7 (2.89%) Senior Developer
14 7 (2.89%) SQL DBA
Libraries, Frameworks & Software Standards
1 50 (20.66%) Kafka
2 9 (3.72%) MDX
3 7 (2.89%) .NET
4 6 (2.48%) XML
5 4 (1.65%) JSON
5 4 (1.65%) Oracle Fusion
6 3 (1.24%) LAMP
6 3 (1.24%) Middleware
6 3 (1.24%) REST
6 3 (1.24%) SAP XI
6 3 (1.24%) Velocity
6 3 (1.24%) Web Services
7 2 (0.83%) LDAP
7 2 (0.83%) Pandas
7 2 (0.83%) Regular Expression
8 1 (0.41%) Apache Avro
8 1 (0.41%) D3.js
8 1 (0.41%) Highcharts JS
8 1 (0.41%) Natural Language Processing
8 1 (0.41%) YAML
Miscellaneous
1 27 (11.16%) Analytical Skills
2 8 (3.31%) Data Structures
3 6 (2.48%) Greenfield Project
4 5 (2.07%) Management Information System
4 5 (2.07%) Tandem
4 5 (2.07%) User Experience
5 4 (1.65%) NHS
5 4 (1.65%) Virtual Team
6 3 (1.24%) Replication
6 3 (1.24%) Self-Motivation
7 2 (0.83%) Data Centre
7 2 (0.83%) Data Protection Act
7 2 (0.83%) Fixed Income
7 2 (0.83%) Reinsurance
8 1 (0.41%) Algorithms
8 1 (0.41%) Derivative
8 1 (0.41%) Hedge funds
8 1 (0.41%) OTC Derivatives
8 1 (0.41%) Reference Data
8 1 (0.41%) Robotics
Operating Systems
1 9 (3.72%) Linux
2 8 (3.31%) Unix
3 5 (2.07%) Windows
4 2 (0.83%) Red Hat Enterprise Linux
4 2 (0.83%) Solaris
5 1 (0.41%) Windows Server
Processes & Methodologies
1 102 (42.15%) Data Modelling
2 100 (41.32%) Business Intelligence
3 92 (38.02%) Analytics
4 89 (36.78%) ETL
5 66 (27.27%) Agile Software Development
6 57 (23.55%) Data Science
7 49 (20.25%) Machine Learning
8 43 (17.77%) SQL Optimisation
9 27 (11.16%) Kimball Methodology
10 23 (9.50%) Data Analysis
10 23 (9.50%) Scrum
11 20 (8.26%) Migration
12 19 (7.85%) Dimensional Modelling
12 19 (7.85%) Visualisation
13 18 (7.44%) Problem-Solving
13 18 (7.44%) Waterfall
14 17 (7.02%) Asset Management
15 16 (6.61%) Data Architecture
16 15 (6.20%) Data Analytics
17 14 (5.79%) Data Governance
Programming Languages
1 161 (66.53%) SQL
2 42 (17.36%) T-SQL
3 32 (13.22%) Python
4 15 (6.20%) C#
5 13 (5.37%) Java
6 11 (4.55%) Data Analysis Expressions (DAX)
7 9 (3.72%) Scala
8 8 (3.31%) PowerShell
9 6 (2.48%) PL/SQL
10 5 (2.07%) Shell Script
10 5 (2.07%) U-SQL
10 5 (2.07%) VBA
11 3 (1.24%) JavaScript
11 3 (1.24%) R
12 2 (0.83%) Bash Shell
12 2 (0.83%) Perl
13 1 (0.41%) C
13 1 (0.41%) Go
13 1 (0.41%) IronPython
13 1 (0.41%) Ruby
Qualifications
1 2 (0.83%) Degree
1 2 (0.83%) ITIL Certification
1 2 (0.83%) SC Cleared
1 2 (0.83%) Security Cleared
2 1 (0.41%) AWS Certification
2 1 (0.41%) ISEB
2 1 (0.41%) ITIL Foundation Certificate
2 1 (0.41%) Microsoft Certification
2 1 (0.41%) PMI Certification
2 1 (0.41%) PMP
2 1 (0.41%) Postgraduate
Quality Assurance & Compliance
1 62 (25.62%) Data Quality
2 5 (2.07%) QA
3 1 (0.41%) GDPR
3 1 (0.41%) Solvency II
System Software
1 6 (2.48%) Oracle RAC
2 4 (1.65%) HDFS
3 3 (1.24%) Apache Flume
4 2 (0.83%) Cronacle
4 2 (0.83%) Veritas File System
4 2 (0.83%) Veritas Volume Manager
Systems Management
1 43 (17.77%) Oozie
2 3 (1.24%) Hadoop YARN
3 2 (0.83%) Ansible
4 1 (0.41%) HP ALM
Vendors
1 65 (26.86%) Microsoft
2 38 (15.70%) Oracle
3 18 (7.44%) Tableau
4 7 (2.89%) Informatica
5 6 (2.48%) Ab Initio
5 6 (2.48%) SAP
6 5 (2.07%) Cognos
6 5 (2.07%) Google
6 5 (2.07%) IBM
7 4 (1.65%) Hyperion
7 4 (1.65%) Talend
8 3 (1.24%) Cloudera
8 3 (1.24%) Teradata
9 2 (0.83%) Alteryx
9 2 (0.83%) Cisco
9 2 (0.83%) Red Hat
9 2 (0.83%) Sun
9 2 (0.83%) Sybase
9 2 (0.83%) Veritas
9 2 (0.83%) VMware