Period
to 24 June 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 24 June 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
6 months to
24 Jun 2018
Same period 2017 Same period 2016
Rank 109 96 78
Rank change year-on-year -13 -18 +54
Permanent jobs citing ETL 112 144 227
As % of all permanent IT jobs advertised in Leeds 2.36% 2.82% 3.66%
As % of the Processes & Methodologies category 2.52% 3.02% 4.00%
Number of salaries quoted 99 129 179
Leeds median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% +3.90%
10th Percentile £36,250 £32,500 £31,250
90th Percentile £70,250 £62,500 £60,500
West Yorkshire median annual salary £45,000 £45,000 £40,250
% change year-on-year - +11.80% +0.63%

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 4,447 4,766 5,679
As % of all permanent IT jobs advertised in Leeds 93.54% 93.34% 91.54%
Number of salaries quoted 3,736 4,078 4,640
Leeds median annual salary £45,000 £45,000 £42,000
Median salary % change year-on-year - +7.14% +5.00%
10th Percentile £28,625 £26,250 £27,000
90th Percentile £65,000 £62,875 £63,750
West Yorkshire median annual salary £45,000 £42,500 £41,000
% change year-on-year +5.88% +3.66% +2.50%

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 24 June 2018.

Salary histogram for ETL in Leeds

For the 6 months to 24 June 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 76 (67.86%) SQL
2 59 (52.68%) Business Intelligence
3 53 (47.32%) SQL Server Integration Services
4 47 (41.96%) Agile Software Development
5 44 (39.29%) SQL Server
6 42 (37.50%) Data Warehouse
7 36 (32.14%) Microsoft
8 34 (30.36%) SQL Server Reporting Services
9 29 (25.89%) Analytics
10 24 (21.43%) SQL Server Analysis Services
11 20 (17.86%) T-SQL
12 18 (16.07%) Hadoop
13 17 (15.18%) Relational Database
13 17 (15.18%) Apache Hive
13 17 (15.18%) Data Modelling
14 16 (14.29%) Python
14 16 (14.29%) SQL Server 2016
15 15 (13.39%) SAP
15 15 (13.39%) MapReduce
15 15 (13.39%) HBase
15 15 (13.39%) Data Analysis
16 14 (12.50%) Microsoft Azure
16 14 (12.50%) SQL Server 2008
16 14 (12.50%) Tableau
16 14 (12.50%) R
16 14 (12.50%) Data Analytics
16 14 (12.50%) Data Science
17 13 (11.61%) Power BI
17 13 (11.61%) NoSQL
17 13 (11.61%) Big Data

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 10 (8.93%) Apache Spark
2 2 (1.79%) BizTalk Server
2 2 (1.79%) Oracle SOA Suite
2 2 (1.79%) SAS
3 1 (0.89%) Apache
3 1 (0.89%) Apache Pig
3 1 (0.89%) Tomcat
3 1 (0.89%) WildFly
Applications
1 10 (8.93%) Microsoft Excel
2 7 (6.25%) Microsoft Office
3 1 (0.89%) MS Visio
Cloud Services
1 14 (12.50%) Microsoft Azure
2 6 (5.36%) IaaS
2 6 (5.36%) PaaS
3 3 (2.68%) Amazon AWS
4 2 (1.79%) Google Cloud Platform
4 2 (1.79%) Loggly
4 2 (1.79%) Sumo Logic
5 1 (0.89%) Amazon EMR
5 1 (0.89%) Amazon S3
5 1 (0.89%) Azure Data Factory
5 1 (0.89%) Serverless
Communications & Networking
1 1 (0.89%) DSL
1 1 (0.89%) Kerberos
Database & Business Intelligence
1 53 (47.32%) SQL Server Integration Services
2 44 (39.29%) SQL Server
3 42 (37.50%) Data Warehouse
4 34 (30.36%) SQL Server Reporting Services
5 24 (21.43%) SQL Server Analysis Services
6 18 (16.07%) Hadoop
7 17 (15.18%) Apache Hive
7 17 (15.18%) Relational Database
8 16 (14.29%) SQL Server 2016
9 15 (13.39%) HBase
10 14 (12.50%) SQL Server 2008
11 13 (11.61%) Big Data
11 13 (11.61%) NoSQL
11 13 (11.61%) Power BI
12 10 (8.93%) SAP HANA
12 10 (8.93%) SQL Server 2014
13 9 (8.04%) Pentaho
14 8 (7.14%) BusinessObjects
14 8 (7.14%) ROLAP
14 8 (7.14%) SQL Server 2005
Development Applications
1 2 (1.79%) CA Release Automation
1 2 (1.79%) Octopus Deploy
2 1 (0.89%) Git (software)
2 1 (0.89%) Jenkins
General
1 9 (8.04%) Finance
2 8 (7.14%) Marketing
3 6 (5.36%) Law
4 1 (0.89%) Advertising
4 1 (0.89%) Games
4 1 (0.89%) Legal
4 1 (0.89%) Retail
Job Titles
1 45 (40.18%) Developer
2 27 (24.11%) Business Intelligence Developer
3 21 (18.75%) Data Engineer
4 16 (14.29%) Business Developer
5 15 (13.39%) ETL Developer
6 13 (11.61%) SSIS Developer
7 12 (10.71%) Architect
7 12 (10.71%) DBA
8 9 (8.04%) SSRS Developer
9 8 (7.14%) Data Architect
9 8 (7.14%) Senior Data Engineer
10 7 (6.25%) Senior Manager
10 7 (6.25%) Software Developer
10 7 (6.25%) SSAS Developer
11 6 (5.36%) Administrator
11 6 (5.36%) Data Manager
11 6 (5.36%) Data Warehouse Developer
11 6 (5.36%) SAP Administrator
11 6 (5.36%) SAP HANA Administrator
11 6 (5.36%) Sybase DBA
Libraries, Frameworks & Software Standards
1 10 (8.93%) .NET
2 9 (8.04%) XML
2 9 (8.04%) XSD
3 8 (7.14%) REST
4 7 (6.25%) Kafka
5 6 (5.36%) JSON
5 6 (5.36%) SOAP
6 5 (4.46%) CSS
6 5 (4.46%) HTML
6 5 (4.46%) Web Services
7 3 (2.68%) WCF
7 3 (2.68%) WinForms
7 3 (2.68%) XHTML
7 3 (2.68%) XSLT
8 2 (1.79%) ASP.NET
8 2 (1.79%) Elastic Stack
8 2 (1.79%) HTML5
8 2 (1.79%) Node.js
8 2 (1.79%) RabbitMQ
8 2 (1.79%) Spring
Miscellaneous
1 12 (10.71%) Analytical Skills
2 9 (8.04%) Management Information System
3 6 (5.36%) Replication
3 6 (5.36%) Taxonomies
4 5 (4.46%) Clustering
5 4 (3.57%) Self-Motivation
6 2 (1.79%) Computer Science
6 2 (1.79%) User Experience
7 1 (0.89%) Algorithms
Operating Systems
1 2 (1.79%) Linux
2 1 (0.89%) CentOS
2 1 (0.89%) Ubuntu
2 1 (0.89%) Unix
Processes & Methodologies
1 59 (52.68%) Business Intelligence
2 47 (41.96%) Agile Software Development
3 29 (25.89%) Analytics
4 17 (15.18%) Data Modelling
5 15 (13.39%) Data Analysis
5 15 (13.39%) MapReduce
6 14 (12.50%) Data Analytics
6 14 (12.50%) Data Science
7 12 (10.71%) Performance Tuning
8 11 (9.82%) Migration
9 10 (8.93%) Market Research
9 10 (8.93%) Visualisation
10 9 (8.04%) IT Strategy
11 8 (7.14%) CRM
11 8 (7.14%) Data Management
11 8 (7.14%) Problem-Solving
11 8 (7.14%) SDLC
11 8 (7.14%) Statistical Analysis
11 8 (7.14%) TOGAF
12 7 (6.25%) Stakeholder Management
Programming Languages
1 76 (67.86%) SQL
2 20 (17.86%) T-SQL
3 16 (14.29%) Python
4 14 (12.50%) R
5 11 (9.82%) C#
6 10 (8.93%) Scala
7 5 (4.46%) Ruby
8 4 (3.57%) ABAP
9 3 (2.68%) PHP
9 3 (2.68%) PL/SQL
10 2 (1.79%) Bash Shell
10 2 (1.79%) C++
10 2 (1.79%) Go
10 2 (1.79%) Java
10 2 (1.79%) Java 8
10 2 (1.79%) JavaScript
10 2 (1.79%) PowerShell
10 2 (1.79%) VB
10 2 (1.79%) VB.NET
10 2 (1.79%) VBA
Qualifications
1 5 (4.46%) Microsoft Certification
2 4 (3.57%) Degree
3 2 (1.79%) MBA
4 1 (0.89%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 8 (7.14%) Data Quality
2 3 (2.68%) GDPR
3 1 (0.89%) PCI DSS
System Software
1 7 (6.25%) HDFS
2 6 (5.36%) Apache Flume
3 5 (4.46%) Virtual Machines
4 2 (1.79%) Docker
Systems Management
1 7 (6.25%) Oozie
2 5 (4.46%) SCCM
2 5 (4.46%) SCOM
2 5 (4.46%) SCOrch
3 3 (2.68%) Puppet
3 3 (2.68%) ZABBIX
4 2 (1.79%) Cobbler
4 2 (1.79%) Nagios
4 2 (1.79%) Opscode Chef
4 2 (1.79%) Prometheus
4 2 (1.79%) Rancher
4 2 (1.79%) Terraform
4 2 (1.79%) Tivoli
5 1 (0.89%) Ansible
5 1 (0.89%) Data Guard
5 1 (0.89%) Enterprise Manager Cloud Control
5 1 (0.89%) Oracle RMAN
5 1 (0.89%) Xymon
Vendors
1 36 (32.14%) Microsoft
2 15 (13.39%) SAP
3 14 (12.50%) Tableau
4 9 (8.04%) Informatica
4 9 (8.04%) Oracle
4 9 (8.04%) Talend
5 6 (5.36%) Cognos
5 6 (5.36%) Google
5 6 (5.36%) Sybase
6 3 (2.68%) MuleSoft
6 3 (2.68%) webMethods
7 2 (1.79%) New Relic
7 2 (1.79%) Rackspace
7 2 (1.79%) Splunk
8 1 (0.89%) Facebook
8 1 (0.89%) IBM
8 1 (0.89%) Red Hat
8 1 (0.89%) Sage