Period
to 18 November 2017

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 18 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Central London > City of London
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 85 93 79
Rank change year-on-year +8 -14 0
Permanent jobs citing ETL 351 376 616
As % of all permanent IT jobs advertised in the City of London 3.45% 3.21% 3.56%
As % of the Processes & Methodologies category 3.83% 3.59% 4.00%
Number of salaries quoted 325 348 534
City of London median annual salary £57,500 £60,000 £57,500
Median salary % change year-on-year -4.17% +4.35% -1.92%
10th Percentile £43,750 £37,850 £42,500
90th Percentile £78,750 £82,500 £86,250
Central London median annual salary £57,500 £60,000 £57,500
% change year-on-year -4.17% +4.35% -

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for process or methodology skills.

All Process and Methodology Skills
City of London
Permanent vacancies with a requirement for process or methodology skills 9170 10468 15412
As % of all permanent IT jobs advertised in the City of London 90.12% 89.47% 89.12%
Number of salaries quoted 8280 9535 13350
City of London median annual salary £60,000 £60,000 £57,500
Median salary % change year-on-year - +4.35% +4.55%
10th Percentile £36,250 £35,000 £33,750
90th Percentile £95,000 £90,000 £87,500
Central London median annual salary £60,000 £57,500 £57,500
% change year-on-year +4.35% - +4.55%

ETL
Job Vacancy Trend in the City of London

Job postings citing ETL as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for ETL in the City of London

ETL
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL in the City of London.

Salary trend for ETL in the City of London

ETL
Salary Histogram in the City of London

The salary distribution of IT jobs citing ETL in the City of London over the 6 months to 18 November 2017.

Salary histogram for ETL in the City of London

ETL
Job Locations in the City of London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the City of London region over the 6 months to 18 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London Bridge - 2 £52,500 -
Moorgate - 1 £42,500 -
ETL
Central London

For the 6 months to 18 November 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 City of London region with a requirement for ETL.

1 287 (81.77%) SQL
2 247 (70.37%) SQL Server
3 230 (65.53%) Business Intelligence
4 206 (58.69%) Data Warehouse
5 198 (56.41%) SQL Server Integration Services
6 186 (52.99%) Microsoft
7 157 (44.73%) SQL Server Reporting Services
8 147 (41.88%) T-SQL
9 131 (37.32%) Finance
10 124 (35.33%) SQL Server Analysis Services
11 108 (30.77%) Agile Software Development
12 89 (25.36%) Analytics
13 82 (23.36%) C#
14 80 (22.79%) .NET
15 74 (21.08%) Data Modelling
16 67 (19.09%) SQL Server 2012
17 66 (18.80%) Data Management
18 62 (17.66%) Python
19 57 (16.24%) Visualisation
19 57 (16.24%) Microsoft Azure
20 53 (15.10%) ASP.NET
21 50 (14.25%) Amazon AWS
22 49 (13.96%) NoSQL
23 48 (13.68%) Big Data
24 47 (13.39%) SQL Server 2008
25 46 (13.11%) Data Architecture
25 46 (13.11%) Degree
25 46 (13.11%) Tableau
26 44 (12.54%) Visual Studio
26 44 (12.54%) Power BI

ETL
Co-occurring IT Skills in the City of London 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 12 (3.42%) SharePoint
2 11 (3.13%) Apache Spark
3 10 (2.85%) IIS
4 9 (2.56%) WordPress
5 5 (1.42%) Apache
5 5 (1.42%) Elasticsearch
6 4 (1.14%) SAS
7 2 (0.57%) Apache Solr
7 2 (0.57%) Confluence
8 1 (0.28%) Apache Pig
8 1 (0.28%) Mule
8 1 (0.28%) WebSphere
Applications
1 30 (8.55%) Microsoft Excel
2 5 (1.42%) MS Visio
3 3 (0.85%) Microsoft Office
Business Applications
1 11 (3.13%) Cognos Business Intelligence
2 5 (1.42%) Markit EDM
3 2 (0.57%) Adobe Campaign
3 2 (0.57%) Dynamics AX
3 2 (0.57%) Eagle PACE
3 2 (0.57%) Unica
4 1 (0.28%) FastStats
4 1 (0.28%) FastStats PeopleStage
4 1 (0.28%) Oracle Applications
Cloud Services
1 57 (16.24%) Microsoft Azure
2 50 (14.25%) Amazon AWS
3 20 (5.70%) Azure Machine Learning
4 17 (4.84%) Google Cloud Platform
5 10 (2.85%) GitHub
6 7 (1.99%) Cloud Computing
6 7 (1.99%) SaaS
7 6 (1.71%) Office 365
8 5 (1.42%) Amazon S3
9 4 (1.14%) PaaS
10 3 (0.85%) Azure Data Factory
10 3 (0.85%) BlueKai
10 3 (0.85%) Cortana Intelligence Suite
10 3 (0.85%) IaaS
11 2 (0.57%) AWS Lambda
11 2 (0.57%) Serverless
12 1 (0.28%) Boomi
Communications & Networking
1 16 (4.56%) Intranet
Database & Business Intelligence
1 247 (70.37%) SQL Server
2 206 (58.69%) Data Warehouse
3 198 (56.41%) SQL Server Integration Services
4 157 (44.73%) SQL Server Reporting Services
5 124 (35.33%) SQL Server Analysis Services
6 67 (19.09%) SQL Server 2012
7 49 (13.96%) NoSQL
8 48 (13.68%) Big Data
9 47 (13.39%) SQL Server 2008
10 44 (12.54%) Power BI
11 31 (8.83%) QlikView
12 30 (8.55%) Hadoop
13 26 (7.41%) OLAP
14 25 (7.12%) Amazon Redshift
15 22 (6.27%) Relational Database
16 20 (5.70%) Amazon RDS
17 17 (4.84%) OLAP Cube
18 16 (4.56%) SQL Server 2016
19 15 (4.27%) SQL Server 2014
20 14 (3.99%) BigQuery
Development Applications
1 44 (12.54%) Visual Studio
2 33 (9.40%) Team Foundation Server
3 30 (8.55%) SQL Server Management Studio (SSMS)
4 19 (5.41%) Subversion
5 18 (5.13%) JIRA
6 17 (4.84%) TeamCity
7 15 (4.27%) Jenkins
7 15 (4.27%) RStudio
7 15 (4.27%) Talend Open Studio
8 14 (3.99%) Git (software)
9 6 (1.71%) InstallShield
10 4 (1.14%) PowerDesigner
10 4 (1.14%) VSS/SourceSafe
11 2 (0.57%) Moq
11 2 (0.57%) MSTest
12 1 (0.28%) Bitbucket
12 1 (0.28%) Mercurial
12 1 (0.28%) Oracle Forms
12 1 (0.28%) TestRail
12 1 (0.28%) Travis CI
General
1 131 (37.32%) Finance
2 20 (5.70%) Law
2 20 (5.70%) Retail
3 19 (5.41%) Legal
4 17 (4.84%) Marketing
5 14 (3.99%) Advertising
6 12 (3.42%) Banking
7 11 (3.13%) Publishing
8 9 (2.56%) Front Office
9 6 (1.71%) Back Office
10 5 (1.42%) Games
10 5 (1.42%) Investment Banking
11 2 (0.57%) Pharmaceutical
12 1 (0.28%) Electronics
12 1 (0.28%) International Banking
Job Titles
1 155 (44.16%) Developer
2 81 (23.08%) SQL Developer
3 62 (17.66%) Analyst
3 62 (17.66%) Business Intelligence Developer
4 50 (14.25%) SSIS Developer
5 35 (9.97%) ETL Developer
6 32 (9.12%) SSRS Developer
7 30 (8.55%) SQL Server Developer
8 29 (8.26%) Senior Developer
8 29 (8.26%) SSAS Developer
9 27 (7.69%) Business Intelligence Lead
10 26 (7.41%) Architect
11 25 (7.12%) SQL BI Developer
12 24 (6.84%) T-SQL Developer
13 21 (5.98%) Data Engineer
14 19 (5.41%) Database Developer
15 18 (5.13%) C# Developer
16 17 (4.84%) Data Manager
16 17 (4.84%) SQL Database Developer
16 17 (4.84%) SQL DBA
Libraries, Frameworks & Software Standards
1 80 (22.79%) .NET
2 53 (15.10%) ASP.NET
3 25 (7.12%) ASP.NET MVC
4 23 (6.55%) Web Services
5 22 (6.27%) JSON
5 22 (6.27%) XML
6 17 (4.84%) MDX
7 13 (3.70%) XSD
8 12 (3.42%) RESTful
8 12 (3.42%) WSDL
9 11 (3.13%) LINQ
9 11 (3.13%) Node.js
10 10 (2.85%) CSS
10 10 (2.85%) HTML
10 10 (2.85%) jQuery
11 9 (2.56%) Ajax
11 9 (2.56%) Razor View Engine
11 9 (2.56%) WAMP
11 9 (2.56%) WinForms
12 8 (2.28%) Lucene
Miscellaneous
1 38 (10.83%) Analytical Skills
2 24 (6.84%) Computer Science
3 22 (6.27%) Management Information System
4 20 (5.70%) Data Structures
5 9 (2.56%) Replication
5 9 (2.56%) Semantic Web
6 6 (1.71%) Reinsurance
7 5 (1.42%) Clustering
7 5 (1.42%) Fintech
7 5 (1.42%) Hedge funds
8 4 (1.14%) Algorithms
8 4 (1.14%) Linux Command Line
8 4 (1.14%) User Experience
9 3 (0.85%) PMI
10 2 (0.57%) Client/Server
10 2 (0.57%) Enterprise Software
10 2 (0.57%) EPoS
10 2 (0.57%) Virtual Team
11 1 (0.28%) Data Centre
11 1 (0.28%) Social Media
Operating Systems
1 17 (4.84%) Windows
2 10 (2.85%) Unix
3 9 (2.56%) Linux
4 3 (0.85%) Windows Server 2008
4 3 (0.85%) Windows Server 2012
Processes & Methodologies
1 230 (65.53%) Business Intelligence
2 108 (30.77%) Agile Software Development
3 89 (25.36%) Analytics
4 74 (21.08%) Data Modelling
5 66 (18.80%) Data Management
6 57 (16.24%) Visualisation
7 46 (13.11%) Data Architecture
8 41 (11.68%) Data Analysis
9 35 (9.97%) Dimensional Modelling
9 35 (9.97%) Scrum
9 35 (9.97%) SDLC
10 32 (9.12%) Master Data Management
10 32 (9.12%) MVC
11 31 (8.83%) Business Analysis
11 31 (8.83%) Data Visualisation
12 30 (8.55%) Data Integration
12 30 (8.55%) Performance Tuning
13 29 (8.26%) Kimball Methodology
14 26 (7.41%) Mentoring
14 26 (7.41%) Test Automation
Programming Languages
1 287 (81.77%) SQL
2 147 (41.88%) T-SQL
3 82 (23.36%) C#
4 62 (17.66%) Python
5 41 (11.68%) R
6 32 (9.12%) PowerShell
7 29 (8.26%) Java
8 22 (6.27%) JavaScript
9 19 (5.41%) VBA
10 17 (4.84%) PL/SQL
10 17 (4.84%) Shell Script
11 13 (3.70%) PHP
12 9 (2.56%) Scala
13 8 (2.28%) Data Analysis Expressions (DAX)
14 7 (1.99%) C
14 7 (1.99%) VB
15 4 (1.14%) MATLAB
16 1 (0.28%) Bash Shell
16 1 (0.28%) Ruby
16 1 (0.28%) SAS Macro
Qualifications
1 46 (13.11%) Degree
2 9 (2.56%) Computer Science Degree
3 8 (2.28%) Microsoft Certification
4 4 (1.14%) ITIL Foundation Certificate
5 3 (0.85%) Master's Degree
5 3 (0.85%) MCSE
5 3 (0.85%) Oracle Certification
5 3 (0.85%) PMI Certification
6 2 (0.57%) ISEB
6 2 (0.57%) PhD
6 2 (0.57%) Security Cleared
7 1 (0.28%) DV Cleared
7 1 (0.28%) ISTQB
7 1 (0.28%) OCP
7 1 (0.28%) SC Cleared
Quality Assurance & Compliance
1 41 (11.68%) Data Quality
2 25 (7.12%) QA
3 7 (1.99%) PMO
4 3 (0.85%) FATCA
4 3 (0.85%) GCP
5 2 (0.57%) SLA
5 2 (0.57%) Solvency II
6 1 (0.28%) Actionable Recommendations
6 1 (0.28%) GDPR
6 1 (0.28%) MiFID
System Software
1 14 (3.99%) HDFS
2 6 (1.71%) Active Directory
3 1 (0.28%) Docker
Systems Management
1 9 (2.56%) HP Quality Center
2 6 (1.71%) SCCM
3 3 (0.85%) Terraform
4 2 (0.57%) Control-M
5 1 (0.28%) Rundeck
Vendors
1 186 (52.99%) Microsoft
2 46 (13.11%) Tableau
3 28 (7.98%) Oracle
4 22 (6.27%) Alteryx
5 19 (5.41%) Cognos
6 17 (4.84%) MicroStrategy
7 15 (4.27%) Google
7 15 (4.27%) Talend
8 14 (3.99%) Informatica
9 13 (3.70%) SAP
10 9 (2.56%) HP
10 9 (2.56%) Sybase
11 8 (2.28%) Adobe
12 6 (1.71%) FactSet
12 6 (1.71%) Salesforce.com
12 6 (1.71%) Twitter
13 4 (1.14%) Bloomberg
13 4 (1.14%) IBM
14 3 (0.85%) EXASOL
14 3 (0.85%) Facebook