Period
to 23 June 2018

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 6 months to 23 June 2018 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
6 months to
23 Jun 2018
Same period 2017 Same period 2016
Rank 47 61 41
Rank change year-on-year +14 -20 -4
Contract jobs citing ETL 94 51 117
As % of all contract IT jobs advertised in Edinburgh 3.25% 2.44% 4.07%
As % of the Processes & Methodologies category 3.73% 2.87% 4.78%
Number of daily rates quoted 67 34 89
Edinburgh median daily rate £400 £443 £425
Median daily rate % change year-on-year -9.60% +4.12% +13.33%
10th Percentile £310 £325 £313
90th Percentile £530 £496 £515
Scotland median daily rate £400 £413 £400
% change year-on-year -3.03% +3.13% +4.23%
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate - - -

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Edinburgh with a requirement for process or methodology skills.

All Process and Methodology Skills
Edinburgh
Contract vacancies with a requirement for process or methodology skills 2,518 1,780 2,447
As % of all contract IT jobs advertised in Edinburgh 86.98% 85.09% 85.20%
Number of daily rates quoted 1,498 1,093 1,352
Edinburgh median daily rate £405 £400 £400
Median daily rate % change year-on-year +1.25% - +6.67%
10th Percentile £290 £256 £275
90th Percentile £569 £550 £550
Scotland median daily rate £400 £380 £375
% change year-on-year +5.26% +1.33% -
Number of hourly rates quoted 23 20 13
Edinburgh median hourly rate £35.00 £16.93 £15.82
Median hourly rate % change year-on-year +106.73% +7.05% -49.39%
10th Percentile £12.74 £12.37 £11.10
90th Percentile £48.28 £43.77 £43.50
Scotland median hourly rate £17.50 £26.75 £36.00
% change year-on-year -34.58% -25.69% +20.00%

ETL
Job Vacancy Trend in Edinburgh

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

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 6 months to 23 June 2018.

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 23 June 2018, IT contractor 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 contract job ads across the Edinburgh region with a requirement for ETL.

1 60 (63.83%) SQL
2 51 (54.26%) Data Warehouse
3 45 (47.87%) Finance
4 43 (45.74%) Oracle
5 37 (39.36%) Agile Software Development
6 35 (37.23%) Informatica
7 33 (35.11%) Unix
7 33 (35.11%) Data Modelling
7 33 (35.11%) Migration
8 30 (31.91%) Data Analysis
9 28 (29.79%) Data Migration
10 27 (28.72%) Data Integration
11 23 (24.47%) Data Quality
11 23 (24.47%) Business Intelligence
12 21 (22.34%) Relational Database
12 21 (22.34%) ETL Development
13 20 (21.28%) Banking
14 19 (20.21%) PowerCenter
15 17 (18.09%) Oracle Database
15 17 (18.09%) Hadoop
15 17 (18.09%) Data Architecture
16 16 (17.02%) Big Data
16 16 (17.02%) Teradata
17 15 (15.96%) SDLC
18 14 (14.89%) Test Automation
19 13 (13.83%) PowerExchange
19 13 (13.83%) PL/SQL
20 12 (12.77%) RDBMS
20 12 (12.77%) TOGAF
21 11 (11.70%) Information Security

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 13 (13.83%) PowerExchange
2 2 (2.13%) SAS
2 2 (2.13%) WebSphere
3 1 (1.06%) Apache
3 1 (1.06%) Apache Solr
3 1 (1.06%) Apache Spark
3 1 (1.06%) Confluence
3 1 (1.06%) GeoServer
Applications
1 1 (1.06%) Microsoft Excel
Business Applications
1 4 (4.26%) Markit EDM
2 3 (3.19%) thinkFolio
3 1 (1.06%) Dynamics CRM
3 1 (1.06%) SAP SD
Cloud Services
1 1 (1.06%) Amazon AWS
1 1 (1.06%) Microsoft Azure
1 1 (1.06%) npm
Communications & Networking
1 1 (1.06%) HTTP
Database & Business Intelligence
1 51 (54.26%) Data Warehouse
2 21 (22.34%) Relational Database
3 19 (20.21%) PowerCenter
4 17 (18.09%) Hadoop
4 17 (18.09%) Oracle Database
5 16 (17.02%) Big Data
6 12 (12.77%) RDBMS
7 11 (11.70%) SQL Server
8 10 (10.64%) SQL Server Integration Services
9 6 (6.38%) Data Lake
10 5 (5.32%) Enterprise Data Warehouse
10 5 (5.32%) SQL Server Reporting Services
11 4 (4.26%) Pentaho
11 4 (4.26%) SQL Server Analysis Services
12 3 (3.19%) Microsoft Analysis Services
13 2 (2.13%) NoSQL
14 1 (1.06%) Apache Cassandra
14 1 (1.06%) Apache Hive
14 1 (1.06%) MongoDB
14 1 (1.06%) Parquet
Development Applications
1 10 (10.64%) ERwin
2 9 (9.57%) Git (software)
3 7 (7.45%) Jenkins
4 5 (5.32%) JIRA
5 2 (2.13%) FitNesse
5 2 (2.13%) Subversion
5 2 (2.13%) Visual Studio
6 1 (1.06%) Bower
6 1 (1.06%) DBeaver
6 1 (1.06%) Hudson
6 1 (1.06%) Oracle APEX
6 1 (1.06%) Oracle Forms
6 1 (1.06%) webpack
General
1 45 (47.87%) Finance
2 20 (21.28%) Banking
3 4 (4.26%) Retail Banking
4 1 (1.06%) Electronics
4 1 (1.06%) Front Office
4 1 (1.06%) Investment Banking
4 1 (1.06%) Manufacturing
4 1 (1.06%) Marketing
4 1 (1.06%) Publishing
4 1 (1.06%) Retail
4 1 (1.06%) Telecoms
Job Titles
1 42 (44.68%) Developer
2 19 (20.21%) Analyst
2 19 (20.21%) Informatica Developer
3 18 (19.15%) Architect
4 11 (11.70%) Data Architect
5 10 (10.64%) ETL Developer
6 9 (9.57%) ETL Tester
6 9 (9.57%) Tester
7 8 (8.51%) Test Analyst
8 7 (7.45%) Business Analyst
9 6 (6.38%) Business Intelligence Analyst
9 6 (6.38%) SQL Developer
9 6 (6.38%) Technical Architect
10 5 (5.32%) Business Intelligence Business Analyst
10 5 (5.32%) Lead Developer
10 5 (5.32%) Python Developer
10 5 (5.32%) Senior Developer
11 4 (4.26%) Senior Informatica Developer
11 4 (4.26%) SQL Analyst
11 4 (4.26%) Technical Analyst
Libraries, Frameworks & Software Standards
1 6 (6.38%) PostGIS
2 3 (3.19%) ActiveMQ
2 3 (3.19%) CSS
2 3 (3.19%) HTML
3 2 (2.13%) .NET
3 2 (2.13%) Spring
4 1 (1.06%) Akka
4 1 (1.06%) AngularJS
4 1 (1.06%) Flask
4 1 (1.06%) HATEOAS
4 1 (1.06%) jQuery
4 1 (1.06%) Kafka
4 1 (1.06%) Middleware
4 1 (1.06%) Node.js
4 1 (1.06%) OpenLayers
4 1 (1.06%) REST
4 1 (1.06%) RESTful
4 1 (1.06%) Sass
4 1 (1.06%) TensorFlow
4 1 (1.06%) XML
Miscellaneous
1 10 (10.64%) Analytical Skills
2 5 (5.32%) Mainframe
3 2 (2.13%) Fixed Income
4 1 (1.06%) Computer Science
4 1 (1.06%) Data Structures
4 1 (1.06%) Enterprise Software
4 1 (1.06%) Fintech
4 1 (1.06%) FMCG
4 1 (1.06%) Greenfield Project
4 1 (1.06%) Minimum Viable Product
4 1 (1.06%) Photography
Operating Systems
1 33 (35.11%) Unix
2 7 (7.45%) Linux
Processes & Methodologies
1 37 (39.36%) Agile Software Development
2 33 (35.11%) Data Modelling
2 33 (35.11%) Migration
3 30 (31.91%) Data Analysis
4 28 (29.79%) Data Migration
5 27 (28.72%) Data Integration
6 23 (24.47%) Business Intelligence
7 21 (22.34%) ETL Development
8 17 (18.09%) Data Architecture
9 15 (15.96%) SDLC
10 14 (14.89%) Test Automation
11 12 (12.77%) TOGAF
12 11 (11.70%) Information Security
12 11 (11.70%) Waterfall
13 9 (9.57%) Defect Management
13 9 (9.57%) Stakeholder Management
14 8 (8.51%) Asset Management
14 8 (8.51%) Open Source
14 8 (8.51%) Test Management
15 7 (7.45%) Analytics
Programming Languages
1 60 (63.83%) SQL
2 13 (13.83%) PL/SQL
3 8 (8.51%) Python
4 6 (6.38%) Java
5 3 (3.19%) JavaScript
6 1 (1.06%) ES6
6 1 (1.06%) Perl
6 1 (1.06%) R
6 1 (1.06%) Scala
6 1 (1.06%) Shell Script
6 1 (1.06%) VB
Qualifications
1 8 (8.51%) ISTQB
2 2 (2.13%) BPSS Clearance
2 2 (2.13%) Security Cleared
3 1 (1.06%) PhD
3 1 (1.06%) TOGAF Certification
Quality Assurance & Compliance
1 23 (24.47%) Data Quality
2 4 (4.26%) Disclosure Scotland
3 3 (3.19%) QA
System Software
1 6 (6.38%) Docker
2 1 (1.06%) Apache Flume
2 1 (1.06%) GeoWebCache
2 1 (1.06%) VMware Infrastructure
Systems Management
1 6 (6.38%) Ansible
2 4 (4.26%) Oracle Flashback
3 1 (1.06%) HP Quality Center
3 1 (1.06%) Opscode Chef
3 1 (1.06%) Puppet
3 1 (1.06%) Terraform
Vendors
1 43 (45.74%) Oracle
2 35 (37.23%) Informatica
3 16 (17.02%) Teradata
4 10 (10.64%) CA
5 7 (7.45%) Bloomberg
5 7 (7.45%) Microsoft
6 3 (3.19%) Charles River
6 3 (3.19%) CODA
6 3 (3.19%) IBM
7 2 (2.13%) Ab Initio
7 2 (2.13%) SAP
7 2 (2.13%) Sitecore
8 1 (1.06%) Cloudera
8 1 (1.06%) FactSet
8 1 (1.06%) Hortonworks
8 1 (1.06%) Hyperion
8 1 (1.06%) MapR
8 1 (1.06%) Twitter
8 1 (1.06%) VMware