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

Extract, Transform and Load (ETL)
Scotland > Edinburgh
6 months to
19 Apr 2018
Same period 2017 Same period 2016
Rank 54 84 53
Rank change year-on-year +30 -31 +18
Permanent jobs citing ETL 104 53 110
As % of all permanent IT jobs advertised in Edinburgh 3.93% 2.39% 4.16%
As % of the Processes & Methodologies category 4.30% 2.57% 4.52%
Number of salaries quoted 86 41 121
Edinburgh median annual salary £42,500 £40,000 £47,500
Median salary % change year-on-year +6.25% -15.79% +7.95%
10th Percentile £28,250 £33,250 £41,250
90th Percentile £69,375 £81,250 £65,000
Scotland median annual salary £42,500 £45,000 £47,500
% change year-on-year -5.56% -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,417 2,064 2,434
As % of all permanent IT jobs advertised in Edinburgh 91.45% 93.10% 92.02%
Number of salaries quoted 1,581 1,329 1,621
Edinburgh median annual salary £45,000 £45,000 £45,000
10th Percentile £28,000 £28,950 £28,750
90th Percentile £69,375 £70,000 £67,500
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 19 April 2018.

Salary histogram for ETL in Edinburgh

For the 6 months to 19 April 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 62 (59.62%) SQL
2 61 (58.65%) Business Intelligence
3 42 (40.38%) Data Modelling
4 37 (35.58%) Finance
5 32 (30.77%) Microsoft
6 31 (29.81%) SQL Server
7 30 (28.85%) Data Warehouse
8 27 (25.96%) Oracle
9 26 (25.00%) SAS
9 26 (25.00%) Data Integration
9 26 (25.00%) Analytics
10 23 (22.12%) Relational Database
11 21 (20.19%) SQL Server Integration Services
12 18 (17.31%) Tableau
13 17 (16.35%) Data Virtualisation
14 14 (13.46%) Apache Spark
14 14 (13.46%) Degree
14 14 (13.46%) Data Architecture
14 14 (13.46%) Banking
14 14 (13.46%) Data Analysis
15 13 (12.50%) Python
15 13 (12.50%) Visualisation
16 12 (11.54%) Stakeholder Management
17 11 (10.58%) SQL Server Reporting Services
17 11 (10.58%) T-SQL
17 11 (10.58%) Statistics
18 10 (9.62%) R
18 10 (9.62%) Informatica
18 10 (9.62%) RDBMS
18 10 (9.62%) Agile Software Development

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 26 (25.00%) SAS
2 14 (13.46%) Apache Spark
3 1 (0.96%) Apache
3 1 (0.96%) CMS
3 1 (0.96%) JBoss
3 1 (0.96%) nginx
3 1 (0.96%) Oracle SOA Suite
3 1 (0.96%) Tomcat
Business Applications
1 7 (6.73%) Cognos Business Intelligence
2 3 (2.88%) Cognos TM1
3 2 (1.92%) Dynamics AX
Cloud Services
1 5 (4.81%) Google Cloud Platform
2 4 (3.85%) Microsoft Azure
3 1 (0.96%) Amazon AWS
3 1 (0.96%) Cortana Intelligence Suite
Communications & Networking
1 1 (0.96%) DMZ
1 1 (0.96%) F5 BIG-IP GTM
1 1 (0.96%) F5 BIG-IP LTM
1 1 (0.96%) HTTP
1 1 (0.96%) Network Security
Database & Business Intelligence
1 31 (29.81%) SQL Server
2 30 (28.85%) Data Warehouse
3 23 (22.12%) Relational Database
4 21 (20.19%) SQL Server Integration Services
5 11 (10.58%) SQL Server Reporting Services
6 10 (9.62%) RDBMS
7 9 (8.65%) Hadoop
7 9 (8.65%) Power BI
8 8 (7.69%) Cognos Report Studio
8 8 (7.69%) DB2
8 8 (7.69%) QlikView
8 8 (7.69%) Star Schema
9 7 (6.73%) Cognos Framework Manager
9 7 (6.73%) MongoDB
9 7 (6.73%) PostgreSQL
9 7 (6.73%) SAS EBI
9 7 (6.73%) SAS Visual Analytics
10 6 (5.77%) Base SAS
10 6 (5.77%) Oracle Database 12c
10 6 (5.77%) SAS Enterprise Guide
Development Applications
1 7 (6.73%) Team Foundation Server
2 6 (5.77%) Oracle Forms
3 2 (1.92%) SQL Server Management Studio (SSMS)
3 2 (1.92%) Visual Studio
4 1 (0.96%) ERwin
4 1 (0.96%) Git (software)
4 1 (0.96%) JIRA
General
1 37 (35.58%) Finance
2 14 (13.46%) Banking
3 3 (2.88%) Financial Institution
4 1 (0.96%) Investment Banking
4 1 (0.96%) Legal
4 1 (0.96%) Manufacturing
4 1 (0.96%) Retail Banking
Job Titles
1 33 (31.73%) Analyst
2 29 (27.88%) Developer
3 20 (19.23%) Data Analyst
4 14 (13.46%) SQL Developer
5 13 (12.50%) Senior Analyst
6 11 (10.58%) Consultant
7 9 (8.65%) Data Integration Developer
7 9 (8.65%) Integration Developer
8 8 (7.69%) Integration Analyst
8 8 (7.69%) Senior Integration Analyst
9 7 (6.73%) Business Intelligence Developer
9 7 (6.73%) SAS Consultant
10 6 (5.77%) Data Scientist
10 6 (5.77%) Oracle Developer
10 6 (5.77%) SQL BI Developer
11 5 (4.81%) Data Manager
11 5 (4.81%) SAS Analyst
11 5 (4.81%) SQL Server BI Developer
11 5 (4.81%) SQL Server Developer
11 5 (4.81%) SSIS Developer
Libraries, Frameworks & Software Standards
1 6 (5.77%) NumPy
2 5 (4.81%) MLlib
2 5 (4.81%) SciPy
3 3 (2.88%) Middleware
4 2 (1.92%) CSS
4 2 (1.92%) HTML
4 2 (1.92%) Kafka
4 2 (1.92%) MDX
5 1 (0.96%) .NET
5 1 (0.96%) AngularJS
5 1 (0.96%) D3.js
5 1 (0.96%) Django
5 1 (0.96%) Natural Language Processing
5 1 (0.96%) OpenGL
5 1 (0.96%) PostGIS
Miscellaneous
1 6 (5.77%) Computer Science
2 5 (4.81%) Analytical Skills
2 5 (4.81%) Mainframe
3 4 (3.85%) Credit Risk
4 3 (2.88%) Fintech
4 3 (2.88%) N-Tier
5 1 (0.96%) Augmented Reality
5 1 (0.96%) Driving Licence
5 1 (0.96%) Greenfield Project
5 1 (0.96%) Management Information System
5 1 (0.96%) Self-Motivation
5 1 (0.96%) Taxonomies
Operating Systems
1 7 (6.73%) Linux
1 7 (6.73%) Unix
2 5 (4.81%) Windows
Processes & Methodologies
1 61 (58.65%) Business Intelligence
2 42 (40.38%) Data Modelling
3 26 (25.00%) Analytics
3 26 (25.00%) Data Integration
4 17 (16.35%) Data Virtualisation
5 14 (13.46%) Data Analysis
5 14 (13.46%) Data Architecture
6 13 (12.50%) Visualisation
7 12 (11.54%) Stakeholder Management
8 11 (10.58%) Statistics
9 10 (9.62%) Agile Software Development
9 10 (9.62%) Creative Thinking
10 9 (8.65%) Master Data Management
10 9 (8.65%) Problem-Solving
11 8 (7.69%) Data Analytics
11 8 (7.69%) Machine Learning
11 8 (7.69%) Project Management
12 7 (6.73%) Mathematics
12 7 (6.73%) Visual Analytics
13 6 (5.77%) Applied Mathematics
Programming Languages
1 62 (59.62%) SQL
2 13 (12.50%) Python
3 11 (10.58%) T-SQL
4 10 (9.62%) R
5 8 (7.69%) PL/SQL
6 3 (2.88%) COBOL
6 3 (2.88%) JCL
7 2 (1.92%) C++
7 2 (1.92%) JavaScript
8 1 (0.96%) Bash Shell
8 1 (0.96%) C#
8 1 (0.96%) Data Analysis Expressions (DAX)
8 1 (0.96%) MATLAB
Qualifications
1 14 (13.46%) Degree
2 1 (0.96%) Computer Science Degree
2 1 (0.96%) Postgraduate
2 1 (0.96%) Security Cleared
Quality Assurance & Compliance
1 5 (4.81%) Data Quality
2 1 (0.96%) BS7666
2 1 (0.96%) Dodd-Frank
2 1 (0.96%) EMIR
2 1 (0.96%) FATCA
2 1 (0.96%) GDPR
2 1 (0.96%) MiFID
2 1 (0.96%) QA
2 1 (0.96%) SLA
2 1 (0.96%) Solvency II
System Software
1 1 (0.96%) Docker
Systems Management
1 1 (0.96%) Ansible
Vendors
1 32 (30.77%) Microsoft
2 27 (25.96%) Oracle
3 18 (17.31%) Tableau
4 10 (9.62%) Informatica
5 9 (8.65%) Cognos
6 8 (7.69%) IBM
7 6 (5.77%) Google
7 6 (5.77%) Talend
8 5 (4.81%) MicroStrategy
8 5 (4.81%) Teradata
9 2 (1.92%) Ab Initio
9 2 (1.92%) Capita
9 2 (1.92%) Perforce
10 1 (0.96%) Apple
10 1 (0.96%) CA
10 1 (0.96%) Cloudera
10 1 (0.96%) F5
10 1 (0.96%) Netezza
10 1 (0.96%) SolarWinds
10 1 (0.96%) Splunk