Period
to 19 November 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 19 November 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
19 Nov 2018
Same period 2017 Same period 2016
Rank 64 82 65
Rank change year-on-year +18 -17 +14
Contract jobs citing Data Warehouse 155 118 181
As % of all contract IT jobs advertised in Yorkshire 3.14% 2.71% 3.33%
As % of the Database & Business Intelligence category 13.84% 12.18% 13.41%
Number of daily rates quoted 115 109 122
Yorkshire median daily rate £400 £425 £375
Median daily rate % change year-on-year -5.88% +13.33% +7.14%
10th Percentile £290 £323 £286
90th Percentile £533 £615 £536
England median daily rate £450 £450 £438
% change year-on-year - +2.86% +2.94%
Number of hourly rates quoted 2 0 3
Yorkshire median hourly rate £15.41 - £25.39
10th Percentile £12.27 - £18.43
90th Percentile £18.99 - £45.08
England median hourly rate £20.25 £27.50 £42.00
% change year-on-year -26.36% -34.52% +58.67%

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 1,120 969 1,350
As % of all contract IT jobs advertised in Yorkshire 22.71% 22.28% 24.82%
Number of daily rates quoted 771 653 921
Yorkshire median daily rate £408 £400 £380
Median daily rate % change year-on-year +1.88% +5.26% +4.47%
10th Percentile £290 £305 £281
90th Percentile £550 £538 £538
England median daily rate £475 £458 £425
% change year-on-year +3.83% +7.65% +3.03%
Number of hourly rates quoted 28 8 22
Yorkshire median hourly rate £17.25 £21.75 £14.25
Median hourly rate % change year-on-year -20.69% +52.63% -18.57%
10th Percentile £13.02 £11.75 £12.30
90th Percentile £34.13 £37.85 £31.50
England median hourly rate £35.00 £31.50 £28.00
% change year-on-year +11.11% +12.50% -

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 19 November 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 19 November 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 +10 104 £381 -10.29% 23
South Yorkshire -11 31 £425 - 2
North Yorkshire +17 17 £400 - 5
East Yorkshire 0 1 £313 -3.85% 1
Data Warehouse
England

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

1 105 (67.74%) SQL
2 91 (58.71%) ETL
3 83 (53.55%) Business Intelligence
4 70 (45.16%) SQL Server
5 56 (36.13%) SQL Server Integration Services
6 54 (34.84%) SQL Server Reporting Services
7 35 (22.58%) T-SQL
8 33 (21.29%) Data Modelling
8 33 (21.29%) Migration
9 32 (20.65%) Agile Software Development
10 31 (20.00%) Finance
11 30 (19.35%) Data Migration
12 29 (18.71%) Oracle
13 26 (16.77%) Analytics
13 26 (16.77%) Power BI
14 23 (14.84%) ETL Development
15 22 (14.19%) Data Integration
16 20 (12.90%) SQL Server Analysis Services
17 19 (12.26%) Kimball Methodology
18 17 (10.97%) PL/SQL
18 17 (10.97%) Python
18 17 (10.97%) Microsoft
19 16 (10.32%) Unix
19 16 (10.32%) Relational Database
20 15 (9.68%) C#
20 15 (9.68%) Toad
21 14 (9.03%) SAS
21 14 (9.03%) Oracle ODI
21 14 (9.03%) Hadoop
21 14 (9.03%) SQL Server 2016

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 14 (9.03%) SAS
2 5 (3.23%) Apache Spark
2 5 (3.23%) SharePoint
3 3 (1.94%) Adobe Experience Manager
3 3 (1.94%) Alfresco
3 3 (1.94%) Documentum
3 3 (1.94%) Drupal
3 3 (1.94%) FileNet
3 3 (1.94%) Liferay
3 3 (1.94%) LiveCycle
3 3 (1.94%) LiveLink
4 2 (1.29%) Confluence
5 1 (0.65%) Apache
5 1 (0.65%) Elasticsearch
5 1 (0.65%) nginx
5 1 (0.65%) Oracle Application Server
Applications
1 8 (5.16%) Microsoft Excel
2 2 (1.29%) Microsoft Office
2 2 (1.29%) Microsoft PowerPoint
3 1 (0.65%) MS Visio
Business Applications
1 3 (1.94%) Cognos Business Intelligence
2 2 (1.29%) Cognos TM1
3 1 (0.65%) Oracle Applications
Cloud Services
1 12 (7.74%) Amazon AWS
2 6 (3.87%) Microsoft Azure
3 4 (2.58%) Amazon EC2
4 3 (1.94%) Amazon S3
5 2 (1.29%) Amazon CloudWatch
5 2 (1.29%) Amazon Kinesis
5 2 (1.29%) Amazon SageMaker
5 2 (1.29%) AWS CloudTrail
5 2 (1.29%) AWS Lambda
5 2 (1.29%) Cloud Computing
5 2 (1.29%) Serverless
5 2 (1.29%) Virtual Private Cloud
6 1 (0.65%) Amazon EMR
Communications & Networking
1 1 (0.65%) DHCP
1 1 (0.65%) DNS
1 1 (0.65%) Firewall
1 1 (0.65%) Internet
1 1 (0.65%) SMS
1 1 (0.65%) VPN
Database & Business Intelligence
1 70 (45.16%) SQL Server
2 56 (36.13%) SQL Server Integration Services
3 54 (34.84%) SQL Server Reporting Services
4 26 (16.77%) Power BI
5 20 (12.90%) SQL Server Analysis Services
6 16 (10.32%) Relational Database
7 14 (9.03%) Hadoop
7 14 (9.03%) Oracle ODI
7 14 (9.03%) SQL Server 2016
8 13 (8.39%) Big Data
8 13 (8.39%) Data Lake
9 11 (7.10%) OLAP
10 10 (6.45%) Star Schema
11 8 (5.16%) MongoDB
11 8 (5.16%) Oracle OLAP
11 8 (5.16%) SQL Server 2014
12 7 (4.52%) BusinessObjects
12 7 (4.52%) DataStage
12 7 (4.52%) NoSQL
13 6 (3.87%) Data Mart
Development Applications
1 15 (9.68%) Toad
2 9 (5.81%) Git (software)
3 6 (3.87%) JIRA
3 6 (3.87%) Visual Studio
4 5 (3.23%) Jenkins
5 4 (2.58%) Octopus Deploy
5 4 (2.58%) Subversion
5 4 (2.58%) Team Foundation Server
5 4 (2.58%) TeamCity
6 3 (1.94%) Ant
6 3 (1.94%) Xcode
7 2 (1.29%) ERwin
7 2 (1.29%) MSTest
7 2 (1.29%) SpecFlow
8 1 (0.65%) DbUnit
8 1 (0.65%) jMock
8 1 (0.65%) JUnit
8 1 (0.65%) Maven
8 1 (0.65%) Mercurial
8 1 (0.65%) Mockito
General
1 31 (20.00%) Finance
2 12 (7.74%) Retail
3 8 (5.16%) Banking
4 2 (1.29%) Law
4 2 (1.29%) Marketing
5 1 (0.65%) Financial Institution
Job Titles
1 93 (60.00%) Developer
2 35 (22.58%) SQL Developer
3 28 (18.06%) ETL Developer
4 23 (14.84%) Analyst
4 23 (14.84%) Business Intelligence Developer
5 13 (8.39%) Data Analyst
6 10 (6.45%) Architect
6 10 (6.45%) Data Warehouse Developer
7 9 (5.81%) Data Engineer
7 9 (5.81%) Test Analyst
8 7 (4.52%) Data Warehouse Analyst
9 6 (3.87%) Data Architect
9 6 (3.87%) Data Warehouse Test Analyst
9 6 (3.87%) ETL Analyst
10 5 (3.23%) SSIS Developer
10 5 (3.23%) SSRS Developer
10 5 (3.23%) Test Data Analyst
10 5 (3.23%) Tester
11 4 (2.58%) Business Intelligence Analyst
11 4 (2.58%) Software Engineer
Libraries, Frameworks & Software Standards
1 7 (4.52%) Web Services
2 5 (3.23%) SOAP
3 4 (2.58%) .NET
3 4 (2.58%) Spring
4 3 (1.94%) Apache Flex
4 3 (1.94%) CSS
4 3 (1.94%) Dojo
4 3 (1.94%) Ext JS
4 3 (1.94%) Java EE
4 3 (1.94%) jQuery
4 3 (1.94%) JSON
4 3 (1.94%) JSR 170
4 3 (1.94%) OpenGL
4 3 (1.94%) Sencha Touch
4 3 (1.94%) WebGL
4 3 (1.94%) XML
5 2 (1.29%) Kafka
5 2 (1.29%) Node.js
5 2 (1.29%) React
6 1 (0.65%) Spring Boot
Miscellaneous
1 12 (7.74%) Analytical Skills
2 10 (6.45%) NHS
3 9 (5.81%) Greenfield Project
4 7 (4.52%) Management Information System
5 3 (1.94%) Data Structures
5 3 (1.94%) Mainframe
5 3 (1.94%) Self-Motivation
6 1 (0.65%) BBC
6 1 (0.65%) Clustering
6 1 (0.65%) Enterprise Software
6 1 (0.65%) Linux Command Line
6 1 (0.65%) PKI
6 1 (0.65%) Private Cloud
6 1 (0.65%) Public Cloud
6 1 (0.65%) Reference Data
Operating Systems
1 16 (10.32%) Unix
2 8 (5.16%) Windows
3 5 (3.23%) Linux
4 3 (1.94%) Android
4 3 (1.94%) Apple iOS
5 2 (1.29%) Windows Server
6 1 (0.65%) Windows Server 2003
6 1 (0.65%) zOS
Processes & Methodologies
1 91 (58.71%) ETL
2 83 (53.55%) Business Intelligence
3 33 (21.29%) Data Modelling
3 33 (21.29%) Migration
4 32 (20.65%) Agile Software Development
5 30 (19.35%) Data Migration
6 26 (16.77%) Analytics
7 23 (14.84%) ETL Development
8 22 (14.19%) Data Integration
9 19 (12.26%) Kimball Methodology
10 13 (8.39%) Project Management
11 11 (7.10%) Change Data Capture
11 11 (7.10%) Data Analysis
11 11 (7.10%) Data Management
12 10 (6.45%) Performance Tuning
13 9 (5.81%) Stakeholder Management
14 8 (5.16%) Business Analysis
14 8 (5.16%) Inmon Methodology
14 8 (5.16%) Test Scripting
14 8 (5.16%) Validation
Programming Languages
1 105 (67.74%) SQL
2 35 (22.58%) T-SQL
3 17 (10.97%) PL/SQL
3 17 (10.97%) Python
4 15 (9.68%) C#
5 12 (7.74%) Java
6 9 (5.81%) VBA
7 7 (4.52%) Shell Script
8 5 (3.23%) R
9 4 (2.58%) Scala
10 3 (1.94%) JavaScript
10 3 (1.94%) Objective-C
10 3 (1.94%) PowerShell
11 2 (1.29%) COBOL
11 2 (1.29%) Perl
11 2 (1.29%) Ruby
12 1 (0.65%) C++
12 1 (0.65%) PHP
12 1 (0.65%) VB
Qualifications
1 5 (3.23%) Degree
2 2 (1.29%) AWS Certification
3 1 (0.65%) CCNA
3 1 (0.65%) CEH
3 1 (0.65%) Cisco Certification
3 1 (0.65%) CISM
3 1 (0.65%) CISSP
3 1 (0.65%) Computer Science Degree
3 1 (0.65%) ISEB
3 1 (0.65%) ISTQB
3 1 (0.65%) ITIL Certification
3 1 (0.65%) MCSE
3 1 (0.65%) Microsoft Certification
3 1 (0.65%) Numerate Degree
3 1 (0.65%) Oracle Certification
3 1 (0.65%) PMI Certification
3 1 (0.65%) PMP
Quality Assurance & Compliance
1 10 (6.45%) QA
2 9 (5.81%) PMO
3 8 (5.16%) Data Quality
4 1 (0.65%) GDPR
System Software
1 2 (1.29%) Active Directory
1 2 (1.29%) Docker
1 2 (1.29%) Oracle RAC
2 1 (0.65%) HDFS
2 1 (0.65%) VMware Infrastructure
2 1 (0.65%) vSphere
Systems Management
1 4 (2.58%) Terraform
2 3 (1.94%) Puppet
3 2 (1.29%) Data Guard
3 2 (1.29%) Oracle Enterprise Manager
3 2 (1.29%) Oracle RMAN
3 2 (1.29%) Oracle Statspack
3 2 (1.29%) Packer
3 2 (1.29%) Tivoli
4 1 (0.65%) Ansible
4 1 (0.65%) Kubernetes
4 1 (0.65%) Microsoft Data Protection Manager
4 1 (0.65%) Oozie
4 1 (0.65%) Opscode Chef
4 1 (0.65%) Rancher
Vendors
1 29 (18.71%) Oracle
2 17 (10.97%) Microsoft
3 11 (7.10%) IBM
4 9 (5.81%) SAP
4 9 (5.81%) Tableau
5 7 (4.52%) Cognos
5 7 (4.52%) Hortonworks
6 4 (2.58%) Cloudera
6 4 (2.58%) Informatica
7 3 (1.94%) Ab Initio
7 3 (1.94%) Adobe
7 3 (1.94%) Alteryx
7 3 (1.94%) FatWire
7 3 (1.94%) Interwoven
7 3 (1.94%) OpenText
7 3 (1.94%) Sencha
7 3 (1.94%) Sitecore
7 3 (1.94%) Vignette
7 3 (1.94%) Xerox
8 2 (1.29%) VMware