The table below looks at the statistics for ETL skills in IT jobs advertised for the Canary Wharf region. Included is a guide to the average salaries offered in IT jobs that have cited ETL over the 3 months to 31 July 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
31 Jul 2015
Same period 2014 Same period 2013
Extract, Transform and Load (ETL)
Rank 16 25 31
Rank change year-on-year
+9 +6
Permanent jobs citing ETL 11 7 3
As % of all permanent IT jobs located in Canary Wharf 8.09% 3.85% 1.85%
As % of the Processes & Methodologies category 9.09% 4.27% 2.04%
Number of salaries quoted 11 6 3
Average salary £65,000 £57,500 £47,500
Average salary % change year-on-year
+13.04% +21.05%
UK excluding London average salary £47,500 £45,000 £45,000
% change year-on-year
+5.55% -
ETL
London

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

Processes & Methodologies Category
Canary Wharf
Permanent IT job ads with a match in the
Processes & Methodologies category
121 164 147
As % of all permanent IT jobs located in Canary Wharf 88.97% 90.11% 90.74%
Number of salaries quoted 100 145 119
Average salary £75,000 £69,000 £77,500
Average salary % change year-on-year
+8.69% -10.96%
90% offered a salary of more than £47,500 £47,500 £50,000
10% offered a salary of more than £80,000 £100,000 £110,000
UK excluding London average salary £45,000 £42,500 £40,995
% change year-on-year
+5.88% +3.67%

ETL
Jobs Demand Trend in Canary Wharf

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

ETL Jobs Demand Trend in Canary Wharf

ETL
Salary Trend in Canary Wharf

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL across the Canary Wharf region.

ETL Salary Trend in Canary Wharf

ETL
Salary Histogram in Canary Wharf

This chart provides a salary histogram for IT jobs citing ETL across the Canary Wharf region over the 3 months to 31 July 2015.

ETL Salary Histogram in Canary Wharf

ETL
Top 30 Related IT Skills in Canary Wharf

For the 6 months to 31 July 2015, IT jobs across the Canary Wharf 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 IT job ads sampled that cited ETL.

1 18 (94.74%) SQL
2 13 (68.42%) Data Modelling
3 11 (57.89%) Finance
3 11 (57.89%) Data Warehouse
3 11 (57.89%) Degree
3 11 (57.89%) Analytical Skills
4 10 (52.63%) Oracle
4 10 (52.63%) Migration
5 9 (47.37%) Agile Software Development
6 8 (42.11%) Hadoop
6 8 (42.11%) Big Data
7 7 (36.84%) Banking
7 7 (36.84%) Data Management
7 7 (36.84%) Scrum
8 6 (31.58%) Perforce
8 6 (31.58%) Unified Process
8 6 (31.58%) Change Management
8 6 (31.58%) SQL Server
8 6 (31.58%) T-SQL
8 6 (31.58%) C#
8 6 (31.58%) Visual Studio
8 6 (31.58%) PL/SQL
8 6 (31.58%) Informatica
8 6 (31.58%) Subversion
8 6 (31.58%) TDD
8 6 (31.58%) Pair Programming
8 6 (31.58%) Credit Risk
8 6 (31.58%) SpecFlow
8 6 (31.58%) BDD
8 6 (31.58%) Red Gate

ETL
Top Related IT Skills in Canary Wharf by Category

For the 6 months to 31 July 2015, IT jobs across the Canary Wharf 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 IT job ads sampled that cited ETL. Up to 20 skills are shown per category.

Application Platforms
1 2 (10.53%) Oracle Workflow
2 1 (5.26%) Apache Pig
2 1 (5.26%) Apache Spark
Business Applications
1 2 (10.53%) Cognos TM1
Database & Business Intelligence
1 11 (57.89%) Data Warehouse
2 8 (42.11%) Hadoop
2 8 (42.11%) Big Data
3 6 (31.58%) SQL Server
4 5 (26.32%) RDBMS
4 5 (26.32%) Oracle ODI
4 5 (26.32%) Relational Database
5 4 (21.05%) Enterprise Data Warehouse
5 4 (21.05%) Data Mart
5 4 (21.05%) DB2
6 3 (15.79%) Oracle Reports
6 3 (15.79%) Cognos Report Studio
6 3 (15.79%) Cognos Framework Manager
7 2 (10.53%) Oracle Database
7 2 (10.53%) OLAP
7 2 (10.53%) BusinessObjects Web Intelligence
7 2 (10.53%) SQL Server Analysis Services
7 2 (10.53%) Oracle Database 10g
7 2 (10.53%) BusinessObjects
7 2 (10.53%) PowerCenter
Development Applications
1 6 (31.58%) Visual Studio
1 6 (31.58%) Subversion
1 6 (31.58%) SpecFlow
2 4 (21.05%) ERwin
2 4 (21.05%) Talend Open Studio
3 2 (10.53%) Maven
3 2 (10.53%) Toad
General
1 11 (57.89%) Finance
2 7 (36.84%) Banking
3 2 (10.53%) Retail
3 2 (10.53%) Investment Banking
3 2 (10.53%) Retail Banking
Job Titles
1 13 (68.42%) Developer
2 6 (31.58%) SQL Developer
3 5 (26.32%) Architect
4 4 (21.05%) Data Architect
5 3 (15.79%) Developer Analyst
5 3 (15.79%) C# Analyst Programmer
5 3 (15.79%) Analyst
5 3 (15.79%) Analyst Programmer
5 3 (15.79%) Programmer
5 3 (15.79%) C# Developer
5 3 (15.79%) C# Programmer
5 3 (15.79%) SQL Programmer
6 2 (10.53%) TM1 Developer
6 2 (10.53%) TM1 Consultant
6 2 (10.53%) AWS Developer
6 2 (10.53%) Business Objects Developer
6 2 (10.53%) Business Developer
6 2 (10.53%) Consultant
7 1 (5.26%) Business Intelligence Architect
7 1 (5.26%) Applications Manager
Libraries, Frameworks & Software Standards
1 4 (21.05%) Web Services
1 4 (21.05%) XML
1 4 (21.05%) JMS
1 4 (21.05%) WS-I
1 4 (21.05%) XBRL
1 4 (21.05%) Middleware
1 4 (21.05%) MDX
2 2 (10.53%) Spring
2 2 (10.53%) Java EE
Miscellaneous
1 11 (57.89%) Analytical Skills
2 6 (31.58%) Credit Risk
3 5 (26.32%) Computer Science
4 4 (21.05%) Data Centre
4 4 (21.05%) Management Information System
4 4 (21.05%) Replication
4 4 (21.05%) Taxonomies
5 3 (15.79%) Data Integration
6 2 (10.53%) Visualisation
Operating Systems
1 2 (10.53%) UNIX
1 2 (10.53%) Linux
Processes & Methodologies
1 13 (68.42%) Data Modelling
2 10 (52.63%) Migration
3 9 (47.37%) Agile Software Development
4 7 (36.84%) Scrum
4 7 (36.84%) Data Management
5 6 (31.58%) BDD
5 6 (31.58%) Unified Process
5 6 (31.58%) TDD
5 6 (31.58%) Pair Programming
5 6 (31.58%) Change Management
6 5 (26.32%) Business Intelligence
6 5 (26.32%) Project Management
7 4 (21.05%) SOA
7 4 (21.05%) UML
7 4 (21.05%) RUP
7 4 (21.05%) Validation
7 4 (21.05%) Information Security
7 4 (21.05%) PDM
7 4 (21.05%) Data Migration
7 4 (21.05%) Data Validation
Programming Languages
1 18 (94.74%) SQL
2 6 (31.58%) T-SQL
2 6 (31.58%) C#
2 6 (31.58%) PL/SQL
3 3 (15.79%) Java
4 1 (5.26%) Python
4 1 (5.26%) Scala
Qualifications
1 11 (57.89%) Degree
2 1 (5.26%) PMP
2 1 (5.26%) PMI Certification
Quality Assurance & Compliance
1 4 (21.05%) QA
2 2 (10.53%) Data Quality
Vendors
1 10 (52.63%) Oracle
2 6 (31.58%) Informatica
2 6 (31.58%) Perforce
2 6 (31.58%) Red Gate
3 4 (21.05%) Talend
3 4 (21.05%) Cloudera
4 3 (15.79%) Cognos
5 2 (10.53%) Actimize
5 2 (10.53%) SAP
6 1 (5.26%) MapR
6 1 (5.26%) Hortonworks
6 1 (5.26%) Vertica
6 1 (5.26%) Netezza
6 1 (5.26%) Greenplum
6 1 (5.26%) Teradata
6 1 (5.26%) IBM
6 1 (5.26%) Sybase