Period
to 24 November 2017

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 24 November 2017 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
24 Nov 2017
Same period 2016 Same period 2015
Rank 76 62 51
Rank change year-on-year -14 -11 +29
Contract jobs citing ETL 75 97 109
As % of all contract IT jobs advertised in the East Midlands 2.33% 2.94% 3.43%
As % of the Processes & Methodologies category 2.82% 3.58% 4.36%
Number of daily rates quoted 50 72 88
East Midlands median daily rate £380 £363 £439
Median daily rate % change year-on-year +4.83% -17.38% +18.98%
10th Percentile £298 £225 £261
90th Percentile £575 £511 £563
England median daily rate £450 £425 £425
% change year-on-year +5.88% - -
Number of hourly rates quoted 4 0 0
East Midlands median hourly rate £46.88 - -
England median hourly rate £45.00 £42.00 £28.75
% change year-on-year +7.14% +46.09% -24.84%

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 2664 2710 2499
As % of all contract IT jobs advertised in the East Midlands 82.94% 82.17% 78.58%
Number of daily rates quoted 1692 1716 1586
East Midlands median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.67% -
10th Percentile £250 £244 £225
90th Percentile £550 £575 £538
England median daily rate £450 £425 £425
% change year-on-year +5.88% - +6.25%
Number of hourly rates quoted 99 71 84
East Midlands median hourly rate £15.50 £14.00 £16.20
Median hourly rate % change year-on-year +10.71% -13.58% +2.86%
10th Percentile £9.31 £8.76 £11.00
90th Percentile £51.00 £40.00 £40.18
England median hourly rate £24.00 £24.00 £22.50
% change year-on-year - +6.67% +18.42%

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 24 November 2017.

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
Contractor Hourly Rate Histogram in the East Midlands

The hourly rate distribution of IT jobs citing ETL in the East Midlands over the 6 months to 24 November 2017.

Contractor hourly rate histogram 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 24 November 2017. 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
Nottinghamshire +9 25 £380 +4.83% 1
Northamptonshire -20 21 £333 -8.28% 3
Leicestershire -2 10 £550 +29.41%
Derbyshire -9 8 £408 +18.55%
Lincolnshire +4 7 £300 -31.82% 2
ETL
England

For the 6 months to 24 November 2017, IT contractor jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the East Midlands region with a requirement for ETL.

1 51 (68.00%) SQL
2 36 (48.00%) SQL Server
3 32 (42.67%) Data Warehouse
4 30 (40.00%) Business Intelligence
5 28 (37.33%) SQL Server Integration Services
6 22 (29.33%) Migration
7 19 (25.33%) Data Modelling
8 18 (24.00%) Oracle
8 18 (24.00%) Agile Software Development
8 18 (24.00%) Data Quality
9 17 (22.67%) Data Migration
10 15 (20.00%) T-SQL
11 13 (17.33%) SQL Server Reporting Services
12 11 (14.67%) Microsoft
12 11 (14.67%) SQL Server Analysis Services
13 10 (13.33%) Data Extraction
13 10 (13.33%) Informatica
14 9 (12.00%) ERP
15 8 (10.67%) Power BI
15 8 (10.67%) Data Structures
15 8 (10.67%) Analytical Skills
15 8 (10.67%) Stakeholder Management
15 8 (10.67%) Data Analysis
16 7 (9.33%) Finance
16 7 (9.33%) PeopleSoft
16 7 (9.33%) Performance Tuning
16 7 (9.33%) Data Mapping
16 7 (9.33%) Microsoft Azure
17 6 (8.00%) PowerShell
17 6 (8.00%) Machine Learning

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 6 (8.00%) SharePoint
2 1 (1.33%) Apache Pig
2 1 (1.33%) IIS
2 1 (1.33%) Luigi
2 1 (1.33%) Oracle Workflow
2 1 (1.33%) SAS
Applications
1 5 (6.67%) Microsoft Excel
2 2 (2.67%) Microsoft Office
3 1 (1.33%) Microsoft PowerPoint
Business Applications
1 2 (2.67%) Oracle EBS
1 2 (2.67%) Oracle EBS R12
1 2 (2.67%) Oracle ERP
2 1 (1.33%) Infor M3
Cloud Services
1 7 (9.33%) Microsoft Azure
2 1 (1.33%) Azure Machine Learning
Communications & Networking
1 3 (4.00%) Internet
2 2 (2.67%) FTP
3 1 (1.33%) SMS
Database & Business Intelligence
1 36 (48.00%) SQL Server
2 32 (42.67%) Data Warehouse
3 28 (37.33%) SQL Server Integration Services
4 13 (17.33%) SQL Server Reporting Services
5 11 (14.67%) SQL Server Analysis Services
6 8 (10.67%) Power BI
7 6 (8.00%) SQL Server 2016
8 5 (6.67%) Data Lake
8 5 (6.67%) Relational Database
9 4 (5.33%) PowerCenter
9 4 (5.33%) QlikView
9 4 (5.33%) Snowflake Schema
9 4 (5.33%) SQL Server 2005
9 4 (5.33%) SQL Server 2012
10 3 (4.00%) Big Data
10 3 (4.00%) Data Mining
10 3 (4.00%) Microsoft Analysis Services
10 3 (4.00%) NoSQL
10 3 (4.00%) Oracle Database 11g
10 3 (4.00%) RDBMS
Development Applications
1 3 (4.00%) Subversion
2 1 (1.33%) PeopleTools
2 1 (1.33%) Team Foundation Server
2 1 (1.33%) Toad
2 1 (1.33%) TortoiseSVN
General
1 7 (9.33%) Finance
2 4 (5.33%) Pharmaceutical
3 3 (4.00%) Retail
4 2 (2.67%) Manufacturing
5 1 (1.33%) Aerospace
5 1 (1.33%) Legal
5 1 (1.33%) Marketing
5 1 (1.33%) Telecoms
Job Titles
1 27 (36.00%) Developer
2 21 (28.00%) Analyst
3 15 (20.00%) Data Analyst
4 14 (18.67%) Business Intelligence Developer
5 12 (16.00%) Architect
6 11 (14.67%) ETL Developer
7 9 (12.00%) Data Engineer
8 8 (10.67%) Data Migration Analyst
8 8 (10.67%) Migration Analyst
8 8 (10.67%) SQL Developer
9 6 (8.00%) Informatica Developer
9 6 (8.00%) Informatica ETL Developer
9 6 (8.00%) Solutions Architect
9 6 (8.00%) SSIS Developer
10 5 (6.67%) Senior Developer
10 5 (6.67%) SQL BI Developer
11 4 (5.33%) Power BI Developer
11 4 (5.33%) Senior Business Intelligence Developer
11 4 (5.33%) SQL Server Developer
12 3 (4.00%) Informatica Architect
Libraries, Frameworks & Software Standards
1 5 (6.67%) MDX
2 2 (2.67%) Ajax
2 2 (2.67%) XML
2 2 (2.67%) XSL
2 2 (2.67%) XSLT
3 1 (1.33%) .NET
3 1 (1.33%) Middleware
3 1 (1.33%) Natural Language Processing
3 1 (1.33%) Oracle GoldenGate
3 1 (1.33%) Web Services
Miscellaneous
1 8 (10.67%) Analytical Skills
1 8 (10.67%) Data Structures
2 3 (4.00%) Greenfield Project
2 3 (4.00%) NHS
3 2 (2.67%) Taxonomies
4 1 (1.33%) Computer Science
4 1 (1.33%) Enterprise Software
4 1 (1.33%) Management Information System
4 1 (1.33%) Replication
Operating Systems
1 1 (1.33%) Linux
Processes & Methodologies
1 30 (40.00%) Business Intelligence
2 22 (29.33%) Migration
3 19 (25.33%) Data Modelling
4 18 (24.00%) Agile Software Development
5 17 (22.67%) Data Migration
6 10 (13.33%) Data Extraction
7 9 (12.00%) ERP
8 8 (10.67%) Data Analysis
8 8 (10.67%) Stakeholder Management
9 7 (9.33%) Data Mapping
9 7 (9.33%) Performance Tuning
10 6 (8.00%) Analytics
10 6 (8.00%) CRM
10 6 (8.00%) Machine Learning
11 5 (6.67%) Data Architecture
11 5 (6.67%) Data Integration
11 5 (6.67%) Data Reconciliation
11 5 (6.67%) Dimensional Modelling
11 5 (6.67%) Kimball Methodology
11 5 (6.67%) Scrum
Programming Languages
1 51 (68.00%) SQL
2 15 (20.00%) T-SQL
3 6 (8.00%) Java
3 6 (8.00%) PL/SQL
3 6 (8.00%) PowerShell
3 6 (8.00%) Python
4 5 (6.67%) C#
4 5 (6.67%) Data Analysis Expressions (DAX)
5 3 (4.00%) C++
5 3 (4.00%) Perl
6 2 (2.67%) PeopleCode
6 2 (2.67%) SQR
7 1 (1.33%) Shell Script
7 1 (1.33%) VB.NET
7 1 (1.33%) VBA
Qualifications
1 6 (8.00%) Degree
2 4 (5.33%) Security Cleared
3 2 (2.67%) SC Cleared
4 1 (1.33%) Computer Science Degree
4 1 (1.33%) ISTQB
4 1 (1.33%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 18 (24.00%) Data Quality
2 2 (2.67%) 21 CFR Part 11
2 2 (2.67%) CDISC
2 2 (2.67%) GxP
2 2 (2.67%) HL7
3 1 (1.33%) QA
3 1 (1.33%) SLA
System Software
1 1 (1.33%) Oracle RAC
Systems Management
1 1 (1.33%) Data Guard
1 1 (1.33%) Enterprise Manager Cloud Control
1 1 (1.33%) Oracle Enterprise Manager
Vendors
1 18 (24.00%) Oracle
2 11 (14.67%) Microsoft
3 10 (13.33%) Informatica
4 7 (9.33%) PeopleSoft
5 3 (4.00%) Tableau
6 2 (2.67%) SAP
7 1 (1.33%) Hortonworks
7 1 (1.33%) IBM
7 1 (1.33%) Infor
7 1 (1.33%) Teradata