Period
to 25 August 2019

The following table provides summary statistics for contract job vacancies advertised in Yorkshire 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 25 August 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
England > Yorkshire
6 months to
25 Aug 2019
Same period 2018 Same period 2017
Rank 90 74 81
Rank change year-on-year -16 +7 -12
Contract jobs citing Data Warehouse 85 149 114
As % of all contract IT jobs advertised in Yorkshire 2.08% 3.00% 2.69%
As % of the Database & Business Intelligence category 10.53% 12.74% 11.48%
Number of daily rates quoted 54 113 93
Yorkshire median daily rate £445 £425 £425
Median daily rate % change year-on-year +4.71% - +6.25%
10th Percentile £325 £307 £325
90th Percentile £609 £525 £643
England median daily rate £475 £463 £450
% change year-on-year +2.70% +2.78% +2.86%
Number of hourly rates quoted 2 0 0
Yorkshire median hourly rate £35.00 - -
England median hourly rate £30.00 £26.50 £26.00
% change year-on-year +13.21% +1.92% +13.04%

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 Yorkshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Yorkshire
Contract vacancies with a requirement for database or business intelligence skills 807 1,170 993
As % of all contract IT jobs advertised in Yorkshire 19.75% 23.52% 23.44%
Number of daily rates quoted 535 828 656
Yorkshire median daily rate £425 £400 £400
Median daily rate % change year-on-year +6.25% - +5.26%
10th Percentile £306 £305 £300
90th Percentile £575 £550 £538
England median daily rate £475 £475 £450
% change year-on-year - +5.56% +5.88%
Number of hourly rates quoted 20 22 11
Yorkshire median hourly rate £20.86 £17.54 £17.50
Median hourly rate % change year-on-year +18.93% +0.20% +25.00%
10th Percentile £15.22 £13.36 £12.00
90th Percentile £35.00 £33.75 £35.00
England median hourly rate £35.00 £30.00 £30.00
% change year-on-year +16.67% - +5.26%

Data Warehouse
Job Vacancy Trend in Yorkshire

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in Yorkshire.

Job vacancy trend for Data Warehouse in Yorkshire

Data Warehouse
Contractor Daily Rate Trend in Yorkshire

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

Contractor daily rate trend for Data Warehouse in Yorkshire

Data Warehouse
Contractor Daily Rate Histogram in Yorkshire

The daily rate distribution of IT jobs citing Data Warehouse in Yorkshire over the 6 months to 25 August 2019.

Contractor daily rate histogram for Data Warehouse in Yorkshire

Data Warehouse
Contractor Hourly Rate Trend in Yorkshire

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

Contractor hourly rate trend for Data Warehouse in Yorkshire

Data Warehouse
Contract Job Locations in Yorkshire

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 Yorkshire region over the 6 months to 25 August 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
West Yorkshire +6 69 £435 +2.35% 25
South Yorkshire -30 12 £450 +5.88% 4
North Yorkshire +2 2 - - 5
East Yorkshire -2 1 - - 2
Data Warehouse
England

For the 6 months to 25 August 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 Yorkshire region with a requirement for Data Warehouse.

1 46 (54.12%) Business Intelligence
2 43 (50.59%) SQL
3 29 (34.12%) SQL Server
3 29 (34.12%) Data Modelling
3 29 (34.12%) Agile Software Development
4 28 (32.94%) ETL
5 27 (31.76%) Visualisation
6 25 (29.41%) Power BI
6 25 (29.41%) Power Platform
7 23 (27.06%) Data Visualisation
7 23 (27.06%) SQL Server Integration Services
8 21 (24.71%) Big Data
9 19 (22.35%) Tableau
10 18 (21.18%) Microsoft
10 18 (21.18%) Hadoop
11 17 (20.00%) T-SQL
12 16 (18.82%) Python
12 16 (18.82%) Finance
13 15 (17.65%) Git (software)
13 15 (17.65%) Data Science
14 14 (16.47%) Analytics
14 14 (16.47%) SQL Server Analysis Services
14 14 (16.47%) SQL Server Reporting Services
15 13 (15.29%) Data Integration
15 13 (15.29%) Apache Spark
16 12 (14.12%) Azure
16 12 (14.12%) Jenkins
16 12 (14.12%) Kafka
16 12 (14.12%) Apache Hive
16 12 (14.12%) Migration

Data Warehouse
Co-occurring IT Skills in Yorkshire 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 (15.29%) Apache Spark
2 2 (2.35%) SharePoint
2 2 (2.35%) SharePoint 2013
3 1 (1.18%) SAS
Applications
1 3 (3.53%) MS Visio
2 2 (2.35%) Microsoft Excel
2 2 (2.35%) Spreadsheet
3 1 (1.18%) Microsoft Office
Business Applications
1 2 (2.35%) Cognos Business Intelligence
1 2 (2.35%) Cognos TM1
Cloud Services
1 25 (29.41%) Power Platform
2 12 (14.12%) Azure
3 11 (12.94%) AWS
3 11 (12.94%) GCP
4 6 (7.06%) GitHub
5 2 (2.35%) Azure Data Factory
6 1 (1.18%) Office 365
Communications & Networking
1 1 (1.18%) Kerberos
Database & Business Intelligence
1 29 (34.12%) SQL Server
2 25 (29.41%) Power BI
3 23 (27.06%) SQL Server Integration Services
4 21 (24.71%) Big Data
5 18 (21.18%) Hadoop
6 14 (16.47%) SQL Server Analysis Services
6 14 (16.47%) SQL Server Reporting Services
7 12 (14.12%) Apache Hive
8 8 (9.41%) HBase
8 8 (9.41%) NoSQL
9 6 (7.06%) Relational Database
10 5 (5.88%) RDBMS
10 5 (5.88%) Snowflake Schema
11 4 (4.71%) Impala
11 4 (4.71%) Oracle Database
11 4 (4.71%) Oracle Database 12c
11 4 (4.71%) QlikView
12 3 (3.53%) BusinessObjects
12 3 (3.53%) Enterprise Data Warehouse
13 2 (2.35%) PowerCenter
Development Applications
1 15 (17.65%) Git (software)
2 12 (14.12%) Jenkins
3 3 (3.53%) ER Studio
3 3 (3.53%) ERwin
3 3 (3.53%) PowerDesigner
3 3 (3.53%) Team Foundation Server
3 3 (3.53%) Visual Studio
4 2 (2.35%) SQL Server Management Studio (SSMS)
5 1 (1.18%) JIRA
5 1 (1.18%) Oracle APEX
5 1 (1.18%) Visual Studio Team System
General
1 16 (18.82%) Finance
2 10 (11.76%) Public Sector
3 4 (4.71%) Social Science
4 2 (2.35%) Banking
4 2 (2.35%) Retail
4 2 (2.35%) Retail Banking
5 1 (1.18%) Italian Language
5 1 (1.18%) Pharmaceutical
Job Titles
1 35 (41.18%) Developer
2 19 (22.35%) Business Intelligence Developer
3 11 (12.94%) Architect
4 10 (11.76%) SQL Developer
5 9 (10.59%) Big Data Engineer
6 8 (9.41%) Data Architect
7 6 (7.06%) SQL BI Developer
8 5 (5.88%) Data Manager
8 5 (5.88%) Data Scientist
8 5 (5.88%) DevOps Engineer
8 5 (5.88%) SSIS Developer
9 4 (4.71%) Analyst
9 4 (4.71%) Data Analyst
9 4 (4.71%) Data Engineer
9 4 (4.71%) Data Modeller
9 4 (4.71%) Data Warehouse Developer
9 4 (4.71%) Delivery Manager
9 4 (4.71%) T-SQL Developer
10 3 (3.53%) Administrator
10 3 (3.53%) DBA
Libraries, Frameworks & Software Standards
1 12 (14.12%) Kafka
2 5 (5.88%) D3.js
3 4 (4.71%) ggplot
4 2 (2.35%) REST
5 1 (1.18%) .NET
5 1 (1.18%) HTML
5 1 (1.18%) HTML5
5 1 (1.18%) JSON
Miscellaneous
1 7 (8.24%) Analytical Skills
2 2 (2.35%) Client/Server
2 2 (2.35%) Data Structures
2 2 (2.35%) Greenfield Project
3 1 (1.18%) Data Protection Act
3 1 (1.18%) Management Information System
3 1 (1.18%) NHS
3 1 (1.18%) Robotics
3 1 (1.18%) Self-Motivation
3 1 (1.18%) Taxonomies
Operating Systems
1 12 (14.12%) Linux
2 3 (3.53%) CentOS
Processes & Methodologies
1 46 (54.12%) Business Intelligence
2 29 (34.12%) Agile Software Development
2 29 (34.12%) Data Modelling
3 28 (32.94%) ETL
4 27 (31.76%) Visualisation
5 23 (27.06%) Data Visualisation
6 15 (17.65%) Data Science
7 14 (16.47%) Analytics
8 13 (15.29%) Data Integration
9 12 (14.12%) Data Management
9 12 (14.12%) Migration
10 10 (11.76%) DevOps
11 9 (10.59%) Continuous Integration
11 9 (10.59%) Software Engineering
12 8 (9.41%) Data Architecture
12 8 (9.41%) Data Migration
12 8 (9.41%) Data Protection
12 8 (9.41%) TDD
13 7 (8.24%) Metadata Management
13 7 (8.24%) Performance Tuning
Programming Languages
1 43 (50.59%) SQL
2 17 (20.00%) T-SQL
3 16 (18.82%) Python
4 11 (12.94%) Ruby
5 10 (11.76%) Scala
6 6 (7.06%) Go
7 5 (5.88%) PL/SQL
8 4 (4.71%) C
8 4 (4.71%) C++
8 4 (4.71%) Java
8 4 (4.71%) Perl
8 4 (4.71%) PowerShell
9 3 (3.53%) R
10 2 (2.35%) Bash Shell
10 2 (2.35%) Data Analysis Expressions (DAX)
11 1 (1.18%) C#
11 1 (1.18%) HiveQL
11 1 (1.18%) JavaScript
11 1 (1.18%) Shell Script
11 1 (1.18%) VBA
Qualifications
1 4 (4.71%) Degree
1 4 (4.71%) Master's Degree
2 2 (2.35%) MCSE
2 2 (2.35%) Microsoft Certification
3 1 (1.18%) ISEB
3 1 (1.18%) ITIL Certification
Quality Assurance & Compliance
1 9 (10.59%) Data Quality
1 9 (10.59%) QA
2 1 (1.18%) GDPR
2 1 (1.18%) PMO
System Software
1 2 (2.35%) Oracle RAC
Systems Management
1 6 (7.06%) Opscode Chef
2 4 (4.71%) Oozie
3 2 (2.35%) Data Guard
3 2 (2.35%) Oracle RMAN
Vendors
1 19 (22.35%) Tableau
2 18 (21.18%) Microsoft
3 11 (12.94%) Google
4 7 (8.24%) Oracle
5 4 (4.71%) Alteryx
5 4 (4.71%) BiZZdesign
5 4 (4.71%) IBM
5 4 (4.71%) Informatica
6 3 (3.53%) Dataiku
6 3 (3.53%) SAP
7 2 (2.35%) Cognos
7 2 (2.35%) Netezza
7 2 (2.35%) Paxata
8 1 (1.18%) Ab Initio
8 1 (1.18%) Databricks
8 1 (1.18%) MapR