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

Extract, Transform and Load (ETL)
UK
6 months to
28 Mar 2020
Same period 2019 Same period 2018
Rank 121 130 137
Rank change year-on-year +9 +7 +4
Permanent jobs citing ETL 3,141 3,839 4,261
As % of all permanent jobs advertised in the UK 2.64% 2.59% 2.42%
As % of the Processes & Methodologies category 2.88% 2.81% 2.62%
Number of salaries quoted 2,499 3,264 3,655
Median annual salary £57,500 £55,000 £52,500
Median salary % change year-on-year +4.55% +4.76% +5.00%
10th Percentile £36,250 £33,750 £33,879
90th Percentile £90,000 £83,750 £80,000
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +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 109,164 136,674 162,480
As % of all permanent IT jobs advertised in the UK 91.92% 92.24% 92.20%
Number of salaries quoted 86,514 107,624 132,472
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £31,250 £30,000 £29,000
90th Percentile £88,750 £85,000 £81,250
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 28 March 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 28 March 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 +18 2,986 £57,500 +2.68% 451
London +11 1,709 £65,000 +7.44% 188
UK excluding London +13 1,387 £50,000 +5.26% 288
South East +32 422 £55,000 - 58
North of England +25 361 £50,000 +16.28% 77
North West +55 233 £50,000 +17.65% 41
Midlands +7 176 £47,500 - 63
South West -11 157 £42,500 -15.00% 35
East of England +22 143 £52,500 -12.50% 30
West Midlands +16 139 £47,500 -5.00% 46
Work from Home +15 139 £60,000 +3.45% 21
Yorkshire -16 103 £50,000 +11.11% 35
Scotland -25 70 £42,500 - 15
Wales +9 49 £42,500 +21.43% 9
East Midlands -14 35 £45,000 +5.88% 17
North East -13 25 £42,000 -5.97% 1
Northern Ireland +6 10 £45,000 +63.64% 1

For the 6 months to 28 March 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 2,233 (71.09%) SQL
2 1,563 (49.76%) Business Intelligence
3 1,391 (44.29%) Data Warehouse
4 1,344 (42.79%) SQL Server
5 1,040 (33.11%) Analytics
6 970 (30.88%) SQL Server Integration Services
7 918 (29.23%) Python
8 820 (26.11%) Azure
9 816 (25.98%) Finance
10 805 (25.63%) Agile Software Development
11 792 (25.21%) Power Platform
12 788 (25.09%) Power BI
13 784 (24.96%) Data Modelling
14 680 (21.65%) Microsoft
15 628 (19.99%) Analytical Skills
16 627 (19.96%) AWS
17 626 (19.93%) SQL Server Reporting Services
18 615 (19.58%) Tableau
19 566 (18.02%) Oracle
20 563 (17.92%) Visualisation
21 561 (17.86%) Big Data
22 555 (17.67%) T-SQL
23 462 (14.71%) Data Lake
24 460 (14.65%) Data Analysis
25 446 (14.20%) Degree
26 422 (13.44%) SQL Server Analysis Services
27 404 (12.86%) Java
28 386 (12.29%) Data Analytics
29 362 (11.52%) Data Science
30 357 (11.37%) DevOps

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 348 (11.08%) Apache Spark
2 116 (3.69%) Apache Airflow
3 97 (3.09%) Apache
4 83 (2.64%) SAS
5 63 (2.01%) SharePoint
6 60 (1.91%) Elasticsearch
7 35 (1.11%) Luigi
8 34 (1.08%) Confluence
9 20 (0.64%) ArcGIS
10 17 (0.54%) Apache Pig
11 15 (0.48%) Jupyter
11 15 (0.48%) Tornado
12 9 (0.29%) IIS
12 9 (0.29%) Oracle Workflow
12 9 (0.29%) Tomcat
13 8 (0.25%) Mule
14 7 (0.22%) MQSeries
15 6 (0.19%) Apache Solr
15 6 (0.19%) BizTalk Server
15 6 (0.19%) Oracle Spatial
Applications
1 196 (6.24%) Microsoft Excel
2 58 (1.85%) Microsoft Office
3 33 (1.05%) SPSS
4 11 (0.35%) MS Visio
5 10 (0.32%) Microsoft PowerPoint
6 7 (0.22%) Spreadsheet
7 6 (0.19%) Microsoft Project
8 1 (0.032%) InfoPath
8 1 (0.032%) Photoshop
Business Applications
1 24 (0.76%) Dynamics CRM
2 20 (0.64%) Dynamics GP
3 15 (0.48%) Cognos TM1
4 11 (0.35%) Oracle EBS
4 11 (0.35%) Oracle Financials
5 9 (0.29%) SAP MDG
6 8 (0.25%) Cognos Business Intelligence
7 7 (0.22%) NetSuite
7 7 (0.22%) Sparx Enterprise Architect
8 6 (0.19%) Salesforce.com CRM
9 5 (0.16%) Infor SunSystems
9 5 (0.16%) iTrent
9 5 (0.16%) Markit EDM
9 5 (0.16%) RiskWrite
10 4 (0.13%) Actimize
10 4 (0.13%) Oracle ERP
10 4 (0.13%) Oracle General Ledger
10 4 (0.13%) Raiser's Edge
10 4 (0.13%) SAP MDM
11 3 (0.096%) Adobe Campaign
Cloud Services
1 820 (26.11%) Azure
2 792 (25.21%) Power Platform
3 627 (19.96%) AWS
4 291 (9.26%) GCP
5 160 (5.09%) Azure Data Factory
6 125 (3.98%) Amazon S3
7 119 (3.79%) Amazon EMR
8 73 (2.32%) SaaS
9 68 (2.16%) Serverless
10 58 (1.85%) Amazon EC2
11 47 (1.50%) Amazon Kinesis
12 43 (1.37%) Dynamics 365
13 42 (1.34%) AWS Lambda
13 42 (1.34%) GitHub
14 40 (1.27%) Cloud Computing
15 36 (1.15%) PaaS
16 35 (1.11%) IBM Cloud
17 31 (0.99%) Office 365
18 27 (0.86%) Amazon SQS
18 27 (0.86%) IaaS
Communications & Networking
1 18 (0.57%) Internet
2 11 (0.35%) SNA
3 10 (0.32%) DNS
4 8 (0.25%) DHCP
4 8 (0.25%) SAN
5 7 (0.22%) Firewall
5 7 (0.22%) Network Security
6 6 (0.19%) VLAN
7 5 (0.16%) FTP
7 5 (0.16%) Intranet
8 4 (0.13%) HTTP
9 3 (0.096%) Extranet
10 2 (0.064%) DOCSIS
10 2 (0.064%) TCP/IP
10 2 (0.064%) VPN
11 1 (0.032%) ASN.1
11 1 (0.032%) Broadband
11 1 (0.032%) NAS
11 1 (0.032%) Radio Access Network
11 1 (0.032%) Software-Defined Networking
Database & Business Intelligence
1 1,391 (44.29%) Data Warehouse
2 1,344 (42.79%) SQL Server
3 970 (30.88%) SQL Server Integration Services
4 788 (25.09%) Power BI
5 626 (19.93%) SQL Server Reporting Services
6 561 (17.86%) Big Data
7 462 (14.71%) Data Lake
8 422 (13.44%) SQL Server Analysis Services
9 303 (9.65%) Hadoop
10 298 (9.49%) Relational Database
11 277 (8.82%) Amazon Redshift
12 275 (8.76%) NoSQL
13 211 (6.72%) PostgreSQL
14 208 (6.62%) Snowflake Schema
15 176 (5.60%) Azure SQL Database
16 138 (4.39%) Oracle Reports
17 127 (4.04%) OLAP
18 123 (3.92%) Apache Hive
19 119 (3.79%) BigQuery
20 118 (3.76%) MongoDB
Development Applications
1 160 (5.09%) Git (software)
2 108 (3.44%) JIRA
3 92 (2.93%) Jenkins
4 72 (2.29%) Visual Studio
5 62 (1.97%) Team Foundation Server
6 53 (1.69%) Visual Studio Team System
7 49 (1.56%) SQL Server Management Studio (SSMS)
8 37 (1.18%) Vagrant
9 33 (1.05%) Atlassian Bamboo
10 19 (0.60%) Eclipse
11 18 (0.57%) GitLab
12 17 (0.54%) ERwin
13 15 (0.48%) TeamCity
14 13 (0.41%) Bitbucket
15 12 (0.38%) Cucumber
16 11 (0.35%) Postman
16 11 (0.35%) SoapUI
16 11 (0.35%) Subversion
17 10 (0.32%) Eclipse RCP
17 10 (0.32%) Selenium
General
1 816 (25.98%) Finance
2 151 (4.81%) Marketing
3 146 (4.65%) Legal
4 127 (4.04%) Retail
5 97 (3.09%) Banking
6 75 (2.39%) Public Sector
7 72 (2.29%) Law
8 71 (2.26%) Manufacturing
9 50 (1.59%) Games
10 39 (1.24%) Financial Institution
10 39 (1.24%) Telecoms
11 38 (1.21%) Advertising
12 34 (1.08%) Automotive
13 31 (0.99%) Publishing
14 14 (0.45%) Front Office
15 13 (0.41%) Electronics
16 11 (0.35%) Back Office
17 10 (0.32%) Military
18 7 (0.22%) Aerospace
18 7 (0.22%) Billing
Job Titles
1 1,009 (32.12%) Developer
2 610 (19.42%) Data Engineer
3 531 (16.91%) Analyst
4 365 (11.62%) Business Intelligence Developer
5 313 (9.96%) SQL Developer
6 286 (9.11%) Architect
7 270 (8.60%) Data Analyst
8 191 (6.08%) Data Architect
9 171 (5.44%) Senior Developer
10 165 (5.25%) ETL Developer
11 143 (4.55%) Senior Data Engineer
12 130 (4.14%) Business Intelligence Analyst
13 124 (3.95%) DBA
14 116 (3.69%) Consultant
15 104 (3.31%) Senior Analyst
16 92 (2.93%) SQL DBA
17 91 (2.90%) SQL Server Developer
18 90 (2.87%) Data Warehouse Developer
19 88 (2.80%) Data Manager
20 83 (2.64%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 204 (6.49%) Kafka
2 183 (5.83%) Web Services
3 179 (5.70%) .NET
4 130 (4.14%) XML
5 119 (3.79%) HTML
6 112 (3.57%) REST
7 95 (3.02%) CSS
8 93 (2.96%) JSON
9 77 (2.45%) MDX
10 69 (2.20%) SOAP
11 59 (1.88%) Node.js
12 51 (1.62%) Spark Streaming
13 44 (1.40%) AngularJS
13 44 (1.40%) ASP.NET
14 42 (1.34%) Natural Language Processing
14 42 (1.34%) RESTful
14 42 (1.34%) TensorFlow
15 38 (1.21%) J2EE
16 34 (1.08%) jQuery
17 33 (1.05%) Middleware
Miscellaneous
1 628 (19.99%) Analytical Skills
2 178 (5.67%) Data Structures
3 163 (5.19%) Management Information System
4 89 (2.83%) Greenfield Project
5 68 (2.16%) Self-Motivation
6 61 (1.94%) Algorithms
7 40 (1.27%) User Experience
8 38 (1.21%) Enterprise Software
9 35 (1.11%) Reinsurance
10 33 (1.05%) Blog
11 32 (1.02%) Public Cloud
12 31 (0.99%) Acoustics
13 27 (0.86%) Cloud Native
13 27 (0.86%) Data Centre
14 23 (0.73%) Tandem
15 21 (0.67%) Social Media
16 19 (0.60%) Clustering
16 19 (0.60%) Reference Data
17 18 (0.57%) Semantic Web
17 18 (0.57%) Social Network
Operating Systems
1 139 (4.43%) Linux
2 102 (3.25%) Unix
3 68 (2.16%) Windows
4 27 (0.86%) Windows Server
5 12 (0.38%) Oracle Linux
6 4 (0.13%) Red Hat Enterprise Linux
7 3 (0.096%) CentOS
8 2 (0.064%) OpenVMS
8 2 (0.064%) Solaris
9 1 (0.032%) Android
9 1 (0.032%) Apple iOS
9 1 (0.032%) Ubuntu
9 1 (0.032%) Windows Server 2003
Processes & Methodologies
1 1,563 (49.76%) Business Intelligence
2 1,040 (33.11%) Analytics
3 805 (25.63%) Agile Software Development
4 784 (24.96%) Data Modelling
5 563 (17.92%) Visualisation
6 460 (14.65%) Data Analysis
7 386 (12.29%) Data Analytics
8 362 (11.52%) Data Science
9 357 (11.37%) DevOps
10 354 (11.27%) Migration
11 317 (10.09%) Data Engineering
12 309 (9.84%) Data Integration
13 297 (9.46%) Problem-Solving
14 272 (8.66%) Data Architecture
15 267 (8.50%) Data Visualisation
16 246 (7.83%) Data Extraction
17 240 (7.64%) Machine Learning
18 232 (7.39%) Data Management
19 219 (6.97%) Project Management
20 200 (6.37%) Data Migration
Programming Languages
1 2,233 (71.09%) SQL
2 918 (29.23%) Python
3 555 (17.67%) T-SQL
4 404 (12.86%) Java
5 332 (10.57%) C#
6 203 (6.46%) Scala
7 178 (5.67%) R
8 155 (4.93%) JavaScript
9 128 (4.08%) PL/SQL
10 100 (3.18%) Data Analysis Expressions (DAX)
11 86 (2.74%) PowerShell
12 56 (1.78%) Shell Script
13 55 (1.75%) VBA
14 43 (1.37%) C++
14 43 (1.37%) Go
15 39 (1.24%) C
16 27 (0.86%) Bash Shell
17 22 (0.70%) VB.NET
18 21 (0.67%) VB
19 18 (0.57%) PHP
Qualifications
1 446 (14.20%) Degree
2 96 (3.06%) Security Cleared
3 82 (2.61%) Computer Science Degree
4 66 (2.10%) SC Cleared
5 21 (0.67%) ISTQB
6 16 (0.51%) Numerate Degree
7 12 (0.38%) Master's Degree
8 11 (0.35%) PhD
9 10 (0.32%) Microsoft Certification
10 8 (0.25%) PMI Certification
11 6 (0.19%) HND
12 5 (0.16%) ISEB
12 5 (0.16%) MCSA
12 5 (0.16%) Postgraduate
13 4 (0.13%) DV Cleared
13 4 (0.13%) ISTQB Foundation Certification
14 3 (0.096%) ISTQB Advanced Certification
15 2 (0.064%) AWS Certification
15 2 (0.064%) ITIL Foundation Certificate
16 1 (0.032%) MBA
Quality Assurance & Compliance
1 315 (10.03%) Data Quality
2 142 (4.52%) QA
3 93 (2.96%) GAAP
4 50 (1.59%) GDPR
5 23 (0.73%) Solvency II
6 13 (0.41%) ISO/IEC 27001
6 13 (0.41%) SLA
7 7 (0.22%) Dodd-Frank
7 7 (0.22%) EMIR
7 7 (0.22%) MiFID
8 4 (0.13%) COBIT
8 4 (0.13%) HL7
9 3 (0.096%) CDISC
10 1 (0.032%) Basel III
10 1 (0.032%) DICOM
10 1 (0.032%) HIPAA
10 1 (0.032%) IFRS
10 1 (0.032%) IFRS 9
10 1 (0.032%) PMO
System Software
1 148 (4.71%) Docker
2 33 (1.05%) VirtualBox
3 29 (0.92%) HDFS
4 25 (0.80%) Active Directory
5 11 (0.35%) Apache ZooKeeper
6 10 (0.32%) Apache Flume
7 9 (0.29%) Hyper-V
8 7 (0.22%) Oracle RAC
8 7 (0.22%) Virtual Servers
9 6 (0.19%) Virtual Machines
10 5 (0.16%) Tivoli Workload Scheduler
10 5 (0.16%) VMware Infrastructure
11 2 (0.064%) Varnish
12 1 (0.032%) Terminal Server
Systems Management
1 128 (4.08%) Kubernetes
2 86 (2.74%) Terraform
3 74 (2.36%) Ansible
4 38 (1.21%) Docker Swarm
5 24 (0.76%) Puppet
6 21 (0.67%) Opscode Chef
7 20 (0.64%) Oozie
8 14 (0.45%) Hadoop YARN
9 12 (0.38%) Control-M
10 6 (0.19%) Failover Clustering
11 5 (0.16%) Salt
11 5 (0.16%) Tivoli
12 4 (0.13%) BMC PATROL
12 4 (0.13%) Kibana
13 3 (0.096%) BladeLogic
13 3 (0.096%) logstash
13 3 (0.096%) Mesos
14 2 (0.064%) CA Single Sign-On
14 2 (0.064%) Consul
14 2 (0.064%) HP Quality Center
Vendors
1 680 (21.65%) Microsoft
2 615 (19.58%) Tableau
3 566 (18.02%) Oracle
4 330 (10.51%) Informatica
5 226 (7.20%) Teradata
6 225 (7.16%) Alteryx
7 223 (7.10%) Google
8 182 (5.79%) Cadence
9 179 (5.70%) Blue Prism
9 179 (5.70%) UiPath
10 178 (5.67%) Automation Anywhere
11 177 (5.64%) Talend
12 173 (5.51%) IBM
13 127 (4.04%) Salesforce.com
14 126 (4.01%) Databricks
15 124 (3.95%) SAP
16 75 (2.39%) Cloudera
17 71 (2.26%) Cognos
18 43 (1.37%) Hortonworks
19 35 (1.11%) RedGate