Period
to 24 November 2017

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

Extract, Transform and Load (ETL)
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 76 91 117
Rank change year-on-year +15 +26 -12
Permanent jobs citing ETL 168 165 163
As % of all permanent IT jobs advertised in Leeds 3.39% 3.02% 2.34%
As % of the Processes & Methodologies category 3.67% 3.33% 2.55%
Number of salaries quoted 146 135 127
Leeds median annual salary £41,500 £45,000 £50,000
Median salary % change year-on-year -7.78% -10.00% +11.11%
10th Percentile £31,500 £32,500 £29,250
90th Percentile £58,750 £52,500 £77,500
West Yorkshire median annual salary £42,500 £45,000 £46,500
% change year-on-year -5.56% -3.23% +3.33%

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 4576 4958 6389
As % of all permanent IT jobs advertised in Leeds 92.20% 90.89% 91.89%
Number of salaries quoted 3849 4248 5088
Leeds median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - +6.25%
10th Percentile £27,500 £26,250 £27,000
90th Percentile £62,500 £62,500 £60,300
West Yorkshire median annual salary £42,500 £42,500 £42,000
% change year-on-year - +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 24 November 2017.

Salary histogram for ETL in Leeds

For the 6 months to 24 November 2017, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Leeds region with a requirement for ETL.

1 141 (83.93%) SQL
2 120 (71.43%) SQL Server Integration Services
3 115 (68.45%) SQL Server
4 104 (61.90%) Business Intelligence
5 91 (54.17%) Data Warehouse
6 90 (53.57%) Microsoft
7 78 (46.43%) SQL Server Reporting Services
8 75 (44.64%) SQL Server Analysis Services
9 56 (33.33%) T-SQL
10 44 (26.19%) Data Modelling
11 37 (22.02%) Agile Software Development
11 37 (22.02%) Migration
12 35 (20.83%) Analytics
13 29 (17.26%) Data Analysis
13 29 (17.26%) Visual Studio
14 28 (16.67%) SQL Server 2012
15 27 (16.07%) Tableau
15 27 (16.07%) Data Integration
15 27 (16.07%) SQL Server 2014
16 25 (14.88%) Team Foundation Server
16 25 (14.88%) .NET
17 24 (14.29%) C#
18 23 (13.69%) Oracle
18 23 (13.69%) Relational Database
19 22 (13.10%) PowerShell
20 21 (12.50%) Data Migration
20 21 (12.50%) Performance Tuning
20 21 (12.50%) Java
20 21 (12.50%) Power BI
21 20 (11.90%) Data Mining

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 11 (6.55%) SAS
2 5 (2.98%) SharePoint
3 3 (1.79%) Apache Spark
4 2 (1.19%) Apache Pig
Applications
1 12 (7.14%) Microsoft Excel
2 7 (4.17%) Microsoft Office
3 1 (0.60%) SPSS
Business Applications
1 9 (5.36%) Dynamics CRM
Cloud Services
1 16 (9.52%) Microsoft Azure
2 2 (1.19%) Cortana Intelligence Suite
3 1 (0.60%) Amazon AWS
3 1 (0.60%) GitHub
Communications & Networking
1 1 (0.60%) SMS
Database & Business Intelligence
1 120 (71.43%) SQL Server Integration Services
2 115 (68.45%) SQL Server
3 91 (54.17%) Data Warehouse
4 78 (46.43%) SQL Server Reporting Services
5 75 (44.64%) SQL Server Analysis Services
6 28 (16.67%) SQL Server 2012
7 27 (16.07%) SQL Server 2014
8 23 (13.69%) Relational Database
9 21 (12.50%) Power BI
10 20 (11.90%) Data Mining
11 18 (10.71%) SQL Server 2016
12 17 (10.12%) DataStage
12 17 (10.12%) IBM InfoSphere
13 13 (7.74%) Big Data
14 11 (6.55%) QlikView
14 11 (6.55%) SQL Server 2008
15 10 (5.95%) Hadoop
16 9 (5.36%) PowerPivot
17 8 (4.76%) Enterprise Data Warehouse
17 8 (4.76%) RDBMS
Development Applications
1 29 (17.26%) Visual Studio
2 25 (14.88%) Team Foundation Server
3 12 (7.14%) SQL Server Management Studio (SSMS)
4 9 (5.36%) Octopus Deploy
4 9 (5.36%) Talend Open Studio
5 3 (1.79%) Selenium
5 3 (1.79%) TeamCity
5 3 (1.79%) WebDriver
6 1 (0.60%) Eclipse
6 1 (0.60%) Git (software)
6 1 (0.60%) Oracle APEX
6 1 (0.60%) SoapUI
6 1 (0.60%) SpecFlow
General
1 19 (11.31%) Advertising
2 17 (10.12%) Finance
3 9 (5.36%) Games
4 3 (1.79%) Retail
5 1 (0.60%) Legal
Job Titles
1 85 (50.60%) Developer
2 33 (19.64%) ETL Developer
3 30 (17.86%) Business Intelligence Developer
4 28 (16.67%) SQL Developer
5 23 (13.69%) Analyst
5 23 (13.69%) SSIS Developer
6 20 (11.90%) DBA
7 18 (10.71%) Administrator
8 12 (7.14%) Data Warehouse Developer
9 11 (6.55%) Trainer
10 10 (5.95%) Business Intelligence Analyst
11 9 (5.36%) Database Developer
12 8 (4.76%) SQL BI Developer
13 6 (3.57%) Business Developer
13 6 (3.57%) Data Analyst
13 6 (3.57%) Database Engineer
13 6 (3.57%) SAP Developer
13 6 (3.57%) Senior Database Engineer
14 5 (2.98%) .NET Developer
14 5 (2.98%) Senior Developer
Libraries, Frameworks & Software Standards
1 25 (14.88%) .NET
2 9 (5.36%) ASP.NET
2 9 (5.36%) XML
3 4 (2.38%) AngularJS
3 4 (2.38%) RabbitMQ
4 3 (1.79%) .NET Core
5 2 (1.19%) JSON
5 2 (1.19%) REST
5 2 (1.19%) SOAP
5 2 (1.19%) Web Services
6 1 (0.60%) ASP.NET Web API
6 1 (0.60%) CSS
6 1 (0.60%) HTML
6 1 (0.60%) Kafka
6 1 (0.60%) MDX
6 1 (0.60%) Spark Streaming
6 1 (0.60%) WinForms
Miscellaneous
1 15 (8.93%) Analytical Skills
2 10 (5.95%) Data Structures
3 4 (2.38%) Management Information System
3 4 (2.38%) NHS
4 3 (1.79%) Replication
5 2 (1.19%) Computer Science
6 1 (0.60%) Clustering
6 1 (0.60%) Greenfield Project
Operating Systems
1 19 (11.31%) Linux
2 4 (2.38%) Unix
3 2 (1.19%) Android
3 2 (1.19%) Apple iOS
Processes & Methodologies
1 104 (61.90%) Business Intelligence
2 44 (26.19%) Data Modelling
3 37 (22.02%) Agile Software Development
3 37 (22.02%) Migration
4 35 (20.83%) Analytics
5 29 (17.26%) Data Analysis
6 27 (16.07%) Data Integration
7 21 (12.50%) Data Migration
7 21 (12.50%) Performance Tuning
8 20 (11.90%) Data Visualisation
8 20 (11.90%) Visualisation
9 19 (11.31%) ETL Development
10 17 (10.12%) Data Management
10 17 (10.12%) Kimball Methodology
11 16 (9.52%) Data Cleansing
11 16 (9.52%) ERP
12 14 (8.33%) Data Transformation
12 14 (8.33%) E-Commerce
12 14 (8.33%) Stakeholder Management
13 13 (7.74%) Mentoring
Programming Languages
1 141 (83.93%) SQL
2 56 (33.33%) T-SQL
3 24 (14.29%) C#
4 22 (13.10%) PowerShell
5 21 (12.50%) Java
6 17 (10.12%) Shell Script
7 15 (8.93%) Bash Shell
8 10 (5.95%) PL/SQL
9 8 (4.76%) VBA
10 6 (3.57%) Python
11 5 (2.98%) VB.NET
12 4 (2.38%) VB
13 3 (1.79%) JavaScript
14 2 (1.19%) XPath
15 1 (0.60%) Data Analysis Expressions (DAX)
15 1 (0.60%) R
15 1 (0.60%) Scala
15 1 (0.60%) VBScript
Qualifications
1 17 (10.12%) Microsoft Certification
2 15 (8.93%) MCSA
3 12 (7.14%) MCSE
4 10 (5.95%) Degree
5 3 (1.79%) Computer Science Degree
5 3 (1.79%) MCP
5 3 (1.79%) SC Cleared
5 3 (1.79%) Security Cleared
6 1 (0.60%) Numerate Degree
Quality Assurance & Compliance
1 19 (11.31%) QA
2 3 (1.79%) Data Quality
2 3 (1.79%) SLA
System Software
1 3 (1.79%) Docker
2 1 (0.60%) Apache Flume
Systems Management
1 1 (0.60%) Ansible
Vendors
1 90 (53.57%) Microsoft
2 27 (16.07%) Tableau
3 23 (13.69%) Oracle
4 18 (10.71%) SAP
5 17 (10.12%) IBM
6 15 (8.93%) Netezza
7 13 (7.74%) Cognos
8 9 (5.36%) Talend
9 3 (1.79%) Progress
9 3 (1.79%) RedGate
10 2 (1.19%) MicroStrategy
11 1 (0.60%) Capita
11 1 (0.60%) Informatica
11 1 (0.60%) Logi
11 1 (0.60%) Logi Analytics
11 1 (0.60%) Splunk
11 1 (0.60%) Sybase