Period
to 24 September 2018

The following table provides summary statistics for permanent job vacancies advertised in Scotland 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 24 September 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
UK > Scotland
6 months to
24 Sep 2018
Same period 2017 Same period 2016
Rank 106 71 80
Rank change year-on-year -35 +9 -12
Permanent jobs citing ETL 142 195 165
As % of all permanent IT jobs advertised in Scotland 2.63% 3.56% 3.07%
As % of the Processes & Methodologies category 2.82% 3.85% 3.31%
Number of salaries quoted 107 83 85
Scotland median annual salary £45,000 £45,000 £50,000
Median salary % change year-on-year - -10.00% +11.11%
10th Percentile £32,200 £32,550 £36,550
90th Percentile £68,750 £59,500 £68,250
UK median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - -4.76%

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 Scotland with a requirement for process or methodology skills.

All Process and Methodology Skills
Scotland
Permanent vacancies with a requirement for process or methodology skills 5,027 5,062 4,981
As % of all permanent IT jobs advertised in Scotland 93.13% 92.29% 92.55%
Number of salaries quoted 3,337 3,202 2,938
Scotland median annual salary £45,750 £44,000 £44,000
Median salary % change year-on-year +3.98% - +3.53%
10th Percentile £29,750 £28,250 £26,750
90th Percentile £70,000 £67,500 £65,000
UK median annual salary £50,000 £50,000 £48,000
% change year-on-year - +4.17% +1.05%

ETL
Job Vacancy Trend in Scotland

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

Job vacancy trend for ETL in Scotland

ETL
Salary Trend in Scotland

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

Salary trend for ETL in Scotland

ETL
Salary Histogram in Scotland

The salary distribution of IT jobs citing ETL in Scotland over the 6 months to 24 September 2018.

Salary histogram for ETL 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 6 months to 24 September 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow -9 72 £45,000 +9.09% 14
Edinburgh -29 63 £45,000 - 18
Aberdeen - 5 £44,676 -
West Lothian - 2 £55,000 -
North Lanarkshire +1 1 £37,500 -9.09%
Falkirk - 1 £65,000 -
ETL
UK

For the 6 months to 24 September 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 Scotland region with a requirement for ETL.

1 117 (82.39%) SQL
2 80 (56.34%) Business Intelligence
3 61 (42.96%) Data Warehouse
4 54 (38.03%) SQL Server Integration Services
5 49 (34.51%) SQL Server
6 45 (31.69%) Finance
7 40 (28.17%) Analytics
8 39 (27.46%) Oracle
8 39 (27.46%) T-SQL
8 39 (27.46%) Data Modelling
9 38 (26.76%) Microsoft
10 33 (23.24%) SQL Server Reporting Services
11 29 (20.42%) SQL Server Analysis Services
12 28 (19.72%) Power BI
13 25 (17.61%) Relational Database
13 25 (17.61%) Amazon AWS
14 24 (16.90%) SAS
15 22 (15.49%) Unix
16 21 (14.79%) Python
16 21 (14.79%) Analytical Skills
17 20 (14.08%) Visualisation
18 19 (13.38%) Data Quality
18 19 (13.38%) Banking
19 18 (12.68%) Data Analysis
20 16 (11.27%) Big Data
20 16 (11.27%) Microsoft Azure
20 16 (11.27%) Agile Software Development
20 16 (11.27%) Star Schema
20 16 (11.27%) Problem-Solving
21 15 (10.56%) Apache Spark

ETL
Co-occurring 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 24 (16.90%) SAS
2 15 (10.56%) Apache Spark
3 14 (9.86%) Apache Pig
4 2 (1.41%) SharePoint
5 1 (0.70%) Apache
5 1 (0.70%) Tomcat
Applications
1 2 (1.41%) Microsoft Excel
Business Applications
1 1 (0.70%) Cognos Business Intelligence
1 1 (0.70%) Cognos TM1
1 1 (0.70%) Dynamics CRM
1 1 (0.70%) Eloqua
Cloud Services
1 25 (17.61%) Amazon AWS
2 16 (11.27%) Microsoft Azure
3 14 (9.86%) Amazon EMR
4 6 (4.23%) Amazon EC2
4 6 (4.23%) Amazon S3
4 6 (4.23%) AWS Lambda
4 6 (4.23%) Serverless
5 2 (1.41%) Amazon CloudWatch
5 2 (1.41%) Amazon ElastiCache
5 2 (1.41%) Amazon ELB
5 2 (1.41%) AWS CloudFormation
5 2 (1.41%) AWS CodePipeline
5 2 (1.41%) AWS Elastic Beanstalk
5 2 (1.41%) Azure Data Factory
5 2 (1.41%) Datadog
5 2 (1.41%) GitHub
5 2 (1.41%) Google Cloud Platform
5 2 (1.41%) Sumo Logic
5 2 (1.41%) Virtual Private Cloud
6 1 (0.70%) AWS Data Pipeline
Communications & Networking
1 1 (0.70%) DNS
1 1 (0.70%) FTP
Database & Business Intelligence
1 61 (42.96%) Data Warehouse
2 54 (38.03%) SQL Server Integration Services
3 49 (34.51%) SQL Server
4 33 (23.24%) SQL Server Reporting Services
5 29 (20.42%) SQL Server Analysis Services
6 28 (19.72%) Power BI
7 25 (17.61%) Relational Database
8 16 (11.27%) Big Data
8 16 (11.27%) Star Schema
9 14 (9.86%) Apache Hive
10 13 (9.15%) SQL Server 2012
11 11 (7.75%) Hadoop
11 11 (7.75%) Oracle Database
12 10 (7.04%) Amazon Redshift
12 10 (7.04%) QlikView
12 10 (7.04%) RDBMS
12 10 (7.04%) SAS Data Integration Studio
12 10 (7.04%) Sqoop
13 7 (4.93%) Qlik Sense
13 7 (4.93%) SAS EBI
Development Applications
1 6 (4.23%) Oracle Forms
1 6 (4.23%) Visual Studio
2 5 (3.52%) Jenkins
3 4 (2.82%) Git (software)
3 4 (2.82%) SQL Server Management Studio (SSMS)
4 3 (2.11%) Atlassian Bamboo
5 2 (1.41%) Bitbucket
5 2 (1.41%) GitLab
5 2 (1.41%) Team Foundation Server
5 2 (1.41%) Travis CI
6 1 (0.70%) CA Release Automation
6 1 (0.70%) Cucumber
6 1 (0.70%) ER Studio
6 1 (0.70%) FitNesse
6 1 (0.70%) Gradle
6 1 (0.70%) Hudson
6 1 (0.70%) Selenium
6 1 (0.70%) TeamCity
6 1 (0.70%) Toad
General
1 45 (31.69%) Finance
2 19 (13.38%) Banking
3 6 (4.23%) Investment Banking
4 5 (3.52%) Law
5 4 (2.82%) Financial Institution
5 4 (2.82%) Marketing
6 3 (2.11%) Legal
6 3 (2.11%) Retail
7 2 (1.41%) Advertising
7 2 (1.41%) Manufacturing
8 1 (0.70%) Retail Finance
8 1 (0.70%) Telecoms
Job Titles
1 52 (36.62%) Developer
2 35 (24.65%) Consultant
3 28 (19.72%) Analyst
4 16 (11.27%) SQL Developer
5 15 (10.56%) Database Developer
6 12 (8.45%) Business Intelligence Consultant
7 11 (7.75%) Business Intelligence Analyst
7 11 (7.75%) Business Intelligence Developer
8 10 (7.04%) AWS Consultant
8 10 (7.04%) Data Analyst
8 10 (7.04%) Data Consultant
9 9 (6.34%) ETL Developer
10 8 (5.63%) Big Data Consultant
10 8 (5.63%) Oracle Developer
10 8 (5.63%) SQL Database Developer
11 7 (4.93%) Data Engineer
11 7 (4.93%) Migration Analyst
11 7 (4.93%) SAS Consultant
12 6 (4.23%) Data Migration Analyst
12 6 (4.23%) Support Analyst
Libraries, Frameworks & Software Standards
1 5 (3.52%) .NET
1 5 (3.52%) Kafka
2 4 (2.82%) Node.js
2 4 (2.82%) Web Services
3 3 (2.11%) Elastic Stack
4 2 (1.41%) ASP.NET
5 1 (0.70%) CSS
5 1 (0.70%) EDI
5 1 (0.70%) EDIFACT
5 1 (0.70%) HTML
5 1 (0.70%) OpenGL
5 1 (0.70%) PostGIS
5 1 (0.70%) Spring
5 1 (0.70%) XML
Miscellaneous
1 21 (14.79%) Analytical Skills
2 7 (4.93%) Mainframe
3 5 (3.52%) Reference Data
4 4 (2.82%) Computer Science
4 4 (2.82%) Fintech
4 4 (2.82%) Public Cloud
5 3 (2.11%) Analytical Mindset
5 3 (2.11%) Greenfield Project
6 2 (1.41%) Enterprise Cloud
6 2 (1.41%) Linux Command Line
6 2 (1.41%) Self-Motivation
7 1 (0.70%) Algorithms
7 1 (0.70%) Augmented Reality
7 1 (0.70%) Data Structures
7 1 (0.70%) FMCG
7 1 (0.70%) Management Information System
7 1 (0.70%) Private Cloud
7 1 (0.70%) Social Media
7 1 (0.70%) TRADACOMS
Operating Systems
1 22 (15.49%) Unix
2 11 (7.75%) Windows
3 8 (5.63%) Linux
4 2 (1.41%) Windows Server
5 1 (0.70%) AIX
5 1 (0.70%) CentOS
5 1 (0.70%) Red Hat Enterprise Linux
5 1 (0.70%) Ubuntu
Processes & Methodologies
1 80 (56.34%) Business Intelligence
2 40 (28.17%) Analytics
3 39 (27.46%) Data Modelling
4 20 (14.08%) Visualisation
5 18 (12.68%) Data Analysis
6 16 (11.27%) Agile Software Development
6 16 (11.27%) Problem-Solving
7 13 (9.15%) Creative Thinking
7 13 (9.15%) Migration
8 12 (8.45%) Business Analysis
8 12 (8.45%) Data Engineering
9 10 (7.04%) Data Analytics
9 10 (7.04%) Data Visualisation
9 10 (7.04%) ETL Development
9 10 (7.04%) Statistics
10 9 (6.34%) Analytical Thinking
10 9 (6.34%) Data Migration
10 9 (6.34%) Data Science
11 8 (5.63%) Data Extraction
11 8 (5.63%) Data Virtualisation
Programming Languages
1 117 (82.39%) SQL
2 39 (27.46%) T-SQL
3 21 (14.79%) Python
4 14 (9.86%) R
5 12 (8.45%) Scala
6 11 (7.75%) Bash Shell
6 11 (7.75%) Java
7 7 (4.93%) JavaScript
7 7 (4.93%) Ruby
8 6 (4.23%) C#
8 6 (4.23%) PL/SQL
9 3 (2.11%) Shell Script
10 2 (1.41%) Go
10 2 (1.41%) PHP
11 1 (0.70%) C++
11 1 (0.70%) Data Analysis Expressions (DAX)
11 1 (0.70%) Perl
11 1 (0.70%) VBA
Qualifications
1 8 (5.63%) Degree
2 2 (1.41%) Computer Science Degree
2 2 (1.41%) Numerate Degree
3 1 (0.70%) AWS Certification
3 1 (0.70%) Security Cleared
Quality Assurance & Compliance
1 19 (13.38%) Data Quality
2 1 (0.70%) QA
2 1 (0.70%) SLA
System Software
1 10 (7.04%) HDFS
2 5 (3.52%) Docker
3 1 (0.70%) Tivoli Workload Scheduler
3 1 (0.70%) VMware Infrastructure
Systems Management
1 14 (9.86%) Oozie
2 8 (5.63%) Systems Management Server (SMS)
3 4 (2.82%) Ansible
3 4 (2.82%) Puppet
3 4 (2.82%) Terraform
4 3 (2.11%) Kubernetes
4 3 (2.11%) Opscode Chef
5 2 (1.41%) Grafana
5 2 (1.41%) Prometheus
5 2 (1.41%) Sysdig
6 1 (0.70%) Docker Swarm
6 1 (0.70%) Mesos
6 1 (0.70%) Rundeck
6 1 (0.70%) Tivoli
Vendors
1 39 (27.46%) Oracle
2 38 (26.76%) Microsoft
3 15 (10.56%) Cognos
3 15 (10.56%) Tableau
4 14 (9.86%) Informatica
5 6 (4.23%) IBM
6 5 (3.52%) Vertica
7 3 (2.11%) Ab Initio
7 3 (2.11%) SAP
7 3 (2.11%) Teradata
8 2 (1.41%) Alteryx
8 2 (1.41%) Google
8 2 (1.41%) IDERA
8 2 (1.41%) MicroStrategy
8 2 (1.41%) OutlookSoft
8 2 (1.41%) RedGate
8 2 (1.41%) Salesforce.com
8 2 (1.41%) Splunk
8 2 (1.41%) Talend
9 1 (0.70%) Cloudera