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

3 months to
24 Jul 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 48 58 55
Rank change year-on-year
+10 -3
Permanent jobs citing ETL 22 23 14
As % of all permanent IT jobs located in Cardiff 3.09% 2.83% 2.11%
As % of the Processes & Methodologies category 3.78% 3.38% 2.70%
Number of salaries quoted 18 17 14
Median salary £36,250 £45,000 £42,240
Median salary % change year-on-year
-19.44% +6.53%
90% offered a salary of more than £32,350 £28,500 £35,750
10% offered a salary of more than £40,000 £45,000 £45,000
UK excluding London median salary £45,000 £46,500 £44,000
% change year-on-year
-3.22% +5.68%
ETL
South Wales

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

Processes & Methodologies Category
Cardiff
Permanent IT job ads with a match in the
Processes & Methodologies category
582 681 519
As % of all permanent IT jobs located in Cardiff 81.86% 83.76% 78.28%
Number of salaries quoted 511 543 456
Median salary £40,000 £37,500 £37,500
Median salary % change year-on-year
+6.66% -
90% offered a salary of more than £26,500 £27,154 £27,500
10% offered a salary of more than £52,500 £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 Cardiff

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

ETL Jobs Demand Trend in Cardiff

ETL
Salary Trend in Cardiff

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

ETL Salary Trend in Cardiff

ETL
Salary Histogram in Cardiff

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

ETL Salary Histogram in Cardiff

ETL
Top 30 Related IT Skills in Cardiff

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

1 43 (93.48%) SQL
2 33 (71.74%) SQL Server
3 24 (52.17%) Business Intelligence
4 23 (50.00%) SQL Server Integration Services
5 21 (45.65%) Data Warehouse
6 20 (43.48%) Agile Software Development
7 19 (41.30%) SQL Server Analysis Services
8 17 (36.96%) T-SQL
9 16 (34.78%) SQL Server 2012
10 14 (30.43%) SQL Server Reporting Services
10 14 (30.43%) MDX
10 14 (30.43%) SDLC
11 13 (28.26%) Microsoft
11 13 (28.26%) OLAP
12 12 (26.09%) MS Excel
12 12 (26.09%) Computer Science
12 12 (26.09%) OLAP Cube
13 11 (23.91%) Linux
13 11 (23.91%) MySQL
14 10 (21.74%) Scrum
15 8 (17.39%) Software Engineering
15 8 (17.39%) Kimball Methodology
15 8 (17.39%) Oracle
15 8 (17.39%) C++
15 8 (17.39%) Java
15 8 (17.39%) Unix
16 7 (15.22%) Web Services
16 7 (15.22%) OO
16 7 (15.22%) PHP
16 7 (15.22%) Visual Studio

ETL
Top Related IT Skills in Cardiff 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:

Applications
1 12 (26.09%) MS Excel
Business Applications
1 1 (2.17%) Dynamics NAV
Cloud Services
1 4 (8.70%) Microsoft Azure
2 1 (2.17%) Amazon AWS
Communications & Networking
1 4 (8.70%) HTTP
1 4 (8.70%) TCP/IP
1 4 (8.70%) tcpdump
Database & Business Intelligence
1 33 (71.74%) SQL Server
2 23 (50.00%) SQL Server Integration Services
3 21 (45.65%) Data Warehouse
4 19 (41.30%) SQL Server Analysis Services
5 16 (34.78%) SQL Server 2012
6 14 (30.43%) SQL Server Reporting Services
7 13 (28.26%) OLAP
8 12 (26.09%) OLAP Cube
9 11 (23.91%) MySQL
10 5 (10.87%) Microsoft Analysis Services
10 5 (10.87%) Power BI
10 5 (10.87%) PowerPivot
11 3 (6.52%) Big Data
11 3 (6.52%) HPCC
11 3 (6.52%) QlikView
11 3 (6.52%) Relational Database
12 2 (4.35%) SAP BW
13 1 (2.17%) Data Mining
13 1 (2.17%) RDBMS
13 1 (2.17%) Star Schema
Development Applications
1 7 (15.22%) Visual Studio
2 6 (13.04%) Team Foundation Server
General
1 6 (13.04%) Advertising
2 5 (10.87%) Finance
Job Titles
1 34 (73.91%) Developer
2 17 (36.96%) Database Developer
3 13 (28.26%) SQL Developer
4 10 (21.74%) Senior Database Developer
4 10 (21.74%) Senior Developer
5 7 (15.22%) Data Warehouse Developer
5 7 (15.22%) Software Engineer
5 7 (15.22%) SQL Database Developer
6 6 (13.04%) SQL Server Developer
6 6 (13.04%) SSAS Developer
6 6 (13.04%) SSIS Developer
6 6 (13.04%) SSRS Developer
7 4 (8.70%) C++ Software Engineer
7 4 (8.70%) DBA
7 4 (8.70%) SQL DBA
7 4 (8.70%) T-SQL Developer
8 3 (6.52%) Junior
8 3 (6.52%) Junior Developer
8 3 (6.52%) PHP Developer
8 3 (6.52%) Security Engineer
Libraries, Frameworks & Software Standards
1 14 (30.43%) MDX
2 7 (15.22%) Web Services
3 4 (8.70%) REST
3 4 (8.70%) SOAP
3 4 (8.70%) WSDL
3 4 (8.70%) XML
4 3 (6.52%) jQuery
5 1 (2.17%) .NET
Miscellaneous
1 12 (26.09%) Computer Science
2 6 (13.04%) Analytical Skills
3 4 (8.70%) Data Integration
4 3 (6.52%) Grid Computing
5 2 (4.35%) Data Structures
5 2 (4.35%) Visualisation
6 1 (2.17%) Data Protection Act
6 1 (2.17%) iSeries
6 1 (2.17%) Management Information System
Operating Systems
1 11 (23.91%) Linux
2 8 (17.39%) Unix
3 1 (2.17%) Windows
Processes & Methodologies
1 24 (52.17%) Business Intelligence
2 20 (43.48%) Agile Software Development
3 14 (30.43%) SDLC
4 10 (21.74%) Scrum
5 8 (17.39%) Kimball Methodology
5 8 (17.39%) Software Engineering
6 7 (15.22%) OO
7 6 (13.04%) Data Analysis
8 5 (10.87%) Analytics
8 5 (10.87%) Data Cleansing
9 4 (8.70%) Cybersecurity
9 4 (8.70%) Data Modelling
9 4 (8.70%) ETL Development
9 4 (8.70%) Functional Programming
9 4 (8.70%) Migration
9 4 (8.70%) Online Security
9 4 (8.70%) TDD
10 3 (6.52%) MVC
10 3 (6.52%) Performance Tuning
10 3 (6.52%) Systems Analysis
Programming Languages
1 43 (93.48%) SQL
2 17 (36.96%) T-SQL
3 8 (17.39%) C++
3 8 (17.39%) Java
4 7 (15.22%) PHP
5 5 (10.87%) C#
6 4 (8.70%) C
6 4 (8.70%) Erlang
6 4 (8.70%) Haskell
6 4 (8.70%) Lisp
6 4 (8.70%) Python
7 3 (6.52%) JavaScript
8 2 (4.35%) VB
9 1 (2.17%) PL/SQL
9 1 (2.17%) VB.NET
Qualifications
1 3 (6.52%) Degree
2 2 (4.35%) MCSA
2 2 (4.35%) MCSE
2 2 (4.35%) Microsoft Certification
Quality Assurance & Compliance
1 3 (6.52%) Data Quality
1 3 (6.52%) QA
System Software
1 4 (8.70%) Snort
Vendors
1 13 (28.26%) Microsoft
2 8 (17.39%) Oracle
3 4 (8.70%) Informatica
3 4 (8.70%) Sybase
4 3 (6.52%) Teradata
4 3 (6.52%) Zend
5 2 (4.35%) SAP
6 1 (2.17%) IBM