Period
to 23 July 2018

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 23 July 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)
Yorkshire > West Yorkshire
6 months to
23 Jul 2018
Same period 2017 Same period 2016
Rank 74 70 84
Rank change year-on-year -4 +14 -27
Contract jobs citing ETL 111 80 99
As % of all contract IT jobs advertised in West Yorkshire 3.24% 2.81% 2.44%
As % of the Processes & Methodologies category 3.64% 3.21% 2.79%
Number of daily rates quoted 76 46 77
West Yorkshire median daily rate £384 £413 £400
Median daily rate % change year-on-year -6.97% +3.13% +3.90%
10th Percentile £285 £322 £306
90th Percentile £525 £524 £475
Yorkshire median daily rate £400 £400 £381
% change year-on-year - +4.92% -0.97%
Number of hourly rates quoted 0 0 0
West Yorkshire median hourly rate - - -
Yorkshire median hourly rate £35.00 £35.00 -

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 3,050 2,489 3,551
As % of all contract IT jobs advertised in West Yorkshire 89.13% 87.58% 87.53%
Number of daily rates quoted 2,085 1,701 2,430
West Yorkshire median daily rate £413 £400 £400
Median daily rate % change year-on-year +3.13% - +12.68%
10th Percentile £300 £288 £286
90th Percentile £538 £550 £569
Yorkshire median daily rate £407 £400 £400
% change year-on-year +1.81% - +14.29%
Number of hourly rates quoted 70 54 53
West Yorkshire median hourly rate £17.50 £13.43 £13.50
Median hourly rate % change year-on-year +30.31% -0.52% -19.26%
10th Percentile £11.13 £8.41 £10.20
90th Percentile £40.10 £28.96 £23.40
Yorkshire median hourly rate £18.99 £13.50 £14.50
% change year-on-year +40.63% -6.90% -6.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 23 July 2018.

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 23 July 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
Leeds -14 79 £405 -1.82% 15
Halifax +13 12 £325 -32.29% 2
Wakefield - 5 £475 -
Bradford -9 3 £355 - 6
Bingley - 1 £325 - 1
ETL
Yorkshire

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

1 56 (50.45%) SQL
2 46 (41.44%) Data Warehouse
3 39 (35.14%) Agile Software Development
4 37 (33.33%) Business Intelligence
5 31 (27.93%) SQL Server Integration Services
6 26 (23.42%) Hadoop
7 23 (20.72%) Finance
8 22 (19.82%) SQL Server
8 22 (19.82%) Migration
9 21 (18.92%) Data Modelling
10 20 (18.02%) Informatica
10 20 (18.02%) Apache Hive
10 20 (18.02%) Kafka
11 19 (17.12%) HBase
11 19 (17.12%) T-SQL
12 18 (16.22%) Talend
12 18 (16.22%) Apache Spark
12 18 (16.22%) MapReduce
12 18 (16.22%) Data Migration
13 17 (15.32%) Big Data
13 17 (15.32%) ETL Development
14 15 (13.51%) Relational Database
14 15 (13.51%) Pentaho
15 14 (12.61%) SQL Server Reporting Services
15 14 (12.61%) Banking
15 14 (12.61%) Spark Streaming
16 13 (11.71%) Python
16 13 (11.71%) NoSQL
17 12 (10.81%) Amazon AWS
17 12 (10.81%) Analytical Skills

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 18 (16.22%) Apache Spark
2 7 (6.31%) SAS
3 3 (2.70%) Confluence
4 1 (0.90%) SharePoint
4 1 (0.90%) WebSphere
Applications
1 4 (3.60%) Microsoft Excel
2 3 (2.70%) Microsoft Office
3 1 (0.90%) Microsoft PowerPoint
Business Applications
1 5 (4.50%) Cognos Business Intelligence
2 4 (3.60%) Cognos TM1
Cloud Services
1 12 (10.81%) Amazon AWS
2 9 (8.11%) Amazon S3
3 7 (6.31%) GitHub
4 4 (3.60%) Virtual Private Cloud
5 3 (2.70%) Amazon EC2
5 3 (2.70%) Amazon EMR
5 3 (2.70%) Amazon Glacier
6 1 (0.90%) Cloud Computing
6 1 (0.90%) Microsoft Azure
Communications & Networking
1 6 (5.41%) DSL
Database & Business Intelligence
1 46 (41.44%) Data Warehouse
2 31 (27.93%) SQL Server Integration Services
3 26 (23.42%) Hadoop
4 22 (19.82%) SQL Server
5 20 (18.02%) Apache Hive
6 19 (17.12%) HBase
7 17 (15.32%) Big Data
8 15 (13.51%) Pentaho
8 15 (13.51%) Relational Database
9 14 (12.61%) SQL Server Reporting Services
10 13 (11.71%) NoSQL
11 9 (8.11%) SQL Server Analysis Services
12 8 (7.21%) Amazon Aurora
12 8 (7.21%) Impala
12 8 (7.21%) Sqoop
13 7 (6.31%) SQL Server 2016
14 6 (5.41%) DataStage
15 5 (4.50%) Cognos Framework Manager
15 5 (4.50%) Cognos Report Studio
15 5 (4.50%) OLAP
Development Applications
1 6 (5.41%) JIRA
1 6 (5.41%) Visual Studio
2 3 (2.70%) Team Foundation Server
3 2 (1.80%) Git (software)
4 1 (0.90%) Gerrit
4 1 (0.90%) IBM UrbanCode
4 1 (0.90%) Jenkins
4 1 (0.90%) Octopus Deploy
4 1 (0.90%) SpecFlow
4 1 (0.90%) SQL Server Management Studio (SSMS)
4 1 (0.90%) TeamCity
4 1 (0.90%) Toad
General
1 23 (20.72%) Finance
2 14 (12.61%) Banking
3 2 (1.80%) Games
3 2 (1.80%) Publishing
3 2 (1.80%) Retail
4 1 (0.90%) Billing
4 1 (0.90%) Investment Banking
4 1 (0.90%) Telecoms
Job Titles
1 46 (41.44%) Developer
2 25 (22.52%) Data Engineer
3 17 (15.32%) Business Intelligence Developer
3 17 (15.32%) ETL Developer
4 13 (11.71%) Analyst
5 12 (10.81%) SQL Developer
6 8 (7.21%) Cognos Developer
7 6 (5.41%) Cognos BI Developer
7 6 (5.41%) Data Analyst
7 6 (5.41%) Test Engineer
8 4 (3.60%) .NET Software Engineer
8 4 (3.60%) Big Data Engineer
8 4 (3.60%) C# Software Engineer
8 4 (3.60%) ETL Analyst
8 4 (3.60%) Report Analyst
8 4 (3.60%) Software Engineer
8 4 (3.60%) SQL Analyst
8 4 (3.60%) Test Analyst
8 4 (3.60%) Test Leader
9 3 (2.70%) Tester
Libraries, Frameworks & Software Standards
1 20 (18.02%) Kafka
2 14 (12.61%) Spark Streaming
3 4 (3.60%) .NET
3 4 (3.60%) .NET Framework
3 4 (3.60%) WCF
4 3 (2.70%) ODBC
4 3 (2.70%) RESTful
4 3 (2.70%) Web Services
5 1 (0.90%) XML
Miscellaneous
1 12 (10.81%) Analytical Skills
2 6 (5.41%) Mainframe
3 3 (2.70%) Data Centre
3 3 (2.70%) Data Structures
3 3 (2.70%) Greenfield Project
3 3 (2.70%) Management Information System
3 3 (2.70%) NHS
4 2 (1.80%) Reference Data
5 1 (0.90%) Enterprise Software
Operating Systems
1 8 (7.21%) Unix
2 5 (4.50%) Linux
3 3 (2.70%) Red Hat Enterprise Linux
4 1 (0.90%) Windows
4 1 (0.90%) Windows Server
4 1 (0.90%) zOS
Processes & Methodologies
1 39 (35.14%) Agile Software Development
2 37 (33.33%) Business Intelligence
3 22 (19.82%) Migration
4 21 (18.92%) Data Modelling
5 18 (16.22%) Data Migration
5 18 (16.22%) MapReduce
6 17 (15.32%) ETL Development
7 11 (9.91%) Continuous Integration
7 11 (9.91%) Scrum
7 11 (9.91%) Test Automation
8 10 (9.01%) Analytics
9 9 (8.11%) Continuous Improvement
9 9 (8.11%) DevOps
9 9 (8.11%) Problem-Solving
10 8 (7.21%) Data Mapping
11 7 (6.31%) BDD
11 7 (6.31%) Reverse Engineering
11 7 (6.31%) Security Testing
11 7 (6.31%) Software Engineering
11 7 (6.31%) TDD
Programming Languages
1 56 (50.45%) SQL
2 19 (17.12%) T-SQL
3 13 (11.71%) Python
4 12 (10.81%) Java
5 9 (8.11%) Scala
6 8 (7.21%) C#
7 7 (6.31%) Shell Script
8 6 (5.41%) HiveQL
9 2 (1.80%) COBOL
9 2 (1.80%) Perl
9 2 (1.80%) PL/SQL
9 2 (1.80%) Ruby
9 2 (1.80%) VBA
10 1 (0.90%) R
10 1 (0.90%) Smalltalk
10 1 (0.90%) VB
Qualifications
1 9 (8.11%) Security Cleared
2 8 (7.21%) SC Cleared
3 2 (1.80%) Degree
4 1 (0.90%) BPSS Clearance
4 1 (0.90%) Computer Science Degree
Quality Assurance & Compliance
1 11 (9.91%) QA
2 4 (3.60%) Data Quality
3 2 (1.80%) GDPR
3 2 (1.80%) PMO
4 1 (0.90%) PCI DSS
4 1 (0.90%) SLA
System Software
1 8 (7.21%) Apache Flume
2 3 (2.70%) Docker
Systems Management
1 7 (6.31%) Ansible
2 3 (2.70%) Opscode Chef
3 1 (0.90%) Control-M
Vendors
1 20 (18.02%) Informatica
2 18 (16.22%) Talend
3 12 (10.81%) Microsoft
4 10 (9.01%) Cognos
4 10 (9.01%) Oracle
5 8 (7.21%) IBM
6 6 (5.41%) Cloudera
7 5 (4.50%) SAP
8 4 (3.60%) Hortonworks
8 4 (3.60%) MuleSoft
8 4 (3.60%) webMethods
9 3 (2.70%) Netezza
9 3 (2.70%) Splunk
10 1 (0.90%) Ab Initio
10 1 (0.90%) Axway
10 1 (0.90%) BMC
10 1 (0.90%) IBM Sterling
10 1 (0.90%) Microgen
10 1 (0.90%) Tableau
10 1 (0.90%) VMware