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

Extract, Transform and Load (ETL)
Scotland > Edinburgh
6 months to
23 Jan 2018
Same period 2017 Same period 2016
Rank 52 81 47
Rank change year-on-year +29 -34 +59
Permanent jobs citing ETL 113 48 124
As % of all permanent IT jobs advertised in Edinburgh 4.25% 2.20% 4.46%
As % of the Processes & Methodologies category 4.65% 2.37% 4.88%
Number of salaries quoted 58 41 128
Edinburgh median annual salary £45,000 £55,000 £47,500
Median salary % change year-on-year -18.18% +15.79% +7.95%
10th Percentile £31,400 £36,250 £37,120
90th Percentile £62,875 £75,000 £65,000
Scotland median annual salary £45,000 £50,000 £47,500
% change year-on-year -10.00% +5.26% +11.76%

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,430 2,024 2,542
As % of all permanent IT jobs advertised in Edinburgh 91.46% 92.72% 91.41%
Number of salaries quoted 1,519 1,354 1,617
Edinburgh median annual salary £44,500 £45,000 £45,000
Median salary % change year-on-year -1.11% - +5.88%
10th Percentile £27,500 £30,000 £28,750
90th Percentile £66,750 £70,000 £66,100
Scotland median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

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 23 January 2018.

Salary histogram for ETL in Edinburgh

For the 6 months to 23 January 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 68 (60.18%) SQL
1 68 (60.18%) Business Intelligence
2 57 (50.44%) Finance
3 45 (39.82%) SQL Server Integration Services
4 41 (36.28%) Oracle
5 39 (34.51%) SQL Server
6 32 (28.32%) Data Warehouse
7 28 (24.78%) Banking
8 27 (23.89%) Tableau
9 26 (23.01%) SQL Server Reporting Services
10 25 (22.12%) Cognos
10 25 (22.12%) T-SQL
10 25 (22.12%) Degree
11 24 (21.24%) Analytics
11 24 (21.24%) Analytical Skills
11 24 (21.24%) Microsoft
11 24 (21.24%) Stakeholder Management
12 23 (20.35%) Teradata
12 23 (20.35%) MicroStrategy
13 22 (19.47%) Data Modelling
14 21 (18.58%) Informatica
15 18 (15.93%) Project Management
16 16 (14.16%) Data Analysis
16 16 (14.16%) Software Testing
16 16 (14.16%) Oracle OWB
16 16 (14.16%) BODI
16 16 (14.16%) People Management
16 16 (14.16%) Mentoring
16 16 (14.16%) Infrastructure Management
16 16 (14.16%) SQL Server 2012

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 15 (13.27%) SAS
2 13 (11.50%) Apache Spark
3 1 (0.88%) Confluence
3 1 (0.88%) Oracle SOA Suite
Business Applications
1 7 (6.19%) Cognos Business Intelligence
2 2 (1.77%) Cognos TM1
2 2 (1.77%) Dynamics AX
3 1 (0.88%) BusinessWorks
Cloud Services
1 5 (4.42%) iPaaS
2 4 (3.54%) Google Cloud Platform
3 2 (1.77%) Microsoft Azure
4 1 (0.88%) Amazon AWS
Communications & Networking
1 1 (0.88%) Internet
Database & Business Intelligence
1 45 (39.82%) SQL Server Integration Services
2 39 (34.51%) SQL Server
3 32 (28.32%) Data Warehouse
4 26 (23.01%) SQL Server Reporting Services
5 16 (14.16%) BODI
5 16 (14.16%) Oracle OWB
5 16 (14.16%) SQL Server 2012
6 13 (11.50%) Power BI
7 10 (8.85%) Hadoop
7 10 (8.85%) Oracle Database
8 9 (7.96%) Big Data
8 9 (7.96%) PostgreSQL
8 9 (7.96%) QlikView
9 8 (7.08%) Base SAS
9 8 (7.08%) Oracle Database 11g
9 8 (7.08%) Oracle Database 12c
9 8 (7.08%) SAS Enterprise Guide
10 7 (6.19%) MongoDB
10 7 (6.19%) Relational Database
11 6 (5.31%) Cognos Analysis Studio
Development Applications
1 13 (11.50%) Team Foundation Server
2 8 (7.08%) Oracle Forms
3 1 (0.88%) ERwin
3 1 (0.88%) JIRA
3 1 (0.88%) SQL Server Management Studio (SSMS)
General
1 57 (50.44%) Finance
2 28 (24.78%) Banking
3 2 (1.77%) Manufacturing
4 1 (0.88%) Investment Banking
4 1 (0.88%) Retail
4 1 (0.88%) Retail Banking
4 1 (0.88%) Telecoms
Job Titles
1 41 (36.28%) Developer
2 29 (25.66%) SQL Developer
3 25 (22.12%) Consultant
4 23 (20.35%) Business Intelligence Developer
5 20 (17.70%) Teradata Consultant
6 19 (16.81%) SQL BI Developer
6 19 (16.81%) SSIS Developer
7 15 (13.27%) SQL Server BI Developer
7 15 (13.27%) SQL Server Developer
8 14 (12.39%) Analyst
9 13 (11.50%) Data Analyst
10 11 (9.73%) SSRS Developer
11 9 (7.96%) Architect
12 8 (7.08%) Oracle Developer
13 7 (6.19%) Data Warehouse Developer
14 6 (5.31%) Data Scientist
15 5 (4.42%) Business Intelligence Consultant
15 5 (4.42%) SAP Architect
15 5 (4.42%) SAS Data Analyst
15 5 (4.42%) Senior Analyst
Libraries, Frameworks & Software Standards
1 6 (5.31%) NumPy
2 4 (3.54%) .NET
3 3 (2.65%) AngularJS
3 3 (2.65%) Django
3 3 (2.65%) Middleware
3 3 (2.65%) MLlib
3 3 (2.65%) SciPy
4 2 (1.77%) CSS
4 2 (1.77%) HTML
4 2 (1.77%) Kafka
4 2 (1.77%) MDX
5 1 (0.88%) ASP.NET
5 1 (0.88%) JMS
5 1 (0.88%) PostGIS
5 1 (0.88%) TIBCO EMS
5 1 (0.88%) Web Services
Miscellaneous
1 24 (21.24%) Analytical Skills
2 6 (5.31%) Computer Science
3 5 (4.42%) Credit Risk
3 5 (4.42%) Hybrid Cloud
4 3 (2.65%) N-Tier
5 2 (1.77%) Driving Licence
6 1 (0.88%) Greenfield Project
6 1 (0.88%) Mainframe
6 1 (0.88%) Management Information System
6 1 (0.88%) Taxonomies
Operating Systems
1 11 (9.73%) Linux
2 5 (4.42%) Unix
3 1 (0.88%) Windows
Processes & Methodologies
1 68 (60.18%) Business Intelligence
2 24 (21.24%) Analytics
2 24 (21.24%) Stakeholder Management
3 22 (19.47%) Data Modelling
4 18 (15.93%) Project Management
5 16 (14.16%) Data Analysis
5 16 (14.16%) Infrastructure Management
5 16 (14.16%) Mentoring
5 16 (14.16%) People Management
5 16 (14.16%) Software Testing
6 15 (13.27%) Data Integration
7 14 (12.39%) Agile Software Development
8 13 (11.50%) Integration Testing
8 13 (11.50%) System Integration Testing
9 12 (10.62%) Visualisation
10 10 (8.85%) Information Management
11 8 (7.08%) Data Management
11 8 (7.08%) Migration
12 7 (6.19%) Data Migration
12 7 (6.19%) Software Engineering
Programming Languages
1 68 (60.18%) SQL
2 25 (22.12%) T-SQL
3 15 (13.27%) Python
4 9 (7.96%) PL/SQL
5 7 (6.19%) R
6 5 (4.42%) C#
7 3 (2.65%) COBOL
7 3 (2.65%) JCL
8 2 (1.77%) Java
8 2 (1.77%) JavaScript
8 2 (1.77%) Scala
9 1 (0.88%) Bash Shell
9 1 (0.88%) C++
9 1 (0.88%) MATLAB
Qualifications
1 25 (22.12%) Degree
2 1 (0.88%) Computer Science Degree
2 1 (0.88%) Microsoft Certification
2 1 (0.88%) Postgraduate
Quality Assurance & Compliance
1 9 (7.96%) Data Quality
2 1 (0.88%) BS7666
2 1 (0.88%) Disclosure Scotland
2 1 (0.88%) GDPR
2 1 (0.88%) QA
2 1 (0.88%) SLA
System Software
1 1 (0.88%) Docker
Systems Management
1 1 (0.88%) Ansible
Vendors
1 41 (36.28%) Oracle
2 27 (23.89%) Tableau
3 25 (22.12%) Cognos
4 24 (21.24%) Microsoft
5 23 (20.35%) MicroStrategy
5 23 (20.35%) Teradata
6 21 (18.58%) Informatica
7 8 (7.08%) IBM
8 5 (4.42%) SAP
9 4 (3.54%) Google
9 4 (3.54%) Perforce
10 3 (2.65%) Capita
11 2 (1.77%) Ab Initio
12 1 (0.88%) CA
12 1 (0.88%) Cloudera
12 1 (0.88%) Netezza
12 1 (0.88%) ServiceNow
12 1 (0.88%) SolarWinds
12 1 (0.88%) Talend
12 1 (0.88%) TIBCO