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 August 2016 with a comparison to the same period over the previous 2 years.

3 months to
24 Aug 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 59 64 44
Rank change year-on-year
+5 -20
Permanent jobs citing ETL 15 18 24
As % of all permanent IT jobs located in Cardiff 2.05% 2.14% 3.60%
As % of the Processes & Methodologies category 2.43% 2.58% 4.62%
Number of salaries quoted 14 12 24
Median salary £36,250 £43,490 £37,500
Median salary % change year-on-year
-16.64% +15.97%
90% offered a salary of more than £32,150 £22,150 £35,000
10% offered a salary of more than £40,000 £45,000 £45,000
UK excluding London median salary £45,000 £46,000 £45,000
% change year-on-year
-2.17% +2.22%
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
618 698 519
As % of all permanent IT jobs located in Cardiff 84.54% 83.00% 77.93%
Number of salaries quoted 548 578 465
Median salary £37,500 £37,500 £35,000
Median salary % change year-on-year
- +7.14%
90% offered a salary of more than £26,000 £27,500 £27,500
10% offered a salary of more than £53,250 £50,000 £55,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

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

For the 6 months to 24 August 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 33 (91.67%) SQL
2 27 (75.00%) SQL Server
3 22 (61.11%) Business Intelligence
4 21 (58.33%) SQL Server Integration Services
5 19 (52.78%) SQL Server Analysis Services
5 19 (52.78%) Data Warehouse
6 17 (47.22%) T-SQL
6 17 (47.22%) Agile Software Development
7 13 (36.11%) SQL Server Reporting Services
7 13 (36.11%) SQL Server 2012
8 12 (33.33%) MDX
8 12 (33.33%) Microsoft
8 12 (33.33%) OLAP
9 11 (30.56%) MS Excel
9 11 (30.56%) OLAP Cube
10 9 (25.00%) SDLC
11 7 (19.44%) Computer Science
11 7 (19.44%) Kimball Methodology
11 7 (19.44%) Scrum
11 7 (19.44%) Advertising
11 7 (19.44%) Visual Studio
11 7 (19.44%) Oracle
12 6 (16.67%) MySQL
12 6 (16.67%) Linux
12 6 (16.67%) Team Foundation Server
13 5 (13.89%) Analytical Skills
13 5 (13.89%) Software Engineering
13 5 (13.89%) Microsoft Azure
13 5 (13.89%) Unix
13 5 (13.89%) C++

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 11 (30.56%) MS Excel
Business Applications
1 2 (5.56%) Dynamics NAV
Cloud Services
1 5 (13.89%) Microsoft Azure
2 1 (2.78%) Amazon AWS
Communications & Networking
1 2 (5.56%) HTTP
1 2 (5.56%) TCP/IP
1 2 (5.56%) tcpdump
Database & Business Intelligence
1 27 (75.00%) SQL Server
2 21 (58.33%) SQL Server Integration Services
3 19 (52.78%) Data Warehouse
3 19 (52.78%) SQL Server Analysis Services
4 13 (36.11%) SQL Server 2012
4 13 (36.11%) SQL Server Reporting Services
5 12 (33.33%) OLAP
6 11 (30.56%) OLAP Cube
7 6 (16.67%) MySQL
8 4 (11.11%) Microsoft Analysis Services
8 4 (11.11%) Power BI
8 4 (11.11%) PowerPivot
8 4 (11.11%) QlikView
9 3 (8.33%) Relational Database
10 2 (5.56%) SAP BW
11 1 (2.78%) Big Data
11 1 (2.78%) Data Mining
11 1 (2.78%) Hadoop
11 1 (2.78%) RDBMS
11 1 (2.78%) Star Schema
Development Applications
1 7 (19.44%) Visual Studio
2 6 (16.67%) Team Foundation Server
General
1 7 (19.44%) Advertising
2 3 (8.33%) Finance
Job Titles
1 29 (80.56%) Developer
2 14 (38.89%) Database Developer
3 11 (30.56%) SQL Developer
4 9 (25.00%) Senior Developer
5 8 (22.22%) Senior Database Developer
6 6 (16.67%) Data Warehouse Developer
6 6 (16.67%) SQL Database Developer
6 6 (16.67%) SSAS Developer
6 6 (16.67%) SSIS Developer
6 6 (16.67%) SSRS Developer
7 5 (13.89%) SQL Server Developer
8 4 (11.11%) Business Intelligence Developer
8 4 (11.11%) Software Engineer
8 4 (11.11%) T-SQL Developer
9 3 (8.33%) C++ Software Engineer
10 2 (5.56%) DBA
10 2 (5.56%) Junior
10 2 (5.56%) Junior Developer
10 2 (5.56%) Junior SQL Developer
10 2 (5.56%) SQL DBA
Libraries, Frameworks & Software Standards
1 12 (33.33%) MDX
2 4 (11.11%) Web Services
3 3 (8.33%) REST
3 3 (8.33%) SOAP
3 3 (8.33%) WSDL
3 3 (8.33%) XML
4 1 (2.78%) jQuery
Miscellaneous
1 7 (19.44%) Computer Science
2 5 (13.89%) Analytical Skills
3 4 (11.11%) Data Integration
4 2 (5.56%) Data Structures
4 2 (5.56%) Visualisation
5 1 (2.78%) Data Protection Act
5 1 (2.78%) Grid Computing
5 1 (2.78%) iSeries
Operating Systems
1 6 (16.67%) Linux
2 5 (13.89%) Unix
3 1 (2.78%) Windows
Processes & Methodologies
1 22 (61.11%) Business Intelligence
2 17 (47.22%) Agile Software Development
3 9 (25.00%) SDLC
4 7 (19.44%) Kimball Methodology
4 7 (19.44%) Scrum
5 5 (13.89%) Software Engineering
6 4 (11.11%) Analytics
6 4 (11.11%) ETL Development
6 4 (11.11%) OO
6 4 (11.11%) TDD
7 3 (8.33%) Data Analysis
7 3 (8.33%) Data Cleansing
7 3 (8.33%) Data Modelling
7 3 (8.33%) Migration
8 2 (5.56%) CRM
8 2 (5.56%) Cybersecurity
8 2 (5.56%) Data Migration
8 2 (5.56%) Functional Programming
8 2 (5.56%) High Availability
8 2 (5.56%) Online Security
Programming Languages
1 33 (91.67%) SQL
2 17 (47.22%) T-SQL
3 5 (13.89%) C++
3 5 (13.89%) Java
4 4 (11.11%) C#
4 4 (11.11%) PHP
5 2 (5.56%) C
5 2 (5.56%) Erlang
5 2 (5.56%) Haskell
5 2 (5.56%) Lisp
5 2 (5.56%) Python
5 2 (5.56%) VB
6 1 (2.78%) JavaScript
6 1 (2.78%) PL/SQL
Qualifications
1 2 (5.56%) Degree
2 1 (2.78%) MCSA
2 1 (2.78%) MCSE
2 1 (2.78%) Microsoft Certification
Quality Assurance & Compliance
1 3 (8.33%) QA
2 2 (5.56%) Data Quality
System Software
1 2 (5.56%) Snort
Vendors
1 12 (33.33%) Microsoft
2 7 (19.44%) Oracle
3 4 (11.11%) Informatica
4 3 (8.33%) Sybase
4 3 (8.33%) Teradata
5 2 (5.56%) SAP
6 1 (2.78%) IBM
6 1 (2.78%) Zend