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

Extract, Transform and Load (ETL)
UK
6 months to
17 Jan 2019
Same period 2018 Same period 2017
Rank 133 143 143
Rank change year-on-year +10 0 -40
Permanent jobs citing ETL 3,761 4,135 4,282
As % of all permanent IT jobs advertised in the UK 2.49% 2.39% 2.41%
As % of the Processes & Methodologies category 2.71% 2.60% 2.64%
Number of salaries quoted 3,063 3,305 3,561
UK median annual salary £55,000 £50,000 £51,000
Median salary % change year-on-year +10.00% -1.96% +2.00%
10th Percentile £35,000 £33,750 £33,500
90th Percentile £83,750 £78,650 £77,500
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 138,598 159,025 162,437
As % of all permanent IT jobs advertised in the UK 91.69% 91.81% 91.33%
Number of salaries quoted 109,286 127,729 134,362
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £30,000 £28,500 £27,651
90th Percentile £85,000 £80,000 £78,750
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 17 January 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 17 January 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 +13 3,522 £55,000 +10.00% 514
London +27 1,978 £60,000 +4.35% 265
UK excluding London -3 1,713 £47,500 +5.56% 301
South East -5 470 £53,500 +1.90% 65
North of England -26 401 £45,000 - 79
Midlands -5 247 £46,000 +2.22% 46
East of England +38 223 £55,000 +10.00% 20
North West -12 200 £45,000 - 41
South West -16 198 £50,000 +25.00% 39
Yorkshire -45 162 £45,000 +1.19% 34
West Midlands -17 154 £47,500 - 33
Scotland -15 140 £45,000 - 45
East Midlands +24 92 £44,000 +10.00% 13
North East +27 40 £42,500 +19.40% 4
Wales 0 30 £37,500 -6.25% 3
Northern Ireland -2 11 £27,500 -38.89% 4
Channel Islands - 1 £37,500 -

For the 6 months to 17 January 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,507 (66.66%) SQL
2 1,911 (50.81%) Business Intelligence
3 1,856 (49.35%) Data Warehouse
4 1,792 (47.65%) SQL Server
5 1,589 (42.25%) SQL Server Integration Services
6 1,302 (34.62%) Agile Software Development
7 1,158 (30.79%) Microsoft
8 1,110 (29.51%) SQL Server Reporting Services
9 1,063 (28.26%) Analytics
10 1,003 (26.67%) Finance
11 929 (24.70%) Data Modelling
12 906 (24.09%) T-SQL
13 817 (21.72%) Big Data
14 793 (21.08%) Microsoft Azure
15 784 (20.85%) Python
16 783 (20.82%) SQL Server Analysis Services
17 723 (19.22%) Power BI
18 704 (18.72%) Oracle
19 633 (16.83%) Tableau
20 604 (16.06%) Analytical Skills
21 579 (15.39%) Java
22 542 (14.41%) Visualisation
23 534 (14.20%) Hadoop
24 528 (14.04%) C#
25 504 (13.40%) Relational Database
26 493 (13.11%) Amazon AWS
27 438 (11.65%) Data Quality
28 436 (11.59%) Data Analysis
29 427 (11.35%) .NET
30 418 (11.11%) Problem-Solving

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 405 (10.77%) Apache Spark
2 157 (4.17%) SAS
3 145 (3.86%) Apache
4 122 (3.24%) SharePoint
5 83 (2.21%) Elasticsearch
6 46 (1.22%) Confluence
7 43 (1.14%) Apache Pig
8 31 (0.82%) Apache Airflow
9 26 (0.69%) Oracle SOA Suite
10 24 (0.64%) WebLogic
11 21 (0.56%) Apache Solr
12 20 (0.53%) CMS
13 19 (0.51%) WebSphere
14 18 (0.48%) Oracle Workflow
15 16 (0.43%) Tomcat
16 15 (0.40%) IIS
17 14 (0.37%) nginx
18 13 (0.35%) BizTalk Server
19 8 (0.21%) Alfresco
19 8 (0.21%) SharePoint 2010
Applications
1 333 (8.85%) Microsoft Excel
2 69 (1.83%) Microsoft Office
3 33 (0.88%) MS Visio
4 30 (0.80%) Microsoft PowerPoint
5 15 (0.40%) SPSS
6 12 (0.32%) Microsoft Project
6 12 (0.32%) Spreadsheet
7 2 (0.053%) Chatbot
7 2 (0.053%) InfoPath
7 2 (0.053%) Mingle
8 1 (0.027%) ArchiCAD
8 1 (0.027%) AutoCAD
8 1 (0.027%) MicroStation
8 1 (0.027%) Revit
Business Applications
1 67 (1.78%) Dynamics CRM
2 35 (0.93%) Cognos Business Intelligence
2 35 (0.93%) Cognos TM1
2 35 (0.93%) Dynamics AX
3 17 (0.45%) Oracle EBS
4 13 (0.35%) Dynamics NAV
5 10 (0.27%) FastStats
5 10 (0.27%) NetSuite
5 10 (0.27%) Oracle EBS R12
6 8 (0.21%) Markit EDM
7 7 (0.19%) SAP CO
7 7 (0.19%) SAP FI
7 7 (0.19%) SAP FI/CO
7 7 (0.19%) SAP IS-U
8 6 (0.16%) Oracle Retail
8 6 (0.16%) SAP HR
9 5 (0.13%) Maximo
9 5 (0.13%) Misys Opics
10 4 (0.11%) FastStats PeopleStage
10 4 (0.11%) Salesforce.com CRM
Cloud Services
1 793 (21.08%) Microsoft Azure
2 493 (13.11%) Amazon AWS
3 116 (3.08%) Google Cloud Platform
4 115 (3.06%) Azure Data Factory
5 55 (1.46%) GitHub
6 54 (1.44%) Amazon EMR
7 52 (1.38%) SaaS
8 47 (1.25%) Serverless
9 44 (1.17%) Amazon S3
10 40 (1.06%) Data Lake Analytics
10 40 (1.06%) PaaS
11 39 (1.04%) Cloud Computing
12 29 (0.77%) Office 365
13 28 (0.74%) Boomi
14 26 (0.69%) AWS Lambda
15 25 (0.66%) Amazon Kinesis
16 22 (0.58%) Dynamics 365
17 21 (0.56%) IaaS
18 19 (0.51%) Amazon EC2
19 18 (0.48%) Google Analytics
Communications & Networking
1 16 (0.43%) HTTP
2 14 (0.37%) HTTPS
3 13 (0.35%) Internet
4 11 (0.29%) FTP
5 8 (0.21%) SSL
6 7 (0.19%) Broadband
7 5 (0.13%) Wi-Fi
8 4 (0.11%) DNS
8 4 (0.11%) Extranet
8 4 (0.11%) Firewall
8 4 (0.11%) SAN
8 4 (0.11%) WAN
9 3 (0.080%) LAN
9 3 (0.080%) Network Security
9 3 (0.080%) SMS
9 3 (0.080%) SMTP
9 3 (0.080%) VoIP
10 2 (0.053%) CTI
10 2 (0.053%) Telnet
10 2 (0.053%) X.509
Database & Business Intelligence
1 1,856 (49.35%) Data Warehouse
2 1,792 (47.65%) SQL Server
3 1,589 (42.25%) SQL Server Integration Services
4 1,110 (29.51%) SQL Server Reporting Services
5 817 (21.72%) Big Data
6 783 (20.82%) SQL Server Analysis Services
7 723 (19.22%) Power BI
8 534 (14.20%) Hadoop
9 504 (13.40%) Relational Database
10 331 (8.80%) NoSQL
11 293 (7.79%) BusinessObjects
12 259 (6.89%) Apache Hive
13 233 (6.20%) Data Lake
14 226 (6.01%) QlikView
15 189 (5.03%) OLAP
15 189 (5.03%) SQL Server 2012
16 186 (4.95%) PostgreSQL
17 183 (4.87%) SQL Server 2016
18 171 (4.55%) Microsoft Analysis Services
18 171 (4.55%) MySQL
Development Applications
1 161 (4.28%) Git (software)
2 157 (4.17%) Visual Studio
3 150 (3.99%) JIRA
4 133 (3.54%) Team Foundation Server
5 76 (2.02%) Jenkins
6 70 (1.86%) Octopus Deploy
7 69 (1.83%) Subversion
8 68 (1.81%) SQL Server Management Studio (SSMS)
9 61 (1.62%) Visual Studio Team System
10 53 (1.41%) Eclipse
11 51 (1.36%) ERwin
12 43 (1.14%) Eclipse RCP
13 40 (1.06%) ER Studio
14 34 (0.90%) TeamCity
15 29 (0.77%) SoapUI
16 24 (0.64%) Maven
17 19 (0.51%) Selenium
17 19 (0.51%) tSQLt
18 16 (0.43%) Ant
19 15 (0.40%) Toad
General
1 1,003 (26.67%) Finance
2 256 (6.81%) Banking
3 237 (6.30%) Retail
4 171 (4.55%) Marketing
5 74 (1.97%) Advertising
6 53 (1.41%) Telecoms
7 47 (1.25%) Investment Banking
8 44 (1.17%) Manufacturing
9 43 (1.14%) Legal
10 39 (1.04%) Games
10 39 (1.04%) Law
11 29 (0.77%) Publishing
12 25 (0.66%) Automotive
13 22 (0.58%) Pharmaceutical
14 18 (0.48%) Back Office
15 12 (0.32%) Electronics
16 11 (0.29%) Financial Institution
17 8 (0.21%) Military
17 8 (0.21%) Retail Banking
18 7 (0.19%) Music Industry
Job Titles
1 1,569 (41.72%) Developer
2 637 (16.94%) Business Intelligence Developer
3 566 (15.05%) SQL Developer
4 492 (13.08%) Data Engineer
5 473 (12.58%) Analyst
6 345 (9.17%) Architect
7 286 (7.60%) Senior Developer
8 259 (6.89%) Consultant
9 251 (6.67%) ETL Developer
10 250 (6.65%) Data Architect
11 208 (5.53%) SQL BI Developer
12 199 (5.29%) SSIS Developer
13 167 (4.44%) Data Warehouse Developer
14 164 (4.36%) Data Analyst
15 148 (3.94%) SQL Server Developer
16 142 (3.78%) Database Developer
17 139 (3.70%) Business Intelligence Analyst
18 135 (3.59%) DBA
19 132 (3.51%) Business Developer
20 121 (3.22%) SSRS Developer
Libraries, Frameworks & Software Standards
1 427 (11.35%) .NET
2 286 (7.60%) XML
3 243 (6.46%) Web Services
4 226 (6.01%) Kafka
5 157 (4.17%) HTML
6 152 (4.04%) JSON
7 138 (3.67%) Middleware
8 101 (2.69%) MDX
9 94 (2.50%) CSS
10 92 (2.45%) SOAP
11 79 (2.10%) ASP.NET
12 78 (2.07%) REST
13 68 (1.81%) RESTful
14 65 (1.73%) ASP.NET Web API
15 64 (1.70%) Spark Streaming
16 54 (1.44%) WCF
17 49 (1.30%) JSP
18 48 (1.28%) Spring
19 43 (1.14%) J2EE
20 42 (1.12%) Apache NiFi
Miscellaneous
1 604 (16.06%) Analytical Skills
2 182 (4.84%) Data Structures
3 145 (3.86%) Greenfield Project
4 135 (3.59%) Management Information System
5 89 (2.37%) Fintech
6 83 (2.21%) Replication
6 83 (2.21%) Self-Motivation
7 75 (1.99%) Algorithms
8 70 (1.86%) User Experience
9 52 (1.38%) Reference Data
10 49 (1.30%) FMCG
11 46 (1.22%) Reinsurance
12 41 (1.09%) Virtual Team
13 33 (0.88%) Life Science
14 32 (0.85%) Enterprise Software
15 31 (0.82%) Robotics
16 30 (0.80%) Clustering
17 28 (0.74%) NHS
17 28 (0.74%) Tandem
18 23 (0.61%) Social Network
Operating Systems
1 284 (7.55%) Linux
2 180 (4.79%) Unix
3 173 (4.60%) Windows
4 29 (0.77%) Windows Server
5 27 (0.72%) Apple iOS
6 13 (0.35%) AIX
6 13 (0.35%) Red Hat Enterprise Linux
6 13 (0.35%) Windows Server 2012
7 9 (0.24%) HPUX
7 9 (0.24%) Solaris
7 9 (0.24%) Windows Server 2008
8 7 (0.19%) Android
9 5 (0.13%) CentOS
10 4 (0.11%) Ubuntu
10 4 (0.11%) Windows 10
11 3 (0.080%) Oracle Linux
12 2 (0.053%) DC/OS
12 2 (0.053%) Debian
12 2 (0.053%) Windows Server 2003
13 1 (0.027%) Windows XP
Processes & Methodologies
1 1,911 (50.81%) Business Intelligence
2 1,302 (34.62%) Agile Software Development
3 1,063 (28.26%) Analytics
4 929 (24.70%) Data Modelling
5 542 (14.41%) Visualisation
6 436 (11.59%) Data Analysis
7 418 (11.11%) Problem-Solving
8 414 (11.01%) Data Integration
9 402 (10.69%) Migration
10 400 (10.64%) Data Management
11 396 (10.53%) Data Science
12 350 (9.31%) Data Engineering
13 329 (8.75%) Machine Learning
14 313 (8.32%) Scrum
15 308 (8.19%) Data Migration
16 277 (7.37%) ETL Development
17 272 (7.23%) Kimball Methodology
18 267 (7.10%) Data Architecture
19 265 (7.05%) Data Analytics
19 265 (7.05%) Dimensional Modelling
Programming Languages
1 2,507 (66.66%) SQL
2 906 (24.09%) T-SQL
3 784 (20.85%) Python
4 579 (15.39%) Java
5 528 (14.04%) C#
6 227 (6.04%) JavaScript
7 211 (5.61%) PL/SQL
8 203 (5.40%) Scala
9 182 (4.84%) R
10 163 (4.33%) PowerShell
11 114 (3.03%) VBA
12 110 (2.92%) Data Analysis Expressions (DAX)
13 91 (2.42%) C++
14 67 (1.78%) PHP
14 67 (1.78%) VB
15 61 (1.62%) Shell Script
16 52 (1.38%) Bash Shell
17 45 (1.20%) VB.NET
18 39 (1.04%) C
19 30 (0.80%) Perl
Qualifications
1 383 (10.18%) Degree
2 115 (3.06%) Security Cleared
3 78 (2.07%) SC Cleared
4 59 (1.57%) Computer Science Degree
5 35 (0.93%) ISEB
6 19 (0.51%) Master's Degree
6 19 (0.51%) PMI Certification
7 18 (0.48%) AWS Certification
8 16 (0.43%) Microsoft Certification
9 14 (0.37%) ISTQB
9 14 (0.37%) PhD
10 11 (0.29%) PMP
11 10 (0.27%) ITIL Foundation Certificate
11 10 (0.27%) Numerate Degree
12 9 (0.24%) DV Cleared
12 9 (0.24%) ISTQB Foundation Certification
13 8 (0.21%) PRINCE2 Certification
14 7 (0.19%) MCP
15 4 (0.11%) ITIL Certification
16 3 (0.080%) MCSA
Quality Assurance & Compliance
1 438 (11.65%) Data Quality
2 216 (5.74%) QA
3 108 (2.87%) GDPR
4 30 (0.80%) SLA
5 19 (0.51%) IFRS
6 18 (0.48%) ISO/IEC 27001
7 16 (0.43%) Solvency II
8 12 (0.32%) MiFID
9 9 (0.24%) Dodd-Frank
9 9 (0.24%) IFRS 9
10 3 (0.080%) Cyber Essentials
11 2 (0.053%) Basel III
11 2 (0.053%) COREP
11 2 (0.053%) CRD IV
11 2 (0.053%) PMO
12 1 (0.027%) COBIT
12 1 (0.027%) EMIR
12 1 (0.027%) FATCA
12 1 (0.027%) HL7
12 1 (0.027%) ISO 20022
System Software
1 131 (3.48%) Docker
2 101 (2.69%) HDFS
3 70 (1.86%) Apache Flume
4 12 (0.32%) VMware Infrastructure
5 10 (0.27%) Apache ZooKeeper
6 6 (0.16%) Varnish
6 6 (0.16%) Virtual Machines
7 4 (0.11%) Active Directory
7 4 (0.11%) Tivoli Workload Scheduler
8 2 (0.053%) Oracle RAC
9 1 (0.027%) VirtualBox
9 1 (0.027%) VMware ESXi
Systems Management
1 97 (2.58%) Kubernetes
2 80 (2.13%) Oozie
3 37 (0.98%) Docker Swarm
4 33 (0.88%) Puppet
5 28 (0.74%) Terraform
6 27 (0.72%) Ansible
7 24 (0.64%) Control-M
7 24 (0.64%) Opscode Chef
8 22 (0.58%) Grafana
8 22 (0.58%) Hadoop YARN
9 16 (0.43%) Kibana
10 15 (0.40%) Prometheus
11 13 (0.35%) Automic
11 13 (0.35%) Mesos
12 11 (0.29%) logstash
12 11 (0.29%) Oracle RMAN
13 8 (0.21%) Rundeck
13 8 (0.21%) Single Sign-On
13 8 (0.21%) Systems Management Server (SMS)
14 7 (0.19%) Microsoft Clustering
Vendors
1 1,158 (30.79%) Microsoft
2 704 (18.72%) Oracle
3 633 (16.83%) Tableau
4 391 (10.40%) Informatica
5 350 (9.31%) SAP
6 183 (4.87%) Talend
7 178 (4.73%) Cognos
8 173 (4.60%) IBM
9 148 (3.94%) Hortonworks
10 146 (3.88%) Cloudera
11 129 (3.43%) Google
12 94 (2.50%) Teradata
13 88 (2.34%) Salesforce.com
14 79 (2.10%) Ab Initio
15 70 (1.86%) Alteryx
16 54 (1.44%) MuleSoft
16 54 (1.44%) Netezza
17 52 (1.38%) Red Hat
18 43 (1.14%) MicroStrategy
19 38 (1.01%) TIBCO