Period
to 28 May 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 May 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 May 2020
Same period 2019 Same period 2018
Rank 67 72 98
Rank change year-on-year +5 +26 -4
Contract jobs citing Data Warehouse 57 118 111
As % of all contract jobs advertised in Yorkshire 2.69% 2.64% 2.28%
As % of the Database & Business Intelligence category 14.81% 12.72% 10.72%
Number of daily rates quoted 33 86 90
Median daily rate £575 £425 £425
Median daily rate % change year-on-year +35.29% - +13.33%
10th Percentile £318 £289 £263
90th Percentile £685 £563 £525
England median daily rate £475 £475 £475
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
England median hourly rate £50.00 £19.85 £26.50
% change year-on-year +151.89% -25.09% -27.40%

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 385 928 1,035
As % of all contract IT jobs advertised in Yorkshire 18.15% 20.77% 21.28%
Number of daily rates quoted 251 638 723
Median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +6.67%
10th Percentile £306 £306 £298
90th Percentile £613 £575 £538
England median daily rate £500 £488 £475
% change year-on-year +2.56% +2.63% +5.56%
Number of hourly rates quoted 21 20 8
Median hourly rate £19.90 £17.11 £18.77
Median hourly rate % change year-on-year +16.34% -8.87% -1.21%
10th Percentile £11.63 £14.41 £14.38
90th Percentile £27.29 £26.21 £34.13
Median hourly rate £35.00 £35.00 £32.00
% change year-on-year - +9.38% +6.67%

Data Warehouse
Job Vacancy Trend in Yorkshire

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

Job vacancy trend for Data Warehouse in Yorkshire

Data Warehouse
Contractor Daily Rate Trend in Yorkshire

3-month moving average daily rate quoted in jobs citing Data Warehouse in Yorkshire.

Daily rate trend for Data Warehouse in Yorkshire

Data Warehouse
Daily Rate Histogram in Yorkshire

Daily rate distribution for jobs citing Data Warehouse in Yorkshire over the 6 months to 28 May 2020.

Daily rate histogram for Data Warehouse in Yorkshire

Data Warehouse
Contractor Hourly Rate Trend in Yorkshire

3-month moving average hourly rates quoted in jobs citing Data Warehouse in Yorkshire.

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 28 May 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 +9 49 £575 +35.29% 2
South Yorkshire +38 4 £550 +131.58%
North Yorkshire +1 4 £194 -56.94%
Data Warehouse
England

For the 6 months to 28 May 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 28 (49.12%) SQL
2 19 (33.33%) SQL Server Integration Services
3 18 (31.58%) ETL
4 16 (28.07%) Business Intelligence
4 16 (28.07%) SQL Server
5 15 (26.32%) Power BI
5 15 (26.32%) Power Platform
6 12 (21.05%) Agile Software Development
7 11 (19.30%) SQL Server Reporting Services
8 9 (15.79%) Finance
8 9 (15.79%) Migration
8 9 (15.79%) ERP
8 9 (15.79%) Data Modelling
8 9 (15.79%) SQL Server Analysis Services
8 9 (15.79%) Security Cleared
8 9 (15.79%) Data Governance
8 9 (15.79%) Big Data
9 8 (14.04%) Kimball Methodology
9 8 (14.04%) Azure
9 8 (14.04%) AWS
9 8 (14.04%) Continuous Integration
9 8 (14.04%) Data Integration
10 7 (12.28%) Git (software)
10 7 (12.28%) Legal
10 7 (12.28%) Open Source
10 7 (12.28%) Identity Access Management
10 7 (12.28%) PySpark
11 6 (10.53%) Data Lake
11 6 (10.53%) Continuous Deployment
11 6 (10.53%) Public Sector

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 2 (3.51%) SharePoint
2 1 (1.75%) Apache Spark
Applications
1 5 (8.77%) Microsoft Excel
2 1 (1.75%) Microsoft Office
2 1 (1.75%) Microsoft PowerPoint
2 1 (1.75%) Spreadsheet
Cloud Services
1 15 (26.32%) Power Platform
2 8 (14.04%) AWS
2 8 (14.04%) Azure
3 6 (10.53%) GitHub
4 5 (8.77%) Amazon CloudWatch
4 5 (8.77%) Amazon EC2
4 5 (8.77%) Amazon S3
4 5 (8.77%) Azure Data Factory
Communications & Networking
1 3 (5.26%) Firewall
Database & Business Intelligence
1 19 (33.33%) SQL Server Integration Services
2 16 (28.07%) SQL Server
3 15 (26.32%) Power BI
4 11 (19.30%) SQL Server Reporting Services
5 9 (15.79%) Big Data
5 9 (15.79%) SQL Server Analysis Services
6 6 (10.53%) Azure SQL Database
6 6 (10.53%) Data Lake
6 6 (10.53%) Qlik Sense
6 6 (10.53%) QlikView
7 4 (7.02%) Relational Database
8 3 (5.26%) BusinessObjects
8 3 (5.26%) NoSQL
8 3 (5.26%) SQL Server 2012
9 2 (3.51%) Apache Hive
9 2 (3.51%) Azure SQL Data Warehouse
9 2 (3.51%) Hadoop
9 2 (3.51%) Microsoft Power View
9 2 (3.51%) SAP HANA
10 1 (1.75%) SQL Server 2014
Development Applications
1 7 (12.28%) Git (software)
2 5 (8.77%) Bitbucket
2 5 (8.77%) GitLab
3 3 (5.26%) Snyk
3 3 (5.26%) SQL Server Management Studio (SSMS)
4 2 (3.51%) Bitbucket Server
5 1 (1.75%) ERwin
5 1 (1.75%) Jenkins
5 1 (1.75%) Octopus Deploy
5 1 (1.75%) ProC
5 1 (1.75%) Team Foundation Server
5 1 (1.75%) TeamCity
General
1 9 (15.79%) Finance
2 7 (12.28%) Legal
3 6 (10.53%) Public Sector
4 3 (5.26%) Law
5 1 (1.75%) Local Government
5 1 (1.75%) Manufacturing
5 1 (1.75%) Marketing
5 1 (1.75%) Retail
Job Titles
1 19 (33.33%) Architect
1 19 (33.33%) Developer
2 10 (17.54%) Data Architect
3 9 (15.79%) Analyst
4 6 (10.53%) Business Intelligence Developer
4 6 (10.53%) Enterprise Architect
5 4 (7.02%) Business Analyst
5 4 (7.02%) Data Engineer
5 4 (7.02%) SQL Developer
5 4 (7.02%) Technical Architect
6 3 (5.26%) Data Warehouse Architect
6 3 (5.26%) Enterprise Data Architect
6 3 (5.26%) ETL Developer
6 3 (5.26%) Senior Architect
7 2 (3.51%) Analyst Developer
7 2 (3.51%) Database Developer
7 2 (3.51%) SAP Architect
7 2 (3.51%) Senior Technical Architect
7 2 (3.51%) Technical Analyst
7 2 (3.51%) Technical Business Analyst
Libraries, Frameworks & Software Standards
1 7 (12.28%) PySpark
2 2 (3.51%) .NET
2 2 (3.51%) AngularJS
2 2 (3.51%) JSON
3 1 (1.75%) .NET Core
3 1 (1.75%) Kafka
3 1 (1.75%) Pandas
3 1 (1.75%) RxJS
Miscellaneous
1 6 (10.53%) Enterprise Software
2 5 (8.77%) Analytical Skills
3 3 (5.26%) Data Centre
3 3 (5.26%) Data Structures
4 1 (1.75%) Linked Data
4 1 (1.75%) NHS
4 1 (1.75%) Self-Motivation
Operating Systems
1 1 (1.75%) Linux
Processes & Methodologies
1 18 (31.58%) ETL
2 16 (28.07%) Business Intelligence
3 12 (21.05%) Agile Software Development
4 9 (15.79%) Data Governance
4 9 (15.79%) Data Modelling
4 9 (15.79%) ERP
4 9 (15.79%) Migration
5 8 (14.04%) Continuous Integration
5 8 (14.04%) Data Integration
5 8 (14.04%) Kimball Methodology
6 7 (12.28%) Identity Access Management
6 7 (12.28%) Open Source
7 6 (10.53%) Business Analysis
7 6 (10.53%) Collaborative Working
7 6 (10.53%) Continuous Deployment
7 6 (10.53%) Information Architecture
7 6 (10.53%) SOA
8 5 (8.77%) Project Planning
8 5 (8.77%) Risk Assessment
8 5 (8.77%) Risk Management
Programming Languages
1 28 (49.12%) SQL
2 6 (10.53%) Python
3 5 (8.77%) T-SQL
4 3 (5.26%) Data Analysis Expressions (DAX)
4 3 (5.26%) Java
5 2 (3.51%) C#
5 2 (3.51%) PL/SQL
6 1 (1.75%) Go
6 1 (1.75%) JavaScript
6 1 (1.75%) PowerShell
6 1 (1.75%) Ruby
6 1 (1.75%) TypeScript
6 1 (1.75%) VBA
Qualifications
1 9 (15.79%) Security Cleared
2 5 (8.77%) CESG Certified Professional
2 5 (8.77%) CISM
2 5 (8.77%) CISSP
2 5 (8.77%) CRISC
2 5 (8.77%) DV Cleared
3 3 (5.26%) AWS Certification
4 2 (3.51%) Degree
4 2 (3.51%) SC Cleared
Quality Assurance & Compliance
1 5 (8.77%) GDPR
2 2 (3.51%) Data Quality
3 1 (1.75%) QA
Systems Management
1 3 (5.26%) Terraform
2 1 (1.75%) Oozie
2 1 (1.75%) Opscode Chef
Vendors
1 6 (10.53%) Microsoft
2 5 (8.77%) Tableau
3 4 (7.02%) Databricks
3 4 (7.02%) Oracle
4 2 (3.51%) SAP
5 1 (1.75%) Birst
5 1 (1.75%) Cloudera
5 1 (1.75%) Google
5 1 (1.75%) Infor
5 1 (1.75%) Informatica
5 1 (1.75%) RedGate
5 1 (1.75%) Teradata