The first table below looks at the demand for ETL skills in IT contracts advertised for the Edinburgh region. Included is a guide to the average contractor rates offered in IT contracts that have cited ETL over the 3 months to 24 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Processes & Methodologies category for the Edinburgh region.

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.

Location
3 months to
24 May 2013
Same period 2012 Same period 2011
Extract, Transform and Load (ETL)
Rank 29 49 29
Rank change year-on-year
+20 -20
Contract jobs citing ETL 29 14 44
As % of all contract IT jobs located in Edinburgh 3.481% 1.288% 3.398%
As % of the Processes & Methodologies category 5.079% 1.926% 5.134%
Number of daily rates quoted 16 7 18
Average daily rate £425 £375 £390
Average daily rate % change year-on-year
+13.33% -3.84%
90% offered a daily rate of more than £275 £312 £297
10% offered a daily rate of more than £513 £417 £513
UK excluding London average daily rate £375 £365 £390
% change year-on-year
+2.73% -6.41%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £30.00 £60.00 £38.75
% change year-on-year
-50.00% +54.83%
All Processes & Methodologies
Edinburgh
Contract IT job ads with a match in the
Processes & Methodologies category
571 727 857
As % of all contract IT jobs located in Edinburgh 68.55% 66.88% 66.18%
Number of daily rates quoted 269 362 465
Average daily rate £413 £375 £375
Average daily rate % change year-on-year
+10.00% -
90% offered a daily rate of more than £270 £246 £225
10% offered a daily rate of more than £525 £475 £535
UK excluding London average daily rate £365 £365 £375
% change year-on-year
- -2.66%
Number of hourly rates quoted 8 16 8
Average hourly rate £20.00 £27.50 £17.50
Average hourly rate % change year-on-year
-27.27% +57.14%
90% offered a hourly rate of more than £11.00 £12.88 £14.50
10% offered a hourly rate of more than £25.45 £39.00 £43.75
UK excluding London average hourly rate £30.00 £25.00 £29.50
% change year-on-year
+20.00% -15.25%
ETL
Scotland

ETL
Jobs Demand Trend

This chart provides a 3-month moving total of IT contractor jobs citing ETL across the Edinburgh region as a proportion of the total demand within the Processes & Methodologies category.

Edinburgh ETL Jobs Demand Trend

ETL
Daily Rate Trend

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

Edinburgh ETL Daily Rate Trend

ETL
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing ETL across the Edinburgh region over the 3 months to 24 May 2013.

Edinburgh ETL Daily Rate Histogram

ETL
Hourly Rate Trend

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

Edinburgh ETL Hourly Rate Trend

ETL
Top 30 Related IT Skills

For the 6 months to 24 May 2013, IT contractor jobs across the Edinburgh region citing ETL also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited ETL.

1 30 (55.56%) Finance
2 26 (48.15%) Data Warehouse
3 20 (37.04%) SQL
3 20 (37.04%) Banking
4 16 (29.63%) Business Intelligence
4 16 (29.63%) Informatica
5 15 (27.78%) Oracle
6 12 (22.22%) Migration
7 10 (18.52%) Data Analysis
8 9 (16.67%) Teradata
8 9 (16.67%) Data Migration
9 8 (14.81%) SQL Server
9 8 (14.81%) PL/SQL
9 8 (14.81%) OLAP
9 8 (14.81%) SQL Server Integration Services
10 7 (12.96%) SQL Server Reporting Services
10 7 (12.96%) Asset Management
10 7 (12.96%) Ab Initio
10 7 (12.96%) Data Modelling
10 7 (12.96%) SAS
11 6 (11.11%) T-SQL
11 6 (11.11%) User Acceptance Testing
12 5 (9.259%) Retail
12 5 (9.259%) UNIX
13 4 (7.407%) Oracle 8/8i
13 4 (7.407%) Hyperion
13 4 (7.407%) PowerCenter
13 4 (7.407%) Star Schema
13 4 (7.407%) Retail Banking
13 4 (7.407%) SQL Server 2005

ETL
Top Related IT Skills by Category

For the 6 months to 24 May 2013, IT contractor jobs across the Edinburgh region citing ETL also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited ETL. Up to 20 skills are shown per category.

Application Development
1 3 (5.556%) JDBC
1 3 (5.556%) Web Services
2 2 (3.704%) MDX
3 1 (1.852%) ASP.NET MVC 2
3 1 (1.852%) .NET
3 1 (1.852%) XML
3 1 (1.852%) XSD
3 1 (1.852%) ASP.NET
Application Platforms
1 7 (12.96%) SAS
2 3 (5.556%) SharePoint
2 3 (5.556%) PowerExchange
3 2 (3.704%) SharePoint 2013
4 1 (1.852%) Oracle Application Server
Applications
1 2 (3.704%) MS Excel
2 1 (1.852%) PowerPivot
2 1 (1.852%) MS PowerPoint
Business Applications
1 2 (3.704%) Oracle EBS
Database & Business Intelligence
1 26 (48.15%) Data Warehouse
2 8 (14.81%) SQL Server
2 8 (14.81%) OLAP
2 8 (14.81%) SQL Server Integration Services
3 7 (12.96%) SQL Server Reporting Services
4 4 (7.407%) Oracle 8/8i
4 4 (7.407%) PowerCenter
4 4 (7.407%) Star Schema
4 4 (7.407%) SQL Server 2005
4 4 (7.407%) SQL Server Analysis Services
5 3 (5.556%) SQL Server 2012
5 3 (5.556%) Oracle BI EE
5 3 (5.556%) QlikView
5 3 (5.556%) Oracle 11g
5 3 (5.556%) Oracle 10g
5 3 (5.556%) Data Mining
5 3 (5.556%) DTS
6 2 (3.704%) DataStage
6 2 (3.704%) RDBMS
6 2 (3.704%) BODI
Development Applications
1 2 (3.704%) ERwin
2 1 (1.852%) Team Foundation Server
2 1 (1.852%) MSTest
2 1 (1.852%) NUnit
General
1 30 (55.56%) Finance
2 20 (37.04%) Banking
3 5 (9.259%) Retail
4 4 (7.407%) Retail Banking
5 2 (3.704%) Investment Banking
5 2 (3.704%) Marketing
5 2 (3.704%) Manufacturing
6 1 (1.852%) Financial Institution
6 1 (1.852%) Corporate Banking
Job Titles
1 18 (33.33%) Analyst
2 9 (16.67%) Developer
3 8 (14.81%) Data Analyst
4 6 (11.11%) Architect
4 6 (11.11%) Designer
5 5 (9.259%) Test Analyst
6 4 (7.407%) Consultant
6 4 (7.407%) Data Architect
7 3 (5.556%) Ab Initio Developer
7 3 (5.556%) Systems Analyst
8 2 (3.704%) Solutions Architect
8 2 (3.704%) Oracle Developer
8 2 (3.704%) ETL Developer
8 2 (3.704%) Support Analyst
9 1 (1.852%) C# .NET Developer
9 1 (1.852%) Data Migration Consultant
9 1 (1.852%) OBIEE Consultant
9 1 (1.852%) Migration Consultant
9 1 (1.852%) Data Warehouse Consultant
9 1 (1.852%) Technical Business Analyst
Miscellaneous
1 3 (5.556%) Data Integration
2 2 (3.704%) Mathematics
2 2 (3.704%) Management Information System
2 2 (3.704%) Data Conversion
3 1 (1.852%) iSeries
Operating Systems
1 5 (9.259%) UNIX
2 3 (5.556%) Windows
2 3 (5.556%) Linux
3 1 (1.852%) zOS
Processes & Methodologies
1 16 (29.63%) Business Intelligence
2 12 (22.22%) Migration
3 10 (18.52%) Data Analysis
4 9 (16.67%) Data Migration
5 7 (12.96%) Asset Management
5 7 (12.96%) Data Modelling
6 6 (11.11%) User Acceptance Testing
7 4 (7.407%) Stakeholder Management
7 4 (7.407%) Data Architecture
7 4 (7.407%) Metadata Management
8 3 (5.556%) Capacity Management
8 3 (5.556%) Kimball Methodology
8 3 (5.556%) Analytics
8 3 (5.556%) GAP Analysis
8 3 (5.556%) Data Management
8 3 (5.556%) Investment Management
8 3 (5.556%) Dimensional Modelling
8 3 (5.556%) Business Analysis
9 2 (3.704%) UML
9 2 (3.704%) Content Management
Programming Languages
1 20 (37.04%) SQL
2 8 (14.81%) PL/SQL
3 6 (11.11%) T-SQL
4 3 (5.556%) Shell Script
5 2 (3.704%) Perl
6 1 (1.852%) C
6 1 (1.852%) C#
6 1 (1.852%) Java
6 1 (1.852%) VBA
Qualifications
1 3 (5.556%) ISTQB
1 3 (5.556%) ISEB
2 2 (3.704%) Degree
Quality Assurance & Compliance
1 2 (3.704%) QA
2 1 (1.852%) Solvency II
2 1 (1.852%) Data Quality
System Software
1 1 (1.852%) Oracle RAC
Systems Management
1 1 (1.852%) Data Guard
1 1 (1.852%) HP Quality Center
Vendors
1 16 (29.63%) Informatica
2 15 (27.78%) Oracle
3 9 (16.67%) Teradata
4 7 (12.96%) Ab Initio
5 4 (7.407%) Hyperion
6 3 (5.556%) DataFlux
6 3 (5.556%) IBM
6 3 (5.556%) Microsoft
6 3 (5.556%) CheckPoint
6 3 (5.556%) Business Objects
7 2 (3.704%) Trillium
7 2 (3.704%) Cadis
8 1 (1.852%) HP
8 1 (1.852%) Salesforce.com
8 1 (1.852%) MicroStrategy
8 1 (1.852%) PeopleSoft
Edinburgh, Midlothian
We have an immediate requirement for an experienced Datawarehouse Test Analyst with background testing ETL / MI Reporting solutions, ideally within the Financial Services Sector. Successful candidates will have...
Search Consultancy
Posted: 20 May 2013
Edinburgh, Midlothian
PeopleSoft, Data, SQL, ETL, Functional Specifications, MI, BI, Reporting, Data Sources, HR My banking client based in Edinburgh requires a number of PeopleSoft HR Data Business Analysts to...
Aston Carter
Rate: £350 - £450 per day
Posted: 24 May 2013
Edinburgh, Midlothian
Sound understanding of UAT processes, including experience of using HP Quality Centre. - Proficient in the use of MS Word, Excel, Access and PowerPoint. - ?Knowledge of SQL. - Experience of...
Head Resourcing
Rate: £300 - £350 per day + depending on experience.
Posted: 21 May 2013
Edinburgh, Scotland
Test Lead, Scotland, Investment Banking, £400-450 per day A leading banking client in Edinburgh urgently requires a Test Lead, to work on a 6-month rolling contract...
Orgtel
Rate: £400 - £450 per day
Posted: 15 May 2013
Edinburgh, Midlothian
Our client is recruiting for a PeopleSoft OBIEE HR Consultant... Experience with OBIEE... Experience of leading the solutioning of HR Analytics. The successful candidate may also have the...
Experis IT
Rate: £415 - £443.20 per day
Posted: 21 May 2013
Edinburgh, Midlothian
A Test Analyst contract requirement has been identified by our Edinburgh based Financial Services Client. The successful candidate will be carrying out UAT Testing within a large UAT...
Head Resourcing
Rate: £250 - £320 per day
Posted: 21 May 2013