Period
to 25 September 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 25 September 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
25 Sep 2018
Same period 2017 Same period 2016
Rank 76 73 66
Rank change year-on-year -3 -7 -10
Contract jobs citing Data Warehouse 143 115 183
As % of all contract IT jobs advertised in Yorkshire 2.86% 2.78% 3.27%
As % of the Database & Business Intelligence category 12.15% 11.88% 13.30%
Number of daily rates quoted 112 95 129
Yorkshire median daily rate £423 £425 £400
Median daily rate % change year-on-year -0.59% +6.25% +14.29%
10th Percentile £301 £325 £310
90th Percentile £517 £615 £750
England median daily rate £450 £450 £438
% change year-on-year - +2.86% +2.94%
Number of hourly rates quoted 0 0 1
Yorkshire median hourly rate - - £50.00
England median hourly rate £35.00 £27.00 £35.00
% change year-on-year +29.63% -22.86% +6.87%

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,177 968 1,376
As % of all contract IT jobs advertised in Yorkshire 23.51% 23.36% 24.61%
Number of daily rates quoted 824 639 962
Yorkshire median daily rate £413 £400 £380
Median daily rate % change year-on-year +3.13% +5.26% +8.57%
10th Percentile £301 £306 £290
90th Percentile £550 £535 £550
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 21 10 21
Yorkshire median hourly rate £17.00 £19.50 £14.00
Median hourly rate % change year-on-year -12.82% +39.29% -20.00%
10th Percentile £13.25 £11.92 £12.25
90th Percentile £33.75 £35.95 £33.75
England median hourly rate £27.87 £30.00 £30.00
% change year-on-year -7.12% - +7.14%

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 September 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 25 September 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 -8 87 £413 -2.94% 23
South Yorkshire -4 35 £425 - 2
North Yorkshire +4 9 £406 - 6
East Yorkshire +3 4 £463 +26.71%
Data Warehouse
England

For the 6 months to 25 September 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 89 (62.24%) Business Intelligence
2 84 (58.74%) SQL
3 77 (53.85%) ETL
4 50 (34.97%) SQL Server
5 42 (29.37%) SQL Server Integration Services
6 36 (25.17%) Agile Software Development
7 34 (23.78%) Oracle
8 30 (20.98%) Data Modelling
9 29 (20.28%) SQL Server Reporting Services
10 28 (19.58%) Analytics
11 26 (18.18%) Data Integration
11 26 (18.18%) T-SQL
11 26 (18.18%) Finance
12 22 (15.38%) Relational Database
13 20 (13.99%) Retail
14 19 (13.29%) Unix
14 19 (13.29%) PL/SQL
15 18 (12.59%) Python
15 18 (12.59%) IBM
15 18 (12.59%) Microsoft
15 18 (12.59%) Kimball Methodology
16 17 (11.89%) Big Data
16 17 (11.89%) ETL Development
16 17 (11.89%) Toad
16 17 (11.89%) Migration
16 17 (11.89%) NHS
17 16 (11.19%) PMO
18 15 (10.49%) Power BI
18 15 (10.49%) Hadoop
19 14 (9.79%) Oracle ODI

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 11 (7.69%) SAS
2 6 (4.20%) SharePoint
3 3 (2.10%) Adobe Experience Manager
3 3 (2.10%) Alfresco
3 3 (2.10%) Apache Spark
3 3 (2.10%) Documentum
3 3 (2.10%) Drupal
3 3 (2.10%) FileNet
3 3 (2.10%) Liferay
3 3 (2.10%) LiveCycle
3 3 (2.10%) LiveLink
4 2 (1.40%) Confluence
4 2 (1.40%) Oracle Application Server
5 1 (0.70%) Apache
5 1 (0.70%) Elasticsearch
5 1 (0.70%) IIS
5 1 (0.70%) MS Exchange
5 1 (0.70%) nginx
5 1 (0.70%) Skype for Business
Applications
1 9 (6.29%) Microsoft Excel
2 2 (1.40%) Microsoft Office
2 2 (1.40%) Microsoft PowerPoint
2 2 (1.40%) Spreadsheet
3 1 (0.70%) MS Visio
Business Applications
1 5 (3.50%) Cognos Business Intelligence
2 4 (2.80%) Cognos TM1
3 2 (1.40%) Oracle Applications
Cloud Services
1 11 (7.69%) Amazon AWS
2 4 (2.80%) Microsoft Azure
3 3 (2.10%) Amazon S3
4 2 (1.40%) Amazon EC2
4 2 (1.40%) AWS Lambda
4 2 (1.40%) Serverless
5 1 (0.70%) Amazon CloudWatch
5 1 (0.70%) AWS CloudTrail
5 1 (0.70%) Cloud Computing
5 1 (0.70%) GitHub
5 1 (0.70%) Trello
5 1 (0.70%) Virtual Private Cloud
Communications & Networking
1 3 (2.10%) SMS
2 2 (1.40%) Firewall
3 1 (0.70%) Internet
3 1 (0.70%) VPN
3 1 (0.70%) WAN
3 1 (0.70%) Wi-Fi
Database & Business Intelligence
1 50 (34.97%) SQL Server
2 42 (29.37%) SQL Server Integration Services
3 29 (20.28%) SQL Server Reporting Services
4 22 (15.38%) Relational Database
5 17 (11.89%) Big Data
6 15 (10.49%) Hadoop
6 15 (10.49%) Power BI
7 14 (9.79%) Oracle ODI
8 13 (9.09%) SQL Server Analysis Services
9 12 (8.39%) DataStage
9 12 (8.39%) OLAP
9 12 (8.39%) SQL Server 2016
10 10 (6.99%) Star Schema
11 9 (6.29%) Data Mart
12 8 (5.59%) Oracle OLAP
13 7 (4.90%) BusinessObjects
13 7 (4.90%) NoSQL
13 7 (4.90%) Oracle Database
14 6 (4.20%) Data Lake
15 5 (3.50%) MongoDB
Development Applications
1 17 (11.89%) Toad
2 8 (5.59%) Git (software)
3 7 (4.90%) JIRA
4 6 (4.20%) Visual Studio
5 4 (2.80%) Octopus Deploy
5 4 (2.80%) Subversion
5 4 (2.80%) Team Foundation Server
5 4 (2.80%) TeamCity
6 3 (2.10%) Ant
6 3 (2.10%) ERwin
6 3 (2.10%) Jenkins
6 3 (2.10%) Xcode
7 2 (1.40%) SpecFlow
8 1 (0.70%) DbUnit
8 1 (0.70%) GitLab
8 1 (0.70%) Mercurial
8 1 (0.70%) Mockito
8 1 (0.70%) MSTest
8 1 (0.70%) SoapUI
8 1 (0.70%) SonarQube
General
1 26 (18.18%) Finance
2 20 (13.99%) Retail
3 13 (9.09%) Banking
4 2 (1.40%) Billing
4 2 (1.40%) Investment Banking
4 2 (1.40%) Law
4 2 (1.40%) Manufacturing
5 1 (0.70%) Financial Institution
5 1 (0.70%) Marketing
5 1 (0.70%) Retail Banking
Job Titles
1 90 (62.94%) Developer
2 28 (19.58%) ETL Developer
2 28 (19.58%) SQL Developer
3 23 (16.08%) Business Intelligence Developer
4 16 (11.19%) Analyst
5 10 (6.99%) Architect
6 9 (6.29%) Data Engineer
7 8 (5.59%) Data Analyst
8 7 (4.90%) Data Warehouse Developer
8 7 (4.90%) Python Developer
9 6 (4.20%) Data Architect
10 5 (3.50%) Business Analyst
10 5 (3.50%) Test Analyst
11 4 (2.80%) Business Intelligence Analyst
11 4 (2.80%) Consultant
11 4 (2.80%) Senior Developer
11 4 (2.80%) SSIS Developer
12 3 (2.10%) AWS Developer
12 3 (2.10%) ETL Analyst
12 3 (2.10%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 5 (3.50%) SOAP
2 4 (2.80%) .NET
2 4 (2.80%) Spring
3 3 (2.10%) Apache Flex
3 3 (2.10%) CSS
3 3 (2.10%) Dojo
3 3 (2.10%) Ext JS
3 3 (2.10%) Java EE
3 3 (2.10%) jQuery
3 3 (2.10%) JSON
3 3 (2.10%) JSR 170
3 3 (2.10%) OpenGL
3 3 (2.10%) Sencha Touch
3 3 (2.10%) WebGL
3 3 (2.10%) XML
4 2 (1.40%) Node.js
4 2 (1.40%) Oracle GoldenGate
4 2 (1.40%) React
4 2 (1.40%) Web Services
5 1 (0.70%) J2EE
Miscellaneous
1 17 (11.89%) NHS
2 10 (6.99%) Analytical Skills
3 8 (5.59%) Greenfield Project
3 8 (5.59%) Management Information System
4 5 (3.50%) Mainframe
5 2 (1.40%) Clustering
5 2 (1.40%) Data Structures
5 2 (1.40%) Self-Motivation
6 1 (0.70%) BBC
6 1 (0.70%) Derivative
6 1 (0.70%) Enterprise Software
6 1 (0.70%) Linux Command Line
6 1 (0.70%) PKI
6 1 (0.70%) Private Cloud
6 1 (0.70%) Public Cloud
6 1 (0.70%) Reference Data
6 1 (0.70%) Replication
6 1 (0.70%) Virtual Team
Operating Systems
1 19 (13.29%) Unix
2 7 (4.90%) Windows
3 5 (3.50%) Linux
4 3 (2.10%) Android
4 3 (2.10%) Apple iOS
4 3 (2.10%) Windows Server
5 1 (0.70%) Windows Server 2003
5 1 (0.70%) zOS
Processes & Methodologies
1 89 (62.24%) Business Intelligence
2 77 (53.85%) ETL
3 36 (25.17%) Agile Software Development
4 30 (20.98%) Data Modelling
5 28 (19.58%) Analytics
6 26 (18.18%) Data Integration
7 18 (12.59%) Kimball Methodology
8 17 (11.89%) ETL Development
8 17 (11.89%) Migration
9 14 (9.79%) Performance Tuning
10 13 (9.09%) Data Migration
10 13 (9.09%) Project Management
11 12 (8.39%) Data Management
12 11 (7.69%) Change Data Capture
12 11 (7.69%) Problem-Solving
13 10 (6.99%) Test Scripting
14 9 (6.29%) Business Analysis
14 9 (6.29%) Data Analytics
14 9 (6.29%) Scrum
14 9 (6.29%) Stakeholder Management
Programming Languages
1 84 (58.74%) SQL
2 26 (18.18%) T-SQL
3 19 (13.29%) PL/SQL
4 18 (12.59%) Python
5 13 (9.09%) C#
6 9 (6.29%) Java
7 8 (5.59%) Shell Script
7 8 (5.59%) VBA
8 5 (3.50%) R
9 4 (2.80%) COBOL
10 3 (2.10%) Objective-C
11 2 (1.40%) JavaScript
11 2 (1.40%) Perl
11 2 (1.40%) PHP
11 2 (1.40%) Scala
12 1 (0.70%) C++
12 1 (0.70%) PowerShell
12 1 (0.70%) Ruby
12 1 (0.70%) VB
Qualifications
1 2 (1.40%) Degree
1 2 (1.40%) ITIL Certification
1 2 (1.40%) Oracle Certification
2 1 (0.70%) CCNA
2 1 (0.70%) CEH
2 1 (0.70%) Cisco Certification
2 1 (0.70%) CISM
2 1 (0.70%) CISSP
2 1 (0.70%) Computer Science Degree
2 1 (0.70%) ISEB
2 1 (0.70%) ISTQB
2 1 (0.70%) MCSE
2 1 (0.70%) Microsoft Certification
2 1 (0.70%) PMI Certification
2 1 (0.70%) PMP
Quality Assurance & Compliance
1 16 (11.19%) PMO
2 9 (6.29%) QA
3 5 (3.50%) Data Quality
4 3 (2.10%) GDPR
System Software
1 5 (3.50%) Docker
2 2 (1.40%) Oracle RAC
3 1 (0.70%) Active Directory
3 1 (0.70%) VMware Infrastructure
3 1 (0.70%) vSphere
Systems Management
1 2 (1.40%) Ansible
1 2 (1.40%) Data Guard
1 2 (1.40%) HP Quality Center
1 2 (1.40%) Kubernetes
1 2 (1.40%) Oracle Enterprise Manager
1 2 (1.40%) Oracle RMAN
1 2 (1.40%) Oracle Statspack
1 2 (1.40%) Terraform
1 2 (1.40%) Tivoli
2 1 (0.70%) Opscode Chef
2 1 (0.70%) Puppet
2 1 (0.70%) Rancher
2 1 (0.70%) SCCM
Vendors
1 34 (23.78%) Oracle
2 18 (12.59%) IBM
2 18 (12.59%) Microsoft
3 11 (7.69%) Cognos
4 9 (6.29%) Hortonworks
4 9 (6.29%) Tableau
5 6 (4.20%) Informatica
6 4 (2.80%) SAP
7 3 (2.10%) Ab Initio
7 3 (2.10%) Adobe
7 3 (2.10%) Alteryx
7 3 (2.10%) Cloudera
7 3 (2.10%) FatWire
7 3 (2.10%) Interwoven
7 3 (2.10%) Netezza
7 3 (2.10%) OpenText
7 3 (2.10%) Sencha
7 3 (2.10%) Sitecore
7 3 (2.10%) Vignette
7 3 (2.10%) Xerox