Period
to 20 September 2018

The following table provides summary statistics for contract job vacancies advertised in Scotland with a requirement for ETL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ETL over the 6 months to 20 September 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Extract, Transform and Load (ETL)
UK > Scotland
6 months to
20 Sep 2018
Same period 2017 Same period 2016
Rank 84 71 90
Rank change year-on-year -13 +19 -47
Contract jobs citing ETL 132 120 129
As % of all contract IT jobs advertised in Scotland 2.42% 2.51% 2.47%
As % of the Processes & Methodologies category 2.77% 2.96% 2.88%
Number of daily rates quoted 86 69 76
Scotland median daily rate £425 £413 £400
Median daily rate % change year-on-year +3.03% +3.13% +2.56%
10th Percentile £339 £313 £306
90th Percentile £588 £503 £525
UK median daily rate £450 £450 £425
% change year-on-year - +5.88% -
Number of hourly rates quoted 1 0 0
Scotland median hourly rate £43.00 - -
UK median hourly rate £36.75 £40.00 £44.00
% change year-on-year -8.13% -9.09% +47.90%

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

All Process and Methodology Skills
Scotland
Contract vacancies with a requirement for process or methodology skills 4,770 4,053 4,484
As % of all contract IT jobs advertised in Scotland 87.41% 84.84% 85.93%
Number of daily rates quoted 2,677 2,298 2,605
Scotland median daily rate £400 £388 £363
Median daily rate % change year-on-year +3.23% +6.90% -3.33%
10th Percentile £255 £256 £236
90th Percentile £550 £530 £495
UK median daily rate £450 £450 £425
% change year-on-year - +5.88% +6.12%
Number of hourly rates quoted 105 102 107
Scotland median hourly rate £24.00 £26.25 £30.50
Median hourly rate % change year-on-year -8.57% -13.93% +45.24%
10th Percentile £10.85 £13.00 £10.00
90th Percentile £47.80 £43.75 £42.70
UK median hourly rate £20.50 £24.00 £23.00
% change year-on-year -14.58% +4.35% +4.55%

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
Contractor Daily Rate Trend in Scotland

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL in Scotland.

Contractor daily rate trend for ETL in Scotland

ETL
Contractor Daily Rate Histogram in Scotland

The daily rate distribution of IT jobs citing ETL in Scotland over the 6 months to 20 September 2018.

Contractor daily rate histogram for ETL in Scotland

ETL
Contractor Hourly Rate Trend in Scotland

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ETL in Scotland.

Contractor hourly rate trend for ETL in Scotland

ETL
Contract Job Locations in Scotland

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the Scotland region over the 6 months to 20 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh -3 67 £450 +12.50% 18
Glasgow +17 56 £414 -2.65% 14
Dundee -4 6 £413 -4.35%
Stirling -9 1 £450 -5.26%
Fife - 1 - -
ETL
UK

For the 6 months to 20 September 2018, IT contractor 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 contract job ads across the Scotland region with a requirement for ETL.

1 86 (65.15%) SQL
2 64 (48.48%) Oracle
3 58 (43.94%) Agile Software Development
4 52 (39.39%) SQL Server
5 45 (34.09%) Data Warehouse
6 37 (28.03%) Finance
7 30 (22.73%) Business Intelligence
8 28 (21.21%) Relational Database
9 26 (19.70%) Migration
10 25 (18.94%) Data Modelling
10 25 (18.94%) Big Data
11 24 (18.18%) Data Migration
12 23 (17.42%) Java
13 22 (16.67%) Microsoft
14 21 (15.91%) SQL Server Integration Services
14 21 (15.91%) Git (software)
14 21 (15.91%) DevOps
15 20 (15.15%) ETL Development
15 20 (15.15%) Informatica
15 20 (15.15%) Python
16 19 (14.39%) .NET
17 18 (13.64%) Ab Initio
17 18 (13.64%) Jenkins
18 17 (12.88%) Scrum
18 17 (12.88%) Banking
19 16 (12.12%) Hadoop
19 16 (12.12%) Pentaho
19 16 (12.12%) Microsoft Azure
19 16 (12.12%) Linux
20 15 (11.36%) T-SQL

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 5 (3.79%) Apache Pig
2 4 (3.03%) Apache Spark
2 4 (3.03%) SAS
2 4 (3.03%) Tomcat
3 2 (1.52%) WebSphere
4 1 (0.76%) Apache
4 1 (0.76%) Apache Solr
4 1 (0.76%) Elasticsearch
4 1 (0.76%) Oracle Workflow
4 1 (0.76%) SharePoint
Applications
1 5 (3.79%) Microsoft Excel
2 2 (1.52%) Microsoft Office
2 2 (1.52%) MS Visio
3 1 (0.76%) Microsoft PowerPoint
Business Applications
1 3 (2.27%) Dynamics CRM
2 2 (1.52%) thinkFolio
3 1 (0.76%) SAP SD
Cloud Services
1 16 (12.12%) Microsoft Azure
2 9 (6.82%) Azure Data Factory
2 9 (6.82%) Dynamics 365
2 9 (6.82%) PaaS
3 6 (4.55%) Amazon AWS
4 3 (2.27%) Office 365
5 2 (1.52%) Amazon EC2
5 2 (1.52%) Amazon S3
5 2 (1.52%) Virtual Private Cloud
6 1 (0.76%) Salesforce Service Cloud
6 1 (0.76%) Trello
Communications & Networking
1 4 (3.03%) FTP
2 1 (0.76%) HTTP
Database & Business Intelligence
1 52 (39.39%) SQL Server
2 45 (34.09%) Data Warehouse
3 28 (21.21%) Relational Database
4 25 (18.94%) Big Data
5 21 (15.91%) SQL Server Integration Services
6 16 (12.12%) Hadoop
6 16 (12.12%) Pentaho
7 15 (11.36%) Oracle Database
8 13 (9.85%) SQL Server Reporting Services
9 11 (8.33%) SQL Server Analysis Services
10 10 (7.58%) Microsoft Analysis Services
10 10 (7.58%) Power BI
11 9 (6.82%) Azure SQL Database
11 9 (6.82%) Data Lake
11 9 (6.82%) HDInsight
11 9 (6.82%) NoSQL
12 8 (6.06%) RDBMS
13 7 (5.30%) Apache Hive
13 7 (5.30%) MongoDB
14 6 (4.55%) MariaDB
Development Applications
1 21 (15.91%) Git (software)
2 18 (13.64%) Jenkins
3 13 (9.85%) JIRA
4 7 (5.30%) Bitbucket
4 7 (5.30%) IntelliJ
5 5 (3.79%) Maven
6 3 (2.27%) Subversion
7 1 (0.76%) ClearCase
7 1 (0.76%) Eclipse
7 1 (0.76%) Eclipse RCP
7 1 (0.76%) Gradle
7 1 (0.76%) Team Foundation Server
7 1 (0.76%) Visual Studio
General
1 37 (28.03%) Finance
2 17 (12.88%) Banking
3 7 (5.30%) Retail
4 4 (3.03%) Investment Banking
5 3 (2.27%) Manufacturing
5 3 (2.27%) Telecoms
6 2 (1.52%) Marketing
6 2 (1.52%) Retail Banking
7 1 (0.76%) Electronics
7 1 (0.76%) Front Office
7 1 (0.76%) Law
Job Titles
1 84 (63.64%) Developer
2 23 (17.42%) ETL Developer
3 14 (10.61%) SQL Developer
4 13 (9.85%) Analyst
5 11 (8.33%) Ab Initio Developer
6 10 (7.58%) .NET Developer
7 7 (5.30%) Architect
7 7 (5.30%) Consultant
8 6 (4.55%) Data Analyst
8 6 (4.55%) Python Developer
8 6 (4.55%) Test Analyst
9 5 (3.79%) Data Modeller
10 4 (3.03%) DBA
10 4 (3.03%) Java Developer
10 4 (3.03%) Lead Developer
10 4 (3.03%) Oracle Developer
10 4 (3.03%) Software Developer
10 4 (3.03%) SQL Analyst
10 4 (3.03%) Technical Analyst
11 3 (2.27%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 19 (14.39%) .NET
2 14 (10.61%) HTML
3 9 (6.82%) .NET Framework
3 9 (6.82%) PostGIS
3 9 (6.82%) XML
4 8 (6.06%) Spring
5 7 (5.30%) AngularJS
5 7 (5.30%) Drools
5 7 (5.30%) REST
6 6 (4.55%) Web Services
7 5 (3.79%) J2EE
7 5 (3.79%) JSON
8 4 (3.03%) ActiveMQ
8 4 (3.03%) HTML5
8 4 (3.03%) JDBC
8 4 (3.03%) JMS
8 4 (3.03%) JNDI
8 4 (3.03%) Middleware
8 4 (3.03%) Spring Batch
9 3 (2.27%) CSS
Miscellaneous
1 13 (9.85%) Analytical Skills
2 7 (5.30%) Cloud Native
2 7 (5.30%) Private Cloud
3 4 (3.03%) Greenfield Project
4 3 (2.27%) Data Structures
5 2 (1.52%) Enterprise Software
5 2 (1.52%) Fintech
5 2 (1.52%) Management Information System
5 2 (1.52%) Wiki
6 1 (0.76%) Clustering
6 1 (0.76%) Computer Science
6 1 (0.76%) FMCG
6 1 (0.76%) NHS
6 1 (0.76%) Self-Motivation
6 1 (0.76%) User Experience
Operating Systems
1 16 (12.12%) Linux
2 9 (6.82%) Unix
3 5 (3.79%) Windows
4 1 (0.76%) Red Hat Enterprise Linux
4 1 (0.76%) Windows Server
Processes & Methodologies
1 58 (43.94%) Agile Software Development
2 30 (22.73%) Business Intelligence
3 26 (19.70%) Migration
4 25 (18.94%) Data Modelling
5 24 (18.18%) Data Migration
6 21 (15.91%) DevOps
7 20 (15.15%) ETL Development
8 17 (12.88%) Scrum
9 14 (10.61%) Analytics
9 14 (10.61%) Data Analysis
9 14 (10.61%) Data Integration
10 13 (9.85%) Web Development
11 12 (9.09%) Visualisation
12 11 (8.33%) Asset Management
13 10 (7.58%) OO
14 9 (6.82%) Data Transformation
14 9 (6.82%) Kanban
14 9 (6.82%) Machine Learning
14 9 (6.82%) Microservices
14 9 (6.82%) Stakeholder Management
Programming Languages
1 86 (65.15%) SQL
2 23 (17.42%) Java
3 20 (15.15%) Python
4 15 (11.36%) T-SQL
5 13 (9.85%) PL/SQL
5 13 (9.85%) Shell Script
6 10 (7.58%) JavaScript
7 7 (5.30%) R
8 6 (4.55%) PowerShell
9 5 (3.79%) C#
9 5 (3.79%) Perl
10 4 (3.03%) Bash Shell
10 4 (3.03%) VB
10 4 (3.03%) VBA
11 3 (2.27%) VB.NET
11 3 (2.27%) VB6
12 2 (1.52%) Korn
12 2 (1.52%) Scala
13 1 (0.76%) Apex Code
13 1 (0.76%) C++
Qualifications
1 7 (5.30%) Degree
2 4 (3.03%) Security Cleared
3 1 (0.76%) BC Cleared
3 1 (0.76%) BPSS Clearance
3 1 (0.76%) Computer Science Degree
3 1 (0.76%) Numerate Degree
3 1 (0.76%) SC Cleared
Quality Assurance & Compliance
1 9 (6.82%) QA
2 7 (5.30%) Data Quality
3 2 (1.52%) GDPR
3 2 (1.52%) PMO
4 1 (0.76%) Disclosure Scotland
4 1 (0.76%) IFRS
4 1 (0.76%) IFRS 9
System Software
1 10 (7.58%) Docker
2 5 (3.79%) HDFS
Systems Management
1 14 (10.61%) Ansible
2 5 (3.79%) Oracle Flashback
3 4 (3.03%) Control-M
3 4 (3.03%) Opscode Chef
3 4 (3.03%) Puppet
4 1 (0.76%) Grafana
4 1 (0.76%) Prometheus
4 1 (0.76%) SCOM
Vendors
1 64 (48.48%) Oracle
2 22 (16.67%) Microsoft
3 20 (15.15%) Informatica
4 18 (13.64%) Ab Initio
5 12 (9.09%) Tableau
5 12 (9.09%) Talend
6 11 (8.33%) Teradata
7 7 (5.30%) IBM
8 5 (3.79%) Vermilion
9 3 (2.27%) MicroStrategy
9 3 (2.27%) SAP
10 2 (1.52%) Bloomberg
10 2 (1.52%) CODA
10 2 (1.52%) Sitecore
11 1 (0.76%) Alteryx
11 1 (0.76%) Curam
11 1 (0.76%) Red Hat
11 1 (0.76%) Salesforce.com
11 1 (0.76%) SaltStack
11 1 (0.76%) SolarWinds