Period
to 18 June 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 18 June 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
18 Jun 2018
Same period 2017 Same period 2016
Rank 66 75 81
Rank change year-on-year +9 +6 -22
Contract jobs citing ETL 166 89 149
As % of all contract IT jobs advertised in Scotland 3.17% 2.35% 2.74%
As % of the Processes & Methodologies category 3.71% 2.79% 3.20%
Number of daily rates quoted 128 58 100
Scotland median daily rate £400 £419 £400
Median daily rate % change year-on-year -4.48% +4.69% +3.23%
10th Percentile £310 £293 £305
90th Percentile £550 £488 £501
UK median daily rate £450 £450 £425
% change year-on-year - +5.88% -
Number of hourly rates quoted 0 0 0
Scotland median hourly rate - - -
UK median hourly rate £47.50 £40.00 £25.25
% change year-on-year +18.75% +58.42% -31.29%

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,480 3,194 4,659
As % of all contract IT jobs advertised in Scotland 85.56% 84.50% 85.69%
Number of daily rates quoted 2,699 1,875 2,602
Scotland median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - -
10th Percentile £262 £250 £235
90th Percentile £550 £513 £525
UK median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% +6.25%
Number of hourly rates quoted 82 74 90
Scotland median hourly rate £18.00 £25.50 £36.00
Median hourly rate % change year-on-year -29.41% -29.17% +25.22%
10th Percentile £10.51 £11.27 £11.25
90th Percentile £60.50 £47.01 £43.15
UK median hourly rate £21.84 £25.00 £25.00
% change year-on-year -12.64% - +17.10%

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 18 June 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 18 June 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 +13 100 £400 -10.61% 8
Glasgow -10 49 £400 +14.29% 5
Dundee - 8 £413 -
Inverclyde - 3 £335 -
North Lanarkshire - 2 £693 -
Stirling -11 1 £450 -5.26%
Renfrewshire - 1 £313 -
ETL
UK

For the 6 months to 18 June 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 96 (57.83%) SQL
2 76 (45.78%) Data Warehouse
3 68 (40.96%) Agile Software Development
4 63 (37.95%) Finance
4 63 (37.95%) Oracle
5 51 (30.72%) Informatica
6 49 (29.52%) Data Modelling
7 40 (24.10%) Unix
7 40 (24.10%) Relational Database
8 39 (23.49%) Migration
9 38 (22.89%) Data Analysis
10 32 (19.28%) Data Migration
10 32 (19.28%) Business Intelligence
11 31 (18.67%) Data Integration
12 30 (18.07%) Banking
13 29 (17.47%) Data Quality
14 27 (16.27%) SQL Server Integration Services
15 26 (15.66%) SQL Server
15 26 (15.66%) ETL Development
16 25 (15.06%) Big Data
17 23 (13.86%) PowerCenter
17 23 (13.86%) Hadoop
18 20 (12.05%) TOGAF
18 20 (12.05%) PL/SQL
19 19 (11.45%) RDBMS
19 19 (11.45%) Data Architecture
19 19 (11.45%) Analytical Skills
20 18 (10.84%) Test Automation
20 18 (10.84%) Microsoft
21 17 (10.24%) Teradata

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 13 (7.83%) PowerExchange
2 4 (2.41%) Apache Pig
2 4 (2.41%) Apache Spark
2 4 (2.41%) Tomcat
3 2 (1.20%) SAS
3 2 (1.20%) SharePoint
3 2 (1.20%) WebSphere
4 1 (0.60%) Apache
4 1 (0.60%) Apache Airflow
4 1 (0.60%) Apache Solr
4 1 (0.60%) Confluence
4 1 (0.60%) GeoServer
Applications
1 1 (0.60%) Microsoft Excel
Business Applications
1 4 (2.41%) Markit EDM
2 3 (1.81%) thinkFolio
3 1 (0.60%) Dynamics CRM
3 1 (0.60%) Oracle EBS
3 1 (0.60%) SAP SD
Cloud Services
1 10 (6.02%) Microsoft Azure
2 3 (1.81%) Azure Data Factory
3 2 (1.20%) Amazon AWS
3 2 (1.20%) Cloud Computing
4 1 (0.60%) Amazon S3
4 1 (0.60%) npm
4 1 (0.60%) Oracle Service Cloud
Communications & Networking
1 4 (2.41%) FTP
2 2 (1.20%) HTTP
Database & Business Intelligence
1 76 (45.78%) Data Warehouse
2 40 (24.10%) Relational Database
3 27 (16.27%) SQL Server Integration Services
4 26 (15.66%) SQL Server
5 25 (15.06%) Big Data
6 23 (13.86%) Hadoop
6 23 (13.86%) PowerCenter
7 19 (11.45%) RDBMS
8 17 (10.24%) Oracle Database
9 12 (7.23%) SQL Server Analysis Services
10 11 (6.63%) SQL Server Reporting Services
11 10 (6.02%) Data Lake
12 8 (4.82%) NoSQL
13 7 (4.22%) Apache Hive
13 7 (4.22%) HBase
13 7 (4.22%) Pentaho
14 6 (3.61%) Enterprise Data Warehouse
14 6 (3.61%) Star Schema
15 5 (3.01%) Snowflake Schema
16 4 (2.41%) QlikView
Development Applications
1 13 (7.83%) Git (software)
2 11 (6.63%) ERwin
3 7 (4.22%) Jenkins
3 7 (4.22%) JIRA
4 4 (2.41%) Maven
5 3 (1.81%) Subversion
5 3 (1.81%) Team Foundation Server
6 2 (1.20%) FitNesse
6 2 (1.20%) Oracle Forms
6 2 (1.20%) Visual Studio
7 1 (0.60%) Bower
7 1 (0.60%) ClearCase
7 1 (0.60%) DBeaver
7 1 (0.60%) Hudson
7 1 (0.60%) Oracle APEX
7 1 (0.60%) Selenium
7 1 (0.60%) webpack
General
1 63 (37.95%) Finance
2 30 (18.07%) Banking
3 6 (3.61%) Retail Banking
4 3 (1.81%) Legal
5 2 (1.20%) Marketing
5 2 (1.20%) Retail
6 1 (0.60%) Electronics
6 1 (0.60%) Front Office
6 1 (0.60%) Investment Banking
6 1 (0.60%) Manufacturing
6 1 (0.60%) Publishing
6 1 (0.60%) Telecoms
Job Titles
1 76 (45.78%) Developer
2 29 (17.47%) Architect
3 25 (15.06%) Analyst
4 22 (13.25%) ETL Developer
5 21 (12.65%) Informatica Developer
6 14 (8.43%) Data Architect
6 14 (8.43%) Test Analyst
7 11 (6.63%) .NET Developer
7 11 (6.63%) ETL Tester
7 11 (6.63%) Tester
8 9 (5.42%) Solutions Architect
8 9 (5.42%) SQL Developer
9 7 (4.22%) Data Modeller
9 7 (4.22%) Senior Developer
10 6 (3.61%) Business Analyst
10 6 (3.61%) Business Intelligence Analyst
10 6 (3.61%) Consultant
10 6 (3.61%) Lead Developer
10 6 (3.61%) Lead Solutions Architect
10 6 (3.61%) Technical Architect
Libraries, Frameworks & Software Standards
1 16 (9.64%) HTML
2 13 (7.83%) .NET
3 10 (6.02%) .NET Framework
4 8 (4.82%) XML
5 7 (4.22%) PostGIS
6 6 (3.61%) CSS
6 6 (3.61%) Spring
7 5 (3.01%) HTML5
7 5 (3.01%) JMS
7 5 (3.01%) REST
7 5 (3.01%) Web Services
8 4 (2.41%) ActiveMQ
8 4 (2.41%) J2EE
8 4 (2.41%) JDBC
8 4 (2.41%) JNDI
8 4 (2.41%) Spring Batch
9 3 (1.81%) CSS3
9 3 (1.81%) JSON
10 2 (1.20%) Kafka
10 2 (1.20%) RESTful
Miscellaneous
1 19 (11.45%) Analytical Skills
2 6 (3.61%) Mainframe
3 2 (1.20%) Data Structures
3 2 (1.20%) Fixed Income
3 2 (1.20%) Greenfield Project
4 1 (0.60%) Algorithms
4 1 (0.60%) Clustering
4 1 (0.60%) Computer Science
4 1 (0.60%) Enterprise Software
4 1 (0.60%) Fintech
4 1 (0.60%) FMCG
4 1 (0.60%) Management Information System
4 1 (0.60%) Minimum Viable Product
4 1 (0.60%) Photography
4 1 (0.60%) Reference Data
4 1 (0.60%) Taxonomies
Operating Systems
1 40 (24.10%) Unix
2 14 (8.43%) Linux
3 4 (2.41%) Windows
Processes & Methodologies
1 68 (40.96%) Agile Software Development
2 49 (29.52%) Data Modelling
3 39 (23.49%) Migration
4 38 (22.89%) Data Analysis
5 32 (19.28%) Business Intelligence
5 32 (19.28%) Data Migration
6 31 (18.67%) Data Integration
7 26 (15.66%) ETL Development
8 20 (12.05%) TOGAF
9 19 (11.45%) Data Architecture
10 18 (10.84%) Test Automation
11 17 (10.24%) SDLC
12 16 (9.64%) Waterfall
13 12 (7.23%) Open Source
13 12 (7.23%) Performance Tuning
14 11 (6.63%) Analytics
14 11 (6.63%) Information Security
15 10 (6.02%) Defect Management
15 10 (6.02%) Stakeholder Management
16 9 (5.42%) Mentoring
Programming Languages
1 96 (57.83%) SQL
2 20 (12.05%) PL/SQL
3 14 (8.43%) JavaScript
3 14 (8.43%) Python
4 11 (6.63%) Java
5 8 (4.82%) T-SQL
6 7 (4.22%) Shell Script
7 4 (2.41%) C#
7 4 (2.41%) VB
8 3 (1.81%) Perl
8 3 (1.81%) R
8 3 (1.81%) VB.NET
8 3 (1.81%) VB6
9 2 (1.20%) PowerShell
9 2 (1.20%) Scala
9 2 (1.20%) VBA
10 1 (0.60%) Bash Shell
10 1 (0.60%) C
10 1 (0.60%) ES6
Qualifications
1 9 (5.42%) ISTQB
2 6 (3.61%) Security Cleared
3 4 (2.41%) Degree
4 2 (1.20%) BPSS Clearance
4 2 (1.20%) MCAD
4 2 (1.20%) MCSD
4 2 (1.20%) MCTS
4 2 (1.20%) Microsoft Certification
5 1 (0.60%) PhD
5 1 (0.60%) SC Cleared
5 1 (0.60%) TOGAF Certification
Quality Assurance & Compliance
1 29 (17.47%) Data Quality
2 7 (4.22%) QA
3 4 (2.41%) Disclosure Scotland
4 1 (0.60%) SEPA
System Software
1 7 (4.22%) Docker
2 6 (3.61%) HDFS
3 1 (0.60%) Apache Flume
3 1 (0.60%) GeoWebCache
3 1 (0.60%) VMware Infrastructure
Systems Management
1 7 (4.22%) Ansible
2 5 (3.01%) Oracle Flashback
3 2 (1.20%) Control-M
4 1 (0.60%) Hadoop YARN
4 1 (0.60%) HP Quality Center
4 1 (0.60%) Oozie
4 1 (0.60%) Opscode Chef
4 1 (0.60%) Puppet
4 1 (0.60%) Terraform
Vendors
1 63 (37.95%) Oracle
2 51 (30.72%) Informatica
3 18 (10.84%) Microsoft
4 17 (10.24%) Teradata
5 11 (6.63%) CA
6 7 (4.22%) Bloomberg
7 5 (3.01%) SAP
8 3 (1.81%) Ab Initio
8 3 (1.81%) Charles River
8 3 (1.81%) CODA
8 3 (1.81%) IBM
8 3 (1.81%) MicroStrategy
9 2 (1.20%) Cloudera
9 2 (1.20%) Sitecore
10 1 (0.60%) Capita
10 1 (0.60%) FactSet
10 1 (0.60%) Hortonworks
10 1 (0.60%) MapR
10 1 (0.60%) Tableau
10 1 (0.60%) Twitter