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

3 months to
29 Sep 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 69 61 112
Rank change year-on-year
-8 +51
Permanent jobs citing ETL 81 116 68
As % of all permanent IT jobs located in Scotland 3.23% 3.48% 1.87%
As % of the Processes & Methodologies category 3.60% 3.84% 2.17%
Number of salaries quoted 55 75 34
Median salary £50,000 £47,500 £47,000
Median salary % change year-on-year
+5.26% +1.06%
90% offered a salary of more than £37,500 £37,500 £32,950
10% offered a salary of more than £75,000 £67,000 £65,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
2249 3017 3130
As % of all permanent IT jobs located in Scotland 89.74% 90.55% 86.15%
Number of salaries quoted 1405 1901 2011
Median salary £45,000 £45,000 £42,000
Median salary % change year-on-year
- +7.14%
90% offered a salary of more than £31,000 £32,000 £30,000
10% offered a salary of more than £65,000 £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 29 September 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 29 September 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
Edinburgh +6 41 £55,000 +15.78% 8
Glasgow -14 34 £48,000 +1.05% 9
Renfrewshire -1 5 £42,500 -
Stirling - 1 - - 1
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 29 September 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 79 (47.59%) Finance
2 71 (42.77%) SQL
3 68 (40.96%) Data Warehouse
4 62 (37.35%) Oracle
5 54 (32.53%) Business Intelligence
5 54 (32.53%) Agile Software Development
6 49 (29.52%) Informatica
6 49 (29.52%) SQL Server
7 43 (25.90%) Microsoft
7 43 (25.90%) Data Modelling
8 42 (25.30%) Perl
9 37 (22.29%) Hadoop
10 35 (21.08%) Big Data
10 35 (21.08%) SQL Server Integration Services
11 34 (20.48%) Unix
12 31 (18.67%) Analytical Skills
13 28 (16.87%) Apache Hive
14 27 (16.27%) Scrum
15 26 (15.66%) Java
15 26 (15.66%) Data Architecture
16 25 (15.06%) Performance Tuning
17 24 (14.46%) HBase
17 24 (14.46%) Banking
18 23 (13.86%) Software Engineering
18 23 (13.86%) C#
18 23 (13.86%) .NET
18 23 (13.86%) ETL Development
19 22 (13.25%) PL/SQL
19 22 (13.25%) Linux
20 21 (12.65%) Project Management

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 8 (4.82%) Apache
2 6 (3.61%) SharePoint
3 4 (2.41%) SAS
4 3 (1.81%) Apache Pig
4 3 (1.81%) Apache Spark
5 1 (0.60%) CMS
Applications
1 7 (4.22%) MS Excel
2 3 (1.81%) MS Visio
3 2 (1.20%) MS Office
3 2 (1.20%) MS PowerPoint
3 2 (1.20%) MS Project
Business Applications
1 12 (7.23%) HiPortfolio
2 6 (3.61%) Cognos Business Intelligence
3 4 (2.41%) Cognos TM1
3 4 (2.41%) Oracle Assets
3 4 (2.41%) Oracle Payables
4 3 (1.81%) Dynamics CRM
4 3 (1.81%) SAP CO
4 3 (1.81%) SAP FI
4 3 (1.81%) SAP FI/CO
5 2 (1.20%) Markit EDM
6 1 (0.60%) Oracle Retail
6 1 (0.60%) SAP BPC
Cloud Services
1 14 (8.43%) SaaS
2 7 (4.22%) Microsoft Azure
3 5 (3.01%) Amazon AWS
3 5 (3.01%) Cloud Computing
4 2 (1.20%) GitHub
Database & Business Intelligence
1 68 (40.96%) Data Warehouse
2 49 (29.52%) SQL Server
3 37 (22.29%) Hadoop
4 35 (21.08%) Big Data
4 35 (21.08%) SQL Server Integration Services
5 28 (16.87%) Apache Hive
6 24 (14.46%) HBase
7 21 (12.65%) Relational Database
8 20 (12.05%) OLAP
9 15 (9.04%) PowerCenter
10 12 (7.23%) JasperReports
10 12 (7.23%) Oracle OLAP
10 12 (7.23%) Oracle Reports
11 10 (6.02%) Data Mart
11 10 (6.02%) Oracle Database
11 10 (6.02%) QlikView
12 9 (5.42%) DataStage
12 9 (5.42%) MongoDB
13 8 (4.82%) DB2
13 8 (4.82%) RDBMS
Development Applications
1 10 (6.02%) Selenium
2 9 (5.42%) Team Foundation Server
3 8 (4.82%) ERwin
4 7 (4.22%) Git (software)
5 5 (3.01%) Cucumber
5 5 (3.01%) HP UFT
5 5 (3.01%) JBehave
5 5 (3.01%) Jenkins
5 5 (3.01%) JUnit
5 5 (3.01%) Maven
5 5 (3.01%) Subversion
5 5 (3.01%) TestNG
5 5 (3.01%) WebDriver
6 3 (1.81%) Talend Open Studio
7 2 (1.20%) Visual Studio
8 1 (0.60%) PVCS
General
1 79 (47.59%) Finance
2 24 (14.46%) Banking
3 17 (10.24%) Retail
4 14 (8.43%) Games
5 12 (7.23%) Telecoms
6 4 (2.41%) General Ledger
6 4 (2.41%) Law
6 4 (2.41%) Legal
7 3 (1.81%) Retail Banking
8 2 (1.20%) Billing
9 1 (0.60%) Advertising
9 1 (0.60%) Corporate Banking
9 1 (0.60%) Marketing
Job Titles
1 68 (40.96%) Developer
2 29 (17.47%) Architect
3 21 (12.65%) ETL Developer
4 18 (10.84%) SQL Developer
5 15 (9.04%) Data Architect
6 14 (8.43%) Big Data Developer
6 14 (8.43%) Consultant
6 14 (8.43%) Solutions Architect
7 12 (7.23%) Analyst
8 11 (6.63%) Senior Developer
9 10 (6.02%) Data Modeller
10 9 (5.42%) Data Engineer
11 6 (3.61%) Business Intelligence Developer
11 6 (3.61%) Data Consultant
11 6 (3.61%) ETL Consultant
12 5 (3.01%) Hadoop Architect
12 5 (3.01%) Test Automation Engineer
12 5 (3.01%) Test Engineer
12 5 (3.01%) Test Leader
13 4 (2.41%) Informatica ETL Developer
Libraries, Frameworks & Software Standards
1 23 (13.86%) .NET
2 15 (9.04%) ASP.NET
3 12 (7.23%) ASP.NET MVC 5
3 12 (7.23%) ASP.NET Web Forms
3 12 (7.23%) REST
3 12 (7.23%) WinForms
4 9 (5.42%) MDX
5 8 (4.82%) CSS
5 8 (4.82%) HTML
6 5 (3.01%) RESTful
7 4 (2.41%) Web Services
8 3 (1.81%) OpenMP
9 2 (1.20%) XML
10 1 (0.60%) COM
10 1 (0.60%) Drools
10 1 (0.60%) FpML
10 1 (0.60%) Middleware
10 1 (0.60%) SOAP
10 1 (0.60%) XML Schema
10 1 (0.60%) XSLT
Miscellaneous
1 31 (18.67%) Analytical Skills
2 14 (8.43%) Data Integration
3 13 (7.83%) Computer Science
4 8 (4.82%) Mathematics
5 6 (3.61%) Enterprise Software
5 6 (3.61%) Visualisation
6 4 (2.41%) Management Information System
6 4 (2.41%) Reference Data
7 3 (1.81%) Statistics
8 2 (1.20%) User Experience
9 1 (0.60%) Clustering
9 1 (0.60%) Data Extraction
9 1 (0.60%) EPoS
9 1 (0.60%) Replication
Operating Systems
1 34 (20.48%) Unix
2 22 (13.25%) Linux
3 8 (4.82%) Windows
4 4 (2.41%) Solaris
5 3 (1.81%) Windows Server
Processes & Methodologies
1 54 (32.53%) Agile Software Development
1 54 (32.53%) Business Intelligence
2 43 (25.90%) Data Modelling
3 27 (16.27%) Scrum
4 26 (15.66%) Data Architecture
5 25 (15.06%) Performance Tuning
6 23 (13.86%) ETL Development
6 23 (13.86%) Software Engineering
7 21 (12.65%) Information Management
7 21 (12.65%) Project Management
8 19 (11.45%) Analytics
9 18 (10.84%) SDLC
10 16 (9.64%) Data Governance
11 15 (9.04%) Asset Management
11 15 (9.04%) MVC
12 13 (7.83%) Data Management
12 13 (7.83%) Disruptive Innovation
12 13 (7.83%) Investment Management
12 13 (7.83%) Kanban
13 12 (7.23%) Logical Data Model
Programming Languages
1 71 (42.77%) SQL
2 42 (25.30%) Perl
3 26 (15.66%) Java
4 23 (13.86%) C#
5 22 (13.25%) PL/SQL
6 20 (12.05%) T-SQL
7 16 (9.64%) Python
8 12 (7.23%) Korn
8 12 (7.23%) Shell Script
8 12 (7.23%) VB
9 8 (4.82%) C++
10 7 (4.22%) JavaScript
11 6 (3.61%) PowerShell
12 5 (3.01%) R
12 5 (3.01%) Ruby
13 2 (1.20%) VBA
14 1 (0.60%) VB.NET
Qualifications
1 16 (9.64%) Degree
2 1 (0.60%) ISEB
2 1 (0.60%) ISTQB
2 1 (0.60%) ISTQB Foundation Certification
2 1 (0.60%) Security Cleared
Quality Assurance & Compliance
1 10 (6.02%) Data Quality
2 8 (4.82%) QA
3 1 (0.60%) COBIT
System Software
1 3 (1.81%) Apache Flume
Systems Management
1 3 (1.81%) MOM
Vendors
1 62 (37.35%) Oracle
2 49 (29.52%) Informatica
3 43 (25.90%) Microsoft
4 17 (10.24%) Ab Initio
5 16 (9.64%) MicroStrategy
6 10 (6.02%) SAP
6 10 (6.02%) Teradata
7 9 (5.42%) Cloudera
8 8 (4.82%) IBM
8 8 (4.82%) Pega
9 7 (4.22%) Cognos
9 7 (4.22%) Tableau
10 6 (3.61%) Netezza
11 3 (1.81%) ESRI
11 3 (1.81%) Talend
12 1 (0.60%) Alteryx
12 1 (0.60%) ATG
12 1 (0.60%) Cognizant
Glasgow, Lanarkshire
HAYS INFORMATION TECHNOLOGY
Salary: £45000.00 - £60000.00 per annum
Posted: 1 hour ago
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent salary + benefits
Posted: 2 days ago
Glasgow, Lanarkshire
FPSG Connect
Posted: 2 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £50,000 per annum Plus benefits
Posted: 2 days ago
Edinburgh & Lothians
Meraki Talent Ltd
Salary: Excellent plus bonus and benefits
Posted: 3 days ago
Gourock, Renfrewshire
Lorien Resourcing
Posted: 5 days ago
Edinburgh, Midlothian
HAYS INFORMATION TECHNOLOGY
Salary: £35000.00 - £50000.00 per annum
Posted: 2 days ago
Glasgow
Cathcart Associates
Salary: £35000 - £50000 per annum + Benefits
Posted: 21 days ago
Edinburgh
Cathcart Associates
Salary: £35000 - £40000 per annum + Benefits
Posted: 14 days ago
Stirling, Stirlingshire
PRUDENTIAL
Posted: 13 days ago
Glasgow
Cathcart Associates
Salary: £35000 - £50000 per annum + Benefits
Posted: 17 days ago
Edinburgh
OHO Group Ltd.
Salary: £40000 - £65000 per annum, Benefits: Bonus
Posted: 24 days ago