Period
to 28 October 2020

The following table provides summary statistics for permanent job vacancies advertised in 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 28 October 2020 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > London
6 months to
28 Oct 2020
Same period 2019 Same period 2018
Rank 98 93 109
Rank change year-on-year -5 +16 +18
Permanent jobs citing ETL 666 1,865 2,104
As % of all permanent jobs advertised in London 3.34% 3.41% 3.11%
As % of the Processes & Methodologies category 3.58% 3.66% 3.36%
Number of salaries quoted 594 1,550 1,761
Median annual salary £65,000 £62,500 £60,000
Median salary % change year-on-year +4.00% +4.17% +4.35%
10th Percentile £41,250 £40,000 £41,250
90th Percentile £95,000 £93,750 £85,000
England median annual salary £55,000 £55,000 £55,000

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 London with a requirement for process or methodology skills.

All Process and Methodology Skills
London
Permanent vacancies with a requirement for process or methodology skills 18,591 50,972 62,660
As % of all permanent IT jobs advertised in London 93.28% 93.26% 92.72%
Number of salaries quoted 15,507 41,095 50,381
Median annual salary £70,000 £65,000 £62,500
Median salary % change year-on-year +7.69% +4.00% +4.17%
10th Percentile £42,500 £36,250 £35,000
90th Percentile £105,000 £99,112 £95,000
England median annual salary £55,500 £52,500 £52,500
% change year-on-year +5.71% - +5.00%

ETL
Job Vacancy Trend in London

Job postings citing ETL as a proportion of all IT jobs advertised in London.

Job vacancy trend for ETL in London

ETL
Salary Trend in London

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

Salary trend for ETL in London

ETL
Salary Histogram in London

Salary distribution for jobs citing ETL in London over the 6 months to 28 October 2020.

Salary histogram for ETL in London

ETL
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the London region over the 6 months to 28 October 2020. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London -5 144 £67,500 +8.00% 27
South London +50 29 £65,000 -7.14% 2
West London +29 16 £53,750 -6.52% 7
East London +9 16 £67,500 +50.00% 6
ETL
England

For the 6 months to 28 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 London region with a requirement for ETL.

1 432 (64.86%) SQL
2 294 (44.14%) Business Intelligence
3 293 (43.99%) Python
4 288 (43.24%) Data Warehouse
5 259 (38.89%) AWS
6 237 (35.59%) Azure
7 235 (35.29%) Analytics
8 225 (33.78%) Agile Software Development
9 193 (28.98%) Data Modelling
10 189 (28.38%) SQL Server
10 189 (28.38%) Power BI
10 189 (28.38%) Power Platform
11 178 (26.73%) Finance
12 174 (26.13%) Java
13 162 (24.32%) Big Data
14 159 (23.87%) SQL Server Integration Services
15 119 (17.87%) Hadoop
16 116 (17.42%) Oracle
17 112 (16.82%) Microsoft
17 112 (16.82%) DevOps
18 109 (16.37%) Visualisation
19 107 (16.07%) SQL Server Reporting Services
20 105 (15.77%) Data Analytics
21 101 (15.17%) Apache Spark
22 100 (15.02%) Tableau
23 95 (14.26%) GCP
24 94 (14.11%) Data Science
25 92 (13.81%) Data Lake
26 86 (12.91%) Apache Hive
27 84 (12.61%) Data Engineering

ETL
Co-occurring IT Skills in 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 101 (15.17%) Apache Spark
2 40 (6.01%) SAS
3 34 (5.11%) Apache
4 28 (4.20%) Apache Airflow
4 28 (4.20%) Elasticsearch
5 17 (2.55%) SharePoint
6 5 (0.75%) Tornado
7 4 (0.60%) Anypoint
7 4 (0.60%) Confluence
8 3 (0.45%) CMS
8 3 (0.45%) IIS
8 3 (0.45%) Jupyter
8 3 (0.45%) Luigi
8 3 (0.45%) OpenStack
9 2 (0.30%) ArcGIS
10 1 (0.15%) Oracle Application Server
Applications
1 60 (9.01%) Microsoft Excel
2 12 (1.80%) Spreadsheet
3 2 (0.30%) MS Visio
3 2 (0.30%) SPSS
Business Applications
1 21 (3.15%) Dynamics CRM
2 9 (1.35%) iTrent
2 9 (1.35%) Northgate Housing
3 8 (1.20%) Oracle Applications
4 5 (0.75%) Markit EDM
5 2 (0.30%) Dynamics AX
6 1 (0.15%) Dynamics NAV
6 1 (0.15%) PolarLake
6 1 (0.15%) Sentinel
6 1 (0.15%) Shopify
Cloud Services
1 259 (38.89%) AWS
2 237 (35.59%) Azure
3 189 (28.38%) Power Platform
4 95 (14.26%) GCP
5 53 (7.96%) Amazon S3
6 46 (6.91%) Azure Data Factory
7 30 (4.50%) Serverless
8 27 (4.05%) Amazon Kinesis
9 25 (3.75%) AWS Lambda
10 21 (3.15%) SaaS
11 16 (2.40%) Trello
12 15 (2.25%) Amazon EMR
13 14 (2.10%) AWS CloudFormation
14 12 (1.80%) PaaS
15 9 (1.35%) Amazon SageMaker
15 9 (1.35%) Amazon SQS
16 7 (1.05%) AdWords
16 7 (1.05%) Amazon EC2
16 7 (1.05%) Dynamics 365
16 7 (1.05%) Google Analytics
Communications & Networking
1 9 (1.35%) HTTP
2 7 (1.05%) Firewall
2 7 (1.05%) TCP/IP
3 6 (0.90%) WebEx
4 3 (0.45%) Internet
5 1 (0.15%) DSL
5 1 (0.15%) SSH
Database & Business Intelligence
1 288 (43.24%) Data Warehouse
2 189 (28.38%) Power BI
2 189 (28.38%) SQL Server
3 162 (24.32%) Big Data
4 159 (23.87%) SQL Server Integration Services
5 119 (17.87%) Hadoop
6 107 (16.07%) SQL Server Reporting Services
7 100 (15.02%) Tableau
8 92 (13.81%) Data Lake
9 86 (12.91%) Apache Hive
10 80 (12.01%) Snowflake Schema
11 78 (11.71%) SQL Server Analysis Services
12 74 (11.11%) Amazon Redshift
13 73 (10.96%) NoSQL
14 62 (9.31%) Relational Database
15 54 (8.11%) Looker
16 49 (7.36%) BigQuery
17 48 (7.21%) OLAP
18 47 (7.06%) BusinessObjects
19 46 (6.91%) Oracle Database
Development Applications
1 50 (7.51%) Git (software)
2 34 (5.11%) JIRA
3 32 (4.80%) Selenium
4 24 (3.60%) Cucumber
5 20 (3.00%) Jenkins
6 12 (1.80%) Visual Studio
7 9 (1.35%) Appium
7 9 (1.35%) Cypress.io
8 8 (1.20%) Maven
9 7 (1.05%) Team Foundation Server
9 7 (1.05%) Visual Studio Team System
9 7 (1.05%) WebDriver
10 5 (0.75%) RStudio
11 4 (0.60%) GitLab
12 3 (0.45%) Gatling
12 3 (0.45%) JMeter
12 3 (0.45%) JUnit
12 3 (0.45%) SQL Server Management Studio (SSMS)
12 3 (0.45%) TeamCity
13 2 (0.30%) LoadRunner
General
1 178 (26.73%) Finance
2 43 (6.46%) Banking
3 37 (5.56%) Marketing
4 22 (3.30%) Retail
5 17 (2.55%) Advertising
6 11 (1.65%) Games
7 9 (1.35%) Front Office
7 9 (1.35%) Legal
7 9 (1.35%) Pharmaceutical
7 9 (1.35%) Social Housing
8 7 (1.05%) Telecoms
9 6 (0.90%) Manufacturing
10 4 (0.60%) Financial Institution
10 4 (0.60%) Investment Banking
11 2 (0.30%) Back Office
11 2 (0.30%) Digital Economy
12 1 (0.15%) French Language
12 1 (0.15%) Public Sector
12 1 (0.15%) Publishing
12 1 (0.15%) Retail Banking
Job Titles
1 210 (31.53%) Data Engineer
2 196 (29.43%) Developer
3 78 (11.71%) Business Intelligence Developer
4 69 (10.36%) Analyst
5 61 (9.16%) SQL Developer
6 58 (8.71%) Architect
7 53 (7.96%) Consultant
8 39 (5.86%) Azure Developer
9 37 (5.56%) Data Architect
9 37 (5.56%) Data Warehouse Developer
9 37 (5.56%) ETL Developer
9 37 (5.56%) SQL Server Developer
10 31 (4.65%) AWS Engineer
10 31 (4.65%) SQL BI Developer
10 31 (4.65%) SSIS Developer
11 29 (4.35%) Python Engineer
12 27 (4.05%) Senior Data Engineer
13 26 (3.90%) Senior Developer
14 25 (3.75%) Data Analyst
15 24 (3.60%) SQL Server Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 54 (8.11%) Kafka
2 51 (7.66%) Web Services
3 46 (6.91%) REST
4 39 (5.86%) RESTful
5 38 (5.71%) .NET
5 38 (5.71%) JSON
5 38 (5.71%) XML
6 33 (4.95%) PySpark
7 27 (4.05%) SOAP
8 26 (3.90%) MDX
9 23 (3.45%) HTML
10 16 (2.40%) Natural Language Processing
11 14 (2.10%) J2EE
12 13 (1.95%) Spring
13 12 (1.80%) Apache NiFi
14 10 (1.50%) CSS
14 10 (1.50%) Node.js
15 9 (1.35%) Pandas
16 8 (1.20%) Apache Beam
16 8 (1.20%) Spring Boot
Miscellaneous
1 60 (9.01%) Analytical Skills
2 28 (4.20%) Data Structures
3 24 (3.60%) Greenfield Project
4 23 (3.45%) Management Information System
5 21 (3.15%) Algorithms
6 17 (2.55%) Self-Motivation
7 14 (2.10%) Cloud Native
7 14 (2.10%) Mobile App
8 13 (1.95%) Clustering
9 11 (1.65%) Online Banking
9 11 (1.65%) Reference Data
10 10 (1.50%) Reinsurance
11 9 (1.35%) Virtual Team
12 8 (1.20%) Mobile Banking
12 8 (1.20%) User Experience
13 7 (1.05%) Hedge funds
13 7 (1.05%) Social Media
14 6 (0.90%) NHS
15 5 (0.75%) EPoS
16 4 (0.60%) Replication
Operating Systems
1 52 (7.81%) Unix
2 34 (5.11%) Linux
3 21 (3.15%) Windows
4 7 (1.05%) Ubuntu
5 3 (0.45%) Windows 10
6 1 (0.15%) CentOS
Processes & Methodologies
1 294 (44.14%) Business Intelligence
2 235 (35.29%) Analytics
3 225 (33.78%) Agile Software Development
4 193 (28.98%) Data Modelling
5 112 (16.82%) DevOps
6 109 (16.37%) Visualisation
7 105 (15.77%) Data Analytics
8 94 (14.11%) Data Science
9 84 (12.61%) Data Engineering
10 81 (12.16%) Requirements Gathering
11 72 (10.81%) Scrum
12 71 (10.66%) Migration
13 68 (10.21%) Software Engineering
14 64 (9.61%) Data Integration
14 64 (9.61%) Test Automation
15 61 (9.16%) Mentoring
16 60 (9.01%) Data Architecture
16 60 (9.01%) Data Visualisation
17 57 (8.56%) Machine Learning
18 56 (8.41%) Data Analysis
Programming Languages
1 432 (64.86%) SQL
2 293 (43.99%) Python
3 174 (26.13%) Java
4 80 (12.01%) JavaScript
5 75 (11.26%) T-SQL
6 46 (6.91%) Shell Script
7 45 (6.76%) PL/SQL
7 45 (6.76%) Scala
8 42 (6.31%) R
9 38 (5.71%) C#
9 38 (5.71%) HiveQL
10 20 (3.00%) Data Analysis Expressions (DAX)
11 18 (2.70%) Bash Shell
12 14 (2.10%) VBA
13 13 (1.95%) C
14 10 (1.50%) PHP
15 9 (1.35%) C++
15 9 (1.35%) MATLAB
15 9 (1.35%) PowerShell
16 7 (1.05%) Java 8
Qualifications
1 65 (9.76%) Degree
2 30 (4.50%) BPSS Clearance
3 13 (1.95%) Computer Science Degree
4 9 (1.35%) Security Cleared
5 8 (1.20%) ISEB
6 7 (1.05%) AWS Certification
6 7 (1.05%) ISTQB
7 6 (0.90%) SC Cleared
8 5 (0.75%) DV Cleared
9 4 (0.60%) PhD
10 2 (0.30%) Microsoft Certification
10 2 (0.30%) Postgraduate
11 1 (0.15%) CBAP
11 1 (0.15%) IIBA
11 1 (0.15%) MCSA
Quality Assurance & Compliance
1 59 (8.86%) Data Quality
2 32 (4.80%) QA
3 27 (4.05%) GDPR
4 14 (2.10%) SLA
5 1 (0.15%) EMIR
5 1 (0.15%) MiFID
5 1 (0.15%) PMO
System Software
1 48 (7.21%) HDFS
2 43 (6.46%) Docker
3 11 (1.65%) Active Directory
4 7 (1.05%) Apache Flume
5 1 (0.15%) VirtualBox
Systems Management
1 34 (5.11%) Kubernetes
2 13 (1.95%) Terraform
3 7 (1.05%) Hadoop YARN
4 5 (0.75%) Control-M
5 4 (0.60%) CloudHub
5 4 (0.60%) Puppet
6 3 (0.45%) Ansible
6 3 (0.45%) HP Quality Center
6 3 (0.45%) Microsoft Clustering
6 3 (0.45%) Oozie
7 2 (0.30%) Opscode Chef
8 1 (0.15%) Docker Swarm
8 1 (0.15%) Grafana
8 1 (0.15%) Kibana
8 1 (0.15%) logstash
8 1 (0.15%) Prometheus
Vendors
1 116 (17.42%) Oracle
2 112 (16.82%) Microsoft
3 79 (11.86%) Informatica
4 63 (9.46%) Talend
5 58 (8.71%) Google
6 50 (7.51%) Databricks
7 45 (6.76%) Cloudera
8 18 (2.70%) Alteryx
9 17 (2.55%) IBM
9 17 (2.55%) SAP
10 14 (2.10%) Salesforce.com
11 10 (1.50%) Teradata
12 9 (1.35%) Northgate
13 8 (1.20%) Cognos
14 7 (1.05%) DoubleClick
14 7 (1.05%) MuleSoft
14 7 (1.05%) Red Hat
15 6 (0.90%) Blue Prism
15 6 (0.90%) Jitterbit
16 5 (0.75%) Guidewire