Period
to

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 May 2022 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 May 2022
Same period 2021 Same period 2020
Rank 58 63 94
Rank change year-on-year +5 +31 -6
Permanent jobs citing ETL 346 218 210
As % of all permanent jobs advertised in the City of London 4.73% 4.36% 2.99%
As % of the Processes & Methodologies category 4.99% 4.57% 3.15%
Number of salaries quoted 310 194 182
10th Percentile £48,625 £46,400 £42,500
25th Percentile £52,500 £52,500 £50,438
Median annual salary (50th Percentile) £70,000 £65,000 £65,000
Median % change year-on-year +7.69% - +8.33%
75th Percentile £85,000 £82,188 £82,500
90th Percentile £95,000 £94,625 £92,375
Central London median annual salary £70,000 £65,000 £65,000
% change year-on-year +7.69% - +8.33%

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 6,938 4,771 6,658
As % of all permanent IT jobs advertised in the City of London 94.86% 95.48% 94.78%
Number of salaries quoted 5,528 4,265 5,839
10th Percentile £46,250 £43,750 £41,250
25th Percentile £57,500 £55,000 £52,500
Median annual salary (50th Percentile) £72,500 £72,500 £67,500
Median % change year-on-year - +7.41% +3.85%
75th Percentile £93,750 £90,000 £85,000
90th Percentile £108,750 £107,500 £100,000
Central London median annual salary £72,500 £70,000 £68,211
% change year-on-year +3.57% +2.62% +4.94%

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 May 2022.

Salary histogram for ETL in the City of London

For the 6 months to 23 May 2022, 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 226 (65.32%) SQL
2 186 (53.76%) Data Warehouse
3 164 (47.40%) Business Intelligence
4 133 (38.44%) Azure
5 127 (36.71%) Python
6 117 (33.82%) Data Modelling
7 115 (33.24%) Analytics
8 106 (30.64%) Data Management
9 105 (30.35%) Power BI
9 105 (30.35%) Power Platform
10 102 (29.48%) Finance
11 99 (28.61%) SQL Server
12 97 (28.03%) SQL Server Integration Services
13 89 (25.72%) Agile
14 81 (23.41%) Microsoft
15 80 (23.12%) Social Skills
16 74 (21.39%) Oracle
17 72 (20.81%) AWS
18 71 (20.52%) Informatica
19 69 (19.94%) Visualisation
20 64 (18.50%) Data Quality
21 63 (18.21%) SQL Server Reporting Services
22 62 (17.92%) Data Science
23 59 (17.05%) Data Lake
23 59 (17.05%) Snowflake
24 57 (16.47%) Data Engineering
25 54 (15.61%) Problem-Solving
26 53 (15.32%) DevOps
27 49 (14.16%) T-SQL
28 48 (13.87%) Data Pipeline

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 31 (8.96%) Apache Spark
2 27 (7.80%) SAS
3 16 (4.62%) SharePoint
4 11 (3.18%) Apache
5 10 (2.89%) Confluence
6 9 (2.60%) Elasticsearch
7 6 (1.73%) Apache Airflow
8 3 (0.87%) Apache Pig
8 3 (0.87%) Appian
Applications
1 37 (10.69%) Microsoft Excel
2 12 (3.47%) Microsoft Office
3 4 (1.16%) Microsoft PowerPoint
4 1 (0.29%) MS Visio
Business Applications
1 3 (0.87%) Cognos Business Intelligence
2 2 (0.58%) SAP MDM
3 1 (0.29%) Oracle Assets
3 1 (0.29%) Oracle Payables
3 1 (0.29%) Oracle Procure-to-Pay
3 1 (0.29%) Oracle Receivables
Cloud Services
1 133 (38.44%) Azure
2 105 (30.35%) Power Platform
3 72 (20.81%) AWS
4 59 (17.05%) Snowflake
5 41 (11.85%) GCP
6 37 (10.69%) Azure Data Factory
7 31 (8.96%) Collibra
8 28 (8.09%) Matillion
9 15 (4.34%) Azure Cosmos DB
10 14 (4.05%) Azure Synapse Analytics
11 12 (3.47%) Amazon S3
12 10 (2.89%) Serverless
13 9 (2.60%) Microsoft 365
14 8 (2.31%) SaaS
15 7 (2.02%) Azure Storage
16 6 (1.73%) Amazon EC2
16 6 (1.73%) GitHub
16 6 (1.73%) PaaS
17 5 (1.45%) Amazon EMR
17 5 (1.45%) AWS Lambda
Communications & Networking
1 5 (1.45%) Network Security
Database & Business Intelligence
1 186 (53.76%) Data Warehouse
2 105 (30.35%) Power BI
3 99 (28.61%) SQL Server
4 97 (28.03%) SQL Server Integration Services
5 63 (18.21%) SQL Server Reporting Services
6 59 (17.05%) Data Lake
7 43 (12.43%) Tableau
8 41 (11.85%) Big Data
8 41 (11.85%) SQL Server Analysis Services
9 37 (10.69%) NoSQL
10 34 (9.83%) Relational Database
11 29 (8.38%) Amazon Redshift
11 29 (8.38%) Hadoop
12 24 (6.94%) PostgreSQL
13 23 (6.65%) QlikView
14 21 (6.07%) OLAP
15 20 (5.78%) Apache Hive
15 20 (5.78%) Qlik Sense
16 16 (4.62%) MySQL
17 15 (4.34%) OLTP
Development Applications
1 22 (6.36%) JIRA
2 14 (4.05%) Git (software)
3 11 (3.18%) Team Foundation Server
4 10 (2.89%) Jenkins
5 6 (1.73%) Mercurial
5 6 (1.73%) Octopus Deploy
6 4 (1.16%) Atlassian Bamboo
6 4 (1.16%) ERwin
6 4 (1.16%) GitLab
6 4 (1.16%) PowerDesigner
6 4 (1.16%) Visual Studio
7 3 (0.87%) ER Studio
7 3 (0.87%) SQL Server Management Studio (SSMS)
7 3 (0.87%) Vagrant
8 1 (0.29%) Bitbucket
8 1 (0.29%) Spinnaker
General
1 102 (29.48%) Finance
2 80 (23.12%) Social Skills
3 30 (8.67%) Advertising
4 25 (7.23%) Analytical Skills
5 19 (5.49%) Influencing Skills
5 19 (5.49%) Law
5 19 (5.49%) Marketing
6 12 (3.47%) Banking
7 10 (2.89%) Public Sector
8 6 (1.73%) Financial Institution
8 6 (1.73%) Legal
9 4 (1.16%) Manufacturing
9 4 (1.16%) Retail
10 3 (0.87%) Inclusion and Diversity
11 2 (0.58%) Music Industry
12 1 (0.29%) Electronics
12 1 (0.29%) French Language
12 1 (0.29%) Games
12 1 (0.29%) General Ledger
12 1 (0.29%) International Banking
Job Titles
1 89 (25.72%) Analyst
2 83 (23.99%) Data Engineer
3 77 (22.25%) Developer
4 40 (11.56%) Business Intelligence Developer
5 34 (9.83%) Data Analyst
6 30 (8.67%) Business Analyst
7 22 (6.36%) Architect
8 21 (6.07%) Data Manager
9 20 (5.78%) HR Analyst
10 19 (5.49%) Data Architect
10 19 (5.49%) Senior Data Engineer
11 18 (5.20%) ETL Developer
12 17 (4.91%) Data Business Analyst
13 16 (4.62%) Report Manager
13 16 (4.62%) Technical Analyst
14 13 (3.76%) Report Developer
15 12 (3.47%) Business Systems Analyst
15 12 (3.47%) HR Business Analyst
16 11 (3.18%) SQL Developer
17 10 (2.89%) Azure Engineer
Libraries, Frameworks & Software Standards
1 20 (5.78%) .NET
2 11 (3.18%) PySpark
2 11 (3.18%) RESTful
3 7 (2.02%) Kafka
4 6 (1.73%) Pandas
5 4 (1.16%) FastAPI
5 4 (1.16%) Spark Streaming
5 4 (1.16%) Starlette
6 3 (0.87%) AngularJS
6 3 (0.87%) JSON
6 3 (0.87%) React
7 2 (0.58%) .NET Core
7 2 (0.58%) ASP.NET
7 2 (0.58%) D3.js
7 2 (0.58%) Flask
7 2 (0.58%) Node.js
7 2 (0.58%) Shiny
7 2 (0.58%) SOAP
7 2 (0.58%) Spring
7 2 (0.58%) XML
Miscellaneous
1 17 (4.91%) Data Structures
2 16 (4.62%) Marketing Technology
3 12 (3.47%) Replication
4 8 (2.31%) Management Information System
4 8 (2.31%) Reference Data
4 8 (2.31%) Self-Motivation
5 7 (2.02%) Greenfield Project
5 7 (2.02%) Virtual Team
6 6 (1.73%) Cloud Native
6 6 (1.73%) Reinsurance
7 5 (1.45%) Private Cloud
8 4 (1.16%) User Experience
9 3 (0.87%) Blockchain
9 3 (0.87%) Derivative
9 3 (0.87%) Enterprise Software
9 3 (0.87%) FMCG
9 3 (0.87%) Legacy Systems
10 2 (0.58%) Housing Association
10 2 (0.58%) Social Media
10 2 (0.58%) Sports Betting
Operating Systems
1 22 (6.36%) Unix
2 14 (4.05%) Linux
3 1 (0.29%) Windows
Processes & Methodologies
1 164 (47.40%) Business Intelligence
2 117 (33.82%) Data Modelling
3 115 (33.24%) Analytics
4 106 (30.64%) Data Management
5 89 (25.72%) Agile
6 69 (19.94%) Visualisation
7 62 (17.92%) Data Science
8 57 (16.47%) Data Engineering
9 54 (15.61%) Problem-Solving
10 53 (15.32%) DevOps
11 48 (13.87%) Data Pipeline
12 44 (12.72%) CI/CD
13 43 (12.43%) Data Governance
13 43 (12.43%) Data Integration
14 38 (10.98%) Data Visualisation
15 37 (10.69%) Master Data Management
15 37 (10.69%) Requirements Gathering
15 37 (10.69%) Stakeholder Management
16 35 (10.12%) Data Analytics
16 35 (10.12%) Kimball Methodology
Programming Languages
1 226 (65.32%) SQL
2 127 (36.71%) Python
3 49 (14.16%) T-SQL
4 45 (13.01%) Java
5 21 (6.07%) Scala
6 20 (5.78%) C#
7 12 (3.47%) Data Analysis Expressions (DAX)
7 12 (3.47%) JavaScript
8 8 (2.31%) PL/SQL
8 8 (2.31%) PowerShell
9 7 (2.02%) HiveQL
9 7 (2.02%) Perl
9 7 (2.02%) R
9 7 (2.02%) Shell Script
10 5 (1.45%) Ruby
11 3 (0.87%) C++
12 2 (0.58%) MATLAB
13 1 (0.29%) Go
13 1 (0.29%) TypeScript
13 1 (0.29%) VBA
Qualifications
1 24 (6.94%) Degree
2 9 (2.60%) SC Cleared
2 9 (2.60%) Security Cleared
3 8 (2.31%) Computer Science Degree
4 3 (0.87%) Master's Degree
Quality Assurance & Compliance
1 64 (18.50%) Data Quality
2 25 (7.23%) QA
3 14 (4.05%) GDPR
4 7 (2.02%) SLA
4 7 (2.02%) Solvency II
5 3 (0.87%) PMO
6 1 (0.29%) IFRS
6 1 (0.29%) IFRS 17
6 1 (0.29%) MiFID
System Software
1 15 (4.34%) Docker
2 7 (2.02%) HDFS
3 6 (1.73%) Active Directory
4 3 (0.87%) Apache Flume
4 3 (0.87%) VirtualBox
Systems Management
1 14 (4.05%) Terraform
2 7 (2.02%) Ansible
2 7 (2.02%) Kubernetes
3 3 (0.87%) Docker Swarm
4 1 (0.29%) Grafana
4 1 (0.29%) Opscode Chef
4 1 (0.29%) Puppet
Vendors
1 81 (23.41%) Microsoft
2 74 (21.39%) Oracle
3 71 (20.52%) Informatica
4 42 (12.14%) Talend
5 24 (6.94%) IBM
6 23 (6.65%) Databricks
6 23 (6.65%) Workday
7 22 (6.36%) SAP
8 19 (5.49%) Google
9 11 (3.18%) Alteryx
9 11 (3.18%) QAD
9 11 (3.18%) Salesforce.com
10 10 (2.89%) SnapLogic
11 9 (2.60%) Cloudera
12 8 (2.31%) Hortonworks
13 6 (1.73%) Cognos
14 4 (1.16%) Cognizant
14 4 (1.16%) MicroStrategy
14 4 (1.16%) Trillium
15 3 (0.87%) Facebook