Period
to 1 August 2021

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 1 August 2021 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Central London > City of London
6 months to
1 Aug 2021
Same period 2020 Same period 2019
Rank 80 102 75
Rank change year-on-year +22 -27 0
Permanent jobs citing ETL 200 144 424
As % of all permanent jobs advertised in the City of London 3.58% 2.74% 4.15%
As % of the Processes & Methodologies category 3.75% 2.91% 4.41%
Number of salaries quoted 175 116 384
10th Percentile £44,900 £41,625 £37,725
25th Percentile £52,500 £55,750 £47,500
Median annual salary (50th Percentile) £65,000 £72,500 £62,500
Median % change year-on-year -10.34% +16.00% -3.85%
75th Percentile £80,000 £86,250 £75,313
90th Percentile £101,500 £91,875 £87,500
Central London median annual salary £65,000 £70,000 £60,000
% change year-on-year -7.14% +16.67% -7.69%

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for process or methodology skills.

All Process and Methodology Skills
City of London
Permanent vacancies with a requirement for process or methodology skills 5,330 4,952 9,604
As % of all permanent IT jobs advertised in the City of London 95.42% 94.40% 94.03%
Number of salaries quoted 4,770 4,349 8,559
10th Percentile £43,000 £42,500 £37,500
25th Percentile £54,750 £52,500 £50,000
Median annual salary (50th Percentile) £72,500 £70,000 £65,500
Median % change year-on-year +3.57% +6.87% +1.95%
75th Percentile £91,250 £85,000 £82,500
90th Percentile £107,500 £100,000 £97,500
Central London median annual salary £70,000 £70,000 £65,000
% change year-on-year - +7.69% +4.00%

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
Salary Trend in the City of London

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

Salary trend for ETL in the City of London

ETL
Salary Histogram in the City of London

Salary distribution for jobs citing ETL in the City of London over the 6 months to 1 August 2021.

Salary histogram for ETL in the City of London

For the 6 months to 1 August 2021, IT 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 permanent job ads across the City of London region with a requirement for ETL.

1 130 (65.00%) SQL
2 109 (54.50%) Data Warehouse
3 99 (49.50%) Business Intelligence
4 96 (48.00%) Analytics
5 93 (46.50%) Python
6 72 (36.00%) Azure
7 67 (33.50%) Data Modelling
8 66 (33.00%) Power BI
8 66 (33.00%) Power Platform
9 59 (29.50%) AWS
10 58 (29.00%) SQL Server Integration Services
11 57 (28.50%) Agile Software Development
12 48 (24.00%) Data Lake
13 46 (23.00%) Data Engineering
14 44 (22.00%) SQL Server
15 39 (19.50%) Finance
16 35 (17.50%) DevOps
17 33 (16.50%) Microsoft Excel
18 32 (16.00%) Databricks
19 31 (15.50%) SQL Server Reporting Services
20 30 (15.00%) Microsoft
20 30 (15.00%) Social Skills
21 29 (14.50%) Data Science
22 28 (14.00%) Azure Data Factory
22 28 (14.00%) Docker
23 27 (13.50%) JIRA
24 26 (13.00%) SQL Server Analysis Services
24 26 (13.00%) Analytical Skills
25 25 (12.50%) Problem-Solving
25 25 (12.50%) PostgreSQL

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 18 (9.00%) Apache Spark
2 15 (7.50%) Apache Airflow
2 15 (7.50%) Confluence
3 11 (5.50%) SharePoint
4 4 (2.00%) Apache
4 4 (2.00%) SAS
5 2 (1.00%) Apache Pig
5 2 (1.00%) Appian
5 2 (1.00%) Elasticsearch
Applications
1 33 (16.50%) Microsoft Excel
2 3 (1.50%) Microsoft Office
3 1 (0.50%) Microsoft PowerPoint
3 1 (0.50%) Spreadsheet
Business Applications
1 2 (1.00%) IBM Planning Analytics
1 2 (1.00%) SAP ERP
2 1 (0.50%) Dynamics AX
2 1 (0.50%) Oracle ERP
2 1 (0.50%) Oracle Financials
2 1 (0.50%) Oracle Procure-to-Pay
2 1 (0.50%) SAP BPC
2 1 (0.50%) SAP GRC
2 1 (0.50%) SAP Oil and Gas
Cloud Services
1 72 (36.00%) Azure
2 66 (33.00%) Power Platform
3 59 (29.50%) AWS
4 28 (14.00%) Azure Data Factory
5 17 (8.50%) Amazon S3
6 16 (8.00%) GCP
7 15 (7.50%) Serverless
8 13 (6.50%) Snowflake
9 11 (5.50%) AWS Lambda
10 10 (5.00%) PowerApps
11 9 (4.50%) Matillion
11 9 (4.50%) Power Automate
12 7 (3.50%) Amazon EC2
12 7 (3.50%) AWS Step Functions
12 7 (3.50%) Azure Synapse Analytics
13 6 (3.00%) AWS CloudFormation
13 6 (3.00%) Microsoft 365
14 5 (2.50%) Azure Logic Apps
14 5 (2.50%) SaaS
15 3 (1.50%) Amazon EKS
Communications & Networking
1 4 (2.00%) SSH
2 1 (0.50%) FTP
2 1 (0.50%) Intranet
2 1 (0.50%) PuTTY
2 1 (0.50%) WinSCP
Database & Business Intelligence
1 109 (54.50%) Data Warehouse
2 66 (33.00%) Power BI
3 58 (29.00%) SQL Server Integration Services
4 48 (24.00%) Data Lake
5 44 (22.00%) SQL Server
6 31 (15.50%) SQL Server Reporting Services
7 26 (13.00%) SQL Server Analysis Services
8 25 (12.50%) PostgreSQL
9 22 (11.00%) Azure SQL Database
10 18 (9.00%) Big Data
11 17 (8.50%) Tableau
12 16 (8.00%) Amazon Redshift
12 16 (8.00%) Hadoop
13 14 (7.00%) Relational Database
14 11 (5.50%) NoSQL
14 11 (5.50%) RDBMS
15 10 (5.00%) Amazon Athena
16 9 (4.50%) Apache Hive
16 9 (4.50%) MongoDB
16 9 (4.50%) SQL Server 2012
Development Applications
1 27 (13.50%) JIRA
2 21 (10.50%) Git (software)
3 17 (8.50%) Jenkins
4 9 (4.50%) Octopus Deploy
5 8 (4.00%) Selenium
6 7 (3.50%) Visual Studio
7 5 (2.50%) GitLab
8 4 (2.00%) Cucumber
9 3 (1.50%) ERwin
10 2 (1.00%) ER Studio
10 2 (1.00%) PowerDesigner
11 1 (0.50%) Atlassian Bamboo
11 1 (0.50%) Team Foundation Server
11 1 (0.50%) TeamCity
11 1 (0.50%) Vagrant
General
1 39 (19.50%) Finance
2 30 (15.00%) Social Skills
3 26 (13.00%) Analytical Skills
4 16 (8.00%) Advertising
5 6 (3.00%) Telecoms
6 5 (2.50%) Banking
6 5 (2.50%) French Language
7 4 (2.00%) Front Office
7 4 (2.00%) Legal
8 3 (1.50%) Law
8 3 (1.50%) Retail
9 2 (1.00%) Presentation Skills
9 2 (1.00%) Public Sector
10 1 (0.50%) Manufacturing
10 1 (0.50%) Marketing
10 1 (0.50%) Music Industry
10 1 (0.50%) Retail Banking
10 1 (0.50%) Social Housing
Job Titles
1 70 (35.00%) Data Engineer
2 42 (21.00%) Analyst
2 42 (21.00%) Developer
3 26 (13.00%) Data Analyst
4 22 (11.00%) Business Intelligence Developer
5 19 (9.50%) Senior Data Engineer
6 16 (8.00%) ETL Analyst
6 16 (8.00%) SQL Analyst
6 16 (8.00%) SQL Data Analyst
7 15 (7.50%) SSIS Analyst
8 13 (6.50%) Architect
8 13 (6.50%) Azure Engineer
8 13 (6.50%) Data Architect
9 11 (5.50%) Consultant
10 10 (5.00%) Technical Analyst
11 9 (4.50%) Business Intelligence Consultant
11 9 (4.50%) DBA
11 9 (4.50%) Excel Analyst
12 8 (4.00%) AWS Engineer
12 8 (4.00%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 18 (9.00%) Kafka
2 15 (7.50%) PySpark
3 7 (3.50%) RabbitMQ
4 5 (2.50%) .NET
4 5 (2.50%) Elastic Stack
4 5 (2.50%) Flask
4 5 (2.50%) Jinja
4 5 (2.50%) JSON
4 5 (2.50%) MDX
4 5 (2.50%) NumPy
4 5 (2.50%) SciPy
4 5 (2.50%) SQLAlchemy
5 4 (2.00%) Gherkin
5 4 (2.00%) pytest
5 4 (2.00%) RESTful
5 4 (2.00%) Web Services
6 3 (1.50%) .NET Framework
6 3 (1.50%) REST
6 3 (1.50%) XML
7 2 (1.00%) OAuth
Miscellaneous
1 10 (5.00%) Management Information System
2 9 (4.50%) Data Structures
3 8 (4.00%) Clustering
4 6 (3.00%) Analytical Mindset
4 6 (3.00%) Reinsurance
5 5 (2.50%) Enterprise Software
6 3 (1.50%) Derivative
6 3 (1.50%) Virtual Team
7 2 (1.00%) Fixed Income
7 2 (1.00%) Greenfield Project
7 2 (1.00%) User Experience
8 1 (0.50%) Acoustics
8 1 (0.50%) Algorithms
8 1 (0.50%) Data Centre
8 1 (0.50%) e-Learning
8 1 (0.50%) Equities
8 1 (0.50%) FMCG
8 1 (0.50%) Linux Command Line
8 1 (0.50%) Music Streaming
8 1 (0.50%) Robotics
Operating Systems
1 14 (7.00%) Linux
2 12 (6.00%) Windows
3 5 (2.50%) Unix
4 4 (2.00%) Windows 10
Processes & Methodologies
1 99 (49.50%) Business Intelligence
2 96 (48.00%) Analytics
3 67 (33.50%) Data Modelling
4 57 (28.50%) Agile Software Development
5 46 (23.00%) Data Engineering
6 35 (17.50%) DevOps
7 29 (14.50%) Data Science
8 25 (12.50%) Data Pipeline
8 25 (12.50%) Problem-Solving
8 25 (12.50%) Visualisation
9 21 (10.50%) Data Architecture
9 21 (10.50%) ETL Development
10 20 (10.00%) Data Analysis
10 20 (10.00%) Data Analytics
11 19 (9.50%) Stakeholder Management
12 18 (9.00%) Kimball Methodology
12 18 (9.00%) Requirements Gathering
13 17 (8.50%) Dashboard Development
13 17 (8.50%) Data Governance
13 17 (8.50%) Migration
Programming Languages
1 130 (65.00%) SQL
2 93 (46.50%) Python
3 25 (12.50%) Java
4 19 (9.50%) T-SQL
5 14 (7.00%) R
6 13 (6.50%) Data Analysis Expressions (DAX)
7 11 (5.50%) PowerShell
8 8 (4.00%) C#
9 7 (3.50%) JavaScript
10 6 (3.00%) Bash Shell
11 5 (2.50%) Cypher
12 4 (2.00%) C++
12 4 (2.00%) PL/SQL
12 4 (2.00%) Shell Script
12 4 (2.00%) VBA
13 3 (1.50%) Scala
14 2 (1.00%) ABAP
14 2 (1.00%) HiveQL
15 1 (0.50%) Go
15 1 (0.50%) TypeScript
Qualifications
1 19 (9.50%) Degree
2 7 (3.50%) ISEB
2 7 (3.50%) ISTQB
3 6 (3.00%) Computer Science Degree
4 1 (0.50%) CISA
4 1 (0.50%) Master's Degree
4 1 (0.50%) Oracle Certification
Quality Assurance & Compliance
1 9 (4.50%) QA
2 8 (4.00%) Data Quality
3 1 (0.50%) Actionable Recommendations
3 1 (0.50%) GRC
3 1 (0.50%) SLA
System Software
1 28 (14.00%) Docker
2 8 (4.00%) VMware Infrastructure
3 3 (1.50%) Apache Flume
4 2 (1.00%) HDFS
5 1 (0.50%) Apache ZooKeeper
5 1 (0.50%) VirtualBox
Systems Management
1 13 (6.50%) Terraform
2 10 (5.00%) Ansible
3 8 (4.00%) Grafana
3 8 (4.00%) Kubernetes
4 4 (2.00%) HP Quality Center
5 1 (0.50%) Docker Swarm
Vendors
1 32 (16.00%) Databricks
2 30 (15.00%) Microsoft
3 16 (8.00%) Informatica
4 12 (6.00%) Oracle
5 11 (5.50%) Talend
6 8 (4.00%) VMware
7 7 (3.50%) Google
7 7 (3.50%) SAP
8 6 (3.00%) Alteryx
8 6 (3.00%) Salesforce.com
9 5 (2.50%) SnapLogic
10 4 (2.00%) Cloudera
11 3 (1.50%) IBM
12 2 (1.00%) Hortonworks
13 1 (0.50%) Aderant
13 1 (0.50%) Automation Anywhere
13 1 (0.50%) MuleSoft
13 1 (0.50%) RedGate
13 1 (0.50%) StreamSets
13 1 (0.50%) UiPath