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

Extract, Transform and Load (ETL)
UK > Scotland
6 months to
14 Dec 2018
Same period 2017 Same period 2016
Rank 108 78 75
Rank change year-on-year -30 -3 +2
Permanent jobs citing ETL 133 185 155
As % of all permanent IT jobs advertised in Scotland 2.51% 3.29% 3.10%
As % of the Processes & Methodologies category 2.68% 3.57% 3.35%
Number of salaries quoted 98 92 110
Scotland median annual salary £45,000 £45,000 £50,000
Median salary % change year-on-year - -10.00% +5.26%
10th Percentile £32,500 £32,000 £35,925
90th Percentile £68,750 £57,500 £75,000
UK median annual salary £55,000 £50,000 £51,500
% change year-on-year +10.00% -2.91% +3.00%

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 4,963 5,184 4,624
As % of all permanent IT jobs advertised in Scotland 93.61% 92.19% 92.50%
Number of salaries quoted 3,189 3,357 2,867
Scotland median annual salary £45,000 £44,500 £44,500
Median salary % change year-on-year +1.12% - +4.71%
10th Percentile £28,932 £28,250 £28,250
90th Percentile £70,000 £65,000 £65,000
UK median annual salary £52,500 £50,000 £48,500
% change year-on-year +5.00% +3.09% +2.11%

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 14 December 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 14 December 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 +19 63 £45,000 +9.09% 15
Edinburgh -52 53 £45,000 - 6
Aberdeen - 5 £44,676 -
Dundee - 4 £34,000 -
Stirling +1 1 - -
Falkirk - 1 £65,000 -
Fife - 1 £28,500 -
Renfrewshire - 1 £45,000 -
ETL
UK

For the 6 months to 14 December 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 106 (79.70%) SQL
2 76 (57.14%) Business Intelligence
3 65 (48.87%) Data Warehouse
3 65 (48.87%) SQL Server
4 51 (38.35%) SQL Server Integration Services
5 44 (33.08%) Data Modelling
6 41 (30.83%) Oracle
7 39 (29.32%) SQL Server Reporting Services
8 36 (27.07%) Power BI
9 35 (26.32%) T-SQL
10 34 (25.56%) Microsoft
11 33 (24.81%) Python
12 32 (24.06%) Finance
13 31 (23.31%) Analytics
14 30 (22.56%) Analytical Skills
15 29 (21.80%) Visualisation
16 27 (20.30%) Amazon AWS
17 25 (18.80%) Microsoft Azure
18 21 (15.79%) SQL Server Analysis Services
18 21 (15.79%) Relational Database
19 19 (14.29%) Tableau
20 18 (13.53%) Banking
21 17 (12.78%) Data Analysis
22 16 (12.03%) Data Quality
22 16 (12.03%) Big Data
22 16 (12.03%) Agile Software Development
22 16 (12.03%) Data Engineering
23 15 (11.28%) Problem-Solving
23 15 (11.28%) Unix
23 15 (11.28%) Data Visualisation

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 10 (7.52%) SAS
2 7 (5.26%) Apache Pig
2 7 (5.26%) Apache Spark
3 3 (2.26%) Oracle Workflow
3 3 (2.26%) Tomcat
3 3 (2.26%) WebLogic
4 2 (1.50%) Oracle SOA Suite
5 1 (0.75%) Apache
5 1 (0.75%) Elasticsearch
5 1 (0.75%) PowerExchange
5 1 (0.75%) SharePoint
Applications
1 3 (2.26%) Microsoft Excel
2 1 (0.75%) Microsoft Office
Business Applications
1 1 (0.75%) Eloqua
1 1 (0.75%) Hyperion Planning
1 1 (0.75%) Oracle AML
Cloud Services
1 27 (20.30%) Amazon AWS
2 25 (18.80%) Microsoft Azure
3 7 (5.26%) Amazon EMR
4 5 (3.76%) Amazon EC2
4 5 (3.76%) Amazon S3
4 5 (3.76%) AWS Lambda
4 5 (3.76%) Serverless
5 2 (1.50%) Amazon CloudWatch
5 2 (1.50%) Amazon ElastiCache
5 2 (1.50%) Amazon ELB
5 2 (1.50%) AWS CloudFormation
5 2 (1.50%) AWS CodePipeline
5 2 (1.50%) AWS Elastic Beanstalk
5 2 (1.50%) Datadog
5 2 (1.50%) GitHub
5 2 (1.50%) Sumo Logic
5 2 (1.50%) Virtual Private Cloud
6 1 (0.75%) Google Cloud Platform
Communications & Networking
1 2 (1.50%) SSL
2 1 (0.75%) DNS
2 1 (0.75%) FTP
Database & Business Intelligence
1 65 (48.87%) Data Warehouse
1 65 (48.87%) SQL Server
2 51 (38.35%) SQL Server Integration Services
3 39 (29.32%) SQL Server Reporting Services
4 36 (27.07%) Power BI
5 21 (15.79%) Relational Database
5 21 (15.79%) SQL Server Analysis Services
6 16 (12.03%) Big Data
7 10 (7.52%) Oracle Database
8 8 (6.02%) Hadoop
8 8 (6.02%) SQL Server 2012
8 8 (6.02%) Star Schema
9 7 (5.26%) Apache Hive
9 7 (5.26%) Data Mining
9 7 (5.26%) IBM InfoSphere
9 7 (5.26%) PostgreSQL
9 7 (5.26%) QlikView
9 7 (5.26%) SAS Data Integration Studio
10 6 (4.51%) SSDT
11 5 (3.76%) Amazon RDS
Development Applications
1 8 (6.02%) Visual Studio
2 6 (4.51%) Jenkins
3 5 (3.76%) Git (software)
3 5 (3.76%) Oracle Forms
4 4 (3.01%) Hudson
4 4 (3.01%) SQL Server Management Studio (SSMS)
5 3 (2.26%) Atlassian Bamboo
6 2 (1.50%) Bitbucket
6 2 (1.50%) ER Studio
6 2 (1.50%) GitLab
6 2 (1.50%) TeamCity
6 2 (1.50%) Toad
6 2 (1.50%) Travis CI
7 1 (0.75%) CA Release Automation
7 1 (0.75%) ERwin
7 1 (0.75%) Sonatype Nexus
7 1 (0.75%) Team Foundation Server
General
1 32 (24.06%) Finance
2 18 (13.53%) Banking
3 8 (6.02%) Investment Banking
4 7 (5.26%) Law
5 5 (3.76%) Marketing
6 4 (3.01%) Retail
7 3 (2.26%) Retail Banking
8 1 (0.75%) Financial Institution
8 1 (0.75%) Pharmaceutical
Job Titles
1 58 (43.61%) Developer
2 29 (21.80%) Consultant
3 25 (18.80%) SQL Developer
4 21 (15.79%) Database Developer
5 16 (12.03%) Business Intelligence Consultant
6 12 (9.02%) SQL Database Developer
7 10 (7.52%) Business Consultant
8 9 (6.77%) Analyst
8 9 (6.77%) Data Engineer
9 8 (6.02%) Business Intelligence Developer
10 7 (5.26%) Data Scientist
10 7 (5.26%) Oracle Developer
10 7 (5.26%) Senior Developer
11 6 (4.51%) Data Consultant
11 6 (4.51%) ETL Developer
12 5 (3.76%) Data Analyst
12 5 (3.76%) SAS Consultant
12 5 (3.76%) SQL BI Developer
13 4 (3.01%) DBA
13 4 (3.01%) Lead Developer
Libraries, Frameworks & Software Standards
1 11 (8.27%) .NET
2 10 (7.52%) ASP.NET
3 5 (3.76%) Web Services
4 4 (3.01%) HTML
4 4 (3.01%) Kafka
4 4 (3.01%) Node.js
5 3 (2.26%) .NET Framework
5 3 (2.26%) Elastic Stack
5 3 (2.26%) J2EE
5 3 (2.26%) Spring
6 2 (1.50%) ASP.NET Web API
6 2 (1.50%) Entity Framework
6 2 (1.50%) JSON
6 2 (1.50%) LINQ
6 2 (1.50%) OAuth
6 2 (1.50%) OAuth2
6 2 (1.50%) SAML
6 2 (1.50%) SOAP
6 2 (1.50%) XML
7 1 (0.75%) PostGIS
Miscellaneous
1 30 (22.56%) Analytical Skills
2 8 (6.02%) Greenfield Project
3 6 (4.51%) Algorithms
4 5 (3.76%) Mainframe
5 3 (2.26%) Public Cloud
6 2 (1.50%) Enterprise Cloud
6 2 (1.50%) Linux Command Line
6 2 (1.50%) Self-Motivation
7 1 (0.75%) Analytical Mindset
7 1 (0.75%) Fintech
7 1 (0.75%) iPad
7 1 (0.75%) iPhone
7 1 (0.75%) Management Information System
7 1 (0.75%) Social Media
7 1 (0.75%) TRADACOMS
7 1 (0.75%) User Experience
Operating Systems
1 15 (11.28%) Unix
2 8 (6.02%) Linux
2 8 (6.02%) Windows
3 3 (2.26%) Windows Server
4 2 (1.50%) AIX
5 1 (0.75%) Apple iOS
5 1 (0.75%) CentOS
5 1 (0.75%) Red Hat Enterprise Linux
5 1 (0.75%) Ubuntu
Processes & Methodologies
1 76 (57.14%) Business Intelligence
2 44 (33.08%) Data Modelling
3 31 (23.31%) Analytics
4 29 (21.80%) Visualisation
5 17 (12.78%) Data Analysis
6 16 (12.03%) Agile Software Development
6 16 (12.03%) Data Engineering
7 15 (11.28%) Data Visualisation
7 15 (11.28%) Problem-Solving
8 13 (9.77%) ETL Development
9 12 (9.02%) Data Extraction
9 12 (9.02%) Data Science
10 11 (8.27%) Database Theory
10 11 (8.27%) Relational Database Theory
11 10 (7.52%) Data Transformation
11 10 (7.52%) Procedural Programming
11 10 (7.52%) Stakeholder Management
12 9 (6.77%) Creative Thinking
12 9 (6.77%) Software Engineering
13 8 (6.02%) Data Analytics
Programming Languages
1 106 (79.70%) SQL
2 35 (26.32%) T-SQL
3 33 (24.81%) Python
4 15 (11.28%) Bash Shell
4 15 (11.28%) Scala
5 12 (9.02%) Java
5 12 (9.02%) R
6 11 (8.27%) C#
7 8 (6.02%) JavaScript
7 8 (6.02%) PL/SQL
7 8 (6.02%) Ruby
8 5 (3.76%) Perl
9 2 (1.50%) Go
9 2 (1.50%) PHP
10 1 (0.75%) Data Analysis Expressions (DAX)
10 1 (0.75%) Shell Script
10 1 (0.75%) VB
10 1 (0.75%) VB.NET
Qualifications
1 3 (2.26%) Degree
2 1 (0.75%) AWS Certification
2 1 (0.75%) Security Cleared
Quality Assurance & Compliance
1 16 (12.03%) Data Quality
2 3 (2.26%) QA
System Software
1 5 (3.76%) Docker
2 4 (3.01%) Tivoli Workload Scheduler
3 3 (2.26%) HDFS
4 1 (0.75%) VMware Infrastructure
Systems Management
1 8 (6.02%) Systems Management Server (SMS)
2 7 (5.26%) Oozie
3 4 (3.01%) Ansible
3 4 (3.01%) Puppet
3 4 (3.01%) Terraform
3 4 (3.01%) Tivoli
4 3 (2.26%) Kubernetes
4 3 (2.26%) Opscode Chef
5 2 (1.50%) Grafana
5 2 (1.50%) Prometheus
5 2 (1.50%) Sysdig
6 1 (0.75%) Docker Swarm
6 1 (0.75%) Mesos
6 1 (0.75%) Rundeck
Vendors
1 41 (30.83%) Oracle
2 34 (25.56%) Microsoft
3 19 (14.29%) Tableau
4 11 (8.27%) Cognos
4 11 (8.27%) Informatica
5 7 (5.26%) Ab Initio
6 6 (4.51%) IBM
7 4 (3.01%) Teradata
8 3 (2.26%) IDERA
8 3 (2.26%) MicroStrategy
8 3 (2.26%) RedGate
8 3 (2.26%) Salesforce.com
9 2 (1.50%) Alteryx
9 2 (1.50%) Splunk
9 2 (1.50%) Sybase
9 2 (1.50%) Talend
10 1 (0.75%) CA
10 1 (0.75%) Google
10 1 (0.75%) Red Hat
10 1 (0.75%) VMware