The following table provides summary statistics for permanent job vacancies advertised in Canary Wharf with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 3 months to 27 June 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
London / Canary Wharf
3 months to
27 Jun 2017
Same period 2016 Same period 2015
Rank 34 22 21
Rank change year-on-year -12 -1  
Permanent jobs citing ETL 2 6 11
As % of all permanent IT jobs advertised in Canary Wharf 1.30% 3.92% 7.33%
As % of the Processes & Methodologies category 1.34% 4.96% 7.59%
Number of salaries quoted 2 6 10
Median salary £72,500 £65,000 £70,000
Median salary % change year-on-year +11.53% -7.14%  
90% offered a salary of more than £68,500 £57,500 £56,000
10% offered a salary of more than £76,500 £72,500 £78,100
UK excluding London median salary £45,000 £45,000 £45,000

ETL is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Canary Wharf with a requirement for process and methodology skills.

Process & Methodology Skills
Canary Wharf
Permanent job vacancies with a requirement for process and methodology skills 149 121 145
As % of all permanent IT job vacancies advertised in Canary Wharf 96.75% 79.08% 96.67%
Number of salaries quoted 107 99 116
Median salary £70,000 £60,000 £70,000
Median salary % change year-on-year +16.66% -14.28%  
90% offered a salary of more than £50,000 £47,000 £45,000
10% offered a salary of more than £100,000 £80,000 £100,000
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year - +2.27%  

ETL
Job Vacancy Trend in Canary Wharf

The job posting trend of jobs advertised in Canary Wharf citing ETL as a proportion of all permanent or contract IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for ETL 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 in Canary Wharf.

Salary trend for ETL in Canary Wharf

For the 6 months to 27 June 2017, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Canary Wharf region with a requirement for ETL.

1 4 (80.00%) Data Warehouse
2 3 (60.00%) Finance
2 3 (60.00%) Banking
3 2 (40.00%) Data Modelling
3 2 (40.00%) Business Intelligence
3 2 (40.00%) Java
3 2 (40.00%) SQL
3 2 (40.00%) SQL Server
3 2 (40.00%) SQL Server Analysis Services
3 2 (40.00%) SQL Server Reporting Services
3 2 (40.00%) SQL Server Integration Services
3 2 (40.00%) Analytics
3 2 (40.00%) MDX
4 1 (20.00%) Apache Flex
4 1 (20.00%) Credit Risk
4 1 (20.00%) Market Risk
4 1 (20.00%) Stress Testing
4 1 (20.00%) MS Visio
4 1 (20.00%) C#
4 1 (20.00%) Sqoop
4 1 (20.00%) Enterprise Software
4 1 (20.00%) Performance Tuning
4 1 (20.00%) Logical Data Model
4 1 (20.00%) Physical Data Model
4 1 (20.00%) SDLC
4 1 (20.00%) ETL Development
4 1 (20.00%) Data Flow Diagram
4 1 (20.00%) Data Lineage
4 1 (20.00%) Budgeting and Forecasting
4 1 (20.00%) IT Strategy

ETL
Co-occurring IT Skills in Canary Wharf 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:

Applications
1 1 (20.00%) MS Visio
Cloud Services
1 1 (20.00%) Microsoft Azure
Database & Business Intelligence
1 4 (80.00%) Data Warehouse
2 2 (40.00%) SQL Server
2 2 (40.00%) SQL Server Analysis Services
2 2 (40.00%) SQL Server Integration Services
2 2 (40.00%) SQL Server Reporting Services
3 1 (20.00%) Apache Hive
3 1 (20.00%) Big Data
3 1 (20.00%) DB2
3 1 (20.00%) Hadoop
3 1 (20.00%) Pentaho
3 1 (20.00%) PowerPivot
3 1 (20.00%) Sqoop
Development Applications
1 1 (20.00%) ERwin
General
1 3 (60.00%) Banking
1 3 (60.00%) Finance
2 1 (20.00%) Advertising
2 1 (20.00%) Back Office
2 1 (20.00%) Legal
Job Titles
1 3 (60.00%) Architect
2 1 (20.00%) Business Intelligence Architect
2 1 (20.00%) Data Architect
2 1 (20.00%) Data Warehouse Developer
2 1 (20.00%) Developer
2 1 (20.00%) Enterprise Architect
2 1 (20.00%) Enterprise Data Architect
2 1 (20.00%) Head of Business Intelligence
2 1 (20.00%) Technical Architect
2 1 (20.00%) Teradata Developer
Libraries, Frameworks & Software Standards
1 2 (40.00%) MDX
2 1 (20.00%) .NET
2 1 (20.00%) Apache Flex
2 1 (20.00%) Web Services
Miscellaneous
1 1 (20.00%) Credit Risk
1 1 (20.00%) Enterprise Software
1 1 (20.00%) Mainframe
1 1 (20.00%) Market Risk
Processes & Methodologies
1 2 (40.00%) Analytics
1 2 (40.00%) Business Intelligence
1 2 (40.00%) Data Modelling
2 1 (20.00%) Budgeting and Forecasting
2 1 (20.00%) Data Flow Diagram
2 1 (20.00%) Data Lineage
2 1 (20.00%) Enterprise Architecture
2 1 (20.00%) ETL Development
2 1 (20.00%) Information Architecture
2 1 (20.00%) IT Strategy
2 1 (20.00%) Kimball Methodology
2 1 (20.00%) Logical Data Model
2 1 (20.00%) Performance Tuning
2 1 (20.00%) Physical Data Model
2 1 (20.00%) Process Improvement
2 1 (20.00%) Risk Management
2 1 (20.00%) SDLC
2 1 (20.00%) Stakeholder Engagement
2 1 (20.00%) Stress Testing
2 1 (20.00%) Technical Architecture
Programming Languages
1 2 (40.00%) Java
1 2 (40.00%) SQL
2 1 (20.00%) C#
2 1 (20.00%) Perl
Quality Assurance & Compliance
1 1 (20.00%) Data Quality
Vendors
1 1 (20.00%) Cloudera
1 1 (20.00%) IBM
1 1 (20.00%) Microsoft
1 1 (20.00%) Oracle
1 1 (20.00%) SAP
1 1 (20.00%) Tableau
1 1 (20.00%) Teradata