Period
to 20 August 2018

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 20 August 2018 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
20 Aug 2018
Same period 2017 Same period 2016
Rank 85 82 60
Rank change year-on-year -3 -22 -28
Contract jobs citing Data Warehouse 208 203 261
As % of all contract IT jobs advertised in the City of London 2.97% 3.07% 3.86%
As % of the Database & Business Intelligence category 11.42% 11.74% 15.72%
Number of daily rates quoted 169 172 206
City of London median daily rate £475 £493 £450
Median daily rate % change year-on-year -3.55% +9.44% -
10th Percentile £363 £389 £334
90th Percentile £619 £649 £656
Central London median daily rate £488 £475 £450
% change year-on-year +2.63% +5.56% -
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,821 1,729 1,660
As % of all contract IT jobs advertised in the City of London 25.96% 26.16% 24.56%
Number of daily rates quoted 1,442 1,345 1,308
City of London median daily rate £525 £513 £475
Median daily rate % change year-on-year +2.44% +7.89% +5.56%
10th Percentile £366 £355 £319
90th Percentile £675 £675 £638
Central London median daily rate £525 £500 £473
% change year-on-year +5.00% +5.82% +5.00%
Number of hourly rates quoted 12 6 8
City of London median hourly rate £21.75 £22.99 £19.00
Median hourly rate % change year-on-year -5.40% +21.01% -45.71%
10th Percentile £19.50 £20.75 £15.83
90th Percentile £32.70 £31.44 £26.72
Central London median hourly rate £22.00 £24.49 £19.00
% change year-on-year -10.15% +28.87% -30.44%

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 20 August 2018.

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 20 August 2018. 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
Moorgate -5 3 - -
London Bridge - 3 £575 -
Data Warehouse
Central London

For the 6 months to 20 August 2018, 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 136 (65.38%) SQL
2 115 (55.29%) Business Intelligence
3 105 (50.48%) ETL
4 98 (47.12%) SQL Server Integration Services
5 91 (43.75%) SQL Server
6 88 (42.31%) Finance
7 78 (37.50%) SQL Server Reporting Services
8 70 (33.65%) Agile Software Development
9 67 (32.21%) T-SQL
10 52 (25.00%) Power BI
11 50 (24.04%) Microsoft
12 46 (22.12%) SQL Server Analysis Services
13 43 (20.67%) Analytics
14 34 (16.35%) C#
14 34 (16.35%) Data Modelling
15 32 (15.38%) Microsoft Azure
15 32 (15.38%) Tableau
16 29 (13.94%) Visualisation
17 26 (12.50%) Oracle
17 26 (12.50%) Big Data
18 24 (11.54%) Scrum
19 23 (11.06%) Migration
19 23 (11.06%) .NET
20 21 (10.10%) ETL Development
20 21 (10.10%) Problem-Solving
21 20 (9.62%) SQL Server 2008
21 20 (9.62%) Python
22 19 (9.13%) Kimball Methodology
22 19 (9.13%) Relational Database
23 18 (8.65%) Performance Tuning

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 13 (6.25%) Apache Spark
2 4 (1.92%) SharePoint
3 3 (1.44%) IIS
3 3 (1.44%) SAS
4 2 (0.96%) Apache Airflow
4 2 (0.96%) Apache Solr
5 1 (0.48%) Alfresco
5 1 (0.48%) Apache
5 1 (0.48%) Apache Pig
5 1 (0.48%) Confluence
5 1 (0.48%) Oracle Workflow
5 1 (0.48%) WebSphere
Applications
1 18 (8.65%) Microsoft Excel
2 2 (0.96%) Microsoft PowerPoint
2 2 (0.96%) MS Visio
3 1 (0.48%) Microsoft Office
3 1 (0.48%) Stata
Business Applications
1 2 (0.96%) Dynamics AX
1 2 (0.96%) FastStats
2 1 (0.48%) SAP HCM
2 1 (0.48%) SAP HR
Cloud Services
1 32 (15.38%) Microsoft Azure
2 17 (8.17%) Amazon AWS
3 10 (4.81%) PaaS
4 5 (2.40%) Google Cloud Platform
5 4 (1.92%) Amazon S3
5 4 (1.92%) Azure Data Factory
5 4 (1.92%) GitHub
6 3 (1.44%) IaaS
7 2 (0.96%) Amazon EMR
7 2 (0.96%) Data Lake Analytics
8 1 (0.48%) Amazon Kinesis
8 1 (0.48%) Azure Functions
8 1 (0.48%) Azure Machine Learning
8 1 (0.48%) Dynamics 365
8 1 (0.48%) Google Analytics
8 1 (0.48%) SaaS
8 1 (0.48%) Serverless
8 1 (0.48%) Slack
8 1 (0.48%) SuccessFactors
8 1 (0.48%) Trello
Communications & Networking
1 4 (1.92%) SMS
2 1 (0.48%) Firewall
2 1 (0.48%) LAN
2 1 (0.48%) NAS
2 1 (0.48%) PABX
2 1 (0.48%) SAN
2 1 (0.48%) TCP/IP
2 1 (0.48%) VoIP
2 1 (0.48%) VPN
2 1 (0.48%) WAN
Database & Business Intelligence
1 98 (47.12%) SQL Server Integration Services
2 91 (43.75%) SQL Server
3 78 (37.50%) SQL Server Reporting Services
4 52 (25.00%) Power BI
5 46 (22.12%) SQL Server Analysis Services
6 26 (12.50%) Big Data
7 20 (9.62%) SQL Server 2008
8 19 (9.13%) Relational Database
9 14 (6.73%) Data Lake
9 14 (6.73%) Enterprise Data Warehouse
9 14 (6.73%) Hadoop
9 14 (6.73%) Microsoft Analysis Services
10 13 (6.25%) SQL Server 2012
11 11 (5.29%) Azure SQL Data Warehouse
11 11 (5.29%) SQL Server 2016
12 10 (4.81%) OLAP
13 9 (4.33%) Amazon Redshift
13 9 (4.33%) Star Schema
14 8 (3.85%) Oracle Database
14 8 (3.85%) SQL Server 2014
Development Applications
1 12 (5.77%) JIRA
1 12 (5.77%) Team Foundation Server
2 6 (2.88%) SQL Server Management Studio (SSMS)
2 6 (2.88%) Visual Studio
3 5 (2.40%) Subversion
4 4 (1.92%) ERwin
4 4 (1.92%) TeamCity
5 3 (1.44%) Git (software)
5 3 (1.44%) Visual Studio Team System
6 2 (0.96%) Eclipse
6 2 (0.96%) Jenkins
6 2 (0.96%) RStudio
6 2 (0.96%) SpecFlow
7 1 (0.48%) GitLab
7 1 (0.48%) Maven
7 1 (0.48%) Mercurial
7 1 (0.48%) Moq
7 1 (0.48%) MSTest
7 1 (0.48%) PowerDesigner
7 1 (0.48%) Rhino Mocks
General
1 88 (42.31%) Finance
2 11 (5.29%) Marketing
3 10 (4.81%) Banking
4 7 (3.37%) Retail
5 4 (1.92%) Law
6 3 (1.44%) Investment Banking
7 2 (0.96%) Back Office
7 2 (0.96%) Legal
7 2 (0.96%) Pharmaceutical
7 2 (0.96%) Telecoms
8 1 (0.48%) Advertising
8 1 (0.48%) Digital Economy
8 1 (0.48%) Electronics
8 1 (0.48%) Financial Institution
8 1 (0.48%) General Ledger
8 1 (0.48%) Manufacturing
Job Titles
1 115 (55.29%) Developer
2 50 (24.04%) Business Intelligence Developer
3 44 (21.15%) SQL Developer
4 29 (13.94%) SSIS Developer
5 27 (12.98%) Analyst
6 19 (9.13%) SSRS Developer
7 18 (8.65%) SQL BI Developer
8 16 (7.69%) Data Warehouse Developer
9 14 (6.73%) Architect
9 14 (6.73%) SSAS Developer
10 13 (6.25%) Data Engineer
10 13 (6.25%) ETL Developer
10 13 (6.25%) T-SQL Developer
11 12 (5.77%) Power BI Developer
12 11 (5.29%) Senior Developer
13 10 (4.81%) Business Developer
14 9 (4.33%) Consultant
15 8 (3.85%) C# Developer
15 8 (3.85%) Data Architect
15 8 (3.85%) Test Manager
Libraries, Frameworks & Software Standards
1 23 (11.06%) .NET
2 13 (6.25%) XML
3 5 (2.40%) WPF
4 4 (1.92%) JSON
4 4 (1.92%) Kafka
4 4 (1.92%) REST
4 4 (1.92%) Swagger
4 4 (1.92%) WCF
4 4 (1.92%) Web Services
5 3 (1.44%) Angular 2
5 3 (1.44%) ASP.NET Web API
5 3 (1.44%) ASP.NET Web Forms
5 3 (1.44%) Entity Framework
5 3 (1.44%) Middleware
5 3 (1.44%) WinForms
5 3 (1.44%) XSD
6 2 (0.96%) .NET Framework
6 2 (0.96%) Apache Thrift
6 2 (0.96%) MDX
6 2 (0.96%) RESTful
Miscellaneous
1 13 (6.25%) Analytical Skills
2 10 (4.81%) Reinsurance
3 6 (2.88%) Data Structures
3 6 (2.88%) Greenfield Project
4 5 (2.40%) Private Cloud
4 5 (2.40%) Self-Motivation
5 4 (1.92%) Management Information System
5 4 (1.92%) Replication
5 4 (1.92%) User Experience
6 3 (1.44%) Computer Science
7 2 (0.96%) Algorithms
7 2 (0.96%) Derivative
7 2 (0.96%) Fintech
7 2 (0.96%) Life Science
7 2 (0.96%) Tandem
8 1 (0.48%) Animation
8 1 (0.48%) Data Centre
8 1 (0.48%) Hybrid Cloud
8 1 (0.48%) Public Cloud
8 1 (0.48%) Virtual Team
Operating Systems
1 6 (2.88%) Linux
2 4 (1.92%) Windows
3 3 (1.44%) Unix
4 1 (0.48%) HPUX
4 1 (0.48%) Solaris
4 1 (0.48%) Ubuntu
4 1 (0.48%) Windows Server
4 1 (0.48%) zOS
Processes & Methodologies
1 115 (55.29%) Business Intelligence
2 105 (50.48%) ETL
3 70 (33.65%) Agile Software Development
4 43 (20.67%) Analytics
5 34 (16.35%) Data Modelling
6 29 (13.94%) Visualisation
7 24 (11.54%) Scrum
8 23 (11.06%) Migration
9 21 (10.10%) ETL Development
9 21 (10.10%) Problem-Solving
10 19 (9.13%) Kimball Methodology
11 18 (8.65%) Performance Tuning
12 15 (7.21%) Data Integration
13 14 (6.73%) SDLC
14 13 (6.25%) Data Analysis
14 13 (6.25%) Data Visualisation
14 13 (6.25%) Test Automation
15 11 (5.29%) Data Architecture
15 11 (5.29%) Mentoring
16 10 (4.81%) Data Analytics
Programming Languages
1 136 (65.38%) SQL
2 67 (32.21%) T-SQL
3 34 (16.35%) C#
4 20 (9.62%) Python
5 14 (6.73%) Java
6 13 (6.25%) PL/SQL
7 10 (4.81%) VB.NET
8 9 (4.33%) PowerShell
9 7 (3.37%) Data Analysis Expressions (DAX)
9 7 (3.37%) VBA
10 5 (2.40%) Scala
11 4 (1.92%) JavaScript
11 4 (1.92%) R
11 4 (1.92%) VB
12 3 (1.44%) PHP
13 2 (0.96%) U-SQL
14 1 (0.48%) C
14 1 (0.48%) C++
14 1 (0.48%) Java 8
14 1 (0.48%) Perl
Qualifications
1 5 (2.40%) Degree
1 5 (2.40%) Security Cleared
2 4 (1.92%) SC Cleared
3 2 (0.96%) DV Cleared
3 2 (0.96%) PMI Certification
3 2 (0.96%) PMP
4 1 (0.48%) CISA
4 1 (0.48%) CISSP
4 1 (0.48%) Computer Science Degree
4 1 (0.48%) Microsoft Certification
4 1 (0.48%) Numerate Degree
Quality Assurance & Compliance
1 16 (7.69%) Data Quality
2 13 (6.25%) QA
3 4 (1.92%) GDPR
4 3 (1.44%) GCP
5 2 (0.96%) EMIR
5 2 (0.96%) MiFID
6 1 (0.48%) HL7
6 1 (0.48%) Solvency II
System Software
1 4 (1.92%) HDFS
2 3 (1.44%) Docker
3 1 (0.48%) Apache Flume
3 1 (0.48%) Apache ZooKeeper
3 1 (0.48%) Oracle RAC
3 1 (0.48%) Virtual Machines
3 1 (0.48%) VirtualBox
3 1 (0.48%) VMware Infrastructure
Systems Management
1 4 (1.92%) Oozie
2 1 (0.48%) Failover Clustering
2 1 (0.48%) Kibana
2 1 (0.48%) Microsoft Clustering
Vendors
1 50 (24.04%) Microsoft
2 32 (15.38%) Tableau
3 26 (12.50%) Oracle
4 13 (6.25%) Informatica
5 8 (3.85%) IBM
6 6 (2.88%) Cognos
6 6 (2.88%) Google
7 4 (1.92%) Ab Initio
7 4 (1.92%) Citrix
7 4 (1.92%) Cloudera
7 4 (1.92%) SAP
7 4 (1.92%) Teradata
8 3 (1.44%) Talend
9 2 (0.96%) CA
9 2 (0.96%) Salesforce.com
9 2 (0.96%) Sybase
10 1 (0.48%) Embarcadero
10 1 (0.48%) Perforce
10 1 (0.48%) Red Hat
10 1 (0.48%) Unisys