Period
to 28 May 2020

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 28 May 2020 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
28 May 2020
Same period 2019 Same period 2018
Rank 83 89 93
Rank change year-on-year +6 +4 +6
Contract jobs citing ETL 548 1,150 1,250
As % of all contract jobs advertised in London 2.83% 2.87% 2.74%
As % of the Processes & Methodologies category 3.20% 3.22% 3.10%
Number of daily rates quoted 370 843 928
Median daily rate £500 £485 £500
Median daily rate % change year-on-year +3.09% -3.00% +5.26%
10th Percentile £363 £351 £325
90th Percentile £675 £650 £638
England median daily rate £475 £463 £470
% change year-on-year +2.70% -1.60% +4.44%
Number of hourly rates quoted 4 5 3
Median hourly rate £35.00 £35.00 £65.00
Median hourly rate % change year-on-year - -46.15% +118.01%
England median hourly rate £35.00 £35.00 £47.50
% change year-on-year - -26.32% +42.86%

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 17,122 35,764 40,320
As % of all contract IT jobs advertised in London 88.42% 89.13% 88.50%
Number of daily rates quoted 11,778 25,475 29,121
Median daily rate £525 £520 £500
Median daily rate % change year-on-year +0.96% +4.00% +5.26%
10th Percentile £325 £338 £325
90th Percentile £700 £675 £675
England median daily rate £475 £475 £463
% change year-on-year - +2.70% +2.78%
Number of hourly rates quoted 294 403 564
Median hourly rate £35.00 £25.50 £25.00
Median hourly rate % change year-on-year +37.25% +2.00% -
10th Percentile £15.00 £12.50 £13.83
90th Percentile £54.63 £53.75 £50.35
Median hourly rate £28.00 £24.91 £22.00
% change year-on-year +12.40% +13.23% -13.73%

ETL
Job Vacancy Trend in London

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

Job vacancy trend for ETL in London

ETL
Contractor Daily Rate Trend in London

3-month moving average daily rate quoted in jobs citing ETL in London.

Daily rate trend for ETL in London

ETL
Daily Rate Histogram in London

Daily rate distribution for jobs citing ETL in London over the 6 months to 28 May 2020.

Daily rate histogram for ETL in London

ETL
Contractor Hourly Rate Trend in London

3-month moving average hourly rates quoted in jobs citing ETL in London.

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 28 May 2020. 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 +36 126 £510 +7.37% 7
South London +22 24 £475 +3.26% 10
West London +33 10 £425 - 4
East London +38 3 £315 -40.71% 1
North London +18 1 - -
ETL
England

For the 6 months to 28 May 2020, 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 352 (64.23%) SQL
2 238 (43.43%) Data Warehouse
3 225 (41.06%) Business Intelligence
4 213 (38.87%) Agile Software Development
5 160 (29.20%) SQL Server
6 154 (28.10%) Data Modelling
6 154 (28.10%) Azure
7 149 (27.19%) Finance
8 131 (23.91%) SQL Server Integration Services
9 129 (23.54%) Python
10 127 (23.18%) Analytics
11 125 (22.81%) Microsoft
12 108 (19.71%) AWS
13 107 (19.53%) DevOps
14 105 (19.16%) Migration
15 87 (15.88%) Big Data
15 87 (15.88%) Power Platform
16 85 (15.51%) Power BI
17 82 (14.96%) Oracle
18 78 (14.23%) Kimball Methodology
19 69 (12.59%) Analytical Skills
19 69 (12.59%) Data Engineering
19 69 (12.59%) T-SQL
20 66 (12.04%) Apache Spark
21 64 (11.68%) Hadoop
22 60 (10.95%) Git (software)
22 60 (10.95%) Java
23 59 (10.77%) SQL Server Analysis Services
23 59 (10.77%) Data Migration
23 59 (10.77%) SQL Server Reporting Services

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 66 (12.04%) Apache Spark
2 24 (4.38%) SAS
3 17 (3.10%) Confluence
4 14 (2.55%) Elasticsearch
5 11 (2.01%) WebLogic
6 8 (1.46%) Apache Airflow
7 7 (1.28%) Apache
8 6 (1.09%) Apache Pig
8 6 (1.09%) Oracle Workflow
9 4 (0.73%) IBM Notes
9 4 (0.73%) SharePoint
10 3 (0.55%) Apache Pulsar
10 3 (0.55%) Oracle Application Server
11 2 (0.36%) CMS
11 2 (0.36%) Oracle 10gAS
11 2 (0.36%) Oracle SOA Suite
12 1 (0.18%) IBM Domino
12 1 (0.18%) IBM HTTP Server
12 1 (0.18%) IIS
12 1 (0.18%) Tomcat
Applications
1 49 (8.94%) Microsoft Excel
2 6 (1.09%) Microsoft Office
3 4 (0.73%) Microsoft PowerPoint
3 4 (0.73%) Photoshop
4 3 (0.55%) Adobe Illustrator
4 3 (0.55%) InDesign
5 2 (0.36%) Chatbot
5 2 (0.36%) Microsoft Project
5 2 (0.36%) Stata
6 1 (0.18%) MS Visio
6 1 (0.18%) SPSS
Business Applications
1 4 (0.73%) FINCAD Analytics
2 3 (0.55%) Dynamics CRM
2 3 (0.55%) Dynamics NAV
2 3 (0.55%) SAP MDM
2 3 (0.55%) SAP S/4HANA
3 2 (0.36%) Markit EDM
3 2 (0.36%) NetSuite
3 2 (0.36%) PolarLake
3 2 (0.36%) SAP ERP
3 2 (0.36%) SAP PM
4 1 (0.18%) Magento
4 1 (0.18%) Oracle EBS
4 1 (0.18%) Sage BI
4 1 (0.18%) SAP CRM
4 1 (0.18%) SAP Hybris
4 1 (0.18%) Shopify
4 1 (0.18%) Sparx Enterprise Architect
Cloud Services
1 154 (28.10%) Azure
2 108 (19.71%) AWS
3 87 (15.88%) Power Platform
4 59 (10.77%) GCP
5 40 (7.30%) Azure Data Factory
6 20 (3.65%) Amazon S3
6 20 (3.65%) Serverless
7 18 (3.28%) PaaS
8 17 (3.10%) AWS Lambda
9 16 (2.92%) Amazon Kinesis
10 14 (2.55%) Amazon EC2
11 12 (2.19%) IaaS
12 10 (1.82%) Slack
13 9 (1.64%) Amazon EMR
14 7 (1.28%) Amazon Glacier
14 7 (1.28%) AWS CloudFormation
15 6 (1.09%) Amazon SQS
15 6 (1.09%) AWS Step Functions
15 6 (1.09%) GitHub
16 5 (0.91%) Office 365
Communications & Networking
1 3 (0.55%) DKIM
2 2 (0.36%) Firewall
2 2 (0.36%) Kerberos
3 1 (0.18%) Broadband
3 1 (0.18%) Internet
3 1 (0.18%) SAN
3 1 (0.18%) Skype
3 1 (0.18%) SMTP
3 1 (0.18%) Unified Communications
3 1 (0.18%) VPN
3 1 (0.18%) WebEx
Database & Business Intelligence
1 238 (43.43%) Data Warehouse
2 160 (29.20%) SQL Server
3 131 (23.91%) SQL Server Integration Services
4 87 (15.88%) Big Data
5 85 (15.51%) Power BI
6 64 (11.68%) Hadoop
7 59 (10.77%) SQL Server Analysis Services
7 59 (10.77%) SQL Server Reporting Services
8 54 (9.85%) Relational Database
9 53 (9.67%) NoSQL
10 45 (8.21%) Data Lake
11 41 (7.48%) Azure SQL Data Warehouse
12 40 (7.30%) Azure SQL Database
13 34 (6.20%) Amazon Redshift
14 32 (5.84%) MongoDB
15 30 (5.47%) Apache Hive
15 30 (5.47%) Microsoft Analysis Services
16 28 (5.11%) Snowflake Schema
17 25 (4.56%) PostgreSQL
18 24 (4.38%) MySQL
Development Applications
1 60 (10.95%) Git (software)
2 53 (9.67%) JIRA
3 31 (5.66%) Jenkins
4 25 (4.56%) SQL Server Management Studio (SSMS)
5 18 (3.28%) Visual Studio
6 15 (2.74%) Team Foundation Server
7 12 (2.19%) Visual Studio Team System
8 11 (2.01%) GitLab
9 10 (1.82%) Subversion
10 8 (1.46%) Postman
11 6 (1.09%) Selenium
11 6 (1.09%) Toad
12 4 (0.73%) ERwin
12 4 (0.73%) Gatling
12 4 (0.73%) JMeter
12 4 (0.73%) JUnit
13 3 (0.55%) ER Studio
13 3 (0.55%) Jasmine
13 3 (0.55%) Oracle Forms
14 2 (0.36%) Eclipse
General
1 149 (27.19%) Finance
2 36 (6.57%) Banking
3 25 (4.56%) Retail
4 24 (4.38%) Public Sector
5 15 (2.74%) Marketing
6 14 (2.55%) Legal
7 11 (2.01%) Telecoms
8 9 (1.64%) Publishing
9 8 (1.46%) Law
10 7 (1.28%) Front Office
11 6 (1.09%) Back Office
11 6 (1.09%) Investment Banking
12 5 (0.91%) Manufacturing
13 4 (0.73%) Billing
13 4 (0.73%) Financial Institution
14 2 (0.36%) Electronics
14 2 (0.36%) General Ledger
14 2 (0.36%) Local Government
15 1 (0.18%) Advertising
15 1 (0.18%) Pharmaceutical
Job Titles
1 179 (32.66%) Developer
2 129 (23.54%) Data Engineer
3 65 (11.86%) Architect
4 60 (10.95%) Analyst
5 57 (10.40%) SQL Developer
6 48 (8.76%) ETL Developer
7 39 (7.12%) Business Intelligence Developer
8 38 (6.93%) Data Architect
9 37 (6.75%) Azure Engineer
10 33 (6.02%) Consultant
11 29 (5.29%) AWS Engineer
12 22 (4.01%) Python Engineer
12 22 (4.01%) Technical Analyst
13 21 (3.83%) Business Analyst
13 21 (3.83%) Data Warehouse Developer
14 20 (3.65%) Big Data Engineer
15 18 (3.28%) SSIS Developer
16 16 (2.92%) Business Intelligence Analyst
17 15 (2.74%) Data Analyst
17 15 (2.74%) SQL Analyst
Libraries, Frameworks & Software Standards
1 48 (8.76%) Kafka
2 39 (7.12%) Web Services
2 39 (7.12%) XML
3 27 (4.93%) .NET
4 23 (4.20%) PySpark
5 18 (3.28%) REST
6 17 (3.10%) JSON
7 15 (2.74%) scikit-learn
7 15 (2.74%) TensorFlow
8 11 (2.01%) Apache NiFi
8 11 (2.01%) CSS
8 11 (2.01%) HTML
8 11 (2.01%) React
9 10 (1.82%) AngularJS
9 10 (1.82%) Keras
9 10 (1.82%) MDX
9 10 (1.82%) MLlib
10 9 (1.64%) Spring
10 9 (1.64%) XML Schema
11 8 (1.46%) RabbitMQ
Miscellaneous
1 69 (12.59%) Analytical Skills
2 23 (4.20%) Data Structures
3 16 (2.92%) Replication
4 14 (2.55%) Algorithms
5 13 (2.37%) Greenfield Project
6 11 (2.01%) Derivative
7 10 (1.82%) Fixed Income
7 10 (1.82%) Reinsurance
7 10 (1.82%) Self-Motivation
8 9 (1.64%) Management Information System
8 9 (1.64%) Public Cloud
9 8 (1.46%) Hedge funds
9 8 (1.46%) User Experience
10 6 (1.09%) Blog
10 6 (1.09%) Credit Risk
10 6 (1.09%) NHS
10 6 (1.09%) Taxonomies
11 5 (0.91%) Enterprise Software
11 5 (0.91%) Foreign Exchange (FX)
11 5 (0.91%) Reference Data
Operating Systems
1 48 (8.76%) Unix
2 36 (6.57%) Linux
3 11 (2.01%) Windows
4 3 (0.55%) Mac OS X
4 3 (0.55%) Solaris
4 3 (0.55%) Windows 10
4 3 (0.55%) Windows XP
5 2 (0.36%) Windows Server
5 2 (0.36%) Windows Server 2003
Processes & Methodologies
1 225 (41.06%) Business Intelligence
2 213 (38.87%) Agile Software Development
3 154 (28.10%) Data Modelling
4 127 (23.18%) Analytics
5 107 (19.53%) DevOps
6 105 (19.16%) Migration
7 78 (14.23%) Kimball Methodology
8 69 (12.59%) Data Engineering
9 59 (10.77%) Data Migration
10 52 (9.49%) Data Integration
11 51 (9.31%) Machine Learning
12 46 (8.39%) Visualisation
13 45 (8.21%) Performance Tuning
13 45 (8.21%) Scrum
14 43 (7.85%) ETL Development
14 43 (7.85%) SDLC
15 41 (7.48%) Data Analytics
15 41 (7.48%) Data Architecture
16 40 (7.30%) Data Science
17 35 (6.39%) Validation
Programming Languages
1 352 (64.23%) SQL
2 129 (23.54%) Python
3 69 (12.59%) T-SQL
4 60 (10.95%) Java
5 48 (8.76%) PL/SQL
6 38 (6.93%) Scala
7 34 (6.20%) JavaScript
8 31 (5.66%) C#
9 26 (4.74%) Shell Script
10 22 (4.01%) PowerShell
11 20 (3.65%) Data Analysis Expressions (DAX)
12 17 (3.10%) R
13 15 (2.74%) Ruby
14 13 (2.37%) Perl
15 11 (2.01%) VB
16 9 (1.64%) Bash Shell
16 9 (1.64%) C
16 9 (1.64%) SAS Macro
17 8 (1.46%) Go
18 7 (1.28%) TypeScript
Qualifications
1 37 (6.75%) Security Cleared
2 34 (6.20%) SC Cleared
3 18 (3.28%) Degree
4 9 (1.64%) BPSS Clearance
5 7 (1.28%) Computer Science Degree
6 6 (1.09%) Postgraduate
7 4 (0.73%) DBS Check
8 2 (0.36%) AWS Certification
8 2 (0.36%) DV Cleared
9 1 (0.18%) ACCA
9 1 (0.18%) CIMA
9 1 (0.18%) ISEB
9 1 (0.18%) ISTQB
9 1 (0.18%) Microsoft Certification
Quality Assurance & Compliance
1 37 (6.75%) Data Quality
2 26 (4.74%) QA
3 12 (2.19%) GDPR
4 11 (2.01%) Solvency II
5 10 (1.82%) IFRS
6 3 (0.55%) SLA
7 2 (0.36%) SNOMED CT
8 1 (0.18%) WCAG
System Software
1 28 (5.11%) Docker
2 13 (2.37%) HDFS
3 9 (1.64%) Virtual Machines
4 5 (0.91%) Apache Flume
5 2 (0.36%) Active Directory
Systems Management
1 38 (6.93%) Kubernetes
2 20 (3.65%) Terraform
3 13 (2.37%) Ansible
4 4 (0.73%) Control-M
4 4 (0.73%) Kibana
4 4 (0.73%) Kubeflow
5 3 (0.55%) Grafana
5 3 (0.55%) HP Quality Center
5 3 (0.55%) Oracle Statspack
6 2 (0.36%) Hadoop YARN
6 2 (0.36%) HP ALM
6 2 (0.36%) Oozie
6 2 (0.36%) Puppet
6 2 (0.36%) Single Sign-On
7 1 (0.18%) Ambari
7 1 (0.18%) Istio
7 1 (0.18%) linkerd
7 1 (0.18%) Microsoft Intune
7 1 (0.18%) Opscode Chef
7 1 (0.18%) Tivoli
Vendors
1 125 (22.81%) Microsoft
2 82 (14.96%) Oracle
3 58 (10.58%) Informatica
4 47 (8.58%) Tableau
5 37 (6.75%) Google
6 32 (5.84%) SAP
7 25 (4.56%) Databricks
8 24 (4.38%) Cloudera
9 21 (3.83%) Talend
10 16 (2.92%) MapR
11 15 (2.74%) IBM
12 12 (2.19%) Ab Initio
13 10 (1.82%) Alteryx
13 10 (1.82%) Hortonworks
14 7 (1.28%) Sybase
14 7 (1.28%) Teradata
15 6 (1.09%) Adobe
15 6 (1.09%) Salesforce.com
16 5 (0.91%) HP
16 5 (0.91%) MicroStrategy