Period
to 20 November 2017

The following table provides summary statistics for contract job vacancies advertised in the 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 20 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 > Midlands
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 79 76 54
Rank change year-on-year -3 -22 +43
Contract jobs citing ETL 193 253 258
As % of all contract IT jobs advertised in the Midlands 2.37% 2.62% 3.05%
As % of the Processes & Methodologies category 2.85% 3.17% 3.86%
Number of daily rates quoted 121 173 184
Midlands median daily rate £400 £390 £400
Median daily rate % change year-on-year +2.56% -2.50% +6.67%
10th Percentile £313 £228 £257
90th Percentile £575 £513 £521
England median daily rate £450 £425 £425
% change year-on-year +5.88% - -
Number of hourly rates quoted 9 0 0
Midlands median hourly rate £51.25 - -
England median hourly rate £46.21 £44.00 £28.75
% change year-on-year +5.02% +53.04% -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 Midlands with a requirement for process or methodology skills.

All Process and Methodology Skills
Midlands
Contract vacancies with a requirement for process or methodology skills 6782 7980 6686
As % of all contract IT jobs advertised in the Midlands 83.18% 82.57% 79.04%
Number of daily rates quoted 4315 4877 3952
Midlands median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.67% +3.23%
10th Percentile £250 £250 £231
90th Percentile £550 £575 £538
England median daily rate £450 £425 £423
% change year-on-year +5.88% +0.59% +5.63%
Number of hourly rates quoted 241 204 263
Midlands median hourly rate £21.24 £16.75 £19.00
Median hourly rate % change year-on-year +26.81% -11.84% +4.11%
10th Percentile £10.59 £10.50 £11.00
90th Percentile £48.75 £39.85 £42.54
England median hourly rate £24.00 £24.42 £22.50
% change year-on-year -1.72% +8.53% +18.42%

ETL
Job Vacancy Trend in the Midlands

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

Job vacancy trend for ETL in the Midlands

ETL
Contractor Daily Rate Trend in the Midlands

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

Contractor daily rate trend for ETL in the Midlands

ETL
Contractor Daily Rate Histogram in the Midlands

The daily rate distribution of IT jobs citing ETL in the Midlands over the 6 months to 20 November 2017.

Contractor daily rate histogram for ETL in the Midlands

ETL
Contractor Hourly Rate Trend in the Midlands

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

Contractor hourly rate trend for ETL in the Midlands

ETL
Contractor Hourly Rate Histogram in the Midlands

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

Contractor hourly rate histogram for ETL in the Midlands

ETL
Contract Job Locations in the 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 Midlands region over the 6 months to 20 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
West Midlands +1 119 £413 +3.13% 18
East Midlands -14 74 £384 +5.86% 8
ETL
England

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

1 120 (62.18%) SQL
2 92 (47.67%) Business Intelligence
3 82 (42.49%) SQL Server
4 75 (38.86%) Data Warehouse
5 62 (32.12%) Oracle
6 60 (31.09%) Migration
7 57 (29.53%) SQL Server Integration Services
8 49 (25.39%) SQL Server Reporting Services
9 45 (23.32%) Agile Software Development
10 43 (22.28%) Microsoft
11 38 (19.69%) Data Modelling
11 38 (19.69%) T-SQL
11 38 (19.69%) Data Migration
12 33 (17.10%) Data Quality
13 30 (15.54%) SQL Server Analysis Services
14 29 (15.03%) Analytics
15 26 (13.47%) Data Management
16 25 (12.95%) Security Cleared
17 24 (12.44%) Tableau
17 24 (12.44%) Finance
18 22 (11.40%) Analytical Skills
19 21 (10.88%) Oracle Database
19 21 (10.88%) Pentaho
19 21 (10.88%) SharePoint
20 20 (10.36%) Data Analysis
20 20 (10.36%) SC Cleared
20 20 (10.36%) Power BI
21 17 (8.81%) ERP
21 17 (8.81%) CRM
22 16 (8.29%) Cognos

ETL
Co-occurring IT Skills in the 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 21 (10.88%) SharePoint
2 12 (6.22%) ArcGIS
3 9 (4.66%) SAS
4 5 (2.59%) Oracle SOA Suite
5 2 (1.04%) IIS
6 1 (0.52%) Apache Pig
6 1 (0.52%) Apache Spark
6 1 (0.52%) BizTalk Server
6 1 (0.52%) Luigi
6 1 (0.52%) MQSeries
6 1 (0.52%) Oracle 10gAS
6 1 (0.52%) Oracle Application Server
6 1 (0.52%) Oracle Workflow
Applications
1 12 (6.22%) Microsoft Excel
2 7 (3.63%) Microsoft Office
Business Applications
1 4 (2.07%) Oracle ERP
2 2 (1.04%) Dynamics AX
2 2 (1.04%) Dynamics CRM
2 2 (1.04%) Oracle Financials
3 1 (0.52%) Infor M3
3 1 (0.52%) Maximo
3 1 (0.52%) Oracle EBS
3 1 (0.52%) SAP ERP
3 1 (0.52%) SAP Retail
Cloud Services
1 9 (4.66%) Microsoft Azure
2 4 (2.07%) SaaS
2 4 (2.07%) Salesforce Service Cloud
3 2 (1.04%) Dynamics 365
4 1 (0.52%) Azure Machine Learning
4 1 (0.52%) Google Cloud Platform
Communications & Networking
1 4 (2.07%) Internet
2 3 (1.55%) SMS
3 2 (1.04%) FTP
Database & Business Intelligence
1 82 (42.49%) SQL Server
2 75 (38.86%) Data Warehouse
3 57 (29.53%) SQL Server Integration Services
4 49 (25.39%) SQL Server Reporting Services
5 30 (15.54%) SQL Server Analysis Services
6 21 (10.88%) Oracle Database
6 21 (10.88%) Pentaho
7 20 (10.36%) Power BI
8 16 (8.29%) OLAP
9 15 (7.77%) Relational Database
10 13 (6.74%) Oracle OLAP
11 12 (6.22%) Oracle Database 12c
11 12 (6.22%) RDBMS
12 10 (5.18%) PowerPivot
12 10 (5.18%) SQL Server 2012
12 10 (5.18%) SQL Server 2016
13 9 (4.66%) Oracle Database 11g
14 8 (4.15%) IBM InfoSphere
14 8 (4.15%) SQL Server 2014
15 7 (3.63%) QlikView
Development Applications
1 9 (4.66%) Subversion
2 7 (3.63%) Team Foundation Server
3 6 (3.11%) Git (software)
4 2 (1.04%) SoapUI
4 2 (1.04%) Talend Open Studio
4 2 (1.04%) Visual Studio
5 1 (0.52%) Oracle APEX
5 1 (0.52%) Oracle Forms
5 1 (0.52%) PeopleTools
5 1 (0.52%) Toad
5 1 (0.52%) TortoiseSVN
General
1 24 (12.44%) Finance
2 8 (4.15%) Retail
3 6 (3.11%) Pharmaceutical
4 3 (1.55%) Manufacturing
5 1 (0.52%) Aerospace
5 1 (0.52%) Automotive
5 1 (0.52%) Banking
5 1 (0.52%) Legal
5 1 (0.52%) Marketing
5 1 (0.52%) Telecoms
Job Titles
1 81 (41.97%) Developer
2 42 (21.76%) Business Intelligence Developer
3 38 (19.69%) Analyst
4 23 (11.92%) Architect
4 23 (11.92%) SQL Developer
5 20 (10.36%) ETL Developer
6 19 (9.84%) Data Analyst
7 17 (8.81%) Senior Developer
8 15 (7.77%) Senior Business Intelligence Developer
9 14 (7.25%) Data Engineer
9 14 (7.25%) DBA
10 12 (6.22%) Business Intelligence Analyst
10 12 (6.22%) Data Migration Analyst
10 12 (6.22%) Migration Analyst
11 11 (5.70%) Business Developer
11 11 (5.70%) SSIS Developer
12 10 (5.18%) SQL BI Developer
13 9 (4.66%) Oracle DBA
13 9 (4.66%) Solutions Architect
13 9 (4.66%) SQL Analyst
Libraries, Frameworks & Software Standards
1 13 (6.74%) Web Services
2 10 (5.18%) .NET
3 9 (4.66%) MDX
4 5 (2.59%) WCF
4 5 (2.59%) WPF
5 4 (2.07%) XML
6 2 (1.04%) Ajax
6 2 (1.04%) ASP.NET
6 2 (1.04%) HTML
6 2 (1.04%) Oracle Fusion
6 2 (1.04%) RESTful
6 2 (1.04%) XSL
6 2 (1.04%) XSLT
7 1 (0.52%) CSS
7 1 (0.52%) DHTML
7 1 (0.52%) Kafka
7 1 (0.52%) Natural Language Processing
7 1 (0.52%) Oracle GoldenGate
7 1 (0.52%) Visualforce
7 1 (0.52%) XHTML
Miscellaneous
1 22 (11.40%) Analytical Skills
2 13 (6.74%) Data Structures
3 6 (3.11%) Management Information System
4 5 (2.59%) Greenfield Project
5 4 (2.07%) FMCG
5 4 (2.07%) NHS
6 2 (1.04%) Computer Science
6 2 (1.04%) Data Protection Act
6 2 (1.04%) Enterprise Software
6 2 (1.04%) Replication
6 2 (1.04%) Taxonomies
7 1 (0.52%) iPad
7 1 (0.52%) Life Science
7 1 (0.52%) LIMS
7 1 (0.52%) SCADA
Operating Systems
1 5 (2.59%) Unix
2 3 (1.55%) Linux
3 2 (1.04%) Windows
4 1 (0.52%) HPUX
4 1 (0.52%) Red Hat Enterprise Linux
4 1 (0.52%) Windows 10
4 1 (0.52%) Windows Server
4 1 (0.52%) Windows Server 2003
4 1 (0.52%) Windows Server 2008
Processes & Methodologies
1 92 (47.67%) Business Intelligence
2 60 (31.09%) Migration
3 45 (23.32%) Agile Software Development
4 38 (19.69%) Data Migration
4 38 (19.69%) Data Modelling
5 29 (15.03%) Analytics
6 26 (13.47%) Data Management
7 20 (10.36%) Data Analysis
8 17 (8.81%) CRM
8 17 (8.81%) ERP
9 16 (8.29%) Visualisation
10 15 (7.77%) Performance Tuning
11 14 (7.25%) ITIL
12 12 (6.22%) Complex ETL
12 12 (6.22%) ETL Development
12 12 (6.22%) Stakeholder Management
13 11 (5.70%) Data Extraction
13 11 (5.70%) Data Mapping
14 10 (5.18%) Data Integration
14 10 (5.18%) Kimball Methodology
Programming Languages
1 120 (62.18%) SQL
2 38 (19.69%) T-SQL
3 15 (7.77%) C#
4 14 (7.25%) PL/SQL
5 12 (6.22%) JavaScript
6 9 (4.66%) PowerShell
7 7 (3.63%) Data Analysis Expressions (DAX)
7 7 (3.63%) Java
7 7 (3.63%) Python
8 3 (1.55%) C++
8 3 (1.55%) Perl
8 3 (1.55%) Shell Script
8 3 (1.55%) VBA
9 2 (1.04%) Data Mining Extensions (DMX)
9 2 (1.04%) PeopleCode
9 2 (1.04%) SQR
9 2 (1.04%) VB.NET
10 1 (0.52%) Apex Code
10 1 (0.52%) VB
Qualifications
1 25 (12.95%) Security Cleared
2 20 (10.36%) SC Cleared
3 11 (5.70%) Degree
4 3 (1.55%) BPSS Clearance
4 3 (1.55%) Master's Degree
5 2 (1.04%) ISTQB
5 2 (1.04%) SAS Certification
6 1 (0.52%) Computer Science Degree
6 1 (0.52%) ISEB
6 1 (0.52%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 33 (17.10%) Data Quality
2 2 (1.04%) 21 CFR Part 11
2 2 (1.04%) CDISC
2 2 (1.04%) Disclosure Scotland
2 2 (1.04%) GDPR
2 2 (1.04%) GxP
2 2 (1.04%) HL7
2 2 (1.04%) QA
3 1 (0.52%) GCP
3 1 (0.52%) SLA
3 1 (0.52%) Solvency II
System Software
1 2 (1.04%) Tivoli Workload Scheduler
2 1 (0.52%) Active Directory
2 1 (0.52%) Hyper-V
2 1 (0.52%) Oracle RAC
2 1 (0.52%) VMware Infrastructure
Systems Management
1 14 (7.25%) Oracle EDQ
2 11 (5.70%) Data Guard
2 11 (5.70%) Oracle RMAN
3 2 (1.04%) HP Quality Center
3 2 (1.04%) Tivoli
4 1 (0.52%) Enterprise Manager Cloud Control
4 1 (0.52%) Oracle Enterprise Manager
4 1 (0.52%) Systems Management Server (SMS)
Vendors
1 62 (32.12%) Oracle
2 43 (22.28%) Microsoft
3 24 (12.44%) Tableau
4 16 (8.29%) Cognos
5 14 (7.25%) Informatica
6 10 (5.18%) IBM
6 10 (5.18%) SAP
7 7 (3.63%) PeopleSoft
8 5 (2.59%) Salesforce.com
9 3 (1.55%) Netezza
10 2 (1.04%) ESRI
10 2 (1.04%) HP
10 2 (1.04%) OpenText
10 2 (1.04%) Syncsort
10 2 (1.04%) Talend
10 2 (1.04%) Teradata
11 1 (0.52%) Hortonworks
11 1 (0.52%) Infor
11 1 (0.52%) MicroStrategy
11 1 (0.52%) Red Hat