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

3 months to
24 May 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 75 68 88
Rank change year-on-year
-7 +20
Permanent jobs citing ETL 88 89 91
As % of all permanent IT jobs located in Scotland 3.12% 3.03% 2.34%
As % of the Processes & Methodologies category 3.46% 3.41% 2.76%
Number of salaries quoted 37 60 49
Median salary £51,000 £44,750 £52,500
Median salary % change year-on-year
+13.96% -14.76%
90% offered a salary of more than £38,000 £37,250 £29,800
10% offered a salary of more than £64,600 £58,200 £95,000
UK excluding London median salary £45,000 £45,000 £44,500
% change year-on-year
- +1.12%
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
2543 2608 3295
As % of all permanent IT jobs located in Scotland 90.18% 88.92% 84.77%
Number of salaries quoted 1509 1629 2186
Median salary £45,000 £44,500 £42,500
Median salary % change year-on-year
+1.12% +4.70%
90% offered a salary of more than £30,500 £32,500 £30,000
10% offered a salary of more than £65,000 £60,000 £60,000
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 24 May 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 24 May 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 0 55 £46,250 +14.19% 8
Edinburgh -21 27 £54,500 +21.11% 5
Falkirk - 3 £50,000 -
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 24 May 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 99 (52.94%) Business Intelligence
2 85 (45.45%) SQL
3 70 (37.43%) Data Warehouse
3 70 (37.43%) Finance
4 59 (31.55%) Oracle
5 55 (29.41%) Agile Software Development
6 49 (26.20%) Stakeholder Management
7 48 (25.67%) BusinessObjects
8 46 (24.60%) QlikView
9 45 (24.06%) Data Management
10 44 (23.53%) Cognos
10 44 (23.53%) Data Modelling
11 43 (22.99%) SQL Server
11 43 (22.99%) SQL Server Integration Services
12 42 (22.46%) ETL Development
13 37 (19.79%) Informatica
13 37 (19.79%) Asset Management
14 35 (18.72%) SQL Server Reporting Services
15 33 (17.65%) Data Analysis
16 31 (16.58%) Analytical Skills
17 30 (16.04%) Banking
17 30 (16.04%) SQL Server Analysis Services
18 27 (14.44%) C#
18 27 (14.44%) Unix
18 27 (14.44%) Microsoft
18 27 (14.44%) Visualisation
19 26 (13.90%) Oracle Database
20 25 (13.37%) Oracle ODI
20 25 (13.37%) Java
21 24 (12.83%) PowerCenter

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 15 (8.02%) SAS
2 8 (4.28%) Apache
3 4 (2.14%) SharePoint
4 3 (1.60%) Apache Spark
5 2 (1.07%) SharePoint 2010
5 2 (1.07%) SharePoint 2013
6 1 (0.53%) CMS
6 1 (0.53%) IBM Notes
6 1 (0.53%) MQSeries
6 1 (0.53%) Tomcat
6 1 (0.53%) WebLogic
Applications
1 13 (6.95%) MS PowerPoint
2 12 (6.42%) MS Excel
3 3 (1.60%) MS Office
4 1 (0.53%) MS Visio
4 1 (0.53%) SPSS
Business Applications
1 16 (8.56%) Hi Portfolio
2 6 (3.21%) Hyperion Planning
3 4 (2.14%) Markit EDM
4 3 (1.60%) Oracle EBS R12
4 3 (1.60%) SAP CO
4 3 (1.60%) SAP FI
4 3 (1.60%) SAP FI/CO
5 2 (1.07%) Oracle Retail
6 1 (0.53%) Cognos TM1
6 1 (0.53%) Oracle Applications
6 1 (0.53%) Oracle EBS
6 1 (0.53%) SAP BPC
Cloud Services
1 3 (1.60%) Microsoft Azure
2 1 (0.53%) Amazon AWS
Communications & Networking
1 1 (0.53%) TCP/IP
Database & Business Intelligence
1 70 (37.43%) Data Warehouse
2 48 (25.67%) BusinessObjects
3 46 (24.60%) QlikView
4 43 (22.99%) SQL Server
4 43 (22.99%) SQL Server Integration Services
5 35 (18.72%) SQL Server Reporting Services
6 30 (16.04%) SQL Server Analysis Services
7 26 (13.90%) Oracle Database
8 25 (13.37%) Oracle ODI
9 24 (12.83%) PowerCenter
10 22 (11.76%) Oracle Database 11g
11 21 (11.23%) DataStage
11 21 (11.23%) Oracle Database 10g
12 20 (10.70%) Hadoop
12 20 (10.70%) Oracle BI EE
13 16 (8.56%) BODI
13 16 (8.56%) JasperReports
14 13 (6.95%) Relational Database
15 12 (6.42%) Big Data
16 6 (3.21%) Qlik Sense
Development Applications
1 22 (11.76%) Talend Open Studio
2 7 (3.74%) Git (software)
3 6 (3.21%) Selenium
3 6 (3.21%) Subversion
4 5 (2.67%) Jenkins
4 5 (2.67%) JUnit
5 4 (2.14%) JBehave
5 4 (2.14%) Maven
5 4 (2.14%) TestNG
5 4 (2.14%) Visual Studio
5 4 (2.14%) WebDriver
6 3 (1.60%) SQL Server Management Studio (SSMS)
6 3 (1.60%) Team Foundation Server
7 2 (1.07%) Cucumber
7 2 (1.07%) HP UFT
8 1 (0.53%) FitNesse
8 1 (0.53%) Toad
General
1 70 (37.43%) Finance
2 30 (16.04%) Banking
3 12 (6.42%) Manufacturing
4 9 (4.81%) Retail
5 7 (3.74%) Games
6 4 (2.14%) Corporate Banking
7 2 (1.07%) Billing
7 2 (1.07%) Front Office
8 1 (0.53%) Marketing
8 1 (0.53%) Retail Banking
8 1 (0.53%) Telecoms
Job Titles
1 104 (55.61%) Developer
2 53 (28.34%) Consultant
3 41 (21.93%) Business Intelligence Developer
4 40 (21.39%) Business Intelligence Consultant
5 22 (11.76%) ETL Developer
6 18 (9.63%) Analyst
7 14 (7.49%) Business Consultant
7 14 (7.49%) SQL Developer
8 13 (6.95%) QlikView Developer
9 10 (5.35%) Big Data Developer
10 9 (4.81%) Oracle BI Developer
10 9 (4.81%) Oracle Developer
11 7 (3.74%) ETL Consultant
12 6 (3.21%) Architect
12 6 (3.21%) QlikView Consultant
13 5 (2.67%) Applications Developer
13 5 (2.67%) Senior Developer
13 5 (2.67%) Test Analyst
14 4 (2.14%) Service Manager
14 4 (2.14%) Test Engineer
Libraries, Frameworks & Software Standards
1 21 (11.23%) .NET
2 19 (10.16%) ASP.NET
3 16 (8.56%) ASP.NET MVC 5
3 16 (8.56%) ASP.NET Web Forms
3 16 (8.56%) WinForms
4 5 (2.67%) Drools
4 5 (2.67%) Middleware
5 4 (2.14%) RESTful
5 4 (2.14%) Web Services
6 3 (1.60%) MDX
6 3 (1.60%) OpenMP
6 3 (1.60%) XML
7 2 (1.07%) .NET Framework
8 1 (0.53%) COM
8 1 (0.53%) CSS
8 1 (0.53%) jQuery
8 1 (0.53%) Spring
8 1 (0.53%) TIBCO EMS
8 1 (0.53%) WCF
8 1 (0.53%) XSLT
Miscellaneous
1 31 (16.58%) Analytical Skills
2 27 (14.44%) Visualisation
3 14 (7.49%) Data Integration
4 13 (6.95%) Management Information System
5 8 (4.28%) Computer Science
5 8 (4.28%) Mathematics
6 7 (3.74%) Enterprise Software
7 6 (3.21%) Fintech
7 6 (3.21%) User Experience
8 3 (1.60%) Driving Licence
8 3 (1.60%) Statistics
9 2 (1.07%) EPoS
10 1 (0.53%) Algorithms
10 1 (0.53%) Clustering
10 1 (0.53%) Data Structures
Operating Systems
1 27 (14.44%) Unix
2 9 (4.81%) Linux
3 7 (3.74%) Windows
4 1 (0.53%) AIX
4 1 (0.53%) Red Hat Enterprise Linux
4 1 (0.53%) Windows Server
Processes & Methodologies
1 99 (52.94%) Business Intelligence
2 55 (29.41%) Agile Software Development
3 49 (26.20%) Stakeholder Management
4 45 (24.06%) Data Management
5 44 (23.53%) Data Modelling
6 42 (22.46%) ETL Development
7 37 (19.79%) Asset Management
8 33 (17.65%) Data Analysis
9 23 (12.30%) PRINCE2
10 22 (11.76%) Enterprise Data Management
11 20 (10.70%) Dimensional Modelling
11 20 (10.70%) SDLC
12 19 (10.16%) Analytics
13 18 (9.63%) MVC
14 16 (8.56%) Fund Accounting
14 16 (8.56%) Software Architecture
15 15 (8.02%) Scrum
16 13 (6.95%) CRM
16 13 (6.95%) Data Governance
17 11 (5.88%) Software Engineering
Programming Languages
1 85 (45.45%) SQL
2 27 (14.44%) C#
3 25 (13.37%) Java
4 23 (12.30%) Perl
4 23 (12.30%) PL/SQL
5 16 (8.56%) Korn
5 16 (8.56%) VB
6 12 (6.42%) Python
6 12 (6.42%) T-SQL
7 8 (4.28%) C++
8 6 (3.21%) VBA
9 5 (2.67%) R
10 4 (2.14%) Ruby
11 3 (1.60%) Shell Script
12 2 (1.07%) VB.NET
13 1 (0.53%) JavaScript
13 1 (0.53%) PowerShell
Qualifications
1 22 (11.76%) PRINCE2 Practitioner
1 22 (11.76%) Security Cleared
2 13 (6.95%) Degree
3 5 (2.67%) ISEB
3 5 (2.67%) ISTQB
3 5 (2.67%) ISTQB Foundation Certification
4 2 (1.07%) MCSA
4 2 (1.07%) Microsoft Certification
Quality Assurance & Compliance
1 22 (11.76%) Data Quality
2 8 (4.28%) QA
3 4 (2.14%) COBIT
4 1 (0.53%) ISO 9001
4 1 (0.53%) SLA
Systems Management
1 1 (0.53%) Control-M
1 1 (0.53%) HP Quality Center
Vendors
1 59 (31.55%) Oracle
2 44 (23.53%) Cognos
3 37 (19.79%) Informatica
4 27 (14.44%) Microsoft
5 22 (11.76%) Talend
6 18 (9.63%) Tableau
7 17 (9.09%) Ab Initio
7 17 (9.09%) Teradata
8 9 (4.81%) MicroStrategy
9 7 (3.74%) SAP
10 6 (3.21%) Hyperion
10 6 (3.21%) IBM
11 2 (1.07%) ATG
11 2 (1.07%) Charles River
11 2 (1.07%) Netezza
12 1 (0.53%) ESRI
12 1 (0.53%) Lotus
12 1 (0.53%) Red Hat
12 1 (0.53%) Sybase
12 1 (0.53%) TIBCO
Glasgow, Lanarkshire
Cognizant
Posted: 19 hours ago
Glasgow, Lanarkshire
NSK International Consultants Ltd
Salary: From £55,000 to £65,000 per annum
Posted: 4 days ago
Glasgow
Churchill Frank International
Salary: £40000 - £60000 per annum
Posted: 5 days ago
Edinburgh, Midlothian
Harvey Nash plc
Posted: 6 days ago
Glasgow
Hays Specialist Recruitment Ltd
Salary: £36000.00 - £40000.00 per annum
Posted: 7 days ago
Edinburgh
Churchill Frank International
Salary: £60000 - £70000 per annum + Bonus, SAS Training & Perks
Posted: 8 days ago
Edinburgh
Churchill Frank International
Salary: £30000 - £45000 per annum
Posted: 12 days ago
Glasgow
Recruitment Revolution Limited
Salary: Competitive Salary + Benefits Package
Posted: 13 days ago
Edinburgh
Cathcart Associates
Salary: £40000 - £69000 per annum + Benefits
Posted: 18 days ago
Glasgow
Vivid Resourcing
Posted: 21 days ago
Glasgow, Scotland
JP Morgan Glasgow
Salary: Competitive + Benefits
Posted: 26 days ago