Period
to 14 December 2018

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

Extract, Transform and Load (ETL)
South Wales > Cardiff
6 months to
14 Dec 2018
Same period 2017 Same period 2016
Rank 71 62 74
Rank change year-on-year -9 +12 +11
Permanent jobs citing ETL 20 21 35
As % of all permanent IT jobs advertised in Cardiff 1.80% 2.59% 2.61%
As % of the Processes & Methodologies category 2.10% 2.73% 2.84%
Number of salaries quoted 18 19 33
Cardiff median annual salary £35,000 £35,000 £36,000
Median salary % change year-on-year - -2.78% -20.00%
10th Percentile £23,500 £32,250 £31,000
90th Percentile £42,725 £54,250 £55,500
South Wales median annual salary £37,500 £37,500 £36,000
% change year-on-year - +4.17% -20.00%

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

All Process and Methodology Skills
Cardiff
Permanent vacancies with a requirement for process or methodology skills 951 769 1,234
As % of all permanent IT jobs advertised in Cardiff 85.75% 94.70% 91.95%
Number of salaries quoted 783 687 1,121
Cardiff median annual salary £40,000 £38,000 £36,000
Median salary % change year-on-year +5.26% +5.56% +2.86%
10th Percentile £25,500 £24,250 £22,500
90th Percentile £65,000 £55,000 £55,000
South Wales median annual salary £40,000 £38,500 £37,500
% change year-on-year +3.90% +2.67% +4.17%

ETL
Job Vacancy Trend in Cardiff

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

Job vacancy trend for ETL in Cardiff

ETL
Salary Trend in Cardiff

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

Salary trend for ETL in Cardiff

ETL
Salary Histogram in Cardiff

The salary distribution of IT jobs citing ETL in Cardiff over the 6 months to 14 December 2018.

Salary histogram for ETL in Cardiff

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

1 18 (90.00%) Business Intelligence
2 17 (85.00%) SQL
3 14 (70.00%) ETL Development
4 13 (65.00%) Power BI
4 13 (65.00%) Data Warehouse
5 11 (55.00%) SQL Server
5 11 (55.00%) SQL Server Reporting Services
5 11 (55.00%) SQL Server Integration Services
5 11 (55.00%) Analytics
6 10 (50.00%) Data Analysis Expressions (DAX)
6 10 (50.00%) BusinessObjects
6 10 (50.00%) Data Integration
6 10 (50.00%) Finance
7 9 (45.00%) Microsoft
8 8 (40.00%) Visualisation
8 8 (40.00%) Agile Software Development
9 7 (35.00%) Microsoft Azure
9 7 (35.00%) Kimball Methodology
10 6 (30.00%) Amazon AWS
10 6 (30.00%) Oracle
10 6 (30.00%) T-SQL
11 5 (25.00%) VBA
11 5 (25.00%) HTML
11 5 (25.00%) JavaScript
11 5 (25.00%) DB2
11 5 (25.00%) Data Modelling
11 5 (25.00%) SAS
11 5 (25.00%) HTTP
11 5 (25.00%) XML
11 5 (25.00%) HTTPS

ETL
Co-occurring 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:

Application Platforms
1 5 (25.00%) SAS
2 1 (5.00%) Apache Spark
2 1 (5.00%) Elasticsearch
Applications
1 2 (10.00%) Microsoft Excel
Cloud Services
1 7 (35.00%) Microsoft Azure
2 6 (30.00%) Amazon AWS
3 5 (25.00%) Office 365
3 5 (25.00%) SaaS
Communications & Networking
1 5 (25.00%) HTTP
1 5 (25.00%) HTTPS
2 1 (5.00%) Kerberos
Database & Business Intelligence
1 13 (65.00%) Data Warehouse
1 13 (65.00%) Power BI
2 11 (55.00%) SQL Server
2 11 (55.00%) SQL Server Integration Services
2 11 (55.00%) SQL Server Reporting Services
3 10 (50.00%) BusinessObjects
4 5 (25.00%) BusinessObjects Web Intelligence
4 5 (25.00%) DB2
4 5 (25.00%) PowerPivot
4 5 (25.00%) Relational Database
4 5 (25.00%) SAS EBI
4 5 (25.00%) SQL Server Analysis Services
5 2 (10.00%) Big Data
6 1 (5.00%) Hadoop
6 1 (5.00%) HBase
6 1 (5.00%) OLAP
6 1 (5.00%) OLAP Cube
6 1 (5.00%) Oracle Reports
6 1 (5.00%) Pentaho
6 1 (5.00%) SQL Server 2014
Development Applications
1 1 (5.00%) Git (software)
1 1 (5.00%) Jenkins
1 1 (5.00%) Oracle Forms
1 1 (5.00%) Team Foundation Server
1 1 (5.00%) Visual Studio
General
1 10 (50.00%) Finance
2 1 (5.00%) Advertising
2 1 (5.00%) Telecoms
Job Titles
1 11 (55.00%) Developer
2 10 (50.00%) Business Intelligence Developer
3 8 (40.00%) Analyst
4 7 (35.00%) Business Intelligence Analyst
5 6 (30.00%) SQL BI Developer
5 6 (30.00%) SQL Developer
6 5 (25.00%) Report Analyst
7 4 (20.00%) ETL Developer
8 3 (15.00%) Business Developer
8 3 (15.00%) Data Warehouse Developer
8 3 (15.00%) SQL Server BI Developer
8 3 (15.00%) SQL Server Developer
8 3 (15.00%) SSIS Developer
9 2 (10.00%) Business Data Analyst
9 2 (10.00%) Business Intelligence Data Analyst
9 2 (10.00%) Data Analyst
9 2 (10.00%) SQL Analyst
10 1 (5.00%) Oracle Developer
10 1 (5.00%) SQL Data Analyst
10 1 (5.00%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 5 (25.00%) HTML
1 5 (25.00%) jQuery
1 5 (25.00%) JSON
1 5 (25.00%) XML
2 1 (5.00%) LDAP
Miscellaneous
1 1 (5.00%) Analytical Skills
Operating Systems
1 1 (5.00%) Linux
1 1 (5.00%) Windows
Processes & Methodologies
1 18 (90.00%) Business Intelligence
2 14 (70.00%) ETL Development
3 11 (55.00%) Analytics
4 10 (50.00%) Data Integration
5 8 (40.00%) Agile Software Development
5 8 (40.00%) Visualisation
6 7 (35.00%) Kimball Methodology
7 5 (25.00%) Data Modelling
7 5 (25.00%) Scrum
8 3 (15.00%) Data Visualisation
8 3 (15.00%) Decision-Making
9 2 (10.00%) Business Analytics
10 1 (5.00%) Continuous Improvement
10 1 (5.00%) Continuous Integration
10 1 (5.00%) Cybersecurity
10 1 (5.00%) Data Cleansing
10 1 (5.00%) Infrastructure Engineering
Programming Languages
1 17 (85.00%) SQL
2 10 (50.00%) Data Analysis Expressions (DAX)
3 6 (30.00%) T-SQL
4 5 (25.00%) JavaScript
4 5 (25.00%) VBA
5 1 (5.00%) C#
5 1 (5.00%) PL/SQL
5 1 (5.00%) Python
Qualifications
1 5 (25.00%) Degree
2 1 (5.00%) Security Cleared
Quality Assurance & Compliance
1 5 (25.00%) Data Quality
2 1 (5.00%) QA
2 1 (5.00%) SLA
System Software
1 1 (5.00%) Apache Flume
Systems Management
1 1 (5.00%) Puppet
Vendors
1 9 (45.00%) Microsoft
2 6 (30.00%) Oracle
3 5 (25.00%) Google
4 2 (10.00%) Tableau
5 1 (5.00%) Cloudera