Period
to 28 January 2020

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 28 January 2020 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
28 Jan 2020
Same period 2019 Same period 2018
Rank 58 68 84
Rank change year-on-year +10 +16 -11
Contract jobs citing Data Warehouse 104 145 114
As % of all contract IT jobs advertised in Yorkshire 3.32% 2.98% 2.56%
As % of the Database & Business Intelligence category 16.94% 13.84% 12.10%
Number of daily rates quoted 77 109 107
Yorkshire median daily rate £425 £400 £425
Median daily rate % change year-on-year +6.25% -5.88% +17.24%
10th Percentile £316 £274 £263
90th Percentile £675 £493 £615
England median daily rate £475 £452 £450
% change year-on-year +5.20% +0.33% +2.86%
Number of hourly rates quoted 4 2 0
Yorkshire median hourly rate £33.79 £15.41 -
Median hourly rate % change year-on-year +119.31% - -
England median hourly rate £35.00 £19.18 £27.00
% change year-on-year +82.53% -28.98% -34.15%

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 614 1,048 942
As % of all contract IT jobs advertised in Yorkshire 19.60% 21.56% 21.16%
Number of daily rates quoted 414 738 626
Yorkshire median daily rate £425 £415 £400
Median daily rate % change year-on-year +2.41% +3.75% +6.67%
10th Percentile £313 £302 £283
90th Percentile £588 £573 £538
England median daily rate £475 £485 £475
% change year-on-year -2.06% +2.11% +8.57%
Number of hourly rates quoted 17 26 2
Yorkshire median hourly rate £21.32 £16.74 £32.75
Median hourly rate % change year-on-year +27.36% -48.89% +36.46%
10th Percentile £14.15 £12.74 £23.03
90th Percentile £34.27 £23.05 £42.28
England median hourly rate £32.50 £35.00 £31.23
% change year-on-year -7.14% +12.07% +17.85%

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 28 January 2020.

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
Contractor Hourly Rate Histogram in Yorkshire

The hourly rate distribution of IT jobs citing Data Warehouse in Yorkshire over the 6 months to 28 January 2020.

Contractor hourly rate histogram 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 28 January 2020. 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 +21 89 £425 +13.33% 19
South Yorkshire +17 12 £400 -8.57% 14
North Yorkshire -12 3 £173 -59.41% 4
Data Warehouse
England

For the 6 months to 28 January 2020, 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 52 (50.00%) SQL
2 49 (47.12%) Business Intelligence
3 41 (39.42%) Data Modelling
4 34 (32.69%) SQL Server Integration Services
5 32 (30.77%) SQL Server
6 31 (29.81%) Azure
6 31 (29.81%) Power BI
6 31 (29.81%) Power Platform
7 30 (28.85%) ETL
8 23 (22.12%) Microsoft
9 22 (21.15%) SQL Server Reporting Services
10 21 (20.19%) SQL Server Analysis Services
11 20 (19.23%) Finance
12 19 (18.27%) Agile Software Development
13 16 (15.38%) T-SQL
13 16 (15.38%) Migration
14 15 (14.42%) Public Sector
15 14 (13.46%) Azure SQL Database
16 13 (12.50%) Data Migration
16 13 (12.50%) Stakeholder Management
16 13 (12.50%) Azure Data Factory
17 12 (11.54%) Analytics
18 11 (10.58%) Data Integration
18 11 (10.58%) Visualisation
18 11 (10.58%) ERP
18 11 (10.58%) Databricks
19 10 (9.62%) AWS
19 10 (9.62%) Data Visualisation
19 10 (9.62%) Data Quality
19 10 (9.62%) Analytical Skills

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 6 (5.77%) Apache Spark
2 3 (2.88%) SAS
3 1 (0.96%) Confluence
Applications
1 6 (5.77%) Microsoft Excel
2 2 (1.92%) MS Visio
Business Applications
1 1 (0.96%) Cognos Business Intelligence
1 1 (0.96%) Cognos TM1
1 1 (0.96%) Dynamics AX
Cloud Services
1 31 (29.81%) Azure
1 31 (29.81%) Power Platform
2 13 (12.50%) Azure Data Factory
3 10 (9.62%) AWS
4 6 (5.77%) IaaS
4 6 (5.77%) PaaS
5 5 (4.81%) SaaS
6 2 (1.92%) Azure Machine Learning
7 1 (0.96%) Azure Active Directory
7 1 (0.96%) Dynamics 365
7 1 (0.96%) Slack
Communications & Networking
1 4 (3.85%) Firewall
2 1 (0.96%) PuTTY
Database & Business Intelligence
1 34 (32.69%) SQL Server Integration Services
2 32 (30.77%) SQL Server
3 31 (29.81%) Power BI
4 22 (21.15%) SQL Server Reporting Services
5 21 (20.19%) SQL Server Analysis Services
6 14 (13.46%) Azure SQL Database
7 9 (8.65%) Big Data
8 8 (7.69%) BusinessObjects
9 7 (6.73%) Data Lake
10 6 (5.77%) Star Schema
11 5 (4.81%) Azure SQL Data Warehouse
11 5 (4.81%) Microsoft Analysis Services
11 5 (4.81%) Oracle Database
11 5 (4.81%) QlikView
12 4 (3.85%) Oracle Database 12c
13 3 (2.88%) NoSQL
13 3 (2.88%) PowerCenter
13 3 (2.88%) Qlik Sense
13 3 (2.88%) Relational Database
14 2 (1.92%) Oracle Database 11g
Development Applications
1 3 (2.88%) ERwin
2 2 (1.92%) ER Studio
2 2 (1.92%) PowerDesigner
2 2 (1.92%) SpecFlow
3 1 (0.96%) Ant
3 1 (0.96%) Cucumber
3 1 (0.96%) Git (software)
3 1 (0.96%) Jenkins
3 1 (0.96%) JIRA
3 1 (0.96%) Octopus Deploy
3 1 (0.96%) Oracle APEX
3 1 (0.96%) Oracle Forms
3 1 (0.96%) ProC
3 1 (0.96%) Selenium
3 1 (0.96%) TeamCity
3 1 (0.96%) Visual Studio
3 1 (0.96%) Visual Studio Team System
General
1 20 (19.23%) Finance
2 15 (14.42%) Public Sector
3 5 (4.81%) Billing
4 4 (3.85%) Banking
5 3 (2.88%) Law
5 3 (2.88%) Retail
6 2 (1.92%) Legal
6 2 (1.92%) Manufacturing
7 1 (0.96%) Italian Language
7 1 (0.96%) Local Government
Job Titles
1 26 (25.00%) Developer
2 23 (22.12%) Architect
3 19 (18.27%) Analyst
4 15 (14.42%) Business Intelligence Developer
4 15 (14.42%) Data Architect
5 14 (13.46%) Business Analyst
6 11 (10.58%) Data Manager
7 8 (7.69%) Power BI Developer
8 7 (6.73%) Enterprise Architect
9 6 (5.77%) DBA
9 6 (5.77%) SSAS Developer
9 6 (5.77%) Technical Analyst
9 6 (5.77%) Technical Business Analyst
10 5 (4.81%) Data Engineer
10 5 (4.81%) SQL Developer
11 4 (3.85%) Administrator
11 4 (3.85%) Business Intelligence Analyst
11 4 (3.85%) Data Analyst
11 4 (3.85%) Project Manager
11 4 (3.85%) Solutions Architect
Libraries, Frameworks & Software Standards
1 5 (4.81%) PySpark
2 2 (1.92%) Gherkin
2 2 (1.92%) REST
3 1 (0.96%) .NET
3 1 (0.96%) .NET Core
3 1 (0.96%) AngularJS
3 1 (0.96%) D3.js
3 1 (0.96%) Pandas
3 1 (0.96%) RxJS
Miscellaneous
1 10 (9.62%) Analytical Skills
2 6 (5.77%) Enterprise Software
3 4 (3.85%) NHS
4 2 (1.92%) Client/Server
4 2 (1.92%) Clustering
4 2 (1.92%) Data Structures
5 1 (0.96%) FMCG
5 1 (0.96%) Management Information System
5 1 (0.96%) Public Cloud
5 1 (0.96%) Taxonomies
Operating Systems
1 5 (4.81%) Windows
2 2 (1.92%) Linux
Processes & Methodologies
1 49 (47.12%) Business Intelligence
2 41 (39.42%) Data Modelling
3 30 (28.85%) ETL
4 19 (18.27%) Agile Software Development
5 16 (15.38%) Migration
6 13 (12.50%) Data Migration
6 13 (12.50%) Stakeholder Management
7 12 (11.54%) Analytics
8 11 (10.58%) Data Integration
8 11 (10.58%) ERP
8 11 (10.58%) Visualisation
9 10 (9.62%) Data Visualisation
10 8 (7.69%) Metadata Management
10 8 (7.69%) Project Delivery
11 7 (6.73%) Data Architecture
11 7 (6.73%) Data Governance
11 7 (6.73%) Information Architecture
11 7 (6.73%) Kimball Methodology
11 7 (6.73%) Performance Tuning
11 7 (6.73%) TOGAF
Programming Languages
1 52 (50.00%) SQL
2 16 (15.38%) T-SQL
3 4 (3.85%) C#
4 3 (2.88%) Data Analysis Expressions (DAX)
4 3 (2.88%) PL/SQL
4 3 (2.88%) PowerShell
4 3 (2.88%) Python
5 2 (1.92%) VBA
6 1 (0.96%) C
6 1 (0.96%) JavaScript
6 1 (0.96%) SAS Macro
6 1 (0.96%) Shell Script
6 1 (0.96%) TypeScript
6 1 (0.96%) VB
6 1 (0.96%) X++
Qualifications
1 4 (3.85%) ISEB
2 3 (2.88%) Degree
2 3 (2.88%) ISTQB
3 1 (0.96%) Computer Science Degree
3 1 (0.96%) ISTQB Foundation Certification
3 1 (0.96%) Security Cleared
Quality Assurance & Compliance
1 10 (9.62%) Data Quality
2 9 (8.65%) QA
3 5 (4.81%) GDPR
4 1 (0.96%) PMO
4 1 (0.96%) WCAG
System Software
1 2 (1.92%) Oracle RAC
2 1 (0.96%) Active Directory
2 1 (0.96%) Docker
Systems Management
1 2 (1.92%) Data Guard
1 2 (1.92%) Oracle RMAN
2 1 (0.96%) Kubernetes
2 1 (0.96%) Puppet
Vendors
1 23 (22.12%) Microsoft
2 11 (10.58%) Databricks
3 9 (8.65%) Oracle
4 6 (5.77%) SAP
4 6 (5.77%) Tableau
5 5 (4.81%) Informatica
6 3 (2.88%) BiZZdesign
6 3 (2.88%) Cognos
7 2 (1.92%) Cloudera
7 2 (1.92%) IBM
8 1 (0.96%) Alteryx
8 1 (0.96%) Birst
8 1 (0.96%) Infor
8 1 (0.96%) RedGate