Period
to 18 October 2021

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 18 October 2021 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
18 Oct 2021
Same period 2020 Same period 2019
Rank 78 83 58
Rank change year-on-year +5 -25 +35
Contract jobs citing ETL 113 38 235
As % of all contract jobs advertised in the City of London 2.93% 2.14% 3.94%
As % of the Processes & Methodologies category 3.21% 2.41% 4.34%
Number of daily rates quoted 78 23 184
10th Percentile £385 £334 £384
25th Percentile £463 £409 £425
Median daily rate (50th Percentile) £540 £440 £500
Median % change year-on-year +22.87% -12.10% +5.26%
75th Percentile £638 £655 £575
90th Percentile £688 £700 £650
Central London median daily rate £525 £439 £500
% change year-on-year +19.73% -12.30% +5.26%
Number of hourly rates quoted 1 0 0
Median hourly rate £58.00 - -
Central London median hourly rate £58.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 3,516 1,578 5,411
As % of all contract IT jobs advertised in the City of London 91.11% 89.05% 90.65%
Number of daily rates quoted 2,642 1,183 4,302
10th Percentile £363 £313 £325
25th Percentile £463 £413 £425
Median daily rate (50th Percentile) £550 £515 £525
Median % change year-on-year +6.80% -1.90% +3.96%
75th Percentile £650 £600 £600
90th Percentile £748 £675 £676
Central London median daily rate £550 £515 £513
% change year-on-year +6.80% +0.49% +2.50%
Number of hourly rates quoted 37 30 62
10th Percentile £10.10 £14.95 £11.78
25th Percentile £18.25 £18.13 £12.76
Median hourly rate £28.00 £32.75 £17.75
Median % change year-on-year -14.50% +84.51% -5.08%
75th Percentile £42.25 £44.50 £25.94
90th Percentile £62.15 £47.75 £49.29
Central London median hourly rate £30.00 £32.00 £20.00
% change year-on-year -6.25% +60.00% +6.95%

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 18 October 2021.

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 18 October 2021, 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 82 (72.57%) SQL
2 54 (47.79%) Finance
3 42 (37.17%) Azure
4 41 (36.28%) Business Intelligence
5 39 (34.51%) Python
6 37 (32.74%) Data Warehouse
7 35 (30.97%) SQL Server
8 32 (28.32%) Agile Software Development
8 32 (28.32%) SQL Server Integration Services
9 29 (25.66%) DevOps
10 28 (24.78%) Power BI
10 28 (24.78%) Power Platform
10 28 (24.78%) Analytics
10 28 (24.78%) Data Modelling
11 25 (22.12%) Microsoft
12 23 (20.35%) Problem-Solving
13 22 (19.47%) Social Skills
14 21 (18.58%) T-SQL
15 18 (15.93%) Big Data
16 17 (15.04%) NoSQL
16 17 (15.04%) Java
16 17 (15.04%) Data Pipeline
17 16 (14.16%) Visual Studio
17 16 (14.16%) User Acceptance Testing
17 16 (14.16%) SQL Server Analysis Services
18 15 (13.27%) AWS
18 15 (13.27%) Data Analysis
18 15 (13.27%) Apache Spark
19 14 (12.39%) Data Engineering
19 14 (12.39%) C#

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 15 (13.27%) Apache Spark
2 3 (2.65%) SAS
3 2 (1.77%) Apache Airflow
4 1 (0.88%) Apache
4 1 (0.88%) Confluence
4 1 (0.88%) Oracle SOA Suite
4 1 (0.88%) Tomcat
4 1 (0.88%) WebLogic
Applications
1 12 (10.62%) Microsoft Excel
2 6 (5.31%) Microsoft PowerPoint
3 1 (0.88%) Spreadsheet
Business Applications
1 1 (0.88%) CA PPM
1 1 (0.88%) Dynamics CRM
1 1 (0.88%) Magento
1 1 (0.88%) Northgate Housing
1 1 (0.88%) Oracle Payables
1 1 (0.88%) Oracle Procure-to-Pay
1 1 (0.88%) Salesforce.com CRM
Cloud Services
1 42 (37.17%) Azure
2 28 (24.78%) Power Platform
3 15 (13.27%) AWS
4 13 (11.50%) Azure Data Factory
5 12 (10.62%) GitHub
6 9 (7.96%) Snowflake
7 7 (6.19%) Amazon S3
8 5 (4.42%) Azure Synapse Analytics
9 4 (3.54%) Cloud Computing
9 4 (3.54%) Matillion
9 4 (3.54%) Serverless
10 3 (2.65%) Azure Cosmos DB
11 2 (1.77%) Amazon EC2
11 2 (1.77%) AWS Lambda
11 2 (1.77%) Azure Functions
11 2 (1.77%) Azure Service Bus
11 2 (1.77%) Azure Stack
11 2 (1.77%) dbt
11 2 (1.77%) Dynamics 365
11 2 (1.77%) GCP
Communications & Networking
1 1 (0.88%) FIX Connectivity
Database & Business Intelligence
1 37 (32.74%) Data Warehouse
2 35 (30.97%) SQL Server
3 32 (28.32%) SQL Server Integration Services
4 28 (24.78%) Power BI
5 18 (15.93%) Big Data
6 17 (15.04%) NoSQL
7 16 (14.16%) SQL Server Analysis Services
8 14 (12.39%) Tableau
9 13 (11.50%) Data Lake
10 10 (8.85%) MongoDB
11 9 (7.96%) Azure SQL Database
12 8 (7.08%) Microsoft Analysis Services
13 7 (6.19%) Hadoop
14 6 (5.31%) PostgreSQL
14 6 (5.31%) SQL Server Reporting Services
15 5 (4.42%) Amazon Redshift
15 5 (4.42%) Apache Hive
16 4 (3.54%) Metadata
16 4 (3.54%) Relational Database
16 4 (3.54%) SSDT
Development Applications
1 16 (14.16%) Visual Studio
2 8 (7.08%) Git (software)
2 8 (7.08%) Octopus Deploy
3 7 (6.19%) Jenkins
3 7 (6.19%) JIRA
3 7 (6.19%) TeamCity
4 5 (4.42%) Team Foundation Server
5 4 (3.54%) IBM UrbanCode
5 4 (3.54%) Selenium
6 3 (2.65%) Maven
6 3 (2.65%) SpecFlow
7 2 (1.77%) Appium
7 2 (1.77%) TestNG
7 2 (1.77%) WebDriver
7 2 (1.77%) Zephyr
8 1 (0.88%) AppScan
8 1 (0.88%) Cucumber
8 1 (0.88%) GoCD
8 1 (0.88%) MLflow
8 1 (0.88%) Toad
General
1 54 (47.79%) Finance
2 22 (19.47%) Social Skills
3 12 (10.62%) Analytical Skills
4 11 (9.73%) Banking
5 6 (5.31%) Front Office
6 5 (4.42%) Investment Banking
6 5 (4.42%) Marketing
7 4 (3.54%) Legal
7 4 (3.54%) Manufacturing
8 3 (2.65%) Documentation Skills
8 3 (2.65%) Financial Institution
8 3 (2.65%) Law
9 2 (1.77%) General Ledger
9 2 (1.77%) Presentation Skills
9 2 (1.77%) Public Sector
10 1 (0.88%) Back Office
10 1 (0.88%) International Banking
10 1 (0.88%) Prime Brokerage
Job Titles
1 36 (31.86%) Data Engineer
1 36 (31.86%) Developer
2 16 (14.16%) Analyst
3 10 (8.85%) SQL Developer
4 7 (6.19%) Java Developer
5 6 (5.31%) Architect
5 6 (5.31%) Data Analyst
5 6 (5.31%) Senior Data Engineer
6 5 (4.42%) Analyst Developer
6 5 (4.42%) Business Analyst
6 5 (4.42%) Business Intelligence Analyst
6 5 (4.42%) Business Intelligence Developer
6 5 (4.42%) Test Leader
7 4 (3.54%) Data Warehouse Developer
7 4 (3.54%) Technical Analyst
8 3 (2.65%) .NET Developer
8 3 (2.65%) Data Architect
8 3 (2.65%) Data Manager
8 3 (2.65%) Data Warehouse Analyst
8 3 (2.65%) ETL Developer
Libraries, Frameworks & Software Standards
1 10 (8.85%) Kafka
2 9 (7.96%) JSON
2 9 (7.96%) XML
3 8 (7.08%) .NET
3 8 (7.08%) Spring
4 7 (6.19%) AngularJS
5 6 (5.31%) PySpark
5 6 (5.31%) React
6 3 (2.65%) JMS
6 3 (2.65%) MDX
6 3 (2.65%) REST
6 3 (2.65%) SOAP
6 3 (2.65%) Spring Boot
7 2 (1.77%) HTML
7 2 (1.77%) J2EE
7 2 (1.77%) LINQ
7 2 (1.77%) Middleware
7 2 (1.77%) WCF
7 2 (1.77%) WinForms
8 1 (0.88%) FIX Protocol
Miscellaneous
1 9 (7.96%) Algorithms
2 8 (7.08%) Management Information System
3 6 (5.31%) Legacy Applications
4 4 (3.54%) Self-Motivation
5 2 (1.77%) Credit Risk
5 2 (1.77%) Replication
5 2 (1.77%) Social Media
6 1 (0.88%) Data Structures
6 1 (0.88%) Derivative
6 1 (0.88%) Enterprise Software
6 1 (0.88%) Equity Derivative
6 1 (0.88%) Fixed Income
6 1 (0.88%) Hedge funds
6 1 (0.88%) Housing Association
6 1 (0.88%) Legacy Systems
6 1 (0.88%) Linux Command Line
6 1 (0.88%) NHS
6 1 (0.88%) N-Tier
6 1 (0.88%) Taxonomies
6 1 (0.88%) User Experience
Operating Systems
1 3 (2.65%) Linux
1 3 (2.65%) VMS
2 2 (1.77%) Unix
3 1 (0.88%) Windows
Processes & Methodologies
1 41 (36.28%) Business Intelligence
2 32 (28.32%) Agile Software Development
3 29 (25.66%) DevOps
4 28 (24.78%) Analytics
4 28 (24.78%) Data Modelling
5 23 (20.35%) Problem-Solving
6 17 (15.04%) Data Pipeline
7 16 (14.16%) User Acceptance Testing
8 15 (13.27%) Data Analysis
9 14 (12.39%) Data Engineering
10 13 (11.50%) Data Science
11 12 (10.62%) Data Architecture
12 11 (9.73%) Data Ingestion
12 11 (9.73%) Migration
13 10 (8.85%) Data Management
13 10 (8.85%) Data Migration
13 10 (8.85%) ETL Development
13 10 (8.85%) Visualisation
14 9 (7.96%) Computer Science
14 9 (7.96%) Continuous Integration
Programming Languages
1 82 (72.57%) SQL
2 39 (34.51%) Python
3 21 (18.58%) T-SQL
4 17 (15.04%) Java
5 14 (12.39%) C#
6 9 (7.96%) Scala
7 8 (7.08%) Data Analysis Expressions (DAX)
8 6 (5.31%) R
8 6 (5.31%) VBA
9 3 (2.65%) PL/SQL
10 2 (1.77%) Bash Shell
10 2 (1.77%) JavaScript
10 2 (1.77%) PHP
10 2 (1.77%) VB
10 2 (1.77%) VBScript
11 1 (0.88%) C
11 1 (0.88%) C++
11 1 (0.88%) Java 8
11 1 (0.88%) MATLAB
Qualifications
1 7 (6.19%) Degree
2 4 (3.54%) Computer Science Degree
2 4 (3.54%) Security Cleared
3 3 (2.65%) SC Cleared
4 2 (1.77%) AWS Certification
4 2 (1.77%) ISTQB
4 2 (1.77%) ISTQB Advanced Certification
4 2 (1.77%) ISTQB Foundation Certification
4 2 (1.77%) Numerate Degree
5 1 (0.88%) ACCA
5 1 (0.88%) CIMA
Quality Assurance & Compliance
1 7 (6.19%) Data Quality
1 7 (6.19%) QA
2 4 (3.54%) Solvency II
3 3 (2.65%) IFRS
3 3 (2.65%) Sarbanes-Oxley
4 2 (1.77%) GDPR
5 1 (0.88%) NCSC
5 1 (0.88%) SLA
System Software
1 9 (7.96%) Docker
2 1 (0.88%) HDFS
Systems Management
1 4 (3.54%) Kubernetes
2 3 (2.65%) Ansible
2 3 (2.65%) Terraform
3 1 (0.88%) Control-M
3 1 (0.88%) HP Fortify
3 1 (0.88%) Kubeflow
3 1 (0.88%) WebInspect
Vendors
1 25 (22.12%) Microsoft
2 13 (11.50%) Databricks
3 10 (8.85%) Oracle
4 8 (7.08%) Alteryx
5 7 (6.19%) IBM
6 3 (2.65%) Informatica
6 3 (2.65%) SAP
6 3 (2.65%) StreamSets
7 2 (1.77%) Google
7 2 (1.77%) Maconomy
7 2 (1.77%) Talend
8 1 (0.88%) Ab Initio
8 1 (0.88%) Anaplan
8 1 (0.88%) BMC
8 1 (0.88%) Cloudera
8 1 (0.88%) Dell
8 1 (0.88%) MapR
8 1 (0.88%) Northgate
8 1 (0.88%) Salesforce.com
8 1 (0.88%) Teradata