Period
to 23 November 2017

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

Extract, Transform and Load (ETL)
England > Yorkshire
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 91 110 122
Rank change year-on-year +19 +12 -17
Permanent jobs citing ETL 298 283 338
As % of all permanent IT jobs advertised in Yorkshire 3.02% 2.53% 2.58%
As % of the Processes & Methodologies category 3.35% 2.82% 2.86%
Number of salaries quoted 260 228 268
Yorkshire median annual salary £42,500 £42,500 £45,000
Median salary % change year-on-year - -5.56% -
10th Percentile £31,250 £32,500 £29,750
90th Percentile £55,000 £52,500 £67,500
England median annual salary £50,000 £52,500 £52,000
% change year-on-year -4.76% +0.96% -0.95%

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 8883 10042 11835
As % of all permanent IT jobs advertised in Yorkshire 90.14% 89.67% 90.21%
Number of salaries quoted 7439 8453 9634
Yorkshire median annual salary £42,500 £42,000 £40,000
Median salary % change year-on-year +1.19% +5.00% +1.27%
10th Percentile £26,250 £26,250 £26,075
90th Percentile £61,250 £62,500 £60,000
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

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 23 November 2017.

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 23 November 2017. 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 +15 239 £42,500 -5.56% 13
East Yorkshire +15 24 £45,000 +95.65% 1
South Yorkshire +15 18 £35,000 -
North Yorkshire +5 9 £42,500 +21.43% 2
ETL
England

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

1 240 (80.54%) SQL
2 211 (70.81%) SQL Server
3 206 (69.13%) SQL Server Integration Services
4 197 (66.11%) Business Intelligence
5 190 (63.76%) Data Warehouse
6 160 (53.69%) SQL Server Reporting Services
7 152 (51.01%) Microsoft
8 145 (48.66%) SQL Server Analysis Services
9 131 (43.96%) T-SQL
10 88 (29.53%) Data Modelling
11 63 (21.14%) Power BI
12 62 (20.81%) Agile Software Development
13 49 (16.44%) ETL Development
14 48 (16.11%) Performance Tuning
15 47 (15.77%) Analytics
15 47 (15.77%) SAP
16 46 (15.44%) Visualisation
17 45 (15.10%) Finance
17 45 (15.10%) Migration
18 44 (14.77%) PowerShell
19 42 (14.09%) Data Analysis
19 42 (14.09%) Visual Studio
19 42 (14.09%) Data Visualisation
19 42 (14.09%) SQL Server 2012
20 39 (13.09%) Oracle
21 37 (12.42%) Tableau
22 36 (12.08%) Data Integration
23 35 (11.74%) Team Foundation Server
24 34 (11.41%) SQL Server 2016
24 34 (11.41%) C#

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 15 (5.03%) SAS
2 10 (3.36%) SharePoint
3 3 (1.01%) Apache Spark
4 2 (0.67%) Apache Pig
5 1 (0.34%) IBM Notes
5 1 (0.34%) Tomcat
Applications
1 20 (6.71%) Microsoft Excel
2 7 (2.35%) Microsoft Office
3 3 (1.01%) Microsoft Project
4 1 (0.34%) Microsoft PowerPoint
4 1 (0.34%) MS Visio
4 1 (0.34%) SPSS
Business Applications
1 9 (3.02%) Dynamics CRM
2 5 (1.68%) SAP Hybris
3 1 (0.34%) Oracle ERP
Cloud Services
1 32 (10.74%) Microsoft Azure
2 6 (2.01%) Amazon AWS
3 2 (0.67%) Cortana Intelligence Suite
4 1 (0.34%) GitHub
4 1 (0.34%) Office 365
Communications & Networking
1 1 (0.34%) SMS
Database & Business Intelligence
1 211 (70.81%) SQL Server
2 206 (69.13%) SQL Server Integration Services
3 190 (63.76%) Data Warehouse
4 160 (53.69%) SQL Server Reporting Services
5 145 (48.66%) SQL Server Analysis Services
6 63 (21.14%) Power BI
7 42 (14.09%) SQL Server 2012
8 34 (11.41%) SQL Server 2016
9 30 (10.07%) Relational Database
9 30 (10.07%) SQL Server 2014
10 20 (6.71%) Data Mining
10 20 (6.71%) SAP HANA
11 19 (6.38%) QlikView
12 18 (6.04%) SQL Server 2008
13 17 (5.70%) Big Data
13 17 (5.70%) DataStage
13 17 (5.70%) IBM InfoSphere
14 15 (5.03%) BusinessObjects
14 15 (5.03%) SAP Data Services
15 14 (4.70%) Hadoop
Development Applications
1 42 (14.09%) Visual Studio
2 35 (11.74%) Team Foundation Server
3 31 (10.40%) SQL Server Management Studio (SSMS)
4 15 (5.03%) Octopus Deploy
5 14 (4.70%) Talend Open Studio
6 4 (1.34%) TeamCity
6 4 (1.34%) Visual Studio Team System
7 3 (1.01%) Selenium
7 3 (1.01%) WebDriver
8 2 (0.67%) Git (software)
9 1 (0.34%) Eclipse
9 1 (0.34%) Jenkins
9 1 (0.34%) Oracle APEX
9 1 (0.34%) SoapUI
9 1 (0.34%) Sonatype Nexus
9 1 (0.34%) SpecFlow
General
1 45 (15.10%) Finance
2 28 (9.40%) Advertising
3 9 (3.02%) Games
3 9 (3.02%) Retail
4 8 (2.68%) Manufacturing
5 4 (1.34%) Banking
6 3 (1.01%) Retail Finance
6 3 (1.01%) Telecoms
7 1 (0.34%) Law
7 1 (0.34%) Legal
7 1 (0.34%) Private Banking
7 1 (0.34%) Retail Banking
Job Titles
1 153 (51.34%) Developer
2 70 (23.49%) Business Intelligence Developer
3 42 (14.09%) DBA
4 41 (13.76%) ETL Developer
4 41 (13.76%) SQL Developer
5 37 (12.42%) Administrator
6 35 (11.74%) Analyst
6 35 (11.74%) SSIS Developer
7 25 (8.39%) Senior DBA
8 24 (8.05%) SQL DBA
9 23 (7.72%) Data Warehouse Developer
9 23 (7.72%) Senior Developer
10 22 (7.38%) Business Developer
11 20 (6.71%) Senior SQL DBA
12 19 (6.38%) Architect
13 17 (5.70%) Senior Business Intelligence Developer
14 16 (5.37%) Database Developer
15 14 (4.70%) Data Architect
16 12 (4.03%) SQL BI Developer
17 11 (3.69%) SSRS Developer
Libraries, Frameworks & Software Standards
1 27 (9.06%) .NET
2 15 (5.03%) Middleware
3 14 (4.70%) XML
4 9 (3.02%) ASP.NET
5 4 (1.34%) AngularJS
5 4 (1.34%) RabbitMQ
6 3 (1.01%) .NET Core
6 3 (1.01%) JSON
6 3 (1.01%) SOAP
6 3 (1.01%) Web Services
7 2 (0.67%) REST
7 2 (0.67%) WinForms
8 1 (0.34%) ASP.NET Web API
8 1 (0.34%) CSS
8 1 (0.34%) HTML
8 1 (0.34%) Ionic Framework
8 1 (0.34%) Kafka
8 1 (0.34%) PhoneGap
8 1 (0.34%) RAML
8 1 (0.34%) Spark Streaming
Miscellaneous
1 27 (9.06%) Analytical Skills
2 14 (4.70%) Data Structures
3 8 (2.68%) NHS
4 5 (1.68%) Management Information System
5 4 (1.34%) Clustering
5 4 (1.34%) Data Centre
6 3 (1.01%) Replication
7 2 (0.67%) Computer Science
8 1 (0.34%) Greenfield Project
8 1 (0.34%) Mobile App
Operating Systems
1 20 (6.71%) Linux
2 5 (1.68%) Unix
3 2 (0.67%) Android
3 2 (0.67%) Apple iOS
Processes & Methodologies
1 197 (66.11%) Business Intelligence
2 88 (29.53%) Data Modelling
3 62 (20.81%) Agile Software Development
4 49 (16.44%) ETL Development
5 48 (16.11%) Performance Tuning
6 47 (15.77%) Analytics
7 46 (15.44%) Visualisation
8 45 (15.10%) Migration
9 42 (14.09%) Data Analysis
9 42 (14.09%) Data Visualisation
10 36 (12.08%) Data Integration
11 32 (10.74%) Data Management
12 26 (8.72%) Mentoring
13 25 (8.39%) Kimball Methodology
13 25 (8.39%) Stakeholder Management
14 23 (7.72%) Disaster Recovery
15 22 (7.38%) CRM
15 22 (7.38%) Data Cleansing
16 21 (7.05%) Data Migration
16 21 (7.05%) E-Commerce
Programming Languages
1 240 (80.54%) SQL
2 131 (43.96%) T-SQL
3 44 (14.77%) PowerShell
4 34 (11.41%) C#
5 23 (7.72%) Java
6 17 (5.70%) Shell Script
7 15 (5.03%) Bash Shell
8 14 (4.70%) PL/SQL
9 10 (3.36%) Python
10 8 (2.68%) VBA
11 5 (1.68%) R
11 5 (1.68%) VB
11 5 (1.68%) VB.NET
12 3 (1.01%) ABAP
12 3 (1.01%) JavaScript
13 2 (0.67%) XPath
14 1 (0.34%) C++
14 1 (0.34%) PHP
14 1 (0.34%) Scala
14 1 (0.34%) VBScript
Qualifications
1 34 (11.41%) Microsoft Certification
2 32 (10.74%) MCSA
3 29 (9.73%) MCSE
4 15 (5.03%) Degree
5 4 (1.34%) ISEB
5 4 (1.34%) ISTQB
6 3 (1.01%) Computer Science Degree
6 3 (1.01%) MCP
6 3 (1.01%) SC Cleared
6 3 (1.01%) Security Cleared
7 1 (0.34%) Numerate Degree
Quality Assurance & Compliance
1 25 (8.39%) Data Quality
2 19 (6.38%) QA
3 4 (1.34%) SLA
4 1 (0.34%) Actionable Recommendations
4 1 (0.34%) ISO 9001
4 1 (0.34%) ISO/IEC 27001
4 1 (0.34%) PCI DSS
System Software
1 4 (1.34%) Active Directory
1 4 (1.34%) VMware Infrastructure
2 3 (1.01%) Docker
3 1 (0.34%) Apache Flume
Systems Management
1 1 (0.34%) Ansible
1 1 (0.34%) Puppet
Vendors
1 152 (51.01%) Microsoft
2 47 (15.77%) SAP
3 39 (13.09%) Oracle
4 37 (12.42%) Tableau
5 28 (9.40%) IBM
6 20 (6.71%) Cognos
7 15 (5.03%) Netezza
8 14 (4.70%) Talend
9 7 (2.35%) RedGate
10 6 (2.01%) Informatica
10 6 (2.01%) Sybase
11 5 (1.68%) hybris
12 4 (1.34%) Progress
12 4 (1.34%) VMware
13 2 (0.67%) MicroStrategy
14 1 (0.34%) Capita
14 1 (0.34%) Logi Analytics
14 1 (0.34%) Lotus
14 1 (0.34%) Splunk
14 1 (0.34%) Xamarin