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

3 months to
30 Apr 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 54 50 55
Rank change year-on-year
-4 +5
Permanent jobs citing ETL 41 53 65
As % of all permanent IT jobs located in Edinburgh 3.16% 3.87% 3.96%
As % of the Processes & Methodologies category 3.51% 4.38% 4.51%
Number of salaries quoted 28 42 37
Average salary £51,750 £45,000 £60,000
Average salary % change year-on-year
+15.00% -25.00%
90% offered a salary of more than £34,000 £42,650 £46,500
10% offered a salary of more than £61,250 £67,250 £95,000
UK excluding London average salary £45,000 £45,000 £45,000
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
1168 1211 1440
As % of all permanent IT jobs located in Edinburgh 90.12% 88.39% 87.64%
Number of salaries quoted 754 722 934
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £32,500 £32,500 £29,000
10% offered a salary of more than £67,500 £60,000 £60,000
UK excluding London average salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

ETL
Jobs Demand Trend in Edinburgh

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

ETL Salary Histogram in Edinburgh

ETL
Top 30 Related IT Skills in Edinburgh

For the 6 months to 30 April 2016, IT jobs across the Edinburgh 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 62 (60.19%) Data Warehouse
2 61 (59.22%) Business Intelligence
3 55 (53.40%) Stakeholder Management
4 50 (48.54%) BusinessObjects
5 48 (46.60%) Cognos
6 47 (45.63%) Finance
6 47 (45.63%) Data Management
7 41 (39.81%) SQL
8 39 (37.86%) QlikView
9 38 (36.89%) SQL Server Reporting Services
10 37 (35.92%) SQL Server Integration Services
11 36 (34.95%) Agile Software Development
12 35 (33.98%) SQL Server Analysis Services
12 35 (33.98%) Visualisation
13 32 (31.07%) Oracle
14 31 (30.10%) Data Modelling
15 29 (28.16%) PRINCE2
15 29 (28.16%) Banking
16 28 (27.18%) Enterprise Data Management
16 28 (27.18%) Talend Open Studio
16 28 (27.18%) PRINCE2 Practitioner
16 28 (27.18%) Security Cleared
16 28 (27.18%) Data Quality
16 28 (27.18%) Talend
17 27 (26.21%) Data Analysis
18 26 (25.24%) ETL Development
19 25 (24.27%) Informatica
20 22 (21.36%) PowerCenter
20 22 (21.36%) Oracle Database 11g
20 22 (21.36%) Oracle ODI

ETL
Top Related IT Skills in Edinburgh by Category

For the 6 months to 30 April 2016, IT jobs across the Edinburgh 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 13 (12.62%) SAS
2 5 (4.85%) SharePoint
3 4 (3.88%) SharePoint 2010
3 4 (3.88%) SharePoint 2013
4 1 (0.97%) IBM Notes
Applications
1 13 (12.62%) MS PowerPoint
2 9 (8.74%) MS Excel
3 1 (0.97%) MS Office
3 1 (0.97%) SPSS
Business Applications
1 2 (1.94%) Markit EDM
2 1 (0.97%) Cognos TM1
2 1 (0.97%) Oracle Applications
2 1 (0.97%) Oracle EBS
2 1 (0.97%) Oracle Retail
Cloud Services
1 1 (0.97%) Amazon AWS
Database & Business Intelligence
1 62 (60.19%) Data Warehouse
2 50 (48.54%) BusinessObjects
3 39 (37.86%) QlikView
4 38 (36.89%) SQL Server Reporting Services
5 37 (35.92%) SQL Server Integration Services
6 35 (33.98%) SQL Server Analysis Services
7 22 (21.36%) Oracle Database
7 22 (21.36%) Oracle Database 11g
7 22 (21.36%) Oracle ODI
7 22 (21.36%) PowerCenter
8 21 (20.39%) Oracle Database 10g
9 18 (17.48%) DataStage
10 16 (15.53%) BODI
11 15 (14.56%) SQL Server
12 10 (9.71%) Oracle BI EE
13 9 (8.74%) Hadoop
13 9 (8.74%) Relational Database
14 5 (4.85%) BusinessObjects XI
15 4 (3.88%) OLAP
16 3 (2.91%) OLAP Cube
Development Applications
1 28 (27.18%) Talend Open Studio
2 5 (4.85%) Git (software)
2 5 (4.85%) SQL Server Management Studio (SSMS)
3 3 (2.91%) Team Foundation Server
3 3 (2.91%) Visual Studio
4 2 (1.94%) Cucumber
4 2 (1.94%) HP UFT
4 2 (1.94%) Selenium
4 2 (1.94%) Subversion
5 1 (0.97%) Toad
General
1 47 (45.63%) Finance
2 29 (28.16%) Banking
3 8 (7.77%) Retail
4 5 (4.85%) Corporate Banking
5 2 (1.94%) Front Office
6 1 (0.97%) Billing
6 1 (0.97%) Retail Banking
Job Titles
1 50 (48.54%) Developer
2 49 (47.57%) Consultant
3 45 (43.69%) Business Intelligence Consultant
4 35 (33.98%) Business Intelligence Developer
5 13 (12.62%) Business Consultant
6 11 (10.68%) Analyst
7 8 (7.77%) QlikView Developer
8 6 (5.83%) Senior Developer
8 6 (5.83%) Test Analyst
9 5 (4.85%) ETL Consultant
10 4 (3.88%) Architect
10 4 (3.88%) Business Intelligence Analyst
10 4 (3.88%) Senior Data Warehouse Specialist
11 3 (2.91%) Data Integration Specialist
11 3 (2.91%) Integration Specialist
11 3 (2.91%) Senior QlikView Developer
11 3 (2.91%) SQL Developer
12 2 (1.94%) ETL Analyst
12 2 (1.94%) Technical Developer
12 2 (1.94%) Test Leader
Libraries, Frameworks & Software Standards
1 5 (4.85%) Middleware
2 4 (3.88%) MDX
3 2 (1.94%) .NET
3 2 (1.94%) ASP.NET
3 2 (1.94%) Web Services
4 1 (0.97%) XML
Miscellaneous
1 35 (33.98%) Visualisation
2 15 (14.56%) Analytical Skills
3 12 (11.65%) Data Integration
4 9 (8.74%) Management Information System
5 6 (5.83%) Fintech
6 2 (1.94%) Driving Licence
7 1 (0.97%) EPoS
Operating Systems
1 5 (4.85%) Unix
2 2 (1.94%) Linux
2 2 (1.94%) Windows
3 1 (0.97%) AIX
3 1 (0.97%) Windows Server
Processes & Methodologies
1 61 (59.22%) Business Intelligence
2 55 (53.40%) Stakeholder Management
3 47 (45.63%) Data Management
4 36 (34.95%) Agile Software Development
5 31 (30.10%) Data Modelling
6 29 (28.16%) PRINCE2
7 28 (27.18%) Enterprise Data Management
8 27 (26.21%) Data Analysis
9 26 (25.24%) ETL Development
10 20 (19.42%) Dimensional Modelling
11 14 (13.59%) Asset Management
12 12 (11.65%) Data Governance
13 11 (10.68%) Analytics
14 10 (9.71%) Anti-Money Laundering
14 10 (9.71%) Dashboard Development
15 9 (8.74%) Software Testing
16 8 (7.77%) Technical Analysis
16 8 (7.77%) Workflow
17 6 (5.83%) Business Analysis
17 6 (5.83%) CRM
Programming Languages
1 41 (39.81%) SQL
2 14 (13.59%) PL/SQL
3 9 (8.74%) C#
4 7 (6.80%) VBA
5 6 (5.83%) Java
5 6 (5.83%) T-SQL
6 2 (1.94%) Perl
7 1 (0.97%) Data Mining Extensions (DMX)
7 1 (0.97%) JavaScript
7 1 (0.97%) VB.NET
Qualifications
1 28 (27.18%) PRINCE2 Practitioner
1 28 (27.18%) Security Cleared
2 6 (5.83%) ISEB
2 6 (5.83%) ISTQB
2 6 (5.83%) ISTQB Foundation Certification
3 5 (4.85%) Degree
4 2 (1.94%) MCSA
4 2 (1.94%) Microsoft Certification
Quality Assurance & Compliance
1 28 (27.18%) Data Quality
2 4 (3.88%) COBIT
3 2 (1.94%) QA
4 1 (0.97%) ISO 9001
Systems Management
1 1 (0.97%) HP Quality Center
Vendors
1 48 (46.60%) Cognos
2 32 (31.07%) Oracle
3 28 (27.18%) Talend
4 25 (24.27%) Informatica
5 18 (17.48%) Tableau
6 17 (16.50%) Teradata
7 6 (5.83%) Microsoft
8 3 (2.91%) IBM
9 2 (1.94%) Charles River
10 1 (0.97%) Ab Initio
10 1 (0.97%) ATG
10 1 (0.97%) Lotus
Edinburgh, Midlothian
McGregor Boyall
Posted: 4 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: competitive benefits, D.O.E.
Posted: 5 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: benefits, D.O.E.
Posted: 5 days ago