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

3 months to
25 Mar 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
UK / Scotland
Rank 78 79 78
Rank change year-on-year +1 -1  
Permanent jobs citing ETL 61 90 83
As % of all permanent IT jobs advertised in Scotland 2.63% 3.07% 2.68%
As % of the Processes & Methodologies category 2.88% 3.39% 3.01%
Number of salaries quoted 41 61 57
Median salary £42,500 £47,500 £44,000
Median salary % change year-on-year -10.52% +7.95%  
90% offered a salary of more than £36,500 £37,500 £35,000
10% offered a salary of more than £77,500 £57,500 £63,500
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 2117 2654 2754
As % of all permanent IT job vacancies advertised in Scotland 91.25% 90.52% 89.07%
Number of salaries quoted 1330 1715 1686
Median salary £45,000 £46,000 £44,000
Median salary % change year-on-year -2.17% +4.54%  
90% offered a salary of more than £32,500 £32,500 £32,500
10% offered a salary of more than £70,000 £60,000 £65,000
UK excluding London median salary £45,000 £45,000 £43,000
% change year-on-year - +4.65%  

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 March 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 March 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
Glasgow +1 31 £50,000 +5.26% 6
Edinburgh -29 29 £40,000 -15.78% 5
Scottish Borders - 1 £35,000 -
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 25 March 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 74 (57.81%) SQL
2 63 (49.22%) Business Intelligence
3 62 (48.44%) SQL Server
4 61 (47.66%) Data Warehouse
5 50 (39.06%) Oracle
6 45 (35.16%) SQL Server Integration Services
7 41 (32.03%) Finance
8 38 (29.69%) Data Modelling
9 34 (26.56%) T-SQL
10 31 (24.22%) Microsoft
11 29 (22.66%) Agile Software Development
12 28 (21.88%) Relational Database
13 26 (20.31%) Performance Tuning
13 26 (20.31%) SQL Server Reporting Services
14 25 (19.53%) MicroStrategy
14 25 (19.53%) PL/SQL
15 24 (18.75%) SQL Server 2012
16 23 (17.97%) Analytics
17 22 (17.19%) RDBMS
18 20 (15.63%) Project Management
18 20 (15.63%) MS Excel
19 19 (14.84%) Big Data
20 18 (14.06%) Infrastructure Management
21 17 (13.28%) Oracle Database
21 17 (13.28%) ETL Development
22 15 (11.72%) Java
22 15 (11.72%) Team Foundation Server
22 15 (11.72%) Tableau
23 14 (10.94%) Analytical Skills
23 14 (10.94%) Talend

ETL
Top Related 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 12 (9.38%) SAS
2 6 (4.69%) Apache Spark
3 5 (3.91%) BizTalk Server
4 4 (3.13%) Oracle SOA Suite
5 3 (2.34%) Apache Pig
5 3 (2.34%) SharePoint
Applications
1 20 (15.63%) MS Excel
2 1 (0.78%) MS Office
Business Applications
1 3 (2.34%) Cognos Business Intelligence
2 1 (0.78%) Dynamics CRM
Cloud Services
1 9 (7.03%) Amazon AWS
2 8 (6.25%) Microsoft Azure
3 7 (5.47%) SaaS
4 6 (4.69%) Cloud Computing
5 2 (1.56%) GitHub
Communications & Networking
1 1 (0.78%) Internet
Database & Business Intelligence
1 62 (48.44%) SQL Server
2 61 (47.66%) Data Warehouse
3 45 (35.16%) SQL Server Integration Services
4 28 (21.88%) Relational Database
5 26 (20.31%) SQL Server Reporting Services
6 24 (18.75%) SQL Server 2012
7 22 (17.19%) RDBMS
8 19 (14.84%) Big Data
9 17 (13.28%) Oracle Database
10 14 (10.94%) Oracle Database 11g
11 13 (10.16%) Oracle Database 10g
11 13 (10.16%) Oracle8/8i Database
11 13 (10.16%) Oracle9i Database
12 10 (7.81%) Apache Hive
12 10 (7.81%) DB2
12 10 (7.81%) Hadoop
13 9 (7.03%) HBase
14 8 (6.25%) SAS Enterprise Guide
15 7 (5.47%) SAS Data Integration Studio
15 7 (5.47%) SQL Server 2005
Development Applications
1 15 (11.72%) Team Foundation Server
2 14 (10.94%) Talend Open Studio
3 13 (10.16%) PVCS
4 11 (8.59%) ERwin
5 5 (3.91%) Visual Studio
6 3 (2.34%) Git (software)
6 3 (2.34%) Oracle Forms
7 1 (0.78%) Cucumber
7 1 (0.78%) HP UFT
7 1 (0.78%) JIRA
7 1 (0.78%) Selenium
General
1 41 (32.03%) Finance
2 5 (3.91%) Retail
3 4 (3.13%) Banking
4 3 (2.34%) Spanish Language
5 2 (1.56%) Legal
5 2 (1.56%) Retail Banking
6 1 (0.78%) Billing
6 1 (0.78%) Games
Job Titles
1 69 (53.91%) Developer
2 30 (23.44%) Business Intelligence Developer
2 30 (23.44%) Senior Developer
3 26 (20.31%) SQL Developer
4 19 (14.84%) SQL Server Developer
5 17 (13.28%) Oracle Developer
6 16 (12.50%) DBA
7 15 (11.72%) SQL BI Developer
8 14 (10.94%) Senior Oracle Developer
8 14 (10.94%) SSIS Developer
9 13 (10.16%) SQL Server BI Developer
9 13 (10.16%) SSRS Developer
10 12 (9.38%) Consultant
11 11 (8.59%) Administrator
11 11 (8.59%) Business Intelligence Consultant
12 10 (7.81%) Analyst
13 7 (5.47%) Architect
13 7 (5.47%) Data Architect
13 7 (5.47%) Data Consultant
13 7 (5.47%) Data Warehouse Consultant
Libraries, Frameworks & Software Standards
1 10 (7.81%) .NET
2 7 (5.47%) CSS
2 7 (5.47%) HTML
3 6 (4.69%) Kafka
4 2 (1.56%) Django
5 1 (0.78%) .NET Framework
5 1 (0.78%) REST
Miscellaneous
1 14 (10.94%) Analytical Skills
2 5 (3.91%) Computer Science
2 5 (3.91%) Taxonomies
3 4 (3.13%) Clustering
3 4 (3.13%) Enterprise Software
4 3 (2.34%) Replication
5 2 (1.56%) Driving Licence
5 2 (1.56%) Fintech
5 2 (1.56%) Management Information System
6 1 (0.78%) Derivative
6 1 (0.78%) Minimum Viable Product
6 1 (0.78%) Reference Data
6 1 (0.78%) Swaptions
Operating Systems
1 14 (10.94%) Unix
2 5 (3.91%) Linux
Processes & Methodologies
1 63 (49.22%) Business Intelligence
2 38 (29.69%) Data Modelling
3 29 (22.66%) Agile Software Development
4 26 (20.31%) Performance Tuning
5 23 (17.97%) Analytics
6 20 (15.63%) Project Management
7 18 (14.06%) Infrastructure Management
8 17 (13.28%) ETL Development
9 13 (10.16%) Data Integration
9 13 (10.16%) Integration Testing
9 13 (10.16%) System Integration Testing
10 12 (9.38%) Information Management
11 11 (8.59%) IT Strategy
11 11 (8.59%) Mathematics
12 9 (7.03%) Customer Engagement
12 9 (7.03%) Data Management
13 7 (5.47%) High Availability
13 7 (5.47%) Master Data Management
13 7 (5.47%) Visualisation
14 6 (4.69%) Machine Learning
Programming Languages
1 74 (57.81%) SQL
2 34 (26.56%) T-SQL
3 25 (19.53%) PL/SQL
4 15 (11.72%) Java
5 12 (9.38%) C#
6 8 (6.25%) PowerShell
7 7 (5.47%) JavaScript
7 7 (5.47%) Python
8 2 (1.56%) VBA
9 1 (0.78%) C
9 1 (0.78%) Perl
Qualifications
1 13 (10.16%) Security Cleared
2 11 (8.59%) Degree
3 5 (3.91%) MCITP
3 5 (3.91%) MCSA
3 5 (3.91%) MCSE
3 5 (3.91%) Microsoft Certification
Quality Assurance & Compliance
1 10 (7.81%) Data Quality
2 4 (3.13%) QA
3 1 (0.78%) EMIR
3 1 (0.78%) MiFID
3 1 (0.78%) UCITS
System Software
1 3 (2.34%) HDFS
Systems Management
1 3 (2.34%) Oozie
Vendors
1 50 (39.06%) Oracle
2 31 (24.22%) Microsoft
3 25 (19.53%) MicroStrategy
4 15 (11.72%) Tableau
5 14 (10.94%) Talend
6 13 (10.16%) Teradata
7 9 (7.03%) IBM
7 9 (7.03%) Informatica
8 8 (6.25%) Cognos
8 8 (6.25%) Netezza
9 5 (3.91%) Pega
10 3 (2.34%) DataFlux
11 2 (1.56%) Salesforce.com
12 1 (0.78%) Charles River
12 1 (0.78%) Cloudera
12 1 (0.78%) SAP
Edinburgh, Midlothian
HAYS INFORMATION TECHNOLOGY
Salary: £35000.00 - £46000.00 per annum
Posted: Yesterday
Edinburgh
Churchill Frank
Salary: £40000 - £50000 per annum
Posted: Yesterday
Edinburgh, Midlothian
Resource Management
Salary: £35000 - £45000 per annum + bonus + benefits
Posted: 2 days ago
Glasgow, Lanarkshire
Empiric.com
Salary: From £60,000 to £75,000 per annum Bonus and Benefits package
Posted: 2 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: £40000.00 - £50000.00 per annum + benefits
Posted: 3 days ago
Edinburgh, Midlothian
Churchill Frank
Salary: £35000 - £50000 per annum + Bonus, Pension, SAS Training & More
Posted: 5 days ago
Glasgow, Lanarkshire
Durham Professional Services Limited
Salary: From £20,000 to £30,000 per annum
Posted: 5 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £50,000 per annum Plus excellent benefits
Posted: 3 days ago
Glasgow, Lanarkshire
Harvey Nash plc
Posted: 4 days ago
Stirling, Stirlingshire
PRUDENTIAL
Posted: 8 days ago