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 29 June 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.

Extract, Transform and Load (ETL)
South Wales / Cardiff
3 months to
29 Jun 2017
Same period 2016 Same period 2015
Rank 30 34 24
Rank change year-on-year +4 -10  
Contract jobs citing ETL 13 4 19
As % of all contract IT jobs advertised in Cardiff 3.94% 1.44% 5.67%
As % of the Processes & Methodologies category 4.51% 1.85% 6.91%
Number of daily rates quoted 10 2 14
Median daily rate £325 £375 £325
Median daily rate % change year-on-year -13.33% +15.38%  
90% offered a daily rate of more than £313 £323 £260
10% offered a daily rate of more than £383 £428 £438
UK excluding London median daily rate £413 £400 £397
% change year-on-year +3.12% +0.75%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £55.00 £20.50 £31.50
% change year-on-year +168.29% -34.92%  

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 288 216 275
As % of all contract IT job vacancies advertised in Cardiff 87.27% 77.70% 82.09%
Number of daily rates quoted 933 647 699
Median daily rate £360 £388 £350
Median daily rate % change year-on-year -7.09% +10.71%  
90% offered a daily rate of more than £264 £248 £228
10% offered a daily rate of more than £524 £525 £455
UK excluding London median daily rate £415 £400 £380
% change year-on-year +3.75% +5.26%  
Number of hourly rates quoted 48 11 18
Median hourly rate £16.28 £13.50 £15.75
Median hourly rate % change year-on-year +20.59% -14.28%  
90% offered a hourly rate of more than £12.93 £12.75 £11.64
10% offered a hourly rate of more than £52.50 £37.50 £23.05
UK excluding London median hourly rate £33.50 £28.00 £30.00
% change year-on-year +19.64% -6.66%  

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
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

For the 6 months to 29 June 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 15 (71.43%) Data Warehouse
2 14 (66.67%) SQL
2 14 (66.67%) SQL Server
2 14 (66.67%) SQL Server Integration Services
3 13 (61.90%) Migration
3 13 (61.90%) Data Migration
4 10 (47.62%) Informatica
5 9 (42.86%) Oracle
5 9 (42.86%) Teradata
6 8 (38.10%) SQL Server Reporting Services
6 8 (38.10%) Data Modelling
6 8 (38.10%) Business Intelligence
6 8 (38.10%) Hadoop
7 7 (33.33%) Tableau
7 7 (33.33%) Data Quality
7 7 (33.33%) QlikView
7 7 (33.33%) Data Architecture
7 7 (33.33%) BusinessObjects
7 7 (33.33%) MicroStrategy
7 7 (33.33%) ERwin
7 7 (33.33%) Data Management
7 7 (33.33%) Ab Initio
7 7 (33.33%) Quality Management
8 6 (28.57%) Agile Software Development
8 6 (28.57%) Netezza
8 6 (28.57%) SAS
8 6 (28.57%) SQL Server 2008
8 6 (28.57%) Dimensional Modelling
8 6 (28.57%) Data Analytics
8 6 (28.57%) Analytics

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 6 (28.57%) SAS
2 2 (9.52%) Apache
2 2 (9.52%) Apache Spark
3 1 (4.76%) Elasticsearch
3 1 (4.76%) PowerExchange
Database & Business Intelligence
1 15 (71.43%) Data Warehouse
2 14 (66.67%) SQL Server
2 14 (66.67%) SQL Server Integration Services
3 8 (38.10%) Hadoop
3 8 (38.10%) SQL Server Reporting Services
4 7 (33.33%) BusinessObjects
4 7 (33.33%) QlikView
5 6 (28.57%) SQL Server 2008
6 4 (19.05%) Star Schema
7 2 (9.52%) Big Data
7 2 (9.52%) Enterprise Data Warehouse
7 2 (9.52%) HBase
8 1 (4.76%) Apache Hive
8 1 (4.76%) Impala
8 1 (4.76%) Oracle Database
8 1 (4.76%) Oracle Reports
8 1 (4.76%) Pentaho
8 1 (4.76%) PowerCenter
8 1 (4.76%) SQL Server 2012
8 1 (4.76%) SQL Server 2014
Development Applications
1 7 (33.33%) ERwin
2 2 (9.52%) Team Foundation Server
3 1 (4.76%) Bitbucket
3 1 (4.76%) Git (software)
3 1 (4.76%) Visual Studio
General
1 1 (4.76%) Telecoms
Job Titles
1 7 (33.33%) Architect
1 7 (33.33%) Data Architect
1 7 (33.33%) Developer
2 5 (23.81%) Data Warehouse Developer
2 5 (23.81%) SQL Developer
3 4 (19.05%) SSIS Developer
4 2 (9.52%) ETL Developer
4 2 (9.52%) Teradata Architect
4 2 (9.52%) Test Leader
4 2 (9.52%) T-SQL Developer
5 1 (4.76%) Business Intelligence Developer
5 1 (4.76%) Informatica Consultant
5 1 (4.76%) Informatica Developer
5 1 (4.76%) Lead Test Analyst
5 1 (4.76%) Senior Test Engineer
5 1 (4.76%) SQL DBA
5 1 (4.76%) SQL Server Developer
5 1 (4.76%) Team Leader
5 1 (4.76%) Test Engineer
5 1 (4.76%) Test Team Leader
Libraries, Frameworks & Software Standards
1 4 (19.05%) XML
2 2 (9.52%) JSON
2 2 (9.52%) Kafka
3 1 (4.76%) Middleware
Miscellaneous
1 1 (4.76%) Analytical Skills
1 1 (4.76%) Cyberthreat
1 1 (4.76%) Freedom of Information
1 1 (4.76%) NHS
Operating Systems
1 4 (19.05%) Linux
2 3 (14.29%) Windows
3 1 (4.76%) Windows Server
Processes & Methodologies
1 13 (61.90%) Data Migration
1 13 (61.90%) Migration
2 8 (38.10%) Business Intelligence
2 8 (38.10%) Data Modelling
3 7 (33.33%) Data Architecture
3 7 (33.33%) Data Management
3 7 (33.33%) Quality Management
4 6 (28.57%) Agile Software Development
4 6 (28.57%) Analytics
4 6 (28.57%) Data Analytics
4 6 (28.57%) Dimensional Modelling
5 5 (23.81%) Scrum
5 5 (23.81%) Technical Architecture
5 5 (23.81%) TOGAF
6 4 (19.05%) Dependency Management
6 4 (19.05%) ITIL
6 4 (19.05%) Kimball Methodology
6 4 (19.05%) Logical Data Model
6 4 (19.05%) Physical Data Model
6 4 (19.05%) SDLC
Programming Languages
1 14 (66.67%) SQL
2 5 (23.81%) T-SQL
3 3 (14.29%) PL/SQL
4 2 (9.52%) Java
5 1 (4.76%) Python
Qualifications
1 2 (9.52%) ISTQB
1 2 (9.52%) ISTQB Foundation Certification
1 2 (9.52%) Security Cleared
Quality Assurance & Compliance
1 7 (33.33%) Data Quality
2 1 (4.76%) Disclosure Scotland
2 1 (4.76%) QA
System Software
1 1 (4.76%) Apache Flume
1 1 (4.76%) Oracle RAC
Systems Management
1 1 (4.76%) Kibana
Vendors
1 10 (47.62%) Informatica
2 9 (42.86%) Oracle
2 9 (42.86%) Teradata
3 7 (33.33%) Ab Initio
3 7 (33.33%) MicroStrategy
3 7 (33.33%) Tableau
4 6 (28.57%) Netezza
5 1 (4.76%) Cloudera
5 1 (4.76%) RedGate