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

3 months to
30 Jul 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 67 73 100
Rank change year-on-year
+6 +27
Permanent jobs citing ETL 94 97 80
As % of all permanent IT jobs located in Scotland 3.25% 3.07% 2.16%
As % of the Processes & Methodologies category 3.61% 3.39% 2.50%
Number of salaries quoted 46 67 52
Median salary £52,500 £44,500 £47,000
Median salary % change year-on-year
+17.97% -5.31%
90% offered a salary of more than £36,750 £32,500 £34,550
10% offered a salary of more than £61,000 £77,100 £65,000
UK excluding London median salary £45,000 £47,000 £45,000
% change year-on-year
-4.25% +4.44%
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
2607 2860 3206
As % of all permanent IT jobs located in Scotland 90.21% 90.51% 86.37%
Number of salaries quoted 1473 1827 2151
Median salary £45,000 £42,500 £42,500
Median salary % change year-on-year
+5.88% -
90% offered a salary of more than £30,000 £31,500 £30,000
10% offered a salary of more than £63,950 £60,000 £62,050
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 30 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 30 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 -16 52 £46,000 +16.45% 7
Edinburgh +16 42 £55,000 +10.00% 9
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 30 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 87 (48.88%) Finance
2 81 (45.51%) SQL
3 65 (36.52%) Business Intelligence
4 59 (33.15%) Data Warehouse
5 56 (31.46%) Oracle
6 53 (29.78%) Agile Software Development
7 51 (28.65%) SQL Server
8 41 (23.03%) Informatica
9 40 (22.47%) Data Modelling
10 39 (21.91%) Perl
11 35 (19.66%) Unix
12 34 (19.10%) Microsoft
12 34 (19.10%) Banking
12 34 (19.10%) SQL Server Integration Services
13 32 (17.98%) Hadoop
14 30 (16.85%) Java
15 29 (16.29%) Asset Management
15 29 (16.29%) Analytical Skills
16 27 (15.17%) Big Data
16 27 (15.17%) Scrum
17 25 (14.04%) Data Architecture
18 23 (12.92%) ETL Development
18 23 (12.92%) C#
18 23 (12.92%) QlikView
19 22 (12.36%) Apache Hive
20 21 (11.80%) Project Management
21 20 (11.24%) T-SQL
21 20 (11.24%) PL/SQL
21 20 (11.24%) Linux
21 20 (11.24%) Information 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.49%) Apache
1 8 (4.49%) SAS
2 3 (1.69%) Apache Pig
2 3 (1.69%) Apache Spark
3 2 (1.12%) SharePoint
4 1 (0.56%) CMS
Applications
1 8 (4.49%) MS Excel
2 3 (1.69%) MS PowerPoint
2 3 (1.69%) MS Visio
3 2 (1.12%) MS Office
3 2 (1.12%) MS Project
4 1 (0.56%) SPSS
Business Applications
1 14 (7.87%) Hi Portfolio
2 6 (3.37%) Cognos Business Intelligence
3 5 (2.81%) Cognos TM1
4 4 (2.25%) Markit EDM
5 3 (1.69%) Oracle Assets
5 3 (1.69%) Oracle Payables
5 3 (1.69%) SAP CO
5 3 (1.69%) SAP FI
5 3 (1.69%) SAP FI/CO
6 2 (1.12%) Oracle Retail
7 1 (0.56%) Hyperion Planning
7 1 (0.56%) Oracle Applications
7 1 (0.56%) Oracle EBS
7 1 (0.56%) Oracle EBS R12
7 1 (0.56%) SAP BPC
Cloud Services
1 6 (3.37%) SaaS
2 3 (1.69%) Microsoft Azure
3 1 (0.56%) Amazon AWS
Communications & Networking
1 1 (0.56%) TCP/IP
Database & Business Intelligence
1 59 (33.15%) Data Warehouse
2 51 (28.65%) SQL Server
3 34 (19.10%) SQL Server Integration Services
4 32 (17.98%) Hadoop
5 27 (15.17%) Big Data
6 23 (12.92%) QlikView
7 22 (12.36%) Apache Hive
8 19 (10.67%) Relational Database
9 18 (10.11%) HBase
10 17 (9.55%) OLAP
10 17 (9.55%) PowerCenter
11 15 (8.43%) BusinessObjects
11 15 (8.43%) DataStage
11 15 (8.43%) Oracle Database
12 14 (7.87%) JasperReports
13 12 (6.74%) SQL Server Reporting Services
14 10 (5.62%) SQL Server Analysis Services
15 9 (5.06%) Oracle ODI
15 9 (5.06%) Oracle OLAP
16 8 (4.49%) Oracle Database 11g
Development Applications
1 10 (5.62%) Selenium
1 10 (5.62%) Team Foundation Server
2 6 (3.37%) Git (software)
2 6 (3.37%) Jenkins
2 6 (3.37%) JUnit
3 5 (2.81%) Cucumber
3 5 (2.81%) HP UFT
3 5 (2.81%) JBehave
3 5 (2.81%) Maven
3 5 (2.81%) Subversion
3 5 (2.81%) TestNG
3 5 (2.81%) WebDriver
4 3 (1.69%) Talend Open Studio
5 1 (0.56%) ERwin
5 1 (0.56%) FitNesse
5 1 (0.56%) SQL Server Management Studio (SSMS)
5 1 (0.56%) Toad
5 1 (0.56%) Visual Studio
General
1 87 (48.88%) Finance
2 34 (19.10%) Banking
3 17 (9.55%) Retail
4 15 (8.43%) Games
5 9 (5.06%) Telecoms
6 3 (1.69%) Corporate Banking
6 3 (1.69%) General Ledger
6 3 (1.69%) Retail Banking
7 2 (1.12%) Billing
7 2 (1.12%) Front Office
8 1 (0.56%) Law
8 1 (0.56%) Manufacturing
8 1 (0.56%) Marketing
Job Titles
1 70 (39.33%) Developer
2 29 (16.29%) Architect
2 29 (16.29%) Consultant
3 20 (11.24%) ETL Developer
4 18 (10.11%) SQL Developer
5 16 (8.99%) Solutions Architect
6 14 (7.87%) Analyst
6 14 (7.87%) Big Data Developer
7 12 (6.74%) Business Intelligence Consultant
7 12 (6.74%) Data Architect
8 9 (5.06%) Business Consultant
8 9 (5.06%) Business Intelligence Developer
9 8 (4.49%) QlikView Developer
10 6 (3.37%) Data Engineer
10 6 (3.37%) QlikView Consultant
11 5 (2.81%) Applications Developer
11 5 (2.81%) ETL Consultant
11 5 (2.81%) Test Automation Engineer
11 5 (2.81%) Test Engineer
11 5 (2.81%) Test Leader
Libraries, Frameworks & Software Standards
1 18 (10.11%) .NET
2 16 (8.99%) ASP.NET
3 14 (7.87%) ASP.NET MVC 5
3 14 (7.87%) ASP.NET Web Forms
3 14 (7.87%) WinForms
4 9 (5.06%) REST
5 8 (4.49%) MDX
6 5 (2.81%) Drools
6 5 (2.81%) Middleware
6 5 (2.81%) RESTful
6 5 (2.81%) Web Services
7 3 (1.69%) OpenMP
8 2 (1.12%) .NET Framework
8 2 (1.12%) XML
9 1 (0.56%) COM
9 1 (0.56%) CSS
9 1 (0.56%) HTML
9 1 (0.56%) SOAP
9 1 (0.56%) XML Schema
9 1 (0.56%) XSLT
Miscellaneous
1 29 (16.29%) Analytical Skills
2 13 (7.30%) Data Integration
3 9 (5.06%) Computer Science
4 8 (4.49%) Enterprise Software
4 8 (4.49%) Mathematics
4 8 (4.49%) Visualisation
5 6 (3.37%) Management Information System
5 6 (3.37%) User Experience
6 4 (2.25%) Fintech
7 3 (1.69%) Reference Data
7 3 (1.69%) Statistics
8 2 (1.12%) Clustering
8 2 (1.12%) Driving Licence
8 2 (1.12%) EPoS
9 1 (0.56%) Algorithms
9 1 (0.56%) Data Structures
9 1 (0.56%) Replication
9 1 (0.56%) Virtual Team
Operating Systems
1 35 (19.66%) Unix
2 20 (11.24%) Linux
3 10 (5.62%) Windows
4 3 (1.69%) Solaris
4 3 (1.69%) Windows Server
5 1 (0.56%) AIX
Processes & Methodologies
1 65 (36.52%) Business Intelligence
2 53 (29.78%) Agile Software Development
3 40 (22.47%) Data Modelling
4 29 (16.29%) Asset Management
5 27 (15.17%) Scrum
6 25 (14.04%) Data Architecture
7 23 (12.92%) ETL Development
8 21 (11.80%) Project Management
9 20 (11.24%) Information Management
9 20 (11.24%) SDLC
10 19 (10.67%) Software Engineering
11 18 (10.11%) Analytics
11 18 (10.11%) Data Management
11 18 (10.11%) Performance Tuning
12 17 (9.55%) Stakeholder Management
13 16 (8.99%) MVC
14 14 (7.87%) Data Analysis
14 14 (7.87%) Fund Accounting
14 14 (7.87%) Investment Management
14 14 (7.87%) Software Architecture
Programming Languages
1 81 (45.51%) SQL
2 39 (21.91%) Perl
3 30 (16.85%) Java
4 23 (12.92%) C#
5 20 (11.24%) PL/SQL
5 20 (11.24%) T-SQL
6 16 (8.99%) Python
7 14 (7.87%) Korn
7 14 (7.87%) VB
8 10 (5.62%) Shell Script
9 9 (5.06%) R
10 8 (4.49%) C++
11 5 (2.81%) Ruby
12 3 (1.69%) JavaScript
13 2 (1.12%) VBA
14 1 (0.56%) PowerShell
14 1 (0.56%) VB.NET
Qualifications
1 14 (7.87%) Degree
2 4 (2.25%) ISEB
2 4 (2.25%) ISTQB
2 4 (2.25%) ISTQB Foundation Certification
3 3 (1.69%) PRINCE2 Practitioner
3 3 (1.69%) Security Cleared
Quality Assurance & Compliance
1 10 (5.62%) Data Quality
2 8 (4.49%) QA
3 4 (2.25%) COBIT
4 1 (0.56%) ISO 9001
System Software
1 3 (1.69%) Apache Flume
Systems Management
1 3 (1.69%) MOM
2 1 (0.56%) Control-M
2 1 (0.56%) HP Quality Center
Vendors
1 56 (31.46%) Oracle
2 41 (23.03%) Informatica
3 34 (19.10%) Microsoft
4 19 (10.67%) Cognos
5 18 (10.11%) Ab Initio
6 11 (6.18%) Tableau
7 10 (5.62%) IBM
8 9 (5.06%) MicroStrategy
8 9 (5.06%) SAP
9 8 (4.49%) Teradata
10 6 (3.37%) Cloudera
11 4 (2.25%) Netezza
12 3 (1.69%) ESRI
12 3 (1.69%) Talend
13 2 (1.12%) ATG
13 2 (1.12%) Charles River
14 1 (0.56%) Cognizant
14 1 (0.56%) Hyperion
14 1 (0.56%) Pega
Edinburgh, Midlothian
Search Consultancy
Salary: DOE
Posted: Yesterday
Edinburgh, Midlothian
Sopra Steria Recruitment
Salary: Up to £75,000 per annum
Posted: Yesterday
Edinburgh, Midlothian
Search Consultancy
Salary: DOE
Posted: Yesterday
Edinburgh, Midlothian
Search Consultancy
Salary: £50000.00 - £75000.00 per annum + 15% flexible benefits package
Posted: 5 days ago
Glasgow
Hays Specialist Recruitment Ltd
Salary: £45000.00 - £60000.00 per annum
Posted: 15 days ago
Glasgow
Hays Specialist Recruitment Ltd
Salary: £45000.00 - £52000.00 per annum
Posted: 26 days ago
Edinburgh, Midlothian
Sanderson
Salary: £30000.00 - £45000.00 per annum + Benefits
Posted: 9 days ago
Glasgow
Vivid Resourcing
Posted: 10 days ago
Edinburgh, Midlothian
Sanderson
Salary: £30000.00 - £45000.00 per annum + Benefits
Posted: 8 days ago
Glasgow
Recruitment Revolution Limited
Posted: 17 days ago
Glasgow City Centre
JP Morgan Glasgow
Salary: Competitive + full benefits
Posted: 18 days ago
Glasgow, UK
JP Morgan Glasgow
Salary: Highly Competitive Benefits Package
Posted: 24 days ago