Period
to 20 January 2018

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 20 January 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
England > Yorkshire
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 79 61 83
Rank change year-on-year -18 +22 -31
Contract jobs citing Data Warehouse 115 162 152
As % of all contract IT jobs advertised in Yorkshire 2.61% 3.28% 2.52%
As % of the Database & Business Intelligence category 12.39% 13.29% 10.45%
Number of daily rates quoted 107 108 125
Yorkshire median daily rate £425 £369 £375
Median daily rate % change year-on-year +15.25% -1.67% +7.14%
10th Percentile £263 £278 £263
90th Percentile £615 £525 £560
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% -
Number of hourly rates quoted 0 3 1
Yorkshire median hourly rate - £25.39 £23.00
Median hourly rate % change year-on-year - +10.39% -8.00%
England median hourly rate £26.80 £41.00 £32.25
% change year-on-year -34.64% +27.13% -18.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 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 928 1,219 1,454
As % of all contract IT jobs advertised in Yorkshire 21.08% 24.72% 24.10%
Number of daily rates quoted 622 818 993
Yorkshire median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - +7.14%
10th Percentile £295 £279 £275
90th Percentile £538 £538 £529
England median daily rate £470 £430 £425
% change year-on-year +9.30% +1.18% +6.25%
Number of hourly rates quoted 2 13 22
Yorkshire median hourly rate £32.75 £24.00 £18.50
Median hourly rate % change year-on-year +36.46% +29.73% +6.58%
10th Percentile £23.03 £13.50 £10.10
90th Percentile £42.28 £31.50 £36.24
England median hourly rate £31.23 £27.50 £30.00
% change year-on-year +13.56% -8.33% +4.57%

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

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 20 January 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
West Yorkshire -21 82 £425 +12.58% 29
South Yorkshire +6 30 £425 +26.87% 1
East Yorkshire -3 2 £325 - 2
North Yorkshire +3 1 £450 - 3
Data Warehouse
England

For the 6 months to 20 January 2018, IT contractor jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Yorkshire region with a requirement for Data Warehouse.

1 74 (64.35%) Business Intelligence
2 69 (60.00%) SQL
3 57 (49.57%) SQL Server
4 40 (34.78%) Data Modelling
5 37 (32.17%) ETL
5 37 (32.17%) Microsoft
5 37 (32.17%) SQL Server Integration Services
6 35 (30.43%) Finance
7 32 (27.83%) SQL Server Reporting Services
8 28 (24.35%) SQL Server Analysis Services
9 27 (23.48%) Migration
10 24 (20.87%) Analytics
11 21 (18.26%) Agile Software Development
12 20 (17.39%) Oracle
12 20 (17.39%) Data Integration
12 20 (17.39%) Power BI
13 19 (16.52%) Data Management
14 18 (15.65%) T-SQL
15 17 (14.78%) Banking
16 15 (13.04%) Data Architecture
17 14 (12.17%) Unix
18 13 (11.30%) SAS
18 13 (11.30%) Data Migration
18 13 (11.30%) Analytical Skills
19 12 (10.43%) Tableau
19 12 (10.43%) Big Data
20 11 (9.57%) Data Governance
20 11 (9.57%) SQL Server 2012
20 11 (9.57%) Performance Tuning
20 11 (9.57%) QA

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 (11.30%) SAS
2 5 (4.35%) SharePoint
3 4 (3.48%) SharePoint 2013
4 1 (0.87%) Apache Spark
4 1 (0.87%) Confluence
Applications
1 5 (4.35%) Microsoft Excel
2 4 (3.48%) Spreadsheet
3 3 (2.61%) Microsoft Office
4 1 (0.87%) Microsoft Project
Business Applications
1 5 (4.35%) Oracle Receivables
2 3 (2.61%) Oracle iProcurement
3 2 (1.74%) Oracle EBS
3 2 (1.74%) Oracle General Ledger
3 2 (1.74%) Oracle Payables
3 2 (1.74%) SAP IS-U
4 1 (0.87%) iTrent
Cloud Services
1 7 (6.09%) Microsoft Azure
2 2 (1.74%) Amazon AWS
2 2 (1.74%) Google Cloud Platform
3 1 (0.87%) Azure Data Factory
3 1 (0.87%) Data Lake Analytics
3 1 (0.87%) SaaS
Communications & Networking
1 3 (2.61%) SMS
Database & Business Intelligence
1 57 (49.57%) SQL Server
2 37 (32.17%) SQL Server Integration Services
3 32 (27.83%) SQL Server Reporting Services
4 28 (24.35%) SQL Server Analysis Services
5 20 (17.39%) Power BI
6 12 (10.43%) Big Data
7 11 (9.57%) SQL Server 2012
7 11 (9.57%) SQL Server 2014
8 10 (8.70%) BusinessObjects
8 10 (8.70%) Relational Database
9 9 (7.83%) SQL Server 2008
9 9 (7.83%) SQL Server 2016
10 8 (6.96%) Enterprise Data Warehouse
10 8 (6.96%) NoSQL
11 7 (6.09%) Data Lake
11 7 (6.09%) Microsoft Analysis Services
11 7 (6.09%) OLAP
12 6 (5.22%) Hadoop
12 6 (5.22%) MongoDB
12 6 (5.22%) Oracle BI EE
Development Applications
1 5 (4.35%) ERwin
2 4 (3.48%) SQL Server Management Studio (SSMS)
2 4 (3.48%) Visual Studio
3 1 (0.87%) JIRA
3 1 (0.87%) Octopus Deploy
3 1 (0.87%) VersaTest
General
1 35 (30.43%) Finance
2 17 (14.78%) Banking
3 5 (4.35%) Retail
4 3 (2.61%) Retail Banking
5 1 (0.87%) Advertising
5 1 (0.87%) Financial Institution
5 1 (0.87%) Pharmaceutical
Job Titles
1 56 (48.70%) Developer
2 23 (20.00%) Analyst
3 21 (18.26%) Business Intelligence Developer
4 17 (14.78%) Architect
5 13 (11.30%) Data Architect
5 13 (11.30%) SQL Developer
6 7 (6.09%) Consultant
6 7 (6.09%) Data Analyst
6 7 (6.09%) Data Warehouse Analyst
6 7 (6.09%) Microsoft BI Developer
6 7 (6.09%) Microsoft Developer
6 7 (6.09%) SSRS Developer
7 6 (5.22%) Business Analyst
7 6 (5.22%) Data Engineer
7 6 (5.22%) Data Warehouse Developer
7 6 (5.22%) Report Developer
7 6 (5.22%) Senior Data Engineer
7 6 (5.22%) SQL Analyst
8 5 (4.35%) Data Warehouse Architect
8 5 (4.35%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 7 (6.09%) .NET
2 5 (4.35%) ASP.NET
2 5 (4.35%) MDX
3 2 (1.74%) ASP.NET Web Forms
3 2 (1.74%) Middleware
3 2 (1.74%) Oracle Fusion
4 1 (0.87%) Ajax
4 1 (0.87%) HTML
4 1 (0.87%) WCF
4 1 (0.87%) WPF
Miscellaneous
1 13 (11.30%) Analytical Skills
2 11 (9.57%) Management Information System
3 5 (4.35%) Enterprise Software
3 5 (4.35%) NHS
4 2 (1.74%) Greenfield Project
4 2 (1.74%) Replication
5 1 (0.87%) AS400
5 1 (0.87%) Data Structures
5 1 (0.87%) Mainframe
Operating Systems
1 14 (12.17%) Unix
2 1 (0.87%) Linux
Processes & Methodologies
1 74 (64.35%) Business Intelligence
2 40 (34.78%) Data Modelling
3 37 (32.17%) ETL
4 27 (23.48%) Migration
5 24 (20.87%) Analytics
6 21 (18.26%) Agile Software Development
7 20 (17.39%) Data Integration
8 19 (16.52%) Data Management
9 15 (13.04%) Data Architecture
10 13 (11.30%) Data Migration
11 11 (9.57%) Data Governance
11 11 (9.57%) Performance Tuning
12 10 (8.70%) Data Strategy
13 9 (7.83%) Data Analysis
13 9 (7.83%) Data Visualisation
13 9 (7.83%) Kimball Methodology
13 9 (7.83%) Visualisation
14 7 (6.09%) Business Analysis
14 7 (6.09%) Change Management
14 7 (6.09%) Collaborative Working
Programming Languages
1 69 (60.00%) SQL
2 18 (15.65%) T-SQL
3 10 (8.70%) Shell Script
4 8 (6.96%) PL/SQL
5 5 (4.35%) VB.NET
6 3 (2.61%) R
7 2 (1.74%) C#
7 2 (1.74%) Data Analysis Expressions (DAX)
7 2 (1.74%) Python
8 1 (0.87%) JavaScript
8 1 (0.87%) VB
8 1 (0.87%) VBA
8 1 (0.87%) VBScript
Qualifications
1 6 (5.22%) ISEB
2 3 (2.61%) Degree
2 3 (2.61%) MCSE
2 3 (2.61%) Microsoft Certification
3 2 (1.74%) ISTQB
4 1 (0.87%) ISTQB Foundation Certification
4 1 (0.87%) Security Cleared
Quality Assurance & Compliance
1 11 (9.57%) QA
2 10 (8.70%) Data Quality
3 2 (1.74%) GDPR
Vendors
1 37 (32.17%) Microsoft
2 20 (17.39%) Oracle
3 12 (10.43%) Tableau
4 10 (8.70%) Informatica
5 5 (4.35%) CA
6 4 (3.48%) IBM
6 4 (3.48%) SAP
7 2 (1.74%) Datameer
7 2 (1.74%) Google
7 2 (1.74%) HP
7 2 (1.74%) Logi
7 2 (1.74%) Logi Analytics
7 2 (1.74%) Siebel
8 1 (0.87%) Adobe
8 1 (0.87%) Capita
8 1 (0.87%) Cloudera
8 1 (0.87%) Hortonworks
8 1 (0.87%) Netezza
8 1 (0.87%) RedGate