Period
to 19 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 19 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Scotland > Edinburgh
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 53 77 74
Rank change year-on-year +24 -3 +46
Permanent jobs citing ETL 115 67 94
As % of all permanent IT jobs advertised in Edinburgh 4.29% 2.91% 3.07%
As % of the Processes & Methodologies category 4.71% 3.15% 3.35%
Number of salaries quoted 52 51 92
Edinburgh median annual salary £45,000 £55,000 £47,500
Median salary % change year-on-year -18.18% +15.79% +8.57%
10th Percentile £32,050 £40,000 £37,120
90th Percentile £75,000 £75,000 £68,750
Scotland median annual salary £45,000 £50,000 £47,500
% change year-on-year -10.00% +5.26% +5.56%

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

All Process and Methodology Skills
Edinburgh
Permanent vacancies with a requirement for process or methodology skills 2442 2126 2803
As % of all permanent IT jobs advertised in Edinburgh 91.12% 92.43% 91.66%
Number of salaries quoted 1470 1380 1770
Edinburgh median annual salary £42,500 £45,000 £43,000
Median salary % change year-on-year -5.56% +4.65% +2.38%
10th Percentile £27,000 £29,715 £27,500
90th Percentile £66,250 £70,000 £65,000
Scotland median annual salary £45,000 £44,000 £42,500
% change year-on-year +2.27% +3.53% +2.41%

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
Salary Trend in Edinburgh

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL in Edinburgh.

Salary trend for ETL in Edinburgh

ETL
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing ETL in Edinburgh over the 6 months to 19 November 2017.

Salary histogram for ETL in Edinburgh

For the 6 months to 19 November 2017, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Edinburgh region with a requirement for ETL.

1 73 (63.48%) Business Intelligence
2 58 (50.43%) SQL
3 50 (43.48%) Finance
4 45 (39.13%) SQL Server Integration Services
5 39 (33.91%) Data Warehouse
6 37 (32.17%) Oracle
7 35 (30.43%) SQL Server
8 32 (27.83%) Degree
9 31 (26.96%) Tableau
10 28 (24.35%) Analytical Skills
10 28 (24.35%) Informatica
10 28 (24.35%) MicroStrategy
11 27 (23.48%) Teradata
12 25 (21.74%) Banking
13 24 (20.87%) Microsoft
13 24 (20.87%) T-SQL
13 24 (20.87%) Cognos
14 23 (20.00%) Stakeholder Management
14 23 (20.00%) Information Management
14 23 (20.00%) SQL Server Reporting Services
14 23 (20.00%) Agile Software Development
15 20 (17.39%) Data Integration
15 20 (17.39%) Data Quality
16 19 (16.52%) Project Management
17 18 (15.65%) Analytics
18 17 (14.78%) Infrastructure Management
18 17 (14.78%) Mentoring
18 17 (14.78%) People Management
18 17 (14.78%) SAS
18 17 (14.78%) Software Testing

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 17 (14.78%) SAS
2 13 (11.30%) Apache Spark
3 1 (0.87%) Confluence
Business Applications
1 4 (3.48%) Cognos Business Intelligence
2 2 (1.74%) BusinessWorks
Cloud Services
1 10 (8.70%) iPaaS
2 3 (2.61%) Google Cloud Platform
3 1 (0.87%) Amazon AWS
3 1 (0.87%) Microsoft Azure
Communications & Networking
1 1 (0.87%) Internet
Database & Business Intelligence
1 45 (39.13%) SQL Server Integration Services
2 39 (33.91%) Data Warehouse
3 35 (30.43%) SQL Server
4 23 (20.00%) SQL Server Reporting Services
5 17 (14.78%) BODI
5 17 (14.78%) Oracle OWB
6 16 (13.91%) SQL Server 2012
7 12 (10.43%) PostgreSQL
8 11 (9.57%) MongoDB
9 10 (8.70%) SAP Data Services
9 10 (8.70%) SAP HANA
10 9 (7.83%) BusinessObjects
10 9 (7.83%) Power BI
11 8 (6.96%) PowerCenter
12 7 (6.09%) Base SAS
12 7 (6.09%) Big Data
12 7 (6.09%) QlikView
13 6 (5.22%) Oracle Database
13 6 (5.22%) SAS Enterprise Guide
14 5 (4.35%) SAS EBI
Development Applications
1 14 (12.17%) Team Foundation Server
2 4 (3.48%) Oracle Forms
3 1 (0.87%) JIRA
3 1 (0.87%) SQL Server Management Studio (SSMS)
General
1 50 (43.48%) Finance
2 25 (21.74%) Banking
3 1 (0.87%) Investment Banking
3 1 (0.87%) Local Government
3 1 (0.87%) Manufacturing
3 1 (0.87%) Retail
3 1 (0.87%) Retail Banking
3 1 (0.87%) Telecoms
Job Titles
1 43 (37.39%) Developer
2 35 (30.43%) Consultant
3 26 (22.61%) SQL Developer
4 22 (19.13%) Business Intelligence Developer
5 21 (18.26%) Teradata Consultant
6 20 (17.39%) SSIS Developer
7 19 (16.52%) SQL BI Developer
8 16 (13.91%) SQL Server BI Developer
8 16 (13.91%) SQL Server Developer
9 13 (11.30%) Architect
10 11 (9.57%) SSRS Developer
11 10 (8.70%) Data Scientist
11 10 (8.70%) Integration Architect
11 10 (8.70%) SAP Architect
11 10 (8.70%) SAP Technical Architect
11 10 (8.70%) Technical Architect
12 8 (6.96%) Analyst
12 8 (6.96%) Data Warehouse Developer
12 8 (6.96%) ETL Developer
13 7 (6.09%) Data Warehouse Consultant
Libraries, Frameworks & Software Standards
1 10 (8.70%) NumPy
2 5 (4.35%) AngularJS
2 5 (4.35%) Django
2 5 (4.35%) MLlib
2 5 (4.35%) SciPy
3 4 (3.48%) .NET
4 3 (2.61%) Middleware
5 2 (1.74%) ASP.NET
5 2 (1.74%) CSS
5 2 (1.74%) JMS
5 2 (1.74%) TIBCO EMS
5 2 (1.74%) Web Services
6 1 (0.87%) HTML
Miscellaneous
1 28 (24.35%) Analytical Skills
2 10 (8.70%) Hybrid Cloud
3 4 (3.48%) Computer Science
4 3 (2.61%) Credit Risk
4 3 (2.61%) Driving Licence
4 3 (2.61%) N-Tier
5 1 (0.87%) Greenfield Project
5 1 (0.87%) Mainframe
Operating Systems
1 11 (9.57%) Linux
2 4 (3.48%) Unix
3 1 (0.87%) Windows
Processes & Methodologies
1 73 (63.48%) Business Intelligence
2 23 (20.00%) Agile Software Development
2 23 (20.00%) Information Management
2 23 (20.00%) Stakeholder Management
3 20 (17.39%) Data Integration
4 19 (16.52%) Project Management
5 18 (15.65%) Analytics
6 17 (14.78%) Infrastructure Management
6 17 (14.78%) Mentoring
6 17 (14.78%) People Management
6 17 (14.78%) Software Testing
7 15 (13.04%) Integration Testing
7 15 (13.04%) System Integration Testing
8 13 (11.30%) Data Management
8 13 (11.30%) Data Modelling
9 12 (10.43%) Data Migration
9 12 (10.43%) Migration
9 12 (10.43%) Visualisation
10 11 (9.57%) Data Analysis
10 11 (9.57%) Mathematics
Programming Languages
1 58 (50.43%) SQL
2 24 (20.87%) T-SQL
3 15 (13.04%) Python
4 8 (6.96%) R
5 5 (4.35%) C#
5 5 (4.35%) PL/SQL
6 3 (2.61%) COBOL
6 3 (2.61%) JCL
7 2 (1.74%) Java
7 2 (1.74%) Scala
8 1 (0.87%) JavaScript
8 1 (0.87%) SAS Macro
Qualifications
1 32 (27.83%) Degree
2 1 (0.87%) Computer Science Degree
2 1 (0.87%) Microsoft Certification
Quality Assurance & Compliance
1 20 (17.39%) Data Quality
2 1 (0.87%) Disclosure Scotland
2 1 (0.87%) GDPR
2 1 (0.87%) SLA
Vendors
1 37 (32.17%) Oracle
2 31 (26.96%) Tableau
3 28 (24.35%) Informatica
3 28 (24.35%) MicroStrategy
4 27 (23.48%) Teradata
5 24 (20.87%) Cognos
5 24 (20.87%) Microsoft
6 10 (8.70%) SAP
7 6 (5.22%) Netezza
8 5 (4.35%) IBM
9 3 (2.61%) Google
9 3 (2.61%) Perforce
10 2 (1.74%) Ab Initio
10 2 (1.74%) TIBCO
11 1 (0.87%) Capita