Period
to 24 January 2019

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 24 January 2019 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
24 Jan 2019
Same period 2018 Same period 2017
Rank 71 82 63
Rank change year-on-year +11 -19 +27
Contract jobs citing Data Warehouse 148 117 159
As % of all contract IT jobs advertised in Yorkshire 3.03% 2.60% 3.25%
As % of the Database & Business Intelligence category 13.98% 12.33% 13.29%
Number of daily rates quoted 112 107 107
Yorkshire median daily rate £400 £425 £363
Median daily rate % change year-on-year -5.88% +17.24% -2.42%
10th Percentile £276 £263 £276
90th Percentile £512 £615 £525
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 £19.18 £26.80 £41.00
% change year-on-year -28.44% -34.64% +52.27%

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,059 949 1,196
As % of all contract IT jobs advertised in Yorkshire 21.65% 21.08% 24.43%
Number of daily rates quoted 740 631 802
Yorkshire median daily rate £415 £400 £375
Median daily rate % change year-on-year +3.75% +6.67% -
10th Percentile £305 £281 £281
90th Percentile £575 £538 £538
England median daily rate £484 £475 £433
% change year-on-year +1.89% +9.83% +1.76%
Number of hourly rates quoted 25 2 13
Yorkshire median hourly rate £16.87 £32.75 £24.00
Median hourly rate % change year-on-year -48.49% +36.46% +29.73%
10th Percentile £12.68 £23.03 £13.50
90th Percentile £23.44 £42.28 £31.50
England median hourly rate £35.00 £31.15 £27.50
% change year-on-year +12.36% +13.27% -6.78%

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 24 January 2019.

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 24 January 2019. 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 +12 104 £370 -12.94% 43
North Yorkshire +18 21 £425 -5.56% 6
South Yorkshire -19 20 £450 +5.88% 3
East Yorkshire -4 1 £313 -3.85%
Data Warehouse
England

For the 6 months to 24 January 2019, 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 96 (64.86%) SQL
2 82 (55.41%) ETL
3 70 (47.30%) SQL Server
4 68 (45.95%) Business Intelligence
5 62 (41.89%) SQL Server Reporting Services
6 54 (36.49%) SQL Server Integration Services
7 44 (29.73%) Migration
8 37 (25.00%) Data Migration
9 36 (24.32%) T-SQL
9 36 (24.32%) Power BI
10 32 (21.62%) Finance
11 30 (20.27%) Analytics
12 25 (16.89%) SQL Server Analysis Services
13 24 (16.22%) Data Integration
14 22 (14.86%) Agile Software Development
14 22 (14.86%) Data Modelling
15 20 (13.51%) Microsoft
15 20 (13.51%) ETL Development
16 19 (12.84%) Oracle
17 17 (11.49%) SAP
18 16 (10.81%) Kimball Methodology
18 16 (10.81%) Analytical Skills
19 15 (10.14%) Tableau
20 13 (8.78%) BusinessObjects
20 13 (8.78%) Data Analysis
20 13 (8.78%) Stakeholder Management
20 13 (8.78%) SQL Server 2016
21 12 (8.11%) SQL Server 2014
21 12 (8.11%) Data Lake
21 12 (8.11%) Relational Database

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 7 (4.73%) SAS
2 4 (2.70%) Apache Spark
3 2 (1.35%) Confluence
Applications
1 5 (3.38%) Microsoft Excel
Business Applications
1 4 (2.70%) Dynamics AX
Cloud Services
1 12 (8.11%) Amazon AWS
2 7 (4.73%) Microsoft Azure
3 6 (4.05%) Google Analytics
4 5 (3.38%) Amazon EC2
4 5 (3.38%) Amazon S3
5 4 (2.70%) Dynamics 365
6 2 (1.35%) Amazon CloudWatch
6 2 (1.35%) Amazon EMR
6 2 (1.35%) Amazon Kinesis
6 2 (1.35%) Amazon SageMaker
6 2 (1.35%) AWS CloudTrail
6 2 (1.35%) Cloud Computing
6 2 (1.35%) Virtual Private Cloud
7 1 (0.68%) Amazon ELB
7 1 (0.68%) Amazon SQS
7 1 (0.68%) AWS CodePipeline
7 1 (0.68%) AWS Lambda
7 1 (0.68%) Route 53
7 1 (0.68%) Serverless
Communications & Networking
1 1 (0.68%) DHCP
1 1 (0.68%) DNS
1 1 (0.68%) Internet
1 1 (0.68%) SMS
Database & Business Intelligence
1 70 (47.30%) SQL Server
2 62 (41.89%) SQL Server Reporting Services
3 54 (36.49%) SQL Server Integration Services
4 36 (24.32%) Power BI
5 25 (16.89%) SQL Server Analysis Services
6 13 (8.78%) BusinessObjects
6 13 (8.78%) SQL Server 2016
7 12 (8.11%) Big Data
7 12 (8.11%) Data Lake
7 12 (8.11%) Relational Database
7 12 (8.11%) SQL Server 2014
8 11 (7.43%) Hadoop
9 10 (6.76%) SAP Data Services
10 8 (5.41%) OLAP
10 8 (5.41%) Star Schema
11 7 (4.73%) MongoDB
12 6 (4.05%) Oracle ODI
12 6 (4.05%) Oracle OLAP
12 6 (4.05%) PowerPivot
12 6 (4.05%) RDBMS
Development Applications
1 6 (4.05%) Toad
2 5 (3.38%) Git (software)
3 4 (2.70%) Jenkins
3 4 (2.70%) Visual Studio
4 3 (2.03%) JIRA
4 3 (2.03%) MSTest
4 3 (2.03%) Team Foundation Server
5 2 (1.35%) ERwin
5 2 (1.35%) Octopus Deploy
5 2 (1.35%) TeamCity
6 1 (0.68%) SoapUI
6 1 (0.68%) SonarQube
6 1 (0.68%) Sonatype Nexus
General
1 32 (21.62%) Finance
2 9 (6.08%) Retail
3 6 (4.05%) Banking
4 3 (2.03%) Marketing
5 1 (0.68%) Financial Institution
5 1 (0.68%) Law
Job Titles
1 88 (59.46%) Developer
2 40 (27.03%) SQL Developer
3 35 (23.65%) Analyst
4 20 (13.51%) Business Intelligence Developer
5 18 (12.16%) ETL Developer
6 13 (8.78%) Data Analyst
6 13 (8.78%) Data Warehouse Developer
7 11 (7.43%) SQL BI Developer
8 9 (6.08%) SQL Server Developer
9 8 (5.41%) SQL Server BI Developer
9 8 (5.41%) Test Analyst
10 7 (4.73%) Data Warehouse Analyst
10 7 (4.73%) Data Warehouse Test Analyst
10 7 (4.73%) ETL Analyst
11 6 (4.05%) Architect
11 6 (4.05%) Power BI Developer
11 6 (4.05%) Test Data Analyst
12 5 (3.38%) Data Engineer
12 5 (3.38%) Microsoft BI Developer
12 5 (3.38%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 6 (4.05%) Web Services
2 3 (2.03%) .NET
2 3 (2.03%) MDX
3 2 (1.35%) ASP.NET
3 2 (1.35%) Kafka
3 2 (1.35%) SAP XI
4 1 (0.68%) AngularJS
4 1 (0.68%) Apache NiFi
4 1 (0.68%) Lambda Expressions
4 1 (0.68%) Node.js
4 1 (0.68%) Oracle GoldenGate
4 1 (0.68%) Pandas
4 1 (0.68%) PySpark
4 1 (0.68%) React
4 1 (0.68%) RESTful
4 1 (0.68%) SOAP
Miscellaneous
1 16 (10.81%) Analytical Skills
2 8 (5.41%) Management Information System
3 7 (4.73%) Data Structures
4 6 (4.05%) Greenfield Project
4 6 (4.05%) NHS
5 3 (2.03%) Mainframe
6 2 (1.35%) Analytical Mindset
6 2 (1.35%) Self-Motivation
7 1 (0.68%) Enterprise Software
7 1 (0.68%) Linux Command Line
7 1 (0.68%) Private Cloud
7 1 (0.68%) Public Cloud
Operating Systems
1 12 (8.11%) Unix
2 4 (2.70%) Linux
2 4 (2.70%) Windows
3 1 (0.68%) Red Hat Enterprise Linux
Processes & Methodologies
1 82 (55.41%) ETL
2 68 (45.95%) Business Intelligence
3 44 (29.73%) Migration
4 37 (25.00%) Data Migration
5 30 (20.27%) Analytics
6 24 (16.22%) Data Integration
7 22 (14.86%) Agile Software Development
7 22 (14.86%) Data Modelling
8 20 (13.51%) ETL Development
9 16 (10.81%) Kimball Methodology
10 13 (8.78%) Data Analysis
10 13 (8.78%) Stakeholder Management
11 12 (8.11%) Visualisation
12 11 (7.43%) Change Data Capture
12 11 (7.43%) Data Governance
13 10 (6.76%) Problem-Solving
14 9 (6.08%) Data Management
14 9 (6.08%) Data Visualisation
14 9 (6.08%) Scenario Testing
14 9 (6.08%) Waterfall
Programming Languages
1 96 (64.86%) SQL
2 36 (24.32%) T-SQL
3 11 (7.43%) C#
4 8 (5.41%) PL/SQL
4 8 (5.41%) Python
4 8 (5.41%) VBA
5 7 (4.73%) Java
6 5 (3.38%) Scala
6 5 (3.38%) Shell Script
7 3 (2.03%) PowerShell
7 3 (2.03%) R
8 2 (1.35%) COBOL
8 2 (1.35%) JavaScript
8 2 (1.35%) Ruby
9 1 (0.68%) C++
Qualifications
1 5 (3.38%) Security Cleared
2 3 (2.03%) Degree
3 2 (1.35%) AWS Certification
4 1 (0.68%) Numerate Degree
Quality Assurance & Compliance
1 10 (6.76%) Data Quality
2 6 (4.05%) QA
3 5 (3.38%) PMO
4 1 (0.68%) GDPR
System Software
1 3 (2.03%) Docker
2 1 (0.68%) Active Directory
2 1 (0.68%) HDFS
2 1 (0.68%) Oracle RAC
Systems Management
1 4 (2.70%) Puppet
1 4 (2.70%) Terraform
2 2 (1.35%) Packer
3 1 (0.68%) Data Guard
3 1 (0.68%) Kubernetes
3 1 (0.68%) Microsoft Data Protection Manager
3 1 (0.68%) Oozie
3 1 (0.68%) Opscode Chef
3 1 (0.68%) Oracle Enterprise Manager
3 1 (0.68%) Oracle RMAN
3 1 (0.68%) Oracle Statspack
3 1 (0.68%) Rancher
3 1 (0.68%) Tivoli
Vendors
1 20 (13.51%) Microsoft
2 19 (12.84%) Oracle
3 17 (11.49%) SAP
4 15 (10.14%) Tableau
5 7 (4.73%) Hortonworks
6 6 (4.05%) Google
7 5 (3.38%) IBM
7 5 (3.38%) Salesforce.com
8 4 (2.70%) Cloudera
9 3 (2.03%) CODA
9 3 (2.03%) Informatica
10 2 (1.35%) CA
10 2 (1.35%) Cognos
10 2 (1.35%) HP
11 1 (0.68%) Ab Initio
11 1 (0.68%) CommVault
11 1 (0.68%) DataFlux
11 1 (0.68%) Netezza
11 1 (0.68%) Pegasus
11 1 (0.68%) RedGate