Period
to 16 July 2018

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 16 July 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Scotland > Edinburgh
6 months to
16 Jul 2018
Same period 2017 Same period 2016
Rank 74 65 62
Rank change year-on-year -9 -3 +13
Permanent jobs citing ETL 84 84 84
As % of all permanent IT jobs advertised in Edinburgh 3.12% 3.42% 3.25%
As % of the Processes & Methodologies category 3.34% 3.68% 3.52%
Number of salaries quoted 81 48 69
Edinburgh median annual salary £42,500 £45,000 £52,500
Median salary % change year-on-year -5.56% -14.29% +10.53%
10th Percentile £28,250 £35,350 £37,250
90th Percentile £70,000 £81,250 £65,000
Scotland median annual salary £44,000 £45,000 £47,500
% change year-on-year -2.22% -5.26% +7.95%

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 2,514 2,282 2,386
As % of all permanent IT jobs advertised in Edinburgh 93.32% 92.92% 92.37%
Number of salaries quoted 1,580 1,431 1,474
Edinburgh median annual salary £45,830 £45,000 £45,000
Median salary % change year-on-year +1.84% - +2.27%
10th Percentile £28,250 £28,000 £27,500
90th Percentile £72,500 £72,500 £68,750
Scotland median annual salary £45,000 £45,000 £45,000

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 16 July 2018.

Salary histogram for ETL in Edinburgh

For the 6 months to 16 July 2018, IT 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 permanent job ads across the Edinburgh region with a requirement for ETL.

1 57 (67.86%) SQL
2 47 (55.95%) Business Intelligence
3 35 (41.67%) Data Modelling
4 29 (34.52%) Microsoft
5 26 (30.95%) Finance
6 25 (29.76%) Data Warehouse
7 23 (27.38%) SAS
7 23 (27.38%) Oracle
7 23 (27.38%) Relational Database
8 22 (26.19%) Data Integration
8 22 (26.19%) Analytics
9 19 (22.62%) SQL Server
10 18 (21.43%) Data Virtualisation
11 16 (19.05%) SQL Server Integration Services
12 15 (17.86%) Python
12 15 (17.86%) R
13 14 (16.67%) Data Architecture
14 12 (14.29%) Informatica
15 11 (13.10%) Unix
15 11 (13.10%) Data Analytics
15 11 (13.10%) Apache Spark
16 10 (11.90%) Statistics
16 10 (11.90%) Creative Thinking
17 9 (10.71%) Problem-Solving
17 9 (10.71%) Agile Software Development
17 9 (10.71%) Banking
17 9 (10.71%) Data Analysis
17 9 (10.71%) RDBMS
18 8 (9.52%) Degree
18 8 (9.52%) Master Data 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 23 (27.38%) SAS
2 11 (13.10%) Apache Spark
3 5 (5.95%) Apache Pig
4 2 (2.38%) Apache
5 1 (1.19%) CMS
5 1 (1.19%) JBoss
5 1 (1.19%) nginx
5 1 (1.19%) Tomcat
Business Applications
1 4 (4.76%) Cognos Business Intelligence
2 1 (1.19%) Cognos TM1
2 1 (1.19%) Eloqua
Cloud Services
1 7 (8.33%) Amazon AWS
2 5 (5.95%) Amazon EMR
3 4 (4.76%) Amazon EC2
3 4 (4.76%) Amazon S3
3 4 (4.76%) AWS Lambda
3 4 (4.76%) Microsoft Azure
3 4 (4.76%) Serverless
4 3 (3.57%) Google Cloud Platform
5 2 (2.38%) Amazon ElastiCache
5 2 (2.38%) Amazon ELB
5 2 (2.38%) Virtual Private Cloud
6 1 (1.19%) AWS Data Pipeline
6 1 (1.19%) Cortana Intelligence Suite
Communications & Networking
1 1 (1.19%) DMZ
1 1 (1.19%) F5 BIG-IP GTM
1 1 (1.19%) F5 BIG-IP LTM
1 1 (1.19%) HTTP
1 1 (1.19%) Network Security
Database & Business Intelligence
1 25 (29.76%) Data Warehouse
2 23 (27.38%) Relational Database
3 19 (22.62%) SQL Server
4 16 (19.05%) SQL Server Integration Services
5 9 (10.71%) RDBMS
6 8 (9.52%) SAS Data Integration Studio
7 7 (8.33%) Hadoop
7 7 (8.33%) SQL Server Reporting Services
8 6 (7.14%) Apache Hive
8 6 (7.14%) Big Data
8 6 (7.14%) Oracle Database
8 6 (7.14%) SAS EBI
8 6 (7.14%) SAS Visual Analytics
8 6 (7.14%) Star Schema
9 5 (5.95%) Amazon Redshift
9 5 (5.95%) DB2
9 5 (5.95%) MongoDB
9 5 (5.95%) PostgreSQL
9 5 (5.95%) Sqoop
10 4 (4.76%) Amazon RDS
Development Applications
1 4 (4.76%) SQL Server Management Studio (SSMS)
1 4 (4.76%) Team Foundation Server
1 4 (4.76%) Visual Studio
2 3 (3.57%) Oracle Forms
3 2 (2.38%) Git (software)
4 1 (1.19%) Jenkins
4 1 (1.19%) JIRA
General
1 26 (30.95%) Finance
2 9 (10.71%) Banking
3 3 (3.57%) Financial Institution
4 1 (1.19%) Investment Banking
4 1 (1.19%) Legal
4 1 (1.19%) Manufacturing
4 1 (1.19%) Marketing
Job Titles
1 29 (34.52%) Analyst
2 21 (25.00%) Developer
3 17 (20.24%) Consultant
4 11 (13.10%) Data Analyst
5 10 (11.90%) Data Integration Developer
5 10 (11.90%) Integration Developer
6 9 (10.71%) Senior Analyst
7 8 (9.52%) Integration Analyst
7 8 (9.52%) Senior Integration Analyst
8 7 (8.33%) Business Intelligence Analyst
9 6 (7.14%) SAS Consultant
10 5 (5.95%) AWS Consultant
10 5 (5.95%) Oracle Developer
10 5 (5.95%) Test Analyst
11 4 (4.76%) Business Intelligence Consultant
11 4 (4.76%) Business Test Analyst
11 4 (4.76%) Data Scientist
11 4 (4.76%) Migration Analyst
12 3 (3.57%) SQL Analyst
12 3 (3.57%) Technical Leader
Libraries, Frameworks & Software Standards
1 5 (5.95%) Kafka
2 4 (4.76%) MLlib
2 4 (4.76%) NumPy
2 4 (4.76%) SciPy
3 2 (2.38%) .NET
3 2 (2.38%) CSS
3 2 (2.38%) HTML
3 2 (2.38%) Node.js
3 2 (2.38%) OpenGL
3 2 (2.38%) Web Services
4 1 (1.19%) D3.js
4 1 (1.19%) Natural Language Processing
4 1 (1.19%) PostGIS
Miscellaneous
1 6 (7.14%) Mainframe
2 4 (4.76%) Analytical Skills
2 4 (4.76%) Computer Science
3 3 (3.57%) Fintech
3 3 (3.57%) Public Cloud
4 2 (2.38%) Augmented Reality
4 2 (2.38%) Enterprise Cloud
5 1 (1.19%) Analytical Mindset
5 1 (1.19%) Data Structures
5 1 (1.19%) Driving Licence
5 1 (1.19%) Private Cloud
5 1 (1.19%) Self-Motivation
5 1 (1.19%) Social Media
Operating Systems
1 11 (13.10%) Unix
2 6 (7.14%) Windows
3 3 (3.57%) Linux
Processes & Methodologies
1 47 (55.95%) Business Intelligence
2 35 (41.67%) Data Modelling
3 22 (26.19%) Analytics
3 22 (26.19%) Data Integration
4 18 (21.43%) Data Virtualisation
5 14 (16.67%) Data Architecture
6 11 (13.10%) Data Analytics
7 10 (11.90%) Creative Thinking
7 10 (11.90%) Statistics
8 9 (10.71%) Agile Software Development
8 9 (10.71%) Data Analysis
8 9 (10.71%) Problem-Solving
9 8 (9.52%) Data Science
9 8 (9.52%) Master Data Management
10 7 (8.33%) Open Source
10 7 (8.33%) Stakeholder Management
11 6 (7.14%) Mathematics
11 6 (7.14%) Visual Analytics
11 6 (7.14%) Visualisation
12 5 (5.95%) Machine Learning
Programming Languages
1 57 (67.86%) SQL
2 15 (17.86%) Python
2 15 (17.86%) R
3 7 (8.33%) T-SQL
4 6 (7.14%) Java
5 4 (4.76%) PL/SQL
5 4 (4.76%) Scala
6 2 (2.38%) Bash Shell
6 2 (2.38%) C#
6 2 (2.38%) C++
6 2 (2.38%) JavaScript
6 2 (2.38%) PHP
6 2 (2.38%) Ruby
7 1 (1.19%) Data Analysis Expressions (DAX)
7 1 (1.19%) MATLAB
Qualifications
1 8 (9.52%) Degree
2 2 (2.38%) Numerate Degree
2 2 (2.38%) Security Cleared
3 1 (1.19%) Computer Science Degree
Quality Assurance & Compliance
1 5 (5.95%) Data Quality
2 1 (1.19%) Dodd-Frank
2 1 (1.19%) EMIR
2 1 (1.19%) FATCA
2 1 (1.19%) GCP
2 1 (1.19%) MiFID
2 1 (1.19%) Solvency II
System Software
1 5 (5.95%) HDFS
2 2 (2.38%) Docker
Systems Management
1 5 (5.95%) Oozie
2 2 (2.38%) Terraform
3 1 (1.19%) Ansible
3 1 (1.19%) Kubernetes
3 1 (1.19%) Systems Management Server (SMS)
Vendors
1 29 (34.52%) Microsoft
2 23 (27.38%) Oracle
3 12 (14.29%) Informatica
4 7 (8.33%) Tableau
5 6 (7.14%) Talend
6 5 (5.95%) Cognos
7 4 (4.76%) Google
8 3 (3.57%) IBM
9 1 (1.19%) Ab Initio
9 1 (1.19%) Apple
9 1 (1.19%) CA
9 1 (1.19%) Cloudera
9 1 (1.19%) F5
9 1 (1.19%) Netezza
9 1 (1.19%) Salesforce.com
9 1 (1.19%) ServiceNow
9 1 (1.19%) SolarWinds
9 1 (1.19%) Splunk
9 1 (1.19%) Teradata