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

Location
3 months to
11 Feb 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 68 81 72
Rank change year-on-year
+13 -9
Permanent jobs citing ETL 97 85 111
As % of all permanent IT jobs located in Scotland 3.27% 2.74% 3.32%
As % of the Processes & Methodologies category 3.65% 3.15% 3.93%
Number of salaries quoted 62 52 84
Average salary £47,500 £43,000 £50,500
Average salary % change year-on-year
+10.46% -14.85%
90% offered a salary of more than £35,000 £35,000 £32,500
10% offered a salary of more than £55,000 £49,700 £80,000
UK excluding London average salary £45,000 £44,000 £45,000
% change year-on-year
+2.27% -2.22%
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
2654 2701 2821
As % of all permanent IT jobs located in Scotland 89.48% 86.93% 84.39%
Number of salaries quoted 1702 1714 1846
Average salary £45,000 £42,500 £42,500
Average 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 £63,000 £60,000
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -

ETL
Jobs Demand Trend in Scotland

This chart provides a 3-month moving total of permanent IT jobs citing ETL across the Scotland region as a proportion of the total demand within 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 11 February 2016.

ETL Salary Histogram in Scotland

ETL
Job Locations in Scotland

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing ETL within the Scotland region over the 3 months to 11 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh +30 72 £47,500 +7.95% 15
Glasgow +3 66 £47,500 +31.03% 5
North Lanarkshire - 1 £38,000 - 1
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 11 February 2016, IT jobs across the Scotland region citing ETL also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited ETL.

1 112 (53.59%) Business Intelligence
2 107 (51.20%) SQL
3 98 (46.89%) Data Warehouse
4 90 (43.06%) Oracle
5 81 (38.76%) Finance
6 76 (36.36%) Agile Software Development
7 70 (33.49%) BusinessObjects
8 66 (31.58%) Stakeholder Management
9 63 (30.14%) SQL Server Integration Services
10 58 (27.75%) SQL Server Reporting Services
10 58 (27.75%) QlikView
10 58 (27.75%) Cognos
11 56 (26.79%) Data Management
12 55 (26.32%) SQL Server Analysis Services
12 55 (26.32%) Informatica
13 50 (23.92%) Talend Open Studio
13 50 (23.92%) Talend
14 49 (23.44%) SQL Server
15 46 (22.01%) Visualisation
16 44 (21.05%) Data Quality
17 40 (19.14%) Security Cleared
18 38 (18.18%) PRINCE2 Practitioner
18 38 (18.18%) Enterprise Data Management
18 38 (18.18%) PRINCE2
19 35 (16.75%) Data Modelling
19 35 (16.75%) ETL Development
20 33 (15.79%) Banking
21 30 (14.35%) PL/SQL
21 30 (14.35%) Oracle Database
22 29 (13.88%) Analytical Skills

ETL
Top Related IT Skills in Scotland by Category

For the 6 months to 11 February 2016, IT jobs across the Scotland region citing ETL also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited ETL. Up to 20 skills are shown per category.

Application Platforms
1 18 (8.61%) SAS
2 8 (3.83%) Tomcat
3 6 (2.87%) Apache
3 6 (2.87%) Apache Spark
4 5 (2.39%) JBoss
4 5 (2.39%) SharePoint
5 4 (1.91%) MQSeries
5 4 (1.91%) SharePoint 2010
5 4 (1.91%) SharePoint 2013
5 4 (1.91%) WebLogic
6 1 (0.48%) Apache Pig
6 1 (0.48%) CMS
6 1 (0.48%) IBM Notes
Applications
1 22 (10.53%) MS Excel
2 12 (5.74%) MS PowerPoint
3 4 (1.91%) MS Office
4 1 (0.48%) SPSS
Business Applications
1 6 (2.87%) Oracle 11i
2 5 (2.39%) Hyperion Planning
3 4 (1.91%) Hi Portfolio
4 2 (0.96%) Oracle EBS R12
5 1 (0.48%) Cognos TM1
Cloud Services
1 2 (0.96%) Amazon AWS
1 2 (0.96%) Microsoft Azure
1 2 (0.96%) SaaS
2 1 (0.48%) Amazon EC2
2 1 (0.48%) Cloud Computing
Communications & Networking
1 3 (1.44%) HTTP
2 1 (0.48%) DAB
Database & Business Intelligence
1 98 (46.89%) Data Warehouse
2 70 (33.49%) BusinessObjects
3 63 (30.14%) SQL Server Integration Services
4 58 (27.75%) QlikView
4 58 (27.75%) SQL Server Reporting Services
5 55 (26.32%) SQL Server Analysis Services
6 49 (23.44%) SQL Server
7 30 (14.35%) Oracle Database
8 23 (11.00%) Oracle Database 10g
9 21 (10.05%) PowerCenter
10 19 (9.09%) Oracle BI EE
10 19 (9.09%) Oracle Database 11g
11 18 (8.61%) Oracle ODI
12 16 (7.66%) Hadoop
13 15 (7.18%) BODI
13 15 (7.18%) DataStage
14 12 (5.74%) Informix
14 12 (5.74%) MongoDB
14 12 (5.74%) PostgreSQL
15 11 (5.26%) Big Data
Development Applications
1 50 (23.92%) Talend Open Studio
2 7 (3.35%) Visual Studio
3 6 (2.87%) Subversion
4 4 (1.91%) Git (software)
4 4 (1.91%) JBehave
4 4 (1.91%) Jenkins
4 4 (1.91%) Maven
4 4 (1.91%) SQL Server Management Studio (SSMS)
5 2 (0.96%) Team Foundation Server
6 1 (0.48%) Oracle Forms
6 1 (0.48%) PowerDesigner
General
1 81 (38.76%) Finance
2 33 (15.79%) Banking
3 11 (5.26%) Manufacturing
4 8 (3.83%) Retail
5 4 (1.91%) Marketing
6 3 (1.44%) Corporate Banking
7 2 (0.96%) Law
7 2 (0.96%) Retail Banking
8 1 (0.48%) Games
8 1 (0.48%) General Ledger
8 1 (0.48%) Investment Banking
Job Titles
1 107 (51.20%) Developer
2 69 (33.01%) Consultant
3 62 (29.67%) Business Intelligence Developer
4 53 (25.36%) Business Intelligence Consultant
5 27 (12.92%) DBA
6 18 (8.61%) Analyst
7 15 (7.18%) Administrator
7 15 (7.18%) SQL DBA
8 13 (6.22%) Oracle Developer
9 12 (5.74%) ETL Developer
9 12 (5.74%) MongoDB DBA
10 10 (4.78%) Production DBA
11 9 (4.31%) Applications Support
12 8 (3.83%) Business Consultant
12 8 (3.83%) Business Intelligence Analyst
12 8 (3.83%) ETL Consultant
12 8 (3.83%) Oracle BI Developer
12 8 (3.83%) QlikView Developer
13 7 (3.35%) Senior Developer
13 7 (3.35%) SQL Developer
Libraries, Frameworks & Software Standards
1 15 (7.18%) .NET
2 11 (5.26%) Web Services
3 7 (3.35%) ASP.NET
4 6 (2.87%) WSH
5 5 (2.39%) Drools
5 5 (2.39%) HTML
6 4 (1.91%) ASP.NET MVC 5
6 4 (1.91%) ASP.NET Web Forms
6 4 (1.91%) Hibernate
6 4 (1.91%) MDX
6 4 (1.91%) Middleware
6 4 (1.91%) Regular Expression
6 4 (1.91%) Spring
6 4 (1.91%) TIBCO EMS
6 4 (1.91%) WinForms
7 3 (1.44%) CSS
7 3 (1.44%) XML
8 2 (0.96%) OpenMP
9 1 (0.48%) .NET Framework
9 1 (0.48%) SOAP
Miscellaneous
1 46 (22.01%) Visualisation
2 29 (13.88%) Analytical Skills
3 23 (11.00%) Data Integration
4 13 (6.22%) Management Information System
5 10 (4.78%) Computer Science
6 6 (2.87%) Credit Risk
6 6 (2.87%) Fintech
7 4 (1.91%) Clustering
7 4 (1.91%) Driving Licence
7 4 (1.91%) Statistics
8 2 (0.96%) Mathematics
9 1 (0.48%) Enterprise Software
9 1 (0.48%) User Experience
Operating Systems
1 21 (10.05%) Unix
2 17 (8.13%) Linux
3 5 (2.39%) Windows
4 4 (1.91%) Red Hat Enterprise Linux
4 4 (1.91%) Solaris
5 1 (0.48%) Windows Server
Processes & Methodologies
1 112 (53.59%) Business Intelligence
2 76 (36.36%) Agile Software Development
3 66 (31.58%) Stakeholder Management
4 56 (26.79%) Data Management
5 38 (18.18%) Enterprise Data Management
5 38 (18.18%) PRINCE2
6 35 (16.75%) Data Modelling
6 35 (16.75%) ETL Development
7 24 (11.48%) Data Analysis
7 24 (11.48%) Dimensional Modelling
8 22 (10.53%) Migration
8 22 (10.53%) Performance Tuning
9 21 (10.05%) Data Migration
10 15 (7.18%) Analytics
10 15 (7.18%) DevOps
11 13 (6.22%) Asset Management
12 12 (5.74%) Business Analysis
13 11 (5.26%) Workflow
14 10 (4.78%) Anti-Money Laundering
14 10 (4.78%) Dashboard Development
Programming Languages
1 107 (51.20%) SQL
2 30 (14.35%) PL/SQL
3 19 (9.09%) Java
4 13 (6.22%) C#
4 13 (6.22%) Python
4 13 (6.22%) T-SQL
5 11 (5.26%) PowerShell
6 10 (4.78%) VBA
7 8 (3.83%) Perl
8 7 (3.35%) JavaScript
8 7 (3.35%) Shell Script
9 5 (2.39%) C++
10 4 (1.91%) Korn
10 4 (1.91%) Scala
10 4 (1.91%) sed
10 4 (1.91%) VB
11 2 (0.96%) VB.NET
12 1 (0.48%) Data Mining Extensions (DMX)
Qualifications
1 40 (19.14%) Security Cleared
2 38 (18.18%) PRINCE2 Practitioner
3 20 (9.57%) Degree
4 4 (1.91%) ISEB
4 4 (1.91%) Microsoft Certification
5 3 (1.44%) ISTQB
5 3 (1.44%) ISTQB Foundation Certification
6 2 (0.96%) MCITP
6 2 (0.96%) MCSA
6 2 (0.96%) MCTS
Quality Assurance & Compliance
1 44 (21.05%) Data Quality
2 8 (3.83%) QA
3 2 (0.96%) COREP
3 2 (0.96%) FATCA
3 2 (0.96%) FINREP
3 2 (0.96%) SLA
System Software
1 1 (0.48%) Apache Flume
Systems Management
1 1 (0.48%) MOM
Vendors
1 90 (43.06%) Oracle
2 58 (27.75%) Cognos
3 55 (26.32%) Informatica
4 50 (23.92%) Talend
5 27 (12.92%) Teradata
6 21 (10.05%) Microsoft
7 16 (7.66%) Tableau
8 8 (3.83%) IBM
8 8 (3.83%) Red Hat
9 5 (2.39%) Ab Initio
9 5 (2.39%) Hyperion
9 5 (2.39%) SAP
9 5 (2.39%) Sybase
10 4 (1.91%) Terracotta
10 4 (1.91%) TIBCO
11 2 (0.96%) MicroStrategy
12 1 (0.48%) Lotus
12 1 (0.48%) Pega
12 1 (0.48%) Vertica
Edinburgh, Midlothian
Search Consultancy
Salary: £30000.00 - £60000.00 per annum + benefits
Posted: 3 hours ago
Edinburgh & Lothians
Rockhall Recruitment
Salary: From £35,000 to £55,000 per annum + Package
Posted: 4 hours ago
Edinburgh, Midlothian
McGregor Boyall
Posted: Yesterday
Edinburgh, Midlothian
Search Consultancy
Salary: £35000 - £60000 per annum + benefits
Posted: Yesterday
Glasgow
JP Morgan Glasgow
Salary: Competitive
Posted: Yesterday
Edinburgh & Lothians
ANSON MCCADE
Salary: £40,000 - £80,000 (Depending on Experience)
Posted: 2 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £40000 - £80,000 (Depending on Experience)
Posted: 2 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £40000 - £80,000 (Depending on Experience)
Posted: 2 days ago
Edinburgh, Midlothian
Sopra Steria Recruitment
Salary: Unspecified
Posted: 3 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £55,000 per annum Plus excellent benefits
Posted: 6 days ago
Glasgow, Lanarkshire
Lawrence Harvey Enterprise
Salary: £30000.00 - £45000.00 per annum + Benefits, Pension
Posted: 6 days ago
Edinburgh
Cathcart Associates
Salary: £40000 - £80000 per annum + benefits
Posted: 14 days ago
Edinburgh
Cathcart Associates
Salary: £35000 - £60000 per annum + benefits
Posted: 14 days ago
Bellshill
Lusona
Salary: £0 - £38,000 per year
Posted: 17 days ago