Period
to 10 August 2020

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 10 August 2020 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Scotland > Glasgow
6 months to
10 Aug 2020
Same period 2019 Same period 2018
Rank 68 47 81
Rank change year-on-year -21 +34 -15
Permanent jobs citing ETL 14 99 82
As % of all permanent jobs advertised in Glasgow 1.63% 5.31% 3.54%
As % of the Processes & Methodologies category 1.73% 5.66% 3.74%
Number of salaries quoted 10 88 73
Median annual salary £43,500 £42,500 £42,500
Median salary % change year-on-year +2.35% - -
10th Percentile £38,375 £35,725 £28,250
90th Percentile £47,825 £71,125 £53,750
Scotland median annual salary £43,500 £45,000 £44,000
% change year-on-year -3.33% +2.27% -2.22%

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 809 1,749 2,195
As % of all permanent IT jobs advertised in Glasgow 94.07% 93.78% 94.73%
Number of salaries quoted 552 1,223 1,618
Median annual salary £47,500 £45,000 £47,500
Median salary % change year-on-year +5.56% -5.26% +5.56%
10th Percentile £32,500 £31,250 £31,070
90th Percentile £65,000 £70,000 £67,500
Scotland median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - -

ETL
Job Vacancy Trend in Glasgow

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

Job vacancy trend for ETL in Glasgow

ETL
Salary Trend in Glasgow

3-month moving average salary quoted in jobs citing ETL in Glasgow.

Salary trend for ETL in Glasgow

For the 6 months to 10 August 2020, 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 12 (85.71%) Analytics
2 11 (78.57%) SQL
2 11 (78.57%) Data Warehouse
3 6 (42.86%) Business Intelligence
3 6 (42.86%) Data Modelling
4 5 (35.71%) Microsoft
4 5 (35.71%) SQL Server Integration Services
5 4 (28.57%) QlikView
5 4 (28.57%) SQL Server Analysis Services
5 4 (28.57%) SAS
5 4 (28.57%) Azure
5 4 (28.57%) MicroStrategy
5 4 (28.57%) Cognos
5 4 (28.57%) Oracle
5 4 (28.57%) SQL Server Reporting Services
6 3 (21.43%) Driving Licence
6 3 (21.43%) Data Development
6 3 (21.43%) Data Analytics
6 3 (21.43%) Metadata Management
6 3 (21.43%) PL/SQL
6 3 (21.43%) Python
6 3 (21.43%) Data Governance
6 3 (21.43%) Data Integration
6 3 (21.43%) Agile Software Development
6 3 (21.43%) Degree
7 2 (14.29%) JIRA
7 2 (14.29%) Continuous Integration
7 2 (14.29%) Scala
7 2 (14.29%) AWS
7 2 (14.29%) Java

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 4 (28.57%) SAS
2 1 (7.14%) Apache Spark
Cloud Services
1 4 (28.57%) Azure
2 2 (14.29%) AWS
2 2 (14.29%) Azure Data Factory
Database & Business Intelligence
1 11 (78.57%) Data Warehouse
2 5 (35.71%) SQL Server Integration Services
3 4 (28.57%) QlikView
3 4 (28.57%) SQL Server Analysis Services
3 4 (28.57%) SQL Server Reporting Services
4 2 (14.29%) Azure SQL Data Warehouse
4 2 (14.29%) Big Data
4 2 (14.29%) Data Lake
4 2 (14.29%) PostgreSQL
4 2 (14.29%) SQL Server
5 1 (7.14%) Azure SQL Database
5 1 (7.14%) Cosmos DB
5 1 (7.14%) Data Mining
5 1 (7.14%) SQL Server 2000
Development Applications
1 2 (14.29%) JIRA
2 1 (7.14%) Git (software)
2 1 (7.14%) Visual Studio
General
1 1 (7.14%) Banking
1 1 (7.14%) Finance
Job Titles
1 6 (42.86%) Developer
2 4 (28.57%) Data Engineer
3 3 (21.43%) Cognos Developer
3 3 (21.43%) Designer
4 1 (7.14%) Big Data Engineer
4 1 (7.14%) Data Warehouse Developer
4 1 (7.14%) ETL Developer
4 1 (7.14%) Java Developer
4 1 (7.14%) Lead Designer
4 1 (7.14%) Security Engineer
4 1 (7.14%) SQL Developer
4 1 (7.14%) Technical Designer
4 1 (7.14%) Technical Leader
Libraries, Frameworks & Software Standards
1 1 (7.14%) Apache NiFi
1 1 (7.14%) Kafka
1 1 (7.14%) PySpark
1 1 (7.14%) Spring
1 1 (7.14%) Velocity
Miscellaneous
1 3 (21.43%) Driving Licence
2 2 (14.29%) Greenfield Project
3 1 (7.14%) Client/Server
3 1 (7.14%) Data Centre
3 1 (7.14%) Data Structures
3 1 (7.14%) Replication
3 1 (7.14%) Self-Motivation
Operating Systems
1 2 (14.29%) Linux
2 1 (7.14%) Unix
Processes & Methodologies
1 12 (85.71%) Analytics
2 6 (42.86%) Business Intelligence
2 6 (42.86%) Data Modelling
3 3 (21.43%) Agile Software Development
3 3 (21.43%) Data Analytics
3 3 (21.43%) Data Development
3 3 (21.43%) Data Governance
3 3 (21.43%) Data Integration
3 3 (21.43%) Metadata Management
4 2 (14.29%) Continuous Integration
4 2 (14.29%) Machine Learning
5 1 (7.14%) Application Performance Monitoring
5 1 (7.14%) Build Automation
5 1 (7.14%) Data Architecture
5 1 (7.14%) DevOps
5 1 (7.14%) Mentoring
5 1 (7.14%) Performance Monitoring
5 1 (7.14%) Scrum
5 1 (7.14%) Test Automation
5 1 (7.14%) Visualisation
Programming Languages
1 11 (78.57%) SQL
2 3 (21.43%) PL/SQL
2 3 (21.43%) Python
3 2 (14.29%) Java
3 2 (14.29%) Scala
4 1 (7.14%) Bash Shell
Qualifications
1 3 (21.43%) Degree
2 1 (7.14%) Computer Science Degree
System Software
1 1 (7.14%) Apache ZooKeeper
Systems Management
1 1 (7.14%) Ansible
Vendors
1 5 (35.71%) Microsoft
2 4 (28.57%) Cognos
2 4 (28.57%) MicroStrategy
2 4 (28.57%) Oracle
3 1 (7.14%) Ab Initio
3 1 (7.14%) Alteryx
3 1 (7.14%) Databricks
3 1 (7.14%) Netezza
3 1 (7.14%) Tableau
3 1 (7.14%) Talend