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

Location
3 months to
20 Oct 2014
Same period 2013 Same period 2012
Extract, Transform and Load (ETL)
Rank 98 44 53
Rank change year-on-year
-54 +9
Permanent jobs citing ETL 68 144 128
As % of all permanent IT jobs located in Scotland 1.98% 4.54% 4.03%
As % of the Processes & Methodologies category 2.37% 5.66% 5.25%
Number of salaries quoted 29 83 96
Average salary £42,500 £45,000 £45,000
Average salary % change year-on-year
-5.55% -
90% offered a salary of more than £33,700 £35,000 £35,000
10% offered a salary of more than £65,000 £55,500 £60,000
UK excluding London average salary £45,500 £45,000 £42,500
% change year-on-year
+1.11% +5.88%
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
2869 2546 2437
As % of all permanent IT jobs located in Scotland 83.50% 80.24% 76.64%
Number of salaries quoted 1823 1617 1632
Average salary £42,500 £42,500 £42,500
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £61,250 £60,000 £60,000
UK excluding London average salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

ETL
Jobs Demand Trend in Scotland

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

ETL Salary Histogram in Scotland

ETL
Job Locations in Scotland

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing ETL within the Scotland region over the 3 months to 20 October 2014. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow -13 36 £40,000 -5.88% 10
Edinburgh -67 16 £47,500 -5.00% 6
Stirling - 9 - -
Aberdeen +6 1 - - 2
Renfrewshire - 1 - -
North Lanarkshire - 1 - -
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 20 October 2014, IT jobs across the Scotland 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 93 (63.70%) SQL
2 77 (52.74%) Business Intelligence
3 75 (51.37%) Finance
4 74 (50.68%) Oracle
5 53 (36.30%) Data Warehouse
6 41 (28.08%) Informatica
7 36 (24.66%) SQL Server
8 35 (23.97%) PL/SQL
9 32 (21.92%) Java
9 32 (21.92%) Banking
10 31 (21.23%) Data Modelling
11 30 (20.55%) Agile Software Development
11 30 (20.55%) SQL Server Integration Services
12 27 (18.49%) UNIX
13 26 (17.81%) SQL Server Reporting Services
14 22 (15.07%) Business Objects
14 22 (15.07%) Oracle Database
15 21 (14.38%) Performance Tuning
16 20 (13.70%) SAP
17 19 (13.01%) Migration
18 18 (12.33%) Data Management
19 17 (11.64%) SQL Server Analysis Services
19 17 (11.64%) Relational Database
20 16 (10.96%) QlikView
20 16 (10.96%) Oracle BI EE
20 16 (10.96%) Microsoft
20 16 (10.96%) Linux
20 16 (10.96%) RDBMS
21 15 (10.27%) Oracle Reports
21 15 (10.27%) Cognos

ETL
Top Related IT Skills in Scotland by Category

For the 6 months to 20 October 2014, IT jobs across the Scotland 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 14 (9.59%) SharePoint
2 12 (8.22%) SAS
3 5 (3.42%) WebSphere
4 4 (2.74%) WebLogic
5 3 (2.05%) Tomcat
5 3 (2.05%) NetWeaver
6 2 (1.37%) Oracle Application Server
6 2 (1.37%) WebSphere Application Server
6 2 (1.37%) JBoss
6 2 (1.37%) Oracle SOA Suite
7 1 (0.68%) Elasticsearch
Applications
1 12 (8.22%) MS Excel
2 3 (2.05%) Spreadsheet
3 1 (0.68%) MS Project
3 1 (0.68%) MS Visio
3 1 (0.68%) SPSS
Business Applications
1 7 (4.79%) Oracle EBS
2 4 (2.74%) Dynamics AX
2 4 (2.74%) Cognos Business Intelligence
3 3 (2.05%) SAP BPC
3 3 (2.05%) Oracle ERP
4 2 (1.37%) Oracle 11i
4 2 (1.37%) Oracle BPM
4 2 (1.37%) Cognos TM1
5 1 (0.68%) Agresso
5 1 (0.68%) HFM
Communications & Networking
1 2 (1.37%) FTP
2 1 (0.68%) HTTPS
2 1 (0.68%) SSL
2 1 (0.68%) Intranet
Database & Business Intelligence
1 53 (36.30%) Data Warehouse
2 36 (24.66%) SQL Server
3 30 (20.55%) SQL Server Integration Services
4 26 (17.81%) SQL Server Reporting Services
5 22 (15.07%) Oracle Database
6 17 (11.64%) Relational Database
6 17 (11.64%) SQL Server Analysis Services
7 16 (10.96%) QlikView
7 16 (10.96%) Oracle BI EE
7 16 (10.96%) RDBMS
8 15 (10.27%) Oracle Reports
9 13 (8.90%) Oracle Database 11g
9 13 (8.90%) Data Mart
10 12 (8.22%) Pentaho
10 12 (8.22%) Oracle ODI
11 10 (6.85%) DataStage
12 9 (6.16%) PowerCenter
13 8 (5.48%) Star Schema
14 7 (4.79%) Oracle Database 10g
14 7 (4.79%) Snowflake Schema
Development Applications
1 5 (3.42%) Maven
1 5 (3.42%) Team Foundation Server
2 4 (2.74%) Talend Open Studio
2 4 (2.74%) Subversion
3 3 (2.05%) Git (software)
4 2 (1.37%) TestNG
4 2 (1.37%) ERwin
4 2 (1.37%) JBehave
4 2 (1.37%) WebDriver
4 2 (1.37%) SoapUI
4 2 (1.37%) JIRA
4 2 (1.37%) Oracle APEX
4 2 (1.37%) Selenium
4 2 (1.37%) JUnit
4 2 (1.37%) Toad
5 1 (0.68%) PowerDesigner
5 1 (0.68%) Visual Studio
5 1 (0.68%) Rational Application Developer
5 1 (0.68%) FishEye
5 1 (0.68%) Jenkins
General
1 75 (51.37%) Finance
2 32 (21.92%) Banking
3 11 (7.53%) Retail
3 11 (7.53%) Investment Banking
4 8 (5.48%) Telecoms
5 3 (2.05%) Aerospace
5 3 (2.05%) Retail Banking
5 3 (2.05%) Private Banking
6 2 (1.37%) Front Office
7 1 (0.68%) General Ledger
Job Titles
1 84 (57.53%) Developer
2 27 (18.49%) ETL Developer
3 21 (14.38%) Consultant
4 16 (10.96%) Analyst
5 14 (9.59%) Architect
6 13 (8.90%) Business Intelligence Developer
7 12 (8.22%) Oracle Developer
7 12 (8.22%) OBIEE Consultant
8 10 (6.85%) Database Developer
9 9 (6.16%) Business Developer
10 7 (4.79%) Business Objects Developer
11 6 (4.11%) Systems Analyst
11 6 (4.11%) Business Intelligence Consultant
11 6 (4.11%) Senior Developer
11 6 (4.11%) SQL Developer
11 6 (4.11%) QlikView Developer
12 5 (3.42%) Oracle BI Consultant
12 5 (3.42%) Oracle Consultant
13 4 (2.74%) Designer
13 4 (2.74%) DBA
Libraries, Frameworks & Software Standards
1 13 (8.90%) XML
2 10 (6.85%) .NET
3 7 (4.79%) Web Services
4 4 (2.74%) SOAP
5 2 (1.37%) JMS
5 2 (1.37%) Middleware
5 2 (1.37%) FIXML
5 2 (1.37%) Spring
5 2 (1.37%) Java EE
5 2 (1.37%) Oracle Fusion
6 1 (0.68%) ADO.NET Entity Framework
6 1 (0.68%) WCF
6 1 (0.68%) LINQ
6 1 (0.68%) jQuery
6 1 (0.68%) .NET Framework
6 1 (0.68%) HTML
6 1 (0.68%) XSD
6 1 (0.68%) XSLT
6 1 (0.68%) J2EE
6 1 (0.68%) ADO.NET
Miscellaneous
1 14 (9.59%) Data Integration
2 13 (8.90%) Analytical Skills
3 5 (3.42%) Data Extraction
4 2 (1.37%) SWIFT
4 2 (1.37%) Computer Science
4 2 (1.37%) Reference Data
4 2 (1.37%) Data Conversion
5 1 (0.68%) Credit Risk
5 1 (0.68%) Mainframe
5 1 (0.68%) Grid Computing
5 1 (0.68%) Derivative
5 1 (0.68%) Statistics
5 1 (0.68%) Open Source
5 1 (0.68%) Social Media
Operating Systems
1 27 (18.49%) UNIX
2 16 (10.96%) Linux
3 6 (4.11%) Windows
4 2 (1.37%) Solaris
5 1 (0.68%) AIX
Processes & Methodologies
1 77 (52.74%) Business Intelligence
2 31 (21.23%) Data Modelling
3 30 (20.55%) Agile Software Development
4 21 (14.38%) Performance Tuning
5 19 (13.01%) Migration
6 18 (12.33%) Data Management
7 14 (9.59%) Master Data Management
8 13 (8.90%) Analytics
9 9 (6.16%) Asset Management
9 9 (6.16%) ERP
10 7 (4.79%) Stakeholder Management
10 7 (4.79%) Data Migration
11 6 (4.11%) Data Cleansing
11 6 (4.11%) Scrum
11 6 (4.11%) Data Analysis
12 5 (3.42%) Project Management
12 5 (3.42%) Service Management
12 5 (3.42%) ITSM
12 5 (3.42%) CRM
12 5 (3.42%) Predictive Modelling
Programming Languages
1 93 (63.70%) SQL
2 35 (23.97%) PL/SQL
3 32 (21.92%) Java
4 12 (8.22%) T-SQL
4 12 (8.22%) Python
5 10 (6.85%) C#
6 9 (6.16%) VBA
7 5 (3.42%) Shell Script
7 5 (3.42%) VB
7 5 (3.42%) VB.NET
8 3 (2.05%) Perl
9 2 (1.37%) JavaScript
9 2 (1.37%) Ruby
10 1 (0.68%) Scala
Qualifications
1 15 (10.27%) Degree
2 2 (1.37%) ISTQB
2 2 (1.37%) ISEB
3 1 (0.68%) OCP
3 1 (0.68%) OCA
3 1 (0.68%) Oracle Certification
Quality Assurance & Compliance
1 8 (5.48%) QA
2 7 (4.79%) Data Quality
3 5 (3.42%) SLA
4 1 (0.68%) COREP
Systems Management
1 1 (0.68%) Control-M
1 1 (0.68%) HP Quality Center
Vendors
1 74 (50.68%) Oracle
2 41 (28.08%) Informatica
3 22 (15.07%) Business Objects
4 20 (13.70%) SAP
5 16 (10.96%) Microsoft
6 15 (10.27%) Cognos
7 7 (4.79%) MicroStrategy
7 7 (4.79%) Ab Initio
8 6 (4.11%) Tableau
9 5 (3.42%) IBM
10 4 (2.74%) Actimize
10 4 (2.74%) Talend
11 2 (1.37%) Wall Street Systems
11 2 (1.37%) Hyperion
11 2 (1.37%) Sybase
12 1 (0.68%) PeopleSoft
12 1 (0.68%) Siebel
12 1 (0.68%) HP
12 1 (0.68%) Teradata
12 1 (0.68%) Vertica
Glasgow, Lanarkshire
Cognizant
Posted: Yesterday
Edinburgh, Midlothian
Rockhall Recruitment
Salary: From £45,000 to £75,000 per annum + Excellent Package
Posted: 4 days ago
Edinburgh, Midlothian
Experis Ltd
Salary: £35000.00 - £45000.00 per annum
Posted: 5 days ago
Aberdeen, Aberdeenshire
Cathcart Associates Ltd
Salary: Excellent Benefits
Posted: 5 days ago
Glasgow
Hays IT - Uk Posting account
Salary: £45000.00 - £60000.00 per annum
Posted: 6 days ago
Glasgow
Huxley Associates
Salary: competitive
Posted: 7 days ago
Glasgow
Claremont Consulting Limited
Salary: £30000.00 - £55000 per annum
Posted: 11 days ago
Glasgow
Cathcart Associates
Salary: £275 - £350 per day
Posted: 21 days ago