Period
to 17 February 2019

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 17 February 2019 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
17 Feb 2019
Same period 2018 Same period 2017
Rank 99 94 82
Rank change year-on-year -5 -12 -7
Permanent jobs citing ETL 326 345 381
As % of all permanent IT jobs advertised in the City of London 3.18% 3.24% 3.63%
As % of the Processes & Methodologies category 3.45% 3.47% 3.99%
Number of salaries quoted 313 297 362
City of London median annual salary £55,000 £60,000 £60,000
Median salary % change year-on-year -8.33% - -
10th Percentile £41,250 £43,750 £41,250
90th Percentile £85,000 £83,750 £77,500
Central London median annual salary £57,500 £60,000 £60,000
% change year-on-year -4.17% - -

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 9,437 9,942 9,558
As % of all permanent IT jobs advertised in the City of London 91.95% 93.24% 91.05%
Number of salaries quoted 8,381 8,857 8,711
City of London median annual salary £65,000 £60,000 £60,000
Median salary % change year-on-year +8.33% - +4.35%
10th Percentile £36,250 £36,250 £35,000
90th Percentile £95,000 £95,000 £92,500
Central London median annual salary £65,000 £60,000 £57,500
% change year-on-year +8.33% +4.35% -

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 17 February 2019.

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 17 February 2019. 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 +5 4 £55,000 +4.76%
ETL
Central London

For the 6 months to 17 February 2019, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the City of London region with a requirement for ETL.

1 231 (70.86%) SQL
2 159 (48.77%) Business Intelligence
3 149 (45.71%) Data Warehouse
4 138 (42.33%) SQL Server
5 124 (38.04%) Agile Software Development
6 117 (35.89%) SQL Server Integration Services
7 99 (30.37%) Finance
8 95 (29.14%) SQL Server Reporting Services
9 87 (26.69%) Microsoft
9 87 (26.69%) Analytics
10 75 (23.01%) Power BI
11 73 (22.39%) Python
12 71 (21.78%) Data Modelling
13 70 (21.47%) Java
14 67 (20.55%) T-SQL
15 66 (20.25%) SQL Server Analysis Services
16 65 (19.94%) Microsoft Azure
17 62 (19.02%) XML
18 57 (17.48%) Visualisation
19 55 (16.87%) Big Data
20 54 (16.56%) .NET
21 51 (15.64%) SAP
21 51 (15.64%) Relational Database
22 50 (15.34%) Data Quality
23 49 (15.03%) Tableau
23 49 (15.03%) PowerShell
24 47 (14.42%) QA
25 46 (14.11%) Hadoop
26 44 (13.50%) Oracle
27 42 (12.88%) Analytical Skills

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 42 (12.88%) Apache Spark
2 23 (7.06%) SharePoint
3 8 (2.45%) Apache Airflow
4 4 (1.23%) Apache Pig
5 3 (0.92%) Apache
6 2 (0.61%) Luigi
6 2 (0.61%) NServiceBus
6 2 (0.61%) SAS
7 1 (0.31%) Elasticsearch
7 1 (0.31%) IIS
7 1 (0.31%) Jupyter
7 1 (0.31%) OpenStack
7 1 (0.31%) SugarCRM
Applications
1 32 (9.82%) Microsoft Excel
2 5 (1.53%) Microsoft Office
3 1 (0.31%) Microsoft PowerPoint
3 1 (0.31%) MS Visio
Business Applications
1 34 (10.43%) Dynamics CRM
2 9 (2.76%) FastStats
3 2 (0.61%) Markit EDM
4 1 (0.31%) Cognos TM1
4 1 (0.31%) Eagle PACE
4 1 (0.31%) Relativity
4 1 (0.31%) SAP BPC
4 1 (0.31%) SAP S/4HANA
Cloud Services
1 65 (19.94%) Microsoft Azure
2 34 (10.43%) Amazon AWS
3 26 (7.98%) Azure Data Factory
4 17 (5.21%) Serverless
5 13 (3.99%) Azure Functions
6 9 (2.76%) GitHub
7 6 (1.84%) Amazon S3
7 6 (1.84%) Google Cloud Platform
8 5 (1.53%) Data Lake Analytics
9 3 (0.92%) Amazon EC2
9 3 (0.92%) AWS Lambda
10 2 (0.61%) Amazon EMR
10 2 (0.61%) Amazon Kinesis
10 2 (0.61%) Boomi
10 2 (0.61%) Dynamics 365
10 2 (0.61%) OpenShift
11 1 (0.31%) Amazon CloudWatch
11 1 (0.31%) AWS CloudFormation
11 1 (0.31%) Azure Machine Learning
11 1 (0.31%) SaaS
Communications & Networking
1 1 (0.31%) SAN
Database & Business Intelligence
1 149 (45.71%) Data Warehouse
2 138 (42.33%) SQL Server
3 117 (35.89%) SQL Server Integration Services
4 95 (29.14%) SQL Server Reporting Services
5 75 (23.01%) Power BI
6 66 (20.25%) SQL Server Analysis Services
7 55 (16.87%) Big Data
8 51 (15.64%) Relational Database
9 46 (14.11%) Hadoop
10 37 (11.35%) NoSQL
11 36 (11.04%) SAP Data Services
12 32 (9.82%) BusinessObjects
13 28 (8.59%) MongoDB
14 27 (8.28%) Data Lake
15 24 (7.36%) SQL Server 2016
16 21 (6.44%) Apache Hive
16 21 (6.44%) PostgreSQL
17 19 (5.83%) Amazon Redshift
17 19 (5.83%) RDBMS
18 18 (5.52%) Azure SQL Data Warehouse
Development Applications
1 24 (7.36%) Git (software)
2 18 (5.52%) Jenkins
3 15 (4.60%) Subversion
4 13 (3.99%) Octopus Deploy
4 13 (3.99%) TeamCity
4 13 (3.99%) tSQLt
5 11 (3.37%) Team Foundation Server
6 9 (2.76%) Selenium
7 5 (1.53%) JIRA
7 5 (1.53%) SpecFlow
7 5 (1.53%) SQL Server Management Studio (SSMS)
7 5 (1.53%) Visual Studio Team System
8 3 (0.92%) Eclipse
9 2 (0.61%) ERwin
9 2 (0.61%) RStudio
9 2 (0.61%) Selenium IDE
9 2 (0.61%) SoapUI
9 2 (0.61%) Visual Studio
10 1 (0.31%) ER Studio
10 1 (0.31%) Hudson
General
1 99 (30.37%) Finance
2 41 (12.58%) Retail
3 12 (3.68%) Banking
4 10 (3.07%) Legal
5 6 (1.84%) Games
6 5 (1.53%) Law
7 3 (0.92%) Advertising
7 3 (0.92%) German Language
7 3 (0.92%) Marketing
7 3 (0.92%) Spanish Language
8 2 (0.61%) Automotive
8 2 (0.61%) Investment Banking
8 2 (0.61%) Pharmaceutical
9 1 (0.31%) Electronics
9 1 (0.31%) Financial Institution
9 1 (0.31%) Publishing
9 1 (0.31%) Retail Banking
Job Titles
1 134 (41.10%) Developer
2 69 (21.17%) Data Engineer
3 68 (20.86%) Analyst
4 42 (12.88%) Business Intelligence Developer
5 39 (11.96%) Java Developer
6 35 (10.74%) Senior Developer
7 29 (8.90%) SQL Developer
8 27 (8.28%) Senior Java Developer
9 26 (7.98%) Systems Analyst
10 23 (7.06%) Applications Support
11 22 (6.75%) Applications Support Analyst
11 22 (6.75%) ETL Developer
11 22 (6.75%) Python Engineer
12 19 (5.83%) Data Analyst
13 15 (4.60%) Architect
14 14 (4.29%) Business Intelligence Manager
15 13 (3.99%) Big Data Engineer
16 12 (3.68%) Insurance Systems Analyst
16 12 (3.68%) SQL BI Developer
16 12 (3.68%) SSIS Developer
Libraries, Frameworks & Software Standards
1 62 (19.02%) XML
2 54 (16.56%) .NET
3 35 (10.74%) Web Services
4 28 (8.59%) Spring
5 27 (8.28%) Apache Camel
5 27 (8.28%) RESTful
5 27 (8.28%) SOAP
5 27 (8.28%) Spring Boot
6 25 (7.67%) GraphQL
7 15 (4.60%) NumPy
7 15 (4.60%) Pandas
8 13 (3.99%) Kafka
9 11 (3.37%) SciPy
10 9 (2.76%) ASP.NET
10 9 (2.76%) XSD
11 8 (2.45%) JSON
11 8 (2.45%) Spark Streaming
12 5 (1.53%) Natural Language Processing
12 5 (1.53%) REST
12 5 (1.53%) Velocity
Miscellaneous
1 42 (12.88%) Analytical Skills
2 35 (10.74%) Data Structures
3 34 (10.43%) Reinsurance
4 18 (5.52%) Fintech
5 15 (4.60%) Algorithms
6 13 (3.99%) Market Risk
7 11 (3.37%) Spread Betting
8 8 (2.45%) Management Information System
9 6 (1.84%) Self-Motivation
10 4 (1.23%) Greenfield Project
10 4 (1.23%) Hedge funds
10 4 (1.23%) Marketing Technology
10 4 (1.23%) Reference Data
11 3 (0.92%) Clustering
11 3 (0.92%) Credit Risk
11 3 (0.92%) User Experience
12 2 (0.61%) Data Centre
12 2 (0.61%) Equities
12 2 (0.61%) NHS
12 2 (0.61%) Virtual Team
Operating Systems
1 33 (10.12%) Linux
2 11 (3.37%) Unix
3 6 (1.84%) Windows
4 1 (0.31%) AIX
4 1 (0.31%) HPUX
4 1 (0.31%) Solaris
4 1 (0.31%) Windows Server
4 1 (0.31%) Windows Server 2008
4 1 (0.31%) Windows Server 2012
Processes & Methodologies
1 159 (48.77%) Business Intelligence
2 124 (38.04%) Agile Software Development
3 87 (26.69%) Analytics
4 71 (21.78%) Data Modelling
5 57 (17.48%) Visualisation
6 42 (12.88%) Data Engineering
7 41 (12.58%) Data Management
8 39 (11.96%) Data Analysis
8 39 (11.96%) Kimball Methodology
9 37 (11.35%) CRM
10 33 (10.12%) Scrum
11 31 (9.51%) Data Integration
12 30 (9.20%) Data Science
13 29 (8.90%) Test Automation
13 29 (8.90%) User Acceptance Testing
14 28 (8.59%) Microservices
15 27 (8.28%) Pair Programming
16 25 (7.67%) Change Control
16 25 (7.67%) Migration
16 25 (7.67%) Release Management
Programming Languages
1 231 (70.86%) SQL
2 73 (22.39%) Python
3 70 (21.47%) Java
4 67 (20.55%) T-SQL
5 49 (15.03%) PowerShell
6 40 (12.27%) JavaScript
7 33 (10.12%) C#
8 24 (7.36%) VBA
9 15 (4.60%) Scala
10 10 (3.07%) Data Analysis Expressions (DAX)
10 10 (3.07%) R
11 5 (1.53%) PL/SQL
11 5 (1.53%) U-SQL
12 4 (1.23%) Groovy
13 3 (0.92%) Bash Shell
13 3 (0.92%) C
13 3 (0.92%) C++
13 3 (0.92%) VB
14 2 (0.61%) MATLAB
14 2 (0.61%) PHP
Qualifications
1 13 (3.99%) Degree
2 8 (2.45%) Computer Science Degree
3 3 (0.92%) ISEB
4 2 (0.61%) ISTQB
4 2 (0.61%) PhD
5 1 (0.31%) AWS Certification
5 1 (0.31%) ISTQB Foundation Certification
5 1 (0.31%) Security Cleared
Quality Assurance & Compliance
1 50 (15.34%) Data Quality
2 47 (14.42%) QA
3 5 (1.53%) Solvency II
4 4 (1.23%) SLA
5 2 (0.61%) IFRS
6 1 (0.31%) GDPR
6 1 (0.31%) ISO 20022
6 1 (0.31%) ISO/IEC 27001
System Software
1 35 (10.74%) Docker
2 9 (2.76%) Apache Flume
3 8 (2.45%) HDFS
4 3 (0.92%) Apache ZooKeeper
5 2 (0.61%) VMware Infrastructure
6 1 (0.31%) Virtual Machines
Systems Management
1 30 (9.20%) Kubernetes
2 27 (8.28%) Docker Swarm
3 11 (3.37%) Oozie
4 3 (0.92%) Terraform
5 2 (0.61%) Ansible
5 2 (0.61%) Automic
5 2 (0.61%) Control-M
5 2 (0.61%) Grafana
6 1 (0.31%) Graylog
6 1 (0.31%) Prometheus
Vendors
1 87 (26.69%) Microsoft
2 51 (15.64%) SAP
3 49 (15.03%) Tableau
4 44 (13.50%) Oracle
5 27 (8.28%) Red Hat
6 22 (6.75%) Talend
7 13 (3.99%) Cloudera
8 12 (3.68%) Informatica
9 10 (3.07%) Hortonworks
10 7 (2.15%) Jedox
11 6 (1.84%) Google
12 5 (1.53%) IBM
13 4 (1.23%) SnapLogic
13 4 (1.23%) Teradata
14 3 (0.92%) Cognos
14 3 (0.92%) MuleSoft
14 3 (0.92%) Salesforce.com
15 2 (0.61%) Dell
15 2 (0.61%) MicroStrategy
15 2 (0.61%) Sybase