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

3 months to
20 Jan 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
UK / Scotland
Rank 73 66 80
Rank change year-on-year
-7 +14
Permanent jobs citing ETL 59 95 83
As % of all permanent IT jobs located in Scotland 2.61% 3.21% 2.75%
As % of the Processes & Methodologies category 2.92% 3.56% 3.11%
Number of salaries quoted 45 67 50
Median salary £46,000 £47,500 £42,500
Median salary % change year-on-year
-3.15% +11.76%
90% offered a salary of more than £32,500 £37,500 £35,000
10% offered a salary of more than £75,000 £55,000 £50,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
2020 2672 2672
As % of all permanent IT jobs located in Scotland 89.50% 90.33% 88.56%
Number of salaries quoted 1271 1721 1762
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 £32,500
10% offered a salary of more than £60,500 £61,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 20 January 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 20 January 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 -7 32 £50,000 +5.26% 3
Edinburgh -29 21 £40,000 -15.78% 9
Renfrewshire +1 5 £32,500 -7.14%
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 20 January 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 72 (54.96%) Data Warehouse
2 65 (49.62%) SQL
3 63 (48.09%) Oracle
4 53 (40.46%) Business Intelligence
5 52 (39.69%) SQL Server
6 46 (35.11%) Finance
7 42 (32.06%) Data Modelling
8 40 (30.53%) SQL Server Integration Services
9 37 (28.24%) Agile Software Development
10 32 (24.43%) Microsoft
11 30 (22.90%) Performance Tuning
12 29 (22.14%) Informatica
13 26 (19.85%) MicroStrategy
13 26 (19.85%) PL/SQL
14 25 (19.08%) Relational Database
15 24 (18.32%) T-SQL
15 24 (18.32%) Analytical Skills
16 23 (17.56%) ETL Development
17 20 (15.27%) Infrastructure Management
18 19 (14.50%) Big Data
18 19 (14.50%) Data Integration
19 17 (12.98%) SQL Server Reporting Services
19 17 (12.98%) Teradata
19 17 (12.98%) DB2
19 17 (12.98%) Project Management
20 16 (12.21%) C#
21 15 (11.45%) .NET
21 15 (11.45%) Unix
21 15 (11.45%) Analytics
21 15 (11.45%) SaaS

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 11 (8.40%) SAS
2 7 (5.34%) SharePoint
3 5 (3.82%) BizTalk Server
4 3 (2.29%) Apache Pig
Applications
1 13 (9.92%) MS Excel
Business Applications
1 3 (2.29%) Dynamics CRM
2 2 (1.53%) Cognos Business Intelligence
2 2 (1.53%) Oracle Assets
2 2 (1.53%) Oracle Payables
Cloud Services
1 15 (11.45%) SaaS
2 13 (9.92%) Amazon AWS
2 13 (9.92%) Microsoft Azure
3 10 (7.63%) Cloud Computing
4 4 (3.05%) GitHub
Communications & Networking
1 1 (0.76%) Internet
Database & Business Intelligence
1 72 (54.96%) Data Warehouse
2 52 (39.69%) SQL Server
3 40 (30.53%) SQL Server Integration Services
4 25 (19.08%) Relational Database
5 19 (14.50%) Big Data
6 17 (12.98%) DB2
6 17 (12.98%) SQL Server Reporting Services
7 14 (10.69%) SQL Server 2012
8 13 (9.92%) Data Mart
9 12 (9.16%) Apache Hive
9 12 (9.16%) Hadoop
9 12 (9.16%) Oracle Database
10 11 (8.40%) HBase
11 10 (7.63%) RDBMS
12 9 (6.87%) Oracle Database 11g
13 8 (6.11%) BusinessObjects
13 8 (6.11%) Oracle Database 10g
13 8 (6.11%) Oracle8/8i Database
13 8 (6.11%) Oracle9i Database
14 7 (5.34%) Oracle Reports
Development Applications
1 13 (9.92%) ERwin
2 11 (8.40%) Talend Open Studio
3 8 (6.11%) PVCS
3 8 (6.11%) Team Foundation Server
4 5 (3.82%) Visual Studio
5 4 (3.05%) Git (software)
6 2 (1.53%) Cucumber
6 2 (1.53%) HP UFT
6 2 (1.53%) Selenium
7 1 (0.76%) JIRA
7 1 (0.76%) Oracle Forms
General
1 46 (35.11%) Finance
2 10 (7.63%) Retail
3 6 (4.58%) Banking
3 6 (4.58%) Legal
4 5 (3.82%) Games
5 4 (3.05%) Telecoms
6 3 (2.29%) Law
6 3 (2.29%) Retail Banking
6 3 (2.29%) Spanish Language
7 2 (1.53%) Billing
7 2 (1.53%) General Ledger
8 1 (0.76%) Advertising
Job Titles
1 64 (48.85%) Developer
2 30 (22.90%) Senior Developer
3 22 (16.79%) SQL Developer
4 21 (16.03%) Business Intelligence Developer
5 13 (9.92%) Data Modeller
5 13 (9.92%) SQL Server Developer
6 12 (9.16%) Oracle Developer
7 10 (7.63%) DBA
8 9 (6.87%) Administrator
8 9 (6.87%) Senior SQL Developer
9 8 (6.11%) Senior Oracle Developer
9 8 (6.11%) SQL BI Developer
10 7 (5.34%) Analyst
10 7 (5.34%) Architect
10 7 (5.34%) Consultant
10 7 (5.34%) Senior SQL Server Developer
10 7 (5.34%) SSIS Developer
11 6 (4.58%) ETL Developer
11 6 (4.58%) SQL Server BI Developer
11 6 (4.58%) SSRS Developer
Libraries, Frameworks & Software Standards
1 15 (11.45%) .NET
2 14 (10.69%) CSS
2 14 (10.69%) HTML
3 5 (3.82%) REST
4 2 (1.53%) ASP.NET
5 1 (0.76%) MDX
Miscellaneous
1 24 (18.32%) Analytical Skills
2 19 (14.50%) Data Integration
3 7 (5.34%) Enterprise Software
3 7 (5.34%) Visualisation
4 4 (3.05%) Computer Science
5 3 (2.29%) Reference Data
6 1 (0.76%) Data Extraction
6 1 (0.76%) Derivative
6 1 (0.76%) Driving Licence
6 1 (0.76%) Fintech
6 1 (0.76%) Management Information System
6 1 (0.76%) Minimum Viable Product
6 1 (0.76%) Statistics
6 1 (0.76%) Swaptions
Operating Systems
1 15 (11.45%) Unix
2 8 (6.11%) Linux
3 2 (1.53%) Solaris
Processes & Methodologies
1 53 (40.46%) Business Intelligence
2 42 (32.06%) Data Modelling
3 37 (28.24%) Agile Software Development
4 30 (22.90%) Performance Tuning
5 23 (17.56%) ETL Development
6 20 (15.27%) Infrastructure Management
7 17 (12.98%) Project Management
8 15 (11.45%) Analytics
9 9 (6.87%) High Availability
9 9 (6.87%) Information Management
10 8 (6.11%) Data Governance
10 8 (6.11%) Software Engineering
10 8 (6.11%) Wealth Management
11 7 (5.34%) Data Management
12 6 (4.58%) Data Architecture
12 6 (4.58%) Integration Testing
12 6 (4.58%) Scrum
12 6 (4.58%) System Integration Testing
13 5 (3.82%) Data Mapping
13 5 (3.82%) Kanban
Programming Languages
1 65 (49.62%) SQL
2 26 (19.85%) PL/SQL
3 24 (18.32%) T-SQL
4 16 (12.21%) C#
5 11 (8.40%) JavaScript
5 11 (8.40%) Perl
5 11 (8.40%) PowerShell
6 10 (7.63%) Java
7 4 (3.05%) Shell Script
8 1 (0.76%) C
8 1 (0.76%) Python
Qualifications
1 10 (7.63%) Degree
2 8 (6.11%) Security Cleared
3 5 (3.82%) MCITP
3 5 (3.82%) MCSA
3 5 (3.82%) MCSE
3 5 (3.82%) Microsoft Certification
Quality Assurance & Compliance
1 7 (5.34%) Data Quality
2 6 (4.58%) QA
3 1 (0.76%) EMIR
3 1 (0.76%) MiFID
3 1 (0.76%) UCITS
System Software
1 3 (2.29%) HDFS
Systems Management
1 3 (2.29%) Oozie
Vendors
1 63 (48.09%) Oracle
2 32 (24.43%) Microsoft
3 29 (22.14%) Informatica
4 26 (19.85%) MicroStrategy
5 17 (12.98%) Teradata
6 13 (9.92%) Pega
7 11 (8.40%) Talend
8 10 (7.63%) Tableau
9 7 (5.34%) Netezza
10 5 (3.82%) Cloudera
11 4 (3.05%) Cognos
12 2 (1.53%) Ab Initio
12 2 (1.53%) Salesforce.com
12 2 (1.53%) SAP
13 1 (0.76%) Alteryx
13 1 (0.76%) Charles River
Edinburgh, Midlothian
Monarch Recruitment
Salary: £30000 - £55000 per annum
Posted: 2 hours ago
Edinburgh, Midlothian
Cathcart Associates Ltd
Salary: £40000 - £55000 per annum + Benefits
Posted: Yesterday
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £50,000 per annum Plus excellent benefits
Posted: 2 days ago
Edinburgh, Midlothian
Resource Management
Salary: £35000 - £45000 per annum + bonus + benefits
Posted: 3 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: Benefits including bonus
Posted: 4 days ago
Edinburgh
Hays Specialist Recruitment Ltd
Salary: £40000.00 - £60000.00 per annum
Posted: 14 days ago
Glasgow
Cathcart Associates
Salary: £35000 - £45000 per annum + Benefits
Posted: 11 days ago
Glasgow
Cathcart Associates
Salary: £35000 - £45000 per annum + Benefits
Posted: 11 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £45,000 - £58,000 + extensive benefits package
Posted: 3 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £80,000-£100,000
Posted: 6 days ago
Edinburgh
TDA Group
Salary: £45000 - £55000 per annum + Bonus
Posted: 9 days ago