The following table provides summary statistics for contract job vacancies advertised in North Yorkshire with a requirement for ETL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ETL over the 3 months to 28 June 2017 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.

Extract, Transform and Load (ETL)
Yorkshire / North Yorkshire
3 months to
28 Jun 2017
Same period 2016 Same period 2015
Rank 23 22 32
Rank change year-on-year -1 +10  
Contract jobs citing ETL 1 9 2
As % of all contract IT jobs advertised in North Yorkshire 0.70% 4.74% 0.90%
As % of the Processes & Methodologies category 0.95% 5.81% 1.20%
Number of daily rates quoted 1 7 1
Median daily rate £350 £400 £330
Median daily rate % change year-on-year -12.50% +21.21%  
UK excluding London median daily rate £405 £400 £397
% change year-on-year +1.31% +0.75%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £55.00 £20.50 £31.50
% change year-on-year +168.29% -34.92%  

ETL is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in North Yorkshire with a requirement for process and methodology skills.

Contract Process & Methodology Skills
North Yorkshire
Contract job vacancies with a requirement for process and methodology skills 105 155 167
As % of all contract IT job vacancies advertised in North Yorkshire 73.43% 81.58% 75.23%
Number of daily rates quoted 199 505 422
Median daily rate £375 £450 £375
Median daily rate % change year-on-year -16.66% +20.00%  
90% offered a daily rate of more than £185 £306 £288
10% offered a daily rate of more than £494 £925 £486
UK excluding London median daily rate £415 £400 £380
% change year-on-year +3.75% +5.26%  
Number of hourly rates quoted 14 28 41
Median hourly rate £12.00 £18.50 £11.50
Median hourly rate % change year-on-year -35.13% +60.86%  
90% offered a hourly rate of more than £9.09 £12.25 £10.25
10% offered a hourly rate of more than £43.19 £37.00 £40.00
UK excluding London median hourly rate £34.00 £28.50 £30.00
% change year-on-year +19.29% -5.00%  

ETL
Job Vacancy Trend in North Yorkshire

Job postings citing ETL as a percentage of all IT jobs advertised in North Yorkshire.

Job vacancy trend for ETL in North Yorkshire

ETL
Contractor Daily Rate Trend in North Yorkshire

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL in North Yorkshire.

Contractor daily rate trend for ETL in North Yorkshire

For the 6 months to 28 June 2017, IT contractor jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the North Yorkshire region with a requirement for ETL.

1 2 (100.00%) SQL
1 2 (100.00%) T-SQL
1 2 (100.00%) Business Intelligence
1 2 (100.00%) Microsoft
1 2 (100.00%) SQL Server Integration Services
1 2 (100.00%) SQL Server Reporting Services
2 1 (50.00%) SQL Server Analysis Services
2 1 (50.00%) Data Integration
2 1 (50.00%) SC Cleared
2 1 (50.00%) Security Cleared
2 1 (50.00%) Visualisation
2 1 (50.00%) Data Visualisation
2 1 (50.00%) SQL Server 2012
2 1 (50.00%) Kimball Methodology
2 1 (50.00%) Dashboard Development
2 1 (50.00%) SQL Server 2014
2 1 (50.00%) SQL Server 2016
2 1 (50.00%) Finance
2 1 (50.00%) SQL Server
2 1 (50.00%) Visual Studio
2 1 (50.00%) Data Warehouse
2 1 (50.00%) Data Modelling

ETL
Co-occurring IT Skills in North 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:

Database & Business Intelligence
1 2 (100.00%) SQL Server Integration Services
1 2 (100.00%) SQL Server Reporting Services
2 1 (50.00%) Data Warehouse
2 1 (50.00%) SQL Server
2 1 (50.00%) SQL Server 2012
2 1 (50.00%) SQL Server 2014
2 1 (50.00%) SQL Server 2016
2 1 (50.00%) SQL Server Analysis Services
Development Applications
1 1 (50.00%) Visual Studio
General
1 1 (50.00%) Finance
Job Titles
1 2 (100.00%) Developer
2 1 (50.00%) Business Intelligence Developer
2 1 (50.00%) Data Warehouse Developer
2 1 (50.00%) ETL Developer
2 1 (50.00%) SQL Developer
2 1 (50.00%) SSIS Developer
2 1 (50.00%) SSRS Developer
2 1 (50.00%) T-SQL Developer
Processes & Methodologies
1 2 (100.00%) Business Intelligence
2 1 (50.00%) Dashboard Development
2 1 (50.00%) Data Integration
2 1 (50.00%) Data Modelling
2 1 (50.00%) Data Visualisation
2 1 (50.00%) Kimball Methodology
2 1 (50.00%) Visualisation
Programming Languages
1 2 (100.00%) SQL
1 2 (100.00%) T-SQL
Qualifications
1 1 (50.00%) SC Cleared
1 1 (50.00%) Security Cleared
Vendors
1 2 (100.00%) Microsoft