Period
to 20 June 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 20 June 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
20 Jun 2018
Same period 2017 Same period 2016
Rank 80 104 79
Rank change year-on-year +24 -25 -16
Contract jobs citing ETL 143 83 152
As % of all contract IT jobs advertised in Yorkshire 2.94% 2.00% 2.71%
As % of the Processes & Methodologies category 3.40% 2.37% 3.20%
Number of daily rates quoted 95 45 131
Yorkshire median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - -6.25%
10th Percentile £259 £306 £305
90th Percentile £533 £490 £488
England median daily rate £471 £450 £425
% change year-on-year +4.72% +5.88% -
Number of hourly rates quoted 5 0 0
Yorkshire median hourly rate £35.00 - -
England median hourly rate £47.50 £40.00 £25.25
% change year-on-year +18.75% +58.42% -31.29%

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,206 3,499 4,746
As % of all contract IT jobs advertised in Yorkshire 86.35% 84.44% 84.77%
Number of daily rates quoted 2,783 2,253 3,233
Yorkshire median daily rate £400 £400 £400
10th Percentile £270 £263 £275
90th Percentile £538 £550 £575
England median daily rate £463 £450 £425
% change year-on-year +2.78% +5.88% +4.94%
Number of hourly rates quoted 118 87 106
Yorkshire median hourly rate £20.31 £13.00 £15.75
Median hourly rate % change year-on-year +56.19% -17.46% -5.80%
10th Percentile £10.53 £8.88 £10.20
90th Percentile £44.65 £35.94 £39.38
England median hourly rate £22.00 £25.00 £25.00
% change year-on-year -12.00% - +19.05%

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 20 June 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
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 20 June 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 +21 106 £400 +6.67% 13
South Yorkshire -2 19 £400 +10.34% 6
East Yorkshire +6 10 £458 +30.71%
North Yorkshire +2 2 £225 -40.00% 5
Humberside - 1 £259 -
ETL
England

For the 6 months to 20 June 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 78 (54.55%) SQL
2 62 (43.36%) Data Warehouse
3 61 (42.66%) Business Intelligence
4 51 (35.66%) Agile Software Development
5 42 (29.37%) SQL Server Integration Services
6 34 (23.78%) SQL Server
7 32 (22.38%) Informatica
8 31 (21.68%) Data Modelling
9 30 (20.98%) Hadoop
10 28 (19.58%) Finance
11 24 (16.78%) Microsoft
11 24 (16.78%) Apache Hive
12 23 (16.08%) Kafka
13 22 (15.38%) HBase
13 22 (15.38%) Apache Spark
14 21 (14.69%) Oracle
14 21 (14.69%) T-SQL
15 20 (13.99%) Big Data
15 20 (13.99%) Talend
15 20 (13.99%) MapReduce
16 19 (13.29%) SAS
17 18 (12.59%) Banking
17 18 (12.59%) Migration
17 18 (12.59%) Data Integration
17 18 (12.59%) ETL Development
18 17 (11.89%) Pentaho
18 17 (11.89%) Data Management
18 17 (11.89%) Data Analysis
18 17 (11.89%) Python
19 16 (11.19%) Microsoft Excel

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 22 (15.38%) Apache Spark
2 19 (13.29%) SAS
3 3 (2.10%) Confluence
4 1 (0.70%) WebSphere
Applications
1 16 (11.19%) Microsoft Excel
2 3 (2.10%) Microsoft Office
3 2 (1.40%) Spreadsheet
Business Applications
1 6 (4.20%) Cognos Business Intelligence
1 6 (4.20%) Cognos TM1
2 3 (2.10%) Dynamics AX
3 2 (1.40%) BPCS
3 2 (1.40%) Movex
4 1 (0.70%) SAP ERP
Cloud Services
1 13 (9.09%) Amazon AWS
2 8 (5.59%) GitHub
3 6 (4.20%) Amazon S3
4 1 (0.70%) Cloud Computing
4 1 (0.70%) Microsoft Azure
4 1 (0.70%) Virtual Private Cloud
Communications & Networking
1 8 (5.59%) DSL
Database & Business Intelligence
1 62 (43.36%) Data Warehouse
2 42 (29.37%) SQL Server Integration Services
3 34 (23.78%) SQL Server
4 30 (20.98%) Hadoop
5 24 (16.78%) Apache Hive
6 22 (15.38%) HBase
7 20 (13.99%) Big Data
8 17 (11.89%) Pentaho
9 16 (11.19%) SQL Server Reporting Services
10 15 (10.49%) Power BI
10 15 (10.49%) Relational Database
11 11 (7.69%) BusinessObjects
11 11 (7.69%) DataStage
11 11 (7.69%) NoSQL
12 9 (6.29%) Impala
13 8 (5.59%) SQL Server Analysis Services
13 8 (5.59%) Sqoop
14 6 (4.20%) Data Mart
14 6 (4.20%) OLAP
14 6 (4.20%) Oracle ODI
Development Applications
1 7 (4.90%) Toad
2 6 (4.20%) JIRA
2 6 (4.20%) Visual Studio
3 5 (3.50%) Team Foundation Server
4 3 (2.10%) Git (software)
5 1 (0.70%) Bitbucket
5 1 (0.70%) Gerrit
5 1 (0.70%) IBM UrbanCode
5 1 (0.70%) Jenkins
5 1 (0.70%) Selenium
5 1 (0.70%) SQL Server Management Studio (SSMS)
5 1 (0.70%) TeamCity
5 1 (0.70%) WebDriver
General
1 28 (19.58%) Finance
2 18 (12.59%) Banking
3 4 (2.80%) Games
3 4 (2.80%) Manufacturing
3 4 (2.80%) Retail
4 1 (0.70%) Billing
4 1 (0.70%) Financial Institution
4 1 (0.70%) Investment Banking
4 1 (0.70%) Telecoms
Job Titles
1 69 (48.25%) Developer
2 31 (21.68%) ETL Developer
3 29 (20.28%) Data Engineer
4 28 (19.58%) Analyst
5 21 (14.69%) Business Intelligence Developer
6 11 (7.69%) SQL Developer
7 10 (6.99%) Data Analyst
8 8 (5.59%) Big Data Engineer
9 7 (4.90%) Cognos Developer
9 7 (4.90%) Informatica Developer
10 6 (4.20%) Business Intelligence Analyst
10 6 (4.20%) Data Warehouse Developer
10 6 (4.20%) Informatica ETL Developer
10 6 (4.20%) SQL Analyst
11 5 (3.50%) Cognos BI Developer
11 5 (3.50%) Hadoop Engineer
11 5 (3.50%) Test Engineer
12 4 (2.80%) .NET Software Engineer
12 4 (2.80%) C# Software Engineer
12 4 (2.80%) ETL Analyst
Libraries, Frameworks & Software Standards
1 23 (16.08%) Kafka
2 16 (11.19%) Spark Streaming
3 4 (2.80%) .NET
3 4 (2.80%) .NET Framework
3 4 (2.80%) WCF
4 3 (2.10%) ODBC
4 3 (2.10%) RESTful
4 3 (2.10%) XML
5 2 (1.40%) JSON
6 1 (0.70%) CSS
6 1 (0.70%) HTML
6 1 (0.70%) Node.js
6 1 (0.70%) Oracle GoldenGate
Miscellaneous
1 15 (10.49%) Analytical Skills
2 6 (4.20%) Management Information System
2 6 (4.20%) NHS
3 5 (3.50%) Greenfield Project
4 3 (2.10%) Mainframe
5 2 (1.40%) Data Centre
5 2 (1.40%) Data Structures
5 2 (1.40%) Reference Data
5 2 (1.40%) Virtual Team
6 1 (0.70%) Enterprise Software
6 1 (0.70%) Market Risk
6 1 (0.70%) Replication
Operating Systems
1 11 (7.69%) Unix
2 1 (0.70%) Linux
2 1 (0.70%) Windows
2 1 (0.70%) Windows Server
2 1 (0.70%) zOS
Processes & Methodologies
1 61 (42.66%) Business Intelligence
2 51 (35.66%) Agile Software Development
3 31 (21.68%) Data Modelling
4 20 (13.99%) MapReduce
5 18 (12.59%) Data Integration
5 18 (12.59%) ETL Development
5 18 (12.59%) Migration
6 17 (11.89%) Data Analysis
6 17 (11.89%) Data Management
7 13 (9.09%) Data Migration
8 12 (8.39%) Analytics
8 12 (8.39%) Continuous Improvement
8 12 (8.39%) Continuous Integration
8 12 (8.39%) Problem-Solving
8 12 (8.39%) Test Automation
9 11 (7.69%) Scrum
10 10 (6.99%) DevOps
11 9 (6.29%) Dashboard Development
12 8 (5.59%) Software Engineering
13 7 (4.90%) TDD
Programming Languages
1 78 (54.55%) SQL
2 21 (14.69%) T-SQL
3 17 (11.89%) Python
4 13 (9.09%) Java
5 11 (7.69%) Scala
6 10 (6.99%) Shell Script
7 8 (5.59%) HiveQL
7 8 (5.59%) PL/SQL
8 6 (4.20%) C#
9 4 (2.80%) Ruby
10 3 (2.10%) R
11 2 (1.40%) COBOL
12 1 (0.70%) JavaScript
12 1 (0.70%) Perl
12 1 (0.70%) Smalltalk
12 1 (0.70%) VBA
Qualifications
1 10 (6.99%) Security Cleared
2 7 (4.90%) SC Cleared
3 4 (2.80%) Degree
4 2 (1.40%) BPSS Clearance
Quality Assurance & Compliance
1 13 (9.09%) Data Quality
1 13 (9.09%) QA
2 4 (2.80%) SLA
3 2 (1.40%) GDPR
3 2 (1.40%) PMO
System Software
1 8 (5.59%) Apache Flume
2 5 (3.50%) Docker
Systems Management
1 7 (4.90%) Ansible
2 2 (1.40%) CSIRT
3 1 (0.70%) Systems Management Server (SMS)
Vendors
1 32 (22.38%) Informatica
2 24 (16.78%) Microsoft
3 21 (14.69%) Oracle
4 20 (13.99%) Talend
5 14 (9.79%) SAP
6 12 (8.39%) IBM
7 11 (7.69%) Cognos
8 7 (4.90%) Cloudera
8 7 (4.90%) Tableau
9 6 (4.20%) Hortonworks
10 4 (2.80%) MuleSoft
10 4 (2.80%) webMethods
11 3 (2.10%) Netezza
12 2 (1.40%) Alteryx
12 2 (1.40%) Embarcadero
12 2 (1.40%) Remedy
13 1 (0.70%) Logi
13 1 (0.70%) Logi Analytics
13 1 (0.70%) Microgen
13 1 (0.70%) VMware