Period
to 23 July 2017

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

Extract, Transform and Load (ETL)
UK > Wales
6 months to
23 Jul 2017
Same period 2016 Same period 2015
Rank 72 84 90
Rank change year-on-year +12 +6 +29
Permanent jobs citing ETL 72 73 69
As % of all permanent IT jobs advertised in Wales 3.36% 2.72% 2.50%
As % of the Processes & Methodologies category 3.75% 3.25% 2.92%
Number of salaries quoted 47 57 59
Wales median annual salary £45,000 £40,000 £45,000
Median salary % change year-on-year +12.50% -11.11% +16.03%
10th Percentile £32,488 £29,600 £30,000
90th Percentile £56,250 £52,500 £48,750
UK median annual salary £50,000 £52,000 £52,500
% change year-on-year -3.85% -0.95% +5.00%

ETL is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Wales with a requirement for process and methodology skills.

Process & Methodology Skills
Wales
Permanent job vacancies with a requirement for process and methodology skills 1918 2245 2364
As % of all permanent IT job vacancies advertised in Wales 89.46% 83.52% 85.71%
Number of salaries quoted 1628 1901 1949
Wales median annual salary £40,000 £37,500 £37,000
Median salary % change year-on-year +6.67% +1.35% +5.71%
10th Percentile £24,000 £22,750 £23,750
90th Percentile £56,250 £53,750 £56,250
UK median annual salary £50,000 £48,000 £47,500
% change year-on-year +4.17% +1.05% +5.56%

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

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 23 July 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
South Wales -6 39 £40,000 - 1
Mid Wales +7 12 - -
West Wales -16 7 £37,500 -25.00%
North Wales - 1 £45,000 -
ETL
UK

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

1 62 (86.11%) SQL
2 45 (62.50%) Oracle
2 45 (62.50%) Oracle Reports
3 43 (59.72%) Finance
4 41 (56.94%) Analytical Skills
5 38 (52.78%) PL/SQL
5 38 (52.78%) Oracle Forms
6 25 (34.72%) SQL Server
7 21 (29.17%) Oracle Database
8 18 (25.00%) Microsoft
9 17 (23.61%) XML
9 17 (23.61%) Degree
10 16 (22.22%) SQL Server Integration Services
10 16 (22.22%) Data Integration
10 16 (22.22%) Business Intelligence
11 15 (20.83%) Enterprise Software
12 14 (19.44%) Oracle Database 11g
13 13 (18.06%) Computer Science
13 13 (18.06%) BizTalk Server
13 13 (18.06%) Web Services
14 12 (16.67%) SOAP
14 12 (16.67%) Management Information System
14 12 (16.67%) Business Process Improvement
14 12 (16.67%) REST
14 12 (16.67%) Continuous Improvement
14 12 (16.67%) Process Improvement
15 11 (15.28%) Data Analysis
15 11 (15.28%) Data Warehouse
15 11 (15.28%) .NET
15 11 (15.28%) SQL Server 2012

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 13 (18.06%) BizTalk Server
2 6 (8.33%) Oracle SOA Suite
3 2 (2.78%) SAS
3 2 (2.78%) SharePoint
4 1 (1.39%) Apache Pig
4 1 (1.39%) Apache Spark
Applications
1 3 (4.17%) Microsoft Office
2 1 (1.39%) Microsoft Excel
Business Applications
1 6 (8.33%) Oracle HRMS
1 6 (8.33%) Oracle Receivables
2 1 (1.39%) Dynamics CRM
Cloud Services
1 4 (5.56%) Microsoft Azure
2 1 (1.39%) Amazon AWS
Communications & Networking
1 1 (1.39%) FTP
Database & Business Intelligence
1 45 (62.50%) Oracle Reports
2 25 (34.72%) SQL Server
3 21 (29.17%) Oracle Database
4 16 (22.22%) SQL Server Integration Services
5 14 (19.44%) Oracle Database 11g
6 11 (15.28%) Data Warehouse
6 11 (15.28%) SQL Server 2012
7 10 (13.89%) SQL Server Reporting Services
8 8 (11.11%) SQL Server 2008
9 6 (8.33%) Relational Database
10 4 (5.56%) SQL Server 2005
10 4 (5.56%) SQL Server Analysis Services
11 3 (4.17%) Microsoft Analysis Services
11 3 (4.17%) Power BI
12 2 (2.78%) Amazon Redshift
12 2 (2.78%) Hadoop
12 2 (2.78%) QlikView
12 2 (2.78%) SQL Server 2014
12 2 (2.78%) SQL Server 2016
13 1 (1.39%) BusinessObjects
Development Applications
1 38 (52.78%) Oracle Forms
2 3 (4.17%) Visual Studio
3 1 (1.39%) Bitbucket
3 1 (1.39%) ERwin
3 1 (1.39%) Git (software)
3 1 (1.39%) Team Foundation Server
3 1 (1.39%) VSS/SourceSafe
General
1 43 (59.72%) Finance
2 9 (12.50%) Financial Institution
Job Titles
1 53 (73.61%) Developer
2 38 (52.78%) Oracle Developer
3 20 (27.78%) Senior Developer
4 16 (22.22%) SQL Developer
5 13 (18.06%) Senior Oracle Developer
6 10 (13.89%) Analyst
7 9 (12.50%) Senior SQL Developer
8 8 (11.11%) PL/SQL Developer
9 7 (9.72%) Administrator
10 6 (8.33%) BizTalk Administrator
10 6 (8.33%) Senior Analyst
10 6 (8.33%) Senior Solutions Analyst
10 6 (8.33%) Senior Systems Analyst
10 6 (8.33%) Solutions Analyst
10 6 (8.33%) Systems Analyst
11 4 (5.56%) Business Intelligence Developer
12 3 (4.17%) .NET Developer
12 3 (4.17%) VB.NET Developer
13 2 (2.78%) Integration Analyst
13 2 (2.78%) Senior PL/SQL Developer
Libraries, Frameworks & Software Standards
1 17 (23.61%) XML
2 13 (18.06%) Web Services
3 12 (16.67%) REST
3 12 (16.67%) SOAP
4 11 (15.28%) .NET
5 9 (12.50%) HTML
6 4 (5.56%) ASP.NET
6 4 (5.56%) ASP.NET Web Forms
6 4 (5.56%) WinForms
7 3 (4.17%) CSS
8 2 (2.78%) WCF
9 1 (1.39%) JSON
9 1 (1.39%) LINQ
9 1 (1.39%) WPF
9 1 (1.39%) XSLT
Miscellaneous
1 41 (56.94%) Analytical Skills
2 15 (20.83%) Enterprise Software
3 13 (18.06%) Computer Science
4 12 (16.67%) Management Information System
5 2 (2.78%) Data Structures
5 2 (2.78%) Fintech
6 1 (1.39%) Mobile Computing
Operating Systems
1 4 (5.56%) Windows
Processes & Methodologies
1 16 (22.22%) Business Intelligence
1 16 (22.22%) Data Integration
2 12 (16.67%) Business Process Improvement
2 12 (16.67%) Continuous Improvement
2 12 (16.67%) Process Improvement
3 11 (15.28%) Data Analysis
4 10 (13.89%) Performance Tuning
5 9 (12.50%) Analytics
5 9 (12.50%) Capacity Planning
6 8 (11.11%) Software Engineering
7 7 (9.72%) Data Governance
7 7 (9.72%) ITIL
7 7 (9.72%) Project Management
7 7 (9.72%) Visualisation
8 6 (8.33%) Business Process Modelling
8 6 (8.33%) ITSM
8 6 (8.33%) Migration
8 6 (8.33%) Service Management
8 6 (8.33%) SOA
8 6 (8.33%) Validation
Programming Languages
1 62 (86.11%) SQL
2 38 (52.78%) PL/SQL
3 9 (12.50%) VB.NET
4 7 (9.72%) C#
4 7 (9.72%) T-SQL
5 6 (8.33%) Java
5 6 (8.33%) PHP
6 4 (5.56%) JavaScript
7 3 (4.17%) Python
8 1 (1.39%) C
8 1 (1.39%) R
Qualifications
1 17 (23.61%) Degree
2 6 (8.33%) Postgraduate
3 3 (4.17%) MCP
3 3 (4.17%) Microsoft Certification
4 1 (1.39%) Computer Science Degree
Quality Assurance & Compliance
1 4 (5.56%) SLA
2 3 (4.17%) Data Quality
Vendors
1 45 (62.50%) Oracle
2 18 (25.00%) Microsoft
3 3 (4.17%) DevExpress
3 3 (4.17%) Tableau
4 1 (1.39%) Ab Initio
4 1 (1.39%) Informatica
4 1 (1.39%) MicroStrategy
4 1 (1.39%) Netezza
4 1 (1.39%) Teradata
Cardiff, South Glamorgan
IntaPeople
Salary: £30000 - £40000 per annum
Posted: 6 days ago