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 1 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 81 69 106
Rank change year-on-year
-12 +37
Permanent jobs citing ETL 86 101 77
As % of all permanent IT jobs located in Scotland 3.02% 3.19% 2.03%
As % of the Processes & Methodologies category 3.34% 3.56% 2.37%
Number of salaries quoted 33 69 47
Median salary £50,000 £44,000 £47,500
Median salary % change year-on-year
+13.63% -7.36%
90% offered a salary of more than £38,000 £32,500 £33,700
10% offered a salary of more than £56,800 £57,350 £80,000
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year
- +2.27%
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
2572 2835 3251
As % of all permanent IT jobs located in Scotland 90.34% 89.57% 85.89%
Number of salaries quoted 1433 1798 2206
Median salary £45,000 £44,000 £42,500
Median salary % change year-on-year
+2.27% +3.52%
90% offered a salary of more than £30,000 £31,500 £30,000
10% offered a salary of more than £65,000 £60,000 £60,000
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

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 1 July 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 1 July 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 -12 55 £46,000 +22.66% 6
Edinburgh -4 27 £55,000 +15.78% 4
Falkirk - 1 £50,000 -
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 1 July 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 78 (44.57%) Finance
2 76 (43.43%) SQL
3 75 (42.86%) Business Intelligence
4 61 (34.86%) Data Warehouse
5 56 (32.00%) Oracle
6 52 (29.71%) Agile Software Development
7 44 (25.14%) SQL Server
8 38 (21.71%) Data Modelling
9 36 (20.57%) Informatica
10 33 (18.86%) Asset Management
10 33 (18.86%) SQL Server Integration Services
11 32 (18.29%) Unix
11 32 (18.29%) ETL Development
12 31 (17.71%) Stakeholder Management
12 31 (17.71%) Data Management
13 30 (17.14%) Banking
13 30 (17.14%) Perl
14 29 (16.57%) Microsoft
14 29 (16.57%) QlikView
14 29 (16.57%) Analytical Skills
15 28 (16.00%) BusinessObjects
16 27 (15.43%) Cognos
16 27 (15.43%) Java
16 27 (15.43%) Hadoop
17 25 (14.29%) C#
18 23 (13.14%) PL/SQL
18 23 (13.14%) Scrum
18 23 (13.14%) Big Data
19 21 (12.00%) Data Analysis
20 20 (11.43%) .NET

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 (6.29%) SAS
2 8 (4.57%) Apache
3 3 (1.71%) Apache Pig
3 3 (1.71%) Apache Spark
3 3 (1.71%) SharePoint
4 1 (0.57%) CMS
4 1 (0.57%) SharePoint 2010
4 1 (0.57%) SharePoint 2013
Applications
1 8 (4.57%) MS Excel
2 6 (3.43%) MS PowerPoint
3 2 (1.14%) MS Office
4 1 (0.57%) MS Visio
4 1 (0.57%) SPSS
Business Applications
1 16 (9.14%) Hi Portfolio
2 4 (2.29%) Hyperion Planning
2 4 (2.29%) Markit EDM
3 3 (1.71%) Oracle EBS R12
3 3 (1.71%) SAP CO
3 3 (1.71%) SAP FI
3 3 (1.71%) SAP FI/CO
4 2 (1.14%) Oracle Retail
5 1 (0.57%) Cognos TM1
5 1 (0.57%) Oracle Applications
5 1 (0.57%) Oracle EBS
5 1 (0.57%) SAP BPC
Cloud Services
1 3 (1.71%) Microsoft Azure
2 2 (1.14%) SaaS
3 1 (0.57%) Amazon AWS
Communications & Networking
1 1 (0.57%) TCP/IP
Database & Business Intelligence
1 61 (34.86%) Data Warehouse
2 44 (25.14%) SQL Server
3 33 (18.86%) SQL Server Integration Services
4 29 (16.57%) QlikView
5 28 (16.00%) BusinessObjects
6 27 (15.43%) Hadoop
7 23 (13.14%) Big Data
8 20 (11.43%) Oracle Database
8 20 (11.43%) PowerCenter
9 19 (10.86%) SQL Server Reporting Services
10 17 (9.71%) DataStage
10 17 (9.71%) Oracle ODI
10 17 (9.71%) SQL Server Analysis Services
11 16 (9.14%) JasperReports
12 14 (8.00%) Apache Hive
12 14 (8.00%) Oracle Database 11g
12 14 (8.00%) Relational Database
13 13 (7.43%) Oracle Database 10g
14 12 (6.86%) Oracle BI EE
15 10 (5.71%) HBase
Development Applications
1 11 (6.29%) Talend Open Studio
2 9 (5.14%) Selenium
3 7 (4.00%) Git (software)
4 6 (3.43%) Jenkins
4 6 (3.43%) JUnit
4 6 (3.43%) Subversion
5 5 (2.86%) JBehave
5 5 (2.86%) Maven
5 5 (2.86%) Team Foundation Server
5 5 (2.86%) TestNG
5 5 (2.86%) WebDriver
6 4 (2.29%) Cucumber
6 4 (2.29%) HP UFT
7 2 (1.14%) SQL Server Management Studio (SSMS)
7 2 (1.14%) Visual Studio
8 1 (0.57%) FitNesse
8 1 (0.57%) Toad
General
1 78 (44.57%) Finance
2 30 (17.14%) Banking
3 13 (7.43%) Retail
4 11 (6.29%) Games
5 6 (3.43%) Manufacturing
6 5 (2.86%) Telecoms
7 3 (1.71%) Corporate Banking
8 2 (1.14%) Billing
8 2 (1.14%) Front Office
8 2 (1.14%) Retail Banking
9 1 (0.57%) Marketing
Job Titles
1 83 (47.43%) Developer
2 40 (22.86%) Consultant
3 24 (13.71%) ETL Developer
4 23 (13.14%) Business Intelligence Consultant
5 21 (12.00%) Business Intelligence Developer
6 19 (10.86%) Architect
7 15 (8.57%) Analyst
8 14 (8.00%) Big Data Developer
8 14 (8.00%) SQL Developer
9 10 (5.71%) Business Consultant
9 10 (5.71%) Solutions Architect
10 9 (5.14%) QlikView Developer
11 8 (4.57%) Data Architect
12 7 (4.00%) ETL Consultant
13 6 (3.43%) QlikView Consultant
14 5 (2.86%) Applications Developer
14 5 (2.86%) Oracle BI Developer
14 5 (2.86%) Oracle Developer
14 5 (2.86%) Test Analyst
14 5 (2.86%) Test Automation Engineer
Libraries, Frameworks & Software Standards
1 20 (11.43%) .NET
2 18 (10.29%) ASP.NET
3 16 (9.14%) ASP.NET MVC 5
3 16 (9.14%) ASP.NET Web Forms
3 16 (9.14%) WinForms
4 5 (2.86%) Drools
4 5 (2.86%) Middleware
4 5 (2.86%) REST
4 5 (2.86%) RESTful
4 5 (2.86%) Web Services
5 3 (1.71%) OpenMP
6 2 (1.14%) .NET Framework
6 2 (1.14%) MDX
6 2 (1.14%) XML
7 1 (0.57%) COM
7 1 (0.57%) CSS
7 1 (0.57%) SOAP
7 1 (0.57%) WCF
7 1 (0.57%) XML Schema
7 1 (0.57%) XSLT
Miscellaneous
1 29 (16.57%) Analytical Skills
2 16 (9.14%) Data Integration
3 13 (7.43%) Visualisation
4 9 (5.14%) Computer Science
5 8 (4.57%) Mathematics
6 7 (4.00%) Enterprise Software
7 6 (3.43%) Fintech
7 6 (3.43%) Management Information System
7 6 (3.43%) User Experience
8 4 (2.29%) Virtual Team
9 3 (1.71%) Driving Licence
9 3 (1.71%) Statistics
10 2 (1.14%) Clustering
10 2 (1.14%) EPoS
11 1 (0.57%) Algorithms
11 1 (0.57%) Data Structures
11 1 (0.57%) Replication
Operating Systems
1 32 (18.29%) Unix
2 14 (8.00%) Linux
3 8 (4.57%) Windows
4 1 (0.57%) AIX
4 1 (0.57%) Windows Server
Processes & Methodologies
1 75 (42.86%) Business Intelligence
2 52 (29.71%) Agile Software Development
3 38 (21.71%) Data Modelling
4 33 (18.86%) Asset Management
5 32 (18.29%) ETL Development
6 31 (17.71%) Data Management
6 31 (17.71%) Stakeholder Management
7 23 (13.14%) Scrum
8 21 (12.00%) Data Analysis
9 20 (11.43%) SDLC
10 18 (10.29%) Analytics
10 18 (10.29%) MVC
11 16 (9.14%) Fund Accounting
11 16 (9.14%) Software Architecture
12 15 (8.57%) Data Architecture
12 15 (8.57%) Software Engineering
13 14 (8.00%) Information Management
14 13 (7.43%) Performance Tuning
15 12 (6.86%) Dimensional Modelling
15 12 (6.86%) PRINCE2
Programming Languages
1 76 (43.43%) SQL
2 30 (17.14%) Perl
3 27 (15.43%) Java
4 25 (14.29%) C#
5 23 (13.14%) PL/SQL
6 16 (9.14%) Korn
6 16 (9.14%) Python
6 16 (9.14%) VB
7 13 (7.43%) T-SQL
8 8 (4.57%) C++
8 8 (4.57%) R
9 7 (4.00%) Shell Script
10 5 (2.86%) Ruby
11 4 (2.29%) VBA
12 1 (0.57%) JavaScript
12 1 (0.57%) PowerShell
12 1 (0.57%) VB.NET
Qualifications
1 12 (6.86%) Degree
2 11 (6.29%) PRINCE2 Practitioner
2 11 (6.29%) Security Cleared
3 4 (2.29%) ISEB
3 4 (2.29%) ISTQB
3 4 (2.29%) ISTQB Foundation Certification
4 1 (0.57%) MCSA
4 1 (0.57%) Microsoft Certification
Quality Assurance & Compliance
1 11 (6.29%) Data Quality
2 9 (5.14%) QA
3 4 (2.29%) COBIT
4 1 (0.57%) ISO 9001
4 1 (0.57%) SLA
System Software
1 3 (1.71%) Apache Flume
Systems Management
1 3 (1.71%) MOM
2 1 (0.57%) Control-M
2 1 (0.57%) HP Quality Center
Vendors
1 56 (32.00%) Oracle
2 36 (20.57%) Informatica
3 29 (16.57%) Microsoft
4 27 (15.43%) Cognos
5 17 (9.71%) Ab Initio
6 11 (6.29%) MicroStrategy
6 11 (6.29%) Talend
6 11 (6.29%) Teradata
7 10 (5.71%) Tableau
8 8 (4.57%) SAP
9 7 (4.00%) IBM
10 4 (2.29%) Hyperion
10 4 (2.29%) Netezza
11 3 (1.71%) ESRI
12 2 (1.14%) ATG
12 2 (1.14%) Charles River
12 2 (1.14%) Cloudera
13 1 (0.57%) Cognizant
Glasgow, Lanarkshire
HAYS INFORMATION TECHNOLOGY
Salary: £45000.00 - £52000.00 per annum
Posted: Yesterday
Edinburgh, Midlothian
Maclean Moore Consulting
Salary: From £50,000 to £60,000 per annum + benefits
Posted: Yesterday
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent salary, bonus and benefits
Posted: 2 days ago
Glasgow, Lanarkshire
Net Talent
Posted: 3 days ago
Midlothian
Capita Internal Resourcing
Posted: 2 days ago
Edinburgh
Lawrence Harvey
Salary: £60000.00 - £70000.00 per annum + pension, bonus, health care
Posted: 15 days ago
Glasgow City Centre
JP Morgan Glasgow
Salary: Competitive + full benefits
Posted: 24 days ago