Period
to 23 September 2019

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 23 September 2019 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
UK
6 months to
23 Sep 2019
Same period 2018 Same period 2017
Rank 119 134 149
Rank change year-on-year +15 +15 -12
Permanent jobs citing ETL 3,838 4,145 4,275
As % of all permanent IT jobs advertised in the UK 2.74% 2.51% 2.43%
As % of the Processes & Methodologies category 2.98% 2.73% 2.64%
Number of salaries quoted 3,118 3,372 3,352
UK median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% -0.99%
10th Percentile £35,000 £35,000 £32,500
90th Percentile £85,000 £82,500 £76,250
UK excluding London median annual salary £47,500 £45,000 £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 128,950 151,697 162,176
As % of all permanent IT jobs advertised in the UK 92.10% 91.76% 92.31%
Number of salaries quoted 101,239 120,729 128,104
UK median annual salary £52,500 £50,000 £50,000
Median salary % change year-on-year +5.00% - +4.17%
10th Percentile £30,000 £29,000 £28,000
90th Percentile £86,250 £82,500 £80,000
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +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 23 September 2019.

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 23 September 2019. 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 +9 3,525 £53,500 +1.90% 496
UK excluding London +29 1,902 £47,500 +5.56% 313
London +12 1,861 £61,250 +2.08% 240
North of England +10 473 £45,000 - 81
South East +2 455 £50,000 - 74
North West +20 265 £47,500 +5.56% 48
Midlands +20 256 £45,000 - 48
South West +45 252 £50,000 +11.11% 31
East of England +54 221 £50,000 +5.26% 22
Scotland +42 200 £47,500 +5.56% 48
West Midlands +37 187 £45,000 - 32
Yorkshire -16 170 £45,000 - 27
East Midlands -3 67 £45,000 +5.88% 16
North East +31 38 £36,404 -6.05% 6
Wales +1 35 £43,500 +16.00% 8
Northern Ireland +1 9 £45,000 +2.86% 1
Channel Islands - 3 £47,500 -

For the 6 months to 23 September 2019, 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,759 (71.89%) SQL
2 1,939 (50.52%) Business Intelligence
3 1,929 (50.26%) Data Warehouse
4 1,695 (44.16%) SQL Server
5 1,388 (36.16%) SQL Server Integration Services
6 1,224 (31.89%) Agile Software Development
7 1,117 (29.10%) Analytics
8 999 (26.03%) Azure
9 988 (25.74%) SQL Server Reporting Services
10 980 (25.53%) Python
11 969 (25.25%) Finance
12 968 (25.22%) Microsoft
13 958 (24.96%) Data Modelling
14 949 (24.73%) Power Platform
15 946 (24.65%) Power BI
16 894 (23.29%) T-SQL
17 755 (19.67%) Big Data
18 742 (19.33%) SQL Server Analysis Services
19 649 (16.91%) AWS
20 645 (16.81%) Analytical Skills
21 602 (15.69%) Oracle
22 596 (15.53%) Visualisation
23 556 (14.49%) Tableau
24 514 (13.39%) Relational Database
25 470 (12.25%) Java
26 458 (11.93%) Hadoop
27 443 (11.54%) C#
28 442 (11.52%) Apache Spark
29 441 (11.49%) Problem-Solving
30 436 (11.36%) Data Science

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 442 (11.52%) Apache Spark
2 143 (3.73%) SharePoint
3 108 (2.81%) SAS
4 99 (2.58%) Apache
5 63 (1.64%) Elasticsearch
6 56 (1.46%) Apache Airflow
7 42 (1.09%) Confluence
8 40 (1.04%) Apache Pig
9 27 (0.70%) Luigi
10 24 (0.63%) Oracle SOA Suite
11 13 (0.34%) BizTalk Server
12 12 (0.31%) WebSphere
13 9 (0.23%) ArcGIS
14 8 (0.21%) Tomcat
15 6 (0.16%) ArcSDE
15 6 (0.16%) GeoServer
15 6 (0.16%) IIS
15 6 (0.16%) Oracle Spatial
15 6 (0.16%) Tornado
16 4 (0.10%) SugarCRM
Applications
1 315 (8.21%) Microsoft Excel
2 75 (1.95%) Microsoft Office
3 38 (0.99%) Spreadsheet
4 27 (0.70%) MS Visio
5 14 (0.36%) Microsoft PowerPoint
6 13 (0.34%) SPSS
7 4 (0.10%) InfoPath
8 2 (0.052%) Microsoft Project
9 1 (0.026%) ArchiCAD
9 1 (0.026%) AutoCAD
9 1 (0.026%) Chatbot
9 1 (0.026%) MicroStation
9 1 (0.026%) Revit
9 1 (0.026%) SPSS Modeler
Business Applications
1 59 (1.54%) Dynamics CRM
2 13 (0.34%) Adobe Campaign
3 12 (0.31%) Cognos Business Intelligence
4 11 (0.29%) Cognos TM1
4 11 (0.29%) FastStats
4 11 (0.29%) NetSuite
5 10 (0.26%) Oracle EBS
6 7 (0.18%) Dynamics AX
7 5 (0.13%) FastStats PeopleStage
7 5 (0.13%) Markit EDM
7 5 (0.13%) SAP ERP
8 4 (0.10%) Dynamics NAV
8 4 (0.10%) Hyperion Planning
8 4 (0.10%) Oracle Retail
8 4 (0.10%) SAP S/4HANA
8 4 (0.10%) Unit4 Business World
9 3 (0.078%) Actimize
9 3 (0.078%) HFM
9 3 (0.078%) Infor CRM
9 3 (0.078%) Maximo
Cloud Services
1 999 (26.03%) Azure
2 949 (24.73%) Power Platform
3 649 (16.91%) AWS
4 300 (7.82%) GCP
5 156 (4.06%) Azure Data Factory
6 88 (2.29%) Amazon S3
7 79 (2.06%) Amazon EMR
8 78 (2.03%) SaaS
9 61 (1.59%) Cloud Computing
10 55 (1.43%) Serverless
11 45 (1.17%) Dynamics 365
12 43 (1.12%) Office 365
13 29 (0.76%) Google Analytics
14 28 (0.73%) Amazon EC2
15 27 (0.70%) PaaS
16 25 (0.65%) Amazon ECS
17 22 (0.57%) Azure Functions
17 22 (0.57%) GitHub
18 20 (0.52%) Amazon SQS
19 18 (0.47%) AWS CloudFormation
Communications & Networking
1 19 (0.50%) Internet
2 18 (0.47%) FTP
3 15 (0.39%) Broadband
4 11 (0.29%) Firewall
5 10 (0.26%) DNS
6 6 (0.16%) Wireless
7 4 (0.10%) HTTP
7 4 (0.10%) Intranet
8 3 (0.078%) MVNO
8 3 (0.078%) VPN
8 3 (0.078%) WAN
9 2 (0.052%) HTTPS
9 2 (0.052%) Kerberos
9 2 (0.052%) PPP
9 2 (0.052%) SMS
9 2 (0.052%) SSH
9 2 (0.052%) SSL
10 1 (0.026%) 5G
10 1 (0.026%) iSCSI
10 1 (0.026%) SAN
Database & Business Intelligence
1 1,929 (50.26%) Data Warehouse
2 1,695 (44.16%) SQL Server
3 1,388 (36.16%) SQL Server Integration Services
4 988 (25.74%) SQL Server Reporting Services
5 946 (24.65%) Power BI
6 755 (19.67%) Big Data
7 742 (19.33%) SQL Server Analysis Services
8 514 (13.39%) Relational Database
9 458 (11.93%) Hadoop
10 301 (7.84%) NoSQL
11 298 (7.76%) Data Lake
12 241 (6.28%) PostgreSQL
13 213 (5.55%) QlikView
14 209 (5.45%) Apache Hive
15 207 (5.39%) Amazon Redshift
16 205 (5.34%) Azure SQL Database
16 205 (5.34%) BusinessObjects
17 192 (5.00%) RDBMS
18 184 (4.79%) SQL Server 2012
19 175 (4.56%) MongoDB
Development Applications
1 219 (5.71%) JIRA
2 214 (5.58%) Git (software)
3 157 (4.09%) Jenkins
4 109 (2.84%) Visual Studio
5 95 (2.48%) Team Foundation Server
6 85 (2.21%) Selenium
7 37 (0.96%) SQL Server Management Studio (SSMS)
8 36 (0.94%) Octopus Deploy
8 36 (0.94%) Subversion
9 34 (0.89%) Cucumber
10 33 (0.86%) Maven
11 31 (0.81%) IBM UrbanCode
11 31 (0.81%) Zephyr
12 26 (0.68%) TeamCity
13 22 (0.57%) HP UFT
14 20 (0.52%) Atlassian Bamboo
14 20 (0.52%) SoapUI
15 19 (0.50%) Bitbucket
15 19 (0.50%) GitLab
15 19 (0.50%) RStudio
General
1 969 (25.25%) Finance
2 192 (5.00%) Retail
3 173 (4.51%) Marketing
4 160 (4.17%) Banking
5 91 (2.37%) Public Sector
6 70 (1.82%) Legal
7 52 (1.35%) Manufacturing
8 47 (1.22%) Law
9 41 (1.07%) Games
9 41 (1.07%) Telecoms
10 36 (0.94%) Front Office
11 25 (0.65%) Advertising
11 25 (0.65%) Billing
12 21 (0.55%) Automotive
13 19 (0.50%) Electronics
14 17 (0.44%) Back Office
14 17 (0.44%) Publishing
15 16 (0.42%) Financial Institution
15 16 (0.42%) Investment Banking
16 12 (0.31%) Aerospace
Job Titles
1 1,530 (39.86%) Developer
2 718 (18.71%) Business Intelligence Developer
3 578 (15.06%) Data Engineer
4 556 (14.49%) Analyst
5 514 (13.39%) SQL Developer
6 276 (7.19%) Architect
7 216 (5.63%) Data Analyst
8 211 (5.50%) ETL Developer
9 204 (5.32%) SQL BI Developer
10 202 (5.26%) Senior Developer
11 194 (5.05%) Business Intelligence Analyst
11 194 (5.05%) Consultant
12 173 (4.51%) SSIS Developer
13 167 (4.35%) Data Architect
14 149 (3.88%) DBA
15 139 (3.62%) Database Developer
16 126 (3.28%) Senior Data Engineer
17 123 (3.20%) SQL Server Developer
18 119 (3.10%) Business Developer
19 108 (2.81%) SQL DBA
Libraries, Frameworks & Software Standards
1 281 (7.32%) .NET
2 221 (5.76%) Kafka
2 221 (5.76%) Web Services
3 152 (3.96%) MDX
4 125 (3.26%) XML
5 123 (3.20%) HTML
6 100 (2.61%) ASP.NET
7 93 (2.42%) JSON
7 93 (2.42%) REST
8 70 (1.82%) CSS
9 68 (1.77%) SOAP
10 59 (1.54%) WCF
11 55 (1.43%) Apache NiFi
12 53 (1.38%) RESTful
13 45 (1.17%) .NET Framework
13 45 (1.17%) Pandas
14 43 (1.12%) Node.js
15 41 (1.07%) Apache Beam
16 40 (1.04%) Middleware
17 38 (0.99%) Spark Streaming
Miscellaneous
1 645 (16.81%) Analytical Skills
2 217 (5.65%) Management Information System
3 128 (3.34%) Data Structures
4 92 (2.40%) Greenfield Project
4 92 (2.40%) Self-Motivation
5 75 (1.95%) Algorithms
6 69 (1.80%) Replication
7 47 (1.22%) Enterprise Software
8 46 (1.20%) Clustering
9 45 (1.17%) Virtual Team
10 36 (0.94%) User Experience
11 30 (0.78%) Reference Data
12 29 (0.76%) Life Science
12 29 (0.76%) Reinsurance
13 27 (0.70%) Data Centre
14 26 (0.68%) Hedge funds
15 25 (0.65%) NHS
16 24 (0.63%) Foreign Exchange (FX)
17 20 (0.52%) Taxonomies
18 19 (0.50%) Fixed Income
Operating Systems
1 236 (6.15%) Linux
2 145 (3.78%) Windows
3 137 (3.57%) Unix
4 47 (1.22%) Windows Server
5 11 (0.29%) Apple iOS
6 9 (0.23%) Red Hat Enterprise Linux
7 5 (0.13%) Android
7 5 (0.13%) Windows Server 2012
8 4 (0.10%) AIX
8 4 (0.10%) Windows Server 2003
9 3 (0.078%) Debian
9 3 (0.078%) Windows 10
10 2 (0.052%) CentOS
10 2 (0.052%) Windows Server 2008
11 1 (0.026%) Solaris
11 1 (0.026%) Windows 7
Processes & Methodologies
1 1,939 (50.52%) Business Intelligence
2 1,224 (31.89%) Agile Software Development
3 1,117 (29.10%) Analytics
4 958 (24.96%) Data Modelling
5 596 (15.53%) Visualisation
6 441 (11.49%) Problem-Solving
7 436 (11.36%) Data Science
8 382 (9.95%) DevOps
9 370 (9.64%) Data Management
10 368 (9.59%) Migration
11 352 (9.17%) Data Engineering
12 343 (8.94%) Data Integration
13 320 (8.34%) Data Visualisation
14 309 (8.05%) Data Architecture
15 296 (7.71%) Data Analytics
16 295 (7.69%) Scrum
17 276 (7.19%) Machine Learning
18 273 (7.11%) Data Analysis
19 249 (6.49%) Data Migration
19 249 (6.49%) Mentoring
Programming Languages
1 2,759 (71.89%) SQL
2 980 (25.53%) Python
3 894 (23.29%) T-SQL
4 470 (12.25%) Java
5 443 (11.54%) C#
6 261 (6.80%) Scala
7 227 (5.91%) PL/SQL
8 223 (5.81%) R
9 184 (4.79%) JavaScript
10 175 (4.56%) Data Analysis Expressions (DAX)
11 163 (4.25%) PowerShell
12 159 (4.14%) VBA
13 70 (1.82%) Bash Shell
14 61 (1.59%) VB
15 50 (1.30%) Shell Script
16 44 (1.15%) Go
17 43 (1.12%) Perl
18 38 (0.99%) C
19 37 (0.96%) VB.NET
20 31 (0.81%) C++
Qualifications
1 344 (8.96%) Degree
2 132 (3.44%) Security Cleared
3 97 (2.53%) Computer Science Degree
4 76 (1.98%) SC Cleared
5 53 (1.38%) ISTQB
6 29 (0.76%) ISTQB Foundation Certification
7 28 (0.73%) Master's Degree
8 21 (0.55%) Microsoft Certification
8 21 (0.55%) PhD
9 20 (0.52%) PMI Certification
10 9 (0.23%) ISEB
11 8 (0.21%) AWS Certification
11 8 (0.21%) Numerate Degree
12 7 (0.18%) MCSA
13 5 (0.13%) CGEIT
13 5 (0.13%) DV Cleared
13 5 (0.13%) HND
14 3 (0.078%) DBS Check
14 3 (0.078%) Oracle Certification
15 2 (0.052%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 401 (10.45%) Data Quality
2 218 (5.68%) QA
3 78 (2.03%) GDPR
4 47 (1.22%) SLA
5 31 (0.81%) ISO/IEC 27001
6 5 (0.13%) Actionable Recommendations
6 5 (0.13%) PMO
7 3 (0.078%) HL7
7 3 (0.078%) ISO 20022
8 2 (0.052%) Basel III
8 2 (0.052%) COREP
8 2 (0.052%) CRD IV
8 2 (0.052%) ISO 15022
8 2 (0.052%) Sarbanes-Oxley
8 2 (0.052%) SEPA
9 1 (0.026%) BS7666
9 1 (0.026%) GMP
9 1 (0.026%) GxP
9 1 (0.026%) ISO 9001
9 1 (0.026%) ISO/IEC 20000
System Software
1 151 (3.93%) Docker
2 77 (2.01%) HDFS
3 32 (0.83%) Tivoli Workload Scheduler
4 26 (0.68%) Apache ZooKeeper
5 17 (0.44%) Apache Flume
6 14 (0.36%) VMware Infrastructure
7 8 (0.21%) VirtualBox
8 6 (0.16%) Active Directory
8 6 (0.16%) Virtual Machines
9 5 (0.13%) etcd
10 4 (0.10%) Hyper-V
11 3 (0.078%) Oracle RAC
12 2 (0.052%) pfSense
Systems Management
1 106 (2.76%) Kubernetes
2 81 (2.11%) Terraform
3 57 (1.49%) Ansible
4 43 (1.12%) Puppet
5 42 (1.09%) Opscode Chef
6 38 (0.99%) Oozie
7 32 (0.83%) Tivoli
8 30 (0.78%) Docker Swarm
9 20 (0.52%) Hadoop YARN
10 16 (0.42%) Control-M
11 15 (0.39%) Foglight
11 15 (0.39%) LiteSpeed
12 13 (0.34%) Grafana
12 13 (0.34%) Prometheus
13 11 (0.29%) BMC PATROL
13 11 (0.29%) HP ALM
13 11 (0.29%) Istio
13 11 (0.29%) linkerd
14 10 (0.26%) Salt
14 10 (0.26%) SCOM
Vendors
1 968 (25.22%) Microsoft
2 602 (15.69%) Oracle
3 556 (14.49%) Tableau
4 375 (9.77%) Informatica
5 256 (6.67%) Google
6 220 (5.73%) IBM
7 204 (5.32%) SAP
8 182 (4.74%) Talend
9 110 (2.87%) Cognos
10 109 (2.84%) Teradata
11 105 (2.74%) Cloudera
12 104 (2.71%) Databricks
13 79 (2.06%) Salesforce.com
14 75 (1.95%) Ab Initio
15 69 (1.80%) Alteryx
16 54 (1.41%) Hortonworks
17 51 (1.33%) Netezza
18 33 (0.86%) MuleSoft
19 30 (0.78%) HP
20 29 (0.76%) RedGate