Period
to 22 October 2017

The following table provides summary statistics for contract job vacancies advertised in West 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 October 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 > West Yorkshire
6 months to
22 Oct 2017
Same period 2016 Same period 2015
Rank 60 75 57
Rank change year-on-year +15 -18 +2
Contract jobs citing ETL 97 107 149
As % of all contract IT jobs advertised in West Yorkshire 3.32% 2.84% 3.39%
As % of the Processes & Methodologies category 3.90% 3.29% 3.99%
Number of daily rates quoted 72 68 143
West Yorkshire median daily rate £425 £385 £400
Median daily rate % change year-on-year +10.39% -3.75% +23.08%
10th Percentile £325 £312 £276
90th Percentile £486 £471 £600
Yorkshire median daily rate £425 £375 £400
% change year-on-year +13.33% -6.25% +14.29%
Number of hourly rates quoted 0 1 0
West Yorkshire median hourly rate - £18.38 -
Yorkshire median hourly rate £35.00 £34.19 -
% change year-on-year +2.38% - -

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

All Process and Methodology Skills
West Yorkshire
Contract vacancies with a requirement for process or methodology skills 2486 3256 3737
As % of all contract IT jobs advertised in West Yorkshire 85.11% 86.53% 85.11%
Number of daily rates quoted 1718 2151 2604
West Yorkshire median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.67% +7.14%
10th Percentile £270 £275 £263
90th Percentile £545 £550 £525
Yorkshire median daily rate £400 £400 £375
% change year-on-year - +6.67% +7.14%
Number of hourly rates quoted 54 57 97
West Yorkshire median hourly rate £14.20 £14.50 £15.00
Median hourly rate % change year-on-year -2.07% -3.33% +10.72%
10th Percentile £8.55 £10.20 £9.25
90th Percentile £26.25 £31.05 £38.30
Yorkshire median hourly rate £14.35 £14.81 £14.50
% change year-on-year -3.09% +2.12% -

ETL
Job Vacancy Trend in West Yorkshire

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

Job vacancy trend for ETL in West Yorkshire

ETL
Contractor Daily Rate Trend in West Yorkshire

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

Contractor daily rate trend for ETL in West Yorkshire

ETL
Contractor Daily Rate Histogram in West Yorkshire

The daily rate distribution of IT jobs citing ETL in West Yorkshire over the 6 months to 22 October 2017.

Contractor daily rate histogram for ETL in West Yorkshire

ETL
Contractor Hourly Rate Trend in West Yorkshire

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

Contractor hourly rate trend for ETL in West Yorkshire

ETL
Contract Job Locations in West 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 West Yorkshire region over the 6 months to 22 October 2017. 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
Leeds +40 85 £425 +13.33% 11
Bradford -15 2 - - 1
Halifax +4 1 £475 +26.67%
ETL
Yorkshire

For the 6 months to 22 October 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 West Yorkshire region with a requirement for ETL.

1 63 (64.95%) SQL
2 39 (40.21%) Shell Script
3 37 (38.14%) SQL Server
4 35 (36.08%) Microsoft
5 34 (35.05%) Data Modelling
6 32 (32.99%) Continuous Integration
7 30 (30.93%) Python
7 30 (30.93%) Apache Hive
7 30 (30.93%) Big Data
7 30 (30.93%) DevOps
8 29 (29.90%) Apache Spark
8 29 (29.90%) HBase
8 29 (29.90%) SQL Server Integration Services
8 29 (29.90%) Agile Software Development
9 28 (28.87%) Kafka
10 27 (27.84%) Apache Flume
10 27 (27.84%) Sqoop
10 27 (27.84%) MapReduce
10 27 (27.84%) Hadoop
10 27 (27.84%) Spark Streaming
10 27 (27.84%) Impala
11 26 (26.80%) Data Warehouse
12 25 (25.77%) GitHub
13 21 (21.65%) Ansible
13 21 (21.65%) Business Intelligence
14 20 (20.62%) Security Cleared
15 19 (19.59%) Informatica
15 19 (19.59%) Data Integration
16 18 (18.56%) Open Source
17 17 (17.53%) SC Cleared

ETL
Co-occurring IT Skills in West 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 29 (29.90%) Apache Spark
2 11 (11.34%) OpenStack
3 6 (6.19%) SAS
4 1 (1.03%) Apache
4 1 (1.03%) Confluence
4 1 (1.03%) WebSphere
Applications
1 1 (1.03%) Microsoft Excel
1 1 (1.03%) Microsoft Office
Business Applications
1 2 (2.06%) Dynamics CRM
Cloud Services
1 25 (25.77%) GitHub
2 5 (5.15%) Microsoft Azure
3 4 (4.12%) Amazon AWS
4 3 (3.09%) SaaS
5 2 (2.06%) Dynamics 365
Communications & Networking
1 12 (12.37%) LAN
1 12 (12.37%) VPN
1 12 (12.37%) WAN
Database & Business Intelligence
1 37 (38.14%) SQL Server
2 30 (30.93%) Apache Hive
2 30 (30.93%) Big Data
3 29 (29.90%) HBase
3 29 (29.90%) SQL Server Integration Services
4 27 (27.84%) Hadoop
4 27 (27.84%) Impala
4 27 (27.84%) Sqoop
5 26 (26.80%) Data Warehouse
6 16 (16.49%) NoSQL
7 12 (12.37%) Relational Database
8 11 (11.34%) SQL Server Analysis Services
8 11 (11.34%) SQL Server Reporting Services
9 10 (10.31%) SQL Server 2008
10 9 (9.28%) OLAP
11 7 (7.22%) Microsoft Analysis Services
11 7 (7.22%) MOLAP
11 7 (7.22%) QlikView
11 7 (7.22%) ROLAP
11 7 (7.22%) Star Schema
Development Applications
1 14 (14.43%) Git (software)
2 13 (13.40%) Talend Open Studio
3 7 (7.22%) JIRA
4 5 (5.15%) Octopus Deploy
5 3 (3.09%) SQL Server Management Studio (SSMS)
5 3 (3.09%) Visual Studio
6 1 (1.03%) Eclipse
6 1 (1.03%) JMeter
6 1 (1.03%) JUnit
6 1 (1.03%) LoadRunner
6 1 (1.03%) Oracle Forms
6 1 (1.03%) ProC
General
1 14 (14.43%) Finance
2 4 (4.12%) Electronics
2 4 (4.12%) Manufacturing
2 4 (4.12%) Marketing
2 4 (4.12%) Telecoms
Job Titles
1 43 (44.33%) Developer
2 16 (16.49%) Data Engineer
3 15 (15.46%) DevOps Engineer
4 13 (13.40%) ETL Developer
4 13 (13.40%) SQL Developer
5 9 (9.28%) Senior Data Engineer
6 8 (8.25%) SSAS Developer
7 7 (7.22%) SSIS Developer
8 6 (6.19%) Business Intelligence Developer
8 6 (6.19%) Senior Developer
9 5 (5.15%) Pentaho Developer
9 5 (5.15%) Senior SQL Developer
10 4 (4.12%) Consultant
10 4 (4.12%) DataStage Consultant
10 4 (4.12%) Tester
11 3 (3.09%) .NET Developer
11 3 (3.09%) Analyst
11 3 (3.09%) Data Migration Developer
11 3 (3.09%) Data Migration Lead
11 3 (3.09%) Technical Leader
Libraries, Frameworks & Software Standards
1 28 (28.87%) Kafka
2 27 (27.84%) Spark Streaming
3 14 (14.43%) Sensu
4 7 (7.22%) MDX
5 6 (6.19%) .NET
6 4 (4.12%) XML
7 3 (3.09%) .NET Core
8 1 (1.03%) ASP.NET Web API
8 1 (1.03%) CPAN
8 1 (1.03%) Hibernate
8 1 (1.03%) iBATIS
8 1 (1.03%) J2EE
8 1 (1.03%) Java EE
8 1 (1.03%) JSON
8 1 (1.03%) Spring
8 1 (1.03%) Web Services
8 1 (1.03%) WinForms
Miscellaneous
1 6 (6.19%) Analytical Skills
2 1 (1.03%) Management Information System
2 1 (1.03%) NHS
2 1 (1.03%) Replication
Operating Systems
1 16 (16.49%) Linux
2 8 (8.25%) Unix
Processes & Methodologies
1 34 (35.05%) Data Modelling
2 32 (32.99%) Continuous Integration
3 30 (30.93%) DevOps
4 29 (29.90%) Agile Software Development
5 27 (27.84%) MapReduce
6 21 (21.65%) Business Intelligence
7 19 (19.59%) Data Integration
8 18 (18.56%) Open Source
9 16 (16.49%) Performance Tuning
10 15 (15.46%) Analytics
11 14 (14.43%) Configuration Management
11 14 (14.43%) Disaster Recovery
12 13 (13.40%) Data Analytics
12 13 (13.40%) Migration
13 12 (12.37%) Big Data Analytics
13 12 (12.37%) Information Security
14 11 (11.34%) Data Analysis
15 9 (9.28%) Data Migration
15 9 (9.28%) Data Reconciliation
15 9 (9.28%) Reverse Engineering
Programming Languages
1 63 (64.95%) SQL
2 39 (40.21%) Shell Script
3 30 (30.93%) Python
4 15 (15.46%) T-SQL
5 13 (13.40%) Java
6 11 (11.34%) Scala
7 7 (7.22%) PL/SQL
8 2 (2.06%) R
9 1 (1.03%) ANSI SQL
9 1 (1.03%) C#
9 1 (1.03%) Perl
9 1 (1.03%) PROC SQL
9 1 (1.03%) SAS Macro
9 1 (1.03%) VBA
Qualifications
1 20 (20.62%) Security Cleared
2 17 (17.53%) SC Cleared
3 5 (5.15%) MCITP
3 5 (5.15%) MCSE
3 5 (5.15%) Microsoft Certification
4 4 (4.12%) DV Cleared
4 4 (4.12%) ISEB
5 2 (2.06%) ISTQB
6 1 (1.03%) Degree
6 1 (1.03%) Master's Degree
Quality Assurance & Compliance
1 13 (13.40%) QA
2 12 (12.37%) Data Quality
System Software
1 27 (27.84%) Apache Flume
2 3 (3.09%) Docker
Systems Management
1 21 (21.65%) Ansible
2 14 (14.43%) Prometheus
Vendors
1 35 (36.08%) Microsoft
2 19 (19.59%) Informatica
3 13 (13.40%) Talend
4 10 (10.31%) SAP
5 9 (9.28%) Oracle
6 5 (5.15%) RedGate
7 3 (3.09%) IBM
8 2 (2.06%) Netezza
8 2 (2.06%) Tableau
9 1 (1.03%) Capita
9 1 (1.03%) Logi
9 1 (1.03%) Logi Analytics