Period
to 29 July 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 29 July 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
29 Jul 2021
Same period 2020 Same period 2019
Rank 83 65 72
Rank change year-on-year -18 +7 +6
Contract jobs citing ETL 85 81 220
As % of all contract jobs advertised in the City of London 2.48% 3.43% 3.35%
As % of the Processes & Methodologies category 2.73% 3.88% 3.71%
Number of daily rates quoted 66 58 167
10th Percentile £397 £363 £389
25th Percentile £456 £420 £418
Median daily rate (50th Percentile) £510 £513 £500
Median % change year-on-year -0.49% +2.50% +4.17%
75th Percentile £609 £626 £575
90th Percentile £706 £675 £634
Central London median daily rate £500 £515 £500
% change year-on-year -2.91% +3.00% +3.31%
Number of hourly rates quoted 0 0 1
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 3,118 2,088 5,936
As % of all contract IT jobs advertised in the City of London 90.98% 88.47% 90.47%
Number of daily rates quoted 2,287 1,545 4,657
10th Percentile £363 £338 £350
25th Percentile £450 £425 £425
Median daily rate (50th Percentile) £550 £525 £525
Median % change year-on-year +4.76% - +2.44%
75th Percentile £642 £603 £600
90th Percentile £725 £688 £675
Central London median daily rate £550 £513 £525
% change year-on-year +7.32% -2.38% +5.00%
Number of hourly rates quoted 37 40 69
10th Percentile £10.10 £12.42 £11.25
25th Percentile £14.25 £14.38 £12.76
Median hourly rate £23.45 £34.50 £19.00
Median % change year-on-year -32.03% +81.58% +1.60%
75th Percentile £33.75 £40.93 £37.50
90th Percentile £53.80 £52.90 £47.30
Central London median hourly rate £22.50 £33.59 £19.38
% change year-on-year -33.01% +73.35% +3.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 29 July 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 29 July 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 58 (68.24%) SQL
2 42 (49.41%) Business Intelligence
3 34 (40.00%) Finance
4 31 (36.47%) Azure
5 27 (31.76%) Python
6 26 (30.59%) Data Modelling
7 24 (28.24%) Data Warehouse
7 24 (28.24%) Agile Software Development
8 22 (25.88%) Analytics
9 21 (24.71%) Power Platform
9 21 (24.71%) Power BI
10 20 (23.53%) SQL Server
11 16 (18.82%) Java
11 16 (18.82%) AWS
11 16 (18.82%) SQL Server Integration Services
12 15 (17.65%) DevOps
12 15 (17.65%) Social Skills
12 15 (17.65%) Data Ingestion
13 14 (16.47%) Big Data
14 12 (14.12%) Microsoft
14 12 (14.12%) Oracle
14 12 (14.12%) Data Pipeline
15 11 (12.94%) Data Lake
15 11 (12.94%) Azure Data Factory
15 11 (12.94%) Analytical Skills
15 11 (12.94%) Apache Spark
15 11 (12.94%) T-SQL
16 10 (11.76%) Banking
16 10 (11.76%) Visualisation
16 10 (11.76%) Data Visualisation

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 11 (12.94%) Apache Spark
2 4 (4.71%) SAS
3 3 (3.53%) Apache Airflow
3 3 (3.53%) Oracle SOA Suite
4 1 (1.18%) Apache
4 1 (1.18%) SharePoint
4 1 (1.18%) Tomcat
4 1 (1.18%) WebLogic
Applications
1 2 (2.35%) Microsoft Excel
2 1 (1.18%) Microsoft PowerPoint
2 1 (1.18%) SPSS
Business Applications
1 1 (1.18%) Dynamics CRM
1 1 (1.18%) Magento
1 1 (1.18%) Oracle BPM
1 1 (1.18%) Oracle Payables
1 1 (1.18%) Oracle Procure-to-Pay
1 1 (1.18%) Salesforce.com CRM
1 1 (1.18%) SAP MDG
1 1 (1.18%) SAP MDM
Cloud Services
1 31 (36.47%) Azure
2 21 (24.71%) Power Platform
3 16 (18.82%) AWS
4 11 (12.94%) Azure Data Factory
5 7 (8.24%) Snowflake
6 6 (7.06%) GCP
7 5 (5.88%) Amazon S3
7 5 (5.88%) GitHub
8 4 (4.71%) Azure Synapse Analytics
8 4 (4.71%) Serverless
9 2 (2.35%) Amazon EC2
9 2 (2.35%) Amazon EMR
9 2 (2.35%) AWS Lambda
9 2 (2.35%) Azure Cosmos DB
9 2 (2.35%) Azure Functions
9 2 (2.35%) Azure Service Bus
9 2 (2.35%) Cloud Computing
9 2 (2.35%) Dynamics 365
10 1 (1.18%) AWS CloudFormation
10 1 (1.18%) Virtual Private Cloud
Communications & Networking
1 1 (1.18%) Firewall
1 1 (1.18%) HTTP
Database & Business Intelligence
1 24 (28.24%) Data Warehouse
2 21 (24.71%) Power BI
3 20 (23.53%) SQL Server
4 16 (18.82%) SQL Server Integration Services
5 14 (16.47%) Big Data
6 11 (12.94%) Data Lake
7 9 (10.59%) Tableau
8 8 (9.41%) Azure SQL Database
8 8 (9.41%) NoSQL
8 8 (9.41%) SQL Server Analysis Services
9 7 (8.24%) Amazon Redshift
10 6 (7.06%) PostgreSQL
11 5 (5.88%) Apache Hive
11 5 (5.88%) Hadoop
11 5 (5.88%) Microsoft Analysis Services
11 5 (5.88%) MongoDB
12 4 (4.71%) BusinessObjects
13 3 (3.53%) Looker
13 3 (3.53%) Oracle Database
13 3 (3.53%) Relational Database
Development Applications
1 8 (9.41%) Git (software)
2 7 (8.24%) Jenkins
3 6 (7.06%) Visual Studio
4 5 (5.88%) JIRA
4 5 (5.88%) TeamCity
5 4 (4.71%) IBM UrbanCode
6 2 (2.35%) ERwin
6 2 (2.35%) Selenium
6 2 (2.35%) Team Foundation Server
7 1 (1.18%) Bitbucket
7 1 (1.18%) GitLab
7 1 (1.18%) GoCD
7 1 (1.18%) Maven
7 1 (1.18%) MLflow
7 1 (1.18%) Octopus Deploy
7 1 (1.18%) Oracle APEX
General
1 34 (40.00%) Finance
2 15 (17.65%) Social Skills
3 11 (12.94%) Analytical Skills
4 10 (11.76%) Banking
5 4 (4.71%) Marketing
6 3 (3.53%) Financial Institution
6 3 (3.53%) Investment Banking
6 3 (3.53%) Legal
7 2 (2.35%) Documentation Skills
7 2 (2.35%) Front Office
7 2 (2.35%) General Ledger
7 2 (2.35%) Law
8 1 (1.18%) International Banking
8 1 (1.18%) Pharmaceutical
8 1 (1.18%) Public Sector
8 1 (1.18%) Retail
Job Titles
1 27 (31.76%) Developer
2 22 (25.88%) Data Engineer
3 15 (17.65%) Analyst
4 11 (12.94%) Business Intelligence Analyst
5 9 (10.59%) Business Analyst
6 8 (9.41%) Architect
7 7 (8.24%) Data Business Analyst
7 7 (8.24%) Java Developer
8 6 (7.06%) Business Intelligence Business Analyst
8 6 (7.06%) Business Intelligence Developer
8 6 (7.06%) Insurance Business Analyst
8 6 (7.06%) SQL Analyst
8 6 (7.06%) SQL Data Analyst
9 4 (4.71%) ETL Developer
9 4 (4.71%) Senior Data Engineer
9 4 (4.71%) SQL Developer
10 3 (3.53%) Analyst Developer
10 3 (3.53%) Lead Developer
10 3 (3.53%) Talend Developer
10 3 (3.53%) Technical Analyst
Libraries, Frameworks & Software Standards
1 8 (9.41%) Spring
2 7 (8.24%) Kafka
3 6 (7.06%) AngularJS
3 6 (7.06%) XML
4 5 (5.88%) JSON
4 5 (5.88%) PySpark
4 5 (5.88%) React
4 5 (5.88%) REST
4 5 (5.88%) SOAP
5 3 (3.53%) .NET
5 3 (3.53%) Spring Boot
6 2 (2.35%) JMS
6 2 (2.35%) MDX
7 1 (1.18%) HTML5
7 1 (1.18%) jQuery
7 1 (1.18%) Node.js
7 1 (1.18%) RabbitMQ
7 1 (1.18%) Spring Batch
7 1 (1.18%) Web Dynpro
7 1 (1.18%) Web Services
Miscellaneous
1 7 (8.24%) Algorithms
2 6 (7.06%) Management Information System
3 4 (4.71%) Legacy Applications
4 3 (3.53%) Reinsurance
4 3 (3.53%) Self-Motivation
5 2 (2.35%) Credit Risk
5 2 (2.35%) Data Structures
5 2 (2.35%) Derivative
6 1 (1.18%) BYOD
6 1 (1.18%) Equities
6 1 (1.18%) Fixed Income
6 1 (1.18%) Linux Command Line
6 1 (1.18%) Mashup
6 1 (1.18%) Reference Data
6 1 (1.18%) Replication
6 1 (1.18%) Social Media
Operating Systems
1 3 (3.53%) Linux
1 3 (3.53%) VMS
2 2 (2.35%) Unix
3 1 (1.18%) Windows
Processes & Methodologies
1 42 (49.41%) Business Intelligence
2 26 (30.59%) Data Modelling
3 24 (28.24%) Agile Software Development
4 22 (25.88%) Analytics
5 15 (17.65%) Data Ingestion
5 15 (17.65%) DevOps
6 12 (14.12%) Data Pipeline
7 10 (11.76%) Data Engineering
7 10 (11.76%) Data Science
7 10 (11.76%) Data Visualisation
7 10 (11.76%) Problem-Solving
7 10 (11.76%) User Acceptance Testing
7 10 (11.76%) Visualisation
8 9 (10.59%) Data Analysis
8 9 (10.59%) Software Engineering
9 8 (9.41%) Microservices
9 8 (9.41%) Software Testing
10 7 (8.24%) Data Analytics
10 7 (8.24%) Data Governance
10 7 (8.24%) Data Management
Programming Languages
1 58 (68.24%) SQL
2 27 (31.76%) Python
3 16 (18.82%) Java
4 11 (12.94%) T-SQL
5 7 (8.24%) Scala
6 5 (5.88%) R
7 4 (4.71%) Data Analysis Expressions (DAX)
8 3 (3.53%) C#
8 3 (3.53%) PL/SQL
9 1 (1.18%) ABAP
9 1 (1.18%) Bash Shell
9 1 (1.18%) C++
9 1 (1.18%) Java 8
9 1 (1.18%) JavaScript
9 1 (1.18%) MATLAB
9 1 (1.18%) VB
9 1 (1.18%) VBA
Qualifications
1 4 (4.71%) Degree
2 2 (2.35%) SC Cleared
2 2 (2.35%) Security Cleared
3 1 (1.18%) Computer Science Degree
3 1 (1.18%) ISEB
3 1 (1.18%) ISTQB
Quality Assurance & Compliance
1 4 (4.71%) QA
2 2 (2.35%) Data Quality
3 1 (1.18%) GDPR
3 1 (1.18%) Sarbanes-Oxley
3 1 (1.18%) Solvency II
System Software
1 7 (8.24%) Docker
Systems Management
1 3 (3.53%) Ansible
1 3 (3.53%) Kubernetes
2 1 (1.18%) Control-M
2 1 (1.18%) Kubeflow
2 1 (1.18%) Terraform
Vendors
1 12 (14.12%) Microsoft
1 12 (14.12%) Oracle
2 8 (9.41%) Databricks
3 6 (7.06%) IBM
3 6 (7.06%) Informatica
4 4 (4.71%) SAP
4 4 (4.71%) Talend
5 2 (2.35%) Alteryx
5 2 (2.35%) Axway
5 2 (2.35%) Cognos
5 2 (2.35%) Maconomy
6 1 (1.18%) Anaplan
6 1 (1.18%) Cloudera
6 1 (1.18%) Concur
6 1 (1.18%) MuleSoft
6 1 (1.18%) Salesforce Marketing Cloud
6 1 (1.18%) Salesforce.com
6 1 (1.18%) StreamSets
6 1 (1.18%) Teradata
6 1 (1.18%) Workday