Period
to 9 December 2019

The following table provides summary statistics for permanent job vacancies advertised in Yorkshire 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 9 December 2019 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > Yorkshire
6 months to
9 Dec 2019
Same period 2018 Same period 2017
Rank 133 134 91
Rank change year-on-year +1 -43 +23
Permanent jobs citing ETL 133 173 284
As % of all permanent IT jobs advertised in Yorkshire 2.04% 2.18% 2.92%
As % of the Processes & Methodologies category 2.23% 2.37% 3.16%
Number of salaries quoted 117 153 246
Yorkshire median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - -
10th Percentile £35,000 £31,250 £31,500
90th Percentile £63,354 £62,750 £55,000
England median annual salary £55,000 £55,000 £50,000
% change year-on-year - +10.00% -4.76%

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

All Process and Methodology Skills
Yorkshire
Permanent vacancies with a requirement for process or methodology skills 5,966 7,310 8,993
As % of all permanent IT jobs advertised in Yorkshire 91.55% 92.14% 92.39%
Number of salaries quoted 4,883 5,948 7,556
Yorkshire median annual salary £45,000 £43,000 £42,500
Median salary % change year-on-year +4.65% +1.18% +6.25%
10th Percentile £26,250 £26,250 £26,250
90th Percentile £67,500 £62,500 £60,000
England median annual salary £52,500 £52,500 £50,000
% change year-on-year - +5.00% -

ETL
Job Vacancy Trend in Yorkshire

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

Job vacancy trend for ETL in Yorkshire

ETL
Salary Trend in Yorkshire

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

Salary trend for ETL in Yorkshire

ETL
Salary Histogram in Yorkshire

The salary distribution of IT jobs citing ETL in Yorkshire over the 6 months to 9 December 2019.

Salary histogram for ETL in Yorkshire

ETL
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Yorkshire region over the 6 months to 9 December 2019. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
West Yorkshire +9 98 £47,500 +8.26% 25
South Yorkshire +2 14 £44,385 +4.44% 4
North Yorkshire -8 14 £37,500 -23.47%
East Yorkshire +11 7 £37,500 +15.38%
ETL
England

For the 6 months to 9 December 2019, 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 Yorkshire region with a requirement for ETL.

1 112 (84.21%) SQL
2 78 (58.65%) Business Intelligence
3 75 (56.39%) Data Warehouse
4 62 (46.62%) SQL Server Integration Services
5 52 (39.10%) SQL Server
6 47 (35.34%) Data Modelling
6 47 (35.34%) Power BI
6 47 (35.34%) Power Platform
7 46 (34.59%) T-SQL
8 40 (30.08%) Analytics
9 39 (29.32%) Agile Software Development
10 38 (28.57%) Microsoft
11 36 (27.07%) Big Data
12 32 (24.06%) Apache Spark
13 31 (23.31%) ETL Development
14 29 (21.80%) SQL Server Analysis Services
15 27 (20.30%) SQL Server Reporting Services
15 27 (20.30%) Oracle
15 27 (20.30%) Finance
16 26 (19.55%) Python
16 26 (19.55%) Scala
16 26 (19.55%) Data Engineering
17 25 (18.80%) Azure
17 25 (18.80%) Java
18 22 (16.54%) Hadoop
18 22 (16.54%) Mentoring
19 21 (15.79%) AWS
19 21 (15.79%) Star Schema
20 20 (15.04%) Coaching
21 19 (14.29%) Visualisation

ETL
Co-occurring IT Skills in Yorkshire 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 32 (24.06%) Apache Spark
2 3 (2.26%) Confluence
2 3 (2.26%) SharePoint
3 2 (1.50%) SharePoint 2013
4 1 (0.75%) Apache
4 1 (0.75%) BizTalk Server
4 1 (0.75%) Elasticsearch
4 1 (0.75%) SAS
4 1 (0.75%) WebLogic Portal
Applications
1 7 (5.26%) Microsoft Excel
2 2 (1.50%) Microsoft Office
Business Applications
1 1 (0.75%) Dynamics CRM
1 1 (0.75%) SAP ERP
Cloud Services
1 47 (35.34%) Power Platform
2 25 (18.80%) Azure
3 21 (15.79%) AWS
4 10 (7.52%) Amazon EMR
5 7 (5.26%) Amazon S3
6 6 (4.51%) Azure Data Factory
6 6 (4.51%) GCP
6 6 (4.51%) GitHub
7 4 (3.01%) Amazon Kinesis
8 3 (2.26%) AWS CloudFormation
8 3 (2.26%) Google Sheets
9 2 (1.50%) Amazon EC2
9 2 (1.50%) Amazon SageMaker
10 1 (0.75%) AWS Lambda
10 1 (0.75%) SaaS
10 1 (0.75%) Serverless
Database & Business Intelligence
1 75 (56.39%) Data Warehouse
2 62 (46.62%) SQL Server Integration Services
3 52 (39.10%) SQL Server
4 47 (35.34%) Power BI
5 36 (27.07%) Big Data
6 29 (21.80%) SQL Server Analysis Services
7 27 (20.30%) SQL Server Reporting Services
8 22 (16.54%) Hadoop
9 21 (15.79%) Star Schema
10 19 (14.29%) Apache Hive
11 18 (13.53%) QlikView
12 16 (12.03%) NoSQL
13 12 (9.02%) Relational Database
14 10 (7.52%) Data Lake
15 9 (6.77%) Impala
15 9 (6.77%) Oracle Database
15 9 (6.77%) Sqoop
16 8 (6.02%) Apache Cassandra
17 7 (5.26%) Azure SQL Database
18 6 (4.51%) MongoDB
Development Applications
1 8 (6.02%) Git (software)
1 8 (6.02%) Team Foundation Server
1 8 (6.02%) Visual Studio
2 6 (4.51%) GitLab
2 6 (4.51%) Octopus Deploy
3 5 (3.76%) tSQLt
4 4 (3.01%) ERwin
5 3 (2.26%) JIRA
6 2 (1.50%) Bitbucket
7 1 (0.75%) Atlassian Bamboo
7 1 (0.75%) Selenium
7 1 (0.75%) SpecFlow
7 1 (0.75%) SQL Server Management Studio (SSMS)
7 1 (0.75%) TestRail
7 1 (0.75%) WebDriver
General
1 27 (20.30%) Finance
2 6 (4.51%) Manufacturing
3 3 (2.26%) Retail
4 2 (1.50%) Legal
5 1 (0.75%) Law
5 1 (0.75%) Pharmaceutical
Job Titles
1 84 (63.16%) Developer
2 55 (41.35%) Business Intelligence Developer
3 27 (20.30%) ETL Developer
4 25 (18.80%) Data Engineer
5 14 (10.53%) SQL Developer
6 13 (9.77%) Big Data Engineer
7 11 (8.27%) Analyst
7 11 (8.27%) Business Developer
8 10 (7.52%) Senior Data Engineer
9 9 (6.77%) Architect
9 9 (6.77%) Senior Developer
10 7 (5.26%) Data Architect
11 5 (3.76%) Business Intelligence Analyst
11 5 (3.76%) Data Analyst
11 5 (3.76%) Database Developer
11 5 (3.76%) Junior
11 5 (3.76%) Senior Business Intelligence Developer
11 5 (3.76%) SQL BI Developer
11 5 (3.76%) SQL Database Developer
11 5 (3.76%) SSIS Developer
Libraries, Frameworks & Software Standards
1 12 (9.02%) Kafka
2 5 (3.76%) .NET
3 4 (3.01%) Web Services
4 2 (1.50%) Elastic Stack
4 2 (1.50%) JSON
4 2 (1.50%) MDX
4 2 (1.50%) REST
4 2 (1.50%) SOAP
4 2 (1.50%) XML
5 1 (0.75%) .NET Core
5 1 (0.75%) AngularJS
5 1 (0.75%) EDI
5 1 (0.75%) Node.js
5 1 (0.75%) React
5 1 (0.75%) Vue.js
Miscellaneous
1 18 (13.53%) Analytical Skills
2 4 (3.01%) Self-Motivation
3 3 (2.26%) Algorithms
3 3 (2.26%) Derivative
3 3 (2.26%) Driving Licence
3 3 (2.26%) Mainframe
3 3 (2.26%) Management Information System
4 2 (1.50%) Clustering
4 2 (1.50%) NHS
4 2 (1.50%) Replication
4 2 (1.50%) Tandem
4 2 (1.50%) User Experience
5 1 (0.75%) Greenfield Project
5 1 (0.75%) Lidar
5 1 (0.75%) Taxonomies
5 1 (0.75%) Video\Live Streaming
5 1 (0.75%) Virtual Team
Operating Systems
1 6 (4.51%) Unix
2 1 (0.75%) AIX
2 1 (0.75%) Linux
2 1 (0.75%) Windows
2 1 (0.75%) Windows Server
2 1 (0.75%) Windows Server 2003
2 1 (0.75%) Windows Server 2012
Processes & Methodologies
1 78 (58.65%) Business Intelligence
2 47 (35.34%) Data Modelling
3 40 (30.08%) Analytics
4 39 (29.32%) Agile Software Development
5 31 (23.31%) ETL Development
6 26 (19.55%) Data Engineering
7 22 (16.54%) Mentoring
8 20 (15.04%) Coaching
9 19 (14.29%) Visualisation
10 18 (13.53%) Continuous Improvement
11 17 (12.78%) Data Science
12 15 (11.28%) Kimball Methodology
12 15 (11.28%) Migration
12 15 (11.28%) Technical Leadership
13 14 (10.53%) Decision-Making
13 14 (10.53%) Machine Learning
14 13 (9.77%) Digital Transformation Programme
15 12 (9.02%) Data Development
15 12 (9.02%) Project Management
16 11 (8.27%) Data Analysis
Programming Languages
1 112 (84.21%) SQL
2 46 (34.59%) T-SQL
3 26 (19.55%) Python
3 26 (19.55%) Scala
4 25 (18.80%) Java
5 16 (12.03%) C#
6 8 (6.02%) PL/SQL
6 8 (6.02%) PowerShell
7 5 (3.76%) R
7 5 (3.76%) Shell Script
8 3 (2.26%) C
8 3 (2.26%) JavaScript
8 3 (2.26%) MATLAB
8 3 (2.26%) Ruby
9 2 (1.50%) VB
9 2 (1.50%) VBA
10 1 (0.75%) Bash Shell
10 1 (0.75%) Go
10 1 (0.75%) PHP
Qualifications
1 3 (2.26%) Microsoft Certification
2 2 (1.50%) Degree
2 2 (1.50%) MCITP
2 2 (1.50%) MCTS
3 1 (0.75%) MCSA
3 1 (0.75%) MCSD
3 1 (0.75%) MCSE
Quality Assurance & Compliance
1 12 (9.02%) Data Quality
2 5 (3.76%) QA
3 4 (3.01%) GDPR
4 3 (2.26%) Actionable Recommendations
5 1 (0.75%) GMP
5 1 (0.75%) ISO 9001
System Software
1 17 (12.78%) HDFS
2 6 (4.51%) Apache Flume
Systems Management
1 6 (4.51%) Oozie
2 3 (2.26%) Terraform
3 2 (1.50%) Hadoop YARN
3 2 (1.50%) Mesos
Vendors
1 38 (28.57%) Microsoft
2 27 (20.30%) Oracle
3 15 (11.28%) Cloudera
4 13 (9.77%) Informatica
5 12 (9.02%) Tableau
6 8 (6.02%) SAP
7 7 (5.26%) Talend
8 5 (3.76%) Alteryx
8 5 (3.76%) Google
9 4 (3.01%) Databricks
9 4 (3.01%) Paxata
10 3 (2.26%) IBM
11 2 (1.50%) Cognos
12 1 (0.75%) Atlassian
12 1 (0.75%) Autodesk
12 1 (0.75%) BEA
12 1 (0.75%) Netezza
12 1 (0.75%) Salesforce.com
12 1 (0.75%) Sitecore
12 1 (0.75%) Xamarin