Period
to 22 June 2018

The following table provides summary statistics for contract job vacancies advertised in the East Midlands 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 22 June 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 > East Midlands
6 months to
22 Jun 2018
Same period 2017 Same period 2016
Rank 63 78 78
Rank change year-on-year +15 0 -17
Contract jobs citing ETL 93 67 62
As % of all contract IT jobs advertised in the East Midlands 3.25% 2.23% 1.96%
As % of the Processes & Methodologies category 3.91% 2.67% 2.38%
Number of daily rates quoted 54 34 43
East Midlands median daily rate £404 £400 £425
Median daily rate % change year-on-year +0.94% -5.88% +21.43%
10th Percentile £274 £250 £315
90th Percentile £504 £553 £535
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% -
Number of hourly rates quoted 1 1 0
East Midlands median hourly rate £47.50 £19.00 -
Median hourly rate % change year-on-year +150.00% - -
England median hourly rate £47.50 £40.00 £25.25
% change year-on-year +18.75% +58.42% -31.29%

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

All Process and Methodology Skills
East Midlands
Contract vacancies with a requirement for process or methodology skills 2,381 2,509 2,608
As % of all contract IT jobs advertised in the East Midlands 83.19% 83.52% 82.32%
Number of daily rates quoted 1,451 1,565 1,613
East Midlands median daily rate £400 £400 £388
Median daily rate % change year-on-year - +3.23% +4.73%
10th Percentile £258 £253 £238
90th Percentile £538 £540 £575
England median daily rate £463 £450 £425
% change year-on-year +2.78% +5.88% +4.94%
Number of hourly rates quoted 85 73 66
East Midlands median hourly rate £17.50 £15.50 £16.05
Median hourly rate % change year-on-year +12.90% -3.40% -4.64%
10th Percentile £10.40 £10.38 £11.25
90th Percentile £47.50 £52.50 £41.50
England median hourly rate £22.00 £25.00 £25.00
% change year-on-year -12.00% - +19.05%

ETL
Job Vacancy Trend in the East Midlands

Job postings citing ETL as a percentage of all IT jobs advertised in the East Midlands.

Job vacancy trend for ETL in the East Midlands

ETL
Contractor Daily Rate Trend in the East Midlands

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

Contractor daily rate trend for ETL in the East Midlands

ETL
Contractor Daily Rate Histogram in the East Midlands

The daily rate distribution of IT jobs citing ETL in the East Midlands over the 6 months to 22 June 2018.

Contractor daily rate histogram for ETL in the East Midlands

ETL
Contractor Hourly Rate Trend in the East Midlands

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

Contractor hourly rate trend for ETL in the East Midlands

ETL
Contract Job Locations in the East Midlands

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the East Midlands region over the 6 months to 22 June 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
Derbyshire +38 37 £463 +8.82% 4
Northamptonshire -8 19 £370 -17.78% 3
Nottinghamshire -10 19 £400 +28.00% 6
Leicestershire +17 9 £305 -32.22% 3
ETL
England

For the 6 months to 22 June 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 East Midlands region with a requirement for ETL.

1 60 (64.52%) Data Warehouse
2 57 (61.29%) SQL
2 57 (61.29%) Business Intelligence
3 35 (37.63%) Oracle
4 31 (33.33%) SQL Server
4 31 (33.33%) Microsoft
5 28 (30.11%) Data Quality
6 27 (29.03%) Analytics
7 25 (26.88%) Big Data
7 25 (26.88%) Informatica
8 23 (24.73%) SQL Server Integration Services
9 22 (23.66%) Hadoop
10 21 (22.58%) Analytical Skills
10 21 (22.58%) Agile Software Development
11 20 (21.51%) Unix
11 20 (21.51%) Power BI
12 19 (20.43%) Oracle Reports
13 18 (19.35%) Python
13 18 (19.35%) Manufacturing
14 17 (18.28%) User Acceptance Testing
14 17 (18.28%) Data Analytics
14 17 (18.28%) R
15 16 (17.20%) Tableau
15 16 (17.20%) Apache Spark
15 16 (17.20%) Retail
15 16 (17.20%) PowerCenter
16 15 (16.13%) PL/SQL
16 15 (16.13%) PLM
16 15 (16.13%) Data Engineering
17 13 (13.98%) SQL Server Reporting Services

ETL
Co-occurring IT Skills in the East Midlands 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 16 (17.20%) Apache Spark
2 12 (12.90%) SharePoint
3 7 (7.53%) SAS
4 1 (1.08%) Apache Pig
4 1 (1.08%) Apache Solr
4 1 (1.08%) Elasticsearch
Applications
1 5 (5.38%) Microsoft Excel
2 4 (4.30%) Microsoft PowerPoint
3 1 (1.08%) Microsoft Office
Business Applications
1 2 (2.15%) Oracle Financials
Cloud Services
1 7 (7.53%) Microsoft Azure
2 3 (3.23%) Amazon AWS
3 1 (1.08%) Amazon EC2
3 1 (1.08%) Amazon ELB
3 1 (1.08%) Amazon Kinesis
3 1 (1.08%) Amazon S3
3 1 (1.08%) Google Cloud Platform
3 1 (1.08%) Office 365
3 1 (1.08%) Route 53
3 1 (1.08%) Stackdriver
3 1 (1.08%) Virtual Private Cloud
Communications & Networking
1 7 (7.53%) FTP
1 7 (7.53%) SAN
Database & Business Intelligence
1 60 (64.52%) Data Warehouse
2 31 (33.33%) SQL Server
3 25 (26.88%) Big Data
4 23 (24.73%) SQL Server Integration Services
5 22 (23.66%) Hadoop
6 20 (21.51%) Power BI
7 19 (20.43%) Oracle Reports
8 16 (17.20%) PowerCenter
9 13 (13.98%) Oracle Database
9 13 (13.98%) SQL Server Reporting Services
10 12 (12.90%) Data Mart
11 10 (10.75%) SQL Server Analysis Services
12 9 (9.68%) QlikView
13 7 (7.53%) Oracle BI EE
13 7 (7.53%) SQL Server 2012
14 5 (5.38%) Enterprise Data Warehouse
15 4 (4.30%) Microsoft Analysis Services
15 4 (4.30%) Oracle Database 11g
15 4 (4.30%) Relational Database
15 4 (4.30%) Spotfire
Development Applications
1 9 (9.68%) Visual Studio
2 4 (4.30%) Team Foundation Server
3 3 (3.23%) JIRA
4 2 (2.15%) SQL Server Management Studio (SSMS)
5 1 (1.08%) ERwin
5 1 (1.08%) Git (software)
5 1 (1.08%) Jenkins
5 1 (1.08%) Visual Studio Team System
General
1 18 (19.35%) Manufacturing
2 16 (17.20%) Retail
3 12 (12.90%) Finance
4 11 (11.83%) Banking
5 9 (9.68%) Corporate Banking
6 5 (5.38%) Aerospace
7 1 (1.08%) Investment Banking
Job Titles
1 38 (40.86%) Developer
2 17 (18.28%) Data Engineer
3 16 (17.20%) Analyst
4 14 (15.05%) Business Intelligence Developer
5 11 (11.83%) ETL Developer
6 10 (10.75%) Data Analyst
7 7 (7.53%) SQL Developer
7 7 (7.53%) SSIS Developer
8 6 (6.45%) Architect
8 6 (6.45%) Senior Data Engineer
9 5 (5.38%) Analyst Developer
9 5 (5.38%) Big Data Engineer
9 5 (5.38%) Developer Analyst
9 5 (5.38%) SQL BI Developer
10 4 (4.30%) Business Analyst
10 4 (4.30%) Business Intelligence Analyst
10 4 (4.30%) Business Intelligence Specialist
10 4 (4.30%) Data Architect
10 4 (4.30%) Data Warehouse Specialist
10 4 (4.30%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 9 (9.68%) XML
2 7 (7.53%) Oracle GoldenGate
2 7 (7.53%) Oracle Streams
3 5 (5.38%) HTML
4 4 (4.30%) CSS
4 4 (4.30%) MDX
5 3 (3.23%) JSON
6 2 (2.15%) Kafka
7 1 (1.08%) .NET
7 1 (1.08%) ASP.NET
7 1 (1.08%) Elastic Stack
7 1 (1.08%) J2EE
7 1 (1.08%) Lucene
7 1 (1.08%) Middleware
7 1 (1.08%) OLE
Miscellaneous
1 21 (22.58%) Analytical Skills
2 9 (9.68%) Credit Risk
3 6 (6.45%) Management Information System
4 4 (4.30%) Data Structures
4 4 (4.30%) NHS
5 3 (3.23%) Greenfield Project
6 1 (1.08%) e-Learning
6 1 (1.08%) Replication
6 1 (1.08%) Self-Motivation
Operating Systems
1 20 (21.51%) Unix
2 10 (10.75%) Linux
3 5 (5.38%) Windows
4 4 (4.30%) Windows Server
4 4 (4.30%) Windows Server 2003
5 1 (1.08%) VMS
Processes & Methodologies
1 57 (61.29%) Business Intelligence
2 27 (29.03%) Analytics
3 21 (22.58%) Agile Software Development
4 17 (18.28%) Data Analytics
4 17 (18.28%) User Acceptance Testing
5 15 (16.13%) Data Engineering
5 15 (16.13%) PLM
6 12 (12.90%) Root Cause Analysis
7 11 (11.83%) Performance Tuning
7 11 (11.83%) Use Case
8 10 (10.75%) ERD
9 9 (9.68%) Data Integration
10 8 (8.60%) Problem-Solving
11 7 (7.53%) Visualisation
12 6 (6.45%) Data Modelling
12 6 (6.45%) Scrum
12 6 (6.45%) Unit Testing
13 5 (5.38%) Data Analysis
14 4 (4.30%) Data Architecture
14 4 (4.30%) ITIL
Programming Languages
1 57 (61.29%) SQL
2 18 (19.35%) Python
3 17 (18.28%) R
4 15 (16.13%) PL/SQL
5 8 (8.60%) T-SQL
6 6 (6.45%) Data Analysis Expressions (DAX)
6 6 (6.45%) Java
7 5 (5.38%) JavaScript
8 4 (4.30%) Bash Shell
9 2 (2.15%) C
9 2 (2.15%) PHP
10 1 (1.08%) PowerShell
10 1 (1.08%) Ruby
10 1 (1.08%) VB
Qualifications
1 8 (8.60%) Security Cleared
2 6 (6.45%) SC Cleared
3 2 (2.15%) Degree
3 2 (2.15%) ISTQB
3 2 (2.15%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 28 (30.11%) Data Quality
2 5 (5.38%) GDPR
3 3 (3.23%) PMO
4 1 (1.08%) ISO 9001
4 1 (1.08%) ISO 9002
4 1 (1.08%) TickIT
System Software
1 1 (1.08%) Apache Flume
1 1 (1.08%) Apache ZooKeeper
1 1 (1.08%) Docker
1 1 (1.08%) HDFS
Systems Management
1 2 (2.15%) Systems Management Server (SMS)
2 1 (1.08%) Oozie
Vendors
1 35 (37.63%) Oracle
2 31 (33.33%) Microsoft
3 25 (26.88%) Informatica
4 16 (17.20%) Tableau
5 10 (10.75%) Ab Initio
5 10 (10.75%) Cloudera
6 6 (6.45%) Alteryx
7 4 (4.30%) SAP
7 4 (4.30%) Talend
7 4 (4.30%) TIBCO
8 2 (2.15%) Hortonworks
8 2 (2.15%) MapR
9 1 (1.08%) Dynatrace
9 1 (1.08%) Google
9 1 (1.08%) Salesforce.com