Period
to 11 July 2020

The following table provides summary statistics for contract job vacancies advertised in Hertfordshire 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 11 July 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
East of England > Hertfordshire
6 months to
11 Jul 2020
Same period 2019 Same period 2018
Rank 46 57 57
Rank change year-on-year +11 0 +5
Contract jobs citing Data Warehouse 13 41 45
As % of all contract jobs advertised in Hertfordshire 1.98% 2.88% 2.86%
As % of the Database & Business Intelligence category 11.40% 15.47% 15.79%
Number of daily rates quoted 6 27 31
Median daily rate £438 £475 £400
Median daily rate % change year-on-year -7.89% +18.75% +14.29%
10th Percentile £363 £361 £340
90th Percentile £519 £565 £488
East of England median daily rate £438 £464 £425
% change year-on-year -5.66% +9.12% -
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
East of England median hourly rate - - -

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 Hertfordshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Hertfordshire
Contract vacancies with a requirement for database or business intelligence skills 114 265 285
As % of all contract IT jobs advertised in Hertfordshire 17.35% 18.60% 18.14%
Number of daily rates quoted 64 157 186
Median daily rate £438 £465 £400
Median daily rate % change year-on-year -5.91% +16.25% -
10th Percentile £231 £340 £263
90th Percentile £571 £600 £541
East of England median daily rate £450 £450 £425
% change year-on-year - +5.88% +6.25%
Number of hourly rates quoted 1 8 9
Median hourly rate £28.50 £35.00 £24.00
Median hourly rate % change year-on-year -18.57% +45.83% -12.73%
10th Percentile £28.25 £17.23 £13.10
90th Percentile £28.75 £62.00 £37.00
Median hourly rate £21.57 £30.00 £26.45
% change year-on-year -28.10% +13.42% -16.03%

Data Warehouse
Job Vacancy Trend in Hertfordshire

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

Job vacancy trend for Data Warehouse in Hertfordshire

Data Warehouse
Contractor Daily Rate Trend in Hertfordshire

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

Daily rate trend for Data Warehouse in Hertfordshire

Data Warehouse
Daily Rate Histogram in Hertfordshire

Daily rate distribution for jobs citing Data Warehouse in Hertfordshire over the 6 months to 11 July 2020.

Daily rate histogram for Data Warehouse in Hertfordshire

Data Warehouse
Contractor Hourly Rate Trend in Hertfordshire

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

Hourly rate trend for Data Warehouse in Hertfordshire

Data Warehouse
Contract Job Locations in Hertfordshire

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 Hertfordshire region over the 6 months to 11 July 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
Hatfield +12 2 £400 -3.03%
Welwyn Garden City 0 2 - -
Watford +16 1 £425 -10.53% 1
Hemel Hempstead 0 1 - - 2
Royston - 1 £575 -
Borehamwood - 1 £350 - 2
Welwyn - 1 - -
Data Warehouse
East of England

For the 6 months to 11 July 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 Hertfordshire region with a requirement for Data Warehouse.

1 9 (69.23%) Business Intelligence
2 8 (61.54%) ETL
3 5 (38.46%) SQL
3 5 (38.46%) Data Governance
3 5 (38.46%) Analytical Skills
4 4 (30.77%) Analytics
4 4 (30.77%) Hadoop
4 4 (30.77%) Data Modelling
4 4 (30.77%) Finance
4 4 (30.77%) Agile Software Development
5 3 (23.08%) Retail
5 3 (23.08%) Data Management
5 3 (23.08%) Visualisation
5 3 (23.08%) AWS
5 3 (23.08%) Data Quality
5 3 (23.08%) Data Visualisation
5 3 (23.08%) Data Transformation
5 3 (23.08%) Power BI
5 3 (23.08%) Data Strategy
5 3 (23.08%) Power Platform
5 3 (23.08%) Data Lake
6 2 (15.38%) Data Lineage
6 2 (15.38%) Logical Data Model
6 2 (15.38%) Talend
6 2 (15.38%) Data Analytics
6 2 (15.38%) Amazon EMR
6 2 (15.38%) Master Data Management
6 2 (15.38%) Relational Database
6 2 (15.38%) Amazon Redshift
6 2 (15.38%) FMCG

Data Warehouse
Co-occurring IT Skills in Hertfordshire 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 1 (7.69%) Apache Spark
1 1 (7.69%) Confluence
1 1 (7.69%) SharePoint
Applications
1 2 (15.38%) Microsoft Excel
1 2 (15.38%) Microsoft Office
2 1 (7.69%) MS Visio
Cloud Services
1 3 (23.08%) AWS
1 3 (23.08%) Power Platform
2 2 (15.38%) Amazon EMR
3 1 (7.69%) Amazon S3
Database & Business Intelligence
1 4 (30.77%) Hadoop
2 3 (23.08%) Data Lake
2 3 (23.08%) Power BI
3 2 (15.38%) Amazon Redshift
3 2 (15.38%) RDBMS
3 2 (15.38%) Relational Database
3 2 (15.38%) SQL Server
3 2 (15.38%) SQL Server Analysis Services
3 2 (15.38%) SQL Server Integration Services
4 1 (7.69%) Amazon Athena
4 1 (7.69%) Big Data
4 1 (7.69%) Data Mart
4 1 (7.69%) Data Mining
4 1 (7.69%) Electronic Patient Records
4 1 (7.69%) Microsoft Analysis Services
4 1 (7.69%) NoSQL
4 1 (7.69%) Oracle Reports
4 1 (7.69%) Snowflake Schema
4 1 (7.69%) SQL Server 2008
4 1 (7.69%) SQL Server Reporting Services
Development Applications
1 1 (7.69%) ERwin
1 1 (7.69%) Jenkins
1 1 (7.69%) JIRA
General
1 4 (30.77%) Finance
2 3 (23.08%) Retail
3 1 (7.69%) French Language
3 1 (7.69%) German Language
3 1 (7.69%) Pharmaceutical
3 1 (7.69%) Public Sector
Job Titles
1 3 (23.08%) Business Intelligence Developer
1 3 (23.08%) Developer
2 2 (15.38%) Architect
2 2 (15.38%) Data Manager
2 2 (15.38%) Master Data Manager
2 2 (15.38%) Project Manager
3 1 (7.69%) Analytics Developer
3 1 (7.69%) Data Engineer
3 1 (7.69%) Data Warehouse Manager
3 1 (7.69%) Enterprise Information Architect
3 1 (7.69%) Finance Manager
3 1 (7.69%) Governance Analyst
3 1 (7.69%) Power BI Consultant
3 1 (7.69%) Senior Business Intelligence Developer
3 1 (7.69%) Senior Data Engineer
3 1 (7.69%) Senior SQL Developer
3 1 (7.69%) SQL BI Developer
3 1 (7.69%) SQL Server BI Developer
3 1 (7.69%) SQL Server Data Warehouse Developer
3 1 (7.69%) Transformation Programme Architect
Libraries, Frameworks & Software Standards
1 1 (7.69%) Oracle Fusion
Miscellaneous
1 5 (38.46%) Analytical Skills
2 2 (15.38%) FMCG
Processes & Methodologies
1 9 (69.23%) Business Intelligence
2 8 (61.54%) ETL
3 5 (38.46%) Data Governance
4 4 (30.77%) Agile Software Development
4 4 (30.77%) Analytics
4 4 (30.77%) Data Modelling
5 3 (23.08%) Data Management
5 3 (23.08%) Data Strategy
5 3 (23.08%) Data Transformation
5 3 (23.08%) Data Visualisation
5 3 (23.08%) Visualisation
6 2 (15.38%) Data Analytics
6 2 (15.38%) Data Lineage
6 2 (15.38%) Logical Data Model
6 2 (15.38%) Master Data Management
6 2 (15.38%) Project Management
6 2 (15.38%) Scrum
7 1 (7.69%) Programme Management
7 1 (7.69%) Risk Management
7 1 (7.69%) Stakeholder Management
Programming Languages
1 5 (38.46%) SQL
2 2 (15.38%) T-SQL
3 1 (7.69%) Data Analysis Expressions (DAX)
3 1 (7.69%) Java
3 1 (7.69%) JavaScript
3 1 (7.69%) Python
Qualifications
1 1 (7.69%) Computer Science Degree
1 1 (7.69%) Degree
1 1 (7.69%) SC Cleared
1 1 (7.69%) Security Cleared
Quality Assurance & Compliance
1 3 (23.08%) Data Quality
2 2 (15.38%) QA
Vendors
1 2 (15.38%) Ab Initio
1 2 (15.38%) Talend
2 1 (7.69%) Informatica
2 1 (7.69%) MicroStrategy
2 1 (7.69%) Oracle