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

3 months to
30 Aug 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 53 63 85
Rank change year-on-year
+10 +22
Permanent jobs citing ETL 45 42 21
As % of all permanent IT jobs located in Edinburgh 3.66% 2.73% 1.43%
As % of the Processes & Methodologies category 4.02% 3.04% 1.65%
Number of salaries quoted 32 34 20
Median salary £55,000 £47,500 £39,000
Median salary % change year-on-year
+15.78% +21.79%
90% offered a salary of more than £40,000 £38,670 £32,150
10% offered a salary of more than £74,000 £79,500 £60,500
UK excluding London median salary £45,000 £46,000 £45,000
% change year-on-year
-2.17% +2.22%
ETL
Scotland

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Edinburgh region.

Processes & Methodologies Category
Edinburgh
Permanent IT job ads with a match in the
Processes & Methodologies category
1120 1383 1276
As % of all permanent IT jobs located in Edinburgh 91.06% 90.04% 86.98%
Number of salaries quoted 758 887 841
Median salary £50,000 £45,000 £42,000
Median salary % change year-on-year
+11.11% +7.14%
90% offered a salary of more than £32,500 £32,000 £30,000
10% offered a salary of more than £70,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 Edinburgh

The demand trend of job ads across the Edinburgh region citing ETL as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ETL Jobs Demand Trend in Edinburgh

ETL
Salary Trend in Edinburgh

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL across the Edinburgh region.

ETL Salary Trend in Edinburgh

ETL
Salary Histogram in Edinburgh

This chart provides a salary histogram for IT jobs citing ETL across the Edinburgh region over the 3 months to 30 August 2016.

ETL Salary Histogram in Edinburgh

ETL
Top 30 Related IT Skills in Edinburgh

For the 6 months to 30 August 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 Edinburgh region with a requirement for ETL.

1 48 (69.57%) Finance
2 36 (52.17%) Data Warehouse
3 31 (44.93%) Oracle
4 28 (40.58%) Informatica
5 27 (39.13%) Data Architecture
6 26 (37.68%) Agile Software Development
7 24 (34.78%) Data Modelling
8 22 (31.88%) Hadoop
8 22 (31.88%) Apache Hive
9 21 (30.43%) HBase
9 21 (30.43%) Perl
10 19 (27.54%) SQL
10 19 (27.54%) Banking
11 17 (24.64%) Retail
12 16 (23.19%) Project Management
13 15 (21.74%) OLAP
14 14 (20.29%) Scrum
14 14 (20.29%) Information Management
14 14 (20.29%) Investment Management
14 14 (20.29%) Data Governance
14 14 (20.29%) Disruptive Innovation
15 13 (18.84%) Big Data
15 13 (18.84%) Kanban
16 12 (17.39%) Shell Script
16 12 (17.39%) Telecoms
16 12 (17.39%) Oracle OLAP
16 12 (17.39%) Software Engineering
16 12 (17.39%) Games
16 12 (17.39%) REST
16 12 (17.39%) Logical Data Model

ETL
Top Related IT Skills in Edinburgh 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 2 (2.90%) SAS
Applications
1 3 (4.35%) MS Excel
2 2 (2.90%) MS PowerPoint
Business Applications
1 2 (2.90%) Markit EDM
2 1 (1.45%) Oracle Retail
Cloud Services
1 9 (13.04%) SaaS
2 1 (1.45%) Amazon AWS
2 1 (1.45%) Microsoft Azure
Database & Business Intelligence
1 36 (52.17%) Data Warehouse
2 22 (31.88%) Apache Hive
2 22 (31.88%) Hadoop
3 21 (30.43%) HBase
4 15 (21.74%) OLAP
5 13 (18.84%) Big Data
6 12 (17.39%) Oracle OLAP
7 10 (14.49%) PowerCenter
8 9 (13.04%) MongoDB
8 9 (13.04%) Oracle Reports
8 9 (13.04%) Relational Database
9 5 (7.25%) Data Mart
9 5 (7.25%) DB2
9 5 (7.25%) QlikView
9 5 (7.25%) SQL Server
9 5 (7.25%) SQL Server Analysis Services
9 5 (7.25%) SQL Server Integration Services
10 4 (5.80%) SQL Server Reporting Services
11 3 (4.35%) Oracle Database
11 3 (4.35%) Power BI
Development Applications
1 6 (8.70%) Team Foundation Server
2 5 (7.25%) Cucumber
2 5 (7.25%) ERwin
2 5 (7.25%) HP UFT
2 5 (7.25%) Selenium
3 1 (1.45%) Git (software)
3 1 (1.45%) SQL Server Management Studio (SSMS)
General
1 48 (69.57%) Finance
2 19 (27.54%) Banking
3 17 (24.64%) Retail
4 12 (17.39%) Games
4 12 (17.39%) Telecoms
5 3 (4.35%) Retail Banking
6 1 (1.45%) Billing
6 1 (1.45%) Corporate Banking
Job Titles
1 28 (40.58%) Architect
2 14 (20.29%) Solutions Architect
3 13 (18.84%) Data Architect
4 9 (13.04%) Data Engineer
5 5 (7.25%) Data Modeller
5 5 (7.25%) Developer
5 5 (7.25%) Hadoop Architect
5 5 (7.25%) Test Leader
6 4 (5.80%) Senior Data Warehouse Specialist
7 3 (4.35%) Analyst
7 3 (4.35%) Project Manager
7 3 (4.35%) Team Leader
7 3 (4.35%) Technical Leader
7 3 (4.35%) Test Team Leader
8 2 (2.90%) Development Manager
8 2 (2.90%) Infrastructure Project Manager
8 2 (2.90%) Infrastructure Specialist
8 2 (2.90%) Senior Developer
8 2 (2.90%) Technical Specialist
8 2 (2.90%) Test Analyst
Libraries, Frameworks & Software Standards
1 12 (17.39%) REST
2 5 (7.25%) Middleware
3 4 (5.80%) MDX
4 1 (1.45%) .NET
4 1 (1.45%) ASP.NET
4 1 (1.45%) Web Services
Miscellaneous
1 9 (13.04%) Analytical Skills
2 2 (2.90%) Data Integration
3 1 (1.45%) EPoS
3 1 (1.45%) Management Information System
3 1 (1.45%) Visualisation
Operating Systems
1 11 (15.94%) Linux
2 10 (14.49%) Unix
3 2 (2.90%) Windows
4 1 (1.45%) AIX
4 1 (1.45%) Windows Server
Processes & Methodologies
1 27 (39.13%) Data Architecture
2 26 (37.68%) Agile Software Development
3 24 (34.78%) Data Modelling
4 16 (23.19%) Project Management
5 14 (20.29%) Data Governance
5 14 (20.29%) Disruptive Innovation
5 14 (20.29%) Information Management
5 14 (20.29%) Investment Management
5 14 (20.29%) Scrum
6 13 (18.84%) Kanban
7 12 (17.39%) Logical Data Model
7 12 (17.39%) Physical Data Model
7 12 (17.39%) Software Engineering
8 9 (13.04%) High Availability
9 7 (10.14%) Business Intelligence
9 7 (10.14%) ETL Development
10 6 (8.70%) Software Testing
11 5 (7.25%) Defect Management
11 5 (7.25%) Stakeholder Management
11 5 (7.25%) Test Management
Programming Languages
1 21 (30.43%) Perl
2 19 (27.54%) SQL
3 12 (17.39%) Shell Script
4 10 (14.49%) PL/SQL
5 2 (2.90%) C#
5 2 (2.90%) Java
5 2 (2.90%) VBA
6 1 (1.45%) PowerShell
6 1 (1.45%) T-SQL
Qualifications
1 2 (2.90%) ISEB
1 2 (2.90%) ISTQB
1 2 (2.90%) ISTQB Foundation Certification
2 1 (1.45%) Degree
Quality Assurance & Compliance
1 5 (7.25%) QA
2 4 (5.80%) COBIT
Systems Management
1 1 (1.45%) HP Quality Center
Vendors
1 31 (44.93%) Oracle
2 28 (40.58%) Informatica
3 9 (13.04%) Cloudera
3 9 (13.04%) Microsoft
4 6 (8.70%) Teradata
5 5 (7.25%) Pega
6 4 (5.80%) Tableau
7 1 (1.45%) Ab Initio
7 1 (1.45%) ATG
7 1 (1.45%) Cognos
Edinburgh, Midlothian
Complete Tech Limited
Salary: Up to £55,000 per annum + bonus + life assurance + pension + more
Posted: 3 days ago
Edinburgh, Midlothian
Harvey Nash plc
Salary: pension/bonus/other
Posted: 3 hours ago
Edinburgh, Midlothian
Harvey Nash plc
Salary: excellent plus benefits
Posted: 4 days ago