Period
to 22 July 2019

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

Extract, Transform and Load (ETL)
UK > Wales
6 months to
22 Jul 2019
Same period 2018 Same period 2017
Rank 87 76 75
Rank change year-on-year -11 -1 +9
Permanent jobs citing ETL 32 57 73
As % of all permanent IT jobs advertised in Wales 1.81% 2.97% 3.38%
As % of the Processes & Methodologies category 1.99% 3.20% 3.66%
Number of salaries quoted 28 34 48
Wales median annual salary £40,750 £42,000 £45,000
Median salary % change year-on-year -2.98% -6.67% +12.50%
10th Percentile £30,800 £30,375 £32,491
90th Percentile £51,575 £67,257 £56,250
UK median annual salary £53,500 £52,500 £50,000
% change year-on-year +1.90% +5.00% -3.85%

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

All Process and Methodology Skills
Wales
Permanent vacancies with a requirement for process or methodology skills 1,608 1,784 1,997
As % of all permanent IT jobs advertised in Wales 91.00% 93.06% 92.41%
Number of salaries quoted 1,395 1,457 1,700
Wales median annual salary £40,000 £40,000 £40,000
10th Percentile £26,250 £25,000 £24,000
90th Percentile £58,750 £60,000 £56,250
UK median annual salary £52,500 £50,000 £49,000
% change year-on-year +5.00% +2.04% +3.16%

ETL
Job Vacancy Trend in Wales

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

Job vacancy trend for ETL in Wales

ETL
Salary Trend in Wales

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

Salary trend for ETL in Wales

ETL
Salary Histogram in Wales

The salary distribution of IT jobs citing ETL in Wales over the 6 months to 22 July 2019.

Salary histogram for ETL in Wales

ETL
Job Locations in Wales

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Wales region over the 6 months to 22 July 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
South Wales -3 32 £40,750 +1.88% 11
ETL
UK

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

1 25 (78.13%) Business Intelligence
2 23 (71.88%) Data Warehouse
3 21 (65.63%) SQL
4 18 (56.25%) SQL Server Integration Services
5 15 (46.88%) Power BI
5 15 (46.88%) Power Platform
6 13 (40.63%) SQL Server Reporting Services
6 13 (40.63%) SQL Server
7 12 (37.50%) T-SQL
7 12 (37.50%) Microsoft
7 12 (37.50%) Agile Software Development
8 11 (34.38%) Microsoft Azure
9 8 (25.00%) Degree
9 8 (25.00%) BusinessObjects
10 7 (21.88%) Data Modelling
10 7 (21.88%) Data Integration
10 7 (21.88%) Analytics
11 6 (18.75%) SQL Server Analysis Services
11 6 (18.75%) SAS
11 6 (18.75%) Oracle
12 5 (15.63%) Telecoms
12 5 (15.63%) Oracle Reports
12 5 (15.63%) Test Automation
12 5 (15.63%) Visualisation
12 5 (15.63%) Data Quality
12 5 (15.63%) Unit Testing
12 5 (15.63%) Banking
12 5 (15.63%) SAS Data Integration Studio
13 4 (12.50%) Oracle ODI
13 4 (12.50%) Feasibility Study

ETL
Co-occurring IT Skills in Wales 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 6 (18.75%) SAS
2 1 (3.13%) CMS
Applications
1 3 (9.38%) Microsoft Excel
2 2 (6.25%) Microsoft Office
Business Applications
1 1 (3.13%) Dynamics CRM
Cloud Services
1 15 (46.88%) Power Platform
2 11 (34.38%) Microsoft Azure
3 2 (6.25%) Amazon AWS
3 2 (6.25%) Office 365
3 2 (6.25%) SaaS
Communications & Networking
1 2 (6.25%) HTTP
1 2 (6.25%) HTTPS
Database & Business Intelligence
1 23 (71.88%) Data Warehouse
2 18 (56.25%) SQL Server Integration Services
3 15 (46.88%) Power BI
4 13 (40.63%) SQL Server
4 13 (40.63%) SQL Server Reporting Services
5 8 (25.00%) BusinessObjects
6 6 (18.75%) SQL Server Analysis Services
7 5 (15.63%) Oracle Reports
7 5 (15.63%) SAS Data Integration Studio
8 4 (12.50%) Crystal Reports
8 4 (12.50%) Oracle ODI
8 4 (12.50%) QlikView
9 3 (9.38%) Azure SQL Database
9 3 (9.38%) Relational Database
9 3 (9.38%) SAS EBI
10 2 (6.25%) DB2
10 2 (6.25%) OLAP
10 2 (6.25%) OLAP Cube
10 2 (6.25%) PowerPivot
11 1 (3.13%) MySQL
Development Applications
1 4 (12.50%) Visual Studio
2 3 (9.38%) Team Foundation Server
2 3 (9.38%) Visual Studio Team System
3 2 (6.25%) SQL Server Management Studio (SSMS)
4 1 (3.13%) Git (software)
4 1 (3.13%) Selenium
General
1 5 (15.63%) Banking
1 5 (15.63%) Telecoms
2 3 (9.38%) Finance
3 1 (3.13%) Back Office
3 1 (3.13%) Retail
Job Titles
1 21 (65.63%) Developer
2 13 (40.63%) Business Intelligence Developer
3 8 (25.00%) Analyst
4 7 (21.88%) Data Warehouse Developer
5 4 (12.50%) Analyst Developer
5 4 (12.50%) Analyst Programmer
5 4 (12.50%) Business Developer
5 4 (12.50%) Data Warehouse Analyst
5 4 (12.50%) Developer Analyst
5 4 (12.50%) Programmer
5 4 (12.50%) Senior Analyst
5 4 (12.50%) Senior Analyst Programmer
5 4 (12.50%) Senior Data Warehouse Analyst
5 4 (12.50%) Senior Data Warehouse Developer
5 4 (12.50%) Senior Developer
5 4 (12.50%) Senior Programmer
6 3 (9.38%) Automation Engineer
6 3 (9.38%) Data Analyst
6 3 (9.38%) Data Quality Analyst
6 3 (9.38%) Quality Analyst
Libraries, Frameworks & Software Standards
1 3 (9.38%) HTML
1 3 (9.38%) XML
2 2 (6.25%) jQuery
2 2 (6.25%) JSON
3 1 (3.13%) Web Services
Miscellaneous
1 2 (6.25%) Analytical Skills
2 1 (3.13%) Clustering
Operating Systems
1 1 (3.13%) Linux
1 1 (3.13%) Unix
Processes & Methodologies
1 25 (78.13%) Business Intelligence
2 12 (37.50%) Agile Software Development
3 7 (21.88%) Analytics
3 7 (21.88%) Data Integration
3 7 (21.88%) Data Modelling
4 5 (15.63%) Test Automation
4 5 (15.63%) Unit Testing
4 5 (15.63%) Visualisation
5 4 (12.50%) Decision-Making
5 4 (12.50%) ETL Development
5 4 (12.50%) Feasibility Study
5 4 (12.50%) Regression Testing
5 4 (12.50%) Test Scripting
6 3 (9.38%) Data Governance
6 3 (9.38%) Data Visualisation
6 3 (9.38%) DevOps
6 3 (9.38%) Kimball Methodology
6 3 (9.38%) SDLC
7 2 (6.25%) Continuous Integration
7 2 (6.25%) Data Management
Programming Languages
1 21 (65.63%) SQL
2 12 (37.50%) T-SQL
3 4 (12.50%) C#
3 4 (12.50%) VBA
4 3 (9.38%) Data Analysis Expressions (DAX)
5 2 (6.25%) JavaScript
5 2 (6.25%) PowerShell
6 1 (3.13%) Java
6 1 (3.13%) PHP
Qualifications
1 8 (25.00%) Degree
2 1 (3.13%) Microsoft Certification
2 1 (3.13%) SC Cleared
2 1 (3.13%) Security Cleared
Quality Assurance & Compliance
1 5 (15.63%) Data Quality
2 2 (6.25%) QA
3 1 (3.13%) SLA
Systems Management
1 4 (12.50%) Control-M
Vendors
1 12 (37.50%) Microsoft
2 6 (18.75%) Oracle
3 4 (12.50%) Informatica
3 4 (12.50%) MicroStrategy
3 4 (12.50%) Talend
3 4 (12.50%) Teradata
4 2 (6.25%) Google
4 2 (6.25%) Salesforce.com
4 2 (6.25%) Tableau
5 1 (3.13%) Avaya
5 1 (3.13%) Jaspersoft
5 1 (3.13%) VMware