Period
to 19 July 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 19 July 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
19 Jul 2018
Same period 2017 Same period 2016
Rank 104 101 107
Rank change year-on-year -3 +6 -39
Contract jobs citing ETL 1,234 1,094 1,107
As % of all contract IT jobs advertised in London 2.67% 2.61% 2.43%
As % of the Processes & Methodologies category 3.06% 3.00% 2.82%
Number of daily rates quoted 908 772 759
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% -
10th Percentile £325 £348 £313
90th Percentile £625 £625 £600
England median daily rate £463 £450 £425
% change year-on-year +2.78% +5.88% -
Number of hourly rates quoted 4 4 0
London median hourly rate £56.25 £40.00 -
Median hourly rate % change year-on-year +40.63% - -
England median hourly rate £43.00 £37.50 £20.50
% change year-on-year +14.67% +82.93% -37.88%

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,330 36,432 39,283
As % of all contract IT jobs advertised in London 87.31% 87.01% 86.31%
Number of daily rates quoted 29,255 26,045 28,454
London median daily rate £500 £488 £463
Median daily rate % change year-on-year +2.56% +5.41% +2.78%
10th Percentile £325 £313 £300
90th Percentile £675 £656 £650
England median daily rate £463 £450 £425
% change year-on-year +2.78% +5.88% +4.94%
Number of hourly rates quoted 548 389 357
London median hourly rate £24.75 £24.00 £21.34
Median hourly rate % change year-on-year +3.13% +12.46% +8.24%
10th Percentile £14.00 £12.86 £11.25
90th Percentile £53.75 £52.50 £49.78
England median hourly rate £22.50 £24.86 £23.75
% change year-on-year -9.49% +4.67% +13.10%

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 19 July 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
Contractor Hourly Rate Histogram in London

The hourly rate distribution of IT jobs citing ETL in London over the 6 months to 19 July 2018.

Contractor hourly rate histogram 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 19 July 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 +9 249 £488 -2.50% 128
East London -1 44 £500 -6.10% 7
South London -30 33 £550 +41.94% 6
West London -23 32 £400 -11.11% 28
North London +3 1 £388 +10.71% 4
ETL
England

For the 6 months to 19 July 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 787 (63.78%) SQL
2 507 (41.09%) Data Warehouse
3 439 (35.58%) Agile Software Development
4 417 (33.79%) Business Intelligence
5 397 (32.17%) SQL Server
6 374 (30.31%) Finance
7 347 (28.12%) Python
8 305 (24.72%) SQL Server Integration Services
9 291 (23.58%) Analytics
10 285 (23.10%) Big Data
11 257 (20.83%) Data Modelling
12 229 (18.56%) Java
12 229 (18.56%) Hadoop
13 227 (18.40%) Oracle
14 223 (18.07%) Amazon AWS
15 207 (16.77%) Microsoft
16 198 (16.05%) Apache Spark
17 194 (15.72%) SQL Server Reporting Services
18 188 (15.24%) T-SQL
18 188 (15.24%) Analytical Skills
19 185 (14.99%) Microsoft Azure
20 157 (12.72%) Apache Hive
21 153 (12.40%) Migration
22 140 (11.35%) SQL Server Analysis Services
23 139 (11.26%) C#
24 131 (10.62%) Scala
25 129 (10.45%) ETL Development
26 128 (10.37%) Linux
27 123 (9.97%) Power BI
28 121 (9.81%) Relational Database

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 198 (16.05%) Apache Spark
2 73 (5.92%) Apache
3 49 (3.97%) SAS
4 44 (3.57%) Elasticsearch
5 36 (2.92%) Apache Pig
5 36 (2.92%) SharePoint
6 22 (1.78%) Apache Solr
7 21 (1.70%) Confluence
8 16 (1.30%) Apache Airflow
9 12 (0.97%) Oracle Workflow
10 11 (0.89%) Tomcat
11 10 (0.81%) WebSphere
12 8 (0.65%) Oracle SOA Suite
13 7 (0.57%) IBM HTTP Server
13 7 (0.57%) nginx
14 6 (0.49%) IIS
15 4 (0.32%) Cloud Foundry
15 4 (0.32%) CMS
15 4 (0.32%) NServiceBus
15 4 (0.32%) SharePoint 2010
Applications
1 77 (6.24%) Microsoft Excel
2 31 (2.51%) Microsoft Office
3 29 (2.35%) MS Visio
4 10 (0.81%) Stata
5 8 (0.65%) Chatbot
5 8 (0.65%) SPSS
6 6 (0.49%) Microsoft Project
7 5 (0.41%) Microsoft PowerPoint
8 4 (0.32%) Spreadsheet
Business Applications
1 14 (1.13%) Markit EDM
2 11 (0.89%) Dynamics CRM
3 6 (0.49%) Dynamics AX
3 6 (0.49%) HFM
4 4 (0.32%) Dynamics NAV
4 4 (0.32%) Eagle PACE
4 4 (0.32%) Line 500
4 4 (0.32%) Sage X3
4 4 (0.32%) Salesforce.com CRM
4 4 (0.32%) SAP Oil and Gas
4 4 (0.32%) SAP S/4HANA
4 4 (0.32%) Unit4 Business World
5 3 (0.24%) Oracle EBS
5 3 (0.24%) thinkFolio
6 2 (0.16%) FastStats
6 2 (0.16%) Oracle BPM
6 2 (0.16%) PolarLake
6 2 (0.16%) SAP ECC
6 2 (0.16%) SAP HCM
6 2 (0.16%) Summit
Cloud Services
1 223 (18.07%) Amazon AWS
2 185 (14.99%) Microsoft Azure
3 70 (5.67%) Amazon S3
4 65 (5.27%) Google Cloud Platform
5 47 (3.81%) Amazon EC2
6 30 (2.43%) Azure Data Factory
7 27 (2.19%) Virtual Private Cloud
8 23 (1.86%) PaaS
9 22 (1.78%) Amazon EMR
9 22 (1.78%) Serverless
10 19 (1.54%) Amazon Kinesis
10 19 (1.54%) Google Analytics
11 14 (1.13%) Data Lake Analytics
12 12 (0.97%) IaaS
12 12 (0.97%) SaaS
13 11 (0.89%) AWS Lambda
14 10 (0.81%) Dynamics 365
14 10 (0.81%) GitHub
15 9 (0.73%) Amazon Glacier
15 9 (0.73%) Salesforce Service Cloud
Communications & Networking
1 19 (1.54%) Kerberos
2 12 (0.97%) VPN
3 9 (0.73%) DNS
4 6 (0.49%) HTTP
4 6 (0.49%) ICMP
4 6 (0.49%) SSL
4 6 (0.49%) TCP/IP
5 4 (0.32%) PuTTY
5 4 (0.32%) SMS
6 3 (0.24%) SAN
6 3 (0.24%) X.509
7 2 (0.16%) AMQP
7 2 (0.16%) Internet
7 2 (0.16%) Reverse Proxy
8 1 (0.081%) Firewall
8 1 (0.081%) FTP
8 1 (0.081%) MVNO
8 1 (0.081%) SSH
Database & Business Intelligence
1 507 (41.09%) Data Warehouse
2 397 (32.17%) SQL Server
3 305 (24.72%) SQL Server Integration Services
4 285 (23.10%) Big Data
5 229 (18.56%) Hadoop
6 194 (15.72%) SQL Server Reporting Services
7 157 (12.72%) Apache Hive
8 140 (11.35%) SQL Server Analysis Services
9 123 (9.97%) Power BI
10 121 (9.81%) Relational Database
11 113 (9.16%) Data Lake
12 99 (8.02%) NoSQL
13 98 (7.94%) Amazon Redshift
14 82 (6.65%) PostgreSQL
15 62 (5.02%) Impala
16 60 (4.86%) HBase
17 56 (4.54%) Oracle Database
18 54 (4.38%) SQL Server 2008
19 53 (4.29%) SQL Server 2012
20 52 (4.21%) MongoDB
Development Applications
1 83 (6.73%) Git (software)
2 72 (5.83%) Jenkins
3 63 (5.11%) Team Foundation Server
4 50 (4.05%) JIRA
5 38 (3.08%) Visual Studio
6 30 (2.43%) Visual Studio Team System
7 20 (1.62%) Octopus Deploy
8 18 (1.46%) Artifactory
8 18 (1.46%) SpecFlow
8 18 (1.46%) TeamCity
9 16 (1.30%) Selenium
10 15 (1.22%) Bitbucket
10 15 (1.22%) Maven
11 14 (1.13%) Subversion
12 12 (0.97%) SQL Server Management Studio (SSMS)
13 11 (0.89%) RStudio
14 10 (0.81%) tSQLt
15 9 (0.73%) ERwin
16 7 (0.57%) Moq
16 7 (0.57%) NUnit
General
1 374 (30.31%) Finance
2 113 (9.16%) Banking
3 59 (4.78%) Retail
4 31 (2.51%) Marketing
5 30 (2.43%) Investment Banking
6 21 (1.70%) Legal
7 20 (1.62%) Front Office
8 16 (1.30%) Games
9 12 (0.97%) Law
9 12 (0.97%) Publishing
10 8 (0.65%) Advertising
10 8 (0.65%) Financial Institution
11 7 (0.57%) Back Office
11 7 (0.57%) Pharmaceutical
11 7 (0.57%) Telecoms
12 5 (0.41%) Manufacturing
13 4 (0.32%) Retail Banking
14 3 (0.24%) Electronics
14 3 (0.24%) Private Banking
15 2 (0.16%) General Ledger
Job Titles
1 479 (38.82%) Developer
2 227 (18.40%) Data Engineer
3 146 (11.83%) Analyst
4 136 (11.02%) Business Intelligence Developer
5 129 (10.45%) Architect
6 127 (10.29%) SQL Developer
7 106 (8.59%) ETL Developer
8 89 (7.21%) Big Data Engineer
9 74 (6.00%) Data Analyst
10 67 (5.43%) Data Architect
11 61 (4.94%) Python Engineer
12 59 (4.78%) SSIS Developer
13 56 (4.54%) AWS Engineer
14 46 (3.73%) Consultant
15 38 (3.08%) SQL BI Developer
16 36 (2.92%) Senior Data Engineer
17 33 (2.67%) Hadoop Engineer
17 33 (2.67%) Platform Engineer
17 33 (2.67%) Python Developer
18 31 (2.51%) Big Data Developer
Libraries, Frameworks & Software Standards
1 107 (8.67%) XML
2 105 (8.51%) .NET
3 103 (8.35%) Kafka
4 68 (5.51%) Web Services
5 53 (4.29%) JSON
6 40 (3.24%) REST
7 25 (2.03%) Middleware
8 21 (1.70%) ASP.NET Web API
8 21 (1.70%) MDX
8 21 (1.70%) Natural Language Processing
8 21 (1.70%) Spring
8 21 (1.70%) Spring Boot
9 19 (1.54%) WCF
10 18 (1.46%) ASP.NET
10 18 (1.46%) SOAP
11 17 (1.38%) AngularJS
11 17 (1.38%) ASP.NET MVC
11 17 (1.38%) LDAP
12 16 (1.30%) RESTful
13 14 (1.13%) React
Miscellaneous
1 188 (15.24%) Analytical Skills
2 57 (4.62%) Fintech
3 46 (3.73%) Data Structures
4 44 (3.57%) Computer Science
5 41 (3.32%) Greenfield Project
6 40 (3.24%) Algorithms
7 30 (2.43%) Management Information System
8 24 (1.94%) Self-Motivation
9 21 (1.70%) User Experience
10 19 (1.54%) Replication
11 17 (1.38%) Credit Risk
11 17 (1.38%) Fixed Income
11 17 (1.38%) Wiki
12 16 (1.30%) Reference Data
13 14 (1.13%) Derivative
13 14 (1.13%) Market Risk
13 14 (1.13%) Reinsurance
14 11 (0.89%) Virtual Team
15 10 (0.81%) Enterprise Software
15 10 (0.81%) Foreign Exchange (FX)
Operating Systems
1 128 (10.37%) Linux
2 81 (6.56%) Unix
3 45 (3.65%) Windows
4 15 (1.22%) Red Hat Enterprise Linux
5 8 (0.65%) Ubuntu
6 6 (0.49%) Solaris
7 5 (0.41%) Windows Server
7 5 (0.41%) Windows Server 2008
8 4 (0.32%) CentOS
8 4 (0.32%) Windows 10
8 4 (0.32%) Windows 7
8 4 (0.32%) Windows Server 2003
9 3 (0.24%) AIX
10 1 (0.081%) Mac OS X
10 1 (0.081%) MVS
10 1 (0.081%) Windows Server 2012
Processes & Methodologies
1 439 (35.58%) Agile Software Development
2 417 (33.79%) Business Intelligence
3 291 (23.58%) Analytics
4 257 (20.83%) Data Modelling
5 153 (12.40%) Migration
6 129 (10.45%) ETL Development
7 114 (9.24%) Data Analysis
8 112 (9.08%) Data Migration
8 112 (9.08%) Problem-Solving
9 110 (8.91%) Data Integration
9 110 (8.91%) Data Science
10 104 (8.43%) Scrum
11 100 (8.10%) Visualisation
12 97 (7.86%) DevOps
13 88 (7.13%) Test Automation
14 81 (6.56%) Data Management
15 79 (6.40%) Performance Tuning
16 78 (6.32%) Continuous Integration
17 74 (6.00%) Data Engineering
18 65 (5.27%) Kimball Methodology
Programming Languages
1 787 (63.78%) SQL
2 347 (28.12%) Python
3 229 (18.56%) Java
4 188 (15.24%) T-SQL
5 139 (11.26%) C#
6 131 (10.62%) Scala
7 81 (6.56%) R
8 72 (5.83%) PL/SQL
9 50 (4.05%) Bash Shell
10 48 (3.89%) PowerShell
11 46 (3.73%) JavaScript
12 40 (3.24%) Shell Script
13 23 (1.86%) Ruby
14 21 (1.70%) VBA
15 19 (1.54%) Korn
15 19 (1.54%) MATLAB
15 19 (1.54%) Perl
16 13 (1.05%) C
16 13 (1.05%) Data Analysis Expressions (DAX)
16 13 (1.05%) VB.NET
Qualifications
1 69 (5.59%) Security Cleared
2 58 (4.70%) Degree
3 52 (4.21%) SC Cleared
4 30 (2.43%) DV Cleared
5 15 (1.22%) Computer Science Degree
6 10 (0.81%) PhD
7 9 (0.73%) ISEB
7 9 (0.73%) Numerate Degree
8 7 (0.57%) BPSS Clearance
9 5 (0.41%) ISTQB
9 5 (0.41%) PMP
10 4 (0.32%) DBS Check
10 4 (0.32%) Master's Degree
10 4 (0.32%) PMI Certification
11 2 (0.16%) ITIL Certification
11 2 (0.16%) TOGAF Certification
12 1 (0.081%) CTC Cleared
12 1 (0.081%) ISTQB Advanced Certification
12 1 (0.081%) ISTQB Foundation Certification
12 1 (0.081%) OSCP
Quality Assurance & Compliance
1 102 (8.27%) Data Quality
2 48 (3.89%) QA
3 29 (2.35%) GCP
4 25 (2.03%) GDPR
5 13 (1.05%) IFRS
5 13 (1.05%) IFRS 9
6 7 (0.57%) MiFID
7 6 (0.49%) PMO
8 5 (0.41%) EMIR
9 3 (0.24%) Dodd-Frank
9 3 (0.24%) Solvency II
10 2 (0.16%) ISO 20022
10 2 (0.16%) SEPA
11 1 (0.081%) HL7
11 1 (0.081%) Sarbanes-Oxley
11 1 (0.081%) SLA
System Software
1 71 (5.75%) HDFS
2 63 (5.11%) Docker
3 30 (2.43%) Apache Flume
4 6 (0.49%) Active Directory
5 5 (0.41%) Apache ZooKeeper
6 4 (0.32%) Virtual Machines
7 1 (0.081%) Hyper-V
7 1 (0.081%) Veritas Cluster Server
7 1 (0.081%) Virtual Servers
7 1 (0.081%) VMware ESXi
7 1 (0.081%) VMware Infrastructure
Systems Management
1 50 (4.05%) Hadoop YARN
2 46 (3.73%) Ansible
3 34 (2.76%) Oozie
4 30 (2.43%) Opscode Chef
5 24 (1.94%) Kubernetes
6 21 (1.70%) Puppet
7 19 (1.54%) Control-M
7 19 (1.54%) Terraform
8 8 (0.65%) Ambari
9 7 (0.57%) Consul
9 7 (0.57%) Single Sign-On
10 6 (0.49%) Host Intrusion Detection System
10 6 (0.49%) MOM
10 6 (0.49%) Network Intrusion Detection System
10 6 (0.49%) Prometheus
10 6 (0.49%) Sysdig
11 5 (0.41%) HAProxy
12 4 (0.32%) Kibana
13 3 (0.24%) WhatsUp Gold
13 3 (0.24%) WMI
Vendors
1 227 (18.40%) Oracle
2 207 (16.77%) Microsoft
3 118 (9.56%) Tableau
4 111 (9.00%) Informatica
5 74 (6.00%) SAP
6 71 (5.75%) Cloudera
7 67 (5.43%) Google
8 60 (4.86%) Talend
9 48 (3.89%) Salesforce.com
10 43 (3.48%) IBM
11 35 (2.84%) Hortonworks
12 32 (2.59%) Cognos
13 26 (2.11%) Alteryx
14 24 (1.94%) Red Hat
14 24 (1.94%) Splunk
15 22 (1.78%) Teradata
16 20 (1.62%) Ab Initio
17 16 (1.30%) MicroStrategy
18 13 (1.05%) Atlassian
19 12 (0.97%) Netezza