Period
to 19 October 2018

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 19 October 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Scotland > Glasgow
6 months to
19 Oct 2018
Same period 2017 Same period 2016
Rank 81 86 68
Rank change year-on-year +5 -18 -20
Permanent jobs citing ETL 78 66 89
As % of all permanent IT jobs advertised in Glasgow 3.56% 2.95% 3.93%
As % of the Processes & Methodologies category 3.78% 3.20% 4.16%
Number of salaries quoted 57 18 41
Glasgow median annual salary £45,000 £38,750 £48,500
Median salary % change year-on-year +16.13% -20.10% +2.11%
10th Percentile £32,500 £34,625 £33,000
90th Percentile £54,250 £60,500 £56,250
Scotland median annual salary £45,000 £45,000 £50,000
% change year-on-year - -10.00% +8.70%

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 2,064 2,061 2,137
As % of all permanent IT jobs advertised in Glasgow 94.33% 92.17% 94.27%
Number of salaries quoted 1,513 1,333 1,131
Glasgow median annual salary £47,500 £45,000 £42,500
Median salary % change year-on-year +5.56% +5.88% -
10th Percentile £31,250 £31,250 £27,750
90th Percentile £65,000 £67,500 £60,000
Scotland median annual salary £45,500 £44,000 £44,000
% change year-on-year +3.41% - +3.53%

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 19 October 2018.

Salary histogram for ETL in Glasgow

For the 6 months to 19 October 2018, 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 71 (91.03%) SQL
2 57 (73.08%) Business Intelligence
3 38 (48.72%) SQL Server
3 38 (48.72%) SQL Server Integration Services
4 36 (46.15%) Data Warehouse
5 34 (43.59%) Power BI
6 32 (41.03%) SQL Server Reporting Services
7 30 (38.46%) T-SQL
8 27 (34.62%) Data Modelling
9 26 (33.33%) Microsoft
9 26 (33.33%) Analytical Skills
10 25 (32.05%) Visualisation
11 24 (30.77%) Oracle
12 21 (26.92%) SQL Server Analysis Services
13 19 (24.36%) Amazon AWS
14 18 (23.08%) Analytics
15 17 (21.79%) Cognos
16 16 (20.51%) Finance
16 16 (20.51%) Microsoft Azure
16 16 (20.51%) Tableau
17 14 (17.95%) Relational Database
18 13 (16.67%) Problem-Solving
19 11 (14.10%) Python
19 11 (14.10%) Informatica
19 11 (14.10%) Data Analysis
19 11 (14.10%) Data Engineering
19 11 (14.10%) Data Visualisation
19 11 (14.10%) Data Quality
20 10 (12.82%) Banking
20 10 (12.82%) QlikView

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 8 (10.26%) SAS
2 7 (8.97%) Apache Spark
3 6 (7.69%) Apache Pig
4 3 (3.85%) Oracle Workflow
4 3 (3.85%) Tomcat
4 3 (3.85%) WebLogic
Applications
1 2 (2.56%) Microsoft Excel
Business Applications
1 1 (1.28%) Cognos Business Intelligence
1 1 (1.28%) Cognos TM1
1 1 (1.28%) Oracle AML
Cloud Services
1 19 (24.36%) Amazon AWS
2 16 (20.51%) Microsoft Azure
3 6 (7.69%) Amazon EMR
4 2 (2.56%) Azure Data Factory
Database & Business Intelligence
1 38 (48.72%) SQL Server
1 38 (48.72%) SQL Server Integration Services
2 36 (46.15%) Data Warehouse
3 34 (43.59%) Power BI
4 32 (41.03%) SQL Server Reporting Services
5 21 (26.92%) SQL Server Analysis Services
6 14 (17.95%) Relational Database
7 10 (12.82%) QlikView
8 8 (10.26%) Big Data
8 8 (10.26%) SQL Server 2012
9 7 (8.97%) Hadoop
9 7 (8.97%) Qlik Sense
10 6 (7.69%) Amazon Redshift
10 6 (7.69%) Apache Hive
10 6 (7.69%) Oracle Database
10 6 (7.69%) Sqoop
11 5 (6.41%) RDBMS
12 4 (5.13%) BusinessObjects
12 4 (5.13%) OLAP
13 3 (3.85%) SQL Server 2005
Development Applications
1 1 (1.28%) Cucumber
1 1 (1.28%) FitNesse
1 1 (1.28%) Gradle
1 1 (1.28%) Oracle Forms
1 1 (1.28%) Selenium
1 1 (1.28%) SQL Server Management Studio (SSMS)
1 1 (1.28%) Visual Studio
General
1 16 (20.51%) Finance
2 10 (12.82%) Banking
3 7 (8.97%) Investment Banking
3 7 (8.97%) Law
4 3 (3.85%) Retail
5 2 (2.56%) Advertising
5 2 (2.56%) Legal
6 1 (1.28%) Manufacturing
Job Titles
1 39 (50.00%) Developer
2 21 (26.92%) Consultant
3 16 (20.51%) SQL Developer
4 15 (19.23%) Database Developer
5 13 (16.67%) Business Intelligence Consultant
6 10 (12.82%) Analyst
6 10 (12.82%) Business Intelligence Developer
7 9 (11.54%) Business Consultant
8 7 (8.97%) SQL Database Developer
9 6 (7.69%) AWS Consultant
9 6 (7.69%) Senior Developer
10 5 (6.41%) Big Data Consultant
10 5 (6.41%) Data Analyst
10 5 (6.41%) Data Consultant
10 5 (6.41%) ETL Developer
10 5 (6.41%) Lead Developer
10 5 (6.41%) Support Analyst
11 4 (5.13%) Business Intelligence Analyst
11 4 (5.13%) Business Intelligence Support Analyst
11 4 (5.13%) Business Support Analyst
Libraries, Frameworks & Software Standards
1 4 (5.13%) Spring
2 3 (3.85%) HTML
2 3 (3.85%) J2EE
3 2 (2.56%) .NET
4 1 (1.28%) ASP.NET
Miscellaneous
1 26 (33.33%) Analytical Skills
2 2 (2.56%) Algorithms
2 2 (2.56%) Analytical Mindset
2 2 (2.56%) Reference Data
3 1 (1.28%) Greenfield Project
3 1 (1.28%) Management Information System
Operating Systems
1 7 (8.97%) Unix
2 3 (3.85%) Windows
2 3 (3.85%) Windows Server
Processes & Methodologies
1 57 (73.08%) Business Intelligence
2 27 (34.62%) Data Modelling
3 25 (32.05%) Visualisation
4 18 (23.08%) Analytics
5 13 (16.67%) Problem-Solving
6 11 (14.10%) Data Analysis
6 11 (14.10%) Data Engineering
6 11 (14.10%) Data Visualisation
7 9 (11.54%) Data Extraction
7 9 (11.54%) Database Theory
7 9 (11.54%) Procedural Programming
7 9 (11.54%) Relational Database Theory
8 8 (10.26%) Analytical Thinking
9 7 (8.97%) Risk Management
9 7 (8.97%) Wealth Management
10 6 (7.69%) Business Analysis
10 6 (7.69%) Creative Thinking
10 6 (7.69%) Stakeholder Management
11 5 (6.41%) Complex ETL
11 5 (6.41%) Reverse Engineering
Programming Languages
1 71 (91.03%) SQL
2 30 (38.46%) T-SQL
3 11 (14.10%) Python
4 9 (11.54%) Bash Shell
4 9 (11.54%) Scala
5 8 (10.26%) R
6 4 (5.13%) Java
6 4 (5.13%) PL/SQL
7 2 (2.56%) C#
8 1 (1.28%) Data Analysis Expressions (DAX)
8 1 (1.28%) Shell Script
Qualifications
1 2 (2.56%) Degree
Quality Assurance & Compliance
1 11 (14.10%) Data Quality
2 4 (5.13%) QA
System Software
1 6 (7.69%) HDFS
Systems Management
1 7 (8.97%) Systems Management Server (SMS)
2 6 (7.69%) Oozie
Vendors
1 26 (33.33%) Microsoft
2 24 (30.77%) Oracle
3 17 (21.79%) Cognos
4 16 (20.51%) Tableau
5 11 (14.10%) Informatica
6 5 (6.41%) Vertica
7 3 (3.85%) IBM
7 3 (3.85%) IDERA
7 3 (3.85%) RedGate
8 2 (2.56%) Alteryx
8 2 (2.56%) MicroStrategy
8 2 (2.56%) OutlookSoft
9 1 (1.28%) Salesforce.com
9 1 (1.28%) SAP
9 1 (1.28%) Talend
9 1 (1.28%) Twitter