Period
to 25 October 2020

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 2020 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 2020
Same period 2019 Same period 2018
Rank 75 65 83
Rank change year-on-year -10 +18 +11
Permanent jobs citing ETL 137 418 415
As % of all permanent jobs advertised in the City of London 3.80% 4.20% 3.73%
As % of the Processes & Methodologies category 4.06% 4.49% 4.01%
Number of salaries quoted 119 390 400
Median annual salary £67,500 £62,500 £62,500
Median salary % change year-on-year +8.00% - +8.70%
10th Percentile £40,500 £42,500 £41,250
90th Percentile £95,000 £87,500 £85,000
Central London median annual salary £67,500 £62,500 £62,500
% change year-on-year +8.00% - +8.70%

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 3,378 9,316 10,345
As % of all permanent IT jobs advertised in the City of London 93.57% 93.58% 92.93%
Number of salaries quoted 2,973 8,118 9,232
Median annual salary £70,000 £67,500 £65,000
Median salary % change year-on-year +3.70% +3.85% +8.33%
10th Percentile £45,000 £38,500 £36,750
90th Percentile £101,250 £97,500 £95,000
Central London median annual salary £70,000 £65,000 £62,500
% change year-on-year +7.69% +4.00% +4.17%

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 2020.

Salary histogram for ETL in the City of London

For the 6 months to 25 October 2020, 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 84 (61.31%) SQL
2 76 (55.47%) Azure
3 73 (53.28%) Data Warehouse
4 67 (48.91%) Business Intelligence
5 59 (43.07%) Agile Software Development
6 56 (40.88%) SQL Server
7 53 (38.69%) Data Modelling
8 52 (37.96%) Analytics
9 51 (37.23%) SQL Server Integration Services
10 48 (35.04%) Python
11 44 (32.12%) Power BI
11 44 (32.12%) Power Platform
12 42 (30.66%) AWS
13 35 (25.55%) Big Data
14 34 (24.82%) SQL Server Analysis Services
15 33 (24.09%) Microsoft
15 33 (24.09%) Finance
15 33 (24.09%) DevOps
16 32 (23.36%) Data Analytics
17 30 (21.90%) Oracle
18 29 (21.17%) Java
19 27 (19.71%) SQL Server Reporting Services
20 26 (18.98%) Hadoop
20 26 (18.98%) Test Automation
21 25 (18.25%) Problem-Solving
22 22 (16.06%) Azure Data Factory
22 22 (16.06%) OLAP
23 21 (15.33%) Azure SQL Data Warehouse
23 21 (15.33%) Apache Spark
24 20 (14.60%) JavaScript

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 21 (15.33%) Apache Spark
2 9 (6.57%) Apache
3 8 (5.84%) Apache Airflow
3 8 (5.84%) Elasticsearch
3 8 (5.84%) SharePoint
4 6 (4.38%) SAS
5 3 (2.19%) CMS
Applications
1 19 (13.87%) Microsoft Excel
2 3 (2.19%) Spreadsheet
3 2 (1.46%) MS Visio
Business Applications
1 3 (2.19%) Dynamics CRM
1 3 (2.19%) iTrent
1 3 (2.19%) Northgate Housing
1 3 (2.19%) Oracle Applications
Cloud Services
1 76 (55.47%) Azure
2 44 (32.12%) Power Platform
3 42 (30.66%) AWS
4 22 (16.06%) Azure Data Factory
5 13 (9.49%) GCP
6 9 (6.57%) Serverless
7 7 (5.11%) Amazon S3
7 7 (5.11%) AWS Lambda
7 7 (5.11%) SaaS
8 5 (3.65%) Amazon Kinesis
9 4 (2.92%) Logic Apps
9 4 (2.92%) Office 365
10 3 (2.19%) Amazon EMR
10 3 (2.19%) Amazon SQS
11 2 (1.46%) Amazon ECS
11 2 (1.46%) Amazon ElastiCache
11 2 (1.46%) Amazon SageMaker
11 2 (1.46%) Azure Active Directory
11 2 (1.46%) PowerApps
12 1 (0.73%) Dynamics 365
Database & Business Intelligence
1 73 (53.28%) Data Warehouse
2 56 (40.88%) SQL Server
3 51 (37.23%) SQL Server Integration Services
4 44 (32.12%) Power BI
5 35 (25.55%) Big Data
6 34 (24.82%) SQL Server Analysis Services
7 27 (19.71%) SQL Server Reporting Services
8 26 (18.98%) Hadoop
9 22 (16.06%) OLAP
10 21 (15.33%) Azure SQL Data Warehouse
11 17 (12.41%) Data Lake
12 16 (11.68%) OLAP Cube
13 15 (10.95%) Apache Hive
13 15 (10.95%) OLTP
14 14 (10.22%) Relational Database
15 13 (9.49%) Snowflake Schema
16 12 (8.76%) MySQL
17 11 (8.03%) Azure SQL Database
18 9 (6.57%) Microsoft Analysis Services
18 9 (6.57%) NoSQL
Development Applications
1 20 (14.60%) Selenium
2 11 (8.03%) Cucumber
3 10 (7.30%) Jenkins
4 9 (6.57%) Cypress.io
5 5 (3.65%) JIRA
6 4 (2.92%) Git (software)
7 2 (1.46%) Appium
7 2 (1.46%) Gatling
7 2 (1.46%) JMeter
7 2 (1.46%) PowerDesigner
8 1 (0.73%) Eclipse
8 1 (0.73%) LoadRunner
8 1 (0.73%) NUnit
8 1 (0.73%) RStudio
8 1 (0.73%) xUnit.net
General
1 33 (24.09%) Finance
2 8 (5.84%) Retail
3 6 (4.38%) Pharmaceutical
4 3 (2.19%) Advertising
4 3 (2.19%) Front Office
4 3 (2.19%) Social Housing
5 2 (1.46%) Marketing
6 1 (0.73%) Financial Institution
6 1 (0.73%) Law
6 1 (0.73%) Public Sector
6 1 (0.73%) Publishing
Job Titles
1 51 (37.23%) Developer
2 30 (21.90%) Business Intelligence Developer
3 29 (21.17%) Azure Developer
4 25 (18.25%) Data Engineer
5 22 (16.06%) Analyst
6 20 (14.60%) ETL Developer
7 18 (13.14%) SQL Developer
8 17 (12.41%) OLAP Developer
8 17 (12.41%) SSAS Developer
8 17 (12.41%) SSIS Developer
9 16 (11.68%) SQL BI Developer
10 14 (10.22%) Data Warehouse Developer
10 14 (10.22%) Excel Developer
10 14 (10.22%) Microsoft BI Developer
10 14 (10.22%) SQL Server BI Developer
10 14 (10.22%) SQL Server Data Warehouse Developer
10 14 (10.22%) SQL Server Developer
11 13 (9.49%) Architect
11 13 (9.49%) Data Architect
12 12 (8.76%) Test Analyst
Libraries, Frameworks & Software Standards
1 19 (13.87%) REST
2 18 (13.14%) JSON
3 16 (11.68%) XML
4 15 (10.95%) SOAP
5 12 (8.76%) Kafka
5 12 (8.76%) RESTful
6 10 (7.30%) MDX
7 8 (5.84%) .NET
8 7 (5.11%) Apache Beam
8 7 (5.11%) Web Services
9 6 (4.38%) Spring
10 4 (2.92%) .NET Core
10 4 (2.92%) Gherkin
10 4 (2.92%) pytest
11 3 (2.19%) HTML
11 3 (2.19%) Node.js
11 3 (2.19%) PySpark
12 2 (1.46%) Entity Framework
12 2 (1.46%) HTML5
12 2 (1.46%) NumPy
Miscellaneous
1 7 (5.11%) Analytical Skills
2 6 (4.38%) Management Information System
3 4 (2.92%) Data Structures
3 4 (2.92%) Reinsurance
4 3 (2.19%) Algorithms
4 3 (2.19%) EPoS
4 3 (2.19%) Self-Motivation
5 1 (0.73%) Analytical Mindset
5 1 (0.73%) Client/Server
5 1 (0.73%) Clustering
5 1 (0.73%) Derivative
5 1 (0.73%) Equities
5 1 (0.73%) Mobile App
Operating Systems
1 10 (7.30%) Unix
2 7 (5.11%) Windows
3 3 (2.19%) Windows 10
4 1 (0.73%) Linux
Processes & Methodologies
1 67 (48.91%) Business Intelligence
2 59 (43.07%) Agile Software Development
3 53 (38.69%) Data Modelling
4 52 (37.96%) Analytics
5 33 (24.09%) DevOps
6 32 (23.36%) Data Analytics
7 26 (18.98%) Test Automation
8 25 (18.25%) Problem-Solving
9 19 (13.87%) Data Science
9 19 (13.87%) Migration
10 17 (12.41%) Data Migration
10 17 (12.41%) Scrum
11 15 (10.95%) Architectural Design
11 15 (10.95%) Data Engineering
11 15 (10.95%) Performance Tuning
12 14 (10.22%) Dashboard Development
12 14 (10.22%) Data Analysis
13 13 (9.49%) Data Integration
13 13 (9.49%) TDD
13 13 (9.49%) Visualisation
Programming Languages
1 84 (61.31%) SQL
2 48 (35.04%) Python
3 29 (21.17%) Java
4 20 (14.60%) JavaScript
5 15 (10.95%) Scala
6 10 (7.30%) Data Analysis Expressions (DAX)
6 10 (7.30%) Shell Script
7 8 (5.84%) T-SQL
8 7 (5.11%) R
9 6 (4.38%) C#
9 6 (4.38%) HiveQL
9 6 (4.38%) PL/SQL
10 4 (2.92%) VBA
11 3 (2.19%) MATLAB
11 3 (2.19%) PHP
11 3 (2.19%) Ruby
12 1 (0.73%) C
12 1 (0.73%) Go
12 1 (0.73%) Kotlin
12 1 (0.73%) VB
Qualifications
1 7 (5.11%) ISEB
1 7 (5.11%) ISTQB
2 1 (0.73%) PhD
Quality Assurance & Compliance
1 10 (7.30%) QA
2 9 (6.57%) Data Quality
3 3 (2.19%) SLA
System Software
1 15 (10.95%) Docker
2 6 (4.38%) HDFS
3 3 (2.19%) Active Directory
4 1 (0.73%) Apache Flume
Systems Management
1 13 (9.49%) Kubernetes
2 9 (6.57%) Terraform
3 4 (2.92%) Control-M
4 3 (2.19%) HP Quality Center
5 1 (0.73%) Ansible
5 1 (0.73%) Microsoft Clustering
5 1 (0.73%) Opscode Chef
5 1 (0.73%) Puppet
Vendors
1 33 (24.09%) Microsoft
2 30 (21.90%) Oracle
3 19 (13.87%) Databricks
4 17 (12.41%) Informatica
5 12 (8.76%) Talend
6 6 (4.38%) Cloudera
7 4 (2.92%) Google
7 4 (2.92%) Teradata
8 3 (2.19%) IBM
8 3 (2.19%) Northgate
8 3 (2.19%) Salesforce.com
8 3 (2.19%) SAP
9 2 (1.46%) OutSystems
9 2 (1.46%) SnapLogic
9 2 (1.46%) Sybase
10 1 (0.73%) Alteryx
10 1 (0.73%) Dynatrace
10 1 (0.73%) Guidewire
10 1 (0.73%) Hortonworks
10 1 (0.73%) Palantir