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 1 May 2016 with a comparison to the same period in the previous 2 years.

3 months to
1 May 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 27 29 34
Rank change year-on-year
+2 +5
Permanent jobs citing ETL 3 8 7
As % of all permanent IT jobs located in Canary Wharf 1.89% 4.26% 2.89%
As % of the Processes & Methodologies category 2.56% 4.44% 3.07%
Number of salaries quoted 3 5 7
Average salary £75,000 £70,000 £64,000
Average salary % change year-on-year
+7.14% +9.37%
90% offered a salary of more than £63,000 £53,500 £53,000
10% offered a salary of more than £85,000 £76,800 £70,000
UK excluding London average salary £45,000 £45,000 £45,000
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
117 180 228
As % of all permanent IT jobs located in Canary Wharf 73.58% 95.74% 94.21%
Number of salaries quoted 104 145 205
Average salary £65,000 £67,500 £78,000
Average salary % change year-on-year
-3.70% -13.46%
UK excluding London average salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

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 1 May 2016.

ETL Salary Histogram in Canary Wharf

ETL
Top 30 Related IT Skills in Canary Wharf

For the 6 months to 1 May 2016, 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 7 (100.00%) SQL
2 5 (71.43%) Data Modelling
2 5 (71.43%) Finance
3 4 (57.14%) Validation
3 4 (57.14%) Migration
3 4 (57.14%) Replication
3 4 (57.14%) PDM
3 4 (57.14%) XBRL
3 4 (57.14%) Informatica
3 4 (57.14%) ERwin
3 4 (57.14%) RDBMS
3 4 (57.14%) UML
3 4 (57.14%) Data Warehouse
3 4 (57.14%) Oracle
3 4 (57.14%) Data Management
3 4 (57.14%) QA
3 4 (57.14%) Data Migration
3 4 (57.14%) Data Validation
3 4 (57.14%) Data Architecture
3 4 (57.14%) Talend Open Studio
3 4 (57.14%) Talend
3 4 (57.14%) Master Data Management
3 4 (57.14%) Oracle ODI
3 4 (57.14%) Relational Database
3 4 (57.14%) Analytical Skills
3 4 (57.14%) Logical Data Model
3 4 (57.14%) Physical Data Model
3 4 (57.14%) Enterprise Data Warehouse
4 3 (42.86%) Data Centre
4 3 (42.86%) Capacity Management

ETL
Top Related IT Skills in Canary Wharf by Category

For the 6 months to 1 May 2016, 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 (28.57%) Elasticsearch
Database & Business Intelligence
1 4 (57.14%) Data Warehouse
1 4 (57.14%) Enterprise Data Warehouse
1 4 (57.14%) Oracle ODI
1 4 (57.14%) RDBMS
1 4 (57.14%) Relational Database
2 3 (42.86%) Data Mart
2 3 (42.86%) DB2
3 2 (28.57%) Data Mining
3 2 (28.57%) MySQL
4 1 (14.29%) Big Data
4 1 (14.29%) Hadoop
4 1 (14.29%) SQL Server Integration Services
4 1 (14.29%) SQL Server Reporting Services
Development Applications
1 4 (57.14%) ERwin
1 4 (57.14%) Talend Open Studio
General
1 5 (71.43%) Finance
2 1 (14.29%) Banking
2 1 (14.29%) Investment Banking
Job Titles
1 4 (57.14%) Architect
1 4 (57.14%) Data Architect
2 2 (28.57%) Developer
2 2 (28.57%) Ruby Developer
2 2 (28.57%) Ruby on Rails Developer
3 1 (14.29%) Analyst
3 1 (14.29%) Data Analyst
3 1 (14.29%) ETL Analyst
3 1 (14.29%) Senior Analyst
3 1 (14.29%) Senior Data Analyst
3 1 (14.29%) SQL Analyst
3 1 (14.29%) SQL Data Analyst
3 1 (14.29%) SSIS Analyst
3 1 (14.29%) SSRS Analyst
Libraries, Frameworks & Software Standards
1 4 (57.14%) XBRL
2 3 (42.86%) JMS
2 3 (42.86%) Middleware
2 3 (42.86%) Web Services
2 3 (42.86%) WS-I
2 3 (42.86%) XML
3 2 (28.57%) AngularJS
3 2 (28.57%) RabbitMQ
3 2 (28.57%) Ruby on Rails
4 1 (14.29%) Apache Flex
Miscellaneous
1 4 (57.14%) Analytical Skills
1 4 (57.14%) Replication
2 3 (42.86%) Data Centre
2 3 (42.86%) Management Information System
2 3 (42.86%) Taxonomies
3 1 (14.29%) Visualisation
Processes & Methodologies
1 5 (71.43%) Data Modelling
2 4 (57.14%) Data Architecture
2 4 (57.14%) Data Management
2 4 (57.14%) Data Migration
2 4 (57.14%) Data Validation
2 4 (57.14%) Logical Data Model
2 4 (57.14%) Master Data Management
2 4 (57.14%) Migration
2 4 (57.14%) PDM
2 4 (57.14%) Physical Data Model
2 4 (57.14%) UML
2 4 (57.14%) Validation
3 3 (42.86%) Capacity Management
3 3 (42.86%) Information Governance
3 3 (42.86%) Information Security
3 3 (42.86%) RUP
3 3 (42.86%) Technical Architecture
3 3 (42.86%) TOGAF
3 3 (42.86%) Unified Process
3 3 (42.86%) Zachman Framework
Programming Languages
1 7 (100.00%) SQL
2 2 (28.57%) JavaScript
2 2 (28.57%) Ruby
3 1 (14.29%) Java
3 1 (14.29%) R
Quality Assurance & Compliance
1 4 (57.14%) QA
System Software
1 2 (28.57%) Ceph
1 2 (28.57%) Docker
Systems Management
1 2 (28.57%) Mesos
Vendors
1 4 (57.14%) Informatica
1 4 (57.14%) Oracle
1 4 (57.14%) Talend
2 1 (14.29%) Tableau