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

Location
3 months to
5 Feb 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 21 25 40
Rank change year-on-year
+4 +15
Permanent jobs citing ETL 4 2 9
As % of all permanent IT jobs located in Canary Wharf 3.36% 2.11% 2.94%
As % of the Processes & Methodologies category 3.96% 2.17% 3.30%
Number of salaries quoted 4 2 5
Average salary £75,000 £72,750 £53,000
Average salary % change year-on-year
+3.09% +37.26%
UK excluding London average salary £45,000 £44,500 £45,000
% change year-on-year
+1.12% -1.11%
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
101 92 273
As % of all permanent IT jobs located in Canary Wharf 84.87% 96.84% 89.22%
Number of salaries quoted 100 78 214
Average salary £70,000 £72,500 £78,000
Average salary % change year-on-year
-3.44% -7.05%
90% offered a salary of more than £50,000 £50,000 £55,000
10% offered a salary of more than £85,000 £120,000 £105,000
UK excluding London average salary £45,000 £42,500 £42,500
% change year-on-year
+5.88% -

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 5 February 2016.

ETL Salary Histogram in Canary Wharf

ETL
Top 30 Related IT Skills in Canary Wharf

For the 6 months to 5 February 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 8 (100.00%) SQL
2 7 (87.50%) Finance
3 6 (75.00%) Oracle
3 6 (75.00%) Informatica
4 4 (50.00%) Data Modelling
4 4 (50.00%) SQL Server
4 4 (50.00%) Migration
4 4 (50.00%) Data Migration
4 4 (50.00%) Analytical Skills
5 3 (37.50%) Logical Data Model
5 3 (37.50%) Physical Data Model
5 3 (37.50%) Information Governance
5 3 (37.50%) Master Data Management
5 3 (37.50%) Oracle ODI
5 3 (37.50%) Relational Database
5 3 (37.50%) Enterprise Data Warehouse
5 3 (37.50%) Data Centre
5 3 (37.50%) Data Validation
5 3 (37.50%) Data Architecture
5 3 (37.50%) Problem Management
5 3 (37.50%) Release Management
5 3 (37.50%) Talend Open Studio
5 3 (37.50%) Information Architecture
5 3 (37.50%) Root Cause Analysis
5 3 (37.50%) Capacity Management
5 3 (37.50%) Talend
5 3 (37.50%) Validation
5 3 (37.50%) Data Mart
5 3 (37.50%) Technical Architecture
5 3 (37.50%) Taxonomies

ETL
Top Related IT Skills in Canary Wharf by Category

For the 6 months to 5 February 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.

Database & Business Intelligence
1 4 (50.00%) SQL Server
2 3 (37.50%) Data Mart
2 3 (37.50%) Data Warehouse
2 3 (37.50%) DB2
2 3 (37.50%) Enterprise Data Warehouse
2 3 (37.50%) Oracle ODI
2 3 (37.50%) RDBMS
2 3 (37.50%) Relational Database
3 2 (25.00%) SQL Server Integration Services
4 1 (12.50%) Big Data
4 1 (12.50%) Hadoop
4 1 (12.50%) SQL Server 2008
4 1 (12.50%) SQL Server Reporting Services
Development Applications
1 3 (37.50%) ERwin
1 3 (37.50%) Talend Open Studio
General
1 7 (87.50%) Finance
2 3 (37.50%) Front Office
3 1 (12.50%) Banking
3 1 (12.50%) Investment Banking
Job Titles
1 4 (50.00%) Analyst
2 3 (37.50%) Applications Support
2 3 (37.50%) Applications Support Analyst
2 3 (37.50%) Architect
2 3 (37.50%) Data Architect
2 3 (37.50%) Support Analyst
3 1 (12.50%) Data Analyst
3 1 (12.50%) DBA
3 1 (12.50%) ETL Analyst
3 1 (12.50%) Senior Analyst
3 1 (12.50%) Senior Data Analyst
3 1 (12.50%) SQL Analyst
3 1 (12.50%) SQL Data Analyst
3 1 (12.50%) SQL DBA
Libraries, Frameworks & Software Standards
1 3 (37.50%) FIX Protocol
1 3 (37.50%) JMS
1 3 (37.50%) Middleware
1 3 (37.50%) Web Services
1 3 (37.50%) WS-I
1 3 (37.50%) XBRL
1 3 (37.50%) XML
Miscellaneous
1 4 (50.00%) Analytical Skills
2 3 (37.50%) Data Centre
2 3 (37.50%) Equities
2 3 (37.50%) Management Information System
2 3 (37.50%) Replication
2 3 (37.50%) Taxonomies
3 1 (12.50%) Visualisation
Operating Systems
1 3 (37.50%) Linux
1 3 (37.50%) Solaris
1 3 (37.50%) Unix
1 3 (37.50%) Windows
Processes & Methodologies
1 4 (50.00%) Data Migration
1 4 (50.00%) Data Modelling
1 4 (50.00%) Migration
2 3 (37.50%) Asset Management
2 3 (37.50%) Change Management
2 3 (37.50%) Data Architecture
2 3 (37.50%) Data Management
2 3 (37.50%) Data Validation
2 3 (37.50%) Information Security
2 3 (37.50%) PDM
2 3 (37.50%) Problem Management
2 3 (37.50%) Release Management
2 3 (37.50%) RUP
2 3 (37.50%) Service Delivery
2 3 (37.50%) SOA
2 3 (37.50%) TOGAF
2 3 (37.50%) UML
2 3 (37.50%) Unified Process
2 3 (37.50%) Validation
2 3 (37.50%) Zachman Framework
Programming Languages
1 8 (100.00%) SQL
2 1 (12.50%) Java
2 1 (12.50%) R
2 1 (12.50%) T-SQL
Quality Assurance & Compliance
1 3 (37.50%) QA
Vendors
1 6 (75.00%) Informatica
1 6 (75.00%) Oracle
2 3 (37.50%) Sybase
2 3 (37.50%) Talend
3 1 (12.50%) Tableau