The table below looks at the statistics for ETL skills in IT jobs advertised for the Wales region. Included is a guide to the salaries offered in IT jobs that have cited ETL over the 3 months to 25 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
25 Jul 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 73 75 86
Rank change year-on-year
+2 +11
Permanent jobs citing ETL 33 29 18
As % of all permanent IT jobs located in Wales 2.47% 2.09% 1.36%
As % of the Processes & Methodologies category 2.97% 2.50% 1.70%
Number of salaries quoted 24 22 18
Median salary £38,750 £45,000 £41,980
Median salary % change year-on-year
-13.88% +7.19%
90% offered a salary of more than £32,150 £32,600 £27,500
10% offered a salary of more than £46,750 £45,000 £60,000
UK excluding London median salary £45,000 £46,500 £44,000
% change year-on-year
-3.22% +5.68%
ETL
UK

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Wales region.

Processes & Methodologies Category
Wales
Permanent IT job ads with a match in the
Processes & Methodologies category
1111 1162 1057
As % of all permanent IT jobs located in Wales 83.16% 83.90% 79.77%
Number of salaries quoted 945 942 918
Median salary £40,000 £37,500 £36,500
Median salary % change year-on-year
+6.66% +2.73%
90% offered a salary of more than £26,500 £27,500 £27,500
10% offered a salary of more than £55,000 £55,000 £55,000
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

ETL
Jobs Demand Trend in Wales

The demand trend of job ads across the Wales region citing ETL as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ETL Jobs Demand Trend in Wales

ETL
Salary Trend in Wales

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

ETL Salary Trend in Wales

ETL
Salary Histogram in Wales

This chart provides a salary histogram for IT jobs citing ETL across the Wales region over the 3 months to 25 July 2016.

ETL Salary Histogram 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 3 months to 25 July 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
South Wales +9 27 £37,500 -16.66% 2
Mid Wales - 4 - -
West Wales - 2 £50,000 -
ETL
UK

ETL
Top 30 Related IT Skills in Wales

For the 6 months to 25 July 2016, 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 69 (94.52%) SQL
2 50 (68.49%) SQL Server
3 43 (58.90%) Business Intelligence
4 40 (54.79%) SQL Server Integration Services
5 36 (49.32%) SQL Server Analysis Services
6 32 (43.84%) Data Warehouse
7 29 (39.73%) T-SQL
8 28 (38.36%) Agile Software Development
9 25 (34.25%) SQL Server 2012
10 24 (32.88%) SQL Server Reporting Services
11 22 (30.14%) Microsoft
12 20 (27.40%) MDX
13 19 (26.03%) OLAP
14 17 (23.29%) OLAP Cube
15 15 (20.55%) MySQL
16 14 (19.18%) Oracle
16 14 (19.18%) Data Modelling
16 14 (19.18%) SDLC
17 13 (17.81%) Data Analysis
17 13 (17.81%) Scrum
18 12 (16.44%) Advertising
18 12 (16.44%) MS Excel
18 12 (16.44%) Computer Science
18 12 (16.44%) Kimball Methodology
19 11 (15.07%) Microsoft Analysis Services
19 11 (15.07%) Linux
20 9 (12.33%) Power BI
20 9 (12.33%) Team Foundation Server
20 9 (12.33%) Migration
20 9 (12.33%) C

ETL
Top Related 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 4 (5.48%) SharePoint
Applications
1 12 (16.44%) MS Excel
Business Applications
1 2 (2.74%) Dynamics NAV
2 1 (1.37%) SAP Oil and Gas
Cloud Services
1 5 (6.85%) Microsoft Azure
2 1 (1.37%) Amazon AWS
2 1 (1.37%) SaaS
Communications & Networking
1 4 (5.48%) HTTP
1 4 (5.48%) TCP/IP
1 4 (5.48%) tcpdump
Database & Business Intelligence
1 50 (68.49%) SQL Server
2 40 (54.79%) SQL Server Integration Services
3 36 (49.32%) SQL Server Analysis Services
4 32 (43.84%) Data Warehouse
5 25 (34.25%) SQL Server 2012
6 24 (32.88%) SQL Server Reporting Services
7 19 (26.03%) OLAP
8 17 (23.29%) OLAP Cube
9 15 (20.55%) MySQL
10 11 (15.07%) Microsoft Analysis Services
11 9 (12.33%) Power BI
12 7 (9.59%) Big Data
12 7 (9.59%) PowerPivot
13 6 (8.22%) SQL Server 2008
14 5 (6.85%) Hadoop
14 5 (6.85%) QlikView
15 3 (4.11%) HPCC
15 3 (4.11%) Relational Database
15 3 (4.11%) SAP BW
16 2 (2.74%) Oracle Reports
Development Applications
1 9 (12.33%) Team Foundation Server
2 8 (10.96%) Visual Studio
3 2 (2.74%) Oracle Forms
4 1 (1.37%) Subversion
4 1 (1.37%) TortoiseSVN
General
1 12 (16.44%) Advertising
2 9 (12.33%) Finance
3 1 (1.37%) Manufacturing
3 1 (1.37%) Publishing
3 1 (1.37%) Telecoms
Job Titles
1 53 (72.60%) Developer
2 25 (34.25%) SQL Developer
3 21 (28.77%) Database Developer
4 16 (21.92%) Senior Developer
5 14 (19.18%) Senior Database Developer
6 11 (15.07%) SQL Database Developer
7 10 (13.70%) SQL Server Developer
7 10 (13.70%) SSAS Developer
8 9 (12.33%) Business Intelligence Developer
8 9 (12.33%) Data Warehouse Developer
8 9 (12.33%) DBA
8 9 (12.33%) SQL DBA
9 8 (10.96%) SSIS Developer
10 7 (9.59%) Oracle Developer
10 7 (9.59%) Software Engineer
11 6 (8.22%) SSRS Developer
11 6 (8.22%) T-SQL Developer
12 5 (6.85%) ETL Developer
12 5 (6.85%) Senior SQL Developer
12 5 (6.85%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 20 (27.40%) MDX
2 7 (9.59%) Web Services
3 4 (5.48%) REST
3 4 (5.48%) SOAP
3 4 (5.48%) WSDL
3 4 (5.48%) XML
4 3 (4.11%) jQuery
5 1 (1.37%) .NET
Miscellaneous
1 12 (16.44%) Computer Science
2 8 (10.96%) Data Integration
3 6 (8.22%) Analytical Skills
4 5 (6.85%) Mathematics
5 4 (5.48%) Enterprise Software
6 3 (4.11%) Data Structures
6 3 (4.11%) Grid Computing
6 3 (4.11%) Visualisation
7 2 (2.74%) Data Extraction
8 1 (1.37%) Data Protection Act
8 1 (1.37%) iSeries
8 1 (1.37%) Management Information System
Operating Systems
1 11 (15.07%) Linux
2 8 (10.96%) Unix
3 6 (8.22%) Windows
Processes & Methodologies
1 43 (58.90%) Business Intelligence
2 28 (38.36%) Agile Software Development
3 14 (19.18%) Data Modelling
3 14 (19.18%) SDLC
4 13 (17.81%) Data Analysis
4 13 (17.81%) Scrum
5 12 (16.44%) Kimball Methodology
6 9 (12.33%) Migration
7 8 (10.96%) Performance Tuning
7 8 (10.96%) Software Engineering
7 8 (10.96%) TDD
8 7 (9.59%) Analytics
8 7 (9.59%) OO
9 6 (8.22%) Validation
10 5 (6.85%) Complex ETL
10 5 (6.85%) Configuration Management
10 5 (6.85%) Data Cleansing
10 5 (6.85%) ETL Development
11 4 (5.48%) Cybersecurity
11 4 (5.48%) Functional Programming
Programming Languages
1 69 (94.52%) SQL
2 29 (39.73%) T-SQL
3 9 (12.33%) C
4 8 (10.96%) C++
4 8 (10.96%) Java
5 7 (9.59%) C#
5 7 (9.59%) PHP
5 7 (9.59%) PL/SQL
6 4 (5.48%) Erlang
6 4 (5.48%) Haskell
6 4 (5.48%) Lisp
6 4 (5.48%) Python
7 3 (4.11%) JavaScript
7 3 (4.11%) VB
8 1 (1.37%) VB.NET
Qualifications
1 4 (5.48%) Degree
1 4 (5.48%) MCSA
1 4 (5.48%) MCSE
1 4 (5.48%) Microsoft Certification
Quality Assurance & Compliance
1 5 (6.85%) Data Quality
2 3 (4.11%) QA
3 2 (2.74%) SLA
System Software
1 4 (5.48%) Snort
Vendors
1 22 (30.14%) Microsoft
2 14 (19.18%) Oracle
3 4 (5.48%) Informatica
3 4 (5.48%) Sybase
4 3 (4.11%) SAP
4 3 (4.11%) Teradata
4 3 (4.11%) Zend
5 1 (1.37%) IBM