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

Extract, Transform and Load (ETL)
6 months to
22 Feb 2018
Same period 2017 Same period 2016
Rank 88 111 65
Rank change year-on-year +23 -46 +39
Permanent jobs citing ETL 146 133 270
As % of all permanent IT jobs advertised in Leeds 2.95% 2.50% 3.97%
As % of the Processes & Methodologies category 3.17% 2.77% 4.39%
Number of salaries quoted 123 115 202
Leeds median annual salary £42,500 £42,500 £45,000
Median salary % change year-on-year - -5.56% -
10th Percentile £32,500 £32,500 £29,900
90th Percentile £56,000 £52,500 £67,500
West Yorkshire median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -11.11%

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,603 4,798 6,148
As % of all permanent IT jobs advertised in Leeds 93.08% 90.32% 90.32%
Number of salaries quoted 3,904 4,151 5,001
Leeds median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - +6.25%
10th Percentile £30,000 £26,750 £27,500
90th Percentile £62,500 £60,000 £62,000
West Yorkshire median annual salary £43,000 £42,500 £42,000
% change year-on-year +1.18% +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 22 February 2018.

Salary histogram for ETL in Leeds

For the 6 months to 22 February 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 116 (79.45%) SQL Server Integration Services
2 114 (78.08%) SQL
3 102 (69.86%) Business Intelligence
4 99 (67.81%) SQL Server
5 87 (59.59%) SQL Server Reporting Services
6 77 (52.74%) Data Warehouse
7 69 (47.26%) Microsoft
8 63 (43.15%) SQL Server Analysis Services
9 54 (36.99%) T-SQL
10 41 (28.08%) Analytics
11 38 (26.03%) Agile Software Development
12 30 (20.55%) SQL Server 2016
13 29 (19.86%) SQL Server 2014
13 29 (19.86%) Data Modelling
14 28 (19.18%) Data Analysis
14 28 (19.18%) Tableau
15 23 (15.75%) Data Integration
16 22 (15.07%) SQL Server 2008
17 21 (14.38%) Microsoft Certification
18 20 (13.70%) Migration
18 20 (13.70%) Team Foundation Server
18 20 (13.70%) SQL Server 2012
19 19 (13.01%) Performance Tuning
19 19 (13.01%) Advertising
19 19 (13.01%) Visual Studio
20 18 (12.33%) Oracle
21 15 (10.27%) SAP
22 14 (9.59%) .NET
22 14 (9.59%) Stakeholder Management
22 14 (9.59%) Talend

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 (4.79%) SAS
2 3 (2.05%) SharePoint
3 2 (1.37%) Apache Spark
Applications
1 6 (4.11%) Microsoft Excel
2 1 (0.68%) MS Visio
Business Applications
1 6 (4.11%) Dynamics CRM
Cloud Services
1 8 (5.48%) Microsoft Azure
2 1 (0.68%) Azure Data Factory
2 1 (0.68%) Cortana Intelligence Suite
2 1 (0.68%) Serverless
Communications & Networking
1 1 (0.68%) DSL
Database & Business Intelligence
1 116 (79.45%) SQL Server Integration Services
2 99 (67.81%) SQL Server
3 87 (59.59%) SQL Server Reporting Services
4 77 (52.74%) Data Warehouse
5 63 (43.15%) SQL Server Analysis Services
6 30 (20.55%) SQL Server 2016
7 29 (19.86%) SQL Server 2014
8 22 (15.07%) SQL Server 2008
9 20 (13.70%) SQL Server 2012
10 14 (9.59%) SQL Server 2005
11 13 (8.90%) Big Data
11 13 (8.90%) Power BI
11 13 (8.90%) SQL Server 2000
12 12 (8.22%) Data Mining
12 12 (8.22%) Enterprise Data Warehouse
13 10 (6.85%) QlikView
14 8 (5.48%) BusinessObjects
15 7 (4.79%) Hadoop
15 7 (4.79%) Relational Database
15 7 (4.79%) SAP BW
Development Applications
1 20 (13.70%) Team Foundation Server
2 19 (13.01%) Visual Studio
3 4 (2.74%) Octopus Deploy
4 3 (2.05%) Selenium
4 3 (2.05%) TeamCity
4 3 (2.05%) WebDriver
5 2 (1.37%) SQL Server Management Studio (SSMS)
6 1 (0.68%) SoapUI
6 1 (0.68%) SpecFlow
General
1 19 (13.01%) Advertising
2 13 (8.90%) Finance
3 7 (4.79%) Games
3 7 (4.79%) Law
4 3 (2.05%) Retail
5 1 (0.68%) Marketing
Job Titles
1 85 (58.22%) Developer
2 43 (29.45%) ETL Developer
3 42 (28.77%) Business Intelligence Developer
4 28 (19.18%) SQL Developer
4 28 (19.18%) SSIS Developer
5 23 (15.75%) Business Developer
6 16 (10.96%) DBA
7 15 (10.27%) Data Warehouse Developer
8 13 (8.90%) Analyst
8 13 (8.90%) SSAS Developer
8 13 (8.90%) SSRS Developer
9 11 (7.53%) SQL BI Developer
10 9 (6.16%) Administrator
11 8 (5.48%) T-SQL Developer
12 7 (4.79%) Senior DBA
12 7 (4.79%) Senior SQL DBA
12 7 (4.79%) SQL DBA
13 6 (4.11%) Business Intelligence Analyst
13 6 (4.11%) Trainer
14 4 (2.74%) Consultant
Libraries, Frameworks & Software Standards
1 14 (9.59%) .NET
2 10 (6.85%) ASP.NET
3 8 (5.48%) XML
4 5 (3.42%) REST
5 4 (2.74%) JSON
5 4 (2.74%) SOAP
6 3 (2.05%) Entity Framework
6 3 (2.05%) Kafka
6 3 (2.05%) Web Services
7 2 (1.37%) XSD
8 1 (0.68%) CSS
8 1 (0.68%) Django
8 1 (0.68%) HTML
8 1 (0.68%) HTML5
8 1 (0.68%) MDX
8 1 (0.68%) NumPy
8 1 (0.68%) Pandas
8 1 (0.68%) scikit-learn
8 1 (0.68%) SciPy
8 1 (0.68%) Spark Streaming
Miscellaneous
1 11 (7.53%) Analytical Skills
2 8 (5.48%) Management Information System
3 7 (4.79%) Clustering
4 6 (4.11%) Data Structures
5 5 (3.42%) Replication
6 3 (2.05%) Computer Science
7 2 (1.37%) Taxonomies
8 1 (0.68%) User Experience
Operating Systems
1 3 (2.05%) Linux
1 3 (2.05%) Unix
2 1 (0.68%) Windows
Processes & Methodologies
1 102 (69.86%) Business Intelligence
2 41 (28.08%) Analytics
3 38 (26.03%) Agile Software Development
4 29 (19.86%) Data Modelling
5 28 (19.18%) Data Analysis
6 23 (15.75%) Data Integration
7 20 (13.70%) Migration
8 19 (13.01%) Performance Tuning
9 14 (9.59%) Stakeholder Management
10 13 (8.90%) Disaster Recovery
10 13 (8.90%) Visualisation
11 12 (8.22%) E-Commerce
12 11 (7.53%) Data Transformation
12 11 (7.53%) Database Security
13 10 (6.85%) Data Cleansing
14 9 (6.16%) Data Analytics
14 9 (6.16%) Data Visualisation
14 9 (6.16%) Performance Analysis
15 8 (5.48%) ETL Development
15 8 (5.48%) Kimball Methodology
Programming Languages
1 114 (78.08%) SQL
2 54 (36.99%) T-SQL
3 13 (8.90%) PowerShell
4 9 (6.16%) C#
4 9 (6.16%) PL/SQL
5 6 (4.11%) Java
6 5 (3.42%) ABAP
7 3 (2.05%) JavaScript
7 3 (2.05%) Python
7 3 (2.05%) R
7 3 (2.05%) VBA
8 2 (1.37%) Scala
8 2 (1.37%) XPath
9 1 (0.68%) HiveQL
Qualifications
1 21 (14.38%) Microsoft Certification
2 12 (8.22%) MCSA
3 9 (6.16%) MCSE
4 6 (4.11%) Degree
5 3 (2.05%) Computer Science Degree
5 3 (2.05%) MCP
6 1 (0.68%) Numerate Degree
6 1 (0.68%) SC Cleared
6 1 (0.68%) Security Cleared
Quality Assurance & Compliance
1 3 (2.05%) QA
2 2 (1.37%) SLA
3 1 (0.68%) Data Quality
System Software
1 7 (4.79%) Virtual Machines
2 2 (1.37%) Apache Flume
2 2 (1.37%) HDFS
Systems Management
1 7 (4.79%) SCCM
1 7 (4.79%) SCOM
1 7 (4.79%) SCOrch
2 2 (1.37%) Oozie
Vendors
1 69 (47.26%) Microsoft
2 28 (19.18%) Tableau
3 18 (12.33%) Oracle
4 15 (10.27%) SAP
5 14 (9.59%) Talend
6 8 (5.48%) Cognos
7 3 (2.05%) IBM
7 3 (2.05%) RedGate
8 2 (1.37%) Informatica
8 2 (1.37%) MicroStrategy
9 1 (0.68%) Capita
9 1 (0.68%) Facebook