Period
to 25 October 2020

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

Extract, Transform and Load (ETL)
UK
6 months to
25 Oct 2020
Same period 2019 Same period 2018
Rank 120 125 137
Rank change year-on-year +5 +12 +13
Permanent jobs citing ETL 1,307 3,667 4,085
As % of all permanent jobs advertised in the UK 2.68% 2.69% 2.48%
As % of the Processes & Methodologies category 2.90% 2.92% 2.70%
Number of salaries quoted 1,198 3,109 3,489
Median annual salary £55,000 £52,500 £52,500
Median salary % change year-on-year +4.76% - +5.00%
10th Percentile £36,250 £33,750 £35,000
90th Percentile £85,000 £85,000 £82,500
UK excluding London median annual salary £47,500 £47,000 £45,000
% change year-on-year +1.06% +4.44% -

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 45,137 125,557 151,176
As % of all permanent IT jobs advertised in the UK 92.42% 92.21% 91.93%
Number of salaries quoted 37,192 98,906 120,203
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% -
10th Percentile £32,753 £30,000 £29,000
90th Percentile £90,000 £86,250 £83,750
UK excluding London median annual salary £49,142 £45,000 £45,000
% change year-on-year +9.20% - +5.88%

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 25 October 2020.

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 25 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
England +6 1,225 £55,000 - 237
London -6 652 £65,000 +4.00% 115
UK excluding London +15 629 £47,500 +1.06% 147
North of England +23 166 £47,500 +5.56% 56
South East +60 159 £47,500 -5.00% 16
Work from Home +26 154 £51,000 -2.86% 31
Midlands +34 112 £50,000 +6.38% 21
North West +35 97 £50,000 +5.26% 33
South West +11 78 £45,000 - 10
West Midlands +9 64 £50,000 +5.26% 15
Yorkshire +50 60 £45,000 +0.69% 18
East of England +15 49 £52,500 +5.00% 17
East Midlands +86 48 £50,000 +11.11% 5
Scotland -7 34 £45,000 - 14
Wales +31 26 £47,500 +11.76% 6
North East -3 9 £38,500 +3.91% 5
Northern Ireland +22 5 £45,000 - 7

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

1 860 (65.80%) SQL
2 665 (50.88%) Business Intelligence
3 620 (47.44%) Data Warehouse
4 458 (35.04%) Azure
5 456 (34.89%) Python
6 442 (33.82%) SQL Server
7 410 (31.37%) Agile Software Development
8 405 (30.99%) SQL Server Integration Services
9 385 (29.46%) Analytics
10 380 (29.07%) Power Platform
11 378 (28.92%) Power BI
12 369 (28.23%) AWS
13 349 (26.70%) Data Modelling
14 301 (23.03%) Finance
15 273 (20.89%) Big Data
16 249 (19.05%) Microsoft
17 246 (18.82%) SQL Server Reporting Services
18 224 (17.14%) Java
19 199 (15.23%) Visualisation
20 195 (14.92%) T-SQL
21 193 (14.77%) Data Lake
22 189 (14.46%) Oracle
23 180 (13.77%) Tableau
24 178 (13.62%) SQL Server Analysis Services
25 173 (13.24%) Hadoop
26 171 (13.08%) DevOps
27 159 (12.17%) Data Engineering
28 155 (11.86%) GCP
29 152 (11.63%) Analytical Skills
30 150 (11.48%) Data Analytics

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 139 (10.64%) Apache Spark
2 61 (4.67%) Apache
3 54 (4.13%) SAS
4 51 (3.90%) Apache Airflow
5 39 (2.98%) Elasticsearch
6 24 (1.84%) SharePoint
7 9 (0.69%) Confluence
8 8 (0.61%) Tomcat
9 7 (0.54%) nginx
10 6 (0.46%) ArcGIS
10 6 (0.46%) IIS
10 6 (0.46%) OpenStack
11 5 (0.38%) Jupyter
11 5 (0.38%) Tornado
12 4 (0.31%) Anypoint
12 4 (0.31%) Apache Pig
12 4 (0.31%) CMS
13 3 (0.23%) Luigi
14 2 (0.15%) Drupal
14 2 (0.15%) Liferay
Applications
1 114 (8.72%) Microsoft Excel
2 13 (0.99%) Spreadsheet
3 9 (0.69%) Microsoft Office
4 5 (0.38%) SPSS
5 2 (0.15%) MS Visio
5 2 (0.15%) S-PLUS
6 1 (0.077%) Microsoft PowerPoint
6 1 (0.077%) Microsoft Project
Business Applications
1 27 (2.07%) Dynamics CRM
2 9 (0.69%) iTrent
2 9 (0.69%) Northgate Housing
3 8 (0.61%) Dynamics AX
3 8 (0.61%) Oracle Applications
4 5 (0.38%) Markit EDM
5 4 (0.31%) Eikon
6 3 (0.23%) Dynamics NAV
6 3 (0.23%) SAP MDG
7 2 (0.15%) Oracle Financials
7 2 (0.15%) Teamcenter
8 1 (0.077%) NetSuite
8 1 (0.077%) PolarLake
8 1 (0.077%) SAP MDM
8 1 (0.077%) SAP Oil and Gas
8 1 (0.077%) Sentinel
8 1 (0.077%) Shopify
8 1 (0.077%) Sparx Enterprise Architect
Cloud Services
1 458 (35.04%) Azure
2 380 (29.07%) Power Platform
3 369 (28.23%) AWS
4 155 (11.86%) GCP
5 109 (8.34%) Azure Data Factory
6 79 (6.04%) Amazon S3
7 46 (3.52%) Serverless
8 41 (3.14%) AWS Lambda
9 39 (2.98%) SaaS
10 34 (2.60%) Amazon Kinesis
11 31 (2.37%) Dynamics 365
12 21 (1.61%) PaaS
13 20 (1.53%) Amazon EMR
14 17 (1.30%) Azure Stack
15 16 (1.22%) Trello
16 15 (1.15%) Amazon EC2
17 14 (1.07%) AWS CloudFormation
18 11 (0.84%) Amazon ECS
18 11 (0.84%) Amazon SQS
18 11 (0.84%) GitHub
Communications & Networking
1 8 (0.61%) HTTP
2 7 (0.54%) WebEx
3 6 (0.46%) Firewall
3 6 (0.46%) TCP/IP
4 4 (0.31%) Internet
5 2 (0.15%) LAN
5 2 (0.15%) WAN
6 1 (0.077%) DSL
6 1 (0.077%) HTTPS
6 1 (0.077%) SAN
6 1 (0.077%) Skype
6 1 (0.077%) SSH
Database & Business Intelligence
1 620 (47.44%) Data Warehouse
2 442 (33.82%) SQL Server
3 405 (30.99%) SQL Server Integration Services
4 378 (28.92%) Power BI
5 273 (20.89%) Big Data
6 246 (18.82%) SQL Server Reporting Services
7 193 (14.77%) Data Lake
8 180 (13.77%) Tableau
9 178 (13.62%) SQL Server Analysis Services
10 173 (13.24%) Hadoop
11 125 (9.56%) Apache Hive
12 122 (9.33%) Snowflake Schema
13 121 (9.26%) NoSQL
14 114 (8.72%) Amazon Redshift
15 111 (8.49%) Relational Database
16 90 (6.89%) BigQuery
17 86 (6.58%) Azure SQL Database
18 77 (5.89%) MySQL
19 73 (5.59%) OLAP
20 68 (5.20%) Impala
Development Applications
1 89 (6.81%) Git (software)
2 63 (4.82%) JIRA
3 43 (3.29%) Selenium
4 35 (2.68%) Visual Studio
5 30 (2.30%) Cucumber
6 27 (2.07%) Jenkins
7 22 (1.68%) Team Foundation Server
8 14 (1.07%) Cypress.io
9 13 (0.99%) Visual Studio Team System
10 11 (0.84%) SQL Server Management Studio (SSMS)
11 9 (0.69%) Appium
12 8 (0.61%) C++Builder
12 8 (0.61%) Maven
12 8 (0.61%) WebDriver
13 6 (0.46%) LSMW
13 6 (0.46%) TeamCity
14 5 (0.38%) Eclipse
14 5 (0.38%) ERwin
14 5 (0.38%) RStudio
15 4 (0.31%) Subversion
General
1 301 (23.03%) Finance
2 55 (4.21%) Marketing
3 54 (4.13%) Banking
4 31 (2.37%) Retail
5 30 (2.30%) Advertising
6 22 (1.68%) Law
7 20 (1.53%) Manufacturing
8 15 (1.15%) Games
9 14 (1.07%) Telecoms
10 13 (0.99%) Back Office
10 13 (0.99%) Pharmaceutical
11 11 (0.84%) French Language
11 11 (0.84%) German Language
11 11 (0.84%) Public Sector
11 11 (0.84%) Spanish Language
12 9 (0.69%) Front Office
12 9 (0.69%) Social Housing
13 8 (0.61%) Legal
14 6 (0.46%) Digital Economy
14 6 (0.46%) Financial Institution
Job Titles
1 427 (32.67%) Developer
2 383 (29.30%) Data Engineer
3 173 (13.24%) Business Intelligence Developer
4 149 (11.40%) Analyst
5 121 (9.26%) SQL Developer
6 112 (8.57%) Architect
7 73 (5.59%) Data Architect
8 67 (5.13%) Senior Developer
9 66 (5.05%) Data Analyst
10 64 (4.90%) ETL Developer
10 64 (4.90%) SQL Server Developer
11 62 (4.74%) Consultant
12 56 (4.28%) Data Warehouse Developer
13 47 (3.60%) Azure Developer
13 47 (3.60%) SQL BI Developer
14 43 (3.29%) Business Developer
15 39 (2.98%) Azure Engineer
15 39 (2.98%) Senior Business Intelligence Developer
16 38 (2.91%) DBA
16 38 (2.91%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 80 (6.12%) .NET
2 76 (5.81%) Kafka
3 68 (5.20%) Web Services
4 60 (4.59%) REST
5 56 (4.28%) JSON
6 48 (3.67%) XML
7 47 (3.60%) HTML
8 45 (3.44%) RESTful
9 40 (3.06%) PySpark
10 35 (2.68%) SOAP
11 28 (2.14%) CSS
11 28 (2.14%) MDX
12 21 (1.61%) ASP.NET
13 18 (1.38%) Middleware
14 17 (1.30%) ASP.NET Web API
14 17 (1.30%) Natural Language Processing
15 16 (1.22%) .NET Framework
16 15 (1.15%) HTML5
17 14 (1.07%) Node.js
17 14 (1.07%) Spring
Miscellaneous
1 152 (11.63%) Analytical Skills
2 56 (4.28%) Management Information System
3 51 (3.90%) Self-Motivation
4 49 (3.75%) Data Structures
5 42 (3.21%) Greenfield Project
6 29 (2.22%) Algorithms
7 23 (1.76%) Cloud Native
8 18 (1.38%) Social Media
9 17 (1.30%) Mobile App
9 17 (1.30%) User Experience
10 13 (0.99%) Clustering
10 13 (0.99%) Reference Data
11 12 (0.92%) Reinsurance
11 12 (0.92%) Replication
11 12 (0.92%) Virtual Team
12 9 (0.69%) Hedge funds
12 9 (0.69%) Online Banking
13 7 (0.54%) Mobile Banking
13 7 (0.54%) NHS
14 6 (0.46%) Private Cloud
Operating Systems
1 65 (4.97%) Unix
2 62 (4.74%) Linux
3 31 (2.37%) Windows
4 7 (0.54%) Windows Server 2016
5 6 (0.46%) Ubuntu
6 3 (0.23%) Solaris
6 3 (0.23%) Windows 10
7 2 (0.15%) Windows Server
8 1 (0.077%) AIX
8 1 (0.077%) Android
8 1 (0.077%) Apple iOS
8 1 (0.077%) CentOS
Processes & Methodologies
1 665 (50.88%) Business Intelligence
2 410 (31.37%) Agile Software Development
3 385 (29.46%) Analytics
4 349 (26.70%) Data Modelling
5 199 (15.23%) Visualisation
6 171 (13.08%) DevOps
7 159 (12.17%) Data Engineering
8 150 (11.48%) Data Analytics
8 150 (11.48%) Data Science
8 150 (11.48%) Migration
9 130 (9.95%) Scrum
10 115 (8.80%) Data Analysis
10 115 (8.80%) Data Integration
10 115 (8.80%) Data Visualisation
11 113 (8.65%) Problem-Solving
12 109 (8.34%) Machine Learning
13 107 (8.19%) Data Management
14 106 (8.11%) Data Migration
15 103 (7.88%) Data Architecture
16 100 (7.65%) Requirements Gathering
Programming Languages
1 860 (65.80%) SQL
2 456 (34.89%) Python
3 224 (17.14%) Java
4 195 (14.92%) T-SQL
5 105 (8.03%) JavaScript
6 85 (6.50%) C#
7 83 (6.35%) R
8 70 (5.36%) Scala
9 58 (4.44%) Shell Script
10 57 (4.36%) PL/SQL
11 41 (3.14%) Data Analysis Expressions (DAX)
12 40 (3.06%) HiveQL
13 27 (2.07%) C
14 25 (1.91%) Bash Shell
14 25 (1.91%) C++
15 22 (1.68%) PowerShell
16 20 (1.53%) VBA
17 16 (1.22%) PHP
18 12 (0.92%) MATLAB
19 11 (0.84%) VB
Qualifications
1 118 (9.03%) Degree
2 41 (3.14%) Security Cleared
3 30 (2.30%) BPSS Clearance
4 28 (2.14%) SC Cleared
5 16 (1.22%) Computer Science Degree
5 16 (1.22%) DV Cleared
6 15 (1.15%) Microsoft Certification
7 10 (0.77%) AWS Certification
7 10 (0.77%) ISTQB
8 9 (0.69%) ISEB
9 5 (0.38%) PhD
10 4 (0.31%) ITIL Foundation Certificate
11 3 (0.23%) MCSA
12 2 (0.15%) Postgraduate
13 1 (0.077%) CBAP
13 1 (0.077%) HND
13 1 (0.077%) IIBA
13 1 (0.077%) ISTQB Advanced Certification
13 1 (0.077%) Master's Degree
Quality Assurance & Compliance
1 124 (9.49%) Data Quality
2 51 (3.90%) QA
3 30 (2.30%) GDPR
4 29 (2.22%) SLA
5 5 (0.38%) Sarbanes-Oxley
6 2 (0.15%) IFRS
7 1 (0.077%) EMIR
7 1 (0.077%) ISO/IEC 27001
7 1 (0.077%) MiFID
7 1 (0.077%) PMO
System Software
1 66 (5.05%) HDFS
2 49 (3.75%) Docker
3 14 (1.07%) Apache ZooKeeper
4 11 (0.84%) Active Directory
5 8 (0.61%) Apache Flume
6 7 (0.54%) Varnish
7 1 (0.077%) Tivoli Workload Scheduler
7 1 (0.077%) VirtualBox
Systems Management
1 35 (2.68%) Kubernetes
2 21 (1.61%) Hadoop YARN
3 14 (1.07%) Terraform
4 9 (0.69%) Puppet
5 5 (0.38%) Control-M
6 4 (0.31%) Ansible
6 4 (0.31%) CloudHub
6 4 (0.31%) HP Quality Center
6 4 (0.31%) Oozie
7 3 (0.23%) Opscode Chef
8 2 (0.15%) Fluentd
8 2 (0.15%) Microsoft Clustering
8 2 (0.15%) Oracle Enterprise Manager
8 2 (0.15%) Prometheus
9 1 (0.077%) Docker Swarm
9 1 (0.077%) Grafana
9 1 (0.077%) Kibana
9 1 (0.077%) logstash
9 1 (0.077%) Tivoli
Vendors
1 249 (19.05%) Microsoft
2 189 (14.46%) Oracle
3 107 (8.19%) Google
3 107 (8.19%) Informatica
4 88 (6.73%) Talend
5 74 (5.66%) Databricks
6 60 (4.59%) Cloudera
7 36 (2.75%) SAP
8 29 (2.22%) Alteryx
9 25 (1.91%) Ab Initio
9 25 (1.91%) Teradata
10 21 (1.61%) IBM
11 18 (1.38%) Salesforce.com
12 17 (1.30%) Cognos
13 13 (0.99%) MicroStrategy
14 9 (0.69%) Northgate
15 8 (0.61%) Borland
15 8 (0.61%) MuleSoft
15 8 (0.61%) Vertica
16 7 (0.54%) DoubleClick