Period
to 22 November 2018

The following table provides summary statistics for contract job vacancies advertised in West 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 22 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
Yorkshire > West Yorkshire
6 months to
22 Nov 2018
Same period 2017 Same period 2016
Rank 67 83 67
Rank change year-on-year +16 -16 -5
Contract jobs citing Data Warehouse 103 79 120
As % of all contract IT jobs advertised in West Yorkshire 3.01% 2.59% 3.33%
As % of the Database & Business Intelligence category 12.75% 10.79% 13.35%
Number of daily rates quoted 70 78 79
West Yorkshire median daily rate £375 £425 £385
Median daily rate % change year-on-year -11.76% +10.39% +10.00%
10th Percentile £319 £313 £285
90th Percentile £489 £615 £525
Yorkshire median daily rate £400 £425 £375
% change year-on-year -5.88% +13.33% +7.14%
Number of hourly rates quoted 2 0 2
West Yorkshire median hourly rate £15.41 - £21.88
10th Percentile £12.27 - £17.56
90th Percentile £18.99 - £24.86
Yorkshire median hourly rate £15.41 - £25.39

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

All Database and Business Intelligence Skills
West Yorkshire
Contract vacancies with a requirement for database or business intelligence skills 808 732 899
As % of all contract IT jobs advertised in West Yorkshire 23.58% 23.97% 24.96%
Number of daily rates quoted 555 514 609
West Yorkshire median daily rate £425 £400 £375
Median daily rate % change year-on-year +6.25% +6.67% -
10th Percentile £319 £305 £281
90th Percentile £575 £538 £520
Yorkshire median daily rate £410 £400 £380
% change year-on-year +2.50% +5.26% +4.11%
Number of hourly rates quoted 20 3 14
West Yorkshire median hourly rate £17.66 £22.00 £21.19
Median hourly rate % change year-on-year -19.74% +3.83% +14.53%
10th Percentile £13.17 £13.24 £13.50
90th Percentile £27.15 £24.90 £31.50
Yorkshire median hourly rate £17.66 £21.75 £14.25
% change year-on-year -18.82% +52.63% -18.57%

Data Warehouse
Job Vacancy Trend in West Yorkshire

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

Job vacancy trend for Data Warehouse in West Yorkshire

Data Warehouse
Contractor Daily Rate Trend in West Yorkshire

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

Contractor daily rate trend for Data Warehouse in West Yorkshire

Data Warehouse
Contractor Daily Rate Histogram in West Yorkshire

The daily rate distribution of IT jobs citing Data Warehouse in West Yorkshire over the 6 months to 22 November 2018.

Contractor daily rate histogram for Data Warehouse in West Yorkshire

Data Warehouse
Contractor Hourly Rate Trend in West Yorkshire

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

Contractor hourly rate trend for Data Warehouse in West Yorkshire

Data Warehouse
Contract Job Locations in West 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 West Yorkshire region over the 6 months to 22 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
Leeds +12 56 £425 - 8
Bradford +5 28 £353 -38.70% 9
Bingley - 5 £400 - 1
Wakefield -1 2 £475 +137.50%
Halifax -3 1 - - 4
Data Warehouse
Yorkshire

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

1 69 (66.99%) SQL
1 69 (66.99%) ETL
2 56 (54.37%) SQL Server
3 49 (47.57%) SQL Server Integration Services
4 47 (45.63%) Business Intelligence
4 47 (45.63%) SQL Server Reporting Services
5 29 (28.16%) T-SQL
6 26 (25.24%) Migration
7 24 (23.30%) Agile Software Development
8 23 (22.33%) Data Migration
9 22 (21.36%) ETL Development
10 21 (20.39%) Power BI
11 19 (18.45%) Data Modelling
12 18 (17.48%) SQL Server Analysis Services
12 18 (17.48%) Analytics
13 17 (16.50%) Finance
14 15 (14.56%) C#
15 13 (12.62%) SQL Server 2016
16 12 (11.65%) Relational Database
16 12 (11.65%) Hadoop
17 10 (9.71%) Kimball Methodology
17 10 (9.71%) Python
17 10 (9.71%) Microsoft
17 10 (9.71%) Data Lake
18 9 (8.74%) Unix
18 9 (8.74%) Java
18 9 (8.74%) VBA
18 9 (8.74%) Big Data
18 9 (8.74%) Amazon AWS
19 8 (7.77%) Data Integration

Data Warehouse
Co-occurring IT Skills in West 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 4 (3.88%) Apache Spark
1 4 (3.88%) SAS
2 2 (1.94%) Confluence
2 2 (1.94%) SharePoint
3 1 (0.97%) Apache
3 1 (0.97%) Elasticsearch
3 1 (0.97%) nginx
Applications
1 6 (5.83%) Microsoft Excel
2 2 (1.94%) Microsoft Office
2 2 (1.94%) Microsoft PowerPoint
3 1 (0.97%) MS Visio
Business Applications
1 2 (1.94%) Cognos Business Intelligence
2 1 (0.97%) Cognos TM1
Cloud Services
1 9 (8.74%) Amazon AWS
2 6 (5.83%) Microsoft Azure
3 4 (3.88%) Amazon EC2
4 3 (2.91%) Amazon S3
5 2 (1.94%) Amazon CloudWatch
5 2 (1.94%) Amazon Kinesis
5 2 (1.94%) Amazon SageMaker
5 2 (1.94%) AWS CloudTrail
5 2 (1.94%) AWS Lambda
5 2 (1.94%) Serverless
5 2 (1.94%) Virtual Private Cloud
6 1 (0.97%) Amazon EMR
Communications & Networking
1 1 (0.97%) DHCP
1 1 (0.97%) DNS
1 1 (0.97%) Firewall
1 1 (0.97%) SMS
1 1 (0.97%) VPN
Database & Business Intelligence
1 56 (54.37%) SQL Server
2 49 (47.57%) SQL Server Integration Services
3 47 (45.63%) SQL Server Reporting Services
4 21 (20.39%) Power BI
5 18 (17.48%) SQL Server Analysis Services
6 13 (12.62%) SQL Server 2016
7 12 (11.65%) Hadoop
7 12 (11.65%) Relational Database
8 10 (9.71%) Data Lake
9 9 (8.74%) Big Data
10 8 (7.77%) SQL Server 2014
11 6 (5.83%) DataStage
11 6 (5.83%) NoSQL
12 5 (4.85%) MongoDB
12 5 (4.85%) SQL Server 2008
13 4 (3.88%) Data Mart
14 3 (2.91%) Apache Hive
14 3 (2.91%) Azure SQL Database
14 3 (2.91%) Pentaho
14 3 (2.91%) SQL Server 2012
Development Applications
1 5 (4.85%) JIRA
2 4 (3.88%) Git (software)
2 4 (3.88%) Octopus Deploy
2 4 (3.88%) Team Foundation Server
2 4 (3.88%) TeamCity
2 4 (3.88%) Visual Studio
3 3 (2.91%) Jenkins
4 2 (1.94%) SpecFlow
5 1 (0.97%) DbUnit
5 1 (0.97%) jMock
5 1 (0.97%) JUnit
5 1 (0.97%) Maven
5 1 (0.97%) Mercurial
5 1 (0.97%) Mockito
5 1 (0.97%) SoapUI
5 1 (0.97%) SonarQube
5 1 (0.97%) Subversion
5 1 (0.97%) Toad
General
1 17 (16.50%) Finance
2 8 (7.77%) Retail
3 5 (4.85%) Banking
4 2 (1.94%) Marketing
Job Titles
1 65 (63.11%) Developer
2 31 (30.10%) SQL Developer
3 16 (15.53%) Analyst
3 16 (15.53%) ETL Developer
4 13 (12.62%) Business Intelligence Developer
5 9 (8.74%) Data Analyst
6 8 (7.77%) Data Engineer
6 8 (7.77%) Data Warehouse Developer
7 7 (6.80%) Test Analyst
8 5 (4.85%) SSIS Developer
9 4 (3.88%) Architect
9 4 (3.88%) Data Warehouse Analyst
9 4 (3.88%) Data Warehouse Test Analyst
9 4 (3.88%) ETL Analyst
9 4 (3.88%) Test Data Analyst
10 3 (2.91%) Java Developer
10 3 (2.91%) Python Developer
10 3 (2.91%) Software Engineer
10 3 (2.91%) SQL Server Developer
10 3 (2.91%) Tester
Libraries, Frameworks & Software Standards
1 5 (4.85%) Web Services
2 2 (1.94%) Kafka
2 2 (1.94%) Node.js
2 2 (1.94%) React
2 2 (1.94%) SOAP
3 1 (0.97%) Apache Camel
3 1 (0.97%) J2EE
3 1 (0.97%) Pandas
3 1 (0.97%) PowerMock
3 1 (0.97%) PySpark
3 1 (0.97%) RabbitMQ
3 1 (0.97%) RESTful
3 1 (0.97%) Spring
3 1 (0.97%) Spring Boot
Miscellaneous
1 8 (7.77%) Analytical Skills
2 7 (6.80%) NHS
3 5 (4.85%) Greenfield Project
3 5 (4.85%) Management Information System
4 3 (2.91%) Data Structures
4 3 (2.91%) Mainframe
5 1 (0.97%) BBC
5 1 (0.97%) Linux Command Line
5 1 (0.97%) PKI
5 1 (0.97%) Private Cloud
5 1 (0.97%) Public Cloud
5 1 (0.97%) Reference Data
5 1 (0.97%) Self-Motivation
Operating Systems
1 9 (8.74%) Unix
2 3 (2.91%) Linux
2 3 (2.91%) Windows
3 1 (0.97%) Windows Server
3 1 (0.97%) zOS
Processes & Methodologies
1 69 (66.99%) ETL
2 47 (45.63%) Business Intelligence
3 26 (25.24%) Migration
4 24 (23.30%) Agile Software Development
5 23 (22.33%) Data Migration
6 22 (21.36%) ETL Development
7 19 (18.45%) Data Modelling
8 18 (17.48%) Analytics
9 10 (9.71%) Kimball Methodology
10 8 (7.77%) Data Analysis
10 8 (7.77%) Data Integration
10 8 (7.77%) Data Management
10 8 (7.77%) Problem-Solving
11 7 (6.80%) Project Management
11 7 (6.80%) Stakeholder Management
12 6 (5.83%) Test Automation
12 6 (5.83%) Validation
13 5 (4.85%) Business Analysis
13 5 (4.85%) Data Mapping
13 5 (4.85%) Test Scripting
Programming Languages
1 69 (66.99%) SQL
2 29 (28.16%) T-SQL
3 15 (14.56%) C#
4 10 (9.71%) Python
5 9 (8.74%) Java
5 9 (8.74%) VBA
6 4 (3.88%) Scala
7 2 (1.94%) COBOL
7 2 (1.94%) JavaScript
7 2 (1.94%) Ruby
7 2 (1.94%) Shell Script
8 1 (0.97%) C++
8 1 (0.97%) Perl
8 1 (0.97%) PL/SQL
8 1 (0.97%) PowerShell
8 1 (0.97%) R
8 1 (0.97%) VB
Qualifications
1 5 (4.85%) Degree
2 2 (1.94%) AWS Certification
3 1 (0.97%) CCNA
3 1 (0.97%) CEH
3 1 (0.97%) Cisco Certification
3 1 (0.97%) CISM
3 1 (0.97%) CISSP
3 1 (0.97%) Computer Science Degree
3 1 (0.97%) ISEB
3 1 (0.97%) ISTQB
3 1 (0.97%) MCSE
3 1 (0.97%) Microsoft Certification
3 1 (0.97%) Numerate Degree
3 1 (0.97%) PMI Certification
3 1 (0.97%) PMP
Quality Assurance & Compliance
1 6 (5.83%) PMO
2 5 (4.85%) Data Quality
3 4 (3.88%) QA
System Software
1 2 (1.94%) Active Directory
1 2 (1.94%) Docker
2 1 (0.97%) HDFS
2 1 (0.97%) VMware Infrastructure
2 1 (0.97%) vSphere
Systems Management
1 2 (1.94%) Terraform
2 1 (0.97%) Ansible
2 1 (0.97%) Kubernetes
2 1 (0.97%) Microsoft Data Protection Manager
2 1 (0.97%) Oozie
2 1 (0.97%) Opscode Chef
2 1 (0.97%) Puppet
2 1 (0.97%) Rancher
Vendors
1 10 (9.71%) Microsoft
2 8 (7.77%) SAP
3 6 (5.83%) Hortonworks
3 6 (5.83%) IBM
3 6 (5.83%) Tableau
4 5 (4.85%) Oracle
5 3 (2.91%) Cloudera
5 3 (2.91%) Cognos
6 2 (1.94%) Alteryx
6 2 (1.94%) VMware
7 1 (0.97%) Ab Initio
7 1 (0.97%) BMC
7 1 (0.97%) CommVault
7 1 (0.97%) Netezza
7 1 (0.97%) RedGate
7 1 (0.97%) Salesforce.com
7 1 (0.97%) Splunk
7 1 (0.97%) Zoho