The table below looks at the statistics for ETL skills in IT contracts advertised for the Scotland region. Included is a guide to the contractor rates offered in IT contracts that have cited ETL over the 3 months to 27 February 2017 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
27 Feb 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
UK / Scotland
Rank 61 52 51
Rank change year-on-year
-9 -1
Contract jobs citing ETL 46 82 78
As % of all contract IT jobs located in Scotland 2.63% 3.24% 2.85%
As % of the Processes & Methodologies category 3.12% 3.91% 3.52%
Number of daily rates quoted 28 47 50
Median daily rate £375 £400 £400
Median daily rate % change year-on-year
-6.25% -
90% offered a daily rate of more than £251 £292 £319
10% offered a daily rate of more than £479 £450 £453
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 £39.00 £59.50 £40.00
% change year-on-year
-34.45% +48.75%

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in contract jobs advertised in the Scotland region.

Processes & Methodologies Category
Scotland
Contract IT job ads with a match in the
Processes & Methodologies category
1474 2095 2218
As % of all contract IT jobs located in Scotland 84.13% 82.87% 81.16%
Number of daily rates quoted 880 1130 1253
Median daily rate £388 £388 £400
Median daily rate % change year-on-year
- -3.12%
90% offered a daily rate of more than £260 £265 £275
10% offered a daily rate of more than £500 £550 £500
UK excluding London median daily rate £408 £400 £399
% change year-on-year
+1.87% +0.29%
Number of hourly rates quoted 26 26 41
Median hourly rate £45.00 £40.75 £23.50
Median hourly rate % change year-on-year
+10.42% +73.40%
90% offered a hourly rate of more than £14.50 £17.70 £12.10
10% offered a hourly rate of more than £66.00 £50.00 £49.00
UK excluding London median hourly rate £36.00 £40.00 £29.00
% change year-on-year
-10.00% +37.93%

ETL
Jobs Demand Trend in Scotland

The demand trend of contract jobs across the Scotland region citing ETL as a proportion of all IT contracts with a match in the Processes & Methodologies category.

ETL Jobs Demand Trend in Scotland

ETL
Daily Rate Trend in Scotland

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

ETL Daily Rate Trend in Scotland

ETL
Daily Rate Histogram in Scotland

This chart provides a histogram of daily rates quoted in contract IT jobs citing ETL across the Scotland region over the 3 months to 27 February 2017.

ETL Daily Rate Histogram in Scotland

ETL
Hourly Rate Trend in Scotland

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

ETL Hourly Rate Trend 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 27 February 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
Glasgow +11 28 £350 -3.44% 2
Edinburgh -15 15 £388 -3.12% 6
Dundee - 1 £375 -
Aberdeenshire - 1 £450 -
Inverclyde - 1 £375 -
ETL
UK

ETL
Top 30 Related IT Skills in Scotland

For the 6 months to 27 February 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 (60.87%) SQL
2 40 (43.48%) Data Warehouse
3 28 (30.43%) Oracle
3 28 (30.43%) Business Intelligence
4 27 (29.35%) Data Modelling
5 25 (27.17%) SQL Server
6 22 (23.91%) Agile Software Development
7 17 (18.48%) Finance
7 17 (18.48%) SQL Server Integration Services
8 14 (15.22%) Data Management
8 14 (15.22%) Migration
8 14 (15.22%) Web Services
8 14 (15.22%) BusinessObjects
8 14 (15.22%) ETL Development
9 13 (14.13%) Microsoft
9 13 (14.13%) PL/SQL
10 12 (13.04%) SQL Server 2012
11 11 (11.96%) C#
11 11 (11.96%) Physical Data Model
12 10 (10.87%) Logical Data Model
12 10 (10.87%) T-SQL
12 10 (10.87%) BizTalk Server
12 10 (10.87%) Middleware
12 10 (10.87%) Kimball Methodology
12 10 (10.87%) Visualisation
12 10 (10.87%) SQL Server Reporting Services
12 10 (10.87%) QlikView
12 10 (10.87%) User Acceptance Testing
13 9 (9.78%) Data Migration
13 9 (9.78%) Data Integration

ETL
Top Related 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.87%) BizTalk Server
2 5 (5.43%) Apache Spark
3 4 (4.35%) SAS
3 4 (4.35%) SharePoint
4 2 (2.17%) Oracle Spatial
Applications
1 1 (1.09%) MS Excel
1 1 (1.09%) MS Project
1 1 (1.09%) Weka
Business Applications
1 7 (7.61%) Unit4 Business World
2 3 (3.26%) Oracle EBS
3 2 (2.17%) thinkFolio
4 1 (1.09%) Cognos Business Intelligence
4 1 (1.09%) Endur
4 1 (1.09%) Findur
4 1 (1.09%) Markit EDM
4 1 (1.09%) Minerva
Cloud Services
1 3 (3.26%) Microsoft Azure
2 2 (2.17%) Amazon AWS
Database & Business Intelligence
1 40 (43.48%) Data Warehouse
2 25 (27.17%) SQL Server
3 17 (18.48%) SQL Server Integration Services
4 14 (15.22%) BusinessObjects
5 12 (13.04%) SQL Server 2012
6 10 (10.87%) QlikView
6 10 (10.87%) SQL Server Reporting Services
7 9 (9.78%) Oracle Database
7 9 (9.78%) Relational Database
8 8 (8.70%) SQL Server Analysis Services
9 7 (7.61%) Big Data
9 7 (7.61%) BusinessObjects Web Intelligence
10 6 (6.52%) SAP Data Services
11 5 (5.43%) Enterprise Data Warehouse
11 5 (5.43%) MongoDB
11 5 (5.43%) NoSQL
11 5 (5.43%) Power BI
11 5 (5.43%) SQL Server 2014
12 4 (4.35%) Apache Cassandra
12 4 (4.35%) Pentaho
Development Applications
1 9 (9.78%) Talend Open Studio
2 2 (2.17%) ERwin
3 1 (1.09%) Cucumber
3 1 (1.09%) LoadRunner
3 1 (1.09%) Oracle Forms
3 1 (1.09%) PVCS
3 1 (1.09%) Selenium
3 1 (1.09%) SQL Server Management Studio (SSMS)
3 1 (1.09%) Subversion
3 1 (1.09%) Team Foundation Server
3 1 (1.09%) Visual Studio
General
1 17 (18.48%) Finance
2 8 (8.70%) Banking
3 3 (3.26%) Legal
4 2 (2.17%) Advertising
4 2 (2.17%) Retail
4 2 (2.17%) Retail Banking
5 1 (1.09%) Law
5 1 (1.09%) Marketing
5 1 (1.09%) Multimedia
5 1 (1.09%) Telecoms
Job Titles
1 38 (41.30%) Developer
2 23 (25.00%) Analyst
3 14 (15.22%) Data Analyst
4 11 (11.96%) Architect
5 10 (10.87%) BizTalk Developer
5 10 (10.87%) ETL Developer
6 9 (9.78%) SQL Developer
6 9 (9.78%) Test Analyst
7 8 (8.70%) Consultant
8 7 (7.61%) Data Architect
9 6 (6.52%) Business Intelligence Consultant
10 5 (5.43%) Business Intelligence Developer
10 5 (5.43%) Data Modeller
10 5 (5.43%) Functional Analyst
10 5 (5.43%) Functional Test Analyst
11 4 (4.35%) QlikView Developer
12 3 (3.26%) Designer
12 3 (3.26%) SAP BI Consultant
12 3 (3.26%) SAP Data Consultant
12 3 (3.26%) Test Data Analyst
Libraries, Frameworks & Software Standards
1 14 (15.22%) Web Services
2 10 (10.87%) Middleware
3 9 (9.78%) .NET
4 3 (3.26%) XML
5 2 (2.17%) Ajax
5 2 (2.17%) ASP.NET
5 2 (2.17%) CSS
5 2 (2.17%) HTML
5 2 (2.17%) jQuery
5 2 (2.17%) LINQ
5 2 (2.17%) MDX
5 2 (2.17%) PostGIS
5 2 (2.17%) WPF
6 1 (1.09%) Celery
6 1 (1.09%) CGI
6 1 (1.09%) D3.js
6 1 (1.09%) Flask
Miscellaneous
1 9 (9.78%) Management Information System
2 7 (7.61%) Analytical Skills
3 4 (4.35%) Data Structures
4 3 (3.26%) Enterprise Software
5 2 (2.17%) Social Media
6 1 (1.09%) Computer Science
6 1 (1.09%) e-Learning
Operating Systems
1 4 (4.35%) Unix
2 1 (1.09%) Linux
Processes & Methodologies
1 28 (30.43%) Business Intelligence
2 27 (29.35%) Data Modelling
3 22 (23.91%) Agile Software Development
4 14 (15.22%) Data Management
4 14 (15.22%) ETL Development
4 14 (15.22%) Migration
5 11 (11.96%) Physical Data Model
6 10 (10.87%) Kimball Methodology
6 10 (10.87%) Logical Data Model
6 10 (10.87%) User Acceptance Testing
6 10 (10.87%) Visualisation
7 9 (9.78%) Data Analysis
7 9 (9.78%) Data Integration
7 9 (9.78%) Data Migration
8 8 (8.70%) Analytics
8 8 (8.70%) Data Architecture
8 8 (8.70%) Data Visualisation
9 7 (7.61%) ERP
9 7 (7.61%) Unit Testing
10 6 (6.52%) Master Data Management
Programming Languages
1 56 (60.87%) SQL
2 13 (14.13%) PL/SQL
3 11 (11.96%) C#
4 10 (10.87%) T-SQL
5 5 (5.43%) Python
6 3 (3.26%) Java
7 2 (2.17%) JavaScript
7 2 (2.17%) VB.NET
7 2 (2.17%) VBA
8 1 (1.09%) R
Qualifications
1 2 (2.17%) Degree
1 2 (2.17%) Postgraduate
2 1 (1.09%) APMP
2 1 (1.09%) BPSS Clearance
2 1 (1.09%) ITIL Certification
2 1 (1.09%) Oracle Certification
2 1 (1.09%) Security Cleared
Quality Assurance & Compliance
1 6 (6.52%) Disclosure Scotland
2 4 (4.35%) Data Quality
3 2 (2.17%) QA
4 1 (1.09%) BS7666
4 1 (1.09%) SLA
Systems Management
1 2 (2.17%) HP Quality Center
Vendors
1 28 (30.43%) Oracle
2 13 (14.13%) Microsoft
3 9 (9.78%) Tableau
3 9 (9.78%) Talend
4 8 (8.70%) SAP
5 5 (5.43%) Cognos
6 4 (4.35%) MicroStrategy
7 3 (3.26%) Alteryx
7 3 (3.26%) Charles River
7 3 (3.26%) Informatica
8 2 (2.17%) Ab Initio
8 2 (2.17%) Cloudera
8 2 (2.17%) HP
8 2 (2.17%) IBM
8 2 (2.17%) Netezza
8 2 (2.17%) Teradata
9 1 (1.09%) Fidessa
9 1 (1.09%) Google
9 1 (1.09%) Pega
9 1 (1.09%) RapidMiner
Edinburgh
Orgtel
Rate: £350 - £450 per day
Posted: 3 days ago
Glasgow, Lanarkshire
Harvey Nash plc
Posted: 5 days ago