The following table provides summary statistics for contract job vacancies advertised in Edinburgh 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 30 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.

Extract, Transform and Load (ETL)
Scotland / Edinburgh
3 months to
30 Mar 2017
Same period 2016 Same period 2015
Rank 48 36 39
Rank change year-on-year -12 +3  
Contract jobs citing ETL 25 63 49
As % of all contract IT jobs advertised in Edinburgh 2.71% 4.15% 3.38%
As % of the Processes & Methodologies category 3.21% 5.02% 4.12%
Number of daily rates quoted 17 50 34
Median daily rate £475 £413 £388
Median daily rate % change year-on-year +15.15% +6.45%  
90% offered a daily rate of more than £350 £324 £267
10% offered a daily rate of more than £500 £455 £500
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 Edinburgh with a requirement for process and methodology skills.

Contract Process & Methodology Skills
Edinburgh
Contract job vacancies with a requirement for process and methodology skills 780 1256 1188
As % of all contract IT job vacancies advertised in Edinburgh 84.69% 82.74% 81.93%
Number of daily rates quoted 503 706 673
Median daily rate £400 £413 £400
Median daily rate % change year-on-year -3.03% +3.12%  
90% offered a daily rate of more than £275 £294 £275
10% offered a daily rate of more than £500 £575 £500
UK excluding London median daily rate £410 £400 £396
% change year-on-year +2.50% +1.01%  
Number of hourly rates quoted 9 6 13
Median hourly rate £15.18 £39.00 £37.50
Median hourly rate % change year-on-year -61.07% +4.00%  
90% offered a hourly rate of more than £11.78 £17.75 £14.00
10% offered a hourly rate of more than £33.12 £40.00 £47.50
UK excluding London median hourly rate £35.75 £38.00 £30.00
% change year-on-year -5.92% +26.66%  

ETL
Job Vacancy Trend in Edinburgh

The job posting trend of jobs advertised in Edinburgh 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 Edinburgh

ETL
Contractor Daily Rate Trend in Edinburgh

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

Contractor daily rate trend for ETL in Edinburgh

ETL
Contractor Daily Rate Histogram in Edinburgh

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

Contractor daily rate histogram for ETL in Edinburgh

ETL
Contractor Hourly Rate Trend in Edinburgh

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ETL in Edinburgh.

Contractor hourly rate trend for ETL in Edinburgh

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

1 27 (69.23%) Data Warehouse
2 20 (51.28%) SQL
3 16 (41.03%) Oracle
4 13 (33.33%) Banking
5 12 (30.77%) Data Modelling
6 11 (28.21%) Finance
7 9 (23.08%) Data Architecture
7 9 (23.08%) SAS
7 9 (23.08%) SQL Server
7 9 (23.08%) Cloudera
8 8 (20.51%) Retail
8 8 (20.51%) Agile Software Development
9 7 (17.95%) Data Analysis
9 7 (17.95%) Retail Banking
9 7 (17.95%) Business Intelligence
9 7 (17.95%) Migration
9 7 (17.95%) Teradata
9 7 (17.95%) Hadoop
10 6 (15.38%) Big Data
10 6 (15.38%) Analytics
10 6 (15.38%) PL/SQL
10 6 (15.38%) Data Management
11 5 (12.82%) Amazon AWS
11 5 (12.82%) Microsoft
11 5 (12.82%) Tableau
11 5 (12.82%) Visualisation
11 5 (12.82%) Data Structures
11 5 (12.82%) ETL Development
12 4 (10.26%) Oracle Database
12 4 (10.26%) Disclosure Scotland

ETL
Co-occurring IT Skills in Edinburgh 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 9 (23.08%) SAS
2 3 (7.69%) Apache Spark
2 3 (7.69%) Oracle Spatial
3 2 (5.13%) Apache Airflow
3 2 (5.13%) SharePoint
Applications
1 1 (2.56%) MS Project
1 1 (2.56%) Spreadsheet
Business Applications
1 2 (5.13%) thinkFolio
2 1 (2.56%) Oracle EBS
Cloud Services
1 5 (12.82%) Amazon AWS
2 2 (5.13%) Amazon S3
Database & Business Intelligence
1 27 (69.23%) Data Warehouse
2 9 (23.08%) SQL Server
3 7 (17.95%) Hadoop
4 6 (15.38%) Big Data
5 4 (10.26%) Enterprise Data Warehouse
5 4 (10.26%) Oracle Database
5 4 (10.26%) SQL Server Integration Services
6 3 (7.69%) Apache Cassandra
6 3 (7.69%) BusinessObjects
6 3 (7.69%) Data Lake
6 3 (7.69%) HBase
6 3 (7.69%) OLAP
6 3 (7.69%) Oracle Database 11g
6 3 (7.69%) Pentaho
6 3 (7.69%) QlikView
6 3 (7.69%) Relational Database
7 2 (5.13%) Apache Hive
7 2 (5.13%) Geospatial Data
7 2 (5.13%) SAP Data Services
7 2 (5.13%) SQL Server 2012
Development Applications
1 2 (5.13%) ERwin
2 1 (2.56%) Cucumber
2 1 (2.56%) Oracle Forms
2 1 (2.56%) Selenium
2 1 (2.56%) Subversion
2 1 (2.56%) Talend Open Studio
2 1 (2.56%) TortoiseSVN
General
1 13 (33.33%) Banking
2 11 (28.21%) Finance
3 8 (20.51%) Retail
4 7 (17.95%) Retail Banking
5 1 (2.56%) Legal
Job Titles
1 12 (30.77%) Analyst
2 11 (28.21%) Developer
3 10 (25.64%) Data Analyst
4 6 (15.38%) Architect
5 5 (12.82%) Data Architect
6 4 (10.26%) Designer
6 4 (10.26%) ETL Developer
6 4 (10.26%) Solutions Designer
6 4 (10.26%) SQL Developer
7 3 (7.69%) Business Intelligence Developer
7 3 (7.69%) Data Modeller
7 3 (7.69%) Oracle Developer
7 3 (7.69%) Solutions Architect
7 3 (7.69%) SSIS Developer
8 2 (5.13%) Consultant
8 2 (5.13%) Database Developer
8 2 (5.13%) Oracle Database Developer
8 2 (5.13%) Senior Analyst
8 2 (5.13%) Senior Data Analyst
8 2 (5.13%) Systems Analyst
Libraries, Frameworks & Software Standards
1 4 (10.26%) Web Services
2 2 (5.13%) Kafka
3 1 (2.56%) Celery
3 1 (2.56%) CGI
3 1 (2.56%) Flask
3 1 (2.56%) PostGIS
Miscellaneous
1 5 (12.82%) Data Structures
2 4 (10.26%) Management Information System
3 3 (7.69%) Taxonomies
4 1 (2.56%) Analytical Skills
4 1 (2.56%) e-Learning
4 1 (2.56%) Social Media
Operating Systems
1 2 (5.13%) Unix
Processes & Methodologies
1 12 (30.77%) Data Modelling
2 9 (23.08%) Data Architecture
3 8 (20.51%) Agile Software Development
4 7 (17.95%) Business Intelligence
4 7 (17.95%) Data Analysis
4 7 (17.95%) Migration
5 6 (15.38%) Analytics
5 6 (15.38%) Data Management
6 5 (12.82%) ETL Development
6 5 (12.82%) Visualisation
7 4 (10.26%) Asset Management
7 4 (10.26%) Ontologies
8 3 (7.69%) Data Visualisation
8 3 (7.69%) Kimball Methodology
8 3 (7.69%) Master Data Management
8 3 (7.69%) Requirements Analysis
9 2 (5.13%) Data Ingestion
9 2 (5.13%) Logical Data Model
9 2 (5.13%) Physical Data Model
9 2 (5.13%) Translating Business Requirements
Programming Languages
1 20 (51.28%) SQL
2 6 (15.38%) PL/SQL
3 3 (7.69%) Java
3 3 (7.69%) Python
3 3 (7.69%) R
3 3 (7.69%) Scala
4 2 (5.13%) VBA
5 1 (2.56%) C#
5 1 (2.56%) T-SQL
Qualifications
1 1 (2.56%) APMP
1 1 (2.56%) BPSS Clearance
1 1 (2.56%) Oracle Certification
Quality Assurance & Compliance
1 4 (10.26%) Disclosure Scotland
2 2 (5.13%) Data Quality
3 1 (2.56%) SLA
System Software
1 2 (5.13%) HDFS
Systems Management
1 2 (5.13%) Hadoop YARN
1 2 (5.13%) Oozie
Vendors
1 16 (41.03%) Oracle
2 9 (23.08%) Cloudera
3 7 (17.95%) Teradata
4 5 (12.82%) Microsoft
4 5 (12.82%) Tableau
5 3 (7.69%) Informatica
5 3 (7.69%) SAP
6 2 (5.13%) Ab Initio
6 2 (5.13%) Charles River
7 1 (2.56%) Alteryx
7 1 (2.56%) Cognos
7 1 (2.56%) Google
7 1 (2.56%) IBM
7 1 (2.56%) Netezza
7 1 (2.56%) Pega
7 1 (2.56%) Talend