The following table provides summary statistics for contract job vacancies advertised in Cardiff with a requirement for ETL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ETL over the 3 months to 27 March 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

3 months to
27 Mar 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
South Wales / Cardiff
Rank 31 56 18
Rank change year-on-year +25 -38  
Contract jobs citing ETL 8 4 19
As % of all contract IT jobs advertised in Cardiff 2.41% 0.96% 7.45%
As % of the Processes & Methodologies category 2.79% 1.11% 9.41%
Number of daily rates quoted 6 4 15
Median daily rate £500 £338 £325
Median daily rate % change year-on-year +48.14% +3.84%  
90% offered a daily rate of more than £410 £255 £255
10% offered a daily rate of more than £506 £403 £395
UK excluding London median daily rate £400 £400 £400
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £37.50 - £40.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 contract job vacancies advertised in Cardiff with a requirement for process and methodology skills.

Contract Process & Methodology Skills
Cardiff
Contract job vacancies with a requirement for process and methodology skills 287 359 202
As % of all contract IT job vacancies advertised in Cardiff 86.45% 86.09% 79.22%
Number of daily rates quoted 237 257 150
Median daily rate £375 £375 £375
90% offered a daily rate of more than £190 £275 £215
10% offered a daily rate of more than £525 £450 £475
UK excluding London median daily rate £410 £400 £396
% change year-on-year +2.50% +1.01%  
Number of hourly rates quoted 8 11 11
Median hourly rate £32.50 £13.00 £16.75
Median hourly rate % change year-on-year +150.00% -22.38%  
90% offered a hourly rate of more than £15.25 £13.00 £12.30
10% offered a hourly rate of more than £35.00 £19.63 £32.50
UK excluding London median hourly rate £36.25 £38.50 £30.20
% change year-on-year -5.84% +27.48%  

ETL
Job Vacancy Trend in Cardiff

The job posting trend of jobs advertised in Cardiff citing ETL as a proportion of all contract or permanent IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for ETL in Cardiff

ETL
Contractor Daily Rate Trend in Cardiff

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL in Cardiff.

Contractor daily rate trend for ETL in Cardiff

ETL
Contractor Daily Rate Histogram in Cardiff

The daily rate distribution of IT jobs citing ETL in Cardiff over the 3 months to 27 March 2017.

Contractor daily rate histogram for ETL in Cardiff

ETL
Top 30 Related IT Skills in Cardiff

For the 6 months to 27 March 2017, IT contractor jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Cardiff region with a requirement for ETL.

1 25 (86.21%) Data Warehouse
2 22 (75.86%) SQL
3 19 (65.52%) SQL Server Integration Services
4 18 (62.07%) Teradata
4 18 (62.07%) Oracle
4 18 (62.07%) Informatica
5 13 (44.83%) Business Intelligence
5 13 (44.83%) Data Quality
6 12 (41.38%) SQL Server
7 10 (34.48%) PowerCenter
7 10 (34.48%) SQL Server Reporting Services
7 10 (34.48%) Data Analysis
7 10 (34.48%) Database Tuning
7 10 (34.48%) Oracle Database
7 10 (34.48%) ETL Development
8 9 (31.03%) Data Mapping
8 9 (31.03%) XML
9 8 (27.59%) Microsoft
9 8 (27.59%) Migration
9 8 (27.59%) Data Migration
9 8 (27.59%) Ab Initio
9 8 (27.59%) Tableau
10 7 (24.14%) Analytics
10 7 (24.14%) Data Architecture
10 7 (24.14%) Data Management
10 7 (24.14%) QlikView
10 7 (24.14%) ERwin
10 7 (24.14%) MicroStrategy
10 7 (24.14%) Quality Management
10 7 (24.14%) BusinessObjects

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:

Application Platforms
1 6 (20.69%) PowerExchange
1 6 (20.69%) SAS
2 1 (3.45%) Apache
2 1 (3.45%) Apache Spark
2 1 (3.45%) Luigi
Applications
1 1 (3.45%) MS Excel
Cloud Services
1 1 (3.45%) Amazon AWS
Database & Business Intelligence
1 25 (86.21%) Data Warehouse
2 19 (65.52%) SQL Server Integration Services
3 12 (41.38%) SQL Server
4 10 (34.48%) Oracle Database
4 10 (34.48%) PowerCenter
4 10 (34.48%) SQL Server Reporting Services
5 7 (24.14%) BusinessObjects
5 7 (24.14%) QlikView
6 6 (20.69%) Hadoop
7 3 (10.34%) SQL Server 2014
8 2 (6.90%) Enterprise Data Warehouse
8 2 (6.90%) SQL Server Analysis Services
9 1 (3.45%) Amazon Redshift
9 1 (3.45%) MySQL
9 1 (3.45%) PostgreSQL
9 1 (3.45%) SQL Server 2012
Development Applications
1 7 (24.14%) ERwin
2 6 (20.69%) SQL Server Management Studio (SSMS)
3 1 (3.45%) Talend Open Studio
3 1 (3.45%) Team Foundation Server
General
1 4 (13.79%) Advertising
2 3 (10.34%) Finance
3 1 (3.45%) Retail
Job Titles
1 10 (34.48%) Consultant
2 8 (27.59%) Architect
2 8 (27.59%) Developer
2 8 (27.59%) Informatica Consultant
3 7 (24.14%) Data Architect
4 6 (20.69%) Data Warehouse Developer
5 3 (10.34%) ETL Consultant
5 3 (10.34%) SQL Developer
6 2 (6.90%) DBA
6 2 (6.90%) ETL Developer
6 2 (6.90%) Oracle Consultant
6 2 (6.90%) SQL DBA
6 2 (6.90%) SSIS Developer
6 2 (6.90%) Teradata Architect
6 2 (6.90%) Teradata Consultant
7 1 (3.45%) Analyst
7 1 (3.45%) Service Analyst
7 1 (3.45%) SQL BI Developer
7 1 (3.45%) SQL Server Architect
7 1 (3.45%) XML Developer
Libraries, Frameworks & Software Standards
1 9 (31.03%) XML
2 6 (20.69%) XML Schema
2 6 (20.69%) XSD
Miscellaneous
1 3 (10.34%) iSeries
2 2 (6.90%) Computer Science
3 1 (3.45%) Analytical Skills
3 1 (3.45%) Fintech
3 1 (3.45%) NHS
Operating Systems
1 5 (17.24%) Linux
2 4 (13.79%) Windows
Processes & Methodologies
1 13 (44.83%) Business Intelligence
2 10 (34.48%) Data Analysis
2 10 (34.48%) Database Tuning
2 10 (34.48%) ETL Development
3 9 (31.03%) Data Mapping
4 8 (27.59%) Data Migration
4 8 (27.59%) Migration
5 7 (24.14%) Analytics
5 7 (24.14%) Data Architecture
5 7 (24.14%) Data Management
5 7 (24.14%) Quality Management
6 6 (20.69%) Change Data Capture
6 6 (20.69%) Data Analytics
6 6 (20.69%) Dimensional Modelling
7 5 (17.24%) Data Modelling
7 5 (17.24%) Technical Architecture
7 5 (17.24%) TOGAF
8 3 (10.34%) Translating Business Requirements
9 2 (6.90%) Informatics
10 1 (3.45%) Data Integration
Programming Languages
1 22 (75.86%) SQL
2 3 (10.34%) PowerShell
2 3 (10.34%) T-SQL
3 1 (3.45%) Bash Shell
3 1 (3.45%) Python
Qualifications
1 2 (6.90%) Degree
2 1 (3.45%) Security Cleared
Quality Assurance & Compliance
1 13 (44.83%) Data Quality
2 1 (3.45%) Disclosure Scotland
System Software
1 4 (13.79%) Oracle RAC
Vendors
1 18 (62.07%) Informatica
1 18 (62.07%) Oracle
1 18 (62.07%) Teradata
2 8 (27.59%) Ab Initio
2 8 (27.59%) Microsoft
2 8 (27.59%) Tableau
3 7 (24.14%) MicroStrategy
4 6 (20.69%) Netezza
5 1 (3.45%) Cognos
5 1 (3.45%) RedGate
5 1 (3.45%) SAP
5 1 (3.45%) Talend