The table below looks at the statistics for ETL skills in IT contracts advertised for the North East region. Included is a guide to the contractor rates offered in IT contracts that have cited ETL over the 3 months to 27 July 2016 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 Jul 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 101 53 51
Rank change year-on-year
-48 -2
Contract jobs citing ETL 23 25 4
As % of all contract IT jobs located in the North East 1.54% 2.68% 0.77%
As % of the Processes & Methodologies category 1.83% 3.35% 1.04%
Number of daily rates quoted 17 20 2
Median daily rate £400 £425 £373
Median daily rate % change year-on-year
-5.88% +14.09%
90% offered a daily rate of more than £325 £321 £291
10% offered a daily rate of more than £480 £527 £455
UK excluding London median daily rate £400 £390 £375
% change year-on-year
+2.56% +4.00%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £20.50 £28.75 £46.40
% change year-on-year
-28.69% -38.03%
ETL
England

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

Processes & Methodologies Category
North East
Contract IT job ads with a match in the
Processes & Methodologies category
1257 747 386
As % of all contract IT jobs located in the North East 84.14% 80.06% 73.95%
Number of daily rates quoted 818 475 244
Median daily rate £325 £405 £363
Median daily rate % change year-on-year
-19.75% +11.72%
90% offered a daily rate of more than £225 £260 £250
10% offered a daily rate of more than £510 £553 £465
UK excluding London median daily rate £400 £388 £375
% change year-on-year
+3.22% +3.33%
Number of hourly rates quoted 72 34 16
Median hourly rate £28.00 £15.00 £15.00
Median hourly rate % change year-on-year
+86.66% -
90% offered a hourly rate of more than £21.25 £11.17 £13.00
10% offered a hourly rate of more than £36.00 £30.50 £32.90
UK excluding London median hourly rate £30.00 £30.00 £26.98
% change year-on-year
- +11.21%

ETL
Jobs Demand Trend in the North East

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

ETL Jobs Demand Trend in the North East

ETL
Daily Rate Trend in the North East

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

ETL Daily Rate Trend in the North East

ETL
Daily Rate Histogram in the North East

This chart provides a histogram of daily rates quoted in contract IT jobs citing ETL across the North East region over the 3 months to 27 July 2016.

ETL Daily Rate Histogram in the North East

ETL
Hourly Rate Trend in the North East

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

ETL Hourly Rate Trend in the North East

ETL
Contract Job Locations in the North East

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the North East region over the 3 months to 27 July 2016. 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
(Click see detailed
statistics and trends)
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
Tyne and Wear -43 20 £400 -13.51%
Durham +1 1 - - 1
ETL
England

ETL
Top 30 Related IT Skills in the North East

For the 6 months to 27 July 2016, 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 North East region with a requirement for ETL.

1 28 (73.68%) SQL
1 28 (73.68%) Informatica
2 22 (57.89%) Oracle
3 17 (44.74%) Data Modelling
3 17 (44.74%) Oracle Database
4 16 (42.11%) Business Intelligence
5 13 (34.21%) SQL Server
6 11 (28.95%) PL/SQL
7 10 (26.32%) Unix
7 10 (26.32%) ERwin
8 9 (23.68%) Microsoft
8 9 (23.68%) Oracle Database 11g
9 8 (21.05%) Dimensional Modelling
9 8 (21.05%) Shell Script
9 8 (21.05%) Data Warehouse
9 8 (21.05%) T-SQL
10 5 (13.16%) Amazon Redshift
10 5 (13.16%) Amazon AWS
10 5 (13.16%) SQL Server Integration Services
10 5 (13.16%) Agile Software Development
10 5 (13.16%) Migration
10 5 (13.16%) ISEB
11 4 (10.53%) Salesforce.com
11 4 (10.53%) SQL Server Reporting Services
11 4 (10.53%) Data Quality
11 4 (10.53%) Analytics
11 4 (10.53%) ETL Development
12 3 (7.89%) REST
12 3 (7.89%) Data Integration
12 3 (7.89%) Data Analysis

ETL
Top Related IT Skills in the North East 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 3 (7.89%) SAS
2 2 (5.26%) PowerExchange
3 1 (2.63%) BizTalk Server
3 1 (2.63%) CMS
3 1 (2.63%) IIS
3 1 (2.63%) Sitecore CMS
Applications
1 1 (2.63%) MS Excel
1 1 (2.63%) MS Office
Business Applications
1 2 (5.26%) Dynamics CRM
2 1 (2.63%) Oracle Applications
Cloud Services
1 5 (13.16%) Amazon AWS
2 2 (5.26%) Microsoft Azure
3 1 (2.63%) SaaS
Database & Business Intelligence
1 17 (44.74%) Oracle Database
2 13 (34.21%) SQL Server
3 9 (23.68%) Oracle Database 11g
4 8 (21.05%) Data Warehouse
5 5 (13.16%) Amazon Redshift
5 5 (13.16%) SQL Server Integration Services
6 4 (10.53%) SQL Server Reporting Services
7 2 (5.26%) Big Data
7 2 (5.26%) BusinessObjects
7 2 (5.26%) Data Lake
7 2 (5.26%) DataStage
7 2 (5.26%) Hadoop
7 2 (5.26%) OLAP
7 2 (5.26%) OLTP
7 2 (5.26%) Oracle Reports
7 2 (5.26%) PowerCenter
7 2 (5.26%) SQL Server Analysis Services
8 1 (2.63%) Power BI
8 1 (2.63%) SQL Server 2012
8 1 (2.63%) SQL Server 2014
Development Applications
1 10 (26.32%) ERwin
2 2 (5.26%) Visual Studio
3 1 (2.63%) MSI
3 1 (2.63%) NMock
3 1 (2.63%) Oracle APEX
3 1 (2.63%) SQL Server Management Studio (SSMS)
3 1 (2.63%) StarTeam
3 1 (2.63%) Team Foundation Server
3 1 (2.63%) Toad
3 1 (2.63%) WiX
General
1 1 (2.63%) Finance
1 1 (2.63%) Manufacturing
1 1 (2.63%) Pharmaceutical
1 1 (2.63%) Publishing
Job Titles
1 21 (55.26%) Developer
2 15 (39.47%) Informatica Developer
3 8 (21.05%) ETL Developer
3 8 (21.05%) Tester
4 6 (15.79%) ETL Tester
4 6 (15.79%) Informatica ETL Developer
5 4 (10.53%) Analyst
5 4 (10.53%) Lead Developer
6 3 (7.89%) Oracle Developer
6 3 (7.89%) SQL Developer
7 2 (5.26%) Data Analyst
7 2 (5.26%) DataStage Specialist
7 2 (5.26%) ETL Specialist
7 2 (5.26%) Oracle ETL Developer
7 2 (5.26%) PL/SQL Developer
7 2 (5.26%) Test Specialist
8 1 (2.63%) Data Coordinator
8 1 (2.63%) ETL Analyst
8 1 (2.63%) Microsoft BI Developer
8 1 (2.63%) SSIS Developer
Libraries, Frameworks & Software Standards
1 3 (7.89%) REST
1 3 (7.89%) XML
2 2 (5.26%) JSON
2 2 (5.26%) SOAP
3 1 (2.63%) .NET
3 1 (2.63%) .NET Framework
3 1 (2.63%) ASP.NET
3 1 (2.63%) Web Services
Miscellaneous
1 3 (7.89%) Data Integration
2 2 (5.26%) Mainframe
3 1 (2.63%) Analytical Skills
3 1 (2.63%) CESG
3 1 (2.63%) CESG CLAS
3 1 (2.63%) Data Structures
3 1 (2.63%) Replication
3 1 (2.63%) Statistics
Operating Systems
1 10 (26.32%) Unix
2 1 (2.63%) Windows
2 1 (2.63%) Windows 7
2 1 (2.63%) Windows XP
Processes & Methodologies
1 17 (44.74%) Data Modelling
2 16 (42.11%) Business Intelligence
3 8 (21.05%) Dimensional Modelling
4 5 (13.16%) Agile Software Development
4 5 (13.16%) Migration
5 4 (10.53%) Analytics
5 4 (10.53%) ETL Development
6 3 (7.89%) Data Analysis
6 3 (7.89%) Scrum
6 3 (7.89%) Software Testing
6 3 (7.89%) TOGAF
7 2 (5.26%) CRM
7 2 (5.26%) Data Migration
7 2 (5.26%) ITIL
7 2 (5.26%) Kimball Methodology
7 2 (5.26%) Project Management
7 2 (5.26%) User Acceptance Testing
8 1 (2.63%) ATDD
8 1 (2.63%) Performance Tuning
8 1 (2.63%) SDLC
Programming Languages
1 28 (73.68%) SQL
2 11 (28.95%) PL/SQL
3 8 (21.05%) Shell Script
3 8 (21.05%) T-SQL
4 1 (2.63%) C#
4 1 (2.63%) Java
Qualifications
1 5 (13.16%) ISEB
2 2 (5.26%) ISTQB
2 2 (5.26%) Security Cleared
3 1 (2.63%) BPSS Clearance
3 1 (2.63%) CISSP
3 1 (2.63%) CLAS
3 1 (2.63%) SC Cleared
Quality Assurance & Compliance
1 4 (10.53%) Data Quality
2 2 (5.26%) Disclosure Scotland
3 1 (2.63%) ISO/IEC 27001
System Software
1 1 (2.63%) Active Directory
1 1 (2.63%) VMware Infrastructure
1 1 (2.63%) VMware Workstation
Vendors
1 28 (73.68%) Informatica
2 22 (57.89%) Oracle
3 9 (23.68%) Microsoft
4 4 (10.53%) Salesforce.com
5 2 (5.26%) CA
5 2 (5.26%) Sitecore
5 2 (5.26%) Teradata
6 1 (2.63%) HP
6 1 (2.63%) SAP
6 1 (2.63%) VMware