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

3 months to
27 Feb 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
UK / Scotland
Rank 79 70 82
Rank change year-on-year
-9 +12
Permanent jobs citing ETL 59 100 86
As % of all permanent IT jobs located in Scotland 2.59% 3.45% 2.75%
As % of the Processes & Methodologies category 2.87% 3.79% 3.10%
Number of salaries quoted 51 66 59
Median salary £41,000 £47,500 £44,000
Median salary % change year-on-year
-13.68% +7.95%
90% offered a salary of more than £32,500 £35,000 £35,000
10% offered a salary of more than £77,500 £55,000 £51,000
UK excluding London median salary £45,000 £45,000 £45,000

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
2056 2636 2770
As % of all permanent IT jobs located in Scotland 90.37% 90.87% 88.53%
Number of salaries quoted 1338 1672 1731
Median salary £45,000 £45,500 £44,000
Median salary % change year-on-year
-1.09% +3.40%
90% offered a salary of more than £32,500 £32,500 £32,500
10% offered a salary of more than £65,500 £60,000 £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 27 February 2017.

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 27 February 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 -33 29 £40,000 -15.78% 6
Glasgow -9 25 £50,000 +5.26% 2
Renfrewshire - 4 £32,500 -
Scottish Borders - 1 £35,000 -
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 27 February 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 65 (50.78%) SQL
1 65 (50.78%) SQL Server
2 60 (46.88%) Data Warehouse
2 60 (46.88%) Business Intelligence
3 56 (43.75%) Oracle
4 46 (35.94%) Finance
4 46 (35.94%) SQL Server Integration Services
5 40 (31.25%) Data Modelling
6 34 (26.56%) Microsoft
7 32 (25.00%) T-SQL
8 29 (22.66%) Relational Database
9 28 (21.88%) MicroStrategy
10 27 (21.09%) Performance Tuning
11 26 (20.31%) Agile Software Development
12 24 (18.75%) PL/SQL
13 23 (17.97%) SQL Server Reporting Services
14 22 (17.19%) SQL Server 2012
14 22 (17.19%) ETL Development
15 21 (16.41%) Project Management
16 19 (14.84%) RDBMS
16 19 (14.84%) Analytics
16 19 (14.84%) Analytical Skills
17 18 (14.06%) Infrastructure Management
17 18 (14.06%) Data Integration
17 18 (14.06%) MS Excel
18 17 (13.28%) Teradata
19 15 (11.72%) C#
19 15 (11.72%) Oracle Database
19 15 (11.72%) Big Data
20 14 (10.94%) Tableau

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 10 (7.81%) SAS
2 6 (4.69%) Apache Spark
3 5 (3.91%) BizTalk Server
3 5 (3.91%) SharePoint
4 4 (3.13%) Oracle SOA Suite
5 3 (2.34%) Apache Pig
Applications
1 18 (14.06%) MS Excel
2 1 (0.78%) MS Office
Business Applications
1 3 (2.34%) Cognos Business Intelligence
2 2 (1.56%) Dynamics CRM
Cloud Services
1 12 (9.38%) Amazon AWS
2 11 (8.59%) Microsoft Azure
3 10 (7.81%) SaaS
4 9 (7.03%) Cloud Computing
5 4 (3.13%) GitHub
Communications & Networking
1 1 (0.78%) Internet
Database & Business Intelligence
1 65 (50.78%) SQL Server
2 60 (46.88%) Data Warehouse
3 46 (35.94%) SQL Server Integration Services
4 29 (22.66%) Relational Database
5 23 (17.97%) SQL Server Reporting Services
6 22 (17.19%) SQL Server 2012
7 19 (14.84%) RDBMS
8 15 (11.72%) Big Data
8 15 (11.72%) Oracle Database
9 13 (10.16%) DB2
10 11 (8.59%) Oracle Database 11g
11 10 (7.81%) Apache Hive
11 10 (7.81%) Hadoop
11 10 (7.81%) Oracle Database 10g
11 10 (7.81%) Oracle8/8i Database
11 10 (7.81%) Oracle9i Database
12 9 (7.03%) HBase
13 8 (6.25%) Data Mart
13 8 (6.25%) SQL Server 2005
14 7 (5.47%) BusinessObjects
Development Applications
1 14 (10.94%) ERwin
2 13 (10.16%) Talend Open Studio
3 12 (9.38%) Team Foundation Server
4 10 (7.81%) PVCS
5 6 (4.69%) Visual Studio
6 4 (3.13%) Git (software)
7 3 (2.34%) Oracle Forms
8 1 (0.78%) Cucumber
8 1 (0.78%) HP UFT
8 1 (0.78%) JIRA
8 1 (0.78%) Selenium
General
1 46 (35.94%) Finance
2 6 (4.69%) Retail
3 5 (3.91%) Banking
4 3 (2.34%) Legal
4 3 (2.34%) Retail Banking
4 3 (2.34%) Spanish Language
5 2 (1.56%) Billing
6 1 (0.78%) Games
6 1 (0.78%) Law
Job Titles
1 66 (51.56%) Developer
2 31 (24.22%) Senior Developer
3 25 (19.53%) SQL Developer
4 24 (18.75%) Business Intelligence Developer
5 17 (13.28%) SQL Server Developer
6 15 (11.72%) DBA
7 14 (10.94%) Oracle Developer
8 13 (10.16%) SQL BI Developer
9 12 (9.38%) SSIS Developer
10 11 (8.59%) Administrator
10 11 (8.59%) Senior Oracle Developer
10 11 (8.59%) SQL Server BI Developer
10 11 (8.59%) SSRS Developer
11 9 (7.03%) Analyst
12 8 (6.25%) Data Modeller
12 8 (6.25%) Senior SQL Developer
13 7 (5.47%) Architect
13 7 (5.47%) Consultant
13 7 (5.47%) Data Architect
14 6 (4.69%) Senior Data Architect
Libraries, Frameworks & Software Standards
1 13 (10.16%) .NET
2 11 (8.59%) CSS
2 11 (8.59%) HTML
3 6 (4.69%) Kafka
4 1 (0.78%) ASP.NET
4 1 (0.78%) Django
4 1 (0.78%) REST
Miscellaneous
1 19 (14.84%) Analytical Skills
2 6 (4.69%) Computer Science
3 5 (3.91%) Enterprise Software
3 5 (3.91%) Taxonomies
4 4 (3.13%) Clustering
5 3 (2.34%) Replication
6 2 (1.56%) Driving Licence
6 2 (1.56%) Fintech
7 1 (0.78%) Derivative
7 1 (0.78%) Management Information System
7 1 (0.78%) Minimum Viable Product
7 1 (0.78%) Reference Data
7 1 (0.78%) Swaptions
Operating Systems
1 11 (8.59%) Unix
2 3 (2.34%) Linux
Processes & Methodologies
1 60 (46.88%) Business Intelligence
2 40 (31.25%) Data Modelling
3 27 (21.09%) Performance Tuning
4 26 (20.31%) Agile Software Development
5 22 (17.19%) ETL Development
6 21 (16.41%) Project Management
7 19 (14.84%) Analytics
8 18 (14.06%) Data Integration
8 18 (14.06%) Infrastructure Management
9 11 (8.59%) Integration Testing
9 11 (8.59%) Mathematics
9 11 (8.59%) System Integration Testing
10 10 (7.81%) Data Management
11 8 (6.25%) Master Data Management
11 8 (6.25%) Visualisation
12 7 (5.47%) High Availability
13 6 (4.69%) Data Security
13 6 (4.69%) Enterprise Architecture
13 6 (4.69%) Information Management
13 6 (4.69%) Wealth Management
Programming Languages
1 65 (50.78%) SQL
2 32 (25.00%) T-SQL
3 24 (18.75%) PL/SQL
4 15 (11.72%) C#
5 11 (8.59%) PowerShell
6 10 (7.81%) JavaScript
7 9 (7.03%) Java
8 4 (3.13%) Python
9 1 (0.78%) C
9 1 (0.78%) Perl
9 1 (0.78%) VBA
Qualifications
1 12 (9.38%) Degree
2 10 (7.81%) Security Cleared
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 5 (3.91%) QA
2 4 (3.13%) Data Quality
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 56 (43.75%) Oracle
2 34 (26.56%) Microsoft
3 28 (21.88%) MicroStrategy
4 17 (13.28%) Teradata
5 14 (10.94%) Tableau
6 13 (10.16%) Informatica
6 13 (10.16%) Talend
7 8 (6.25%) Pega
8 6 (4.69%) IBM
8 6 (4.69%) Netezza
9 5 (3.91%) Cognos
10 2 (1.56%) Salesforce.com
10 2 (1.56%) SAP
11 1 (0.78%) Alteryx
11 1 (0.78%) Charles River
11 1 (0.78%) Cloudera
Edinburgh, Midlothian
Resource Management
Salary: £36000 - £50000 per annum + bonus + benefits
Posted: 6 days ago
Edinburgh
Churchill Frank
Salary: £40000 - £50000 per annum
Posted: 13 days ago
Edinburgh
Hays Specialist Recruitment Ltd
Salary: £30000.00 - £35000.00 per annum
Posted: 13 days ago
Glasgow
Cathcart Associates
Salary: £35000 - £50000 per annum + Benefits
Posted: 18 days ago
Edinburgh
Hays Specialist Recruitment Ltd
Salary: £40000.00 - £50000.00 per annum
Posted: 24 days ago
Edinburgh
TDA Group
Salary: £45000 - £55000 per annum + Bonus
Posted: 17 days ago