Period
to 23 February 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 23 February 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
23 Feb 2018
Same period 2017 Same period 2016
Rank 45 81 57
Rank change year-on-year +36 -24 +1
Contract jobs citing ETL 183 95 170
As % of all contract IT jobs advertised in Scotland 3.76% 2.53% 3.08%
As % of the Processes & Methodologies category 4.43% 3.01% 3.75%
Number of daily rates quoted 120 57 110
Scotland median daily rate £400 £400 £400
10th Percentile £310 £270 £270
90th Percentile £539 £488 £578
UK median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% +3.03%
Number of hourly rates quoted 0 0 0
Scotland median hourly rate - - -
UK median hourly rate £55.00 £40.00 £41.75
% change year-on-year +37.50% -4.19% +9.15%

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,133 3,152 4,538
As % of all contract IT jobs advertised in Scotland 84.85% 83.90% 82.14%
Number of daily rates quoted 2,429 1,861 2,393
Scotland median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - -
10th Percentile £255 £225 £250
90th Percentile £550 £513 £525
UK median daily rate £450 £425 £425
% change year-on-year +5.88% - +6.25%
Number of hourly rates quoted 85 77 63
Scotland median hourly rate £21.50 £19.50 £32.50
Median hourly rate % change year-on-year +10.26% -40.00% +43.23%
10th Percentile £11.93 £10.50 £12.35
90th Percentile £47.00 £47.60 £46.80
UK median hourly rate £24.00 £25.00 £25.00
% change year-on-year -4.00% - +24.22%

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 23 February 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 23 February 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 +29 126 £400 +1.27% 12
Glasgow -20 36 £381 -4.69% 14
Inverclyde +3 7 £325 -13.33%
North Lanarkshire - 4 £610 - 1
East Ayrshire - 2 £350 -
Dundee -9 1 - -
Dumfries and Galloway - 1 £250 -
Lanarkshire - 1 - -
Renfrewshire - 1 £313 -
ETL
UK

For the 6 months to 23 February 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 102 (55.74%) SQL
2 87 (47.54%) Data Warehouse
3 79 (43.17%) Agile Software Development
4 63 (34.43%) Finance
5 54 (29.51%) Data Modelling
6 49 (26.78%) Oracle
7 44 (24.04%) Informatica
8 43 (23.50%) Business Intelligence
9 41 (22.40%) Unix
10 39 (21.31%) Data Analysis
11 34 (18.58%) Relational Database
12 32 (17.49%) Banking
12 32 (17.49%) Test Automation
13 31 (16.94%) SQL Server Integration Services
14 30 (16.39%) Migration
14 30 (16.39%) SQL Server
15 29 (15.85%) Data Quality
16 27 (14.75%) Hadoop
17 26 (14.21%) Data Integration
18 24 (13.11%) Data Migration
19 23 (12.57%) Big Data
20 22 (12.02%) Analytical Skills
20 22 (12.02%) Waterfall
20 22 (12.02%) RDBMS
21 21 (11.48%) Analytics
22 19 (10.38%) ETL Development
22 19 (10.38%) PowerCenter
22 19 (10.38%) SQL Server Analysis Services
23 18 (9.84%) SQL Server Reporting Services
23 18 (9.84%) 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 10 (5.46%) PowerExchange
2 4 (2.19%) SAS
3 3 (1.64%) Apache Spark
4 2 (1.09%) SharePoint
5 1 (0.55%) Apache
5 1 (0.55%) Apache Airflow
5 1 (0.55%) Apache Solr
5 1 (0.55%) BizTalk Server
5 1 (0.55%) CMS
5 1 (0.55%) GeoServer
5 1 (0.55%) MTS
5 1 (0.55%) Oracle SOA Suite
5 1 (0.55%) Umbraco
5 1 (0.55%) WebSphere
Applications
1 1 (0.55%) Microsoft Office
1 1 (0.55%) Microsoft Project
Business Applications
1 12 (6.56%) Markit EDM
2 4 (2.19%) Oracle EBS
3 2 (1.09%) thinkFolio
4 1 (0.55%) Dynamics AX
Cloud Services
1 9 (4.92%) Microsoft Azure
2 4 (2.19%) Amazon AWS
3 3 (1.64%) Azure Data Factory
4 2 (1.09%) Cloud Computing
5 1 (0.55%) Amazon S3
5 1 (0.55%) Google Analytics
5 1 (0.55%) npm
5 1 (0.55%) Oracle Service Cloud
5 1 (0.55%) PaaS
Communications & Networking
1 5 (2.73%) HTTP
2 3 (1.64%) TCP/IP
3 2 (1.09%) 2G
3 2 (1.09%) 3G
3 2 (1.09%) ATM
3 2 (1.09%) DWDM
3 2 (1.09%) RNC
4 1 (0.55%) AMQP
4 1 (0.55%) IPsec
4 1 (0.55%) SSL
Database & Business Intelligence
1 87 (47.54%) Data Warehouse
2 34 (18.58%) Relational Database
3 31 (16.94%) SQL Server Integration Services
4 30 (16.39%) SQL Server
5 27 (14.75%) Hadoop
6 23 (12.57%) Big Data
7 22 (12.02%) RDBMS
8 19 (10.38%) PowerCenter
8 19 (10.38%) SQL Server Analysis Services
9 18 (9.84%) SQL Server Reporting Services
10 16 (8.74%) Oracle Database
11 13 (7.10%) Power BI
12 10 (5.46%) Data Lake
13 9 (4.92%) GIS
13 9 (4.92%) PostgreSQL
13 9 (4.92%) Spatial Data
13 9 (4.92%) SQL Server 2012
14 8 (4.37%) Enterprise Data Warehouse
14 8 (4.37%) Star Schema
15 7 (3.83%) QGIS
Development Applications
1 11 (6.01%) ERwin
2 7 (3.83%) Team Foundation Server
3 3 (1.64%) FitNesse
3 3 (1.64%) JIRA
3 3 (1.64%) JMeter
3 3 (1.64%) Oracle Forms
4 2 (1.09%) Oracle APEX
4 2 (1.09%) Subversion
5 1 (0.55%) Bower
5 1 (0.55%) DBeaver
5 1 (0.55%) Git (software)
5 1 (0.55%) Hudson
5 1 (0.55%) Jenkins
5 1 (0.55%) Selenium
5 1 (0.55%) SQL Server Management Studio (SSMS)
5 1 (0.55%) Visual Studio
5 1 (0.55%) webpack
General
1 63 (34.43%) Finance
2 32 (17.49%) Banking
3 9 (4.92%) Retail Banking
4 8 (4.37%) Legal
5 2 (1.09%) Front Office
5 2 (1.09%) Investment Banking
5 2 (1.09%) Retail
6 1 (0.55%) Electronics
6 1 (0.55%) Manufacturing
6 1 (0.55%) Marketing
6 1 (0.55%) Publishing
6 1 (0.55%) Telecoms
Job Titles
1 53 (28.96%) Analyst
2 50 (27.32%) Developer
3 33 (18.03%) Architect
4 32 (17.49%) Test Analyst
5 19 (10.38%) Informatica Developer
6 16 (8.74%) Data Architect
7 15 (8.20%) ETL Developer
8 12 (6.56%) Data Analyst
8 12 (6.56%) Technical Architect
8 12 (6.56%) Tester
9 10 (5.46%) ETL Tester
9 10 (5.46%) Senior Developer
10 8 (4.37%) Business Analyst
10 8 (4.37%) Senior Analyst
11 7 (3.83%) Data Engineer
11 7 (3.83%) Senior Test Analyst
11 7 (3.83%) SQL Developer
12 6 (3.28%) Business Intelligence Analyst
12 6 (3.28%) SSIS Developer
13 5 (2.73%) Senior Informatica Developer
Libraries, Frameworks & Software Standards
1 9 (4.92%) HTML
2 7 (3.83%) PostGIS
2 7 (3.83%) XML
3 5 (2.73%) CSS
3 5 (2.73%) HTML5
3 5 (2.73%) Web Services
4 4 (2.19%) CSS3
4 4 (2.19%) JSON
5 3 (1.64%) .NET
5 3 (1.64%) Kafka
5 3 (1.64%) RESTful
5 3 (1.64%) SOAP
6 2 (1.09%) AngularJS
6 2 (1.09%) Java EE
6 2 (1.09%) jQuery
6 2 (1.09%) Node.js
7 1 (0.55%) Backbone.js
7 1 (0.55%) Entity Framework
7 1 (0.55%) NumPy
7 1 (0.55%) REST
Miscellaneous
1 22 (12.02%) Analytical Skills
2 7 (3.83%) Mainframe
3 6 (3.28%) Data Structures
4 3 (1.64%) Fixed Income
5 2 (1.09%) Algorithms
5 2 (1.09%) Greenfield Project
5 2 (1.09%) Management Information System
5 2 (1.09%) Reference Data
5 2 (1.09%) Taxonomies
6 1 (0.55%) Blog
6 1 (0.55%) Clustering
6 1 (0.55%) Computer Science
6 1 (0.55%) iPad
6 1 (0.55%) Minimum Viable Product
6 1 (0.55%) N-Tier
6 1 (0.55%) Photography
6 1 (0.55%) PKI
6 1 (0.55%) Smart City
6 1 (0.55%) VSAM
Operating Systems
1 41 (22.40%) Unix
2 14 (7.65%) Linux
3 6 (3.28%) Windows
4 1 (0.55%) Mac OS X
4 1 (0.55%) Windows 7
4 1 (0.55%) Windows Server 2012
Processes & Methodologies
1 79 (43.17%) Agile Software Development
2 54 (29.51%) Data Modelling
3 43 (23.50%) Business Intelligence
4 39 (21.31%) Data Analysis
5 32 (17.49%) Test Automation
6 30 (16.39%) Migration
7 26 (14.21%) Data Integration
8 24 (13.11%) Data Migration
9 22 (12.02%) Waterfall
10 21 (11.48%) Analytics
11 19 (10.38%) ETL Development
12 18 (9.84%) Data Architecture
13 17 (9.29%) Open Source
13 17 (9.29%) TOGAF
14 16 (8.74%) SDLC
15 14 (7.65%) Mentoring
16 13 (7.10%) Scrum
16 13 (7.10%) User Acceptance Testing
17 12 (6.56%) Asset Management
18 11 (6.01%) Data Management
Programming Languages
1 102 (55.74%) SQL
2 18 (9.84%) T-SQL
3 14 (7.65%) PL/SQL
3 14 (7.65%) Python
4 10 (5.46%) Java
5 9 (4.92%) JavaScript
6 6 (3.28%) Bash Shell
7 5 (2.73%) C#
8 4 (2.19%) R
9 3 (1.64%) C++
10 2 (1.09%) Perl
10 2 (1.09%) Scala
10 2 (1.09%) Shell Script
11 1 (0.55%) COBOL
11 1 (0.55%) ES6
11 1 (0.55%) JCL
Qualifications
1 9 (4.92%) ISTQB
2 8 (4.37%) Security Cleared
3 5 (2.73%) Degree
4 4 (2.19%) BPSS Clearance
5 3 (1.64%) Postgraduate
6 2 (1.09%) MCAD
6 2 (1.09%) MCSD
6 2 (1.09%) MCTS
6 2 (1.09%) Microsoft Certification
6 2 (1.09%) SC Cleared
7 1 (0.55%) APMP
7 1 (0.55%) ISTQB Advanced Certification
7 1 (0.55%) PhD
Quality Assurance & Compliance
1 29 (15.85%) Data Quality
2 9 (4.92%) QA
3 7 (3.83%) Disclosure Scotland
4 3 (1.64%) SLA
5 2 (1.09%) BS7666
6 1 (0.55%) GDPR
System Software
1 7 (3.83%) Docker
2 3 (1.64%) VMware Infrastructure
3 2 (1.09%) Virtual Machines
4 1 (0.55%) Apache Flume
4 1 (0.55%) GeoWebCache
4 1 (0.55%) HDFS
Systems Management
1 7 (3.83%) Ansible
2 1 (0.55%) Control-M
2 1 (0.55%) Hadoop YARN
2 1 (0.55%) HP ALM
2 1 (0.55%) HP Quality Center
2 1 (0.55%) Oozie
2 1 (0.55%) Terraform
Vendors
1 49 (26.78%) Oracle
2 44 (24.04%) Informatica
3 18 (9.84%) Teradata
4 13 (7.10%) Microsoft
5 10 (5.46%) CA
6 7 (3.83%) Bloomberg
7 6 (3.28%) Tableau
8 5 (2.73%) SAP
9 4 (2.19%) Charles River
10 3 (1.64%) Cognos
10 3 (1.64%) Talend
10 3 (1.64%) VMware
11 2 (1.09%) Ab Initio
11 2 (1.09%) Cloudera
11 2 (1.09%) CODA
11 2 (1.09%) Huawei
11 2 (1.09%) IBM
11 2 (1.09%) NEC
11 2 (1.09%) Nokia
11 2 (1.09%) Nortel