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

Extract, Transform and Load (ETL)
Scotland > Edinburgh
6 months to
22 Oct 2018
Same period 2017 Same period 2016
Rank 89 56 71
Rank change year-on-year -33 +15 -4
Permanent jobs citing ETL 58 115 64
As % of all permanent IT jobs advertised in Edinburgh 2.29% 4.27% 2.80%
As % of the Processes & Methodologies category 2.46% 4.59% 3.00%
Number of salaries quoted 45 51 46
Edinburgh median annual salary £45,000 £45,000 £55,000
Median salary % change year-on-year - -18.18% +15.79%
10th Percentile £32,500 £32,000 £40,000
90th Percentile £68,750 £78,750 £75,000
Scotland median annual salary £45,000 £45,000 £50,000
% change year-on-year - -10.00% +11.11%

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,359 2,504 2,133
As % of all permanent IT jobs advertised in Edinburgh 93.02% 93.05% 93.31%
Number of salaries quoted 1,422 1,500 1,358
Edinburgh median annual salary £47,500 £42,500 £45,000
Median salary % change year-on-year +11.76% -5.56% +5.88%
10th Percentile £29,250 £27,500 £29,000
90th Percentile £75,000 £66,250 £70,000
Scotland median annual salary £45,500 £44,000 £44,000
% change year-on-year +3.41% - +3.53%

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 22 October 2018.

Salary histogram for ETL in Edinburgh

For the 6 months to 22 October 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 46 (79.31%) SQL
2 25 (43.10%) Data Warehouse
3 23 (39.66%) Finance
4 21 (36.21%) Analytics
5 20 (34.48%) Business Intelligence
6 19 (32.76%) Oracle
7 16 (27.59%) SQL Server
7 16 (27.59%) Data Modelling
8 15 (25.86%) SQL Server Integration Services
9 13 (22.41%) Unix
10 12 (20.69%) T-SQL
10 12 (20.69%) Python
10 12 (20.69%) Agile Software Development
11 11 (18.97%) Banking
11 11 (18.97%) SAS
12 10 (17.24%) Java
12 10 (17.24%) Microsoft
12 10 (17.24%) Amazon AWS
13 9 (15.52%) Big Data
13 9 (15.52%) Relational Database
14 8 (13.79%) Oracle Database
14 8 (13.79%) Amazon EMR
14 8 (13.79%) Oozie
14 8 (13.79%) Apache Pig
14 8 (13.79%) Apache Hive
14 8 (13.79%) SAS Data Integration Studio
14 8 (13.79%) Apache Spark
14 8 (13.79%) JavaScript
15 7 (12.07%) Linux
15 7 (12.07%) Visual Studio

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 11 (18.97%) SAS
2 8 (13.79%) Apache Pig
2 8 (13.79%) Apache Spark
3 1 (1.72%) Apache
3 1 (1.72%) PowerExchange
Business Applications
1 1 (1.72%) Eloqua
Cloud Services
1 10 (17.24%) Amazon AWS
2 8 (13.79%) Amazon EMR
3 6 (10.34%) Amazon EC2
3 6 (10.34%) Amazon S3
3 6 (10.34%) AWS Lambda
3 6 (10.34%) Serverless
4 5 (8.62%) Microsoft Azure
5 2 (3.45%) Amazon CloudWatch
5 2 (3.45%) Amazon ElastiCache
5 2 (3.45%) Amazon ELB
5 2 (3.45%) AWS CloudFormation
5 2 (3.45%) AWS CodePipeline
5 2 (3.45%) AWS Elastic Beanstalk
5 2 (3.45%) Datadog
5 2 (3.45%) GitHub
5 2 (3.45%) Google Cloud Platform
5 2 (3.45%) Sumo Logic
5 2 (3.45%) Virtual Private Cloud
6 1 (1.72%) AWS Data Pipeline
Communications & Networking
1 1 (1.72%) DNS
Database & Business Intelligence
1 25 (43.10%) Data Warehouse
2 16 (27.59%) SQL Server
3 15 (25.86%) SQL Server Integration Services
4 9 (15.52%) Big Data
4 9 (15.52%) Relational Database
5 8 (13.79%) Apache Hive
5 8 (13.79%) Oracle Database
5 8 (13.79%) SAS Data Integration Studio
6 7 (12.07%) Hadoop
6 7 (12.07%) SSDT
7 6 (10.34%) Amazon RDS
7 6 (10.34%) SAS EBI
7 6 (10.34%) SAS Visual Analytics
7 6 (10.34%) Star Schema
8 5 (8.62%) Amazon Redshift
8 5 (8.62%) SQL Server Analysis Services
8 5 (8.62%) SQL Server Reporting Services
8 5 (8.62%) Sqoop
9 4 (6.90%) Oracle Database 11g
10 3 (5.17%) PowerCenter
Development Applications
1 7 (12.07%) Visual Studio
2 5 (8.62%) Jenkins
3 4 (6.90%) Git (software)
3 4 (6.90%) Oracle Forms
3 4 (6.90%) SQL Server Management Studio (SSMS)
4 3 (5.17%) Atlassian Bamboo
5 2 (3.45%) Bitbucket
5 2 (3.45%) GitLab
5 2 (3.45%) Team Foundation Server
5 2 (3.45%) Travis CI
6 1 (1.72%) CA Release Automation
6 1 (1.72%) ER Studio
6 1 (1.72%) ERwin
6 1 (1.72%) Hudson
6 1 (1.72%) TeamCity
6 1 (1.72%) Toad
General
1 23 (39.66%) Finance
2 11 (18.97%) Banking
3 5 (8.62%) Marketing
4 3 (5.17%) Retail Banking
5 1 (1.72%) Financial Institution
5 1 (1.72%) Investment Banking
5 1 (1.72%) Retail
Job Titles
1 18 (31.03%) Consultant
1 18 (31.03%) Developer
2 8 (13.79%) Analyst
3 6 (10.34%) Data Consultant
3 6 (10.34%) Oracle Developer
3 6 (10.34%) SAS Consultant
4 5 (8.62%) AWS Consultant
4 5 (8.62%) Business Intelligence Analyst
4 5 (8.62%) Database Developer
4 5 (8.62%) Test Analyst
5 4 (6.90%) Data Engineer
5 4 (6.90%) SQL Developer
6 3 (5.17%) Ab Initio Developer
6 3 (5.17%) AWS Engineer
6 3 (5.17%) Big Data Consultant
6 3 (5.17%) Cloud Engineer
6 3 (5.17%) Microsoft Consultant
6 3 (5.17%) Senior Cloud Engineer
6 3 (5.17%) SQL Database Developer
6 3 (5.17%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 5 (8.62%) .NET
1 5 (8.62%) Kafka
2 4 (6.90%) Node.js
3 3 (5.17%) ASP.NET
3 3 (5.17%) Elastic Stack
3 3 (5.17%) Web Services
4 1 (1.72%) CSS
4 1 (1.72%) HTML
4 1 (1.72%) OpenGL
4 1 (1.72%) PostGIS
Miscellaneous
1 6 (10.34%) Mainframe
2 3 (5.17%) Computer Science
2 3 (5.17%) Greenfield Project
2 3 (5.17%) Public Cloud
3 2 (3.45%) Analytical Skills
3 2 (3.45%) Enterprise Cloud
3 2 (3.45%) Linux Command Line
3 2 (3.45%) Self-Motivation
4 1 (1.72%) Analytical Mindset
4 1 (1.72%) Augmented Reality
4 1 (1.72%) Data Structures
4 1 (1.72%) Fintech
4 1 (1.72%) Private Cloud
4 1 (1.72%) Social Media
Operating Systems
1 13 (22.41%) Unix
2 7 (12.07%) Linux
3 6 (10.34%) Windows
4 2 (3.45%) AIX
5 1 (1.72%) CentOS
5 1 (1.72%) Red Hat Enterprise Linux
5 1 (1.72%) Ubuntu
Processes & Methodologies
1 21 (36.21%) Analytics
2 20 (34.48%) Business Intelligence
3 16 (27.59%) Data Modelling
4 12 (20.69%) Agile Software Development
5 7 (12.07%) Data Analysis
5 7 (12.07%) Data Analytics
5 7 (12.07%) ETL Development
6 6 (10.34%) Creative Thinking
6 6 (10.34%) Software Engineering
6 6 (10.34%) Statistics
6 6 (10.34%) Visual Analytics
7 5 (8.62%) Data Science
7 5 (8.62%) Migration
7 5 (8.62%) Problem-Solving
8 4 (6.90%) Configuration Management
8 4 (6.90%) Data Architecture
8 4 (6.90%) Test Automation
9 3 (5.17%) Change Data Capture
9 3 (5.17%) Digital Marketing
9 3 (5.17%) System Testing
Programming Languages
1 46 (79.31%) SQL
2 12 (20.69%) Python
2 12 (20.69%) T-SQL
3 10 (17.24%) Java
4 8 (13.79%) JavaScript
5 7 (12.07%) R
6 6 (10.34%) Ruby
6 6 (10.34%) Scala
7 5 (8.62%) Bash Shell
7 5 (8.62%) C#
8 4 (6.90%) PL/SQL
9 2 (3.45%) Go
9 2 (3.45%) PHP
10 1 (1.72%) C++
10 1 (1.72%) Perl
Qualifications
1 3 (5.17%) Degree
2 2 (3.45%) Numerate Degree
3 1 (1.72%) Computer Science Degree
3 1 (1.72%) Security Cleared
Quality Assurance & Compliance
1 4 (6.90%) Data Quality
System Software
1 5 (8.62%) Docker
1 5 (8.62%) HDFS
2 2 (3.45%) Tivoli Workload Scheduler
Systems Management
1 8 (13.79%) Oozie
2 4 (6.90%) Ansible
2 4 (6.90%) Puppet
2 4 (6.90%) Terraform
3 3 (5.17%) Kubernetes
3 3 (5.17%) Opscode Chef
4 2 (3.45%) Grafana
4 2 (3.45%) Prometheus
4 2 (3.45%) Sysdig
4 2 (3.45%) Tivoli
5 1 (1.72%) Docker Swarm
5 1 (1.72%) Mesos
5 1 (1.72%) Rundeck
5 1 (1.72%) Systems Management Server (SMS)
Vendors
1 19 (32.76%) Oracle
2 10 (17.24%) Microsoft
3 5 (8.62%) Informatica
4 4 (6.90%) Teradata
5 3 (5.17%) Ab Initio
5 3 (5.17%) IBM
6 2 (3.45%) Google
6 2 (3.45%) Splunk
7 1 (1.72%) CA
7 1 (1.72%) Cloudera
7 1 (1.72%) Cognos
7 1 (1.72%) Red Hat
7 1 (1.72%) Salesforce.com
7 1 (1.72%) Tableau
7 1 (1.72%) Talend