Period
to 23 April 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 23 April 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
23 Apr 2021
Same period 2020 Same period 2019
Rank 67 94 92
Rank change year-on-year +27 -2 -4
Permanent jobs citing ETL 214 242 355
As % of all permanent jobs advertised in the City of London 4.33% 2.98% 3.48%
As % of the Processes & Methodologies category 4.55% 3.16% 3.74%
Number of salaries quoted 192 208 332
10th Percentile £46,250 £42,500 £38,750
25th Percentile £52,500 £51,313 £47,250
Median annual salary (50th Percentile) £65,000 £65,000 £60,000
Median % change year-on-year - +8.33% -7.69%
75th Percentile £85,000 £81,250 £75,000
90th Percentile £100,000 £91,250 £86,125
Central London median annual salary £65,000 £65,000 £60,000
% change year-on-year - +8.33% -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 4,706 7,650 9,503
As % of all permanent IT jobs advertised in the City of London 95.24% 94.08% 93.04%
Number of salaries quoted 4,173 6,684 8,490
10th Percentile £43,750 £40,000 £36,475
25th Percentile £55,000 £51,250 £49,337
Median annual salary (50th Percentile) £72,500 £67,500 £65,000
Median % change year-on-year +7.41% +3.85% +4.00%
75th Percentile £90,000 £85,000 £82,500
90th Percentile £107,500 £100,000 £97,500
Central London median annual salary £70,000 £67,500 £65,000
% change year-on-year +3.70% +3.85% +8.33%

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 23 April 2021.

Salary histogram for ETL in the City of London

For the 6 months to 23 April 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 120 (56.07%) SQL
2 100 (46.73%) Business Intelligence
3 86 (40.19%) Python
4 83 (38.79%) SQL Server
4 83 (38.79%) Azure
5 82 (38.32%) Data Warehouse
6 75 (35.05%) AWS
7 70 (32.71%) Analytics
8 68 (31.78%) Agile Software Development
9 61 (28.50%) Power Platform
9 61 (28.50%) Power BI
10 58 (27.10%) SQL Server Integration Services
11 49 (22.90%) Data Modelling
12 48 (22.43%) Finance
13 47 (21.96%) Visualisation
14 46 (21.50%) Java
15 43 (20.09%) Data Science
16 42 (19.63%) SQL Server Analysis Services
17 38 (17.76%) SQL Server Reporting Services
18 35 (16.36%) T-SQL
19 34 (15.89%) Data Lake
20 31 (14.49%) Hadoop
21 30 (14.02%) Degree
22 29 (13.55%) Microsoft
22 29 (13.55%) Data Visualisation
22 29 (13.55%) Docker
23 28 (13.08%) Azure Data Factory
23 28 (13.08%) Databricks
24 27 (12.62%) DevOps
25 25 (11.68%) Migration

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 20 (9.35%) Apache Spark
2 11 (5.14%) SharePoint
3 10 (4.67%) Apache Airflow
4 8 (3.74%) SAS
5 7 (3.27%) Apache
6 2 (0.93%) Confluence
6 2 (0.93%) Elasticsearch
Applications
1 15 (7.01%) Microsoft Excel
2 1 (0.47%) Microsoft PowerPoint
Business Applications
1 2 (0.93%) SAP ERP
Cloud Services
1 83 (38.79%) Azure
2 75 (35.05%) AWS
3 61 (28.50%) Power Platform
4 28 (13.08%) Azure Data Factory
5 23 (10.75%) GCP
6 13 (6.07%) Amazon S3
6 13 (6.07%) Serverless
7 11 (5.14%) Power Automate
7 11 (5.14%) PowerApps
8 9 (4.21%) Amazon SageMaker
9 8 (3.74%) Amazon EC2
10 7 (3.27%) AWS Lambda
11 6 (2.80%) Matillion
12 4 (1.87%) Amazon EMR
12 4 (1.87%) Azure Functions
12 4 (1.87%) Azure Logic Apps
12 4 (1.87%) IaaS
12 4 (1.87%) PaaS
13 3 (1.40%) Amazon Kinesis
13 3 (1.40%) Google Data Studio
Communications & Networking
1 4 (1.87%) SSH
Database & Business Intelligence
1 83 (38.79%) SQL Server
2 82 (38.32%) Data Warehouse
3 61 (28.50%) Power BI
4 58 (27.10%) SQL Server Integration Services
5 42 (19.63%) SQL Server Analysis Services
6 38 (17.76%) SQL Server Reporting Services
7 34 (15.89%) Data Lake
8 31 (14.49%) Hadoop
9 23 (10.75%) Big Data
10 20 (9.35%) PostgreSQL
10 20 (9.35%) Tableau
11 18 (8.41%) Azure SQL Database
12 15 (7.01%) Amazon Redshift
12 15 (7.01%) BusinessObjects
13 11 (5.14%) Data Mart
13 11 (5.14%) SQL Server 2016
14 10 (4.67%) Microsoft Analysis Services
14 10 (4.67%) Relational Database
15 9 (4.21%) Apache Hive
15 9 (4.21%) NoSQL
Development Applications
1 24 (11.21%) Git (software)
2 22 (10.28%) Jenkins
3 12 (5.61%) Selenium
4 8 (3.74%) Cucumber
5 6 (2.80%) JIRA
5 6 (2.80%) Octopus Deploy
6 4 (1.87%) TeamCity
7 3 (1.40%) GitLab
8 2 (0.93%) Appium
8 2 (0.93%) Team Foundation Server
8 2 (0.93%) Visual Studio
9 1 (0.47%) SQL Server Management Studio (SSMS)
9 1 (0.47%) Toad
General
1 48 (22.43%) Finance
2 15 (7.01%) Banking
3 10 (4.67%) Marketing
4 8 (3.74%) Telecoms
5 7 (3.27%) Advertising
6 5 (2.34%) Public Sector
7 3 (1.40%) Law
8 2 (0.93%) Front Office
8 2 (0.93%) Legal
8 2 (0.93%) Retail
9 1 (0.47%) Games
9 1 (0.47%) Music Industry
9 1 (0.47%) Pharmaceutical
9 1 (0.47%) Social Housing
Job Titles
1 64 (29.91%) Data Engineer
2 55 (25.70%) Developer
3 35 (16.36%) Analyst
4 34 (15.89%) Business Intelligence Developer
5 24 (11.21%) Architect
5 24 (11.21%) Data Architect
5 24 (11.21%) Senior Data Engineer
6 15 (7.01%) Consultant
6 15 (7.01%) Data Analyst
7 13 (6.07%) Senior Developer
8 12 (5.61%) Analyst Developer
8 12 (5.61%) SQL Developer
9 11 (5.14%) Azure Architect
9 11 (5.14%) Business Intelligence Analyst
9 11 (5.14%) Power BI Developer
9 11 (5.14%) Tester
10 10 (4.67%) Report Analyst
10 10 (4.67%) Senior Business Intelligence Developer
11 9 (4.21%) Automation Tester
11 9 (4.21%) Data Scientist
Libraries, Frameworks & Software Standards
1 19 (8.88%) Kafka
1 19 (8.88%) Web Services
2 12 (5.61%) REST
3 11 (5.14%) PySpark
4 5 (2.34%) .NET
4 5 (2.34%) Lambda Expressions
5 4 (1.87%) .NET Core
5 4 (1.87%) ASP.NET
5 4 (1.87%) D3.js
5 4 (1.87%) HTML
5 4 (1.87%) Middleware
6 3 (1.40%) AngularJS
6 3 (1.40%) ASP.NET Core
6 3 (1.40%) Elastic Stack
6 3 (1.40%) Entity Framework
6 3 (1.40%) NumPy
6 3 (1.40%) RabbitMQ
6 3 (1.40%) SciPy
6 3 (1.40%) SQLAlchemy
6 3 (1.40%) Vue.js
Miscellaneous
1 21 (9.81%) Reinsurance
2 15 (7.01%) Management Information System
3 14 (6.54%) Analytical Skills
4 11 (5.14%) Data Structures
5 9 (4.21%) Algorithms
6 7 (3.27%) Clustering
7 5 (2.34%) Fixed Income
8 3 (1.40%) Enterprise Software
8 3 (1.40%) Greenfield Project
8 3 (1.40%) User Experience
8 3 (1.40%) Virtual Team
9 1 (0.47%) Analytical Mindset
9 1 (0.47%) Client/Server
9 1 (0.47%) Derivative
9 1 (0.47%) Equities
9 1 (0.47%) Linux Command Line
9 1 (0.47%) Music Streaming
9 1 (0.47%) Reference Data
9 1 (0.47%) Replication
9 1 (0.47%) Self-Motivation
Operating Systems
1 18 (8.41%) Linux
2 12 (5.61%) Unix
3 8 (3.74%) Windows
Processes & Methodologies
1 100 (46.73%) Business Intelligence
2 70 (32.71%) Analytics
3 68 (31.78%) Agile Software Development
4 49 (22.90%) Data Modelling
5 47 (21.96%) Visualisation
6 43 (20.09%) Data Science
7 29 (13.55%) Data Visualisation
8 27 (12.62%) DevOps
9 25 (11.68%) Migration
10 24 (11.21%) Data Engineering
11 22 (10.28%) Business Analysis
11 22 (10.28%) Data Integration
12 20 (9.35%) Data Analysis
12 20 (9.35%) Data Analytics
13 19 (8.88%) Data Strategy
14 18 (8.41%) Dashboard Development
15 17 (7.94%) Data Management
15 17 (7.94%) Decision-Making
15 17 (7.94%) Scrum
16 16 (7.48%) Mathematics
Programming Languages
1 120 (56.07%) SQL
2 86 (40.19%) Python
3 46 (21.50%) Java
4 35 (16.36%) T-SQL
5 22 (10.28%) JavaScript
6 17 (7.94%) R
7 10 (4.67%) Data Analysis Expressions (DAX)
8 9 (4.21%) C#
8 9 (4.21%) PL/SQL
9 8 (3.74%) Bash Shell
10 7 (3.27%) HiveQL
10 7 (3.27%) Shell Script
11 6 (2.80%) PowerShell
12 5 (2.34%) Cypher
13 4 (1.87%) Scala
14 3 (1.40%) VBA
15 2 (0.93%) MATLAB
15 2 (0.93%) TypeScript
16 1 (0.47%) Go
16 1 (0.47%) Julia
Qualifications
1 30 (14.02%) Degree
2 11 (5.14%) ISEB
2 11 (5.14%) ISTQB
3 9 (4.21%) PhD
4 4 (1.87%) Computer Science Degree
5 3 (1.40%) Numerate Degree
6 1 (0.47%) SC Cleared
6 1 (0.47%) Security Cleared
Quality Assurance & Compliance
1 16 (7.48%) Data Quality
2 6 (2.80%) QA
3 1 (0.47%) GDPR
3 1 (0.47%) PCI DSS
System Software
1 29 (13.55%) Docker
2 7 (3.27%) HDFS
3 6 (2.80%) VMware Infrastructure
4 1 (0.47%) Apache Flume
4 1 (0.47%) Apache ZooKeeper
Systems Management
1 7 (3.27%) Kubernetes
1 7 (3.27%) Terraform
2 6 (2.80%) Ansible
2 6 (2.80%) Grafana
3 1 (0.47%) Microsoft Clustering
Vendors
1 29 (13.55%) Microsoft
2 28 (13.08%) Databricks
3 24 (11.21%) Talend
4 21 (9.81%) Informatica
5 18 (8.41%) Oracle
6 13 (6.07%) SAP
7 11 (5.14%) Google
8 9 (4.21%) Cloudera
8 9 (4.21%) QAD
9 6 (2.80%) Alteryx
9 6 (2.80%) IBM
9 6 (2.80%) VMware
10 5 (2.34%) Salesforce.com
11 3 (1.40%) Intel
11 3 (1.40%) NVIDIA
12 1 (0.47%) Ab Initio
12 1 (0.47%) Guidewire
12 1 (0.47%) MicroStrategy
12 1 (0.47%) Palantir
12 1 (0.47%) Siebel