Period
to 28 September 2020

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 6 months to 28 September 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)
Central London > City of London
6 months to
28 Sep 2020
Same period 2019 Same period 2018
Rank 70 65 92
Rank change year-on-year -5 +27 +8
Contract jobs citing ETL 46 225 198
As % of all contract jobs advertised in the City of London 2.59% 3.67% 2.84%
As % of the Processes & Methodologies category 2.94% 4.06% 3.26%
Number of daily rates quoted 26 174 170
Median daily rate £470 £500 £475
Median daily rate % change year-on-year -6.05% +5.26% -5.00%
10th Percentile £331 £375 £363
90th Percentile £674 £638 £613
Central London median daily rate £439 £500 £475
% change year-on-year -12.30% +5.26% -5.00%
Number of hourly rates quoted 0 1 0
Median hourly rate - £35.00 -
Central London median hourly rate - £35.00 -

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

All Process and Methodology Skills
City of London
Contract vacancies with a requirement for process or methodology skills 1,563 5,536 6,077
As % of all contract IT jobs advertised in the City of London 87.91% 90.24% 87.10%
Number of daily rates quoted 1,102 4,330 4,842
Median daily rate £510 £525 £503
Median daily rate % change year-on-year -2.86% +4.43% +0.55%
10th Percentile £313 £338 £328
90th Percentile £675 £675 £681
Central London median daily rate £510 £520 £500
% change year-on-year -1.92% +4.00% -
Number of hourly rates quoted 32 68 100
Median hourly rate £35.00 £18.33 £18.70
Median hourly rate % change year-on-year +90.94% -1.98% -
10th Percentile £15.00 £11.25 £13.23
90th Percentile £52.03 £52.00 £33.08
Median hourly rate £35.00 £19.75 £18.70
% change year-on-year +77.22% +5.61% -

ETL
Job Vacancy Trend in the City of London

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

Job vacancy trend for ETL in the City of London

ETL
Contractor Daily Rate Trend in the City of London

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

Daily rate trend for ETL in the City of London

ETL
Daily Rate Histogram in the City of London

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

Daily rate histogram for ETL in the City of London

ETL
Contractor Hourly Rate Trend in the City of London

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

Hourly rate trend for ETL in the City of London

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

1 33 (71.74%) SQL
2 19 (41.30%) Data Warehouse
3 18 (39.13%) Business Intelligence
4 17 (36.96%) Finance
5 15 (32.61%) Data Modelling
5 15 (32.61%) Azure
6 14 (30.43%) Microsoft
7 13 (28.26%) Python
8 12 (26.09%) Agile Software Development
9 11 (23.91%) Analytics
9 11 (23.91%) Power BI
9 11 (23.91%) Power Platform
10 10 (21.74%) SQL Server Integration Services
11 9 (19.57%) Oracle
11 9 (19.57%) SQL Server
11 9 (19.57%) Migration
12 8 (17.39%) Azure SQL Database
12 8 (17.39%) SQL Server Analysis Services
12 8 (17.39%) Data Integration
13 7 (15.22%) SC Cleared
13 7 (15.22%) Security Cleared
13 7 (15.22%) Hadoop
13 7 (15.22%) Big Data
13 7 (15.22%) Banking
13 7 (15.22%) Informatica
14 6 (13.04%) MySQL
14 6 (13.04%) Java
14 6 (13.04%) DevOps
14 6 (13.04%) Azure Data Factory
15 5 (10.87%) Problem-Solving

ETL
Co-occurring 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 5 (10.87%) Elasticsearch
2 4 (8.70%) Apache Spark
2 4 (8.70%) SAS
3 2 (4.35%) Confluence
4 1 (2.17%) MQSeries
Applications
1 3 (6.52%) Microsoft Excel
2 2 (4.35%) Microsoft Office
3 1 (2.17%) Microsoft PowerPoint
Business Applications
1 1 (2.17%) Dynamics GP
1 1 (2.17%) Magento
1 1 (2.17%) Shopify
Cloud Services
1 15 (32.61%) Azure
2 11 (23.91%) Power Platform
3 6 (13.04%) Azure Data Factory
4 5 (10.87%) AWS
5 2 (4.35%) IaaS
5 2 (4.35%) Power Automate
5 2 (4.35%) PowerApps
5 2 (4.35%) SaaS
6 1 (2.17%) AWS CloudFormation
6 1 (2.17%) GCP
6 1 (2.17%) PaaS
Database & Business Intelligence
1 19 (41.30%) Data Warehouse
2 11 (23.91%) Power BI
3 10 (21.74%) SQL Server Integration Services
4 9 (19.57%) SQL Server
5 8 (17.39%) Azure SQL Database
5 8 (17.39%) SQL Server Analysis Services
6 7 (15.22%) Big Data
6 7 (15.22%) Hadoop
7 6 (13.04%) MySQL
8 4 (8.70%) Data Lake
8 4 (8.70%) PostgreSQL
8 4 (8.70%) SQL Server Reporting Services
9 3 (6.52%) Azure SQL Data Warehouse
9 3 (6.52%) Enterprise Data Warehouse
9 3 (6.52%) NoSQL
9 3 (6.52%) OLAP
9 3 (6.52%) Relational Database
9 3 (6.52%) SAS EBI
10 2 (4.35%) Impala
10 2 (4.35%) RDBMS
Development Applications
1 4 (8.70%) GitLab
2 2 (4.35%) JIRA
2 2 (4.35%) VersionOne
3 1 (2.17%) Git (software)
3 1 (2.17%) Jenkins
3 1 (2.17%) Subversion
3 1 (2.17%) TeamCity
General
1 17 (36.96%) Finance
2 7 (15.22%) Banking
3 3 (6.52%) Public Sector
3 3 (6.52%) Retail
4 2 (4.35%) Billing
4 2 (4.35%) Marketing
5 1 (2.17%) Financial Institution
5 1 (2.17%) General Ledger
5 1 (2.17%) International Banking
5 1 (2.17%) Investment Banking
Job Titles
1 10 (21.74%) Analyst
1 10 (21.74%) Developer
2 9 (19.57%) Data Engineer
3 7 (15.22%) Architect
4 4 (8.70%) Business Intelligence Consultant
4 4 (8.70%) Consultant
4 4 (8.70%) DevOps Engineer
4 4 (8.70%) Power BI Consultant
5 3 (6.52%) Analyst Developer
5 3 (6.52%) Data Analyst
5 3 (6.52%) Data Architect
5 3 (6.52%) Data Warehouse Developer
5 3 (6.52%) ETL Analyst
6 2 (4.35%) Azure Consultant
6 2 (4.35%) Business Intelligence Analyst
6 2 (4.35%) Data Warehouse Analyst
6 2 (4.35%) ETL Developer
6 2 (4.35%) Lead Architect
6 2 (4.35%) Oracle Developer
6 2 (4.35%) Technical Analyst
Libraries, Frameworks & Software Standards
1 4 (8.70%) LDAP
1 4 (8.70%) RabbitMQ
2 3 (6.52%) Celery
2 3 (6.52%) XML
3 2 (4.35%) .NET
3 2 (4.35%) HTML
3 2 (4.35%) REST
4 1 (2.17%) .NET Core
4 1 (2.17%) Anaconda
4 1 (2.17%) J2EE
4 1 (2.17%) Kafka
4 1 (2.17%) Middleware
4 1 (2.17%) PySpark
4 1 (2.17%) SailPoint
4 1 (2.17%) Spring
4 1 (2.17%) Web Services
4 1 (2.17%) XML Schema
Miscellaneous
1 4 (8.70%) Management Information System
2 3 (6.52%) Analytical Skills
2 3 (6.52%) Blog
2 3 (6.52%) Greenfield Project
3 2 (4.35%) User Experience
4 1 (2.17%) CMDB
4 1 (2.17%) Enterprise Software
4 1 (2.17%) NHS
4 1 (2.17%) Public Cloud
4 1 (2.17%) Robotics
4 1 (2.17%) Tandem
4 1 (2.17%) Taxonomies
4 1 (2.17%) Virtual Team
Operating Systems
1 5 (10.87%) Linux
1 5 (10.87%) Unix
2 3 (6.52%) Mac OS X
Processes & Methodologies
1 18 (39.13%) Business Intelligence
2 15 (32.61%) Data Modelling
3 12 (26.09%) Agile Software Development
4 11 (23.91%) Analytics
5 9 (19.57%) Migration
6 8 (17.39%) Data Integration
7 6 (13.04%) DevOps
8 5 (10.87%) Data Migration
8 5 (10.87%) Kimball Methodology
8 5 (10.87%) Mentoring
8 5 (10.87%) Problem-Solving
9 4 (8.70%) Business Case
9 4 (8.70%) Configuration Management
9 4 (8.70%) Data Analysis
9 4 (8.70%) Data Engineering
9 4 (8.70%) Data Management
9 4 (8.70%) High Availability
9 4 (8.70%) Machine Learning
9 4 (8.70%) Performance Tuning
10 3 (6.52%) Change Management
Programming Languages
1 33 (71.74%) SQL
2 13 (28.26%) Python
3 6 (13.04%) Java
4 5 (10.87%) T-SQL
5 4 (8.70%) JavaScript
6 3 (6.52%) Data Analysis Expressions (DAX)
6 3 (6.52%) PL/SQL
6 3 (6.52%) R
7 2 (4.35%) Bash Shell
7 2 (4.35%) C#
7 2 (4.35%) Scala
8 1 (2.17%) BeanShell
8 1 (2.17%) PowerShell
8 1 (2.17%) SAS Macro
8 1 (2.17%) Shell Script
8 1 (2.17%) SOQL
8 1 (2.17%) VBA
Qualifications
1 7 (15.22%) SC Cleared
1 7 (15.22%) Security Cleared
2 5 (10.87%) Degree
3 2 (4.35%) AWS Certification
3 2 (4.35%) Computer Science Degree
4 1 (2.17%) ACCA
Quality Assurance & Compliance
1 4 (8.70%) Data Quality
2 2 (4.35%) MiFID
2 2 (4.35%) Solvency II
3 1 (2.17%) GDPR
3 1 (2.17%) QA
3 1 (2.17%) SLA
System Software
1 2 (4.35%) Docker
2 1 (2.17%) Active Directory
2 1 (2.17%) HDFS
Systems Management
1 3 (6.52%) Grafana
1 3 (6.52%) Kibana
1 3 (6.52%) Terraform
2 2 (4.35%) HP Quality Center
2 2 (4.35%) Kubernetes
3 1 (2.17%) Control-M
3 1 (2.17%) Kubeflow
3 1 (2.17%) Oozie
3 1 (2.17%) Tivoli
Vendors
1 14 (30.43%) Microsoft
2 9 (19.57%) Oracle
3 7 (15.22%) Informatica
4 5 (10.87%) Cloudera
4 5 (10.87%) Tableau
5 2 (4.35%) Cognos
5 2 (4.35%) IBM
5 2 (4.35%) Pega
5 2 (4.35%) SAP
5 2 (4.35%) ServiceNow
6 1 (2.17%) Ab Initio
6 1 (2.17%) Alteryx
6 1 (2.17%) BMC
6 1 (2.17%) Databricks
6 1 (2.17%) Demandware
6 1 (2.17%) Salesforce.com
6 1 (2.17%) Splunk
6 1 (2.17%) Talend
6 1 (2.17%) Zuora