Period
to 20 January 2019

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 20 January 2019 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
20 Jan 2019
Same period 2018 Same period 2017
Rank 42 45 72
Rank change year-on-year +3 +27 -20
Contract jobs citing ETL 101 112 39
As % of all contract IT jobs advertised in Edinburgh 3.95% 3.88% 2.20%
As % of the Processes & Methodologies category 4.49% 4.43% 2.58%
Number of daily rates quoted 62 67 24
Edinburgh median daily rate £475 £400 £400
Median daily rate % change year-on-year +18.75% - -
10th Percentile £363 £313 £338
90th Percentile £588 £550 £488
Scotland median daily rate £450 £400 £400
% change year-on-year +12.50% - -
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,250 2,526 1,511
As % of all contract IT jobs advertised in Edinburgh 87.96% 87.62% 85.08%
Number of daily rates quoted 1,149 1,467 928
Edinburgh median daily rate £425 £400 £400
Median daily rate % change year-on-year +6.25% - -
10th Percentile £285 £275 £263
90th Percentile £575 £575 £538
Scotland median daily rate £413 £400 £375
% change year-on-year +3.13% +6.67% -
Number of hourly rates quoted 32 21 33
Edinburgh median hourly rate £27.75 £21.00 £25.00
Median hourly rate % change year-on-year +32.14% -16.00% +31.44%
10th Percentile £15.04 £11.25 £14.09
90th Percentile £46.41 £35.00 £52.00
Scotland median hourly rate £24.50 £21.00 £21.25
% change year-on-year +16.67% -1.18% +1.19%

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 20 January 2019.

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 20 January 2019, 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 64 (63.37%) SQL
2 57 (56.44%) Data Warehouse
3 48 (47.52%) Oracle
4 38 (37.62%) SQL Server
5 36 (35.64%) Ab Initio
6 32 (31.68%) Unix
7 29 (28.71%) Finance
7 29 (28.71%) Business Intelligence
8 28 (27.72%) Data Integration
9 26 (25.74%) Shell Script
9 26 (25.74%) Migration
10 23 (22.77%) Teradata
10 23 (22.77%) Data Migration
11 22 (21.78%) Informatica
12 21 (20.79%) Banking
13 20 (19.80%) ETL Development
14 19 (18.81%) Agile Software Development
15 18 (17.82%) Data Modelling
15 18 (17.82%) Oracle Database
16 16 (15.84%) User Acceptance Testing
16 16 (15.84%) QA
17 15 (14.85%) Big Data
17 15 (14.85%) Retail
17 15 (14.85%) Data Analysis
18 14 (13.86%) OLAP
18 14 (13.86%) Metadata Management
19 12 (11.88%) Data Quality
20 11 (10.89%) PL/SQL
21 10 (9.90%) Java
21 10 (9.90%) Investment Management

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 5 (4.95%) Apache Spark
2 4 (3.96%) SAS
3 1 (0.99%) Apache Pig
3 1 (0.99%) Apache Solr
3 1 (0.99%) Elasticsearch
3 1 (0.99%) Oracle Workflow
Applications
1 4 (3.96%) Microsoft Excel
2 2 (1.98%) Microsoft Office
2 2 (1.98%) Microsoft PowerPoint
3 1 (0.99%) Microsoft Project
Cloud Services
1 6 (5.94%) Amazon AWS
2 3 (2.97%) Microsoft Azure
3 2 (1.98%) Amazon EMR
3 2 (1.98%) Amazon S3
4 1 (0.99%) Amazon SageMaker
4 1 (0.99%) Azure Active Directory
4 1 (0.99%) Office 365
4 1 (0.99%) Salesforce Service Cloud
4 1 (0.99%) Trello
Database & Business Intelligence
1 57 (56.44%) Data Warehouse
2 38 (37.62%) SQL Server
3 18 (17.82%) Oracle Database
4 15 (14.85%) Big Data
5 14 (13.86%) OLAP
6 9 (8.91%) Hadoop
7 8 (7.92%) SQL Server Integration Services
8 7 (6.93%) BusinessObjects
8 7 (6.93%) MongoDB
9 6 (5.94%) Apache Hive
9 6 (5.94%) Informix
9 6 (5.94%) PostgreSQL
10 4 (3.96%) Oracle Database 12c
10 4 (3.96%) Relational Database
10 4 (3.96%) SAP Data Services
11 3 (2.97%) NoSQL
11 3 (2.97%) Oracle Exadata
11 3 (2.97%) PowerCenter
11 3 (2.97%) RDBMS
11 3 (2.97%) SQL Server Reporting Services
Development Applications
1 5 (4.95%) Hudson
2 4 (3.96%) ERwin
2 4 (3.96%) JIRA
3 1 (0.99%) ER Studio
3 1 (0.99%) Git (software)
3 1 (0.99%) Jenkins
3 1 (0.99%) Maven
3 1 (0.99%) NUnit
3 1 (0.99%) Subversion
3 1 (0.99%) Visual Studio
General
1 29 (28.71%) Finance
2 21 (20.79%) Banking
3 15 (14.85%) Retail
4 6 (5.94%) Retail Banking
5 4 (3.96%) Investment Banking
6 2 (1.98%) Corporate Banking
6 2 (1.98%) Financial Institution
7 1 (0.99%) Advertising
7 1 (0.99%) Legal
Job Titles
1 50 (49.50%) Developer
2 30 (29.70%) Ab Initio Developer
3 10 (9.90%) Analyst
3 10 (9.90%) Consultant
4 9 (8.91%) Architect
5 7 (6.93%) Data Architect
6 6 (5.94%) DBA
7 5 (4.95%) Data Analyst
8 4 (3.96%) ETL Consultant
9 3 (2.97%) Administrator
9 3 (2.97%) Business Intelligence Consultant
9 3 (2.97%) Data Migration Lead
9 3 (2.97%) Senior DBA
9 3 (2.97%) SQL Developer
9 3 (2.97%) Tester
10 2 (1.98%) Ab Initio Architect
10 2 (1.98%) Data Engineer
10 2 (1.98%) ETL Analyst
10 2 (1.98%) Senior Consultant
10 2 (1.98%) Test Analyst
Libraries, Frameworks & Software Standards
1 7 (6.93%) Web Services
1 7 (6.93%) XML
2 5 (4.95%) REST
3 4 (3.96%) JSON
4 3 (2.97%) .NET
4 3 (2.97%) Middleware
4 3 (2.97%) SOAP
5 2 (1.98%) HTML
5 2 (1.98%) IBM Integration Bus
5 2 (1.98%) Java EE
5 2 (1.98%) JSP
5 2 (1.98%) Servlets
6 1 (0.99%) .NET Framework
6 1 (0.99%) ASP.NET
6 1 (0.99%) ASP.NET Web API
6 1 (0.99%) HTML5
6 1 (0.99%) Kafka
6 1 (0.99%) PostGIS
6 1 (0.99%) Razor View Engine
6 1 (0.99%) Visualforce
Miscellaneous
1 7 (6.93%) Analytical Skills
2 5 (4.95%) Enterprise Software
3 3 (2.97%) Data Structures
4 2 (1.98%) Management Information System
5 1 (0.99%) Clustering
5 1 (0.99%) Fintech
5 1 (0.99%) User Experience
Operating Systems
1 32 (31.68%) Unix
2 5 (4.95%) Linux
3 2 (1.98%) Windows
4 1 (0.99%) Red Hat Enterprise Linux
4 1 (0.99%) Windows Server
Processes & Methodologies
1 29 (28.71%) Business Intelligence
2 28 (27.72%) Data Integration
3 26 (25.74%) Migration
4 23 (22.77%) Data Migration
5 20 (19.80%) ETL Development
6 19 (18.81%) Agile Software Development
7 18 (17.82%) Data Modelling
8 16 (15.84%) User Acceptance Testing
9 15 (14.85%) Data Analysis
10 14 (13.86%) Metadata Management
11 10 (9.90%) Investment Management
12 7 (6.93%) Asset Management
12 7 (6.93%) Data Management
13 6 (5.94%) Database Security
13 6 (5.94%) Database Tuning
13 6 (5.94%) DevOps
13 6 (5.94%) Problem-Solving
13 6 (5.94%) Visualisation
14 5 (4.95%) Analytics
14 5 (4.95%) Performance Tuning
Programming Languages
1 64 (63.37%) SQL
2 26 (25.74%) Shell Script
3 11 (10.89%) PL/SQL
4 10 (9.90%) Java
5 4 (3.96%) Python
5 4 (3.96%) T-SQL
6 3 (2.97%) C#
7 2 (1.98%) JavaScript
7 2 (1.98%) PowerShell
7 2 (1.98%) R
7 2 (1.98%) VBA
8 1 (0.99%) Apex Code
8 1 (0.99%) Bash Shell
8 1 (0.99%) C
8 1 (0.99%) Java 8
8 1 (0.99%) Perl
8 1 (0.99%) Scala
8 1 (0.99%) SOQL
8 1 (0.99%) SOSL
Qualifications
1 1 (0.99%) Degree
1 1 (0.99%) Numerate Degree
1 1 (0.99%) Security Cleared
Quality Assurance & Compliance
1 16 (15.84%) QA
2 12 (11.88%) Data Quality
3 1 (0.99%) Disclosure Scotland
3 1 (0.99%) GDPR
3 1 (0.99%) IFRS
3 1 (0.99%) IFRS 9
3 1 (0.99%) PMO
3 1 (0.99%) PSD2
System Software
1 1 (0.99%) Active Directory
1 1 (0.99%) Docker
Systems Management
1 3 (2.97%) Ansible
2 2 (1.98%) Control-M
3 1 (0.99%) Grafana
3 1 (0.99%) Oozie
3 1 (0.99%) Opscode Chef
3 1 (0.99%) Oracle Flashback
3 1 (0.99%) Prometheus
3 1 (0.99%) Puppet
3 1 (0.99%) SCOM
Vendors
1 48 (47.52%) Oracle
2 36 (35.64%) Ab Initio
3 23 (22.77%) Teradata
4 22 (21.78%) Informatica
5 8 (7.92%) Tableau
5 8 (7.92%) Talend
6 6 (5.94%) IBM
6 6 (5.94%) Microsoft
7 4 (3.96%) SAP
8 3 (2.97%) CA
9 1 (0.99%) Hitachi
9 1 (0.99%) Planview
9 1 (0.99%) Red Hat
9 1 (0.99%) RedGate
9 1 (0.99%) Salesforce.com
9 1 (0.99%) SaltStack
9 1 (0.99%) SolarWinds
9 1 (0.99%) Vermilion