Period
to 26 September 2018

The following table provides summary statistics for permanent job vacancies advertised in Leeds 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 26 September 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
6 months to
26 Sep 2018
Same period 2017 Same period 2016
Rank 123 80 95
Rank change year-on-year -43 +15 +37
Permanent jobs citing ETL 80 154 158
As % of all permanent IT jobs advertised in Leeds 1.94% 3.11% 2.88%
As % of the Processes & Methodologies category 2.13% 3.32% 3.09%
Number of salaries quoted 75 144 123
Leeds median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - -19.05%
10th Percentile £33,875 £32,500 £33,750
90th Percentile £64,900 £62,125 £52,500
West Yorkshire median annual salary £45,000 £45,000 £43,000
% change year-on-year - +4.65% -4.44%

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 advertised in Leeds with a requirement for process or methodology skills.

All Process and Methodology Skills
Leeds
Permanent vacancies with a requirement for process or methodology skills 3,761 4,644 5,113
As % of all permanent IT jobs advertised in Leeds 91.42% 93.91% 93.23%
Number of salaries quoted 3,151 3,913 4,247
Leeds median annual salary £45,000 £45,000 £42,000
Median salary % change year-on-year - +7.14% -1.18%
10th Percentile £27,500 £27,300 £26,250
90th Percentile £65,000 £63,750 £62,500
West Yorkshire median annual salary £45,000 £42,500 £42,000
% change year-on-year +5.88% +1.19% +5.00%

ETL
Job Vacancy Trend in Leeds

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

Job vacancy trend for ETL in Leeds

ETL
Salary Trend in Leeds

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

Salary trend for ETL in Leeds

ETL
Salary Histogram in Leeds

The salary distribution of IT jobs citing ETL in Leeds over the 6 months to 26 September 2018.

Salary histogram for ETL in Leeds

For the 6 months to 26 September 2018, 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 across the Leeds region with a requirement for ETL.

1 60 (75.00%) SQL
2 46 (57.50%) Business Intelligence
3 38 (47.50%) SQL Server Integration Services
4 31 (38.75%) SQL Server Reporting Services
5 29 (36.25%) Data Warehouse
6 26 (32.50%) Microsoft Excel
7 25 (31.25%) SQL Server
8 22 (27.50%) SQL Server Analysis Services
9 20 (25.00%) Agile Software Development
10 19 (23.75%) Python
11 18 (22.50%) Analytics
11 18 (22.50%) Power BI
12 17 (21.25%) Tableau
12 17 (21.25%) Microsoft
12 17 (21.25%) T-SQL
13 16 (20.00%) Relational Database
14 15 (18.75%) Stakeholder Management
15 14 (17.50%) Cognos
16 13 (16.25%) C#
16 13 (16.25%) Migration
16 13 (16.25%) Hadoop
17 12 (15.00%) Microsoft Azure
17 12 (15.00%) Apache Hive
17 12 (15.00%) R
17 12 (15.00%) Data Analysis
17 12 (15.00%) .NET
17 12 (15.00%) SAP
17 12 (15.00%) Data Science
18 11 (13.75%) OLAP
18 11 (13.75%) Finance

ETL
Co-occurring IT Skills in Leeds 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 7 (8.75%) Apache Spark
2 5 (6.25%) SAS
3 2 (2.50%) Apache Pig
3 2 (2.50%) BizTalk Server
3 2 (2.50%) CMS
3 2 (2.50%) Oracle SOA Suite
4 1 (1.25%) Apache
4 1 (1.25%) Tomcat
4 1 (1.25%) WildFly
Applications
1 26 (32.50%) Microsoft Excel
2 9 (11.25%) Microsoft Office
Business Applications
1 10 (12.50%) Cognos TM1
Cloud Services
1 12 (15.00%) Microsoft Azure
2 9 (11.25%) Amazon AWS
3 2 (2.50%) Amazon EMR
3 2 (2.50%) Amazon Kinesis
3 2 (2.50%) Amazon S3
3 2 (2.50%) Google Cloud Platform
3 2 (2.50%) Loggly
3 2 (2.50%) Sumo Logic
4 1 (1.25%) Amazon EC2
4 1 (1.25%) Amazon SageMaker
4 1 (1.25%) AWS Lambda
4 1 (1.25%) Google Analytics
4 1 (1.25%) IaaS
4 1 (1.25%) PaaS
4 1 (1.25%) Serverless
Communications & Networking
1 1 (1.25%) Kerberos
Database & Business Intelligence
1 38 (47.50%) SQL Server Integration Services
2 31 (38.75%) SQL Server Reporting Services
3 29 (36.25%) Data Warehouse
4 25 (31.25%) SQL Server
5 22 (27.50%) SQL Server Analysis Services
6 18 (22.50%) Power BI
7 16 (20.00%) Relational Database
8 13 (16.25%) Hadoop
9 12 (15.00%) Apache Hive
10 11 (13.75%) OLAP
11 9 (11.25%) Big Data
11 9 (11.25%) HBase
12 7 (8.75%) MongoDB
12 7 (8.75%) NoSQL
13 6 (7.50%) Data Lake
13 6 (7.50%) Pentaho
13 6 (7.50%) QlikView
13 6 (7.50%) ROLAP
13 6 (7.50%) SQL Server 2016
14 5 (6.25%) Sqoop
Development Applications
1 2 (2.50%) CA Release Automation
2 1 (1.25%) Git (software)
2 1 (1.25%) Jenkins
2 1 (1.25%) SQL Server Management Studio (SSMS)
2 1 (1.25%) Visual Studio
General
1 11 (13.75%) Finance
2 5 (6.25%) Marketing
3 2 (2.50%) Law
4 1 (1.25%) Automotive
4 1 (1.25%) Banking
4 1 (1.25%) Games
4 1 (1.25%) Retail
Job Titles
1 31 (38.75%) Developer
2 16 (20.00%) Data Engineer
3 15 (18.75%) Business Intelligence Developer
4 10 (12.50%) Business Manager
5 9 (11.25%) Business Intelligence Manager
6 7 (8.75%) Senior Data Engineer
7 6 (7.50%) SSIS Developer
8 5 (6.25%) Architect
8 5 (6.25%) Data Architect
8 5 (6.25%) Senior Developer
8 5 (6.25%) Senior Manager
8 5 (6.25%) Software Developer
8 5 (6.25%) SQL Developer
9 4 (5.00%) Data Manager
9 4 (5.00%) Lead Architect
9 4 (5.00%) Lead Data Architect
9 4 (5.00%) SSRS Developer
10 3 (3.75%) Senior Business Intelligence Developer
10 3 (3.75%) SQL Analyst
10 3 (3.75%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 12 (15.00%) .NET
2 7 (8.75%) REST
2 7 (8.75%) Web Services
2 7 (8.75%) XML
2 7 (8.75%) XSD
3 5 (6.25%) CSS
3 5 (6.25%) HTML
3 5 (6.25%) Kafka
4 4 (5.00%) ASP.NET
4 4 (5.00%) JSON
4 4 (5.00%) SOAP
5 3 (3.75%) Spring
5 3 (3.75%) WCF
5 3 (3.75%) WinForms
5 3 (3.75%) XHTML
5 3 (3.75%) XSLT
6 2 (2.50%) HTML5
6 2 (2.50%) Node.js
6 2 (2.50%) RabbitMQ
6 2 (2.50%) Spring Boot
Miscellaneous
1 10 (12.50%) Analytical Skills
2 4 (5.00%) Replication
2 4 (5.00%) Taxonomies
3 3 (3.75%) Management Information System
4 2 (2.50%) Computer Science
4 2 (2.50%) User Experience
5 1 (1.25%) Algorithms
5 1 (1.25%) Cloud Native
5 1 (1.25%) Enterprise Cloud
5 1 (1.25%) Greenfield Project
5 1 (1.25%) Mainframe
Operating Systems
1 3 (3.75%) Linux
2 1 (1.25%) CentOS
2 1 (1.25%) Ubuntu
2 1 (1.25%) Unix
Processes & Methodologies
1 46 (57.50%) Business Intelligence
2 20 (25.00%) Agile Software Development
3 18 (22.50%) Analytics
4 15 (18.75%) Stakeholder Management
5 13 (16.25%) Migration
6 12 (15.00%) Data Analysis
6 12 (15.00%) Data Science
7 11 (13.75%) Data Analytics
8 9 (11.25%) MapReduce
9 8 (10.00%) Collaborative Working
9 8 (10.00%) Data Management
9 8 (10.00%) Data Migration
9 8 (10.00%) Market Research
10 7 (8.75%) Data Modelling
10 7 (8.75%) Statistical Analysis
10 7 (8.75%) Visualisation
11 6 (7.50%) CRM
11 6 (7.50%) Data Integration
11 6 (7.50%) Problem-Solving
11 6 (7.50%) TOGAF
Programming Languages
1 60 (75.00%) SQL
2 19 (23.75%) Python
3 17 (21.25%) T-SQL
4 13 (16.25%) C#
5 12 (15.00%) R
6 10 (12.50%) Scala
6 10 (12.50%) Tcl
7 9 (11.25%) VBA
8 6 (7.50%) Ruby
8 6 (7.50%) VB
9 5 (6.25%) PL/SQL
9 5 (6.25%) VB.NET
10 4 (5.00%) Java
11 3 (3.75%) JavaScript
11 3 (3.75%) PHP
12 2 (2.50%) Bash Shell
12 2 (2.50%) C++
12 2 (2.50%) Go
12 2 (2.50%) Java 8
13 1 (1.25%) MATLAB
Qualifications
1 5 (6.25%) Degree
2 2 (2.50%) MBA
3 1 (1.25%) AWS Certification
3 1 (1.25%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 6 (7.50%) Data Quality
2 4 (5.00%) GDPR
3 2 (2.50%) PCI DSS
System Software
1 6 (7.50%) HDFS
2 4 (5.00%) Apache Flume
3 2 (2.50%) Docker
Systems Management
1 6 (7.50%) Oozie
2 3 (3.75%) Puppet
2 3 (3.75%) ZABBIX
3 2 (2.50%) Cobbler
3 2 (2.50%) Nagios
3 2 (2.50%) Opscode Chef
3 2 (2.50%) Prometheus
3 2 (2.50%) Rancher
3 2 (2.50%) Terraform
3 2 (2.50%) Tivoli
4 1 (1.25%) Ansible
4 1 (1.25%) Data Guard
4 1 (1.25%) Enterprise Manager Cloud Control
4 1 (1.25%) Oracle RMAN
4 1 (1.25%) Xymon
Vendors
1 17 (21.25%) Microsoft
1 17 (21.25%) Tableau
2 14 (17.50%) Cognos
3 12 (15.00%) SAP
4 10 (12.50%) IBM
5 9 (11.25%) Oracle
6 5 (6.25%) Informatica
6 5 (6.25%) Talend
7 3 (3.75%) Alteryx
7 3 (3.75%) Google
7 3 (3.75%) MuleSoft
7 3 (3.75%) webMethods
8 2 (2.50%) Avaya
8 2 (2.50%) New Relic
8 2 (2.50%) Rackspace
8 2 (2.50%) Splunk
8 2 (2.50%) Sybase
9 1 (1.25%) Red Hat