The following table provides summary statistics for contract job vacancies advertised in the City of London with a requirement for ETL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ETL over the 3 months to 23 March 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.

3 months to
23 Mar 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
London / City of London
Rank 74 82 60
Rank change year-on-year +8 -22  
Contract jobs citing ETL 84 85 165
As % of all contract IT jobs advertised in the City of London 2.80% 2.59% 3.28%
As % of the Processes & Methodologies category 3.28% 2.95% 3.97%
Number of daily rates quoted 63 73 140
Median daily rate £500 £450 £450
Median daily rate % change year-on-year +11.11% -  
90% offered a daily rate of more than £400 £328 £350
10% offered a daily rate of more than £623 £575 £600
UK excluding London median daily rate £400 £400 £400
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £37.50 £63.00 £40.00
% change year-on-year -40.47% +57.50%  

ETL is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the City of London with a requirement for process and methodology skills.

Contract Process & Methodology Skills
City of London
Contract job vacancies with a requirement for process and methodology skills 2560 2885 4153
As % of all contract IT job vacancies advertised in the City of London 85.48% 87.74% 82.60%
Number of daily rates quoted 2008 2312 3203
Median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.55%  
90% offered a daily rate of more than £345 £325 £313
10% offered a daily rate of more than £625 £625 £625
UK excluding London median daily rate £410 £400 £399
% change year-on-year +2.50% +0.29%  
Number of hourly rates quoted 20 25 35
Median hourly rate £16.00 £19.99 £20.45
Median hourly rate % change year-on-year -19.96% -2.21%  
90% offered a hourly rate of more than £13.50 £13.00 £12.50
10% offered a hourly rate of more than £43.84 £47.50 £92.50
UK excluding London median hourly rate £36.00 £39.00 £30.00
% change year-on-year -7.69% +30.00%  

ETL
Job Vacancy Trend in the City of London

The job posting trend of jobs advertised in the City of London citing ETL as a proportion of all contract or permanent IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for ETL in the City of London

ETL
Contractor Daily Rate Trend in the City of London

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

Contractor daily rate trend for ETL in the City of London

ETL
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing ETL in the City of London over the 3 months to 23 March 2017.

Contractor daily rate histogram for ETL in the City of London

ETL
Contractor Hourly Rate Trend in the City of London

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

Contractor hourly rate trend for ETL in the City of London

ETL
Top 30 Related IT Skills in the City of London

For the 6 months to 23 March 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 City of London region with a requirement for ETL.

1 121 (65.41%) SQL
2 89 (48.11%) Data Warehouse
3 70 (37.84%) SQL Server
4 65 (35.14%) Finance
5 62 (33.51%) SQL Server Integration Services
6 61 (32.97%) Data Modelling
7 59 (31.89%) Agile Software Development
8 58 (31.35%) Business Intelligence
9 42 (22.70%) Microsoft
10 40 (21.62%) Analytics
11 39 (21.08%) SQL Server Reporting Services
12 38 (20.54%) Data Quality
13 37 (20.00%) Big Data
14 35 (18.92%) Hadoop
15 34 (18.38%) Oracle
16 30 (16.22%) Java
17 29 (15.68%) Data Analysis
18 28 (15.14%) Data Integration
19 26 (14.05%) T-SQL
19 26 (14.05%) SQL Server Analysis Services
20 24 (12.97%) Performance Tuning
20 24 (12.97%) Analytical Skills
21 22 (11.89%) C#
22 21 (11.35%) Degree
23 20 (10.81%) Banking
24 19 (10.27%) Migration
24 19 (10.27%) Teradata
25 18 (9.73%) MS Excel
25 18 (9.73%) Data Management
25 18 (9.73%) Relational Database

ETL
Top Related IT Skills in the City of London 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 18 (9.73%) Apache Spark
2 10 (5.41%) Apache Pig
2 10 (5.41%) SAS
3 7 (3.78%) SharePoint
4 6 (3.24%) JBoss
5 5 (2.70%) Apache
5 5 (2.70%) Confluence
6 3 (1.62%) Elasticsearch
6 3 (1.62%) WebLogic
7 1 (0.54%) BizTalk Server
7 1 (0.54%) IIS
7 1 (0.54%) Tomcat
7 1 (0.54%) WebSphere
Applications
1 18 (9.73%) MS Excel
2 5 (2.70%) MS Office
3 4 (2.16%) SPSS
4 3 (1.62%) MS Visio
5 1 (0.54%) MS PowerPoint
5 1 (0.54%) Spreadsheet
Business Applications
1 9 (4.86%) Dynamics AX
2 3 (1.62%) Dynamics CRM
3 2 (1.08%) FastStats
3 2 (1.08%) FastStats PeopleStage
3 2 (1.08%) SAP Oil and Gas
4 1 (0.54%) Cognos Business Intelligence
4 1 (0.54%) Oracle EBS
4 1 (0.54%) SAP ERP
Cloud Services
1 15 (8.11%) Microsoft Azure
2 8 (4.32%) Amazon AWS
3 3 (1.62%) IaaS
4 1 (0.54%) Google Cloud Platform
Communications & Networking
1 3 (1.62%) FTP
1 3 (1.62%) HTTP
2 2 (1.08%) Kerberos
2 2 (1.08%) LAN
2 2 (1.08%) WAN
3 1 (0.54%) Internet
3 1 (0.54%) Intranet
3 1 (0.54%) LDAP
Database & Business Intelligence
1 89 (48.11%) Data Warehouse
2 70 (37.84%) SQL Server
3 62 (33.51%) SQL Server Integration Services
4 39 (21.08%) SQL Server Reporting Services
5 37 (20.00%) Big Data
6 35 (18.92%) Hadoop
7 26 (14.05%) SQL Server Analysis Services
8 18 (9.73%) Relational Database
9 17 (9.19%) Apache Hive
9 17 (9.19%) SQL Server 2014
10 14 (7.57%) BusinessObjects
11 11 (5.95%) Data Lake
12 10 (5.41%) Power BI
12 10 (5.41%) QlikView
12 10 (5.41%) SQL Server 2008
13 9 (4.86%) SQL Server 2012
14 8 (4.32%) NoSQL
14 8 (4.32%) OLAP
14 8 (4.32%) Oracle Database
15 7 (3.78%) Data Mining
Development Applications
1 13 (7.03%) JIRA
2 12 (6.49%) Talend Open Studio
3 10 (5.41%) Team Foundation Server
4 7 (3.78%) Git (software)
4 7 (3.78%) Jenkins
5 6 (3.24%) Subversion
6 5 (2.70%) ERwin
6 5 (2.70%) JUnit
6 5 (2.70%) Visual Studio
7 4 (2.16%) Maven
8 3 (1.62%) HP UFT
8 3 (1.62%) Mockito
8 3 (1.62%) Toad
9 2 (1.08%) Atlassian Bamboo
9 2 (1.08%) Selenium
10 1 (0.54%) FitNesse
10 1 (0.54%) jMock
10 1 (0.54%) Oracle APEX
10 1 (0.54%) TeamCity
10 1 (0.54%) WebDriver
General
1 65 (35.14%) Finance
2 20 (10.81%) Banking
3 7 (3.78%) Marketing
4 5 (2.70%) Retail
5 3 (1.62%) Advertising
6 2 (1.08%) Investment Banking
7 1 (0.54%) Billing
7 1 (0.54%) Electronics
7 1 (0.54%) Front Office
7 1 (0.54%) Legal
7 1 (0.54%) Manufacturing
7 1 (0.54%) Pharmaceutical
7 1 (0.54%) Telecoms
Job Titles
1 78 (42.16%) Developer
2 31 (16.76%) Architect
3 30 (16.22%) Analyst
4 27 (14.59%) ETL Developer
5 23 (12.43%) SQL Developer
6 19 (10.27%) Data Architect
7 18 (9.73%) Business Intelligence Developer
8 15 (8.11%) Data Engineer
9 14 (7.57%) Data Analyst
10 13 (7.03%) SSIS Developer
11 9 (4.86%) DBA
11 9 (4.86%) Solutions Architect
12 8 (4.32%) Business Developer
12 8 (4.32%) SSRS Developer
13 7 (3.78%) Business Intelligence Analyst
13 7 (3.78%) C# Developer
13 7 (3.78%) ETL Analyst
13 7 (3.78%) Microsoft Developer
13 7 (3.78%) Senior Developer
13 7 (3.78%) Test Analyst
Libraries, Frameworks & Software Standards
1 15 (8.11%) Web Services
2 14 (7.57%) .NET
2 14 (7.57%) XML
3 5 (2.70%) Middleware
3 5 (2.70%) XSLT
4 4 (2.16%) JSON
4 4 (2.16%) Kafka
4 4 (2.16%) REST
4 4 (2.16%) SOAP
4 4 (2.16%) XSD
5 3 (1.62%) .NET Framework
5 3 (1.62%) ADO
5 3 (1.62%) AngularJS
5 3 (1.62%) HTML
5 3 (1.62%) MDX
6 2 (1.08%) ASP.NET
6 2 (1.08%) J2EE
6 2 (1.08%) SAML
6 2 (1.08%) Spring
6 2 (1.08%) XML Schema
Miscellaneous
1 24 (12.97%) Analytical Skills
2 10 (5.41%) Management Information System
3 9 (4.86%) Data Structures
4 8 (4.32%) Algorithms
4 8 (4.32%) Computer Science
5 4 (2.16%) Replication
6 3 (1.62%) Data Centre
7 2 (1.08%) Credit Risk
7 2 (1.08%) Enterprise Software
7 2 (1.08%) Equities
7 2 (1.08%) Fixed Income
7 2 (1.08%) Reinsurance
7 2 (1.08%) User Experience
8 1 (0.54%) Clustering
8 1 (0.54%) Contactless
8 1 (0.54%) Derivative
8 1 (0.54%) Freedom of Information
8 1 (0.54%) Linux Command Line
8 1 (0.54%) NHS
8 1 (0.54%) Virtual Team
Operating Systems
1 12 (6.49%) Windows
2 11 (5.95%) Linux
3 10 (5.41%) Unix
4 4 (2.16%) Windows Server
Processes & Methodologies
1 61 (32.97%) Data Modelling
2 59 (31.89%) Agile Software Development
3 58 (31.35%) Business Intelligence
4 40 (21.62%) Analytics
5 29 (15.68%) Data Analysis
6 28 (15.14%) Data Integration
7 24 (12.97%) Performance Tuning
8 19 (10.27%) Migration
9 18 (9.73%) Data Management
10 16 (8.65%) Data Architecture
10 16 (8.65%) Scrum
11 14 (7.57%) Visualisation
12 13 (7.03%) Data Migration
12 13 (7.03%) ETL Development
13 12 (6.49%) Data Mapping
13 12 (6.49%) Dimensional Modelling
13 12 (6.49%) Stakeholder Management
13 12 (6.49%) Statistics
14 11 (5.95%) ERP
14 11 (5.95%) Unit Testing
Programming Languages
1 121 (65.41%) SQL
2 30 (16.22%) Java
3 26 (14.05%) T-SQL
4 22 (11.89%) C#
5 17 (9.19%) Python
6 12 (6.49%) R
7 11 (5.95%) PL/SQL
8 7 (3.78%) Scala
8 7 (3.78%) Shell Script
9 4 (2.16%) Bash Shell
9 4 (2.16%) JavaScript
9 4 (2.16%) VBA
10 3 (1.62%) C++
10 3 (1.62%) PowerShell
11 2 (1.08%) XPath
12 1 (0.54%) Apex Code
12 1 (0.54%) Groovy
12 1 (0.54%) MATLAB
12 1 (0.54%) Ruby
12 1 (0.54%) VB.NET
Qualifications
1 21 (11.35%) Degree
2 1 (0.54%) ISTQB
2 1 (0.54%) PhD
2 1 (0.54%) PMI Certification
2 1 (0.54%) PMP
Quality Assurance & Compliance
1 38 (20.54%) Data Quality
2 7 (3.78%) QA
3 6 (3.24%) Solvency II
4 2 (1.08%) IFRS
4 2 (1.08%) MiFID
4 2 (1.08%) PCI DSS
5 1 (0.54%) GDPR
5 1 (0.54%) IFRS 9
5 1 (0.54%) ISO20022
System Software
1 4 (2.16%) HDFS
2 2 (1.08%) Virtual Servers
3 1 (0.54%) Apache Flume
3 1 (0.54%) Oracle RAC
Systems Management
1 3 (1.62%) Control-M
1 3 (1.62%) MOM
1 3 (1.62%) Opscode Chef
1 3 (1.62%) Puppet
2 2 (1.08%) Hadoop YARN
2 2 (1.08%) Oozie
3 1 (0.54%) Ansible
3 1 (0.54%) Tivoli
Vendors
1 42 (22.70%) Microsoft
2 34 (18.38%) Oracle
3 19 (10.27%) Teradata
4 16 (8.65%) Tableau
5 13 (7.03%) Informatica
5 13 (7.03%) Netezza
5 13 (7.03%) SAP
6 12 (6.49%) Talend
7 5 (2.70%) Cognos
7 5 (2.70%) Greenplum
7 5 (2.70%) IBM
7 5 (2.70%) MicroStrategy
7 5 (2.70%) Sybase
7 5 (2.70%) Vertica
8 3 (1.62%) Ab Initio
8 3 (1.62%) WorldPay
9 2 (1.08%) Cloudera
9 2 (1.08%) DataFlux
9 2 (1.08%) Hortonworks
9 2 (1.08%) MapR
City, London
TalentFlow
Rate: From £500 to £550 per day £500 to £550 per day
Posted: Yesterday
City, London
Nigel Frank International Ltd
Rate: £400 - £600 per day
Posted: 3 days ago
City, London
Venturi
Posted: Yesterday
City, London
Cadence Resourcing
Rate: On application
Posted: 6 days ago