Period
to 19 September 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 19 September 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
19 Sep 2018
Same period 2017 Same period 2016
Rank 75 65 70
Rank change year-on-year -10 +5 -18
Contract jobs citing ETL 103 90 125
As % of all contract IT jobs advertised in West Yorkshire 2.94% 3.13% 3.18%
As % of the Processes & Methodologies category 3.31% 3.58% 3.58%
Number of daily rates quoted 72 62 85
West Yorkshire median daily rate £355 £425 £390
Median daily rate % change year-on-year -16.47% +8.97% -2.50%
10th Percentile £313 £325 £309
90th Percentile £486 £493 £461
Yorkshire median daily rate £375 £413 £380
% change year-on-year -9.09% +8.55% -5.00%
Number of hourly rates quoted 2 0 0
West Yorkshire median hourly rate £14.46 - -
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,113 2,513 3,491
As % of all contract IT jobs advertised in West Yorkshire 88.77% 87.32% 88.67%
Number of daily rates quoted 2,136 1,716 2,352
West Yorkshire median daily rate £415 £400 £400
Median daily rate % change year-on-year +3.75% - +10.34%
10th Percentile £304 £275 £283
90th Percentile £550 £545 £545
Yorkshire median daily rate £413 £400 £400
% change year-on-year +3.13% - +9.59%
Number of hourly rates quoted 70 59 49
West Yorkshire median hourly rate £17.00 £14.20 £13.50
Median hourly rate % change year-on-year +19.72% +5.19% -0.70%
10th Percentile £11.13 £8.33 £10.19
90th Percentile £33.08 £27.71 £22.15
Yorkshire median hourly rate £17.46 £14.20 £14.50
% change year-on-year +22.92% -2.07% +4.50%

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 19 September 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 19 September 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 -22 65 £375 -11.76% 7
Halifax +11 10 £325 -31.58%
Bradford -3 10 £355 - 6
Wakefield - 4 £475 -
Bingley - 1 £325 -
ETL
Yorkshire

For the 6 months to 19 September 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 61 (59.22%) SQL
2 52 (50.49%) Data Warehouse
3 47 (45.63%) SQL Server Integration Services
4 42 (40.78%) SQL Server
5 39 (37.86%) Business Intelligence
6 30 (29.13%) T-SQL
7 28 (27.18%) Agile Software Development
8 27 (26.21%) SQL Server Reporting Services
9 22 (21.36%) ETL Development
10 20 (19.42%) Migration
11 19 (18.45%) Microsoft
12 18 (17.48%) Finance
12 18 (17.48%) Data Migration
13 16 (15.53%) Data Modelling
14 15 (14.56%) C#
14 15 (14.56%) Unix
15 14 (13.59%) Data Mapping
15 14 (13.59%) Relational Database
16 13 (12.62%) Analytical Skills
16 13 (12.62%) SQL Server 2016
16 13 (12.62%) Amazon AWS
17 12 (11.65%) Data Integration
17 12 (11.65%) SQL Server Analysis Services
17 12 (11.65%) Analytics
17 12 (11.65%) IBM
17 12 (11.65%) Problem-Solving
18 11 (10.68%) Kimball Methodology
19 10 (9.71%) Test Automation
20 9 (8.74%) Hadoop
20 9 (8.74%) Visualisation

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 7 (6.80%) SAS
2 1 (0.97%) Apache Spark
2 1 (0.97%) Confluence
2 1 (0.97%) SharePoint
Applications
1 6 (5.83%) Microsoft Excel
2 2 (1.94%) Microsoft Office
2 2 (1.94%) Spreadsheet
3 1 (0.97%) Microsoft PowerPoint
Business Applications
1 3 (2.91%) Cognos Business Intelligence
2 2 (1.94%) Cognos TM1
2 2 (1.94%) Dynamics CRM
Cloud Services
1 13 (12.62%) Amazon AWS
2 9 (8.74%) Amazon S3
3 4 (3.88%) Microsoft Azure
3 4 (3.88%) Virtual Private Cloud
4 3 (2.91%) Amazon EC2
4 3 (2.91%) Amazon EMR
4 3 (2.91%) Amazon Glacier
5 2 (1.94%) Dynamics 365
6 1 (0.97%) Cloud Computing
Communications & Networking
1 1 (0.97%) DSL
Database & Business Intelligence
1 52 (50.49%) Data Warehouse
2 47 (45.63%) SQL Server Integration Services
3 42 (40.78%) SQL Server
4 27 (26.21%) SQL Server Reporting Services
5 14 (13.59%) Relational Database
6 13 (12.62%) SQL Server 2016
7 12 (11.65%) SQL Server Analysis Services
8 9 (8.74%) DataStage
8 9 (8.74%) Hadoop
9 8 (7.77%) Amazon Aurora
10 6 (5.83%) Pentaho
10 6 (5.83%) Power BI
11 5 (4.85%) Big Data
11 5 (4.85%) Data Mart
11 5 (4.85%) NoSQL
11 5 (4.85%) SQL Server 2008
11 5 (4.85%) SSDT
12 3 (2.91%) BusinessObjects
12 3 (2.91%) OLAP
12 3 (2.91%) SQL Server 2012
Development Applications
1 8 (7.77%) Visual Studio
2 5 (4.85%) JIRA
3 4 (3.88%) Team Foundation Server
4 3 (2.91%) Octopus Deploy
4 3 (2.91%) TeamCity
5 2 (1.94%) SpecFlow
6 1 (0.97%) Git (software)
6 1 (0.97%) Toad
General
1 18 (17.48%) Finance
2 7 (6.80%) Banking
3 4 (3.88%) Retail
4 2 (1.94%) Publishing
5 1 (0.97%) Billing
5 1 (0.97%) Telecoms
Job Titles
1 62 (60.19%) Developer
2 26 (25.24%) ETL Developer
3 25 (24.27%) SQL Developer
4 16 (15.53%) Business Intelligence Developer
5 11 (10.68%) Analyst
6 8 (7.77%) SSIS Developer
7 6 (5.83%) Data Engineer
7 6 (5.83%) SQL Server Developer
8 5 (4.85%) Data Analyst
9 4 (3.88%) .NET Software Engineer
9 4 (3.88%) C# Software Engineer
9 4 (3.88%) Data Warehouse Developer
9 4 (3.88%) ETL Analyst
9 4 (3.88%) Software Engineer
9 4 (3.88%) SQL BI Developer
9 4 (3.88%) Test Engineer
9 4 (3.88%) Test Leader
9 4 (3.88%) Tester
10 3 (2.91%) Automation Tester
10 3 (2.91%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 4 (3.88%) .NET
1 4 (3.88%) .NET Framework
1 4 (3.88%) Kafka
1 4 (3.88%) WCF
2 3 (2.91%) ODBC
2 3 (2.91%) RESTful
2 3 (2.91%) Web Services
3 1 (0.97%) Pandas
3 1 (0.97%) PySpark
3 1 (0.97%) Spark Streaming
Miscellaneous
1 13 (12.62%) Analytical Skills
2 8 (7.77%) Mainframe
3 4 (3.88%) NHS
4 3 (2.91%) Data Centre
5 2 (1.94%) Data Structures
5 2 (1.94%) Greenfield Project
5 2 (1.94%) Management Information System
6 1 (0.97%) Reference Data
Operating Systems
1 15 (14.56%) Unix
2 8 (7.77%) Linux
3 3 (2.91%) Red Hat Enterprise Linux
4 1 (0.97%) Windows
4 1 (0.97%) Windows Server
4 1 (0.97%) zOS
Processes & Methodologies
1 39 (37.86%) Business Intelligence
2 28 (27.18%) Agile Software Development
3 22 (21.36%) ETL Development
4 20 (19.42%) Migration
5 18 (17.48%) Data Migration
6 16 (15.53%) Data Modelling
7 14 (13.59%) Data Mapping
8 12 (11.65%) Analytics
8 12 (11.65%) Data Integration
8 12 (11.65%) Problem-Solving
9 11 (10.68%) Kimball Methodology
10 10 (9.71%) Test Automation
11 9 (8.74%) Visualisation
12 8 (7.77%) Data Visualisation
12 8 (7.77%) Scrum
12 8 (7.77%) Stakeholder Management
13 7 (6.80%) Continuous Improvement
13 7 (6.80%) Software Engineering
14 6 (5.83%) Mentoring
15 5 (4.85%) API Testing
Programming Languages
1 61 (59.22%) SQL
2 30 (29.13%) T-SQL
3 15 (14.56%) C#
4 8 (7.77%) VBA
5 7 (6.80%) Java
6 5 (4.85%) Python
7 4 (3.88%) COBOL
7 4 (3.88%) Perl
8 1 (0.97%) HiveQL
8 1 (0.97%) PL/SQL
8 1 (0.97%) PowerShell
8 1 (0.97%) R
8 1 (0.97%) Smalltalk
8 1 (0.97%) VB
Qualifications
1 1 (0.97%) Computer Science Degree
1 1 (0.97%) Degree
1 1 (0.97%) SC Cleared
1 1 (0.97%) Security Cleared
Quality Assurance & Compliance
1 8 (7.77%) QA
2 3 (2.91%) Data Quality
2 3 (2.91%) PCI DSS
2 3 (2.91%) PMO
3 2 (1.94%) GDPR
4 1 (0.97%) SLA
System Software
1 3 (2.91%) Docker
Systems Management
1 3 (2.91%) Control-M
1 3 (2.91%) Opscode Chef
Vendors
1 19 (18.45%) Microsoft
2 12 (11.65%) IBM
3 8 (7.77%) Tableau
4 5 (4.85%) Hortonworks
4 5 (4.85%) Oracle
4 5 (4.85%) SAP
5 4 (3.88%) MuleSoft
5 4 (3.88%) webMethods
6 3 (2.91%) Axway
6 3 (2.91%) Cognos
6 3 (2.91%) IBM Sterling
6 3 (2.91%) ServiceNow
6 3 (2.91%) Splunk
7 2 (1.94%) Cloudera
7 2 (1.94%) Informatica
7 2 (1.94%) Netezza
8 1 (0.97%) Alteryx
8 1 (0.97%) BMC
8 1 (0.97%) RedGate
8 1 (0.97%) Talend