Period
to 1 April 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 1 April 2020 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > London
6 months to
1 Apr 2020
Same period 2019 Same period 2018
Rank 91 99 113
Rank change year-on-year +8 +14 +5
Permanent jobs citing ETL 1,683 2,030 2,037
As % of all permanent jobs advertised in London 3.49% 3.33% 2.93%
As % of the Processes & Methodologies category 3.73% 3.59% 3.15%
Number of salaries quoted 1,308 1,742 1,648
Median annual salary £65,000 £62,000 £60,000
Median salary % change year-on-year +4.84% +3.33% +4.35%
10th Percentile £41,250 £41,250 £39,925
90th Percentile £92,500 £87,500 £87,875
England median annual salary £57,500 £56,600 £52,500
% change year-on-year +1.59% +7.81% +5.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 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 45,135 56,510 64,758
As % of all permanent IT jobs advertised in London 93.48% 92.73% 93.24%
Number of salaries quoted 36,183 45,746 53,555
Median annual salary £65,000 £62,500 £60,000
Median salary % change year-on-year +4.00% +4.17% -
10th Percentile £37,500 £36,250 £35,000
90th Percentile £100,000 £95,000 £92,500
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +2.04%

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 1 April 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 1 April 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 -10 337 £65,000 +8.33% 66
South London +78 99 £75,000 +25.00% 12
West London +5 86 £45,000 -14.29% 20
North London +24 55 £40,000 -48.39% 1
East London +32 41 £60,000 -4.00% 5
ETL
England

For the 6 months to 1 April 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 1,179 (70.05%) SQL
2 752 (44.68%) Business Intelligence
3 712 (42.31%) SQL Server
4 708 (42.07%) Data Warehouse
5 627 (37.25%) Python
6 622 (36.96%) Analytics
7 477 (28.34%) Azure
8 464 (27.57%) Finance
9 409 (24.30%) Tableau
10 407 (24.18%) Agile Software Development
11 404 (24.00%) Data Modelling
12 401 (23.83%) AWS
13 384 (22.82%) SQL Server Integration Services
14 358 (21.27%) Oracle
14 358 (21.27%) Data Lake
15 353 (20.97%) Analytical Skills
16 348 (20.68%) Power Platform
17 346 (20.56%) Power BI
17 346 (20.56%) Big Data
18 313 (18.60%) Visualisation
19 303 (18.00%) Degree
20 272 (16.16%) Microsoft
21 264 (15.69%) Data Analysis
22 262 (15.57%) Data Analytics
23 252 (14.97%) Java
24 244 (14.50%) Apache Spark
25 235 (13.96%) DevOps
26 232 (13.78%) Data Science
27 227 (13.49%) T-SQL
28 219 (13.01%) GCP

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 244 (14.50%) Apache Spark
2 104 (6.18%) Apache Airflow
3 68 (4.04%) Apache
4 41 (2.44%) Elasticsearch
5 31 (1.84%) Luigi
6 25 (1.49%) SharePoint
7 24 (1.43%) SAS
8 21 (1.25%) Confluence
9 8 (0.48%) Jupyter
10 7 (0.42%) Apache Solr
10 7 (0.42%) Oracle Workflow
11 6 (0.36%) ArcGIS
11 6 (0.36%) MQSeries
12 5 (0.30%) Apache Pig
12 5 (0.30%) Tornado
13 4 (0.24%) IIS
14 2 (0.12%) BizTalk Server
14 2 (0.12%) nginx
14 2 (0.12%) Oracle SOA Suite
14 2 (0.12%) Tomcat
Applications
1 82 (4.87%) Microsoft Excel
2 17 (1.01%) Microsoft Office
3 13 (0.77%) SPSS
4 3 (0.18%) MS Visio
5 2 (0.12%) Microsoft PowerPoint
5 2 (0.12%) Microsoft Project
6 1 (0.059%) InfoPath
6 1 (0.059%) Photoshop
6 1 (0.059%) Spreadsheet
Business Applications
1 13 (0.77%) Dynamics CRM
2 7 (0.42%) Cognos Business Intelligence
3 6 (0.36%) Salesforce.com CRM
4 5 (0.30%) Markit EDM
4 5 (0.30%) Oracle Financials
4 5 (0.30%) RiskWrite
5 4 (0.24%) Actimize
5 4 (0.24%) Infor SunSystems
5 4 (0.24%) iTrent
5 4 (0.24%) Oracle ERP
5 4 (0.24%) Oracle General Ledger
6 2 (0.12%) Cognos TM1
6 2 (0.12%) Eikon
6 2 (0.12%) Raiser's Edge
6 2 (0.12%) Sage 200
6 2 (0.12%) SAP MDG
6 2 (0.12%) Unit4 Business World
7 1 (0.059%) HFM
7 1 (0.059%) Oracle EBS
7 1 (0.059%) SimCorp Dimension
Cloud Services
1 477 (28.34%) Azure
2 401 (23.83%) AWS
3 348 (20.68%) Power Platform
4 219 (13.01%) GCP
5 99 (5.88%) Azure Data Factory
6 91 (5.41%) Amazon S3
7 82 (4.87%) Amazon EMR
8 58 (3.45%) Serverless
9 47 (2.79%) SaaS
10 46 (2.73%) Amazon EC2
11 33 (1.96%) Amazon Kinesis
11 33 (1.96%) Cloud Computing
12 32 (1.90%) AWS Lambda
12 32 (1.90%) GitHub
13 25 (1.49%) IBM Cloud
14 22 (1.31%) Amazon ECS
15 20 (1.19%) Dynamics 365
16 19 (1.13%) Azure Functions
17 16 (0.95%) Amazon SQS
17 16 (0.95%) Office 365
Communications & Networking
1 7 (0.42%) Network Security
2 6 (0.36%) Internet
3 5 (0.30%) Firewall
3 5 (0.30%) Intranet
4 4 (0.24%) DNS
5 3 (0.18%) Extranet
6 2 (0.12%) DHCP
6 2 (0.12%) FTP
6 2 (0.12%) VPN
7 1 (0.059%) HTTP
7 1 (0.059%) Software-Defined Networking
Database & Business Intelligence
1 712 (42.31%) SQL Server
2 708 (42.07%) Data Warehouse
3 384 (22.82%) SQL Server Integration Services
4 358 (21.27%) Data Lake
5 346 (20.56%) Big Data
5 346 (20.56%) Power BI
6 192 (11.41%) Hadoop
6 192 (11.41%) NoSQL
7 185 (10.99%) Amazon Redshift
8 183 (10.87%) Relational Database
9 170 (10.10%) SQL Server Reporting Services
10 152 (9.03%) Snowflake Schema
11 149 (8.85%) SQL Server Analysis Services
12 125 (7.43%) Azure SQL Database
13 107 (6.36%) PostgreSQL
14 102 (6.06%) Oracle Reports
15 95 (5.64%) BigQuery
16 76 (4.52%) Looker
17 69 (4.10%) Amazon DynamoDB
18 67 (3.98%) MongoDB
Development Applications
1 93 (5.53%) Git (software)
2 68 (4.04%) JIRA
3 58 (3.45%) Jenkins
4 43 (2.55%) Visual Studio
5 35 (2.08%) Visual Studio Team System
6 27 (1.60%) Vagrant
7 23 (1.37%) Atlassian Bamboo
7 23 (1.37%) Team Foundation Server
8 15 (0.89%) ERwin
9 12 (0.71%) SQL Server Management Studio (SSMS)
10 11 (0.65%) TeamCity
11 9 (0.53%) Eclipse
12 8 (0.48%) LoadRunner
13 7 (0.42%) Bitbucket
14 6 (0.36%) GitLab
14 6 (0.36%) GoCD
15 5 (0.30%) Flyway
15 5 (0.30%) Liquibase
15 5 (0.30%) Maven
16 4 (0.24%) Subversion
General
1 464 (27.57%) Finance
2 102 (6.06%) Legal
3 82 (4.87%) Banking
4 80 (4.75%) Marketing
5 62 (3.68%) Retail
6 39 (2.32%) Games
7 28 (1.66%) Financial Institution
8 26 (1.54%) Public Sector
9 25 (1.49%) Manufacturing
9 25 (1.49%) Publishing
10 23 (1.37%) Advertising
11 15 (0.89%) Automotive
12 11 (0.65%) Law
13 9 (0.53%) Front Office
13 9 (0.53%) Telecoms
14 6 (0.36%) iGaming
15 4 (0.24%) Investment Banking
15 4 (0.24%) Pharmaceutical
16 3 (0.18%) Back Office
17 2 (0.12%) Electronics
Job Titles
1 488 (29.00%) Developer
2 423 (25.13%) Data Engineer
3 282 (16.76%) Analyst
4 190 (11.29%) Data Analyst
5 174 (10.34%) SQL Developer
6 164 (9.74%) Architect
7 145 (8.62%) Business Intelligence Developer
8 120 (7.13%) Data Architect
9 117 (6.95%) Senior Developer
10 99 (5.88%) Senior Data Engineer
11 92 (5.47%) ETL Developer
12 72 (4.28%) Senior Analyst
13 61 (3.62%) Azure Engineer
13 61 (3.62%) Senior Data Analyst
14 59 (3.51%) Senior Business Intelligence Developer
15 55 (3.27%) Data Warehouse Developer
16 54 (3.21%) DBA
17 52 (3.09%) Business Intelligence Analyst
18 48 (2.85%) Data Manager
19 47 (2.79%) SQL DBA
Libraries, Frameworks & Software Standards
1 161 (9.57%) Kafka
2 111 (6.60%) Web Services
3 85 (5.05%) .NET
4 68 (4.04%) XML
5 63 (3.74%) REST
6 62 (3.68%) HTML
7 47 (2.79%) CSS
8 44 (2.61%) JSON
8 44 (2.61%) MDX
9 41 (2.44%) Spark Streaming
10 33 (1.96%) TensorFlow
11 30 (1.78%) SOAP
12 27 (1.60%) RESTful
13 26 (1.54%) Pandas
14 24 (1.43%) J2EE
15 23 (1.37%) jQuery
16 21 (1.25%) Natural Language Processing
17 20 (1.19%) RabbitMQ
18 18 (1.07%) Node.js
18 18 (1.07%) PySpark
Miscellaneous
1 353 (20.97%) Analytical Skills
2 126 (7.49%) Data Structures
3 71 (4.22%) Greenfield Project
4 57 (3.39%) Management Information System
5 31 (1.84%) Algorithms
6 25 (1.49%) Enterprise Software
6 25 (1.49%) Self-Motivation
7 24 (1.43%) User Experience
8 23 (1.37%) Blog
9 21 (1.25%) Acoustics
10 19 (1.13%) Public Cloud
11 17 (1.01%) Cloud Native
12 15 (0.89%) Hybrid Cloud
13 14 (0.83%) Reference Data
14 12 (0.71%) Data Centre
15 11 (0.65%) Derivative
16 10 (0.59%) Fixed Income
17 9 (0.53%) Foreign Exchange (FX)
17 9 (0.53%) OTC Derivatives
18 8 (0.48%) Analytical Mindset
Operating Systems
1 77 (4.58%) Linux
2 74 (4.40%) Unix
3 25 (1.49%) Windows
4 12 (0.71%) Oracle Linux
4 12 (0.71%) Windows Server
5 2 (0.12%) CentOS
5 2 (0.12%) Red Hat Enterprise Linux
6 1 (0.059%) OpenVMS
6 1 (0.059%) Ubuntu
Processes & Methodologies
1 752 (44.68%) Business Intelligence
2 622 (36.96%) Analytics
3 407 (24.18%) Agile Software Development
4 404 (24.00%) Data Modelling
5 313 (18.60%) Visualisation
6 264 (15.69%) Data Analysis
7 262 (15.57%) Data Analytics
8 235 (13.96%) DevOps
9 232 (13.78%) Data Science
10 215 (12.77%) Data Engineering
11 184 (10.93%) Migration
12 178 (10.58%) Data Extraction
13 165 (9.80%) Proactive Monitoring
14 161 (9.57%) Data Architecture
15 157 (9.33%) Project Management
16 150 (8.91%) Machine Learning
17 148 (8.79%) Data Visualisation
18 141 (8.38%) Fintech
19 139 (8.26%) Problem-Solving
20 137 (8.14%) Data Integration
Programming Languages
1 1,179 (70.05%) SQL
2 627 (37.25%) Python
3 252 (14.97%) Java
4 227 (13.49%) T-SQL
5 164 (9.74%) C#
6 141 (8.38%) Scala
7 116 (6.89%) R
8 63 (3.74%) PL/SQL
9 54 (3.21%) PowerShell
10 50 (2.97%) JavaScript
11 46 (2.73%) Data Analysis Expressions (DAX)
12 44 (2.61%) Shell Script
13 26 (1.54%) Go
14 24 (1.43%) C++
15 18 (1.07%) VBA
16 16 (0.95%) C
17 15 (0.89%) Bash Shell
18 14 (0.83%) VB
19 13 (0.77%) Java 8
20 11 (0.65%) TypeScript
Qualifications
1 303 (18.00%) Degree
2 67 (3.98%) Computer Science Degree
3 13 (0.77%) Security Cleared
4 10 (0.59%) Master's Degree
5 9 (0.53%) PhD
6 8 (0.48%) Numerate Degree
6 8 (0.48%) PMI Certification
7 7 (0.42%) SC Cleared
8 6 (0.36%) Microsoft Certification
9 5 (0.30%) ISTQB
9 5 (0.30%) Postgraduate
10 4 (0.24%) MCSA
11 2 (0.12%) DV Cleared
12 1 (0.059%) AWS Certification
12 1 (0.059%) ITIL Certification
12 1 (0.059%) MBA
12 1 (0.059%) SAP Certification
Quality Assurance & Compliance
1 160 (9.51%) Data Quality
2 81 (4.81%) GAAP
3 78 (4.63%) QA
4 22 (1.31%) GDPR
5 4 (0.24%) Dodd-Frank
5 4 (0.24%) EMIR
5 4 (0.24%) MiFID
6 3 (0.18%) ISO/IEC 27001
6 3 (0.18%) Solvency II
7 1 (0.059%) Basel III
7 1 (0.059%) IFRS
7 1 (0.059%) IFRS 9
7 1 (0.059%) SLA
System Software
1 117 (6.95%) Docker
2 23 (1.37%) VirtualBox
3 17 (1.01%) Active Directory
4 15 (0.89%) HDFS
5 9 (0.53%) Apache ZooKeeper
6 7 (0.42%) Apache Flume
6 7 (0.42%) Virtual Servers
7 6 (0.36%) Oracle RAC
8 5 (0.30%) Virtual Machines
9 2 (0.12%) Varnish
10 1 (0.059%) Terminal Server
Systems Management
1 100 (5.94%) Kubernetes
2 68 (4.04%) Terraform
3 51 (3.03%) Ansible
4 28 (1.66%) Docker Swarm
5 20 (1.19%) Puppet
6 19 (1.13%) Opscode Chef
7 16 (0.95%) Oozie
8 13 (0.77%) Control-M
9 11 (0.65%) Hadoop YARN
10 5 (0.30%) Salt
11 3 (0.18%) BladeLogic
12 2 (0.12%) Argo
12 2 (0.12%) CA Single Sign-On
12 2 (0.12%) Consul
12 2 (0.12%) HP Quality Center
12 2 (0.12%) Istio
12 2 (0.12%) linkerd
13 1 (0.059%) Data Guard
13 1 (0.059%) Mesos
Vendors
1 409 (24.30%) Tableau
2 358 (21.27%) Oracle
3 272 (16.16%) Microsoft
4 209 (12.42%) Informatica
5 185 (10.99%) Teradata
6 178 (10.58%) Alteryx
7 167 (9.92%) Google
8 158 (9.39%) Automation Anywhere
8 158 (9.39%) Blue Prism
8 158 (9.39%) Cadence
8 158 (9.39%) UiPath
9 97 (5.76%) Talend
10 95 (5.64%) IBM
11 91 (5.41%) Salesforce.com
12 87 (5.17%) Databricks
13 59 (3.51%) SAP
14 33 (1.96%) Cloudera
15 31 (1.84%) Cognos
16 28 (1.66%) Hortonworks
17 21 (1.25%) RedGate