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

Extract, Transform and Load (ETL)
UK / Scotland
3 months to
25 Jun 2017
Same period 2016 Same period 2015
Rank 62 82 71
Rank change year-on-year +20 -11  
Permanent jobs citing ETL 97 83 103
As % of all permanent IT jobs advertised in Scotland 3.66% 2.93% 3.28%
As % of the Processes & Methodologies category 4.00% 3.20% 3.65%
Number of salaries quoted 43 30 69
Median salary £45,000 £51,250 £44,000
Median salary % change year-on-year -12.19% +16.47%  
90% offered a salary of more than £38,000 £38,000 £32,500
10% offered a salary of more than £72,500 £57,300 £57,350
UK excluding London median salary £45,000 £45,000 £45,000

ETL is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Scotland with a requirement for process and methodology skills.

Process & Methodology Skills
Scotland
Permanent job vacancies with a requirement for process and methodology skills 2422 2591 2825
As % of all permanent IT job vacancies advertised in Scotland 91.47% 91.43% 89.83%
Number of salaries quoted 1543 1456 1769
Median salary £45,000 £45,000 £44,000
Median salary % change year-on-year - +2.27%  
90% offered a salary of more than £32,000 £30,000 £32,000
10% offered a salary of more than £69,500 £60,000 £65,000
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year - +2.27%  

ETL
Job Vacancy Trend in Scotland

The job posting trend of jobs advertised in Scotland citing ETL as a proportion of all permanent or contract IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for ETL in Scotland

ETL
Salary Trend in Scotland

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

Salary trend for ETL in Scotland

ETL
Salary Histogram in Scotland

The salary distribution of IT jobs citing ETL in Scotland over the 3 months to 25 June 2017.

Salary histogram for ETL in Scotland

ETL
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Scotland region over the 3 months to 25 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh +25 53 £45,000 -18.18% 2
Glasgow +8 46 £45,000 -2.17% 3
Stirling - 3 £45,000 - 1
ETL
UK

For the 6 months to 25 June 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 Scotland region with a requirement for ETL.

1 92 (58.23%) SQL
2 85 (53.80%) Business Intelligence
3 78 (49.37%) Data Warehouse
4 69 (43.67%) SQL Server
5 56 (35.44%) Oracle
6 55 (34.81%) Agile Software Development
7 52 (32.91%) SQL Server Integration Services
8 46 (29.11%) Finance
9 41 (25.95%) T-SQL
10 35 (22.15%) SQL Server Reporting Services
10 35 (22.15%) Microsoft
10 35 (22.15%) Analytics
11 32 (20.25%) Relational Database
12 31 (19.62%) Information Management
13 29 (18.35%) Tableau
13 29 (18.35%) Data Quality
13 29 (18.35%) Data Modelling
14 28 (17.72%) Java
15 27 (17.09%) RDBMS
16 26 (16.46%) PL/SQL
16 26 (16.46%) Team Foundation Server
17 24 (15.19%) SQL Server 2012
18 23 (14.56%) Performance Tuning
19 22 (13.92%) MicroStrategy
19 22 (13.92%) Cognos
20 21 (13.29%) Unix
21 20 (12.66%) IBM
21 20 (12.66%) Customer Engagement
22 19 (12.03%) System Integration Testing
22 19 (12.03%) Oracle Database

ETL
Co-occurring IT Skills in Scotland 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 (9.49%) Apache Spark
2 14 (8.86%) SAS
3 6 (3.80%) Oracle SOA Suite
4 3 (1.90%) SharePoint
5 1 (0.63%) Elasticsearch
5 1 (0.63%) K2 blackpearl
5 1 (0.63%) OpenStack
Applications
1 3 (1.90%) SPSS
2 2 (1.27%) Microsoft Excel
2 2 (1.27%) Microsoft Office
Business Applications
1 8 (5.06%) Cognos Business Intelligence
2 3 (1.90%) Cognos TM1
3 2 (1.27%) BusinessWorks
4 1 (0.63%) Dynamics CRM
4 1 (0.63%) Eloqua
Cloud Services
1 4 (2.53%) Microsoft Azure
2 2 (1.27%) Amazon AWS
2 2 (1.27%) Cloud Computing
3 1 (0.63%) Azure Data Factory
3 1 (0.63%) iPaaS
3 1 (0.63%) SaaS
Communications & Networking
1 1 (0.63%) Broadband
Database & Business Intelligence
1 78 (49.37%) Data Warehouse
2 69 (43.67%) SQL Server
3 52 (32.91%) SQL Server Integration Services
4 35 (22.15%) SQL Server Reporting Services
5 32 (20.25%) Relational Database
6 27 (17.09%) RDBMS
7 24 (15.19%) SQL Server 2012
8 19 (12.03%) Oracle Database
9 16 (10.13%) Oracle Database 11g
10 15 (9.49%) Oracle Database 10g
10 15 (9.49%) Oracle8/8i Database
10 15 (9.49%) Oracle9i Database
11 14 (8.86%) Big Data
12 13 (8.23%) DataStage
12 13 (8.23%) MongoDB
12 13 (8.23%) PostgreSQL
13 12 (7.59%) DB2
13 12 (7.59%) SQL Server Analysis Services
14 11 (6.96%) PowerCenter
15 10 (6.33%) Hadoop
Development Applications
1 26 (16.46%) Team Foundation Server
2 16 (10.13%) Talend Open Studio
3 15 (9.49%) PVCS
4 8 (5.06%) ERwin
5 6 (3.80%) Selenium
5 6 (3.80%) Visual Studio
6 4 (2.53%) JIRA
7 2 (1.27%) Cucumber
7 2 (1.27%) Git (software)
7 2 (1.27%) HP UFT
7 2 (1.27%) Oracle Forms
General
1 46 (29.11%) Finance
2 5 (3.16%) Banking
3 4 (2.53%) Telecoms
4 2 (1.27%) Legal
4 2 (1.27%) Local Government
5 1 (0.63%) Games
5 1 (0.63%) Manufacturing
5 1 (0.63%) Marketing
5 1 (0.63%) Retail
Job Titles
1 88 (55.70%) Developer
2 37 (23.42%) Business Intelligence Developer
3 35 (22.15%) SQL Developer
4 28 (17.72%) Consultant
5 23 (14.56%) ETL Developer
5 23 (14.56%) SQL Server Developer
6 22 (13.92%) SQL BI Developer
7 20 (12.66%) SSIS Developer
8 19 (12.03%) Oracle Developer
8 19 (12.03%) SQL Server BI Developer
9 18 (11.39%) Data Consultant
10 17 (10.76%) Senior Developer
11 16 (10.13%) Data Warehouse Consultant
11 16 (10.13%) Senior Oracle Developer
12 15 (9.49%) Analyst
12 15 (9.49%) SSRS Developer
13 14 (8.86%) ETL Consultant
14 13 (8.23%) Business Intelligence Consultant
15 12 (7.59%) DBA
16 11 (6.96%) Cognos Developer
Libraries, Frameworks & Software Standards
1 7 (4.43%) Kafka
2 6 (3.80%) NumPy
3 5 (3.16%) CSS
3 5 (3.16%) MLlib
3 5 (3.16%) SciPy
4 4 (2.53%) .NET
4 4 (2.53%) AngularJS
4 4 (2.53%) HTML
4 4 (2.53%) REST
4 4 (2.53%) XML
5 3 (1.90%) Django
5 3 (1.90%) Hibernate
5 3 (1.90%) jQuery
5 3 (1.90%) JSON
5 3 (1.90%) Spring
5 3 (1.90%) Swing
6 2 (1.27%) JMS
6 2 (1.27%) TIBCO EMS
6 2 (1.27%) Web Services
7 1 (0.63%) RESTful
Miscellaneous
1 14 (8.86%) Analytical Skills
2 13 (8.23%) Computer Science
3 6 (3.80%) Driving Licence
3 6 (3.80%) Taxonomies
4 4 (2.53%) Clustering
4 4 (2.53%) Management Information System
5 3 (1.90%) Replication
6 2 (1.27%) Enterprise Software
7 1 (0.63%) Data Structures
7 1 (0.63%) Fintech
7 1 (0.63%) Greenfield Project
7 1 (0.63%) Hybrid Cloud
Operating Systems
1 21 (13.29%) Unix
2 12 (7.59%) Linux
Processes & Methodologies
1 85 (53.80%) Business Intelligence
2 55 (34.81%) Agile Software Development
3 35 (22.15%) Analytics
4 31 (19.62%) Information Management
5 29 (18.35%) Data Modelling
6 23 (14.56%) Performance Tuning
7 20 (12.66%) Customer Engagement
8 19 (12.03%) Integration Testing
8 19 (12.03%) Project Management
8 19 (12.03%) System Integration Testing
9 17 (10.76%) Visualisation
10 16 (10.13%) Data Management
11 15 (9.49%) Infrastructure Management
12 14 (8.86%) Master Data Management
13 13 (8.23%) Machine Learning
13 13 (8.23%) Mathematics
14 11 (6.96%) ETL Development
15 10 (6.33%) Data Analysis
16 9 (5.70%) Statistics
17 8 (5.06%) SOA
Programming Languages
1 92 (58.23%) SQL
2 41 (25.95%) T-SQL
3 28 (17.72%) Java
4 26 (16.46%) PL/SQL
5 18 (11.39%) Python
6 8 (5.06%) C#
7 5 (3.16%) R
8 3 (1.90%) Perl
8 3 (1.90%) VBA
9 2 (1.27%) Korn
9 2 (1.27%) PowerShell
10 1 (0.63%) C++
10 1 (0.63%) JavaScript
10 1 (0.63%) SAS Macro
10 1 (0.63%) VB
Qualifications
1 18 (11.39%) Degree
2 15 (9.49%) Security Cleared
3 2 (1.27%) Computer Science Degree
4 1 (0.63%) Oracle Certification
Quality Assurance & Compliance
1 29 (18.35%) Data Quality
2 4 (2.53%) QA
System Software
1 1 (0.63%) Docker
1 1 (0.63%) HDFS
Vendors
1 56 (35.44%) Oracle
2 35 (22.15%) Microsoft
3 29 (18.35%) Tableau
4 22 (13.92%) Cognos
4 22 (13.92%) MicroStrategy
5 20 (12.66%) IBM
6 16 (10.13%) Informatica
6 16 (10.13%) Talend
7 15 (9.49%) Netezza
8 14 (8.86%) Teradata
9 4 (2.53%) Cognizant
9 4 (2.53%) DataFlux
10 2 (1.27%) Salesforce.com
10 2 (1.27%) TIBCO
11 1 (0.63%) Cloudera
11 1 (0.63%) SAP
Glasgow, Lanarkshire
Search Consultancy
Salary: £35000.00 - £40000.00 per annum
Posted: 5 days ago
Glasgow, Lanarkshire
Cognizant
Salary: Unspecified
Posted: 6 days ago
Edinburgh
Churchill Frank
Salary: £40000 - £50000 per annum
Posted: 13 days ago
Glasgow
Cathcart Associates
Salary: Benefits
Posted: 19 days ago