Period
to 21 April 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 21 April 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
21 Apr 2018
Same period 2017 Same period 2016
Rank 94 96 63
Rank change year-on-year +2 -33 -11
Contract jobs citing Data Warehouse 114 103 176
As % of all contract IT jobs advertised in Yorkshire 2.37% 2.39% 3.07%
As % of the Database & Business Intelligence category 11.08% 9.89% 13.56%
Number of daily rates quoted 89 73 151
Yorkshire median daily rate £413 £375 £380
Median daily rate % change year-on-year +10.00% -1.32% +3.05%
10th Percentile £263 £277 £288
90th Percentile £528 £525 £763
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% -
Number of hourly rates quoted 0 2 3
Yorkshire median hourly rate - £29.82 £23.00
Median hourly rate % change year-on-year - +29.63% -8.00%
England median hourly rate £26.60 £38.75 £26.46
% change year-on-year -31.37% +46.43% -33.01%

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,029 1,041 1,298
As % of all contract IT jobs advertised in Yorkshire 21.35% 24.19% 22.62%
Number of daily rates quoted 694 680 908
Yorkshire median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - +7.14%
10th Percentile £275 £275 £275
90th Percentile £538 £538 £566
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 3 6 20
Yorkshire median hourly rate £17.54 £22.20 £21.00
Median hourly rate % change year-on-year -20.97% +5.69% +13.51%
10th Percentile £17.53 £16.90 £14.81
90th Percentile £19.51 £36.37 £29.48
England median hourly rate £32.50 £29.00 £26.00
% change year-on-year +12.07% +11.54% -13.33%

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 21 April 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 21 April 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 -7 78 £400 +3.23% 19
South Yorkshire +5 25 £425 +21.43% 8
East Yorkshire -3 7 £450 +28.57%
North Yorkshire 0 2 £431 -40.52% 3
Data Warehouse
England

For the 6 months to 21 April 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 65 (57.02%) Business Intelligence
2 64 (56.14%) SQL
3 54 (47.37%) ETL
4 37 (32.46%) SQL Server
5 33 (28.95%) Agile Software Development
6 32 (28.07%) Finance
7 31 (27.19%) SQL Server Integration Services
8 22 (19.30%) SQL Server Reporting Services
8 22 (19.30%) Data Modelling
8 22 (19.30%) Microsoft
9 20 (17.54%) Informatica
9 20 (17.54%) Migration
9 20 (17.54%) Analytics
10 19 (16.67%) Oracle
11 18 (15.79%) Banking
11 18 (15.79%) Data Integration
12 17 (14.91%) SQL Server Analysis Services
12 17 (14.91%) Hadoop
12 17 (14.91%) T-SQL
12 17 (14.91%) Analytical Skills
12 17 (14.91%) Power BI
13 16 (14.04%) Big Data
13 16 (14.04%) Problem-Solving
14 15 (13.16%) Relational Database
15 14 (12.28%) Apache Spark
15 14 (12.28%) NHS
15 14 (12.28%) Apache Hive
16 13 (11.40%) Retail
17 12 (10.53%) Data Management
17 12 (10.53%) Data 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 14 (12.28%) Apache Spark
2 9 (7.89%) SAS
3 5 (4.39%) Confluence
4 4 (3.51%) Apache
4 4 (3.51%) SharePoint
4 4 (3.51%) SharePoint 2013
5 1 (0.88%) Exchange Server 2013
5 1 (0.88%) IIS
5 1 (0.88%) MS Exchange
5 1 (0.88%) Oracle Application Server
Applications
1 4 (3.51%) Spreadsheet
2 3 (2.63%) Microsoft Office
3 1 (0.88%) Microsoft Excel
3 1 (0.88%) Microsoft Project
Business Applications
1 4 (3.51%) Oracle Receivables
2 2 (1.75%) Oracle EBS
2 2 (1.75%) Oracle General Ledger
2 2 (1.75%) Oracle iProcurement
2 2 (1.75%) Oracle Payables
3 1 (0.88%) Cognos Business Intelligence
3 1 (0.88%) Cognos TM1
3 1 (0.88%) Oracle Applications
Cloud Services
1 9 (7.89%) Microsoft Azure
2 7 (6.14%) Amazon AWS
3 5 (4.39%) GitHub
4 2 (1.75%) Amazon S3
4 2 (1.75%) Slack
5 1 (0.88%) Azure Data Factory
5 1 (0.88%) Cloud Computing
5 1 (0.88%) Data Lake Analytics
5 1 (0.88%) Trello
Communications & Networking
1 4 (3.51%) DSL
1 4 (3.51%) SMS
Database & Business Intelligence
1 37 (32.46%) SQL Server
2 31 (27.19%) SQL Server Integration Services
3 22 (19.30%) SQL Server Reporting Services
4 17 (14.91%) Hadoop
4 17 (14.91%) Power BI
4 17 (14.91%) SQL Server Analysis Services
5 16 (14.04%) Big Data
6 15 (13.16%) Relational Database
7 14 (12.28%) Apache Hive
8 12 (10.53%) HBase
9 10 (8.77%) Oracle Database
10 9 (7.89%) Pentaho
11 8 (7.02%) BusinessObjects
11 8 (7.02%) SQL Server 2008
12 7 (6.14%) NoSQL
13 6 (5.26%) DataStage
13 6 (5.26%) Enterprise Data Warehouse
13 6 (5.26%) OLAP
13 6 (5.26%) SQL Server 2012
14 5 (4.39%) SQL Server 2016
Development Applications
1 6 (5.26%) JIRA
2 5 (4.39%) SQL Server Management Studio (SSMS)
3 4 (3.51%) Git (software)
3 4 (3.51%) Visual Studio
4 3 (2.63%) ERwin
4 3 (2.63%) Toad
5 2 (1.75%) Burp Suite
5 2 (1.75%) HP UFT
5 2 (1.75%) Jenkins
5 2 (1.75%) JMeter
5 2 (1.75%) LoadRunner
6 1 (0.88%) GitLab
6 1 (0.88%) VersaTest
General
1 32 (28.07%) Finance
2 18 (15.79%) Banking
3 13 (11.40%) Retail
4 2 (1.75%) Billing
4 2 (1.75%) Investment Banking
4 2 (1.75%) Manufacturing
5 1 (0.88%) Advertising
5 1 (0.88%) Pharmaceutical
5 1 (0.88%) Retail Banking
Job Titles
1 60 (52.63%) Developer
2 18 (15.79%) Analyst
3 16 (14.04%) SQL Developer
4 13 (11.40%) Business Intelligence Developer
5 12 (10.53%) Data Engineer
6 10 (8.77%) ETL Developer
7 9 (7.89%) Data Warehouse Developer
8 8 (7.02%) Architect
9 7 (6.14%) Data Analyst
10 6 (5.26%) Data Architect
10 6 (5.26%) SQL Analyst
11 5 (4.39%) .NET Developer
11 5 (4.39%) Big Data Developer
11 5 (4.39%) Business Analyst
11 5 (4.39%) Consultant
12 4 (3.51%) ETL Analyst
12 4 (3.51%) Informatica Developer
12 4 (3.51%) Informatica ETL Developer
12 4 (3.51%) OBIEE Developer
13 3 (2.63%) Microsoft BI Developer
Libraries, Frameworks & Software Standards
1 11 (9.65%) Kafka
2 9 (7.89%) Spark Streaming
3 7 (6.14%) .NET
4 5 (4.39%) ASP.NET
5 4 (3.51%) Web Services
6 2 (1.75%) ASP.NET Web Forms
6 2 (1.75%) REST
7 1 (0.88%) Ajax
7 1 (0.88%) Doctrine
7 1 (0.88%) HTML
7 1 (0.88%) MDX
7 1 (0.88%) Oracle GoldenGate
7 1 (0.88%) WCF
7 1 (0.88%) WPF
Miscellaneous
1 17 (14.91%) Analytical Skills
2 14 (12.28%) NHS
3 9 (7.89%) Management Information System
4 3 (2.63%) Enterprise Software
4 3 (2.63%) Greenfield Project
4 3 (2.63%) Mainframe
5 2 (1.75%) Clustering
6 1 (0.88%) Market Risk
6 1 (0.88%) Replication
Operating Systems
1 11 (9.65%) Unix
2 2 (1.75%) Windows
3 1 (0.88%) Linux
3 1 (0.88%) Windows Server 2008
3 1 (0.88%) Windows Server 2012
Processes & Methodologies
1 65 (57.02%) Business Intelligence
2 54 (47.37%) ETL
3 33 (28.95%) Agile Software Development
4 22 (19.30%) Data Modelling
5 20 (17.54%) Analytics
5 20 (17.54%) Migration
6 18 (15.79%) Data Integration
7 16 (14.04%) Problem-Solving
8 12 (10.53%) Data Management
8 12 (10.53%) Data Migration
9 10 (8.77%) MapReduce
10 9 (7.89%) Data Governance
10 9 (7.89%) DevOps
10 9 (7.89%) E-Commerce
10 9 (7.89%) Scrum
11 8 (7.02%) Performance Tuning
12 7 (6.14%) Data Analytics
12 7 (6.14%) ETL Development
12 7 (6.14%) Test Scripting
13 6 (5.26%) Continuous Integration
Programming Languages
1 64 (56.14%) SQL
2 17 (14.91%) T-SQL
3 12 (10.53%) Python
4 10 (8.77%) Shell Script
5 5 (4.39%) JavaScript
5 5 (4.39%) VB.NET
6 4 (3.51%) HiveQL
6 4 (3.51%) Java
6 4 (3.51%) PL/SQL
6 4 (3.51%) Scala
7 2 (1.75%) C#
7 2 (1.75%) COBOL
8 1 (0.88%) Data Analysis Expressions (DAX)
8 1 (0.88%) PHP
8 1 (0.88%) VBA
Qualifications
1 6 (5.26%) Security Cleared
2 4 (3.51%) ISEB
2 4 (3.51%) ISTQB
2 4 (3.51%) SC Cleared
3 3 (2.63%) MCSE
3 3 (2.63%) Microsoft Certification
4 1 (0.88%) Degree
4 1 (0.88%) ISTQB Foundation Certification
4 1 (0.88%) ITIL Certification
4 1 (0.88%) Oracle Certification
Quality Assurance & Compliance
1 11 (9.65%) PMO
2 4 (3.51%) QA
3 3 (2.63%) Data Quality
3 3 (2.63%) GDPR
4 2 (1.75%) WCAG
System Software
1 7 (6.14%) Apache Flume
2 6 (5.26%) Docker
3 1 (0.88%) Active Directory
3 1 (0.88%) Oracle RAC
Systems Management
1 5 (4.39%) Ansible
2 3 (2.63%) Puppet
3 2 (1.75%) HP ALM
3 2 (1.75%) HP Quality Center
3 2 (1.75%) Nessus
4 1 (0.88%) Data Guard
4 1 (0.88%) Kubernetes
4 1 (0.88%) Oracle Enterprise Manager
4 1 (0.88%) Oracle RMAN
4 1 (0.88%) Oracle Statspack
Vendors
1 22 (19.30%) Microsoft
2 20 (17.54%) Informatica
3 19 (16.67%) Oracle
4 10 (8.77%) Talend
5 9 (7.89%) Tableau
6 8 (7.02%) IBM
7 5 (4.39%) Cloudera
8 4 (3.51%) SAP
8 4 (3.51%) Splunk
9 3 (2.63%) CA
9 3 (2.63%) Cognos
9 3 (2.63%) Hortonworks
10 2 (1.75%) HP
11 1 (0.88%) Adobe
11 1 (0.88%) Logi
11 1 (0.88%) Logi Analytics
11 1 (0.88%) Netezza
11 1 (0.88%) Zend