Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 4 August 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 4 August 2020 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
UK
6 months to
4 Aug 2020		 Same period 2019 Same period 2018
Rank 116 124 137
Rank change year-on-year +8 +13 +10
Permanent jobs citing ETL 1,798 3,881 4,297
As % of all permanent jobs advertised in the UK 2.70% 2.71% 2.49%
As % of the Processes & Methodologies category 2.93% 2.94% 2.70%
Number of salaries quoted 1,351 3,339 3,642
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 £90,000 £82,500 £82,500
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% +1.12%

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 61,385 131,929 159,040
As % of all permanent IT jobs advertised in the UK 92.23% 92.23% 91.98%
Number of salaries quoted 48,971 103,918 126,923
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +1.01%
10th Percentile £32,500 £30,000 £29,000
90th Percentile £90,000 £86,250 £82,500
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +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 4 August 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 4 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
England +19 1,727 £55,000 - 158
London +5 945 £65,000 +8.33% 66
UK excluding London +12 830 £50,000 +5.26% 102
South East +41 258 £52,500 +3.96% 18
North of England +16 198 £50,000 +11.11% 29
Midlands +41 132 £50,000 +6.38% 26
North West +13 119 £50,000 +11.11% 18
East of England +22 102 £60,000 +20.00% 12
West Midlands +41 96 £51,000 +8.51% 13
Work from Home -5 88 £50,000 -4.76% 22
South West -17 82 £45,000 -5.26% 7
Yorkshire +43 67 £50,000 +11.11% 10
East Midlands +44 34 £48,000 +6.67% 13
Wales +30 30 £47,500 +9.20% 1
Scotland -38 27 £43,500 -3.33% 9
North East +12 12 £39,000 +4.00% 1
Northern Ireland +7 1 - -

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

1 1,256 (69.86%) SQL
2 944 (52.50%) Business Intelligence
3 791 (43.99%) SQL Server
4 734 (40.82%) Data Warehouse
5 652 (36.26%) Analytics
6 580 (32.26%) Python
7 541 (30.09%) SQL Server Integration Services
8 499 (27.75%) Azure
9 482 (26.81%) Power Platform
10 481 (26.75%) Data Modelling
11 477 (26.53%) Power BI
12 434 (24.14%) Tableau
13 424 (23.58%) Agile Software Development
14 403 (22.41%) Finance
15 397 (22.08%) Oracle
16 387 (21.52%) Analytical Skills
17 383 (21.30%) Microsoft
18 381 (21.19%) AWS
19 368 (20.47%) Data Lake
20 343 (19.08%) Visualisation
21 320 (17.80%) Degree
22 316 (17.58%) Data Analysis
23 311 (17.30%) Data Analytics
24 309 (17.19%) SQL Server Reporting Services
25 306 (17.02%) Big Data
26 250 (13.90%) T-SQL
27 233 (12.96%) SQL Server Analysis Services
28 214 (11.90%) Data Extraction
29 207 (11.51%) DevOps
29 207 (11.51%) Data Engineering

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 170 (9.45%) Apache Spark
2 58 (3.23%) Apache Airflow
3 56 (3.11%) Apache
4 50 (2.78%) SAS
5 35 (1.95%) Elasticsearch
6 34 (1.89%) SharePoint
7 13 (0.72%) Luigi
8 12 (0.67%) Apache Pig
9 10 (0.56%) IIS
10 9 (0.50%) Confluence
10 9 (0.50%) Jupyter
11 6 (0.33%) Apache Synapse
11 6 (0.33%) Tornado
12 5 (0.28%) Apache Solr
12 5 (0.28%) Tomcat
13 4 (0.22%) Anypoint
13 4 (0.22%) CMS
13 4 (0.22%) nginx
13 4 (0.22%) Oracle SOA Suite
14 3 (0.17%) Oracle Spatial
Applications
1 121 (6.73%) Microsoft Excel
2 22 (1.22%) Microsoft Office
3 11 (0.61%) SPSS
4 7 (0.39%) Spreadsheet
5 6 (0.33%) Microsoft Project
6 2 (0.11%) Microsoft PowerPoint
6 2 (0.11%) MS Visio
6 2 (0.11%) S-PLUS
7 1 (0.056%) InfoPath
7 1 (0.056%) Photoshop
Business Applications
1 14 (0.78%) Dynamics CRM
2 7 (0.39%) Oracle Financials
2 7 (0.39%) SAP MDG
3 6 (0.33%) Oracle General Ledger
4 5 (0.28%) iTrent
4 5 (0.28%) Oracle ERP
5 4 (0.22%) Adobe Campaign
5 4 (0.22%) Cognos TM1
5 4 (0.22%) Eikon
6 3 (0.17%) Infor SunSystems
6 3 (0.17%) Markit EDM
6 3 (0.17%) Raiser's Edge
6 3 (0.17%) SAP MDM
7 2 (0.11%) Dynamics AX
7 2 (0.11%) Dynamics GP
7 2 (0.11%) NetSuite
7 2 (0.11%) Northgate Housing
7 2 (0.11%) Teamcenter
7 2 (0.11%) Unit4 Business World
8 1 (0.056%) Salesforce.com CRM
Cloud Services
1 499 (27.75%) Azure
2 482 (26.81%) Power Platform
3 381 (21.19%) AWS
4 157 (8.73%) GCP
5 129 (7.17%) Azure Data Factory
6 69 (3.84%) Amazon S3
7 56 (3.11%) SaaS
8 51 (2.84%) Amazon EMR
9 42 (2.34%) Serverless
10 29 (1.61%) Dynamics 365
11 27 (1.50%) AWS Lambda
12 24 (1.33%) PaaS
13 23 (1.28%) Amazon Kinesis
14 19 (1.06%) Amazon EC2
15 18 (1.00%) PowerApps
16 17 (0.95%) Amazon ECS
17 16 (0.89%) IBM Cloud
18 15 (0.83%) Logic Apps
19 13 (0.72%) Amazon SQS
19 13 (0.72%) Office 365
Communications & Networking
1 8 (0.44%) WebEx
2 7 (0.39%) Network Security
3 6 (0.33%) Internet
4 5 (0.28%) HTTP
5 4 (0.22%) Intranet
6 3 (0.17%) Firewall
6 3 (0.17%) TCP/IP
7 2 (0.11%) Extranet
8 1 (0.056%) Broadband
8 1 (0.056%) DHCP
8 1 (0.056%) DNS
8 1 (0.056%) HTTPS
8 1 (0.056%) SAN
8 1 (0.056%) Skype
8 1 (0.056%) VPN
Database & Business Intelligence
1 791 (43.99%) SQL Server
2 734 (40.82%) Data Warehouse
3 541 (30.09%) SQL Server Integration Services
4 477 (26.53%) Power BI
5 368 (20.47%) Data Lake
6 309 (17.19%) SQL Server Reporting Services
7 306 (17.02%) Big Data
8 233 (12.96%) SQL Server Analysis Services
9 182 (10.12%) Hadoop
10 129 (7.17%) Snowflake Schema
11 126 (7.01%) Relational Database
12 120 (6.67%) Amazon Redshift
12 120 (6.67%) NoSQL
13 110 (6.12%) Oracle Reports
14 104 (5.78%) Azure SQL Database
15 102 (5.67%) Apache Hive
16 101 (5.62%) OLAP
17 86 (4.78%) PostgreSQL
18 84 (4.67%) BusinessObjects
19 75 (4.17%) BigQuery
Development Applications
1 97 (5.39%) Git (software)
2 58 (3.23%) JIRA
3 47 (2.61%) Jenkins
4 39 (2.17%) Visual Studio
5 29 (1.61%) SQL Server Management Studio (SSMS)
6 25 (1.39%) Selenium
7 21 (1.17%) Team Foundation Server
8 20 (1.11%) Visual Studio Team System
9 17 (0.95%) Cucumber
10 15 (0.83%) Vagrant
11 14 (0.78%) Atlassian Bamboo
12 10 (0.56%) LSMW
13 9 (0.50%) Bitbucket
13 9 (0.50%) Maven
13 9 (0.50%) TeamCity
14 7 (0.39%) Cypress.io
14 7 (0.39%) ERwin
14 7 (0.39%) WebDriver
15 6 (0.33%) Oracle Forms
15 6 (0.33%) tSQLt
General
1 403 (22.41%) Finance
2 93 (5.17%) Legal
3 85 (4.73%) Marketing
4 60 (3.34%) Retail
5 53 (2.95%) Banking
6 37 (2.06%) Advertising
7 35 (1.95%) Manufacturing
8 34 (1.89%) Law
9 29 (1.61%) Public Sector
10 21 (1.17%) Telecoms
11 15 (0.83%) Back Office
12 14 (0.78%) Games
13 9 (0.50%) Pharmaceutical
14 7 (0.39%) Financial Institution
15 6 (0.33%) Automotive
15 6 (0.33%) Electronics
16 5 (0.28%) Front Office
17 4 (0.22%) Investment Banking
17 4 (0.22%) Police
18 3 (0.17%) Publishing
Job Titles
1 544 (30.26%) Developer
2 438 (24.36%) Data Engineer
3 360 (20.02%) Analyst
4 221 (12.29%) Data Analyst
5 214 (11.90%) Business Intelligence Developer
6 165 (9.18%) SQL Developer
7 136 (7.56%) Architect
8 94 (5.23%) Senior Analyst
9 90 (5.01%) ETL Developer
10 88 (4.89%) Senior Developer
11 83 (4.62%) Data Architect
12 79 (4.39%) Senior Data Engineer
13 66 (3.67%) Senior Data Analyst
14 65 (3.62%) Business Intelligence Analyst
15 64 (3.56%) Consultant
15 64 (3.56%) Data Manager
16 63 (3.50%) Data Warehouse Developer
17 59 (3.28%) SQL Server Developer
18 56 (3.11%) Business Developer
19 54 (3.00%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 115 (6.40%) .NET
1 115 (6.40%) Kafka
2 98 (5.45%) Web Services
3 81 (4.51%) REST
4 77 (4.28%) HTML
5 76 (4.23%) XML
6 74 (4.12%) JSON
7 62 (3.45%) CSS
8 47 (2.61%) MDX
9 45 (2.50%) SOAP
10 36 (2.00%) PySpark
11 34 (1.89%) RESTful
12 33 (1.84%) ASP.NET
12 33 (1.84%) ASP.NET Web API
13 29 (1.61%) HTML5
14 27 (1.50%) AngularJS
15 26 (1.45%) Node.js
16 25 (1.39%) Pandas
16 25 (1.39%) TensorFlow
17 24 (1.33%) J2EE
Miscellaneous
1 387 (21.52%) Analytical Skills
2 107 (5.95%) Data Structures
3 78 (4.34%) Management Information System
4 63 (3.50%) Greenfield Project
5 51 (2.84%) Self-Motivation
6 28 (1.56%) Algorithms
7 23 (1.28%) User Experience
8 16 (0.89%) Acoustics
9 15 (0.83%) Reinsurance
10 14 (0.78%) Blog
11 13 (0.72%) Clustering
12 12 (0.67%) Reference Data
13 10 (0.56%) Derivative
14 9 (0.50%) Analytical Mindset
14 9 (0.50%) Cloud Native
14 9 (0.50%) OTC Derivatives
14 9 (0.50%) Social Media
15 8 (0.44%) Driving Licence
15 8 (0.44%) Mobile App
16 7 (0.39%) Hybrid Cloud
Operating Systems
1 67 (3.73%) Unix
2 58 (3.23%) Linux
3 27 (1.50%) Windows
4 9 (0.50%) Windows Server
5 6 (0.33%) Oracle Linux
6 4 (0.22%) Ubuntu
7 3 (0.17%) Windows 10
8 2 (0.11%) OpenVMS
8 2 (0.11%) Solaris
8 2 (0.11%) Windows Server 2016
9 1 (0.056%) Android
9 1 (0.056%) Apple iOS
9 1 (0.056%) Red Hat Enterprise Linux
9 1 (0.056%) Windows Server 2003
Processes & Methodologies
1 944 (52.50%) Business Intelligence
2 652 (36.26%) Analytics
3 481 (26.75%) Data Modelling
4 424 (23.58%) Agile Software Development
5 343 (19.08%) Visualisation
6 316 (17.58%) Data Analysis
7 311 (17.30%) Data Analytics
8 214 (11.90%) Data Extraction
9 207 (11.51%) Data Engineering
9 207 (11.51%) DevOps
10 181 (10.07%) Data Science
11 165 (9.18%) Migration
12 162 (9.01%) Proactive Monitoring
13 158 (8.79%) Data Visualisation
14 152 (8.45%) Data Integration
15 145 (8.06%) Data Management
15 145 (8.06%) Problem-Solving
16 142 (7.90%) Machine Learning
17 129 (7.17%) Project Management
18 123 (6.84%) Data Architecture
Programming Languages
1 1,256 (69.86%) SQL
2 580 (32.26%) Python
3 250 (13.90%) T-SQL
4 196 (10.90%) Java
5 162 (9.01%) C#
6 107 (5.95%) JavaScript
6 107 (5.95%) R
7 88 (4.89%) Scala
8 67 (3.73%) PL/SQL
9 57 (3.17%) Shell Script
10 55 (3.06%) Data Analysis Expressions (DAX)
11 34 (1.89%) PowerShell
12 24 (1.33%) C++
13 23 (1.28%) VBA
14 20 (1.11%) C
14 20 (1.11%) Go
15 19 (1.06%) HiveQL
16 12 (0.67%) Ruby
17 11 (0.61%) Java 8
18 10 (0.56%) Bash Shell
Qualifications
1 320 (17.80%) Degree
2 68 (3.78%) Security Cleared
3 45 (2.50%) SC Cleared
4 36 (2.00%) Computer Science Degree
5 16 (0.89%) BPSS Clearance
5 16 (0.89%) DV Cleared
6 13 (0.72%) ISTQB
7 10 (0.56%) AWS Certification
7 10 (0.56%) Microsoft Certification
7 10 (0.56%) Numerate Degree
8 9 (0.50%) PhD
9 8 (0.44%) ISEB
10 7 (0.39%) Master's Degree
11 6 (0.33%) ITIL Foundation Certificate
12 4 (0.22%) ISTQB Advanced Certification
12 4 (0.22%) MCSA
13 1 (0.056%) PMI Certification
13 1 (0.056%) Postgraduate
Quality Assurance & Compliance
1 179 (9.96%) Data Quality
2 88 (4.89%) GAAP
3 57 (3.17%) QA
4 28 (1.56%) GDPR
5 10 (0.56%) SLA
6 5 (0.28%) Sarbanes-Oxley
6 5 (0.28%) Solvency II
7 1 (0.056%) ISO/IEC 27001
7 1 (0.056%) PMO
System Software
1 71 (3.95%) Docker
2 36 (2.00%) HDFS
3 14 (0.78%) VirtualBox
4 12 (0.67%) Active Directory
5 9 (0.50%) Apache ZooKeeper
6 7 (0.39%) Virtual Servers
7 5 (0.28%) Tivoli Workload Scheduler
8 4 (0.22%) Apache Flume
8 4 (0.22%) Varnish
9 1 (0.056%) Virtual Machines
Systems Management
1 55 (3.06%) Kubernetes
2 37 (2.06%) Terraform
3 24 (1.33%) Ansible
4 15 (0.83%) Docker Swarm
4 15 (0.83%) Hadoop YARN
5 11 (0.61%) Puppet
6 10 (0.56%) Control-M
7 9 (0.50%) Opscode Chef
8 8 (0.44%) HP Quality Center
9 6 (0.33%) Oozie
10 5 (0.28%) CA Single Sign-On
10 5 (0.28%) Tivoli
11 4 (0.22%) CloudHub
11 4 (0.22%) Salt
12 3 (0.17%) Argo
12 3 (0.17%) Kibana
13 2 (0.11%) Fluentd
13 2 (0.11%) logstash
Vendors
1 434 (24.14%) Tableau
2 397 (22.08%) Oracle
3 383 (21.30%) Microsoft
4 204 (11.35%) Alteryx
5 187 (10.40%) Teradata
6 164 (9.12%) Blue Prism
6 164 (9.12%) UiPath
7 163 (9.07%) Informatica
8 162 (9.01%) Automation Anywhere
8 162 (9.01%) Cadence
9 111 (6.17%) Google
10 103 (5.73%) Talend
11 88 (4.89%) Databricks
12 77 (4.28%) IBM
13 71 (3.95%) SAP
14 51 (2.84%) Salesforce.com
15 49 (2.73%) Cloudera
16 33 (1.84%) Cognos
17 23 (1.28%) MicroStrategy
18 17 (0.95%) Hortonworks
173 ETL job vacancies Nationwide