Period
to 18 November 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 18 November 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
18 Nov 2018
Same period 2017 Same period 2016
Rank 57 75 67
Rank change year-on-year +18 -8 -1
Contract jobs citing ETL 123 91 119
As % of all contract IT jobs advertised in West Yorkshire 3.64% 3.03% 3.28%
As % of the Processes & Methodologies category 4.16% 3.49% 3.74%
Number of daily rates quoted 80 71 80
West Yorkshire median daily rate £364 £425 £395
Median daily rate % change year-on-year -14.41% +7.59% +1.28%
10th Percentile £313 £325 £312
90th Percentile £463 £488 £494
Yorkshire median daily rate £388 £425 £388
% change year-on-year -8.82% +9.68% -3.13%
Number of hourly rates quoted 5 0 2
West Yorkshire median hourly rate £20.25 - £21.88
10th Percentile £13.96 - £17.56
90th Percentile £21.10 - £24.86
Yorkshire median hourly rate £33.00 £35.00 £25.39
% change year-on-year -5.71% +37.85% -

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,960 2,605 3,186
As % of all contract IT jobs advertised in West Yorkshire 87.52% 86.86% 87.72%
Number of daily rates quoted 2,018 1,802 2,089
West Yorkshire median daily rate £413 £400 £400
Median daily rate % change year-on-year +3.13% - +6.67%
10th Percentile £300 £263 £263
90th Percentile £563 £545 £550
Yorkshire median daily rate £413 £400 £400
% change year-on-year +3.13% - +6.67%
Number of hourly rates quoted 68 67 65
West Yorkshire median hourly rate £17.00 £14.50 £14.50
Median hourly rate % change year-on-year +17.24% - -3.33%
10th Percentile £11.23 £9.25 £10.20
90th Percentile £33.75 £35.05 £30.25
Yorkshire median hourly rate £17.00 £15.00 £14.75
% change year-on-year +13.33% +1.69% +1.72%

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 18 November 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 18 November 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 -8 71 £413 -2.94% 17
Bradford +6 24 £350 - 4
Halifax +4 6 £290 -38.95% 4
Bingley - 6 £388 - 2
Wakefield - 2 £475 -
ETL
Yorkshire

For the 6 months to 18 November 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 91 (73.98%) SQL
2 69 (56.10%) Data Warehouse
3 67 (54.47%) SQL Server
4 63 (51.22%) SQL Server Integration Services
5 51 (41.46%) SQL Server Reporting Services
6 49 (39.84%) Business Intelligence
7 39 (31.71%) T-SQL
8 33 (26.83%) Migration
9 31 (25.20%) Data Migration
10 27 (21.95%) ETL Development
10 27 (21.95%) Agile Software Development
11 26 (21.14%) Finance
12 25 (20.33%) Microsoft
12 25 (20.33%) Power BI
13 22 (17.89%) Analytical Skills
14 19 (15.45%) SQL Server Analysis Services
14 19 (15.45%) Data Modelling
15 17 (13.82%) C#
15 17 (13.82%) Analytics
16 15 (12.20%) Relational Database
17 13 (10.57%) SQL Server 2016
17 13 (10.57%) Data Mapping
17 13 (10.57%) Data Quality
18 12 (9.76%) Data Integration
18 12 (9.76%) Amazon AWS
18 12 (9.76%) Unix
18 12 (9.76%) Problem-Solving
19 10 (8.13%) Python
19 10 (8.13%) QA
19 10 (8.13%) Data Management

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 6 (4.88%) SAS
2 3 (2.44%) Confluence
3 1 (0.81%) SharePoint
Applications
1 9 (7.32%) Microsoft Excel
2 5 (4.07%) Spreadsheet
3 2 (1.63%) Microsoft Office
3 2 (1.63%) Microsoft PowerPoint
Business Applications
1 2 (1.63%) Cognos Business Intelligence
1 2 (1.63%) Dynamics CRM
2 1 (0.81%) Cognos TM1
Cloud Services
1 12 (9.76%) Amazon AWS
2 8 (6.50%) Microsoft Azure
3 6 (4.88%) Amazon S3
3 6 (4.88%) Virtual Private Cloud
4 5 (4.07%) Amazon EC2
5 3 (2.44%) Amazon EMR
5 3 (2.44%) Amazon Glacier
5 3 (2.44%) AWS Lambda
5 3 (2.44%) Dynamics 365
5 3 (2.44%) Serverless
6 2 (1.63%) Amazon CloudWatch
6 2 (1.63%) Amazon Kinesis
6 2 (1.63%) Amazon SageMaker
6 2 (1.63%) AWS CloudTrail
Database & Business Intelligence
1 69 (56.10%) Data Warehouse
2 67 (54.47%) SQL Server
3 63 (51.22%) SQL Server Integration Services
4 51 (41.46%) SQL Server Reporting Services
5 25 (20.33%) Power BI
6 19 (15.45%) SQL Server Analysis Services
7 15 (12.20%) Relational Database
8 13 (10.57%) SQL Server 2016
9 8 (6.50%) Data Lake
9 8 (6.50%) DataStage
9 8 (6.50%) Hadoop
10 7 (5.69%) SQL Server 2008
10 7 (5.69%) SQL Server 2014
11 6 (4.88%) Amazon Redshift
11 6 (4.88%) MongoDB
12 5 (4.07%) Amazon Aurora
12 5 (4.07%) Data Mart
12 5 (4.07%) NoSQL
12 5 (4.07%) SSDT
13 4 (3.25%) QlikView
Development Applications
1 7 (5.69%) JIRA
2 6 (4.88%) Octopus Deploy
3 4 (3.25%) Team Foundation Server
3 4 (3.25%) Visual Studio
4 3 (2.44%) Git (software)
4 3 (2.44%) TeamCity
5 2 (1.63%) SpecFlow
6 1 (0.81%) Toad
General
1 26 (21.14%) Finance
2 7 (5.69%) Banking
3 3 (2.44%) Back Office
4 2 (1.63%) Publishing
4 2 (1.63%) Retail
Job Titles
1 80 (65.04%) Developer
2 41 (33.33%) SQL Developer
3 23 (18.70%) ETL Developer
4 22 (17.89%) Business Intelligence Developer
5 15 (12.20%) Analyst
6 11 (8.94%) SSIS Developer
7 9 (7.32%) SQL BI Developer
8 8 (6.50%) Data Warehouse Developer
9 7 (5.69%) Data Analyst
9 7 (5.69%) SQL Server Developer
10 6 (4.88%) Data Engineer
10 6 (4.88%) ETL Analyst
11 5 (4.07%) Test Analyst
11 5 (4.07%) Tester
12 4 (3.25%) Architect
12 4 (3.25%) Information Analyst
12 4 (3.25%) SAS Developer
12 4 (3.25%) Senior Developer
12 4 (3.25%) Test Engineer
12 4 (3.25%) Test Leader
Libraries, Frameworks & Software Standards
1 7 (5.69%) Web Services
2 3 (2.44%) .NET
2 3 (2.44%) .NET Core
2 3 (2.44%) AngularJS
2 3 (2.44%) Kafka
2 3 (2.44%) RxJS
3 1 (0.81%) HTML
3 1 (0.81%) Pandas
3 1 (0.81%) PySpark
Miscellaneous
1 22 (17.89%) Analytical Skills
2 8 (6.50%) Mainframe
3 4 (3.25%) Greenfield Project
4 3 (2.44%) Data Centre
4 3 (2.44%) Management Information System
5 2 (1.63%) Data Structures
5 2 (1.63%) NHS
5 2 (1.63%) VSAM
6 1 (0.81%) Reference Data
Operating Systems
1 12 (9.76%) Unix
2 8 (6.50%) Linux
3 3 (2.44%) Red Hat Enterprise Linux
4 1 (0.81%) Windows
4 1 (0.81%) Windows Server
4 1 (0.81%) zOS
Processes & Methodologies
1 49 (39.84%) Business Intelligence
2 33 (26.83%) Migration
3 31 (25.20%) Data Migration
4 27 (21.95%) Agile Software Development
4 27 (21.95%) ETL Development
5 19 (15.45%) Data Modelling
6 17 (13.82%) Analytics
7 13 (10.57%) Data Mapping
8 12 (9.76%) Data Integration
8 12 (9.76%) Problem-Solving
9 10 (8.13%) Data Management
9 10 (8.13%) Kimball Methodology
9 10 (8.13%) Scrum
9 10 (8.13%) Test Automation
10 9 (7.32%) Validation
10 9 (7.32%) Visualisation
11 8 (6.50%) Data Visualisation
11 8 (6.50%) Performance Tuning
11 8 (6.50%) Stakeholder Management
12 7 (5.69%) Data Analysis
Programming Languages
1 91 (73.98%) SQL
2 39 (31.71%) T-SQL
3 17 (13.82%) C#
4 10 (8.13%) Python
5 9 (7.32%) Java
5 9 (7.32%) VBA
6 4 (3.25%) COBOL
6 4 (3.25%) Perl
7 3 (2.44%) PL/SQL
7 3 (2.44%) TypeScript
8 2 (1.63%) JavaScript
8 2 (1.63%) Ruby
8 2 (1.63%) Scala
8 2 (1.63%) Shell Script
9 1 (0.81%) PowerShell
9 1 (0.81%) R
9 1 (0.81%) Smalltalk
9 1 (0.81%) VB
Qualifications
1 3 (2.44%) Degree
1 3 (2.44%) MCITP
1 3 (2.44%) MCSE
1 3 (2.44%) Microsoft Certification
2 2 (1.63%) AWS Certification
3 1 (0.81%) Computer Science Degree
3 1 (0.81%) SC Cleared
3 1 (0.81%) Security Cleared
Quality Assurance & Compliance
1 13 (10.57%) Data Quality
2 10 (8.13%) QA
3 3 (2.44%) PCI DSS
4 2 (1.63%) SLA
5 1 (0.81%) PMO
System Software
1 5 (4.07%) Docker
Systems Management
1 3 (2.44%) Control-M
1 3 (2.44%) Opscode Chef
Vendors
1 25 (20.33%) Microsoft
2 9 (7.32%) IBM
3 8 (6.50%) Tableau
4 7 (5.69%) SAP
5 5 (4.07%) Oracle
6 4 (3.25%) RedGate
7 3 (2.44%) Axway
7 3 (2.44%) Hortonworks
7 3 (2.44%) IBM Sterling
7 3 (2.44%) ServiceNow
7 3 (2.44%) Splunk
8 2 (1.63%) Cognos
9 1 (0.81%) Ab Initio
9 1 (0.81%) Alteryx
9 1 (0.81%) BMC
9 1 (0.81%) Cloudera
9 1 (0.81%) Netezza
9 1 (0.81%) VMware