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

Extract, Transform and Load (ETL)
UK
6 months to
28 Jan 2020
Same period 2019 Same period 2018
Rank 125 136 145
Rank change year-on-year +11 +9 -2
Permanent jobs citing ETL 3,276 3,766 4,099
As % of all permanent IT jobs advertised in the UK 2.61% 2.49% 2.38%
As % of the Processes & Methodologies category 2.84% 2.70% 2.58%
Number of salaries quoted 2,628 3,068 3,297
UK median annual salary £55,000 £55,000 £50,000
Median salary % change year-on-year - +10.00% -1.96%
10th Percentile £35,000 £35,000 £33,750
90th Percentile £90,000 £83,750 £78,750
UK excluding London median annual salary £47,500 £47,500 £45,000
% change year-on-year - +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 115,522 139,236 158,652
As % of all permanent IT jobs advertised in the UK 91.95% 92.18% 92.19%
Number of salaries quoted 91,482 109,804 128,264
UK median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% +4.17%
10th Percentile £30,500 £29,750 £28,500
90th Percentile £87,500 £85,000 £80,000
UK excluding London median annual salary £46,500 £45,000 £45,000
% change year-on-year +3.33% - +5.88%

ETL
Job Vacancy Trend

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

Job vacancy trend for ETL in the UK

ETL
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL.

Salary trend for ETL in the UK

ETL
Salary Histogram

The salary distribution of IT jobs citing ETL over the 6 months to 28 January 2020.

Salary histogram for ETL in the UK

ETL
Top 16 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 January 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 +15 3,079 £57,500 +4.55% 612
London +8 1,734 £65,000 +8.33% 288
UK excluding London +11 1,494 £47,500 - 370
North of England +31 392 £47,500 +5.56% 122
South East -5 362 £50,000 -9.09% 88
North West +67 248 £50,000 +11.11% 77
Midlands +21 222 £46,500 -2.11% 59
South West +14 196 £45,000 -10.00% 38
West Midlands +48 183 £47,500 -5.00% 37
East of England +14 160 £50,000 -9.09% 16
Scotland -2 108 £45,000 - 26
Yorkshire -13 108 £47,500 +5.56% 33
Wales +14 45 £41,000 +9.33% 20
East Midlands -29 39 £45,000 +1.12% 22
North East +9 36 £40,000 -15.79% 12
Northern Ireland +10 11 £45,000 +63.64% 1

For the 6 months to 28 January 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,338 (71.37%) SQL
2 1,624 (49.57%) Data Warehouse
3 1,571 (47.95%) Business Intelligence
4 1,300 (39.68%) SQL Server
5 1,015 (30.98%) SQL Server Integration Services
6 996 (30.40%) Analytics
7 994 (30.34%) Agile Software Development
8 900 (27.47%) Python
9 899 (27.44%) Azure
10 862 (26.31%) Data Modelling
11 853 (26.04%) Finance
12 775 (23.66%) Power Platform
13 774 (23.63%) Power BI
14 756 (23.08%) Microsoft
15 701 (21.40%) Big Data
16 684 (20.88%) AWS
17 671 (20.48%) SQL Server Reporting Services
18 650 (19.84%) T-SQL
19 537 (16.39%) Visualisation
20 502 (15.32%) Analytical Skills
21 475 (14.50%) SQL Server Analysis Services
22 466 (14.22%) Oracle
23 459 (14.01%) Tableau
24 456 (13.92%) Java
25 429 (13.10%) Data Science
26 388 (11.84%) Migration
27 376 (11.48%) C#
27 376 (11.48%) Apache Spark
28 375 (11.45%) Relational Database
29 374 (11.42%) Data Quality

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 376 (11.48%) Apache Spark
2 120 (3.66%) Apache
2 120 (3.66%) Apache Airflow
3 95 (2.90%) SAS
4 75 (2.29%) SharePoint
5 65 (1.98%) Elasticsearch
6 37 (1.13%) Confluence
7 36 (1.10%) Luigi
8 17 (0.52%) ArcGIS
9 12 (0.37%) Tomcat
10 11 (0.34%) Apache Pig
10 11 (0.34%) BizTalk Server
10 11 (0.34%) Tornado
11 9 (0.27%) Oracle SOA Suite
12 8 (0.24%) Jupyter
13 7 (0.21%) IIS
13 7 (0.21%) MQSeries
13 7 (0.21%) Oracle Workflow
14 5 (0.15%) Mule
15 4 (0.12%) WebSphere
Applications
1 224 (6.84%) Microsoft Excel
2 46 (1.40%) Microsoft Office
3 28 (0.85%) SPSS
4 15 (0.46%) Spreadsheet
5 14 (0.43%) MS Visio
6 9 (0.27%) Microsoft PowerPoint
7 2 (0.061%) Microsoft Project
8 1 (0.031%) SPSS Modeler
Business Applications
1 31 (0.95%) Dynamics CRM
2 17 (0.52%) Dynamics GP
3 12 (0.37%) Cognos TM1
4 11 (0.34%) Cognos Business Intelligence
4 11 (0.34%) Oracle EBS
5 10 (0.31%) NetSuite
6 7 (0.21%) SAP ERP
6 7 (0.21%) SAP MDG
6 7 (0.21%) Sparx Enterprise Architect
7 6 (0.18%) Markit EDM
7 6 (0.18%) Oracle Financials
8 5 (0.15%) RiskWrite
8 5 (0.15%) Salesforce.com CRM
9 4 (0.12%) Dynamics AX
9 4 (0.12%) Oracle Retail
9 4 (0.12%) SAP MDM
10 3 (0.092%) Actimize
10 3 (0.092%) Adobe Campaign
10 3 (0.092%) FastStats
10 3 (0.092%) SAP BPC
Cloud Services
1 899 (27.44%) Azure
2 775 (23.66%) Power Platform
3 684 (20.88%) AWS
4 332 (10.13%) GCP
5 136 (4.15%) Amazon S3
6 130 (3.97%) Azure Data Factory
7 103 (3.14%) Amazon EMR
8 63 (1.92%) Cloud Computing
9 62 (1.89%) Amazon EC2
10 61 (1.86%) Serverless
11 54 (1.65%) SaaS
12 43 (1.31%) GitHub
13 41 (1.25%) Amazon ECS
14 38 (1.16%) Amazon SQS
15 35 (1.07%) Amazon Kinesis
15 35 (1.07%) Dynamics 365
16 33 (1.01%) AWS Lambda
17 30 (0.92%) PaaS
18 29 (0.89%) Office 365
19 28 (0.85%) Google Analytics
Communications & Networking
1 16 (0.49%) Firewall
2 15 (0.46%) Internet
3 14 (0.43%) FTP
4 11 (0.34%) DNS
4 11 (0.34%) SNA
5 8 (0.24%) SAN
6 7 (0.21%) DHCP
7 6 (0.18%) VLAN
8 4 (0.12%) HTTP
9 3 (0.092%) PPP
9 3 (0.092%) TCP/IP
10 2 (0.061%) DOCSIS
10 2 (0.061%) NAS
10 2 (0.061%) VPN
11 1 (0.031%) ASN.1
11 1 (0.031%) Broadband
11 1 (0.031%) Intranet
11 1 (0.031%) iSCSI
11 1 (0.031%) Radio Access Network
11 1 (0.031%) Software-Defined Networking
Database & Business Intelligence
1 1,624 (49.57%) Data Warehouse
2 1,300 (39.68%) SQL Server
3 1,015 (30.98%) SQL Server Integration Services
4 774 (23.63%) Power BI
5 701 (21.40%) Big Data
6 671 (20.48%) SQL Server Reporting Services
7 475 (14.50%) SQL Server Analysis Services
8 375 (11.45%) Relational Database
9 348 (10.62%) Hadoop
10 298 (9.10%) Amazon Redshift
11 295 (9.00%) NoSQL
12 262 (8.00%) Data Lake
13 238 (7.26%) PostgreSQL
14 186 (5.68%) Azure SQL Database
15 182 (5.56%) Snowflake Schema
16 158 (4.82%) BigQuery
17 137 (4.18%) MySQL
18 133 (4.06%) Apache Hive
19 130 (3.97%) QlikView
20 126 (3.85%) OLAP
Development Applications
1 191 (5.83%) Git (software)
2 143 (4.37%) JIRA
3 112 (3.42%) Jenkins
4 73 (2.23%) Visual Studio
5 69 (2.11%) Team Foundation Server
6 47 (1.43%) Visual Studio Team System
7 38 (1.16%) SQL Server Management Studio (SSMS)
8 31 (0.95%) Vagrant
9 30 (0.92%) Atlassian Bamboo
10 25 (0.76%) GitLab
11 24 (0.73%) Selenium
12 23 (0.70%) Eclipse
13 22 (0.67%) RStudio
14 20 (0.61%) Subversion
15 16 (0.49%) Postman
15 16 (0.49%) SoapUI
16 15 (0.46%) IBM UrbanCode
16 15 (0.46%) Zephyr
17 13 (0.40%) ERwin
18 12 (0.37%) Eclipse RCP
General
1 853 (26.04%) Finance
2 149 (4.55%) Marketing
3 133 (4.06%) Retail
4 114 (3.48%) Banking
5 87 (2.66%) Public Sector
6 76 (2.32%) Legal
7 67 (2.05%) Manufacturing
8 58 (1.77%) Games
9 52 (1.59%) Law
10 38 (1.16%) Front Office
11 36 (1.10%) Advertising
11 36 (1.10%) Telecoms
12 35 (1.07%) Automotive
12 35 (1.07%) Financial Institution
13 30 (0.92%) Publishing
14 16 (0.49%) Billing
14 16 (0.49%) Electronics
15 10 (0.31%) Aerospace
15 10 (0.31%) Military
16 9 (0.27%) Back Office
Job Titles
1 1,192 (36.39%) Developer
2 578 (17.64%) Data Engineer
3 445 (13.58%) Business Intelligence Developer
4 394 (12.03%) Analyst
5 369 (11.26%) SQL Developer
6 324 (9.89%) Architect
7 210 (6.41%) Data Architect
8 204 (6.23%) ETL Developer
9 201 (6.14%) Senior Developer
10 161 (4.91%) Consultant
11 143 (4.37%) Data Analyst
12 141 (4.30%) DBA
13 131 (4.00%) Business Intelligence Analyst
14 116 (3.54%) Senior Data Engineer
15 107 (3.27%) Database Developer
16 103 (3.14%) Senior Business Intelligence Developer
17 99 (3.02%) SQL Server Developer
18 93 (2.84%) SQL DBA
19 89 (2.72%) Business Developer
20 86 (2.63%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 231 (7.05%) Web Services
2 211 (6.44%) .NET
3 203 (6.20%) Kafka
4 122 (3.72%) XML
5 115 (3.51%) HTML
6 99 (3.02%) REST
7 91 (2.78%) MDX
8 87 (2.66%) CSS
9 79 (2.41%) JSON
10 65 (1.98%) ASP.NET
11 55 (1.68%) SOAP
12 50 (1.53%) Node.js
13 48 (1.47%) Natural Language Processing
14 43 (1.31%) J2EE
15 42 (1.28%) Spark Streaming
16 39 (1.19%) RESTful
17 37 (1.13%) Middleware
17 37 (1.13%) Pandas
17 37 (1.13%) React
18 36 (1.10%) AngularJS
Miscellaneous
1 502 (15.32%) Analytical Skills
2 172 (5.25%) Management Information System
3 130 (3.97%) Data Structures
4 86 (2.63%) Greenfield Project
5 68 (2.08%) Algorithms
6 63 (1.92%) Self-Motivation
7 55 (1.68%) Enterprise Software
8 43 (1.31%) Public Cloud
9 40 (1.22%) Reference Data
10 39 (1.19%) Reinsurance
11 38 (1.16%) Replication
12 37 (1.13%) User Experience
13 29 (0.89%) Blog
13 29 (0.89%) Foreign Exchange (FX)
14 28 (0.85%) Data Centre
14 28 (0.85%) Equities
14 28 (0.85%) Fixed Income
15 27 (0.82%) Cloud Native
15 27 (0.82%) Virtual Team
16 22 (0.67%) Acoustics
Operating Systems
1 216 (6.59%) Linux
2 103 (3.14%) Unix
3 93 (2.84%) Windows
4 30 (0.92%) Windows Server
5 8 (0.24%) Red Hat Enterprise Linux
6 6 (0.18%) Oracle Linux
7 4 (0.12%) Android
7 4 (0.12%) Apple iOS
7 4 (0.12%) CentOS
8 3 (0.092%) Solaris
9 1 (0.031%) AIX
9 1 (0.031%) Windows Server 2003
9 1 (0.031%) Windows Server 2008
9 1 (0.031%) Windows Server 2012
Processes & Methodologies
1 1,571 (47.95%) Business Intelligence
2 996 (30.40%) Analytics
3 994 (30.34%) Agile Software Development
4 862 (26.31%) Data Modelling
5 537 (16.39%) Visualisation
6 429 (13.10%) Data Science
7 388 (11.84%) Migration
8 369 (11.26%) DevOps
9 351 (10.71%) Problem-Solving
10 350 (10.68%) Data Integration
11 345 (10.53%) Data Engineering
12 321 (9.80%) Data Architecture
13 291 (8.88%) Data Analytics
14 289 (8.82%) Data Management
15 281 (8.58%) Data Visualisation
16 278 (8.49%) Data Analysis
17 253 (7.72%) Machine Learning
18 227 (6.93%) Data Migration
19 209 (6.38%) Mentoring
20 195 (5.95%) ETL Development
Programming Languages
1 2,338 (71.37%) SQL
2 900 (27.47%) Python
3 650 (19.84%) T-SQL
4 456 (13.92%) Java
5 376 (11.48%) C#
6 220 (6.72%) Scala
7 196 (5.98%) R
8 175 (5.34%) JavaScript
9 170 (5.19%) PL/SQL
10 113 (3.45%) Data Analysis Expressions (DAX)
11 101 (3.08%) VBA
12 81 (2.47%) PowerShell
13 48 (1.47%) C
13 48 (1.47%) Go
14 42 (1.28%) Bash Shell
14 42 (1.28%) Shell Script
15 39 (1.19%) VB
16 34 (1.04%) Perl
17 32 (0.98%) C++
18 27 (0.82%) VB.NET
Qualifications
1 295 (9.00%) Degree
2 119 (3.63%) Security Cleared
3 93 (2.84%) Computer Science Degree
4 77 (2.35%) SC Cleared
5 35 (1.07%) ISTQB
6 25 (0.76%) Master's Degree
7 17 (0.52%) ISTQB Foundation Certification
7 17 (0.52%) PhD
7 17 (0.52%) PMI Certification
8 14 (0.43%) Microsoft Certification
9 11 (0.34%) HND
10 9 (0.27%) Numerate Degree
11 7 (0.21%) MCSA
12 5 (0.15%) DV Cleared
12 5 (0.15%) ISEB
13 4 (0.12%) Postgraduate
14 2 (0.061%) ITIL Foundation Certificate
15 1 (0.031%) AWS Certification
15 1 (0.031%) MCSD
15 1 (0.031%) MCSE
Quality Assurance & Compliance
1 374 (11.42%) Data Quality
2 203 (6.20%) QA
3 56 (1.71%) GDPR
4 27 (0.82%) SLA
5 22 (0.67%) ISO/IEC 27001
6 17 (0.52%) Solvency II
7 10 (0.31%) Dodd-Frank
7 10 (0.31%) EMIR
7 10 (0.31%) MiFID
8 6 (0.18%) HL7
9 4 (0.12%) Actionable Recommendations
9 4 (0.12%) COBIT
10 3 (0.092%) CDISC
11 2 (0.061%) PMO
11 2 (0.061%) Sarbanes-Oxley
12 1 (0.031%) GAAP
12 1 (0.031%) GMP
12 1 (0.031%) IFRS
12 1 (0.031%) IFRS 9
12 1 (0.031%) ISO 9001
System Software
1 157 (4.79%) Docker
2 45 (1.37%) HDFS
3 28 (0.85%) VirtualBox
4 19 (0.58%) Active Directory
5 14 (0.43%) Tivoli Workload Scheduler
6 12 (0.37%) Oracle RAC
7 10 (0.31%) Hyper-V
8 9 (0.27%) Apache ZooKeeper
9 8 (0.24%) Apache Flume
9 8 (0.24%) VMware Infrastructure
10 4 (0.12%) Virtual Machines
11 2 (0.061%) Varnish
12 1 (0.031%) Terminal Server
Systems Management
1 117 (3.57%) Kubernetes
2 73 (2.23%) Terraform
3 65 (1.98%) Ansible
4 37 (1.13%) Docker Swarm
5 23 (0.70%) Oozie
6 19 (0.58%) Puppet
7 17 (0.52%) Opscode Chef
8 15 (0.46%) Control-M
8 15 (0.46%) Foglight
8 15 (0.46%) LiteSpeed
9 14 (0.43%) Tivoli
10 10 (0.31%) SCOM
11 8 (0.24%) Hadoop YARN
12 7 (0.21%) Failover Clustering
13 5 (0.15%) BladeLogic
13 5 (0.15%) HP ALM
13 5 (0.15%) HP Quality Center
13 5 (0.15%) Istio
13 5 (0.15%) Kibana
13 5 (0.15%) linkerd
Vendors
1 756 (23.08%) Microsoft
2 466 (14.22%) Oracle
3 459 (14.01%) Tableau
4 346 (10.56%) Informatica
5 276 (8.42%) Google
6 189 (5.77%) IBM
7 177 (5.40%) Talend
8 148 (4.52%) SAP
9 95 (2.90%) Cloudera
10 93 (2.84%) Cognos
10 93 (2.84%) Salesforce.com
11 84 (2.56%) Databricks
11 84 (2.56%) Teradata
12 56 (1.71%) Hortonworks
13 53 (1.62%) Alteryx
14 45 (1.37%) RedGate
15 37 (1.13%) Ab Initio
16 34 (1.04%) Netezza
17 25 (0.76%) MicroStrategy
18 21 (0.64%) SnapLogic