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

Extract, Transform and Load (ETL)
6 months to
18 Nov 2018
Same period 2017 Same period 2016
Rank 116 76 96
Rank change year-on-year -40 +20 +38
Permanent jobs citing ETL 78 166 165
As % of all permanent IT jobs advertised in Leeds 2.02% 3.39% 3.03%
As % of the Processes & Methodologies category 2.23% 3.61% 3.27%
Number of salaries quoted 74 146 136
Leeds median annual salary £45,000 £41,500 £45,000
Median salary % change year-on-year +8.43% -7.78% -10.00%
10th Percentile £32,500 £31,500 £32,500
90th Percentile £70,250 £58,750 £52,500
West Yorkshire median annual salary £45,000 £42,500 £45,000
% change year-on-year +5.88% -5.56% -5.26%

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,505 4,596 5,053
As % of all permanent IT jobs advertised in Leeds 90.90% 93.80% 92.94%
Number of salaries quoted 2,908 3,866 4,323
Leeds median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -
10th Percentile £27,500 £27,500 £26,250
90th Percentile £63,750 £62,500 £62,500
West Yorkshire median annual salary £43,750 £42,500 £42,500
% change year-on-year +2.94% - +2.75%

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 18 November 2018.

Salary histogram for ETL in Leeds

For the 6 months to 18 November 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 68 (87.18%) SQL
2 55 (70.51%) Business Intelligence
3 45 (57.69%) SQL Server Integration Services
4 40 (51.28%) SQL Server Reporting Services
5 36 (46.15%) Data Warehouse
6 34 (43.59%) SQL Server
7 27 (34.62%) T-SQL
7 27 (34.62%) SQL Server Analysis Services
8 23 (29.49%) Microsoft Excel
9 21 (26.92%) Agile Software Development
9 21 (26.92%) Power BI
10 18 (23.08%) Data Modelling
11 16 (20.51%) Microsoft
11 16 (20.51%) Python
11 16 (20.51%) Analytics
12 15 (19.23%) Finance
13 14 (17.95%) C#
13 14 (17.95%) Tableau
14 13 (16.67%) Cognos
15 12 (15.38%) Microsoft Azure
15 12 (15.38%) Amazon AWS
16 11 (14.10%) Oracle
16 11 (14.10%) Stakeholder Management
17 10 (12.82%) Cognos TM1
17 10 (12.82%) SAP
17 10 (12.82%) IBM
17 10 (12.82%) Tcl
17 10 (12.82%) Relational Database
18 9 (11.54%) Data Analytics
18 9 (11.54%) Microsoft Office

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.97%) Apache Spark
1 7 (8.97%) SAS
2 2 (2.56%) Apache
2 2 (2.56%) Apache Pig
2 2 (2.56%) CMS
2 2 (2.56%) Oracle SOA Suite
3 1 (1.28%) Tomcat
3 1 (1.28%) WildFly
Applications
1 23 (29.49%) Microsoft Excel
2 9 (11.54%) Microsoft Office
3 1 (1.28%) Microsoft Project
Business Applications
1 10 (12.82%) Cognos TM1
Cloud Services
1 12 (15.38%) Amazon AWS
1 12 (15.38%) Microsoft Azure
2 5 (6.41%) Amazon Kinesis
3 4 (5.13%) Amazon SageMaker
4 2 (2.56%) Amazon EMR
4 2 (2.56%) Amazon S3
4 2 (2.56%) Cloud Computing
4 2 (2.56%) GitHub
5 1 (1.28%) Amazon EC2
5 1 (1.28%) AWS Lambda
5 1 (1.28%) Google Analytics
5 1 (1.28%) IaaS
5 1 (1.28%) Serverless
Communications & Networking
1 1 (1.28%) Internet
1 1 (1.28%) Kerberos
Database & Business Intelligence
1 45 (57.69%) SQL Server Integration Services
2 40 (51.28%) SQL Server Reporting Services
3 36 (46.15%) Data Warehouse
4 34 (43.59%) SQL Server
5 27 (34.62%) SQL Server Analysis Services
6 21 (26.92%) Power BI
7 10 (12.82%) Relational Database
8 8 (10.26%) MongoDB
9 7 (8.97%) Big Data
9 7 (8.97%) OLAP
10 6 (7.69%) Amazon RDS
10 6 (7.69%) Amazon Redshift
10 6 (7.69%) Apache Hive
10 6 (7.69%) Data Lake
11 5 (6.41%) Pentaho
12 4 (5.13%) Amazon Aurora
12 4 (5.13%) Hadoop
12 4 (5.13%) QlikView
12 4 (5.13%) Snowflake Schema
12 4 (5.13%) SQL Server 2016
Development Applications
1 2 (2.56%) Visual Studio
2 1 (1.28%) Git (software)
2 1 (1.28%) Jenkins
2 1 (1.28%) Octopus Deploy
2 1 (1.28%) SQL Server Management Studio (SSMS)
2 1 (1.28%) Team Foundation Server
2 1 (1.28%) tSQLt
General
1 15 (19.23%) Finance
2 3 (3.85%) Law
3 1 (1.28%) Automotive
3 1 (1.28%) Banking
3 1 (1.28%) Games
3 1 (1.28%) Marketing
Job Titles
1 45 (57.69%) Developer
2 26 (33.33%) Business Intelligence Developer
3 10 (12.82%) Business Manager
3 10 (12.82%) SQL Developer
4 9 (11.54%) Business Intelligence Manager
5 8 (10.26%) ETL Developer
5 8 (10.26%) Senior Developer
5 8 (10.26%) SQL BI Developer
6 7 (8.97%) Data Engineer
6 7 (8.97%) SSIS Developer
7 6 (7.69%) SSRS Developer
8 4 (5.13%) Analyst
8 4 (5.13%) Data Warehouse Developer
8 4 (5.13%) Senior Business Intelligence Developer
8 4 (5.13%) Software Developer
8 4 (5.13%) SQL Analyst
9 3 (3.85%) Architect
9 3 (3.85%) Business Developer
9 3 (3.85%) Junior
9 3 (3.85%) Junior Developer
Libraries, Frameworks & Software Standards
1 9 (11.54%) .NET
2 8 (10.26%) Web Services
3 4 (5.13%) CSS
3 4 (5.13%) HTML
3 4 (5.13%) XML
4 3 (3.85%) ASP.NET
4 3 (3.85%) WCF
4 3 (3.85%) WinForms
4 3 (3.85%) XHTML
4 3 (3.85%) XSD
4 3 (3.85%) XSLT
5 2 (2.56%) REST
5 2 (2.56%) Spark Streaming
6 1 (1.28%) HTML5
6 1 (1.28%) JSON
6 1 (1.28%) Kafka
6 1 (1.28%) LAMP
6 1 (1.28%) LDAP
6 1 (1.28%) Middleware
6 1 (1.28%) Spring
Miscellaneous
1 6 (7.69%) Analytical Skills
2 3 (3.85%) Management Information System
3 2 (2.56%) Computer Science
4 1 (1.28%) Cloud Native
4 1 (1.28%) Enterprise Cloud
4 1 (1.28%) Greenfield Project
4 1 (1.28%) Mainframe
4 1 (1.28%) Replication
4 1 (1.28%) User Experience
Operating Systems
1 3 (3.85%) Linux
2 2 (2.56%) Unix
3 1 (1.28%) CentOS
3 1 (1.28%) Ubuntu
Processes & Methodologies
1 55 (70.51%) Business Intelligence
2 21 (26.92%) Agile Software Development
3 18 (23.08%) Data Modelling
4 16 (20.51%) Analytics
5 11 (14.10%) Stakeholder Management
6 9 (11.54%) Data Analysis
6 9 (11.54%) Data Analytics
6 9 (11.54%) Data Management
7 8 (10.26%) Collaborative Working
7 8 (10.26%) Project Management
8 7 (8.97%) Data Science
8 7 (8.97%) Migration
8 7 (8.97%) Visualisation
9 6 (7.69%) Data Transformation
9 6 (7.69%) Scrum
10 5 (6.41%) Change Management
10 5 (6.41%) CRM
10 5 (6.41%) Data Integration
10 5 (6.41%) Data Migration
11 4 (5.13%) DevOps
Programming Languages
1 68 (87.18%) SQL
2 27 (34.62%) T-SQL
3 16 (20.51%) Python
4 14 (17.95%) C#
5 10 (12.82%) Tcl
6 9 (11.54%) VBA
7 8 (10.26%) Scala
8 7 (8.97%) Java
9 5 (6.41%) JavaScript
9 5 (6.41%) Ruby
9 5 (6.41%) VB
9 5 (6.41%) VB.NET
10 3 (3.85%) R
11 2 (2.56%) PL/SQL
12 1 (1.28%) Bash Shell
12 1 (1.28%) HiveQL
12 1 (1.28%) PHP
12 1 (1.28%) PowerShell
Qualifications
1 6 (7.69%) Degree
2 4 (5.13%) AWS Certification
3 2 (2.56%) MBA
4 1 (1.28%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 8 (10.26%) Data Quality
2 4 (5.13%) GDPR
3 2 (2.56%) QA
4 1 (1.28%) PCI DSS
System Software
1 3 (3.85%) HDFS
Systems Management
1 4 (5.13%) Oozie
2 1 (1.28%) Ansible
2 1 (1.28%) Puppet
2 1 (1.28%) Xymon
2 1 (1.28%) ZABBIX
Vendors
1 16 (20.51%) Microsoft
2 14 (17.95%) Tableau
3 13 (16.67%) Cognos
4 11 (14.10%) Oracle
5 10 (12.82%) IBM
5 10 (12.82%) SAP
6 5 (6.41%) Alteryx
7 3 (3.85%) Informatica
7 3 (3.85%) MuleSoft
7 3 (3.85%) webMethods
8 2 (2.56%) Avaya
8 2 (2.56%) Hortonworks
8 2 (2.56%) Teradata
9 1 (1.28%) Cloudera
9 1 (1.28%) Databricks
9 1 (1.28%) Google
9 1 (1.28%) Red Hat
9 1 (1.28%) Talend