Period
to 25 June 2019

The following table provides summary statistics for permanent job vacancies advertised in Glasgow with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 25 June 2019 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Scotland > Glasgow
6 months to
25 Jun 2019
Same period 2018 Same period 2017
Rank 48 88 69
Rank change year-on-year +40 -19 +3
Permanent jobs citing ETL 94 84 77
As % of all permanent IT jobs advertised in Glasgow 5.03% 3.45% 3.63%
As % of the Processes & Methodologies category 5.33% 3.62% 3.88%
Number of salaries quoted 72 78 31
Glasgow median annual salary £45,000 £42,500 £45,000
Median salary % change year-on-year +5.88% -5.56% -5.26%
10th Percentile £36,250 £28,250 £36,250
90th Percentile £74,200 £55,000 £51,250
Scotland median annual salary £45,000 £42,500 £45,000
% change year-on-year +5.88% -5.56% -5.26%

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Glasgow with a requirement for process or methodology skills.

All Process and Methodology Skills
Glasgow
Permanent vacancies with a requirement for process or methodology skills 1,763 2,321 1,982
As % of all permanent IT jobs advertised in Glasgow 94.33% 95.24% 93.45%
Number of salaries quoted 1,243 1,688 1,223
Glasgow median annual salary £45,000 £47,500 £45,000
Median salary % change year-on-year -5.26% +5.56% +5.88%
10th Percentile £31,250 £31,250 £29,750
90th Percentile £67,500 £70,000 £70,000
Scotland median annual salary £45,000 £45,000 £45,000

ETL
Job Vacancy Trend in Glasgow

Job postings citing ETL as a percentage of all IT jobs advertised in Glasgow.

Job vacancy trend for ETL in Glasgow

ETL
Salary Trend in Glasgow

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

Salary trend for ETL in Glasgow

ETL
Salary Histogram in Glasgow

The salary distribution of IT jobs citing ETL in Glasgow over the 6 months to 25 June 2019.

Salary histogram for ETL in Glasgow

For the 6 months to 25 June 2019, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Glasgow region with a requirement for ETL.

1 67 (71.28%) SQL
2 64 (68.09%) SQL Server
3 45 (47.87%) Business Intelligence
4 37 (39.36%) Finance
5 35 (37.23%) SQL Server Integration Services
6 34 (36.17%) Oracle
7 30 (31.91%) Agile Software Development
7 30 (31.91%) Analytical Skills
8 28 (29.79%) Power BI
8 28 (29.79%) Power Platform
9 26 (27.66%) SQL Server Reporting Services
10 25 (26.60%) T-SQL
11 24 (25.53%) Microsoft
12 23 (24.47%) Visualisation
12 23 (24.47%) Analytics
13 22 (23.40%) Data Warehouse
14 21 (22.34%) Anti-Money Laundering
15 20 (21.28%) Microsoft Azure
16 19 (20.21%) Python
16 19 (20.21%) PL/SQL
17 18 (19.15%) Data Modelling
17 18 (19.15%) Unix
17 18 (19.15%) Problem-Solving
18 17 (18.09%) SQL Server Analysis Services
19 16 (17.02%) Big Data
20 14 (14.89%) NoSQL
20 14 (14.89%) Hadoop
21 13 (13.83%) Data Analysis
21 13 (13.83%) Ab Initio
21 13 (13.83%) Data Science

ETL
Co-occurring IT Skills in Glasgow 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 11 (11.70%) Apache Spark
2 4 (4.26%) Apache
3 2 (2.13%) SAS
3 2 (2.13%) SharePoint
4 1 (1.06%) Confluence
Applications
1 7 (7.45%) Microsoft Office
2 5 (5.32%) Microsoft Excel
2 5 (5.32%) Microsoft PowerPoint
2 5 (5.32%) MS Visio
Business Applications
1 2 (2.13%) Adobe Campaign
1 2 (2.13%) HFM
1 2 (2.13%) Hyperion Planning
2 1 (1.06%) Actimize
Cloud Services
1 28 (29.79%) Power Platform
2 20 (21.28%) Microsoft Azure
3 9 (9.57%) Amazon AWS
4 5 (5.32%) Amazon S3
4 5 (5.32%) Azure Data Factory
5 4 (4.26%) Cloud Computing
5 4 (4.26%) PaaS
6 3 (3.19%) Amazon EC2
6 3 (3.19%) AWS Lambda
6 3 (3.19%) Serverless
7 2 (2.13%) Amazon EMR
7 2 (2.13%) SaaS
8 1 (1.06%) Google Cloud Platform
Communications & Networking
1 5 (5.32%) Internet
Database & Business Intelligence
1 64 (68.09%) SQL Server
2 35 (37.23%) SQL Server Integration Services
3 28 (29.79%) Power BI
4 26 (27.66%) SQL Server Reporting Services
5 22 (23.40%) Data Warehouse
6 17 (18.09%) SQL Server Analysis Services
7 16 (17.02%) Big Data
8 14 (14.89%) Hadoop
8 14 (14.89%) NoSQL
9 11 (11.70%) Azure SQL Database
9 11 (11.70%) Relational Database
10 10 (10.64%) RDBMS
11 9 (9.57%) Oracle BI EE
11 9 (9.57%) Oracle Database
11 9 (9.57%) QlikView
12 8 (8.51%) Data Lake
12 8 (8.51%) SQL Server 2012
13 7 (7.45%) Oracle ODI
14 5 (5.32%) Apache Hive
14 5 (5.32%) IBM InfoSphere
Development Applications
1 6 (6.38%) Oracle Forms
2 5 (5.32%) Visual Studio
3 4 (4.26%) JIRA
4 2 (2.13%) IntelliJ
5 1 (1.06%) SQL Server Management Studio (SSMS)
General
1 37 (39.36%) Finance
2 12 (12.77%) Banking
3 10 (10.64%) Financial Institution
4 5 (5.32%) Marketing
5 3 (3.19%) International Banking
5 3 (3.19%) Legal
6 2 (2.13%) Corporate Banking
Job Titles
1 46 (48.94%) Developer
2 17 (18.09%) SQL Developer
3 14 (14.89%) Data Engineer
4 11 (11.70%) ETL Developer
5 7 (7.45%) Business Intelligence Developer
5 7 (7.45%) Consultant
6 6 (6.38%) Oracle Developer
6 6 (6.38%) Senior Developer
7 5 (5.32%) Technical Leader
8 4 (4.26%) Analyst
8 4 (4.26%) Data Scientist
8 4 (4.26%) SSIS Developer
9 3 (3.19%) Architect
9 3 (3.19%) Business Consultant
9 3 (3.19%) Business Developer
9 3 (3.19%) Business Intelligence Consultant
9 3 (3.19%) Enterprise Architect
9 3 (3.19%) Lead Developer
9 3 (3.19%) Senior Data Engineer
9 3 (3.19%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 4 (4.26%) Drools
1 4 (4.26%) Kafka
2 3 (3.19%) PySpark
2 3 (3.19%) Web Services
3 2 (2.13%) AngularJS
3 2 (2.13%) LAPP Stack
3 2 (2.13%) RESTful
3 2 (2.13%) Velocity
4 1 (1.06%) .NET
4 1 (1.06%) ASP.NET
4 1 (1.06%) JSON
4 1 (1.06%) REST
4 1 (1.06%) SOAP
4 1 (1.06%) Spring
Miscellaneous
1 30 (31.91%) Analytical Skills
2 8 (8.51%) Self-Motivation
3 4 (4.26%) Algorithms
4 3 (3.19%) Digital Media
4 3 (3.19%) User Experience
5 2 (2.13%) Internet of Things
5 2 (2.13%) Marketing Technology
5 2 (2.13%) SWIFT
6 1 (1.06%) Data Structures
6 1 (1.06%) Driving Licence
6 1 (1.06%) Management Information System
6 1 (1.06%) Market Risk
6 1 (1.06%) Virtual Team
Operating Systems
1 18 (19.15%) Unix
2 3 (3.19%) Android
2 3 (3.19%) Apple iOS
3 2 (2.13%) Linux
4 1 (1.06%) Windows
Processes & Methodologies
1 45 (47.87%) Business Intelligence
2 30 (31.91%) Agile Software Development
3 23 (24.47%) Analytics
3 23 (24.47%) Visualisation
4 21 (22.34%) Anti-Money Laundering
5 18 (19.15%) Data Modelling
5 18 (19.15%) Problem-Solving
6 13 (13.83%) Data Analysis
6 13 (13.83%) Data Science
7 12 (12.77%) ETL Development
8 11 (11.70%) Information Security
9 10 (10.64%) Data Architecture
9 10 (10.64%) Data Integration
9 10 (10.64%) Data Management
10 9 (9.57%) Data Engineering
11 8 (8.51%) Data Acquisition
12 7 (7.45%) Stakeholder Management
13 6 (6.38%) Data Transformation
13 6 (6.38%) Metadata Management
13 6 (6.38%) SDLC
Programming Languages
1 67 (71.28%) SQL
2 25 (26.60%) T-SQL
3 19 (20.21%) PL/SQL
3 19 (20.21%) Python
4 12 (12.77%) Java
5 11 (11.70%) Shell Script
6 10 (10.64%) R
7 8 (8.51%) C
8 7 (7.45%) Scala
9 5 (5.32%) Perl
10 4 (4.26%) JavaScript
11 3 (3.19%) Bash Shell
12 2 (2.13%) Ruby
12 2 (2.13%) VBScript
13 1 (1.06%) C#
13 1 (1.06%) MATLAB
13 1 (1.06%) VB
Qualifications
1 1 (1.06%) Computer Science Degree
1 1 (1.06%) Degree
Quality Assurance & Compliance
1 6 (6.38%) Data Quality
2 4 (4.26%) GDPR
2 4 (4.26%) QA
3 2 (2.13%) ISO/IEC 27001
3 2 (2.13%) SEPA
System Software
1 3 (3.19%) HDFS
2 2 (2.13%) Apache Flume
Systems Management
1 2 (2.13%) Hadoop YARN
Vendors
1 34 (36.17%) Oracle
2 24 (25.53%) Microsoft
3 13 (13.83%) Ab Initio
4 12 (12.77%) Tableau
5 8 (8.51%) Informatica
6 7 (7.45%) Databricks
6 7 (7.45%) Hyperion
7 3 (3.19%) Roku
7 3 (3.19%) Virgin Media
8 2 (2.13%) Adobe
8 2 (2.13%) Cloudera
8 2 (2.13%) Hortonworks
9 1 (1.06%) Cognos
9 1 (1.06%) IBM
9 1 (1.06%) MicroStrategy
9 1 (1.06%) Salesforce.com