Period
to 22 September 2018

The following table provides summary statistics for contract job vacancies advertised in 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 6 months to 22 September 2018 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)
England > Yorkshire
6 months to
22 Sep 2018
Same period 2017 Same period 2016
Rank 66 73 71
Rank change year-on-year +7 -2 -25
Contract jobs citing ETL 147 114 173
As % of all contract IT jobs advertised in Yorkshire 2.96% 2.73% 3.04%
As % of the Processes & Methodologies category 3.40% 3.20% 3.50%
Number of daily rates quoted 99 76 121
Yorkshire median daily rate £375 £419 £388
Median daily rate % change year-on-year -10.45% +8.06% -3.13%
10th Percentile £308 £325 £310
90th Percentile £488 £508 £488
England median daily rate £450 £450 £425
% change year-on-year - +5.88% -
Number of hourly rates quoted 7 1 0
Yorkshire median hourly rate £35.00 £35.00 -
England median hourly rate £35.00 £40.00 £44.00
% change year-on-year -12.50% -9.09% +46.67%

ETL is in the Processes and Methodologies 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 process or methodology skills.

All Process and Methodology Skills
Yorkshire
Contract vacancies with a requirement for process or methodology skills 4,320 3,557 4,942
As % of all contract IT jobs advertised in Yorkshire 87.11% 85.26% 86.79%
Number of daily rates quoted 2,899 2,342 3,309
Yorkshire median daily rate £413 £400 £400
Median daily rate % change year-on-year +3.13% - +9.59%
10th Percentile £281 £263 £270
90th Percentile £550 £550 £550
England median daily rate £465 £450 £425
% change year-on-year +3.33% +5.88% +3.03%
Number of hourly rates quoted 116 95 115
Yorkshire median hourly rate £17.41 £14.20 £14.75
Median hourly rate % change year-on-year +22.61% -3.73% +6.31%
10th Percentile £10.75 £8.89 £10.50
90th Percentile £41.50 £32.65 £42.15
England median hourly rate £20.90 £23.14 £22.84
% change year-on-year -9.70% +1.31% +3.82%

ETL
Job Vacancy Trend in Yorkshire

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

Job vacancy trend for ETL in Yorkshire

ETL
Contractor Daily Rate Trend in Yorkshire

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

Contractor daily rate trend for ETL in Yorkshire

ETL
Contractor Daily Rate Histogram in Yorkshire

The daily rate distribution of IT jobs citing ETL in Yorkshire over the 6 months to 22 September 2018.

Contractor daily rate histogram for ETL in Yorkshire

ETL
Contractor Hourly Rate Trend in Yorkshire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ETL in Yorkshire.

Contractor hourly rate trend for ETL in Yorkshire

ETL
Contractor Hourly Rate Histogram in Yorkshire

The hourly rate distribution of IT jobs citing ETL in Yorkshire over the 6 months to 22 September 2018.

Contractor hourly rate histogram for ETL in Yorkshire

ETL
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 ETL within the Yorkshire region over the 6 months to 22 September 2018. 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 -11 103 £355 -16.47% 19
South Yorkshire +1 27 £415 -2.35% 3
East Yorkshire +9 7 £475 -
North Yorkshire +3 4 £256 -26.79% 6
ETL
England

For the 6 months to 22 September 2018, IT contractor jobs citing ETL 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 ETL.

1 95 (64.63%) SQL
2 78 (53.06%) Data Warehouse
3 65 (44.22%) Business Intelligence
4 55 (37.41%) SQL Server Integration Services
5 52 (35.37%) SQL Server
6 37 (25.17%) T-SQL
7 34 (23.13%) SQL Server Reporting Services
8 33 (22.45%) Agile Software Development
9 28 (19.05%) Finance
10 27 (18.37%) Oracle
10 27 (18.37%) Data Modelling
10 27 (18.37%) Data Integration
11 26 (17.69%) ETL Development
12 25 (17.01%) Microsoft
13 23 (15.65%) Migration
14 22 (14.97%) Relational Database
15 21 (14.29%) Unix
15 21 (14.29%) Amazon AWS
16 20 (13.61%) Data Migration
17 18 (12.24%) Kimball Methodology
17 18 (12.24%) Analytics
18 17 (11.56%) C#
18 17 (11.56%) IBM
18 17 (11.56%) Analytical Skills
19 15 (10.20%) Problem-Solving
20 14 (9.52%) PL/SQL
20 14 (9.52%) SAS
20 14 (9.52%) Visualisation
20 14 (9.52%) Data Mapping
21 13 (8.84%) DataStage

ETL
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 14 (9.52%) SAS
2 2 (1.36%) Confluence
3 1 (0.68%) Apache Spark
3 1 (0.68%) SharePoint
Applications
1 12 (8.16%) Microsoft Excel
2 4 (2.72%) Spreadsheet
3 2 (1.36%) Microsoft Office
4 1 (0.68%) Microsoft PowerPoint
Business Applications
1 5 (3.40%) Cognos Business Intelligence
2 4 (2.72%) Cognos TM1
3 3 (2.04%) Dynamics AX
4 2 (1.36%) BPCS
4 2 (1.36%) Dynamics CRM
4 2 (1.36%) Movex
5 1 (0.68%) SAP ERP
Cloud Services
1 21 (14.29%) Amazon AWS
2 10 (6.80%) Amazon S3
3 6 (4.08%) Microsoft Azure
4 5 (3.40%) Virtual Private Cloud
5 4 (2.72%) Amazon EC2
6 3 (2.04%) Amazon EMR
6 3 (2.04%) Amazon Glacier
7 2 (1.36%) Dynamics 365
8 1 (0.68%) Amazon CloudWatch
8 1 (0.68%) AWS CloudTrail
8 1 (0.68%) Cloud Computing
Communications & Networking
1 1 (0.68%) Internet
1 1 (0.68%) PuTTY
Database & Business Intelligence
1 78 (53.06%) Data Warehouse
2 55 (37.41%) SQL Server Integration Services
3 52 (35.37%) SQL Server
4 34 (23.13%) SQL Server Reporting Services
5 22 (14.97%) Relational Database
6 13 (8.84%) DataStage
6 13 (8.84%) SQL Server 2016
7 12 (8.16%) Oracle ODI
7 12 (8.16%) SQL Server Analysis Services
8 10 (6.80%) Hadoop
8 10 (6.80%) OLAP
9 9 (6.12%) BusinessObjects
9 9 (6.12%) Power BI
9 9 (6.12%) Star Schema
10 8 (5.44%) Amazon Aurora
11 7 (4.76%) Big Data
11 7 (4.76%) Oracle OLAP
12 6 (4.08%) Data Mart
12 6 (4.08%) NoSQL
12 6 (4.08%) Pentaho
Development Applications
1 12 (8.16%) Toad
2 8 (5.44%) Visual Studio
3 7 (4.76%) JIRA
4 5 (3.40%) Team Foundation Server
5 3 (2.04%) Octopus Deploy
5 3 (2.04%) TeamCity
6 2 (1.36%) Git (software)
6 2 (1.36%) SpecFlow
7 1 (0.68%) MSTest
General
1 28 (19.05%) Finance
2 11 (7.48%) Banking
3 6 (4.08%) Retail
4 3 (2.04%) Manufacturing
5 2 (1.36%) Publishing
6 1 (0.68%) Billing
6 1 (0.68%) Law
6 1 (0.68%) Telecoms
Job Titles
1 94 (63.95%) Developer
2 41 (27.89%) ETL Developer
3 31 (21.09%) SQL Developer
4 27 (18.37%) Business Intelligence Developer
5 17 (11.56%) Analyst
6 11 (7.48%) SSIS Developer
7 10 (6.80%) Data Analyst
7 10 (6.80%) Data Engineer
8 9 (6.12%) SQL Server Developer
9 8 (5.44%) SQL BI Developer
10 6 (4.08%) Consultant
10 6 (4.08%) SQL Server BI Developer
10 6 (4.08%) T-SQL Developer
11 5 (3.40%) Data Warehouse Developer
11 5 (3.40%) ETL Analyst
12 4 (2.72%) .NET Software Engineer
12 4 (2.72%) C# Software Engineer
12 4 (2.72%) Informatica Developer
12 4 (2.72%) Informatica ETL Developer
12 4 (2.72%) Test Engineer
Libraries, Frameworks & Software Standards
1 5 (3.40%) .NET
1 5 (3.40%) Web Services
2 4 (2.72%) .NET Framework
2 4 (2.72%) WCF
3 3 (2.04%) Kafka
3 3 (2.04%) ODBC
3 3 (2.04%) RESTful
4 1 (0.68%) ASP.NET
4 1 (0.68%) ASP.NET MVC
4 1 (0.68%) CSS
4 1 (0.68%) HTML
4 1 (0.68%) jQuery
4 1 (0.68%) Oracle GoldenGate
4 1 (0.68%) Pandas
4 1 (0.68%) PySpark
4 1 (0.68%) WinForms
Miscellaneous
1 17 (11.56%) Analytical Skills
2 8 (5.44%) Mainframe
3 4 (2.72%) Greenfield Project
3 4 (2.72%) NHS
4 3 (2.04%) Data Centre
5 2 (1.36%) Data Structures
5 2 (1.36%) Management Information System
5 2 (1.36%) Virtual Team
6 1 (0.68%) Enterprise Software
6 1 (0.68%) Reference Data
6 1 (0.68%) Replication
Operating Systems
1 21 (14.29%) Unix
2 8 (5.44%) Linux
3 3 (2.04%) Red Hat Enterprise Linux
4 2 (1.36%) Solaris
4 2 (1.36%) Windows
4 2 (1.36%) Windows Server
5 1 (0.68%) Windows Server 2003
5 1 (0.68%) zOS
Processes & Methodologies
1 65 (44.22%) Business Intelligence
2 33 (22.45%) Agile Software Development
3 27 (18.37%) Data Integration
3 27 (18.37%) Data Modelling
4 26 (17.69%) ETL Development
5 23 (15.65%) Migration
6 20 (13.61%) Data Migration
7 18 (12.24%) Analytics
7 18 (12.24%) Kimball Methodology
8 15 (10.20%) Problem-Solving
9 14 (9.52%) Data Mapping
9 14 (9.52%) Visualisation
10 12 (8.16%) Test Automation
11 11 (7.48%) Continuous Improvement
12 10 (6.80%) Change Data Capture
12 10 (6.80%) Test Scripting
13 9 (6.12%) Data Analysis
13 9 (6.12%) Data Management
13 9 (6.12%) Data Visualisation
13 9 (6.12%) Scrum
Programming Languages
1 95 (64.63%) SQL
2 37 (25.17%) T-SQL
3 17 (11.56%) C#
4 14 (9.52%) PL/SQL
5 12 (8.16%) Python
6 9 (6.12%) VBA
7 8 (5.44%) Java
8 6 (4.08%) Shell Script
9 5 (3.40%) Perl
10 4 (2.72%) COBOL
10 4 (2.72%) R
11 3 (2.04%) JavaScript
12 1 (0.68%) PHP
12 1 (0.68%) PowerShell
12 1 (0.68%) Ruby
12 1 (0.68%) Scala
12 1 (0.68%) Smalltalk
12 1 (0.68%) VB
Qualifications
1 1 (0.68%) Computer Science Degree
1 1 (0.68%) Degree
1 1 (0.68%) SC Cleared
1 1 (0.68%) Security Cleared
Quality Assurance & Compliance
1 12 (8.16%) QA
2 9 (6.12%) Data Quality
3 4 (2.72%) SLA
4 3 (2.04%) GDPR
4 3 (2.04%) PCI DSS
4 3 (2.04%) PMO
System Software
1 6 (4.08%) Docker
Systems Management
1 3 (2.04%) Control-M
1 3 (2.04%) Opscode Chef
Vendors
1 27 (18.37%) Oracle
2 25 (17.01%) Microsoft
3 17 (11.56%) IBM
4 12 (8.16%) Tableau
5 11 (7.48%) SAP
6 9 (6.12%) Informatica
7 8 (5.44%) Hortonworks
8 5 (3.40%) Cognos
9 4 (2.72%) Ab Initio
9 4 (2.72%) MuleSoft
9 4 (2.72%) webMethods
10 3 (2.04%) Axway
10 3 (2.04%) IBM Sterling
10 3 (2.04%) Netezza
10 3 (2.04%) ServiceNow
10 3 (2.04%) Splunk
11 2 (1.36%) Alteryx
11 2 (1.36%) Cloudera
11 2 (1.36%) Remedy
11 2 (1.36%) Talend