Period
to 24 November 2017

The following table provides summary statistics for contract job vacancies advertised in Leeds 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 24 November 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)
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 59 81 76
Rank change year-on-year +22 -5 +7
Contract jobs citing ETL 78 67 84
As % of all contract IT jobs advertised in Leeds 3.46% 2.56% 2.56%
As % of the Processes & Methodologies category 4.01% 2.92% 2.94%
Number of daily rates quoted 63 58 91
Leeds median daily rate £425 £378 £425
Median daily rate % change year-on-year +12.58% -11.18% +29.77%
10th Percentile £313 £311 £263
90th Percentile £490 £479 £705
West Yorkshire median daily rate £425 £390 £390
% change year-on-year +8.97% - +11.43%
Number of hourly rates quoted 0 0 0
Leeds median hourly rate - - -
West Yorkshire median hourly rate - £21.88 -

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 Leeds with a requirement for process or methodology skills.

All Process and Methodology Skills
Leeds
Contract vacancies with a requirement for process or methodology skills 1944 2293 2855
As % of all contract IT jobs advertised in Leeds 86.17% 87.65% 87.18%
Number of daily rates quoted 1390 1547 2002
Leeds median daily rate £410 £400 £380
Median daily rate % change year-on-year +2.50% +5.26% +8.57%
10th Percentile £275 £282 £265
90th Percentile £550 £563 £550
West Yorkshire median daily rate £400 £400 £375
% change year-on-year - +6.67% +7.14%
Number of hourly rates quoted 28 36 67
Leeds median hourly rate £20.50 £13.50 £13.60
Median hourly rate % change year-on-year +51.85% -0.70% +0.70%
10th Percentile £13.58 £10.20 £8.61
90th Percentile £40.00 £31.13 £39.70
West Yorkshire median hourly rate £16.00 £14.50 £15.00
% change year-on-year +10.34% -3.33% +3.45%

ETL
Job Vacancy Trend in Leeds

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

Job vacancy trend for ETL in Leeds

ETL
Contractor Daily Rate Trend in Leeds

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

Contractor daily rate trend for ETL in Leeds

ETL
Contractor Daily Rate Histogram in Leeds

The daily rate distribution of IT jobs citing ETL in Leeds over the 6 months to 24 November 2017.

Contractor daily rate histogram for ETL in Leeds

ETL
Contractor Hourly Rate Trend in Leeds

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

Contractor hourly rate trend for ETL in Leeds

For the 6 months to 24 November 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 Leeds region with a requirement for ETL.

1 51 (65.38%) SQL
2 32 (41.03%) Shell Script
3 29 (37.18%) Python
3 29 (37.18%) Continuous Integration
3 29 (37.18%) Apache Hive
3 29 (37.18%) Big Data
4 28 (35.90%) HBase
4 28 (35.90%) Apache Spark
4 28 (35.90%) Microsoft
4 28 (35.90%) SQL Server
5 27 (34.62%) SQL Server Integration Services
5 27 (34.62%) DevOps
5 27 (34.62%) Kafka
6 26 (33.33%) Apache Flume
6 26 (33.33%) MapReduce
6 26 (33.33%) Sqoop
6 26 (33.33%) Impala
6 26 (33.33%) Spark Streaming
6 26 (33.33%) Hadoop
7 24 (30.77%) GitHub
8 22 (28.21%) Agile Software Development
8 22 (28.21%) Data Modelling
9 20 (25.64%) Ansible
10 19 (24.36%) Informatica
11 18 (23.08%) Security Cleared
11 18 (23.08%) Performance Tuning
12 17 (21.79%) Open Source
12 17 (21.79%) Finance
13 16 (20.51%) NoSQL
13 16 (20.51%) SC Cleared

ETL
Co-occurring IT Skills in Leeds 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 28 (35.90%) Apache Spark
2 10 (12.82%) OpenStack
3 5 (6.41%) SAS
4 1 (1.28%) Apache
4 1 (1.28%) Confluence
Applications
1 1 (1.28%) Microsoft Excel
1 1 (1.28%) Microsoft Office
Business Applications
1 2 (2.56%) Dynamics CRM
Cloud Services
1 24 (30.77%) GitHub
2 4 (5.13%) Amazon AWS
3 3 (3.85%) Microsoft Azure
4 2 (2.56%) Dynamics 365
5 1 (1.28%) SaaS
Communications & Networking
1 11 (14.10%) LAN
1 11 (14.10%) VPN
1 11 (14.10%) WAN
Database & Business Intelligence
1 29 (37.18%) Apache Hive
1 29 (37.18%) Big Data
2 28 (35.90%) HBase
2 28 (35.90%) SQL Server
3 27 (34.62%) SQL Server Integration Services
4 26 (33.33%) Hadoop
4 26 (33.33%) Impala
4 26 (33.33%) Sqoop
5 16 (20.51%) NoSQL
6 15 (19.23%) Data Warehouse
6 15 (19.23%) SQL Server 2008
7 11 (14.10%) QlikView
8 8 (10.26%) SQL Server 2012
8 8 (10.26%) SQL Server Analysis Services
8 8 (10.26%) SQL Server Reporting Services
9 6 (7.69%) Microsoft Analysis Services
9 6 (7.69%) MOLAP
9 6 (7.69%) Relational Database
9 6 (7.69%) ROLAP
9 6 (7.69%) SQL Server 2014
Development Applications
1 13 (16.67%) Git (software)
1 13 (16.67%) Talend Open Studio
2 9 (11.54%) Octopus Deploy
3 6 (7.69%) JIRA
4 1 (1.28%) JMeter
4 1 (1.28%) LoadRunner
4 1 (1.28%) Oracle Forms
4 1 (1.28%) ProC
General
1 17 (21.79%) Finance
2 4 (5.13%) Electronics
2 4 (5.13%) Manufacturing
2 4 (5.13%) Marketing
2 4 (5.13%) Telecoms
Job Titles
1 39 (50.00%) Developer
2 18 (23.08%) SQL Developer
3 16 (20.51%) Data Engineer
4 14 (17.95%) DevOps Engineer
5 12 (15.38%) ETL Developer
6 10 (12.82%) Senior Developer
7 9 (11.54%) Senior Data Engineer
7 9 (11.54%) Senior SQL Developer
8 7 (8.97%) SSAS Developer
9 6 (7.69%) SSIS Developer
10 4 (5.13%) Business Intelligence Developer
10 4 (5.13%) Pentaho Developer
11 3 (3.85%) .NET Developer
11 3 (3.85%) SQL Server Developer
12 2 (2.56%) Analyst
12 2 (2.56%) Analyst Developer
12 2 (2.56%) Integration Engineer
12 2 (2.56%) Project Manager
12 2 (2.56%) Senior Integration Engineer
12 2 (2.56%) Test Leader
Libraries, Frameworks & Software Standards
1 27 (34.62%) Kafka
2 26 (33.33%) Spark Streaming
3 13 (16.67%) Sensu
4 6 (7.69%) MDX
5 4 (5.13%) .NET
6 1 (1.28%) .NET Core
6 1 (1.28%) ASP.NET Web API
6 1 (1.28%) JSON
6 1 (1.28%) Web Services
6 1 (1.28%) WinForms
Miscellaneous
1 9 (11.54%) Analytical Skills
2 1 (1.28%) NHS
2 1 (1.28%) Replication
Operating Systems
1 14 (17.95%) Linux
2 7 (8.97%) Unix
3 1 (1.28%) Windows
Processes & Methodologies
1 29 (37.18%) Continuous Integration
2 27 (34.62%) DevOps
3 26 (33.33%) MapReduce
4 22 (28.21%) Agile Software Development
4 22 (28.21%) Data Modelling
5 18 (23.08%) Performance Tuning
6 17 (21.79%) Open Source
7 13 (16.67%) Business Intelligence
7 13 (16.67%) Configuration Management
7 13 (16.67%) Disaster Recovery
8 12 (15.38%) Analytics
9 11 (14.10%) Big Data Analytics
9 11 (14.10%) Data Analytics
9 11 (14.10%) Information Security
10 10 (12.82%) Data Integration
11 9 (11.54%) Analytical Thinking
11 9 (11.54%) Reverse Engineering
12 8 (10.26%) Collaborative Working
12 8 (10.26%) Data Analysis
12 8 (10.26%) ETL Development
Programming Languages
1 51 (65.38%) SQL
2 32 (41.03%) Shell Script
3 29 (37.18%) Python
4 11 (14.10%) Java
4 11 (14.10%) Scala
4 11 (14.10%) T-SQL
5 6 (7.69%) PL/SQL
6 2 (2.56%) R
7 1 (1.28%) ANSI SQL
7 1 (1.28%) C#
7 1 (1.28%) PROC SQL
7 1 (1.28%) SAS Macro
7 1 (1.28%) VBA
Qualifications
1 18 (23.08%) Security Cleared
2 16 (20.51%) SC Cleared
3 9 (11.54%) MCITP
3 9 (11.54%) MCSE
3 9 (11.54%) Microsoft Certification
4 4 (5.13%) DV Cleared
5 2 (2.56%) ISTQB
6 1 (1.28%) Degree
6 1 (1.28%) Master's Degree
Quality Assurance & Compliance
1 11 (14.10%) QA
2 7 (8.97%) Data Quality
System Software
1 26 (33.33%) Apache Flume
2 1 (1.28%) Docker
Systems Management
1 20 (25.64%) Ansible
2 13 (16.67%) Prometheus
Vendors
1 28 (35.90%) Microsoft
2 19 (24.36%) Informatica
3 13 (16.67%) Talend
4 9 (11.54%) RedGate
5 6 (7.69%) SAP
6 5 (6.41%) Oracle
7 2 (2.56%) Netezza
7 2 (2.56%) Tableau
8 1 (1.28%) Capita
8 1 (1.28%) IBM
8 1 (1.28%) Logi
8 1 (1.28%) Logi Analytics