Period
to 23 February 2018

The following table provides summary statistics for contract job vacancies advertised in 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 February 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)
England > Yorkshire
6 months to
23 Feb 2018
Same period 2017 Same period 2016
Rank 81 70 61
Rank change year-on-year -11 -9 -7
Contract jobs citing ETL 118 135 186
As % of all contract IT jobs advertised in Yorkshire 2.55% 2.91% 3.15%
As % of the Processes & Methodologies category 3.03% 3.50% 3.76%
Number of daily rates quoted 83 94 201
Yorkshire median daily rate £388 £363 £425
Median daily rate % change year-on-year +6.90% -14.71% +6.25%
10th Percentile £259 £307 £275
90th Percentile £525 £505 £600
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% -
Number of hourly rates quoted 0 3 0
Yorkshire median hourly rate - £25.39 -
England median hourly rate £55.00 £40.00 £50.50
% change year-on-year +37.50% -20.79% +32.03%

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

All Process and Methodology Skills
Yorkshire
Contract vacancies with a requirement for process or methodology skills 3,894 3,859 4,944
As % of all contract IT jobs advertised in Yorkshire 84.16% 83.06% 83.64%
Number of daily rates quoted 2,547 2,502 3,311
Yorkshire median daily rate £400 £400 £394
Median daily rate % change year-on-year - +1.52% +8.69%
10th Percentile £263 £259 £263
90th Percentile £538 £550 £563
England median daily rate £455 £438 £425
% change year-on-year +4.00% +2.94% +4.94%
Number of hourly rates quoted 118 117 165
Yorkshire median hourly rate £19.52 £14.87 £15.00
Median hourly rate % change year-on-year +31.28% -0.90% -4.61%
10th Percentile £10.68 £10.17 £9.99
90th Percentile £41.95 £31.90 £28.75
England median hourly rate £24.56 £25.00 £23.75
% change year-on-year -1.76% +5.26% +16.74%

ETL
Job Vacancy Trend in Yorkshire

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

Job vacancy trend for ETL in Yorkshire

ETL
Contractor Daily Rate Trend in Yorkshire

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

Contractor daily rate trend for ETL in Yorkshire

ETL
Contractor Daily Rate Histogram in Yorkshire

The daily rate distribution of IT jobs citing ETL in Yorkshire over the 6 months to 23 February 2018.

Contractor daily rate histogram for ETL in Yorkshire

ETL
Contractor Hourly Rate Trend in Yorkshire

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

Contractor hourly rate trend for ETL in Yorkshire

ETL
Contract Job Locations in 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 Yorkshire region over the 6 months to 23 February 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
West Yorkshire -13 86 £400 +10.34% 21
South Yorkshire 0 26 £399 +4.80% 6
East Yorkshire -4 2 £400 +14.29%
Humberside - 1 £259 -
ETL
England

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

1 66 (55.93%) SQL
2 59 (50.00%) SQL Server
3 55 (46.61%) Business Intelligence
4 49 (41.53%) SQL Server Integration Services
5 44 (37.29%) Microsoft
6 39 (33.05%) Data Warehouse
7 33 (27.97%) Finance
8 31 (26.27%) Agile Software Development
9 28 (23.73%) Migration
10 24 (20.34%) Data Modelling
11 23 (19.49%) T-SQL
11 23 (19.49%) Power BI
12 22 (18.64%) SQL Server Reporting Services
13 19 (16.10%) Data Analysis
13 19 (16.10%) Data Management
13 19 (16.10%) SQL Server 2008
14 18 (15.25%) QlikView
14 18 (15.25%) Oracle
15 17 (14.41%) Analytical Skills
16 15 (12.71%) Data Migration
16 15 (12.71%) SQL Server Analysis Services
17 14 (11.86%) Informatica
17 14 (11.86%) Banking
18 13 (11.02%) SAS
18 13 (11.02%) Performance Tuning
19 12 (10.17%) Apache Hive
19 12 (10.17%) SQL Server 2014
20 11 (9.32%) ETL Development
20 11 (9.32%) Analytical Thinking
20 11 (9.32%) Hadoop

ETL
Co-occurring IT Skills in 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 13 (11.02%) SAS
2 9 (7.63%) Apache Spark
3 2 (1.69%) WebSphere
4 1 (0.85%) Apache
4 1 (0.85%) Confluence
Applications
1 11 (9.32%) Microsoft Excel
2 5 (4.24%) Microsoft Office
3 1 (0.85%) Microsoft Project
Business Applications
1 5 (4.24%) Oracle Receivables
2 3 (2.54%) Oracle iProcurement
3 2 (1.69%) Cognos Business Intelligence
3 2 (1.69%) Cognos TM1
3 2 (1.69%) Dynamics CRM
3 2 (1.69%) Oracle EBS
3 2 (1.69%) Oracle General Ledger
3 2 (1.69%) Oracle Payables
Cloud Services
1 6 (5.08%) Amazon AWS
2 4 (3.39%) Microsoft Azure
3 2 (1.69%) Dynamics 365
4 1 (0.85%) Cloud Computing
4 1 (0.85%) GitHub
4 1 (0.85%) Google Cloud Platform
4 1 (0.85%) SaaS
4 1 (0.85%) SuccessFactors
Communications & Networking
1 5 (4.24%) DSL
2 3 (2.54%) SMS
Database & Business Intelligence
1 59 (50.00%) SQL Server
2 49 (41.53%) SQL Server Integration Services
3 39 (33.05%) Data Warehouse
4 23 (19.49%) Power BI
5 22 (18.64%) SQL Server Reporting Services
6 19 (16.10%) SQL Server 2008
7 18 (15.25%) QlikView
8 15 (12.71%) SQL Server Analysis Services
9 12 (10.17%) Apache Hive
9 12 (10.17%) SQL Server 2014
10 11 (9.32%) Hadoop
11 9 (7.63%) HBase
11 9 (7.63%) Oracle BI EE
12 8 (6.78%) Pentaho
13 7 (5.93%) Relational Database
13 7 (5.93%) SQL Server 2016
14 6 (5.08%) Big Data
14 6 (5.08%) SQL Server 2012
15 5 (4.24%) Oracle Database 12c
15 5 (4.24%) Oracle ODI
Development Applications
1 9 (7.63%) Octopus Deploy
2 4 (3.39%) Git (software)
3 3 (2.54%) Jenkins
3 3 (2.54%) Team Foundation Server
4 2 (1.69%) Gerrit
4 2 (1.69%) IBM UrbanCode
5 1 (0.85%) Bitbucket
5 1 (0.85%) JIRA
5 1 (0.85%) JMeter
5 1 (0.85%) LoadRunner
5 1 (0.85%) Oracle Forms
5 1 (0.85%) Selenium
5 1 (0.85%) SQL Server Management Studio (SSMS)
5 1 (0.85%) TeamCity
5 1 (0.85%) Visual Studio
5 1 (0.85%) WebDriver
General
1 33 (27.97%) Finance
2 14 (11.86%) Banking
3 4 (3.39%) Games
4 1 (0.85%) Advertising
4 1 (0.85%) Financial Institution
4 1 (0.85%) Investment Banking
4 1 (0.85%) Retail
Job Titles
1 69 (58.47%) Developer
2 22 (18.64%) SQL Developer
3 21 (17.80%) Analyst
4 19 (16.10%) ETL Developer
5 18 (15.25%) Business Intelligence Developer
6 16 (13.56%) Data Engineer
7 11 (9.32%) Senior Developer
8 9 (7.63%) Senior SQL Developer
9 7 (5.93%) Analyst Developer
9 7 (5.93%) SSIS Developer
10 5 (4.24%) Big Data Engineer
10 5 (4.24%) Business Intelligence Analyst
10 5 (4.24%) Cognos Developer
10 5 (4.24%) Consultant
10 5 (4.24%) Data Analyst
10 5 (4.24%) Hadoop Engineer
10 5 (4.24%) OBIEE Developer
11 4 (3.39%) Architect
11 4 (3.39%) Data Warehouse Developer
11 4 (3.39%) Database Developer
Libraries, Frameworks & Software Standards
1 9 (7.63%) Kafka
2 5 (4.24%) Spark Streaming
3 3 (2.54%) JSON
4 2 (1.69%) XML
5 1 (0.85%) CSS
5 1 (0.85%) HTML
5 1 (0.85%) JMS
5 1 (0.85%) Node.js
5 1 (0.85%) Spring
Miscellaneous
1 17 (14.41%) Analytical Skills
2 8 (6.78%) Management Information System
3 5 (4.24%) NHS
4 3 (2.54%) Greenfield Project
5 2 (1.69%) Mainframe
6 1 (0.85%) Data Structures
6 1 (0.85%) Enterprise Software
6 1 (0.85%) Hybrid Cloud
6 1 (0.85%) Market Risk
6 1 (0.85%) Replication
Operating Systems
1 7 (5.93%) Unix
2 1 (0.85%) Windows
Processes & Methodologies
1 55 (46.61%) Business Intelligence
2 31 (26.27%) Agile Software Development
3 28 (23.73%) Migration
4 24 (20.34%) Data Modelling
5 19 (16.10%) Data Analysis
5 19 (16.10%) Data Management
6 15 (12.71%) Data Migration
7 13 (11.02%) Performance Tuning
8 11 (9.32%) Analytical Thinking
8 11 (9.32%) ETL Development
9 10 (8.47%) Dashboard Development
9 10 (8.47%) Data Integration
10 8 (6.78%) MapReduce
11 6 (5.08%) Continuous Improvement
12 5 (4.24%) Collaborative Working
12 5 (4.24%) Data Architecture
12 5 (4.24%) Data Governance
12 5 (4.24%) Data Transformation
13 4 (3.39%) Test Automation
13 4 (3.39%) Visualisation
Programming Languages
1 66 (55.93%) SQL
2 23 (19.49%) T-SQL
3 7 (5.93%) Python
4 5 (4.24%) HiveQL
4 5 (4.24%) Scala
5 4 (3.39%) Java
5 4 (3.39%) PL/SQL
5 4 (3.39%) Ruby
6 2 (1.69%) Shell Script
6 2 (1.69%) VBA
7 1 (0.85%) ANSI SQL
7 1 (0.85%) C#
7 1 (0.85%) JavaScript
Qualifications
1 9 (7.63%) MCITP
1 9 (7.63%) MCSE
1 9 (7.63%) Microsoft Certification
2 3 (2.54%) Degree
2 3 (2.54%) ISEB
3 2 (1.69%) Security Cleared
4 1 (0.85%) BPSS Clearance
Quality Assurance & Compliance
1 10 (8.47%) Data Quality
2 7 (5.93%) QA
3 1 (0.85%) GCP
Systems Management
1 2 (1.69%) CSIRT
2 1 (0.85%) Systems Management Server (SMS)
Vendors
1 44 (37.29%) Microsoft
2 18 (15.25%) Oracle
3 14 (11.86%) Informatica
4 10 (8.47%) Tableau
4 10 (8.47%) Talend
5 9 (7.63%) RedGate
6 8 (6.78%) SAP
7 7 (5.93%) Cognos
8 5 (4.24%) IBM
9 3 (2.54%) Cloudera
10 2 (1.69%) Logi
10 2 (1.69%) Logi Analytics
10 2 (1.69%) Microgen
11 1 (0.85%) Ab Initio
11 1 (0.85%) Capita
11 1 (0.85%) Google
11 1 (0.85%) Hortonworks
11 1 (0.85%) Netezza