Period
to 17 November 2017

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 17 November 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
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 57 53 34
Rank change year-on-year -4 -19 +34
Contract jobs citing ETL 86 76 125
As % of all contract IT jobs advertised in Edinburgh 2.95% 3.50% 3.88%
As % of the Processes & Methodologies category 3.50% 4.16% 4.66%
Number of daily rates quoted 51 51 84
Edinburgh median daily rate £400 £400 £405
Median daily rate % change year-on-year - -1.23% +1.25%
10th Percentile £313 £319 £290
90th Percentile £488 £525 £635
Scotland median daily rate £400 £400 £400
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 2457 1826 2682
As % of all contract IT jobs advertised in Edinburgh 84.26% 84.07% 83.21%
Number of daily rates quoted 1434 1040 1388
Edinburgh median daily rate £400 £388 £388
Median daily rate % change year-on-year +3.23% - -3.13%
10th Percentile £263 £260 £263
90th Percentile £550 £525 £521
Scotland median daily rate £390 £360 £375
% change year-on-year +8.33% -4.00% -
Number of hourly rates quoted 18 27 21
Edinburgh median hourly rate £21.00 £20.00 £19.02
Median hourly rate % change year-on-year +5.00% +5.15% +20.61%
10th Percentile £11.22 £11.30 £12.00
90th Percentile £37.52 £48.38 £40.38
Scotland median hourly rate £25.00 £24.00 £25.00
% change year-on-year +4.17% -4.00% +14.94%

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 17 November 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 17 November 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 42 (48.84%) SQL
2 36 (41.86%) Agile Software Development
3 35 (40.70%) Data Warehouse
4 34 (39.53%) Finance
5 21 (24.42%) Hadoop
6 19 (22.09%) Test Automation
6 19 (22.09%) Big Data
6 19 (22.09%) Business Intelligence
7 16 (18.60%) Data Modelling
7 16 (18.60%) Oracle
7 16 (18.60%) Banking
8 14 (16.28%) Teradata
8 14 (16.28%) SQL Server
8 14 (16.28%) Analytics
9 13 (15.12%) User Acceptance Testing
10 12 (13.95%) Informatica
11 11 (12.79%) Migration
12 10 (11.63%) SQL Server Integration Services
13 9 (10.47%) PL/SQL
13 9 (10.47%) Data Migration
13 9 (10.47%) Markit EDM
14 8 (9.30%) Python
14 8 (9.30%) JavaScript
14 8 (9.30%) Unix
14 8 (9.30%) Retail Banking
14 8 (9.30%) SQL Server Reporting Services
14 8 (9.30%) Data Analysis
14 8 (9.30%) Scrum
15 7 (8.14%) Microsoft
15 7 (8.14%) Visualisation

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 (4.65%) SAS
2 1 (1.16%) MTS
2 1 (1.16%) SharePoint
Applications
1 1 (1.16%) Microsoft Project
Business Applications
1 9 (10.47%) Markit EDM
Cloud Services
1 4 (4.65%) Amazon AWS
1 4 (4.65%) Google Analytics
2 2 (2.33%) Microsoft Azure
Communications & Networking
1 3 (3.49%) HTTP
1 3 (3.49%) TCP/IP
2 2 (2.33%) Internet
Database & Business Intelligence
1 35 (40.70%) Data Warehouse
2 21 (24.42%) Hadoop
3 19 (22.09%) Big Data
4 14 (16.28%) SQL Server
5 10 (11.63%) SQL Server Integration Services
6 8 (9.30%) SQL Server Reporting Services
7 6 (6.98%) PostgreSQL
7 6 (6.98%) Power BI
8 5 (5.81%) SQL Server Analysis Services
9 4 (4.65%) GIS
9 4 (4.65%) NoSQL
9 4 (4.65%) Oracle Database
9 4 (4.65%) Spatial Data
10 3 (3.49%) Apache Hive
10 3 (3.49%) Enterprise Data Warehouse
10 3 (3.49%) MongoDB
10 3 (3.49%) Relational Database
11 2 (2.33%) Microsoft Analysis Services
11 2 (2.33%) PowerCenter
11 2 (2.33%) RDBMS
Development Applications
1 6 (6.98%) ERwin
2 3 (3.49%) JMeter
2 3 (3.49%) Team Foundation Server
3 2 (2.33%) JIRA
3 2 (2.33%) Talend Open Studio
4 1 (1.16%) FitNesse
4 1 (1.16%) SQL Server Management Studio (SSMS)
4 1 (1.16%) Subversion
General
1 34 (39.53%) Finance
2 16 (18.60%) Banking
3 8 (9.30%) Retail Banking
4 4 (4.65%) Front Office
5 1 (1.16%) Investment Banking
5 1 (1.16%) Legal
Job Titles
1 31 (36.05%) Analyst
2 25 (29.07%) Test Analyst
3 17 (19.77%) Developer
4 11 (12.79%) Senior Analyst
4 11 (12.79%) Senior Test Analyst
5 8 (9.30%) Architect
6 7 (8.14%) Big Data Analyst
6 7 (8.14%) Consultant
6 7 (8.14%) Data Analyst
6 7 (8.14%) Data Architect
6 7 (8.14%) SQL Developer
7 6 (6.98%) ETL Analyst
7 6 (6.98%) Test Data Analyst
8 5 (5.81%) Data Consultant
8 5 (5.81%) Data Modeller
9 4 (4.65%) Business Intelligence Developer
9 4 (4.65%) Designer
9 4 (4.65%) ETL Developer
9 4 (4.65%) UAT Analyst
9 4 (4.65%) UAT Test Analyst
Libraries, Frameworks & Software Standards
1 4 (4.65%) HTML
2 3 (3.49%) D3.js
2 3 (3.49%) NumPy
2 3 (3.49%) Pandas
2 3 (3.49%) RESTful
3 2 (2.33%) PostGIS
3 2 (2.33%) Web Services
3 2 (2.33%) XML
4 1 (1.16%) Gherkin
4 1 (1.16%) HTML5
4 1 (1.16%) Middleware
Miscellaneous
1 3 (3.49%) Data Structures
1 3 (3.49%) SWIFT
2 2 (2.33%) Analytical Skills
2 2 (2.33%) Greenfield Project
2 2 (2.33%) Management Information System
3 1 (1.16%) Credit Risk
3 1 (1.16%) N-Tier
3 1 (1.16%) Smart City
3 1 (1.16%) Virtual Team
Operating Systems
1 8 (9.30%) Unix
2 5 (5.81%) Linux
Processes & Methodologies
1 36 (41.86%) Agile Software Development
2 19 (22.09%) Business Intelligence
2 19 (22.09%) Test Automation
3 16 (18.60%) Data Modelling
4 14 (16.28%) Analytics
5 13 (15.12%) User Acceptance Testing
6 11 (12.79%) Migration
7 9 (10.47%) Data Migration
8 8 (9.30%) Data Analysis
8 8 (9.30%) Scrum
9 7 (8.14%) Data Architecture
9 7 (8.14%) Visualisation
10 6 (6.98%) Asset Management
10 6 (6.98%) BDD
10 6 (6.98%) Data Integration
10 6 (6.98%) DevOps
10 6 (6.98%) Software Testing
11 5 (5.81%) Test Scripting
12 4 (4.65%) Continuous Integration
12 4 (4.65%) Investment Management
Programming Languages
1 42 (48.84%) SQL
2 9 (10.47%) PL/SQL
3 8 (9.30%) JavaScript
3 8 (9.30%) Python
4 6 (6.98%) Java
4 6 (6.98%) T-SQL
5 2 (2.33%) Bash Shell
5 2 (2.33%) C++
6 1 (1.16%) ANSI SQL
6 1 (1.16%) C#
6 1 (1.16%) COBOL
6 1 (1.16%) JCL
6 1 (1.16%) R
Qualifications
1 3 (3.49%) Postgraduate
1 3 (3.49%) Security Cleared
2 2 (2.33%) ISTQB
2 2 (2.33%) ISTQB Advanced Certification
3 1 (1.16%) APMP
3 1 (1.16%) Degree
3 1 (1.16%) Oracle Certification
Quality Assurance & Compliance
1 6 (6.98%) Data Quality
2 4 (4.65%) QA
3 2 (2.33%) Disclosure Scotland
4 1 (1.16%) BS7666
4 1 (1.16%) GDPR
System Software
1 5 (5.81%) Docker
2 3 (3.49%) VMware Infrastructure
3 2 (2.33%) Virtual Machines
Systems Management
1 5 (5.81%) Ansible
Vendors
1 16 (18.60%) Oracle
2 14 (16.28%) Teradata
3 12 (13.95%) Informatica
4 7 (8.14%) Microsoft
5 4 (4.65%) Google
5 4 (4.65%) Tableau
6 3 (3.49%) Charles River
6 3 (3.49%) HP
6 3 (3.49%) Pega
6 3 (3.49%) VMware
7 2 (2.33%) Ab Initio
7 2 (2.33%) Cloudera
7 2 (2.33%) SAP
7 2 (2.33%) Talend
8 1 (1.16%) Alteryx
8 1 (1.16%) CA
8 1 (1.16%) IBM
8 1 (1.16%) Netezza
8 1 (1.16%) RedGate