Period
to 16 February 2019

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 16 February 2019 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
16 Feb 2019
Same period 2018 Same period 2017
Rank 58 77 71
Rank change year-on-year +19 -6 +12
Contract jobs citing ETL 108 89 92
As % of all contract IT jobs advertised in West Yorkshire 3.31% 2.76% 3.05%
As % of the Processes & Methodologies category 3.81% 3.21% 3.54%
Number of daily rates quoted 75 69 58
West Yorkshire median daily rate £375 £400 £363
Median daily rate % change year-on-year -6.25% +10.34% -14.71%
10th Percentile £322 £259 £310
90th Percentile £456 £538 £500
Yorkshire median daily rate £375 £394 £363
% change year-on-year -4.76% +8.62% -14.71%
Number of hourly rates quoted 6 0 2
West Yorkshire median hourly rate £20.25 - £21.88
10th Percentile £17.21 - £17.56
90th Percentile £21.10 - £24.86
Yorkshire median hourly rate £20.25 - £25.39

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 2,837 2,775 2,602
As % of all contract IT jobs advertised in West Yorkshire 86.89% 85.97% 86.16%
Number of daily rates quoted 1,934 1,881 1,667
West Yorkshire median daily rate £420 £400 £400
Median daily rate % change year-on-year +5.00% - +2.56%
10th Percentile £300 £263 £263
90th Percentile £574 £550 £550
Yorkshire median daily rate £425 £400 £400
% change year-on-year +6.25% - +2.56%
Number of hourly rates quoted 72 78 66
West Yorkshire median hourly rate £17.25 £16.00 £14.57
Median hourly rate % change year-on-year +7.81% +9.85% -5.14%
10th Percentile £10.79 £9.81 £9.96
90th Percentile £34.88 £40.00 £30.38
Yorkshire median hourly rate £17.00 £17.50 £15.00
% change year-on-year -2.86% +16.67% -

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 16 February 2019.

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 16 February 2019. 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 -1 65 £375 -6.25% 15
Bradford - 30 £350 - 5
Bingley - 6 £388 -
Halifax -4 2 - -
Wakefield 0 1 £375 -21.05%
ETL
Yorkshire

For the 6 months to 16 February 2019, 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 78 (72.22%) SQL
2 68 (62.96%) SQL Server
3 62 (57.41%) SQL Server Integration Services
4 58 (53.70%) Data Warehouse
5 57 (52.78%) SQL Server Reporting Services
6 45 (41.67%) Business Intelligence
7 39 (36.11%) Power BI
8 36 (33.33%) T-SQL
9 35 (32.41%) Migration
10 31 (28.70%) Data Migration
11 23 (21.30%) ETL Development
12 22 (20.37%) SQL Server Analysis Services
13 20 (18.52%) Tableau
14 19 (17.59%) Analytical Skills
14 19 (17.59%) Agile Software Development
14 19 (17.59%) Microsoft
15 18 (16.67%) Finance
16 16 (14.81%) Analytics
17 15 (13.89%) Data Quality
17 15 (13.89%) C#
17 15 (13.89%) Data Modelling
17 15 (13.89%) Data Integration
18 14 (12.96%) SQL Server 2014
19 13 (12.04%) Data Analysis
20 11 (10.19%) Visualisation
21 10 (9.26%) Visual Studio
21 10 (9.26%) Validation
22 9 (8.33%) Python
22 9 (8.33%) Data Lake
22 9 (8.33%) Microsoft Azure

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 5 (4.63%) SAS
2 3 (2.78%) Confluence
3 1 (0.93%) Apache Spark
Applications
1 8 (7.41%) Microsoft Excel
2 6 (5.56%) Spreadsheet
3 1 (0.93%) Microsoft PowerPoint
Business Applications
1 1 (0.93%) Dynamics AX
Cloud Services
1 9 (8.33%) Microsoft Azure
2 8 (7.41%) Amazon AWS
3 3 (2.78%) AWS Lambda
3 3 (2.78%) Serverless
4 2 (1.85%) Amazon CloudWatch
4 2 (1.85%) Amazon EC2
4 2 (1.85%) Amazon Kinesis
4 2 (1.85%) Amazon S3
4 2 (1.85%) Amazon SageMaker
4 2 (1.85%) AWS CloudTrail
4 2 (1.85%) Dynamics 365
4 2 (1.85%) Virtual Private Cloud
Database & Business Intelligence
1 68 (62.96%) SQL Server
2 62 (57.41%) SQL Server Integration Services
3 58 (53.70%) Data Warehouse
4 57 (52.78%) SQL Server Reporting Services
5 39 (36.11%) Power BI
6 22 (20.37%) SQL Server Analysis Services
7 14 (12.96%) SQL Server 2014
8 9 (8.33%) Data Lake
9 7 (6.48%) Hadoop
9 7 (6.48%) SQL Server 2016
10 6 (5.56%) DataStage
10 6 (5.56%) MongoDB
10 6 (5.56%) Relational Database
11 5 (4.63%) QlikView
11 5 (4.63%) SQL Server 2008
12 4 (3.70%) Azure SQL Data Warehouse
12 4 (3.70%) Azure SQL Database
12 4 (3.70%) SAS Enterprise Guide
13 3 (2.78%) Snowflake Schema
13 3 (2.78%) Star Schema
Development Applications
1 10 (9.26%) Visual Studio
2 8 (7.41%) Team Foundation Server
3 5 (4.63%) Git (software)
4 4 (3.70%) Octopus Deploy
5 3 (2.78%) JIRA
6 1 (0.93%) ERwin
6 1 (0.93%) Hudson
6 1 (0.93%) MSTest
6 1 (0.93%) TeamCity
General
1 18 (16.67%) Finance
2 4 (3.70%) Banking
3 3 (2.78%) Back Office
3 3 (2.78%) Games
4 2 (1.85%) Retail
Job Titles
1 77 (71.30%) Developer
2 37 (34.26%) SQL Developer
3 20 (18.52%) Business Intelligence Developer
4 19 (17.59%) Analyst
5 14 (12.96%) ETL Developer
6 10 (9.26%) SQL BI Developer
7 8 (7.41%) SSIS Developer
8 7 (6.48%) Data Warehouse Developer
9 6 (5.56%) ETL Analyst
9 6 (5.56%) Test Analyst
10 5 (4.63%) Business Developer
10 5 (4.63%) Data Engineer
10 5 (4.63%) SQL Analyst
11 4 (3.70%) Data Analyst
11 4 (3.70%) Data Warehouse Analyst
11 4 (3.70%) Database Developer
11 4 (3.70%) DBA
11 4 (3.70%) Information Analyst
11 4 (3.70%) Senior Developer
11 4 (3.70%) SQL DBA
Libraries, Frameworks & Software Standards
1 8 (7.41%) .NET
2 4 (3.70%) .NET Framework
2 4 (3.70%) WCF
2 4 (3.70%) Web Services
3 3 (2.78%) .NET Core
3 3 (2.78%) AngularJS
3 3 (2.78%) RxJS
4 2 (1.85%) MDX
4 2 (1.85%) Pandas
5 1 (0.93%) HTML
5 1 (0.93%) J2EE
5 1 (0.93%) Kafka
5 1 (0.93%) NumPy
5 1 (0.93%) PySpark
Miscellaneous
1 19 (17.59%) Analytical Skills
2 5 (4.63%) Greenfield Project
2 5 (4.63%) Mainframe
3 3 (2.78%) Management Information System
4 2 (1.85%) Data Structures
4 2 (1.85%) NHS
4 2 (1.85%) VSAM
5 1 (0.93%) Algorithms
Operating Systems
1 8 (7.41%) Unix
2 1 (0.93%) Linux
Processes & Methodologies
1 45 (41.67%) Business Intelligence
2 35 (32.41%) Migration
3 31 (28.70%) Data Migration
4 23 (21.30%) ETL Development
5 19 (17.59%) Agile Software Development
6 16 (14.81%) Analytics
7 15 (13.89%) Data Integration
7 15 (13.89%) Data Modelling
8 13 (12.04%) Data Analysis
9 11 (10.19%) Visualisation
10 10 (9.26%) Validation
11 8 (7.41%) Data Management
11 8 (7.41%) Data Visualisation
12 7 (6.48%) Data Mapping
12 7 (6.48%) Software Engineering
13 6 (5.56%) Change Data Capture
13 6 (5.56%) Data Validation
13 6 (5.56%) Performance Tuning
13 6 (5.56%) Stakeholder Management
13 6 (5.56%) Waterfall
Programming Languages
1 78 (72.22%) SQL
2 36 (33.33%) T-SQL
3 15 (13.89%) C#
4 9 (8.33%) Python
5 5 (4.63%) VBA
6 4 (3.70%) COBOL
6 4 (3.70%) PowerShell
7 3 (2.78%) Java
7 3 (2.78%) PL/SQL
7 3 (2.78%) TypeScript
8 2 (1.85%) JavaScript
8 2 (1.85%) Ruby
8 2 (1.85%) Scala
8 2 (1.85%) Shell Script
9 1 (0.93%) Data Analysis Expressions (DAX)
9 1 (0.93%) R
Qualifications
1 4 (3.70%) MCSE
1 4 (3.70%) Microsoft Certification
2 3 (2.78%) MCITP
2 3 (2.78%) PMP
3 2 (1.85%) AWS Certification
3 2 (1.85%) Degree
4 1 (0.93%) MCSA
Quality Assurance & Compliance
1 15 (13.89%) Data Quality
2 2 (1.85%) QA
3 1 (0.93%) PMO
3 1 (0.93%) SLA
System Software
1 2 (1.85%) Docker
Vendors
1 20 (18.52%) Tableau
2 19 (17.59%) Microsoft
3 5 (4.63%) SAP
4 4 (3.70%) IBM
4 4 (3.70%) RedGate
5 3 (2.78%) Hortonworks
6 1 (0.93%) Cloudera
6 1 (0.93%) Databricks
6 1 (0.93%) MapR
6 1 (0.93%) Oracle
6 1 (0.93%) Teradata
6 1 (0.93%) Twitter