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

Extract, Transform and Load (ETL)
England > London
6 months to
12 Aug 2020
Same period 2019 Same period 2018
Rank 97 92 100
Rank change year-on-year -5 +8 +26
Permanent jobs citing ETL 870 1,868 2,260
As % of all permanent jobs advertised in London 3.33% 3.31% 3.26%
As % of the Processes & Methodologies category 3.56% 3.56% 3.52%
Number of salaries quoted 611 1,629 1,865
Median annual salary £65,000 £60,500 £60,000
Median salary % change year-on-year +7.44% +0.83% +4.35%
10th Percentile £40,750 £38,750 £40,200
90th Percentile £95,000 £87,500 £87,500
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 24,447 52,464 64,287
As % of all permanent IT jobs advertised in London 93.51% 93.09% 92.71%
Number of salaries quoted 19,755 42,553 51,415
Median annual salary £70,000 £65,000 £60,000
Median salary % change year-on-year +7.69% +8.33% -
10th Percentile £41,250 £36,750 £35,000
90th Percentile £105,000 £97,500 £93,750
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +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 12 August 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 12 August 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 -26 160 £71,250 +18.75% 17
South London +90 77 £67,500 +25.58% 2
West London +31 54 £45,000 -21.74% 3
North London +33 38 £40,000 -48.39% 2
East London +15 33 £72,500 +61.11% 4
ETL
England

For the 6 months to 12 August 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 597 (68.62%) SQL
2 443 (50.92%) Business Intelligence
3 394 (45.29%) Analytics
4 378 (43.45%) SQL Server
5 367 (42.18%) Python
6 323 (37.13%) Data Warehouse
7 268 (30.80%) Tableau
8 251 (28.85%) Oracle
9 244 (28.05%) Azure
10 229 (26.32%) Data Lake
11 226 (25.98%) AWS
12 220 (25.29%) Power Platform
13 218 (25.06%) Power BI
14 216 (24.83%) Finance
15 212 (24.37%) SQL Server Integration Services
15 212 (24.37%) Data Analytics
16 209 (24.02%) Data Modelling
17 200 (22.99%) Analytical Skills
18 199 (22.87%) Data Analysis
19 197 (22.64%) Degree
20 184 (21.15%) Agile Software Development
21 168 (19.31%) Visualisation
22 150 (17.24%) Big Data
23 144 (16.55%) Microsoft
24 141 (16.21%) Alteryx
25 137 (15.75%) Data Extraction
26 134 (15.40%) Teradata
27 129 (14.83%) Java
28 126 (14.48%) Blue Prism
28 126 (14.48%) UiPath

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 99 (11.38%) Apache Spark
2 36 (4.14%) Apache Airflow
3 28 (3.22%) Apache
4 23 (2.64%) SAS
5 19 (2.18%) SharePoint
6 17 (1.95%) Elasticsearch
7 7 (0.80%) Luigi
8 6 (0.69%) Tornado
9 5 (0.57%) Apache Solr
10 4 (0.46%) Anypoint
11 3 (0.34%) CMS
11 3 (0.34%) IIS
11 3 (0.34%) Jupyter
12 2 (0.23%) Apache Pig
12 2 (0.23%) BizTalk Server
12 2 (0.23%) MQSeries
13 1 (0.11%) Apache Synapse
13 1 (0.11%) Confluence
13 1 (0.11%) WebSphere
13 1 (0.11%) WildFly
Applications
1 58 (6.67%) Microsoft Excel
2 7 (0.80%) Spreadsheet
3 3 (0.34%) Microsoft Office
3 3 (0.34%) MS Visio
4 2 (0.23%) SPSS
5 1 (0.11%) InfoPath
5 1 (0.11%) Microsoft Project
5 1 (0.11%) Photoshop
Business Applications
1 7 (0.80%) Dynamics CRM
1 7 (0.80%) Oracle Financials
2 6 (0.69%) Oracle General Ledger
3 5 (0.57%) iTrent
3 5 (0.57%) Oracle ERP
4 3 (0.34%) Markit EDM
4 3 (0.34%) Northgate Housing
5 2 (0.23%) Infor SunSystems
5 2 (0.23%) Oracle Applications
5 2 (0.23%) Raiser's Edge
5 2 (0.23%) Unit4 Business World
6 1 (0.11%) Dynamics NAV
6 1 (0.11%) Oracle EBS R12
6 1 (0.11%) PolarLake
6 1 (0.11%) Sage 200
6 1 (0.11%) Salesforce.com CRM
6 1 (0.11%) Sentinel
Cloud Services
1 244 (28.05%) Azure
2 226 (25.98%) AWS
3 220 (25.29%) Power Platform
4 110 (12.64%) GCP
5 55 (6.32%) Azure Data Factory
6 39 (4.48%) Amazon S3
6 39 (4.48%) SaaS
7 26 (2.99%) Amazon EMR
8 20 (2.30%) Serverless
9 13 (1.49%) Amazon Kinesis
10 11 (1.26%) Amazon ECS
10 11 (1.26%) Azure Functions
10 11 (1.26%) Logic Apps
11 10 (1.15%) Google Analytics
11 10 (1.15%) Office 365
11 10 (1.15%) PowerApps
12 9 (1.03%) PaaS
13 8 (0.92%) AdWords
13 8 (0.92%) Amazon SQS
13 8 (0.92%) Dynamics 365
Communications & Networking
1 7 (0.80%) Network Security
1 7 (0.80%) WebEx
2 6 (0.69%) HTTP
3 3 (0.34%) Firewall
3 3 (0.34%) Intranet
3 3 (0.34%) TCP/IP
4 1 (0.11%) DHCP
4 1 (0.11%) DNS
4 1 (0.11%) Extranet
4 1 (0.11%) Internet
4 1 (0.11%) VPN
Database & Business Intelligence
1 378 (43.45%) SQL Server
2 323 (37.13%) Data Warehouse
3 229 (26.32%) Data Lake
4 218 (25.06%) Power BI
5 212 (24.37%) SQL Server Integration Services
6 150 (17.24%) Big Data
7 106 (12.18%) Hadoop
8 99 (11.38%) SQL Server Reporting Services
9 91 (10.46%) SQL Server Analysis Services
10 87 (10.00%) Oracle Reports
11 74 (8.51%) Snowflake Schema
12 72 (8.28%) Relational Database
13 64 (7.36%) Apache Hive
14 60 (6.90%) NoSQL
15 56 (6.44%) Amazon Redshift
16 52 (5.98%) BigQuery
16 52 (5.98%) OLAP
17 46 (5.29%) Looker
18 44 (5.06%) Azure SQL Database
19 41 (4.71%) Oracle Database
Development Applications
1 47 (5.40%) Git (software)
2 28 (3.22%) JIRA
3 26 (2.99%) Jenkins
4 14 (1.61%) Visual Studio
5 12 (1.38%) Selenium
5 12 (1.38%) Visual Studio Team System
6 9 (1.03%) Cucumber
6 9 (1.03%) Maven
7 8 (0.92%) Bitbucket
7 8 (0.92%) SQL Server Management Studio (SSMS)
8 7 (0.80%) Vagrant
9 6 (0.69%) Atlassian Bamboo
9 6 (0.69%) Oracle Forms
9 6 (0.69%) Team Foundation Server
9 6 (0.69%) TeamCity
10 4 (0.46%) Eclipse
10 4 (0.46%) Flyway
10 4 (0.46%) Liquibase
11 3 (0.34%) CircleCI
11 3 (0.34%) GoCD
General
1 216 (24.83%) Finance
2 70 (8.05%) Legal
3 45 (5.17%) Marketing
4 37 (4.25%) Banking
5 31 (3.56%) Retail
6 21 (2.41%) Advertising
7 11 (1.26%) Games
8 9 (1.03%) Manufacturing
8 9 (1.03%) Pharmaceutical
9 8 (0.92%) Telecoms
10 7 (0.80%) Front Office
10 7 (0.80%) Public Sector
11 4 (0.46%) Investment Banking
12 3 (0.34%) Law
12 3 (0.34%) Social Housing
13 2 (0.23%) Financial Institution
14 1 (0.11%) Automotive
14 1 (0.11%) Back Office
14 1 (0.11%) Publishing
14 1 (0.11%) Retail Banking
Job Titles
1 244 (28.05%) Developer
2 236 (27.13%) Data Engineer
3 198 (22.76%) Analyst
4 139 (15.98%) Data Analyst
5 86 (9.89%) Business Intelligence Developer
6 80 (9.20%) SQL Developer
7 61 (7.01%) ETL Developer
8 60 (6.90%) Senior Analyst
9 53 (6.09%) Senior Data Engineer
10 52 (5.98%) Architect
11 50 (5.75%) Senior Data Analyst
12 46 (5.29%) Data Warehouse Developer
13 44 (5.06%) SSIS Developer
14 41 (4.71%) Senior Developer
15 37 (4.25%) SQL BI Developer
16 34 (3.91%) Data Architect
16 34 (3.91%) SQL Server Developer
17 32 (3.68%) Consultant
17 32 (3.68%) Data Manager
18 30 (3.45%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 65 (7.47%) Kafka
1 65 (7.47%) Web Services
2 55 (6.32%) XML
3 51 (5.86%) JSON
4 50 (5.75%) .NET
5 47 (5.40%) REST
6 34 (3.91%) MDX
7 30 (3.45%) RESTful
8 27 (3.10%) HTML
9 26 (2.99%) PySpark
10 24 (2.76%) SOAP
11 21 (2.41%) Pandas
12 19 (2.18%) CSS
12 19 (2.18%) NumPy
13 18 (2.07%) J2EE
14 16 (1.84%) TensorFlow
15 14 (1.61%) Node.js
16 13 (1.49%) Flask
17 12 (1.38%) RabbitMQ
18 11 (1.26%) D3.js
Miscellaneous
1 200 (22.99%) Analytical Skills
2 57 (6.55%) Data Structures
3 43 (4.94%) Greenfield Project
4 36 (4.14%) Management Information System
5 16 (1.84%) User Experience
6 15 (1.72%) Algorithms
7 13 (1.49%) Self-Motivation
8 10 (1.15%) Derivative
8 10 (1.15%) Reference Data
9 9 (1.03%) Clustering
9 9 (1.03%) OTC Derivatives
9 9 (1.03%) Reinsurance
10 8 (0.92%) Analytical Mindset
11 7 (0.80%) Blog
12 6 (0.69%) Hedge funds
12 6 (0.69%) Hybrid Cloud
12 6 (0.69%) N-Tier
12 6 (0.69%) Virtual Team
13 5 (0.57%) Acoustics
13 5 (0.57%) Cloud Native
Operating Systems
1 45 (5.17%) Unix
2 33 (3.79%) Linux
3 18 (2.07%) Windows
4 6 (0.69%) Windows Server
5 5 (0.57%) Oracle Linux
6 4 (0.46%) Ubuntu
7 3 (0.34%) Windows 10
8 1 (0.11%) OpenVMS
8 1 (0.11%) Red Hat Enterprise Linux
Processes & Methodologies
1 443 (50.92%) Business Intelligence
2 394 (45.29%) Analytics
3 212 (24.37%) Data Analytics
4 209 (24.02%) Data Modelling
5 199 (22.87%) Data Analysis
6 184 (21.15%) Agile Software Development
7 168 (19.31%) Visualisation
8 137 (15.75%) Data Extraction
9 125 (14.37%) Proactive Monitoring
10 114 (13.10%) DevOps
11 109 (12.53%) Data Engineering
12 92 (10.57%) Data Science
12 92 (10.57%) User Acceptance Testing
13 73 (8.39%) Machine Learning
14 72 (8.28%) Project Management
15 71 (8.16%) Data Visualisation
16 70 (8.05%) System Integration Testing
17 69 (7.93%) Data Integration
18 66 (7.59%) Computer Science
19 58 (6.67%) Software Engineering
Programming Languages
1 597 (68.62%) SQL
2 367 (42.18%) Python
3 129 (14.83%) Java
4 80 (9.20%) T-SQL
5 66 (7.59%) C#
6 61 (7.01%) R
7 52 (5.98%) JavaScript
8 45 (5.17%) Scala
9 39 (4.48%) Shell Script
10 36 (4.14%) PL/SQL
11 23 (2.64%) PowerShell
12 21 (2.41%) Data Analysis Expressions (DAX)
13 17 (1.95%) HiveQL
14 11 (1.26%) Java 8
14 11 (1.26%) VBA
15 10 (1.15%) Go
16 9 (1.03%) Bash Shell
17 7 (0.80%) C++
17 7 (0.80%) Julia
18 6 (0.69%) C
Qualifications
1 197 (22.64%) Degree
2 25 (2.87%) Computer Science Degree
3 17 (1.95%) BPSS Clearance
4 10 (1.15%) Security Cleared
5 8 (0.92%) PhD
6 6 (0.69%) Master's Degree
7 5 (0.57%) AWS Certification
7 5 (0.57%) DV Cleared
8 4 (0.46%) SC Cleared
9 3 (0.34%) ISEB
9 3 (0.34%) ISTQB
10 2 (0.23%) MCSA
10 2 (0.23%) Microsoft Certification
10 2 (0.23%) Numerate Degree
Quality Assurance & Compliance
1 82 (9.43%) Data Quality
2 70 (8.05%) GAAP
3 30 (3.45%) QA
4 14 (1.61%) GDPR
5 8 (0.92%) SLA
6 3 (0.34%) Solvency II
System Software
1 51 (5.86%) Docker
2 26 (2.99%) HDFS
3 12 (1.38%) Active Directory
4 7 (0.80%) Virtual Servers
5 6 (0.69%) VirtualBox
6 3 (0.34%) Apache ZooKeeper
7 2 (0.23%) Apache Flume
Systems Management
1 40 (4.60%) Kubernetes
2 25 (2.87%) Terraform
3 9 (1.03%) Ansible
3 9 (1.03%) Control-M
3 9 (1.03%) Hadoop YARN
4 6 (0.69%) Docker Swarm
4 6 (0.69%) Opscode Chef
4 6 (0.69%) Puppet
5 5 (0.57%) CA Single Sign-On
6 4 (0.46%) CloudHub
7 3 (0.34%) Argo
7 3 (0.34%) HP Quality Center
7 3 (0.34%) Oozie
8 2 (0.23%) Salt
Vendors
1 268 (30.80%) Tableau
2 251 (28.85%) Oracle
3 144 (16.55%) Microsoft
4 141 (16.21%) Alteryx
5 134 (15.40%) Teradata
6 126 (14.48%) Blue Prism
6 126 (14.48%) UiPath
7 125 (14.37%) Automation Anywhere
7 125 (14.37%) Cadence
8 89 (10.23%) Informatica
9 75 (8.62%) Google
10 55 (6.32%) Talend
11 53 (6.09%) Databricks
12 42 (4.83%) IBM
13 27 (3.10%) SAP
14 25 (2.87%) Cloudera
14 25 (2.87%) Salesforce.com
15 15 (1.72%) Cognos
16 11 (1.26%) MicroStrategy
17 10 (1.15%) TIBCO