The table below looks at the statistics for ETL skills in IT jobs advertised for the Scotland region. Included is a guide to the salaries offered in IT jobs that have cited ETL over the 3 months to 7 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
7 Dec 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 75 78 83
Rank change year-on-year
+3 +5
Permanent jobs citing ETL 67 92 82
As % of all permanent IT jobs located in Scotland 2.82% 2.96% 2.58%
As % of the Processes & Methodologies category 3.17% 3.31% 2.91%
Number of salaries quoted 51 57 39
Median salary £50,000 £47,500 £42,500
Median salary % change year-on-year
+5.26% +11.76%
90% offered a salary of more than £37,500 £37,500 £35,000
10% offered a salary of more than £75,000 £47,500 £55,000
UK excluding London median salary £45,000 £45,000 £45,000
ETL
UK

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Scotland region.

Processes & Methodologies Category
Scotland
Permanent IT job ads with a match in the
Processes & Methodologies category
2114 2780 2815
As % of all permanent IT jobs located in Scotland 89.05% 89.59% 88.52%
Number of salaries quoted 1309 1763 1856
Median salary £45,000 £45,000 £42,500
Median salary % change year-on-year
- +5.88%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £65,000 £62,500 £65,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

ETL
Jobs Demand Trend in Scotland

The demand trend of job ads across the Scotland region citing ETL as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ETL Jobs Demand Trend in Scotland

ETL
Salary Trend in Scotland

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

ETL Salary Trend in Scotland

ETL
Salary Histogram in Scotland

This chart provides a salary histogram for IT jobs citing ETL across the Scotland region over the 3 months to 7 December 2016.

ETL Salary Histogram 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 7 December 2016. 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
(Click see detailed
statistics and trends)
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 +5 36 £50,000 +5.26% 5
Edinburgh -27 19 £68,000 +47.02% 6
Renfrewshire +3 8 £42,500 +21.42%
Inverclyde - 3 £37,500 -
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 7 December 2016, 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 82 (54.30%) Data Warehouse
2 73 (48.34%) SQL
2 73 (48.34%) Oracle
3 68 (45.03%) Finance
4 57 (37.75%) Business Intelligence
5 53 (35.10%) SQL Server
6 48 (31.79%) Data Modelling
7 45 (29.80%) Agile Software Development
8 42 (27.81%) SQL Server Integration Services
8 42 (27.81%) Informatica
9 32 (21.19%) Microsoft
10 30 (19.87%) Performance Tuning
11 28 (18.54%) Relational Database
11 28 (18.54%) ETL Development
12 27 (17.88%) Analytical Skills
12 27 (17.88%) Big Data
13 25 (16.56%) Apache Hive
13 25 (16.56%) HBase
13 25 (16.56%) Hadoop
13 25 (16.56%) Project Management
14 24 (15.89%) Perl
14 24 (15.89%) PL/SQL
14 24 (15.89%) T-SQL
15 22 (14.57%) MicroStrategy
15 22 (14.57%) Data Architecture
16 20 (13.25%) Banking
17 19 (12.58%) Information Management
17 19 (12.58%) Analytics
17 19 (12.58%) Unix
18 18 (11.92%) Retail

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 9 (5.96%) SAS
2 7 (4.64%) SharePoint
3 5 (3.31%) Apache Pig
4 3 (1.99%) BizTalk Server
Applications
1 8 (5.30%) MS Excel
2 2 (1.32%) MS Project
2 2 (1.32%) MS Visio
Business Applications
1 8 (5.30%) Cognos Business Intelligence
2 4 (2.65%) Cognos TM1
2 4 (2.65%) Oracle Assets
2 4 (2.65%) Oracle Payables
3 3 (1.99%) Dynamics CRM
Cloud Services
1 17 (11.26%) SaaS
2 9 (5.96%) Amazon AWS
2 9 (5.96%) Microsoft Azure
3 8 (5.30%) Cloud Computing
4 4 (2.65%) GitHub
Communications & Networking
1 1 (0.66%) Internet
Database & Business Intelligence
1 82 (54.30%) Data Warehouse
2 53 (35.10%) SQL Server
3 42 (27.81%) SQL Server Integration Services
4 28 (18.54%) Relational Database
5 27 (17.88%) Big Data
6 25 (16.56%) Apache Hive
6 25 (16.56%) Hadoop
6 25 (16.56%) HBase
7 17 (11.26%) DB2
7 17 (11.26%) OLAP
8 15 (9.93%) Data Mart
9 12 (7.95%) Oracle Database
9 12 (7.95%) SQL Server Reporting Services
10 11 (7.28%) Oracle OLAP
10 11 (7.28%) PowerCenter
11 10 (6.62%) Oracle Reports
11 10 (6.62%) RDBMS
12 9 (5.96%) MongoDB
13 7 (4.64%) BusinessObjects
13 7 (4.64%) SQL Server 2012
Development Applications
1 13 (8.61%) ERwin
2 9 (5.96%) Team Foundation Server
3 6 (3.97%) Talend Open Studio
4 4 (2.65%) Cucumber
4 4 (2.65%) Git (software)
4 4 (2.65%) HP UFT
4 4 (2.65%) PVCS
4 4 (2.65%) Selenium
4 4 (2.65%) Visual Studio
5 1 (0.66%) JIRA
General
1 68 (45.03%) Finance
2 20 (13.25%) Banking
3 18 (11.92%) Retail
4 11 (7.28%) Games
4 11 (7.28%) Telecoms
5 6 (3.97%) Legal
6 5 (3.31%) Retail Banking
7 4 (2.65%) General Ledger
7 4 (2.65%) Law
8 3 (1.99%) Spanish Language
9 2 (1.32%) Billing
10 1 (0.66%) Advertising
Job Titles
1 55 (36.42%) Developer
2 24 (15.89%) Architect
3 22 (14.57%) Senior Developer
4 18 (11.92%) SQL Developer
5 16 (10.60%) Business Intelligence Developer
6 14 (9.27%) Data Modeller
7 13 (8.61%) Data Architect
8 11 (7.28%) Solutions Architect
9 10 (6.62%) Consultant
10 9 (5.96%) Data Engineer
11 7 (4.64%) Analyst
11 7 (4.64%) Senior SQL Developer
12 6 (3.97%) Administrator
12 6 (3.97%) Cognos Developer
12 6 (3.97%) DBA
12 6 (3.97%) Oracle Developer
12 6 (3.97%) SQL Server Developer
13 5 (3.31%) ETL Developer
13 5 (3.31%) Infrastructure Manager
13 5 (3.31%) Infrastructure Project Manager
Libraries, Frameworks & Software Standards
1 12 (7.95%) .NET
1 12 (7.95%) CSS
1 12 (7.95%) HTML
2 11 (7.28%) REST
3 8 (5.30%) MDX
4 2 (1.32%) ASP.NET
4 2 (1.32%) Web Services
Miscellaneous
1 27 (17.88%) Analytical Skills
2 17 (11.26%) Data Integration
3 9 (5.96%) Visualisation
4 5 (3.31%) Enterprise Software
4 5 (3.31%) Management Information System
4 5 (3.31%) Reference Data
5 4 (2.65%) Computer Science
6 1 (0.66%) Data Extraction
6 1 (0.66%) Derivative
6 1 (0.66%) Driving Licence
6 1 (0.66%) Minimum Viable Product
6 1 (0.66%) Statistics
6 1 (0.66%) Swaptions
Operating Systems
1 19 (12.58%) Unix
2 16 (10.60%) Linux
3 4 (2.65%) Solaris
4 2 (1.32%) Windows
4 2 (1.32%) Windows Server
Processes & Methodologies
1 57 (37.75%) Business Intelligence
2 48 (31.79%) Data Modelling
3 45 (29.80%) Agile Software Development
4 30 (19.87%) Performance Tuning
5 28 (18.54%) ETL Development
6 25 (16.56%) Project Management
7 22 (14.57%) Data Architecture
8 19 (12.58%) Analytics
8 19 (12.58%) Information Management
9 16 (10.60%) Infrastructure Management
10 15 (9.93%) Data Governance
10 15 (9.93%) Scrum
10 15 (9.93%) Software Engineering
11 12 (7.95%) High Availability
11 12 (7.95%) Kanban
12 11 (7.28%) Disruptive Innovation
12 11 (7.28%) Investment Management
12 11 (7.28%) Logical Data Model
12 11 (7.28%) Physical Data Model
13 7 (4.64%) Mentoring
Programming Languages
1 73 (48.34%) SQL
2 24 (15.89%) Perl
2 24 (15.89%) PL/SQL
2 24 (15.89%) T-SQL
3 12 (7.95%) C#
4 11 (7.28%) Java
4 11 (7.28%) JavaScript
4 11 (7.28%) Shell Script
5 8 (5.30%) PowerShell
6 3 (1.99%) Python
6 3 (1.99%) R
7 1 (0.66%) C
Qualifications
1 10 (6.62%) Degree
2 4 (2.65%) Security Cleared
3 3 (1.99%) MCITP
3 3 (1.99%) MCSA
3 3 (1.99%) MCSE
3 3 (1.99%) Microsoft Certification
Quality Assurance & Compliance
1 10 (6.62%) Data Quality
2 8 (5.30%) QA
3 1 (0.66%) EMIR
3 1 (0.66%) MiFID
3 1 (0.66%) UCITS
System Software
1 3 (1.99%) HDFS
2 2 (1.32%) Apache Flume
Systems Management
1 3 (1.99%) Oozie
2 2 (1.32%) MOM
Vendors
1 73 (48.34%) Oracle
2 42 (27.81%) Informatica
3 32 (21.19%) Microsoft
4 22 (14.57%) MicroStrategy
5 17 (11.26%) Teradata
6 13 (8.61%) Pega
7 10 (6.62%) Cognos
7 10 (6.62%) Tableau
8 9 (5.96%) Cloudera
9 7 (4.64%) Netezza
10 6 (3.97%) Talend
11 5 (3.31%) SAP
12 4 (2.65%) Ab Initio
12 4 (2.65%) IBM
13 2 (1.32%) ESRI
13 2 (1.32%) Salesforce.com
14 1 (0.66%) Alteryx
14 1 (0.66%) Charles River
Glasgow, Lanarkshire
HAYS INFORMATION TECHNOLOGY
Salary: £45000.00 - £55000.00 per annum
Posted: 2 days ago
Edinburgh, Midlothian
Resource Management
Salary: £35000 - £45000 per annum + bonus + benefits
Posted: 5 days ago
Edinburgh, Midlothian
Lorien Resourcing
Posted: 6 days ago
Edinburgh
Cathcart Associates
Salary: £35000 - £45000 per annum + Benefits
Posted: 19 days ago
Edinburgh
Churchill Frank
Salary: £65000 - £85000 per annum + Bonus & Benefits
Posted: 21 days ago
Edinburgh
Hays Specialist Recruitment Ltd
Salary: £40000.00 - £55000.00 per annum
Posted: 23 days ago
Edinburgh
Cathcart Associates
Salary: £40000 - £55000 per annum + Benefits
Posted: 26 days ago