Period
to 18 January 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 18 January 2021 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
UK
6 months to
18 Jan 2021
Same period 2020 Same period 2019
Rank 119 127 136
Rank change year-on-year +8 +9 +11
Permanent jobs citing ETL 1,705 3,256 3,768
As % of all permanent jobs advertised in the UK 2.72% 2.60% 2.49%
As % of the Processes & Methodologies category 2.95% 2.82% 2.70%
Number of salaries quoted 1,621 2,725 3,237
Median annual salary £55,000 £55,000 £55,000
10th Percentile £36,250 £34,971 £35,000
90th Percentile £86,250 £90,000 £82,500
UK excluding London median annual salary £47,750 £47,500 £47,500
% change year-on-year +0.53% - +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 57,835 115,507 139,683
As % of all permanent IT jobs advertised in the UK 92.31% 92.11% 92.23%
Number of salaries quoted 46,689 92,510 111,615
Median annual salary £55,000 £52,500 £52,500
Median salary % change year-on-year +4.76% - +5.00%
10th Percentile £32,500 £30,000 £29,763
90th Percentile £90,000 £87,500 £85,000
UK excluding London median annual salary £49,000 £45,591 £45,000
% change year-on-year +7.48% +1.31% -

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 18 January 2021.

Salary histogram for ETL in the UK

ETL
Top 17 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 18 January 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 +8 1,581 £57,500 +4.55% 291
London +11 878 £65,000 - 135
UK excluding London +11 755 £47,750 +0.53% 179
Work from Home +24 262 £55,000 -8.33% 48
North of England +17 250 £47,500 - 58
South East +25 156 £51,000 +2.00% 31
North West +15 135 £50,500 +6.32% 44
Midlands +28 124 £48,500 +2.11% 33
South West +1 96 £45,000 - 16
Yorkshire +37 92 £45,000 -5.26% 8
West Midlands -10 75 £47,500 - 27
East of England +14 57 £53,750 +7.50% 14
East Midlands +73 49 £50,000 +11.11% 6
Scotland -25 41 £46,750 +10.00% 14
Wales +36 27 £46,250 +8.82% 4
North East +6 23 £42,500 +10.39% 6
Northern Ireland +14 4 £45,000 - 10

For the 6 months to 18 January 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,129 (66.22%) SQL
2 874 (51.26%) Business Intelligence
3 804 (47.16%) Data Warehouse
4 632 (37.07%) Python
5 627 (36.77%) Azure
6 601 (35.25%) Agile Software Development
7 545 (31.96%) SQL Server
8 529 (31.03%) Power Platform
9 525 (30.79%) Power BI
10 513 (30.09%) Analytics
11 509 (29.85%) SQL Server Integration Services
12 492 (28.86%) AWS
13 446 (26.16%) Data Modelling
14 409 (23.99%) Finance
15 352 (20.65%) SQL Server Reporting Services
16 343 (20.12%) Microsoft
16 343 (20.12%) Big Data
17 286 (16.77%) Visualisation
18 277 (16.25%) Java
19 265 (15.54%) T-SQL
20 246 (14.43%) Data Science
21 244 (14.31%) Data Engineering
22 234 (13.72%) SQL Server Analysis Services
23 230 (13.49%) DevOps
24 227 (13.31%) Data Lake
25 222 (13.02%) GCP
26 218 (12.79%) Analytical Skills
27 216 (12.67%) Hadoop
27 216 (12.67%) Oracle
28 205 (12.02%) Migration

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 191 (11.20%) Apache Spark
2 91 (5.34%) Apache
3 70 (4.11%) Apache Airflow
4 62 (3.64%) Elasticsearch
5 53 (3.11%) SAS
6 34 (1.99%) SharePoint
7 18 (1.06%) Luigi
8 15 (0.88%) Confluence
9 14 (0.82%) Jupyter
10 13 (0.76%) Tornado
11 12 (0.70%) OpenStack
12 10 (0.59%) ArcGIS
13 6 (0.35%) Apache Pig
13 6 (0.35%) Liferay
14 4 (0.23%) IIS
14 4 (0.23%) Oracle SOA Suite
15 3 (0.18%) CMS
15 3 (0.18%) nginx
15 3 (0.18%) Tomcat
16 2 (0.12%) Sitecore CMS
Applications
1 119 (6.98%) Microsoft Excel
2 24 (1.41%) Microsoft Office
3 13 (0.76%) Spreadsheet
4 7 (0.41%) MS Visio
4 7 (0.41%) SPSS
5 4 (0.23%) Gliffy
6 1 (0.059%) Microsoft PowerPoint
Business Applications
1 35 (2.05%) Dynamics CRM
2 11 (0.65%) Dynamics AX
3 9 (0.53%) iTrent
3 9 (0.53%) Northgate Housing
4 8 (0.47%) Oracle Applications
4 8 (0.47%) SAP S/4HANA
5 4 (0.23%) Markit EDM
6 3 (0.18%) Dynamics NAV
6 3 (0.18%) Oracle Financials
7 2 (0.12%) FastStats
7 2 (0.12%) Maximo
7 2 (0.12%) Oracle ERP
7 2 (0.12%) Retail-J
7 2 (0.12%) SAP ERP
7 2 (0.12%) Siebel CRM
7 2 (0.12%) Sparx Enterprise Architect
8 1 (0.059%) Oracle General Ledger
8 1 (0.059%) Radian6
8 1 (0.059%) Salesforce.com CRM
8 1 (0.059%) SAP MDG
Cloud Services
1 627 (36.77%) Azure
2 529 (31.03%) Power Platform
3 492 (28.86%) AWS
4 222 (13.02%) GCP
5 159 (9.33%) Azure Data Factory
6 85 (4.99%) Amazon S3
7 59 (3.46%) Serverless
8 50 (2.93%) AWS Lambda
9 47 (2.76%) Amazon Kinesis
10 32 (1.88%) Dynamics 365
11 31 (1.82%) SaaS
12 29 (1.70%) Amazon EMR
13 24 (1.41%) Trello
14 23 (1.35%) PaaS
15 22 (1.29%) Azure Stack
16 20 (1.17%) Amazon SageMaker
16 20 (1.17%) AWS CloudFormation
17 18 (1.06%) Amazon EC2
18 17 (1.00%) GitHub
18 17 (1.00%) PowerApps
Communications & Networking
1 20 (1.17%) HTTP
2 12 (0.70%) Firewall
2 12 (0.70%) TCP/IP
3 8 (0.47%) Internet
3 8 (0.47%) SSL
4 2 (0.12%) Extranet
4 2 (0.12%) LAN
4 2 (0.12%) WAN
5 1 (0.059%) DNS
5 1 (0.059%) DSL
5 1 (0.059%) FTP
5 1 (0.059%) Intranet
5 1 (0.059%) OpenVPN
5 1 (0.059%) SAN
5 1 (0.059%) SSH
Database & Business Intelligence
1 804 (47.16%) Data Warehouse
2 545 (31.96%) SQL Server
3 525 (30.79%) Power BI
4 509 (29.85%) SQL Server Integration Services
5 352 (20.65%) SQL Server Reporting Services
6 343 (20.12%) Big Data
7 234 (13.72%) SQL Server Analysis Services
8 227 (13.31%) Data Lake
9 216 (12.67%) Hadoop
10 203 (11.91%) Tableau
11 181 (10.62%) Relational Database
12 165 (9.68%) Amazon Redshift
13 163 (9.56%) NoSQL
14 148 (8.68%) Snowflake Schema
15 106 (6.22%) Apache Hive
16 96 (5.63%) MySQL
17 92 (5.40%) BigQuery
18 90 (5.28%) Azure SQL Database
19 85 (4.99%) PostgreSQL
20 84 (4.93%) BusinessObjects
Development Applications
1 123 (7.21%) Git (software)
2 71 (4.16%) JIRA
3 54 (3.17%) Jenkins
4 51 (2.99%) Selenium
5 40 (2.35%) Cucumber
6 36 (2.11%) Visual Studio
7 24 (1.41%) Team Foundation Server
8 20 (1.17%) SQL Server Management Studio (SSMS)
9 17 (1.00%) TeamCity
10 14 (0.82%) Maven
11 13 (0.76%) Octopus Deploy
12 12 (0.70%) Appium
12 12 (0.70%) Oracle APEX
13 11 (0.65%) Cypress.io
14 10 (0.59%) Eclipse
15 8 (0.47%) Atlassian Bamboo
15 8 (0.47%) C++Builder
15 8 (0.47%) Eclipse RCP
15 8 (0.47%) Visual Studio Team System
15 8 (0.47%) WebDriver
General
1 409 (23.99%) Finance
2 91 (5.34%) Marketing
3 90 (5.28%) Banking
4 44 (2.58%) Retail
5 40 (2.35%) Games
6 30 (1.76%) Manufacturing
7 28 (1.64%) Law
8 21 (1.23%) Advertising
8 21 (1.23%) Legal
9 19 (1.11%) Telecoms
10 15 (0.88%) German Language
11 14 (0.82%) Public Sector
12 11 (0.65%) French Language
12 11 (0.65%) Spanish Language
13 10 (0.59%) Social Housing
14 8 (0.47%) Back Office
14 8 (0.47%) Digital Economy
14 8 (0.47%) Pharmaceutical
15 7 (0.41%) Aerospace
15 7 (0.41%) Front Office
Job Titles
1 534 (31.32%) Developer
2 498 (29.21%) Data Engineer
3 215 (12.61%) Analyst
4 214 (12.55%) Business Intelligence Developer
5 134 (7.86%) Architect
6 112 (6.57%) SQL Developer
7 99 (5.81%) Data Architect
8 96 (5.63%) Data Analyst
9 86 (5.04%) Consultant
10 81 (4.75%) Senior Developer
11 66 (3.87%) Senior Data Engineer
12 62 (3.64%) ETL Developer
13 61 (3.58%) DBA
14 55 (3.23%) Data Warehouse Developer
15 53 (3.11%) Python Engineer
16 46 (2.70%) SQL Server Developer
17 45 (2.64%) Azure Engineer
18 44 (2.58%) Business Intelligence Analyst
19 42 (2.46%) Power BI Developer
19 42 (2.46%) SQL DBA
Libraries, Frameworks & Software Standards
1 118 (6.92%) Kafka
2 89 (5.22%) .NET
3 88 (5.16%) Web Services
4 75 (4.40%) REST
5 63 (3.70%) XML
6 61 (3.58%) JSON
7 60 (3.52%) RESTful
8 54 (3.17%) HTML
9 47 (2.76%) PySpark
10 40 (2.35%) SOAP
11 29 (1.70%) CSS
11 29 (1.70%) Middleware
11 29 (1.70%) Node.js
12 27 (1.58%) Apache NiFi
13 26 (1.52%) Natural Language Processing
14 23 (1.35%) Spring
15 22 (1.29%) ASP.NET
15 22 (1.29%) Spring Boot
16 21 (1.23%) Flask
16 21 (1.23%) MDX
Miscellaneous
1 218 (12.79%) Analytical Skills
2 87 (5.10%) Data Structures
3 69 (4.05%) Management Information System
4 63 (3.70%) Algorithms
5 57 (3.34%) Greenfield Project
6 47 (2.76%) Self-Motivation
7 36 (2.11%) Cloud Native
8 34 (1.99%) Mobile App
9 29 (1.70%) User Experience
10 25 (1.47%) Reference Data
11 23 (1.35%) Clustering
11 23 (1.35%) Online Banking
12 22 (1.29%) NHS
13 21 (1.23%) Social Media
13 21 (1.23%) Virtual Team
14 17 (1.00%) Reinsurance
15 16 (0.94%) Mobile Banking
16 13 (0.76%) Life Science
17 11 (0.65%) Public Cloud
18 10 (0.59%) Private Cloud
Operating Systems
1 90 (5.28%) Linux
2 70 (4.11%) Unix
3 28 (1.64%) Windows
4 12 (0.70%) Ubuntu
5 7 (0.41%) Windows Server 2016
6 1 (0.059%) AIX
6 1 (0.059%) CentOS
6 1 (0.059%) Solaris
Processes & Methodologies
1 874 (51.26%) Business Intelligence
2 601 (35.25%) Agile Software Development
3 513 (30.09%) Analytics
4 446 (26.16%) Data Modelling
5 286 (16.77%) Visualisation
6 246 (14.43%) Data Science
7 244 (14.31%) Data Engineering
8 230 (13.49%) DevOps
9 205 (12.02%) Migration
10 175 (10.26%) Data Management
11 174 (10.21%) Data Analysis
12 169 (9.91%) Machine Learning
13 166 (9.74%) Problem-Solving
14 162 (9.50%) Data Analytics
15 161 (9.44%) Data Visualisation
16 158 (9.27%) Data Architecture
17 142 (8.33%) Data Integration
18 141 (8.27%) Scrum
19 130 (7.62%) Software Engineering
20 127 (7.45%) Data Migration
Programming Languages
1 1,129 (66.22%) SQL
2 632 (37.07%) Python
3 277 (16.25%) Java
4 265 (15.54%) T-SQL
5 124 (7.27%) R
6 123 (7.21%) JavaScript
7 99 (5.81%) C#
8 95 (5.57%) Scala
9 79 (4.63%) PL/SQL
10 59 (3.46%) Data Analysis Expressions (DAX)
11 55 (3.23%) Shell Script
12 49 (2.87%) Bash Shell
13 41 (2.40%) HiveQL
14 40 (2.35%) C
15 31 (1.82%) VBA
16 28 (1.64%) C++
17 26 (1.52%) PowerShell
18 22 (1.29%) PHP
19 20 (1.17%) MATLAB
20 12 (0.70%) Apex Code
Qualifications
1 167 (9.79%) Degree
2 42 (2.46%) Security Cleared
3 36 (2.11%) SC Cleared
4 30 (1.76%) BPSS Clearance
5 20 (1.17%) Computer Science Degree
6 17 (1.00%) ISEB
7 15 (0.88%) PhD
8 14 (0.82%) ISTQB
9 10 (0.59%) DV Cleared
10 9 (0.53%) DBS Check
11 7 (0.41%) Microsoft Certification
12 5 (0.29%) AWS Certification
12 5 (0.29%) HND
13 4 (0.23%) Oracle Certification
13 4 (0.23%) Tableau Certification
14 3 (0.18%) Numerate Degree
14 3 (0.18%) Postgraduate
15 2 (0.12%) MBCS
15 2 (0.12%) OCP
15 2 (0.12%) TOGAF Certification
Quality Assurance & Compliance
1 192 (11.26%) Data Quality
2 84 (4.93%) QA
3 45 (2.64%) GDPR
4 26 (1.52%) SLA
5 5 (0.29%) ISO/IEC 27001
6 2 (0.12%) IFRS
7 1 (0.059%) COBIT
7 1 (0.059%) EMIR
7 1 (0.059%) HIPAA
7 1 (0.059%) HL7
7 1 (0.059%) MiFID
7 1 (0.059%) PCI DSS
7 1 (0.059%) PMO
System Software
1 85 (4.99%) Docker
2 65 (3.81%) HDFS
3 13 (0.76%) Active Directory
4 11 (0.65%) Apache ZooKeeper
5 6 (0.35%) Apache Flume
5 6 (0.35%) VirtualBox
6 3 (0.18%) Varnish
7 1 (0.059%) Tivoli Workload Scheduler
Systems Management
1 65 (3.81%) Kubernetes
2 31 (1.82%) Terraform
3 17 (1.00%) Puppet
4 14 (0.82%) Ansible
4 14 (0.82%) Hadoop YARN
5 7 (0.41%) Opscode Chef
6 6 (0.35%) Control-M
6 6 (0.35%) Docker Swarm
7 4 (0.23%) Oozie
8 3 (0.18%) Microsoft Clustering
9 2 (0.12%) Grafana
9 2 (0.12%) Oracle Enterprise Manager
9 2 (0.12%) Oracle RMAN
9 2 (0.12%) Prometheus
10 1 (0.059%) Kibana
10 1 (0.059%) logstash
10 1 (0.059%) Tivoli
10 1 (0.059%) WebSphere Cast Iron
Vendors
1 343 (20.12%) Microsoft
2 216 (12.67%) Oracle
3 159 (9.33%) Google
4 133 (7.80%) Informatica
5 131 (7.68%) Talend
6 114 (6.69%) Databricks
7 69 (4.05%) Cloudera
8 65 (3.81%) SAP
9 60 (3.52%) Salesforce.com
10 38 (2.23%) IBM
11 36 (2.11%) Alteryx
12 25 (1.47%) Ab Initio
13 22 (1.29%) Cognos
14 21 (1.23%) Teradata
15 13 (0.76%) Splunk
16 12 (0.70%) MuleSoft
16 12 (0.70%) Red Hat
17 11 (0.65%) TIBCO
18 10 (0.59%) Jitterbit
19 9 (0.53%) Hortonworks