Period
to 23 October 2018

The following table provides summary statistics for contract job vacancies advertised in 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 6 months to 23 October 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 > London
6 months to
23 Oct 2018
Same period 2017 Same period 2016
Rank 105 103 101
Rank change year-on-year -2 -2 -28
Contract jobs citing ETL 1,172 1,171 1,158
As % of all contract IT jobs advertised in London 2.53% 2.57% 2.61%
As % of the Processes & Methodologies category 2.90% 2.92% 3.00%
Number of daily rates quoted 848 848 780
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% -
10th Percentile £350 £354 £324
90th Percentile £625 £625 £638
England median daily rate £455 £450 £425
% change year-on-year +1.11% +5.88% -
Number of hourly rates quoted 1 5 7
London median hourly rate £47.50 £40.00 £45.00
Median hourly rate % change year-on-year +18.75% -11.11% +95.65%
10th Percentile £47.25 £37.75 £40.60
90th Percentile £47.75 £52.00 £123.45
England median hourly rate £35.00 £45.00 £44.00
% change year-on-year -22.22% +2.27% +67.62%

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

All Process and Methodology Skills
London
Contract vacancies with a requirement for process or methodology skills 40,458 40,068 38,608
As % of all contract IT jobs advertised in London 87.48% 88.05% 87.16%
Number of daily rates quoted 29,218 29,022 27,755
London median daily rate £500 £500 £464
Median daily rate % change year-on-year - +7.76% +3.11%
10th Percentile £325 £313 £300
90th Percentile £675 £663 £643
England median daily rate £473 £450 £425
% change year-on-year +5.00% +5.88% +3.03%
Number of hourly rates quoted 469 367 405
London median hourly rate £21.25 £23.00 £21.50
Median hourly rate % change year-on-year -7.61% +6.98% +7.50%
10th Percentile £13.00 £13.14 £11.44
90th Percentile £52.75 £50.50 £52.50
England median hourly rate £21.00 £24.93 £22.50
% change year-on-year -15.75% +10.78% +3.97%

ETL
Job Vacancy Trend in London

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

Job vacancy trend for ETL in London

ETL
Contractor Daily Rate Trend in London

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

Contractor daily rate trend for ETL in London

ETL
Contractor Daily Rate Histogram in London

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

Contractor daily rate histogram for ETL in London

ETL
Contractor Hourly Rate Trend in London

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

Contractor hourly rate trend for ETL in London

ETL
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the London region over the 6 months to 23 October 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
Central London +1 234 £475 -5.00% 71
South London +3 49 £525 +5.00% 5
East London -5 33 £500 +7.53% 8
West London -6 29 £409 -13.95% 53
North London -3 4 £525 +50.00% 5
ETL
England

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

1 753 (64.25%) SQL
2 477 (40.70%) SQL Server
3 463 (39.51%) Data Warehouse
4 440 (37.54%) Agile Software Development
5 426 (36.35%) Business Intelligence
6 370 (31.57%) Finance
7 363 (30.97%) SQL Server Integration Services
8 317 (27.05%) Python
9 253 (21.59%) Amazon AWS
10 248 (21.16%) Oracle
11 234 (19.97%) Microsoft
12 232 (19.80%) Big Data
13 228 (19.45%) Analytics
14 207 (17.66%) Hadoop
14 207 (17.66%) SQL Server Reporting Services
15 202 (17.24%) Analytical Skills
16 193 (16.47%) Microsoft Azure
17 183 (15.61%) Data Modelling
18 174 (14.85%) T-SQL
18 174 (14.85%) SQL Server Analysis Services
19 165 (14.08%) Java
20 162 (13.82%) Scrum
21 158 (13.48%) Data Analysis
22 143 (12.20%) Power BI
23 142 (12.12%) Apache Hive
23 142 (12.12%) Apache Spark
24 134 (11.43%) Banking
25 128 (10.92%) Test Automation
26 127 (10.84%) Unix
27 125 (10.67%) Migration

ETL
Co-occurring IT Skills in 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 142 (12.12%) Apache Spark
2 46 (3.92%) Apache
3 39 (3.33%) SAS
4 32 (2.73%) Elasticsearch
5 26 (2.22%) SharePoint
6 25 (2.13%) Confluence
7 24 (2.05%) Apache Pig
8 15 (1.28%) Apache Solr
9 12 (1.02%) Apache Airflow
10 11 (0.94%) WebSphere
11 7 (0.60%) Cloud Foundry
11 7 (0.60%) CMS
12 6 (0.51%) NServiceBus
12 6 (0.51%) Tomcat
13 5 (0.43%) IIS
14 4 (0.34%) Oracle SOA Suite
15 3 (0.26%) Alfresco
15 3 (0.26%) Oracle Workflow
16 2 (0.17%) nginx
16 2 (0.17%) SharePoint 2010
Applications
1 114 (9.73%) Microsoft Excel
2 52 (4.44%) MS Visio
3 26 (2.22%) Microsoft Office
4 11 (0.94%) Spreadsheet
5 4 (0.34%) Microsoft Project
6 3 (0.26%) Chatbot
6 3 (0.26%) Microsoft PowerPoint
7 2 (0.17%) Mathematica
7 2 (0.17%) SPSS
8 1 (0.085%) Stata
Business Applications
1 16 (1.37%) Markit EDM
2 14 (1.19%) Dynamics CRM
3 9 (0.77%) Dynamics AX
4 6 (0.51%) Dynamics NAV
5 5 (0.43%) Oracle ERP
5 5 (0.43%) SAP Oil and Gas
6 4 (0.34%) SAP S/4HANA
6 4 (0.34%) Unit4 Business World
7 3 (0.26%) Oracle Retail
8 2 (0.17%) Eagle PACE
8 2 (0.17%) HFM
8 2 (0.17%) Line 500
8 2 (0.17%) NetSuite
8 2 (0.17%) Oracle BPM
8 2 (0.17%) Oracle Procure-to-Pay
8 2 (0.17%) PolarLake
8 2 (0.17%) Sage X3
8 2 (0.17%) SAP HCM
8 2 (0.17%) SAP MDG
9 1 (0.085%) Sage CRM
Cloud Services
1 253 (21.59%) Amazon AWS
2 193 (16.47%) Microsoft Azure
3 107 (9.13%) Amazon S3
4 77 (6.57%) Amazon EC2
5 67 (5.72%) Google Cloud Platform
6 59 (5.03%) Virtual Private Cloud
7 36 (3.07%) Amazon EMR
8 23 (1.96%) GitHub
9 22 (1.88%) Azure Data Factory
10 19 (1.62%) Serverless
11 17 (1.45%) AWS Lambda
12 14 (1.19%) Dynamics 365
13 13 (1.11%) Amazon Glacier
13 13 (1.11%) Amazon Kinesis
13 13 (1.11%) PaaS
14 10 (0.85%) Google Analytics
15 9 (0.77%) Data Lake Analytics
15 9 (0.77%) IaaS
16 8 (0.68%) SaaS
17 7 (0.60%) Salesforce Service Cloud
Communications & Networking
1 16 (1.37%) Kerberos
2 5 (0.43%) VPN
3 4 (0.34%) SSL
4 3 (0.26%) Intranet
5 2 (0.17%) FTP
5 2 (0.17%) SMS
6 1 (0.085%) AMQP
6 1 (0.085%) DNS
6 1 (0.085%) Firewall
6 1 (0.085%) HTTP
6 1 (0.085%) ICMP
6 1 (0.085%) MVNO
6 1 (0.085%) Reverse Proxy
6 1 (0.085%) SAN
6 1 (0.085%) SSH
6 1 (0.085%) TCP/IP
Database & Business Intelligence
1 477 (40.70%) SQL Server
2 463 (39.51%) Data Warehouse
3 363 (30.97%) SQL Server Integration Services
4 232 (19.80%) Big Data
5 207 (17.66%) Hadoop
5 207 (17.66%) SQL Server Reporting Services
6 174 (14.85%) SQL Server Analysis Services
7 143 (12.20%) Power BI
8 142 (12.12%) Apache Hive
9 118 (10.07%) Relational Database
10 101 (8.62%) Data Lake
11 88 (7.51%) NoSQL
12 80 (6.83%) SQL Server 2016
13 71 (6.06%) SQL Server 2008
14 70 (5.97%) Impala
15 68 (5.80%) Amazon Redshift
16 67 (5.72%) Sqoop
17 55 (4.69%) SQL Server 2012
18 54 (4.61%) Oracle Database
19 52 (4.44%) Microsoft Analysis Services
Development Applications
1 97 (8.28%) Jenkins
2 96 (8.19%) Git (software)
3 80 (6.83%) JIRA
4 72 (6.14%) Team Foundation Server
5 46 (3.92%) Visual Studio
6 39 (3.33%) Visual Studio Team System
7 30 (2.56%) Selenium
8 25 (2.13%) Octopus Deploy
9 19 (1.62%) Bitbucket
9 19 (1.62%) SpecFlow
10 16 (1.37%) Artifactory
11 13 (1.11%) ERwin
12 12 (1.02%) TeamCity
13 11 (0.94%) Eclipse
13 11 (0.94%) Maven
13 11 (0.94%) Subversion
14 8 (0.68%) SQL Server Management Studio (SSMS)
15 7 (0.60%) Moq
15 7 (0.60%) NUnit
16 6 (0.51%) ReSharper
General
1 370 (31.57%) Finance
2 134 (11.43%) Banking
3 53 (4.52%) Retail
4 38 (3.24%) Investment Banking
5 33 (2.82%) Marketing
6 30 (2.56%) Front Office
6 30 (2.56%) Publishing
7 28 (2.39%) Back Office
8 21 (1.79%) Legal
9 19 (1.62%) Financial Institution
10 13 (1.11%) Games
11 11 (0.94%) Law
12 9 (0.77%) Pharmaceutical
13 8 (0.68%) Retail Banking
13 8 (0.68%) Telecoms
14 7 (0.60%) Advertising
14 7 (0.60%) General Ledger
15 4 (0.34%) Manufacturing
16 2 (0.17%) Electronics
16 2 (0.17%) Spanish Language
Job Titles
1 525 (44.80%) Developer
2 187 (15.96%) Data Engineer
3 168 (14.33%) Business Intelligence Developer
4 126 (10.75%) SQL Developer
5 122 (10.41%) Analyst
6 117 (9.98%) ETL Developer
7 84 (7.17%) Architect
8 64 (5.46%) Big Data Engineer
9 60 (5.12%) Data Analyst
9 60 (5.12%) SSIS Developer
10 57 (4.86%) Consultant
11 47 (4.01%) Platform Engineer
12 45 (3.84%) SQL BI Developer
13 44 (3.75%) Data Architect
14 41 (3.50%) Python Engineer
15 38 (3.24%) AWS Engineer
15 38 (3.24%) Data Warehouse Developer
16 36 (3.07%) Senior Developer
17 33 (2.82%) SQL Analyst
18 31 (2.65%) Oracle Developer
Libraries, Frameworks & Software Standards
1 89 (7.59%) .NET
1 89 (7.59%) XML
2 83 (7.08%) Web Services
3 81 (6.91%) Kafka
4 58 (4.95%) JSON
5 31 (2.65%) Middleware
5 31 (2.65%) REST
6 30 (2.56%) ASP.NET Web API
7 29 (2.47%) AngularJS
7 29 (2.47%) React
8 26 (2.22%) RESTful
9 24 (2.05%) MDX
10 23 (1.96%) WCF
11 20 (1.71%) ASP.NET
12 19 (1.62%) .NET Core
12 19 (1.62%) ASP.NET MVC
12 19 (1.62%) HTML
12 19 (1.62%) KnockoutJS
12 19 (1.62%) ServiceStack
12 19 (1.62%) Spark Streaming
Miscellaneous
1 202 (17.24%) Analytical Skills
2 66 (5.63%) Greenfield Project
3 46 (3.92%) Wiki
4 45 (3.84%) Computer Science
5 42 (3.58%) Algorithms
5 42 (3.58%) Fintech
6 27 (2.30%) Data Structures
6 27 (2.30%) Replication
6 27 (2.30%) User Experience
7 24 (2.05%) Fixed Income
8 20 (1.71%) Equities
9 18 (1.54%) Enterprise Software
10 16 (1.37%) Self-Motivation
11 15 (1.28%) Management Information System
12 14 (1.19%) Virtual Team
13 13 (1.11%) Reinsurance
14 10 (0.85%) Hedge funds
15 8 (0.68%) Mobile App
15 8 (0.68%) Reference Data
16 7 (0.60%) Credit Risk
Operating Systems
1 127 (10.84%) Unix
2 109 (9.30%) Linux
3 71 (6.06%) Windows
4 18 (1.54%) Red Hat Enterprise Linux
5 10 (0.85%) Ubuntu
5 10 (0.85%) Windows Server
6 4 (0.34%) AIX
6 4 (0.34%) CentOS
7 2 (0.17%) Apple iOS
7 2 (0.17%) DC/OS
7 2 (0.17%) Solaris
7 2 (0.17%) Windows 10
7 2 (0.17%) Windows 7
8 1 (0.085%) Mac OS X
8 1 (0.085%) Oracle Linux
8 1 (0.085%) Windows Server 2008
Processes & Methodologies
1 440 (37.54%) Agile Software Development
2 426 (36.35%) Business Intelligence
3 228 (19.45%) Analytics
4 183 (15.61%) Data Modelling
5 162 (13.82%) Scrum
6 158 (13.48%) Data Analysis
7 128 (10.92%) Test Automation
8 125 (10.67%) Migration
9 114 (9.73%) Continuous Integration
10 110 (9.39%) Problem-Solving
11 108 (9.22%) ETL Development
12 101 (8.62%) Performance Tuning
13 98 (8.36%) Kimball Methodology
14 93 (7.94%) Visualisation
15 87 (7.42%) Data Migration
16 86 (7.34%) DevOps
17 82 (7.00%) Data Science
18 80 (6.83%) Data Integration
19 77 (6.57%) Asset Management
20 68 (5.80%) SDLC
Programming Languages
1 753 (64.25%) SQL
2 317 (27.05%) Python
3 174 (14.85%) T-SQL
4 165 (14.08%) Java
5 117 (9.98%) C#
6 116 (9.90%) Scala
7 78 (6.66%) Bash Shell
8 73 (6.23%) PowerShell
9 71 (6.06%) PL/SQL
10 63 (5.38%) Shell Script
11 57 (4.86%) JavaScript
12 54 (4.61%) R
13 48 (4.10%) Korn
14 29 (2.47%) VBA
15 27 (2.30%) VB
16 25 (2.13%) Data Analysis Expressions (DAX)
17 24 (2.05%) MATLAB
18 21 (1.79%) Perl
19 14 (1.19%) C
19 14 (1.19%) Ruby
Qualifications
1 44 (3.75%) Degree
2 40 (3.41%) Security Cleared
3 29 (2.47%) SC Cleared
4 17 (1.45%) Computer Science Degree
5 11 (0.94%) Master's Degree
6 8 (0.68%) PhD
7 5 (0.43%) Numerate Degree
8 4 (0.34%) PMI Certification
9 3 (0.26%) ISEB
9 3 (0.26%) Microsoft Certification
9 3 (0.26%) PMP
10 2 (0.17%) DV Cleared
10 2 (0.17%) ISTQB
10 2 (0.17%) MCSE
11 1 (0.085%) BC Cleared
11 1 (0.085%) CRISC
11 1 (0.085%) ISACA
11 1 (0.085%) MCITP
11 1 (0.085%) MCTS
11 1 (0.085%) OSCP
Quality Assurance & Compliance
1 86 (7.34%) Data Quality
2 66 (5.63%) QA
3 16 (1.37%) GDPR
4 6 (0.51%) GCP
4 6 (0.51%) IFRS
5 5 (0.43%) IFRS 9
5 5 (0.43%) MiFID
6 4 (0.34%) PMO
6 4 (0.34%) Solvency II
7 3 (0.26%) EMIR
8 2 (0.17%) Basel III
8 2 (0.17%) ISO 20022
8 2 (0.17%) SEPA
9 1 (0.085%) Dodd-Frank
9 1 (0.085%) HL7
9 1 (0.085%) Sarbanes-Oxley
System Software
1 74 (6.31%) HDFS
2 58 (4.95%) Docker
3 18 (1.54%) Apache Flume
4 5 (0.43%) Oracle RAC
5 4 (0.34%) Active Directory
5 4 (0.34%) Virtual Machines
6 3 (0.26%) Apache ZooKeeper
7 1 (0.085%) Cronacle
7 1 (0.085%) Hyper-V
7 1 (0.085%) Veritas Cluster Server
7 1 (0.085%) VMware ESXi
Systems Management
1 91 (7.76%) Ansible
2 70 (5.97%) Hadoop YARN
3 69 (5.89%) Opscode Chef
4 53 (4.52%) Puppet
5 35 (2.99%) Kubernetes
6 17 (1.45%) Oozie
7 12 (1.02%) Control-M
8 11 (0.94%) Kibana
8 11 (0.94%) logstash
9 7 (0.60%) Terraform
10 4 (0.34%) Failover Clustering
11 3 (0.26%) Marathon
11 3 (0.26%) Mesos
11 3 (0.26%) Microsoft Clustering
12 2 (0.17%) Ambari
12 2 (0.17%) Apache Brooklyn
12 2 (0.17%) Consul
12 2 (0.17%) HP ALM
12 2 (0.17%) Packer
12 2 (0.17%) WhatsUp Gold
Vendors
1 248 (21.16%) Oracle
2 234 (19.97%) Microsoft
3 120 (10.24%) Tableau
4 101 (8.62%) Informatica
5 66 (5.63%) Cloudera
6 65 (5.55%) SAP
7 64 (5.46%) Talend
8 55 (4.69%) Google
9 36 (3.07%) IBM
10 30 (2.56%) Alteryx
11 29 (2.47%) Ab Initio
12 27 (2.30%) Salesforce.com
13 26 (2.22%) Splunk
14 19 (1.62%) Teradata
15 18 (1.54%) Hortonworks
16 16 (1.37%) Red Hat
17 14 (1.19%) Atlassian
18 11 (0.94%) Cognos
18 11 (0.94%) RedGate
19 10 (0.85%) MicroStrategy