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 3 months to 28 March 2017 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
3 months to
28 Mar 2017
Same period 2016 Same period 2015
Rank 59 50 59
Rank change year-on-year -9 +9  
Contract jobs citing ETL 48 92 78
As % of all contract IT jobs advertised in Scotland 2.73% 3.55% 2.66%
As % of the Processes & Methodologies category 3.26% 4.26% 3.28%
Number of daily rates quoted 30 60 49
Median daily rate £375 £400 £400
Median daily rate % change year-on-year -6.25% -  
90% offered a daily rate of more than £270 £300 £274
10% offered a daily rate of more than £478 £455 £480
UK excluding London median daily rate £400 £400 £400
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £37.50 - £40.00

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

Contract Process & Methodology Skills
Scotland
Contract job vacancies with a requirement for process and methodology skills 1472 2161 2379
As % of all contract IT job vacancies advertised in Scotland 83.83% 83.31% 81.00%
Number of daily rates quoted 901 1215 1311
Median daily rate £390 £393 £400
Median daily rate % change year-on-year -0.63% -1.87%  
90% offered a daily rate of more than £263 £260 £265
10% offered a daily rate of more than £491 £550 £500
UK excluding London median daily rate £410 £400 £396
% change year-on-year +2.50% +1.01%  
Number of hourly rates quoted 25 32 46
Median hourly rate £33.50 £39.00 £31.70
Median hourly rate % change year-on-year -14.10% +23.02%  
90% offered a hourly rate of more than £12.55 £13.45 £12.10
10% offered a hourly rate of more than £46.00 £50.00 £50.00
UK excluding London median hourly rate £36.00 £38.50 £30.20
% change year-on-year -6.49% +27.48%  

ETL
Job Vacancy Trend in Scotland

The job posting trend of jobs advertised in Scotland citing ETL as a proportion of all contract or permanent IT jobs with a match in the Processes & Methodologies category.

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 3 months to 28 March 2017.

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 3 months to 28 March 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh -9 25 £475 +15.15% 5
Glasgow +10 23 £325 +2.36% 3
ETL
UK

For the 6 months to 28 March 2017, IT contractor jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Scotland region with a requirement for ETL.

1 56 (58.95%) SQL
2 47 (49.47%) Data Warehouse
3 28 (29.47%) Data Modelling
4 26 (27.37%) Oracle
4 26 (27.37%) SQL Server
5 25 (26.32%) Finance
6 24 (25.26%) Business Intelligence
7 20 (21.05%) Data Management
8 18 (18.95%) SQL Server Integration Services
9 17 (17.89%) Migration
10 16 (16.84%) Data Analysis
11 15 (15.79%) Banking
12 14 (14.74%) Agile Software Development
12 14 (14.74%) Microsoft
13 13 (13.68%) PL/SQL
13 13 (13.68%) SQL Server Reporting Services
14 12 (12.63%) BusinessObjects
14 12 (12.63%) Visualisation
14 12 (12.63%) SQL Server 2012
14 12 (12.63%) ETL Development
15 11 (11.58%) Master Data Management
15 11 (11.58%) Data Migration
15 11 (11.58%) Data Architecture
16 10 (10.53%) SAS
16 10 (10.53%) GAP Analysis
16 10 (10.53%) Logical Data Model
16 10 (10.53%) Physical Data Model
17 9 (9.47%) Analytical Skills
17 9 (9.47%) Management Information System
17 9 (9.47%) User Acceptance Testing

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 (10.53%) SAS
2 6 (6.32%) Apache Spark
3 3 (3.16%) Oracle Spatial
3 3 (3.16%) SharePoint
4 2 (2.11%) Apache Airflow
5 1 (1.05%) BizTalk Server
Applications
1 2 (2.11%) MS Excel
1 2 (2.11%) Spreadsheet
2 1 (1.05%) MS Project
2 1 (1.05%) Weka
Business Applications
1 3 (3.16%) Oracle EBS
2 2 (2.11%) thinkFolio
3 1 (1.05%) Cognos Business Intelligence
3 1 (1.05%) Unit4 Business World
Cloud Services
1 5 (5.26%) Amazon AWS
2 3 (3.16%) Microsoft Azure
3 2 (2.11%) Amazon S3
Database & Business Intelligence
1 47 (49.47%) Data Warehouse
2 26 (27.37%) SQL Server
3 18 (18.95%) SQL Server Integration Services
4 13 (13.68%) SQL Server Reporting Services
5 12 (12.63%) BusinessObjects
5 12 (12.63%) SQL Server 2012
6 9 (9.47%) Big Data
7 8 (8.42%) Oracle Database
7 8 (8.42%) QlikView
7 8 (8.42%) SQL Server Analysis Services
8 7 (7.37%) BusinessObjects Web Intelligence
8 7 (7.37%) Enterprise Data Warehouse
8 7 (7.37%) Hadoop
8 7 (7.37%) SQL Server 2014
9 6 (6.32%) Apache Cassandra
9 6 (6.32%) Relational Database
9 6 (6.32%) SAP Data Services
10 5 (5.26%) Pentaho
10 5 (5.26%) SQL Server 2016
11 4 (4.21%) Power BI
Development Applications
1 7 (7.37%) Talend Open Studio
2 2 (2.11%) ERwin
3 1 (1.05%) Cucumber
3 1 (1.05%) LoadRunner
3 1 (1.05%) Oracle Forms
3 1 (1.05%) Selenium
3 1 (1.05%) Subversion
3 1 (1.05%) TortoiseSVN
3 1 (1.05%) Visual Studio
General
1 25 (26.32%) Finance
2 15 (15.79%) Banking
3 8 (8.42%) Retail
4 7 (7.37%) Retail Banking
5 3 (3.16%) Legal
6 2 (2.11%) Telecoms
7 1 (1.05%) Advertising
7 1 (1.05%) Law
7 1 (1.05%) Multimedia
Job Titles
1 31 (32.63%) Analyst
2 29 (30.53%) Developer
3 22 (23.16%) Data Analyst
4 12 (12.63%) Architect
5 10 (10.53%) ETL Developer
5 10 (10.53%) Test Analyst
6 9 (9.47%) SQL Developer
7 8 (8.42%) Data Architect
8 7 (7.37%) Consultant
8 7 (7.37%) Designer
8 7 (7.37%) Solutions Designer
9 6 (6.32%) Business Intelligence Consultant
9 6 (6.32%) Data Modeller
10 5 (5.26%) Data Warehouse Developer
10 5 (5.26%) Functional Analyst
10 5 (5.26%) Functional Test Analyst
11 4 (4.21%) Business Intelligence Developer
11 4 (4.21%) Oracle Developer
11 4 (4.21%) SQL DBA
11 4 (4.21%) Test Data Analyst
Libraries, Frameworks & Software Standards
1 6 (6.32%) Web Services
2 3 (3.16%) Middleware
3 2 (2.11%) Kafka
3 2 (2.11%) PostGIS
4 1 (1.05%) .NET
4 1 (1.05%) Ajax
4 1 (1.05%) ASP.NET
4 1 (1.05%) Celery
4 1 (1.05%) CGI
4 1 (1.05%) CSS
4 1 (1.05%) D3.js
4 1 (1.05%) Flask
4 1 (1.05%) HTML
4 1 (1.05%) jQuery
4 1 (1.05%) LINQ
4 1 (1.05%) MDX
4 1 (1.05%) WPF
4 1 (1.05%) XML
Miscellaneous
1 9 (9.47%) Analytical Skills
1 9 (9.47%) Management Information System
2 5 (5.26%) Data Structures
3 3 (3.16%) Enterprise Software
3 3 (3.16%) Taxonomies
4 2 (2.11%) Social Media
5 1 (1.05%) e-Learning
Operating Systems
1 2 (2.11%) Unix
Processes & Methodologies
1 28 (29.47%) Data Modelling
2 24 (25.26%) Business Intelligence
3 20 (21.05%) Data Management
4 17 (17.89%) Migration
5 16 (16.84%) Data Analysis
6 14 (14.74%) Agile Software Development
7 12 (12.63%) ETL Development
7 12 (12.63%) Visualisation
8 11 (11.58%) Data Architecture
8 11 (11.58%) Data Migration
8 11 (11.58%) Master Data Management
9 10 (10.53%) GAP Analysis
9 10 (10.53%) Logical Data Model
9 10 (10.53%) Physical Data Model
10 9 (9.47%) Analytics
10 9 (9.47%) Data Visualisation
10 9 (9.47%) User Acceptance Testing
11 7 (7.37%) Data Integration
11 7 (7.37%) Kimball Methodology
11 7 (7.37%) Unit Testing
Programming Languages
1 56 (58.95%) SQL
2 13 (13.68%) PL/SQL
3 8 (8.42%) T-SQL
4 4 (4.21%) Python
4 4 (4.21%) R
5 3 (3.16%) C#
5 3 (3.16%) Java
5 3 (3.16%) Scala
6 2 (2.11%) VBA
7 1 (1.05%) JavaScript
7 1 (1.05%) VB.NET
Qualifications
1 2 (2.11%) Postgraduate
2 1 (1.05%) APMP
2 1 (1.05%) BPSS Clearance
2 1 (1.05%) Degree
2 1 (1.05%) ITIL Certification
2 1 (1.05%) Oracle Certification
Quality Assurance & Compliance
1 8 (8.42%) Data Quality
2 6 (6.32%) Disclosure Scotland
3 2 (2.11%) QA
4 1 (1.05%) BS7666
4 1 (1.05%) SLA
System Software
1 2 (2.11%) HDFS
Systems Management
1 2 (2.11%) Hadoop YARN
1 2 (2.11%) Oozie
2 1 (1.05%) HP Quality Center
Vendors
1 26 (27.37%) Oracle
2 14 (14.74%) Microsoft
3 9 (9.47%) Cloudera
4 8 (8.42%) SAP
5 7 (7.37%) Tableau
5 7 (7.37%) Talend
5 7 (7.37%) Teradata
6 5 (5.26%) Cognos
7 3 (3.16%) Informatica
7 3 (3.16%) Netezza
8 2 (2.11%) Ab Initio
8 2 (2.11%) Charles River
8 2 (2.11%) IBM
9 1 (1.05%) Alteryx
9 1 (1.05%) Google
9 1 (1.05%) HP
9 1 (1.05%) MicroStrategy
9 1 (1.05%) Pega
9 1 (1.05%) RapidMiner
9 1 (1.05%) Twitter
Glasgow, Lanarkshire
Square One Resources
Rate: From £400 to £450 per day
Posted: 4 days ago