Period
to 12 April 2021

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

Extract, Transform and Load (ETL)
UK
6 months to
12 Apr 2021
Same period 2020 Same period 2019
Rank 117 122 136
Rank change year-on-year +5 +14 +3
Permanent jobs citing ETL 2,250 2,994 3,904
As % of all permanent jobs advertised in the UK 2.73% 2.64% 2.62%
As % of the Processes & Methodologies category 2.95% 2.86% 2.84%
Number of salaries quoted 1,767 2,308 3,211
10th Percentile £36,250 £36,250 £33,750
25th Percentile £43,375 £42,500 £41,250
Median annual salary (50th Percentile) £57,500 £57,500 £55,000
Median % change year-on-year - +4.55% +4.76%
75th Percentile £73,750 £75,000 £71,250
90th Percentile £87,500 £90,000 £83,750
UK excluding London median annual salary £48,000 £50,000 £47,500
% change year-on-year -4.00% +5.26% +5.56%

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

All Process and Methodology Skills
UK
Permanent vacancies with a requirement for process or methodology skills 76,303 104,589 137,442
As % of all permanent IT jobs advertised in the UK 92.46% 92.13% 92.30%
Number of salaries quoted 58,806 83,983 109,303
10th Percentile £32,500 £31,250 £30,000
25th Percentile £41,250 £40,000 £37,500
Median annual salary (50th Percentile) £55,000 £55,000 £52,500
Median % change year-on-year - +4.76% +5.00%
75th Percentile £75,000 £72,500 £70,000
90th Percentile £90,000 £90,000 £85,000
UK excluding London median annual salary £48,500 £47,500 £45,000
% change year-on-year +2.11% +5.56% -

ETL
Job Vacancy Trend

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

Job vacancy trend for ETL in the UK

ETL
Salary Trend

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

Salary trend for ETL in the UK

ETL
Salary Histogram

Salary distribution for jobs citing ETL over the 6 months to 12 April 2021.

Salary histogram for ETL in the UK

ETL
Top 18 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the UK over the 6 months to 12 April 2021. 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
England +4 2,067 £57,500 - 299
London +3 1,113 £65,000 - 135
UK excluding London 0 989 £48,000 -4.00% 179
Work from Home +45 449 £57,500 -4.17% 71
North of England +26 346 £47,500 -9.52% 52
South East -45 195 £55,000 - 35
North West +8 182 £50,000 - 34
Midlands +13 164 £45,000 -10.00% 33
South West +8 142 £42,500 - 20
Yorkshire +29 126 £43,000 -18.10% 16
West Midlands +3 108 £45,000 -10.00% 19
East of England 0 72 £52,500 -16.00% 23
East Midlands +49 56 £47,500 +5.56% 14
Scotland +6 55 £51,250 +20.59% 13
North East +32 38 £42,250 -16.89% 2
Wales +1 15 £45,000 +5.88% 3
Northern Ireland -1 2 £80,000 +77.78%
Isle of Man - 1 £37,500 -

For the 6 months to 12 April 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 with a requirement for ETL.

1 1,495 (66.44%) SQL
2 1,166 (51.82%) Business Intelligence
3 1,048 (46.58%) Data Warehouse
4 896 (39.82%) Azure
5 862 (38.31%) Python
6 769 (34.18%) Analytics
7 765 (34.00%) Power Platform
8 756 (33.60%) Power BI
9 721 (32.04%) Agile Software Development
10 708 (31.47%) AWS
11 694 (30.84%) SQL Server
12 653 (29.02%) SQL Server Integration Services
13 590 (26.22%) Data Modelling
14 493 (21.91%) Microsoft
15 473 (21.02%) SQL Server Reporting Services
16 464 (20.62%) Finance
16 464 (20.62%) Big Data
17 433 (19.24%) Visualisation
18 411 (18.27%) Data Engineering
19 376 (16.71%) Data Science
20 326 (14.49%) SQL Server Analysis Services
21 324 (14.40%) GCP
22 322 (14.31%) Tableau
23 316 (14.04%) Analytical Skills
24 309 (13.73%) T-SQL
25 300 (13.33%) DevOps
26 291 (12.93%) Java
27 284 (12.62%) Data Lake
28 273 (12.13%) Migration
29 271 (12.04%) Hadoop

ETL
Co-occurring IT Skills 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 259 (11.51%) Apache Spark
2 118 (5.24%) Apache Airflow
3 104 (4.62%) Apache
4 59 (2.62%) Elasticsearch
5 56 (2.49%) SharePoint
6 48 (2.13%) Luigi
7 39 (1.73%) SAS
8 25 (1.11%) Confluence
9 22 (0.98%) Apache Pig
10 15 (0.67%) Jupyter
11 10 (0.44%) WebLogic
12 8 (0.36%) OpenStack
13 7 (0.31%) Liferay
13 7 (0.31%) Tornado
14 6 (0.27%) Apache Synapse
14 6 (0.27%) ArcGIS
14 6 (0.27%) JBoss
15 5 (0.22%) Oracle SOA Suite
15 5 (0.22%) Tomcat
16 4 (0.18%) GlassFish
Applications
1 135 (6.00%) Microsoft Excel
2 29 (1.29%) Microsoft Office
3 9 (0.40%) MS Visio
4 5 (0.22%) Microsoft PowerPoint
4 5 (0.22%) SPSS
5 4 (0.18%) Gliffy
5 4 (0.18%) InfoPath
6 2 (0.089%) Microsoft Project
7 1 (0.044%) Figma
7 1 (0.044%) Spreadsheet
Business Applications
1 32 (1.42%) Dynamics CRM
2 11 (0.49%) Dynamics AX
3 9 (0.40%) Oracle ERP
3 9 (0.40%) SAP S/4HANA
4 7 (0.31%) NetSuite
4 7 (0.31%) Oracle EBS
5 6 (0.27%) Adobe Campaign
6 5 (0.22%) FastStats
7 4 (0.18%) SAP ERP
8 2 (0.089%) Dynamics NAV
8 2 (0.089%) Infor M3
8 2 (0.089%) Maximo
8 2 (0.089%) Oracle Financials
8 2 (0.089%) Retail-J
8 2 (0.089%) SAP Business One
8 2 (0.089%) SAP MDG
8 2 (0.089%) Sentinel
8 2 (0.089%) Siebel CRM
9 1 (0.044%) iTrent
9 1 (0.044%) Sparx Enterprise Architect
Cloud Services
1 896 (39.82%) Azure
2 765 (34.00%) Power Platform
3 708 (31.47%) AWS
4 324 (14.40%) GCP
5 224 (9.96%) Azure Data Factory
6 115 (5.11%) Amazon S3
7 102 (4.53%) Serverless
8 79 (3.51%) Amazon EMR
9 67 (2.98%) Amazon Kinesis
9 67 (2.98%) AWS Lambda
10 60 (2.67%) SaaS
11 49 (2.18%) AWS CloudFormation
12 47 (2.09%) Matillion
13 45 (2.00%) Dynamics 365
14 44 (1.96%) Microsoft 365
15 42 (1.87%) IBM Cloud
16 40 (1.78%) PaaS
16 40 (1.78%) PowerApps
17 37 (1.64%) Logic Apps
18 36 (1.60%) Amazon EC2
Communications & Networking
1 31 (1.38%) HTTP
2 28 (1.24%) SSL
3 17 (0.76%) FTP
4 13 (0.58%) Firewall
4 13 (0.58%) Internet
5 11 (0.49%) TCP/IP
6 8 (0.36%) SSH
7 4 (0.18%) DNS
7 4 (0.18%) DSL
7 4 (0.18%) OpenVPN
8 3 (0.13%) Extranet
9 2 (0.089%) Intranet
9 2 (0.089%) SMS
Database & Business Intelligence
1 1,048 (46.58%) Data Warehouse
2 756 (33.60%) Power BI
3 694 (30.84%) SQL Server
4 653 (29.02%) SQL Server Integration Services
5 473 (21.02%) SQL Server Reporting Services
6 464 (20.62%) Big Data
7 326 (14.49%) SQL Server Analysis Services
8 322 (14.31%) Tableau
9 284 (12.62%) Data Lake
10 271 (12.04%) Hadoop
11 240 (10.67%) Amazon Redshift
12 224 (9.96%) Relational Database
13 206 (9.16%) NoSQL
14 175 (7.78%) Snowflake Schema
15 109 (4.84%) Looker
16 108 (4.80%) Azure SQL Database
16 108 (4.80%) Data Mining
17 104 (4.62%) Amazon Athena
17 104 (4.62%) PostgreSQL
18 94 (4.18%) MySQL
Development Applications
1 158 (7.02%) Git (software)
2 122 (5.42%) Jenkins
3 67 (2.98%) JIRA
4 47 (2.09%) Atlassian Bamboo
5 43 (1.91%) Vagrant
6 39 (1.73%) Visual Studio
7 31 (1.38%) Team Foundation Server
8 28 (1.24%) Selenium
9 24 (1.07%) Cucumber
9 24 (1.07%) Octopus Deploy
10 22 (0.98%) TeamCity
11 20 (0.89%) SQL Server Management Studio (SSMS)
12 19 (0.84%) Oracle APEX
13 17 (0.76%) ERwin
14 11 (0.49%) ER Studio
14 11 (0.49%) GitLab
14 11 (0.49%) Oracle Forms
15 10 (0.44%) Eclipse
16 9 (0.40%) Maven
16 9 (0.40%) Subversion
General
1 464 (20.62%) Finance
2 126 (5.60%) Marketing
3 100 (4.44%) Banking
4 65 (2.89%) Retail
5 47 (2.09%) Games
6 44 (1.96%) Manufacturing
7 36 (1.60%) Advertising
7 36 (1.60%) Legal
8 32 (1.42%) Telecoms
9 30 (1.33%) Public Sector
10 27 (1.20%) Law
11 20 (0.89%) Publishing
12 12 (0.53%) Aerospace
13 9 (0.40%) Digital Economy
13 9 (0.40%) Financial Institution
13 9 (0.40%) Pharmaceutical
14 8 (0.36%) Back Office
14 8 (0.36%) Housing Association
14 8 (0.36%) Investment Banking
15 7 (0.31%) Electronics
Job Titles
1 689 (30.62%) Data Engineer
2 635 (28.22%) Developer
3 304 (13.51%) Analyst
4 274 (12.18%) Business Intelligence Developer
5 201 (8.93%) Architect
6 149 (6.62%) Data Architect
7 132 (5.87%) Data Analyst
8 125 (5.56%) SQL Developer
9 110 (4.89%) Senior Data Engineer
10 105 (4.67%) Consultant
11 92 (4.09%) ETL Developer
12 79 (3.51%) Business Intelligence Analyst
13 77 (3.42%) Power BI Developer
14 74 (3.29%) DBA
15 73 (3.24%) Azure Engineer
15 73 (3.24%) Python Engineer
16 71 (3.16%) Senior Developer
17 69 (3.07%) AWS Engineer
17 69 (3.07%) Data Warehouse Developer
18 52 (2.31%) Business Analyst
Libraries, Frameworks & Software Standards
1 187 (8.31%) Kafka
2 122 (5.42%) .NET
3 103 (4.58%) Web Services
4 102 (4.53%) XML
5 94 (4.18%) REST
6 88 (3.91%) JSON
7 64 (2.84%) PySpark
8 62 (2.76%) Spark Streaming
9 54 (2.40%) RESTful
10 45 (2.00%) Middleware
11 43 (1.91%) HTML
12 41 (1.82%) Apache NiFi
13 40 (1.78%) Node.js
14 31 (1.38%) MDX
14 31 (1.38%) SOAP
15 28 (1.24%) CSS
16 24 (1.07%) Natural Language Processing
17 21 (0.93%) React
17 21 (0.93%) Spring
18 20 (0.89%) Elastic Stack
Miscellaneous
1 316 (14.04%) Analytical Skills
2 134 (5.96%) Data Structures
3 78 (3.47%) Greenfield Project
4 73 (3.24%) Management Information System
5 57 (2.53%) Algorithms
6 56 (2.49%) User Experience
7 32 (1.42%) Cloud Native
8 29 (1.29%) Self-Motivation
9 28 (1.24%) Reference Data
10 27 (1.20%) Mobile App
11 26 (1.16%) NHS
11 26 (1.16%) Public Cloud
11 26 (1.16%) Reinsurance
11 26 (1.16%) Virtual Team
12 23 (1.02%) Clustering
13 22 (0.98%) Life Science
14 19 (0.84%) Online Banking
15 16 (0.71%) Client/Server
15 16 (0.71%) Enterprise Software
15 16 (0.71%) Hedge funds
Operating Systems
1 127 (5.64%) Linux
2 45 (2.00%) Unix
3 34 (1.51%) Windows
4 12 (0.53%) Ubuntu
5 8 (0.36%) SUSE
5 8 (0.36%) Windows Server
6 5 (0.22%) Red Hat Enterprise Linux
7 1 (0.044%) AIX
7 1 (0.044%) CentOS
7 1 (0.044%) Solaris
Processes & Methodologies
1 1,166 (51.82%) Business Intelligence
2 769 (34.18%) Analytics
3 721 (32.04%) Agile Software Development
4 590 (26.22%) Data Modelling
5 433 (19.24%) Visualisation
6 411 (18.27%) Data Engineering
7 376 (16.71%) Data Science
8 300 (13.33%) DevOps
9 273 (12.13%) Migration
10 269 (11.96%) Problem-Solving
11 265 (11.78%) Data Architecture
12 264 (11.73%) Data Management
13 231 (10.27%) Data Analytics
14 229 (10.18%) Data Integration
14 229 (10.18%) Data Visualisation
15 224 (9.96%) Data Analysis
16 213 (9.47%) Machine Learning
17 183 (8.13%) Decision-Making
18 182 (8.09%) Software Engineering
19 164 (7.29%) Data Migration
Programming Languages
1 1,495 (66.44%) SQL
2 862 (38.31%) Python
3 309 (13.73%) T-SQL
4 291 (12.93%) Java
5 156 (6.93%) R
6 151 (6.71%) C#
7 108 (4.80%) Scala
8 103 (4.58%) JavaScript
9 100 (4.44%) Data Analysis Expressions (DAX)
10 79 (3.51%) PL/SQL
11 55 (2.44%) Bash Shell
12 45 (2.00%) C
13 44 (1.96%) PowerShell
14 36 (1.60%) C++
15 24 (1.07%) HiveQL
15 24 (1.07%) Shell Script
15 24 (1.07%) VBA
16 18 (0.80%) Go
16 18 (0.80%) MATLAB
17 17 (0.76%) TypeScript
Qualifications
1 244 (10.84%) Degree
2 88 (3.91%) Security Cleared
3 68 (3.02%) SC Cleared
4 51 (2.27%) Computer Science Degree
5 21 (0.93%) DV Cleared
5 21 (0.93%) ISEB
6 19 (0.84%) ISTQB
7 18 (0.80%) BPSS Clearance
8 13 (0.58%) PhD
9 12 (0.53%) Numerate Degree
9 12 (0.53%) Oracle Certification
10 11 (0.49%) DBS Check
11 10 (0.44%) Microsoft Certification
12 7 (0.31%) HND
12 7 (0.31%) ISTQB Foundation Certification
13 6 (0.27%) Master's Degree
14 5 (0.22%) AWS Certification
15 3 (0.13%) MBCS
15 3 (0.13%) OCP
15 3 (0.13%) TOGAF Certification
Quality Assurance & Compliance
1 230 (10.22%) Data Quality
2 84 (3.73%) QA
3 59 (2.62%) GDPR
4 15 (0.67%) SLA
5 6 (0.27%) ISO/IEC 27001
6 1 (0.044%) Actionable Recommendations
6 1 (0.044%) COBIT
6 1 (0.044%) HIPAA
6 1 (0.044%) HL7
6 1 (0.044%) IFRS
6 1 (0.044%) PCI DSS
6 1 (0.044%) Sarbanes-Oxley
System Software
1 197 (8.76%) Docker
2 45 (2.00%) HDFS
3 42 (1.87%) VirtualBox
4 16 (0.71%) Active Directory
5 9 (0.40%) Apache Flume
5 9 (0.40%) Apache ZooKeeper
6 8 (0.36%) vSphere
7 6 (0.27%) VMware Infrastructure
8 5 (0.22%) Virtual Machines
9 4 (0.18%) Oracle RAC
Systems Management
1 170 (7.56%) Kubernetes
2 110 (4.89%) Terraform
3 76 (3.38%) Ansible
4 42 (1.87%) Docker Swarm
5 18 (0.80%) Kibana
6 14 (0.62%) Puppet
7 13 (0.58%) Single Sign-On
8 11 (0.49%) logstash
9 10 (0.44%) Grafana
10 8 (0.36%) Hadoop YARN
10 8 (0.36%) Opscode Chef
11 6 (0.27%) Oracle RMAN
12 5 (0.22%) Oracle Enterprise Manager
13 4 (0.18%) Argo
13 4 (0.18%) Data Guard
14 3 (0.13%) HP ALM
14 3 (0.13%) Packer
15 2 (0.089%) Control-M
15 2 (0.089%) Oozie
15 2 (0.089%) Prometheus
Vendors
1 493 (21.91%) Microsoft
2 230 (10.22%) Oracle
3 216 (9.60%) Google
4 185 (8.22%) Informatica
5 171 (7.60%) Databricks
6 169 (7.51%) Talend
7 116 (5.16%) Salesforce.com
8 110 (4.89%) SAP
9 85 (3.78%) Cloudera
10 82 (3.64%) IBM
11 54 (2.40%) Hortonworks
12 47 (2.09%) Alteryx
13 34 (1.51%) Ab Initio
14 30 (1.33%) Cognos
15 24 (1.07%) Teradata
16 23 (1.02%) Splunk
17 16 (0.71%) Red Hat
18 15 (0.67%) MuleSoft
19 14 (0.62%) Adobe
19 14 (0.62%) VMware