Period
to 25 October 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 25 October 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
25 Oct 2021
Same period 2020 Same period 2019
Rank 64 78 67
Rank change year-on-year +14 -11 +18
Permanent jobs citing ETL 261 137 418
As % of all permanent jobs advertised in the City of London 4.37% 3.79% 4.20%
As % of the Processes & Methodologies category 4.63% 4.02% 4.47%
Number of salaries quoted 235 106 373
10th Percentile £48,750 £40,875 £42,500
25th Percentile £55,000 £58,000 £48,750
Median annual salary (50th Percentile) £67,500 £67,500 £62,500
Median % change year-on-year - +8.00% -
75th Percentile £81,875 £87,500 £77,500
90th Percentile £95,900 £99,375 £87,500
Central London median annual salary £67,500 £67,500 £62,500
% change year-on-year - +8.00% -

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,634 3,406 9,354
As % of all permanent IT jobs advertised in the City of London 94.42% 94.27% 93.93%
Number of salaries quoted 5,023 3,002 8,230
10th Percentile £43,250 £45,000 £38,250
25th Percentile £55,000 £54,027 £51,250
Median annual salary (50th Percentile) £72,500 £70,000 £67,500
Median % change year-on-year +3.57% +3.70% +3.85%
75th Percentile £91,250 £85,000 £82,500
90th Percentile £107,500 £101,250 £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 25 October 2021.

Salary histogram for ETL in the City of London

For the 6 months to 25 October 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 191 (73.18%) SQL
2 158 (60.54%) Data Warehouse
3 128 (49.04%) Business Intelligence
3 128 (49.04%) Analytics
4 103 (39.46%) Data Modelling
5 93 (35.63%) Python
6 86 (32.95%) SQL Server Integration Services
7 81 (31.03%) Azure
8 74 (28.35%) Finance
8 74 (28.35%) Power Platform
9 73 (27.97%) Power BI
10 71 (27.20%) AWS
11 65 (24.90%) Agile Software Development
12 59 (22.61%) Microsoft Excel
13 58 (22.22%) Data Lake
14 45 (17.24%) Microsoft
14 45 (17.24%) Data Architecture
15 44 (16.86%) Data Engineering
15 44 (16.86%) Requirements Gathering
16 42 (16.09%) SQL Server Reporting Services
16 42 (16.09%) SQL Server
17 40 (15.33%) Data Quality
18 39 (14.94%) Analytical Skills
19 37 (14.18%) JIRA
20 36 (13.79%) SQL Server Analysis Services
20 36 (13.79%) Informatica
21 35 (13.41%) Migration
21 35 (13.41%) Data Management
21 35 (13.41%) Big Data
22 33 (12.64%) 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 27 (10.34%) Confluence
2 16 (6.13%) Apache Spark
3 12 (4.60%) Apache Airflow
4 10 (3.83%) SAS
4 10 (3.83%) SharePoint
5 5 (1.92%) Appian
6 4 (1.53%) Apache
7 3 (1.15%) Apache Pig
Applications
1 59 (22.61%) Microsoft Excel
2 3 (1.15%) Microsoft Office
3 1 (0.38%) Spreadsheet
Business Applications
1 2 (0.77%) IBM Planning Analytics
1 2 (0.77%) SAP BPC
2 1 (0.38%) Dynamics AX
2 1 (0.38%) Northgate Housing
2 1 (0.38%) Oracle Applications
2 1 (0.38%) Oracle ERP
2 1 (0.38%) Oracle Financials
2 1 (0.38%) Oracle Procure-to-Pay
2 1 (0.38%) SAP GRC
2 1 (0.38%) SAP Oil and Gas
Cloud Services
1 81 (31.03%) Azure
2 74 (28.35%) Power Platform
3 71 (27.20%) AWS
4 26 (9.96%) Azure Data Factory
5 21 (8.05%) Snowflake
6 18 (6.90%) GCP
7 14 (5.36%) AWS Lambda
7 14 (5.36%) Serverless
8 13 (4.98%) Amazon S3
8 13 (4.98%) AWS Step Functions
8 13 (4.98%) Azure Synapse Analytics
9 11 (4.21%) Matillion
10 6 (2.30%) AWS CloudFormation
10 6 (2.30%) Microsoft 365
11 4 (1.53%) Amazon EC2
11 4 (1.53%) Collibra
11 4 (1.53%) PowerApps
11 4 (1.53%) SaaS
12 2 (0.77%) Azure Logic Apps
12 2 (0.77%) Power Automate
Communications & Networking
1 6 (2.30%) Intranet
2 1 (0.38%) FTP
2 1 (0.38%) Internet
2 1 (0.38%) PuTTY
2 1 (0.38%) WinSCP
Database & Business Intelligence
1 158 (60.54%) Data Warehouse
2 86 (32.95%) SQL Server Integration Services
3 73 (27.97%) Power BI
4 58 (22.22%) Data Lake
5 42 (16.09%) SQL Server
5 42 (16.09%) SQL Server Reporting Services
6 36 (13.79%) SQL Server Analysis Services
7 35 (13.41%) Big Data
8 31 (11.88%) Tableau
9 22 (8.43%) Amazon Redshift
10 20 (7.66%) Hadoop
11 18 (6.90%) PostgreSQL
12 17 (6.51%) Azure SQL Database
13 16 (6.13%) Amazon Athena
14 15 (5.75%) NoSQL
15 13 (4.98%) Apache Hive
16 12 (4.60%) Metadata
16 12 (4.60%) Star Schema
17 11 (4.21%) Data Mart
17 11 (4.21%) Relational Database
Development Applications
1 37 (14.18%) JIRA
2 14 (5.36%) Git (software)
3 8 (3.07%) Jenkins
3 8 (3.07%) Visual Studio
4 5 (1.92%) Selenium
5 4 (1.53%) Cucumber
6 3 (1.15%) ERwin
6 3 (1.15%) GitLab
6 3 (1.15%) Octopus Deploy
7 2 (0.77%) ER Studio
7 2 (0.77%) PowerDesigner
7 2 (0.77%) Team Foundation Server
8 1 (0.38%) Atlassian Bamboo
8 1 (0.38%) Cypress.io
8 1 (0.38%) Oracle APEX
8 1 (0.38%) Postman
8 1 (0.38%) SoapUI
8 1 (0.38%) SQL Server Management Studio (SSMS)
8 1 (0.38%) TeamCity
8 1 (0.38%) Vagrant
General
1 74 (28.35%) Finance
2 39 (14.94%) Analytical Skills
3 21 (8.05%) Advertising
3 21 (8.05%) Social Skills
4 15 (5.75%) Banking
5 10 (3.83%) Public Sector
6 6 (2.30%) Front Office
6 6 (2.30%) Investment Banking
6 6 (2.30%) Law
6 6 (2.30%) Retail
7 5 (1.92%) French Language
7 5 (1.92%) Legal
7 5 (1.92%) Presentation Skills
8 4 (1.53%) Retail Banking
9 3 (1.15%) Organisational Skills
10 1 (0.38%) Automotive
10 1 (0.38%) Documentation Skills
10 1 (0.38%) Manufacturing
10 1 (0.38%) Marketing
10 1 (0.38%) Social Housing
Job Titles
1 79 (30.27%) Data Engineer
2 62 (23.75%) Analyst
3 59 (22.61%) Developer
4 40 (15.33%) Data Analyst
5 32 (12.26%) SQL Analyst
6 30 (11.49%) ETL Analyst
6 30 (11.49%) SSIS Analyst
7 28 (10.73%) SQL Data Analyst
8 19 (7.28%) Excel Analyst
8 19 (7.28%) Technical Analyst
9 18 (6.90%) SQL Developer
10 17 (6.51%) Architect
10 17 (6.51%) Business Intelligence Developer
11 16 (6.13%) Data Architect
12 15 (5.75%) ETL Developer
12 15 (5.75%) Senior Data Engineer
13 14 (5.36%) Business Intelligence Analyst
14 11 (4.21%) Consultant
15 10 (3.83%) Data Analytics Engineer
15 10 (3.83%) Data Manager
Libraries, Frameworks & Software Standards
1 16 (6.13%) PySpark
2 12 (4.60%) Web Services
3 10 (3.83%) .NET
3 10 (3.83%) Kafka
4 6 (2.30%) JSON
4 6 (2.30%) MDX
4 6 (2.30%) React
5 5 (1.92%) .NET Framework
6 4 (1.53%) .NET Core
6 4 (1.53%) Entity Framework
6 4 (1.53%) Gherkin
6 4 (1.53%) pytest
6 4 (1.53%) RabbitMQ
6 4 (1.53%) RESTful
6 4 (1.53%) XML
7 3 (1.15%) AngularJS
7 3 (1.15%) ASP.NET Core
7 3 (1.15%) Dapper ORM
7 3 (1.15%) Elastic Stack
7 3 (1.15%) Vue.js
Miscellaneous
1 17 (6.51%) Management Information System
2 12 (4.60%) Data Structures
3 6 (2.30%) Enterprise Software
3 6 (2.30%) Reinsurance
4 5 (1.92%) Analytical Mindset
5 3 (1.15%) Replication
6 2 (0.77%) Clustering
6 2 (0.77%) Derivative
7 1 (0.38%) Acoustics
7 1 (0.38%) Algorithms
7 1 (0.38%) Blog
7 1 (0.38%) Credit Risk
7 1 (0.38%) Data Centre
7 1 (0.38%) e-Learning
7 1 (0.38%) FMCG
7 1 (0.38%) Greenfield Project
7 1 (0.38%) Life Science
7 1 (0.38%) PMI
7 1 (0.38%) Robotics
7 1 (0.38%) Wiki
Operating Systems
1 12 (4.60%) Unix
2 6 (2.30%) Windows
3 4 (1.53%) Linux
3 4 (1.53%) Windows 10
Processes & Methodologies
1 128 (49.04%) Analytics
1 128 (49.04%) Business Intelligence
2 103 (39.46%) Data Modelling
3 65 (24.90%) Agile Software Development
4 45 (17.24%) Data Architecture
5 44 (16.86%) Data Engineering
5 44 (16.86%) Requirements Gathering
6 35 (13.41%) Data Management
6 35 (13.41%) Migration
7 33 (12.64%) Stakeholder Management
7 33 (12.64%) Visualisation
8 32 (12.26%) Problem-Solving
9 31 (11.88%) Data Analytics
9 31 (11.88%) SDLC
10 29 (11.11%) Data Migration
11 28 (10.73%) Kimball Methodology
12 27 (10.34%) Data Governance
13 25 (9.58%) Data Pipeline
13 25 (9.58%) Data Science
14 23 (8.81%) DevOps
Programming Languages
1 191 (73.18%) SQL
2 93 (35.63%) Python
3 32 (12.26%) Java
4 25 (9.58%) C#
5 22 (8.43%) R
6 11 (4.21%) PL/SQL
7 10 (3.83%) Data Analysis Expressions (DAX)
7 10 (3.83%) JavaScript
7 10 (3.83%) T-SQL
7 10 (3.83%) VBA
8 7 (2.68%) Scala
9 6 (2.30%) PowerShell
10 5 (1.92%) C++
10 5 (1.92%) HiveQL
11 3 (1.15%) ABAP
11 3 (1.15%) Shell Script
12 2 (0.77%) Bash Shell
12 2 (0.77%) PHP
13 1 (0.38%) Apex Code
13 1 (0.38%) C
Qualifications
1 22 (8.43%) Degree
2 6 (2.30%) Computer Science Degree
3 4 (1.53%) ISEB
3 4 (1.53%) ISTQB
4 3 (1.15%) BPSS Clearance
4 3 (1.15%) SC Cleared
4 3 (1.15%) Security Cleared
5 2 (0.77%) Master's Degree
6 1 (0.38%) CISA
6 1 (0.38%) IBM Certification
6 1 (0.38%) Microsoft Certification
6 1 (0.38%) Oracle Certification
6 1 (0.38%) PMI Certification
6 1 (0.38%) Tableau Certification
Quality Assurance & Compliance
1 40 (15.33%) Data Quality
2 17 (6.51%) QA
3 4 (1.53%) Solvency II
4 1 (0.38%) Actionable Recommendations
4 1 (0.38%) GRC
4 1 (0.38%) SLA
System Software
1 10 (3.83%) Docker
2 5 (1.92%) HDFS
3 2 (0.77%) Apache Flume
3 2 (0.77%) VMware Infrastructure
4 1 (0.38%) VirtualBox
Systems Management
1 8 (3.07%) Terraform
2 6 (2.30%) Ansible
3 4 (1.53%) HP Quality Center
4 2 (0.77%) Grafana
5 1 (0.38%) Control-M
5 1 (0.38%) Docker Swarm
5 1 (0.38%) Kubernetes
5 1 (0.38%) Tivoli
Vendors
1 45 (17.24%) Microsoft
2 36 (13.79%) Informatica
3 31 (11.88%) Databricks
4 28 (10.73%) Talend
5 27 (10.34%) Oracle
6 24 (9.20%) Salesforce.com
7 20 (7.66%) Alteryx
8 18 (6.90%) SAP
9 13 (4.98%) Google
10 12 (4.60%) IBM
11 6 (2.30%) Cloudera
12 5 (1.92%) Hortonworks
12 5 (1.92%) SnapLogic
13 2 (0.77%) VMware
14 1 (0.38%) Cognos
14 1 (0.38%) MuleSoft
14 1 (0.38%) Northgate
14 1 (0.38%) Palantir
14 1 (0.38%) Salesforce Marketing Cloud
14 1 (0.38%) Trillium