Period
to 19 October 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 19 October 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
19 Oct 2018
Same period 2017 Same period 2016
Rank 67 56 53
Rank change year-on-year -11 -3 -21
Contract jobs citing ETL 78 86 88
As % of all contract IT jobs advertised in Edinburgh 2.64% 3.10% 3.82%
As % of the Processes & Methodologies category 2.97% 3.67% 4.47%
Number of daily rates quoted 50 53 58
Edinburgh median daily rate £450 £400 £400
Median daily rate % change year-on-year +12.50% - -
10th Percentile £362 £313 £332
90th Percentile £588 £488 £525
Scotland median daily rate £450 £400 £425
% change year-on-year +12.50% -5.88% +6.92%
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate £43.00 - -

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,623 2,344 1,967
As % of all contract IT jobs advertised in Edinburgh 88.67% 84.62% 85.45%
Number of daily rates quoted 1,342 1,367 1,127
Edinburgh median daily rate £425 £400 £390
Median daily rate % change year-on-year +6.25% +2.56% +2.63%
10th Percentile £280 £263 £263
90th Percentile £575 £550 £525
Scotland median daily rate £400 £390 £355
% change year-on-year +2.56% +9.86% -5.33%
Number of hourly rates quoted 27 18 24
Edinburgh median hourly rate £25.00 £16.68 £19.75
Median hourly rate % change year-on-year +49.88% -15.54% +23.44%
10th Percentile £10.90 £11.22 £11.15
90th Percentile £43.96 £37.52 £47.36
Scotland median hourly rate £25.00 £26.25 £25.00
% change year-on-year -4.76% +5.00% +25.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 19 October 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 19 October 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 51 (65.38%) SQL
2 39 (50.00%) SQL Server
3 38 (48.72%) Oracle
4 37 (47.44%) Data Warehouse
5 26 (33.33%) Ab Initio
6 25 (32.05%) Finance
7 20 (25.64%) Business Intelligence
7 20 (25.64%) Oracle Database
8 19 (24.36%) Agile Software Development
8 19 (24.36%) Migration
8 19 (24.36%) Teradata
9 18 (23.08%) Banking
10 17 (21.79%) Data Migration
11 15 (19.23%) ETL Development
12 14 (17.95%) Unix
13 13 (16.67%) Informatica
13 13 (16.67%) Data Integration
14 12 (15.38%) Talend
14 12 (15.38%) Shell Script
14 12 (15.38%) Data Modelling
15 11 (14.10%) QA
15 11 (14.10%) User Acceptance Testing
16 10 (12.82%) Retail
17 9 (11.54%) Python
17 9 (11.54%) .NET
17 9 (11.54%) Java
17 9 (11.54%) Analytical Skills
18 8 (10.26%) Ansible
18 8 (10.26%) Investment Management
18 8 (10.26%) DevOps

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 4 (5.13%) SAS
2 2 (2.56%) Apache Spark
2 2 (2.56%) WebSphere
3 1 (1.28%) Apache Pig
3 1 (1.28%) Apache Solr
3 1 (1.28%) Elasticsearch
3 1 (1.28%) Oracle Workflow
Applications
1 3 (3.85%) Microsoft Excel
2 2 (2.56%) Microsoft Office
3 1 (1.28%) Microsoft PowerPoint
Business Applications
1 2 (2.56%) thinkFolio
Cloud Services
1 3 (3.85%) Amazon AWS
2 2 (2.56%) Amazon S3
2 2 (2.56%) Microsoft Azure
3 1 (1.28%) Amazon EMR
3 1 (1.28%) Amazon SageMaker
3 1 (1.28%) Office 365
3 1 (1.28%) Salesforce Service Cloud
3 1 (1.28%) Trello
Communications & Networking
1 1 (1.28%) HTTP
Database & Business Intelligence
1 39 (50.00%) SQL Server
2 37 (47.44%) Data Warehouse
3 20 (25.64%) Oracle Database
4 7 (8.97%) Big Data
4 7 (8.97%) MongoDB
4 7 (8.97%) PostgreSQL
4 7 (8.97%) SQL Server Integration Services
5 6 (7.69%) Informix
5 6 (7.69%) OLAP
6 5 (6.41%) SQL Server Reporting Services
7 4 (5.13%) Relational Database
8 3 (3.85%) BusinessObjects
8 3 (3.85%) Hadoop
8 3 (3.85%) NoSQL
9 2 (2.56%) Apache Hive
9 2 (2.56%) Oracle Database 12c
9 2 (2.56%) Oracle OLAP
9 2 (2.56%) PowerCenter
9 2 (2.56%) RDBMS
9 2 (2.56%) SQL Server Analysis Services
Development Applications
1 6 (7.69%) Git (software)
2 5 (6.41%) Jenkins
3 2 (2.56%) ERwin
3 2 (2.56%) Subversion
4 1 (1.28%) Hudson
4 1 (1.28%) JIRA
4 1 (1.28%) Maven
4 1 (1.28%) Team Foundation Server
4 1 (1.28%) Visual Studio
General
1 25 (32.05%) Finance
2 18 (23.08%) Banking
3 10 (12.82%) Retail
4 5 (6.41%) Investment Banking
5 2 (2.56%) Corporate Banking
5 2 (2.56%) Retail Banking
6 1 (1.28%) Financial Institution
6 1 (1.28%) Front Office
Job Titles
1 42 (53.85%) Developer
2 20 (25.64%) Ab Initio Developer
3 11 (14.10%) Analyst
4 8 (10.26%) Architect
4 8 (10.26%) SQL Developer
5 6 (7.69%) Data Analyst
5 6 (7.69%) DBA
6 5 (6.41%) Consultant
7 4 (5.13%) Data Architect
7 4 (5.13%) Technical Analyst
8 3 (3.85%) Administrator
8 3 (3.85%) Senior DBA
8 3 (3.85%) Solutions Architect
8 3 (3.85%) Technical Leader
9 2 (2.56%) Ab Initio Consultant
9 2 (2.56%) Data Migration Analyst
9 2 (2.56%) Lead Developer
9 2 (2.56%) Senior Developer
9 2 (2.56%) Software Developer
9 2 (2.56%) Test Analyst
Libraries, Frameworks & Software Standards
1 9 (11.54%) .NET
2 5 (6.41%) PostGIS
3 4 (5.13%) Spring
4 3 (3.85%) Middleware
4 3 (3.85%) REST
4 3 (3.85%) Web Services
5 2 (2.56%) ASP.NET
5 2 (2.56%) HTML
5 2 (2.56%) IBM Integration Bus
5 2 (2.56%) SOAP
5 2 (2.56%) XML
6 1 (1.28%) .NET Framework
6 1 (1.28%) CSS
6 1 (1.28%) Elastic Stack
6 1 (1.28%) HATEOAS
6 1 (1.28%) JSON
6 1 (1.28%) Kafka
6 1 (1.28%) Spark Streaming
6 1 (1.28%) Visualforce
6 1 (1.28%) WinForms
Miscellaneous
1 9 (11.54%) Analytical Skills
2 2 (2.56%) Data Structures
2 2 (2.56%) Enterprise Software
3 1 (1.28%) Clustering
3 1 (1.28%) Fintech
3 1 (1.28%) Management Information System
3 1 (1.28%) Self-Motivation
3 1 (1.28%) User Experience
Operating Systems
1 14 (17.95%) Unix
2 7 (8.97%) Linux
3 2 (2.56%) Windows
4 1 (1.28%) Red Hat Enterprise Linux
4 1 (1.28%) Windows Server
Processes & Methodologies
1 20 (25.64%) Business Intelligence
2 19 (24.36%) Agile Software Development
2 19 (24.36%) Migration
3 17 (21.79%) Data Migration
4 15 (19.23%) ETL Development
5 13 (16.67%) Data Integration
6 12 (15.38%) Data Modelling
7 11 (14.10%) User Acceptance Testing
8 8 (10.26%) DevOps
8 8 (10.26%) Investment Management
9 7 (8.97%) Asset Management
9 7 (8.97%) Data Analysis
10 6 (7.69%) Database Security
10 6 (7.69%) Database Tuning
10 6 (7.69%) Metadata Management
11 5 (6.41%) BDD
11 5 (6.41%) Data Transformation
11 5 (6.41%) Stakeholder Management
11 5 (6.41%) TDD
12 4 (5.13%) Business Analysis
Programming Languages
1 51 (65.38%) SQL
2 12 (15.38%) Shell Script
3 9 (11.54%) Java
3 9 (11.54%) Python
4 3 (3.85%) C#
4 3 (3.85%) PL/SQL
5 2 (2.56%) Bash Shell
5 2 (2.56%) JavaScript
5 2 (2.56%) PowerShell
5 2 (2.56%) Scala
5 2 (2.56%) T-SQL
5 2 (2.56%) VBA
6 1 (1.28%) Apex Code
6 1 (1.28%) Perl
6 1 (1.28%) R
6 1 (1.28%) SOQL
6 1 (1.28%) SOSL
6 1 (1.28%) VB
Qualifications
1 5 (6.41%) Degree
2 1 (1.28%) Numerate Degree
2 1 (1.28%) Security Cleared
Quality Assurance & Compliance
1 11 (14.10%) QA
2 6 (7.69%) Data Quality
3 1 (1.28%) GDPR
3 1 (1.28%) IFRS
3 1 (1.28%) IFRS 9
3 1 (1.28%) PMO
System Software
1 5 (6.41%) Docker
Systems Management
1 8 (10.26%) Ansible
2 2 (2.56%) Opscode Chef
2 2 (2.56%) Puppet
3 1 (1.28%) Grafana
3 1 (1.28%) Prometheus
3 1 (1.28%) SCOM
Vendors
1 38 (48.72%) Oracle
2 26 (33.33%) Ab Initio
3 19 (24.36%) Teradata
4 13 (16.67%) Informatica
5 12 (15.38%) Talend
6 6 (7.69%) IBM
6 6 (7.69%) Microsoft
7 5 (6.41%) Vermilion
8 4 (5.13%) Tableau
9 2 (2.56%) Bloomberg
9 2 (2.56%) CA
9 2 (2.56%) CODA
9 2 (2.56%) Sitecore
10 1 (1.28%) Red Hat
10 1 (1.28%) Salesforce.com
10 1 (1.28%) SaltStack
10 1 (1.28%) SolarWinds