Period
to 23 September 2018

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 23 September 2018 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
23 Sep 2018
Same period 2017 Same period 2016
Rank 78 90 105
Rank change year-on-year +12 +15 -23
Permanent jobs citing ETL 431 335 355
As % of all permanent IT jobs advertised in the City of London 3.95% 3.31% 2.87%
As % of the Processes & Methodologies category 4.28% 3.61% 3.13%
Number of salaries quoted 394 314 329
City of London median annual salary £65,000 £57,500 £60,000
Median salary % change year-on-year +13.04% -4.17% +4.35%
10th Percentile £42,150 £42,500 £37,500
90th Percentile £87,500 £78,750 £88,000
Central London median annual salary £65,000 £57,500 £60,000
% change year-on-year +13.04% -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 10,070 9,268 11,334
As % of all permanent IT jobs advertised in the City of London 92.21% 91.51% 91.57%
Number of salaries quoted 8,971 8,355 10,371
City of London median annual salary £65,000 £60,000 £60,000
Median salary % change year-on-year +8.33% - +4.35%
10th Percentile £37,000 £36,250 £35,000
90th Percentile £93,750 £92,500 £87,500
Central London median annual salary £62,500 £60,000 £57,500
% change year-on-year +4.17% +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 23 September 2018.

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 23 September 2018. 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 +9 17 £45,000 -14.29%
ETL
Central London

For the 6 months to 23 September 2018, 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 313 (72.62%) SQL
2 231 (53.60%) Data Warehouse
3 216 (50.12%) SQL Server
4 205 (47.56%) SQL Server Integration Services
5 186 (43.16%) Business Intelligence
6 171 (39.68%) Finance
7 146 (33.87%) SQL Server Reporting Services
8 134 (31.09%) T-SQL
9 113 (26.22%) Microsoft
10 106 (24.59%) Agile Software Development
11 96 (22.27%) SQL Server Analysis Services
12 88 (20.42%) Analytics
13 83 (19.26%) Data Modelling
14 80 (18.56%) Big Data
15 77 (17.87%) Power BI
16 73 (16.94%) Data Integration
17 68 (15.78%) Tableau
17 68 (15.78%) Data Quality
17 68 (15.78%) Python
18 63 (14.62%) Relational Database
19 61 (14.15%) Data Management
20 58 (13.46%) Oracle
20 58 (13.46%) Hadoop
20 58 (13.46%) Analytical Skills
21 56 (12.99%) Java
22 54 (12.53%) C#
22 54 (12.53%) .NET
22 54 (12.53%) Migration
23 53 (12.30%) XML
23 53 (12.30%) Visualisation

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 39 (9.05%) Apache Spark
2 21 (4.87%) SAS
3 13 (3.02%) SharePoint
4 4 (0.93%) Elasticsearch
5 3 (0.70%) Confluence
5 3 (0.70%) IIS
5 3 (0.70%) Oracle Workflow
6 2 (0.46%) Apache Pig
7 1 (0.23%) Apache
7 1 (0.23%) Apache Airflow
7 1 (0.23%) Jupyter
7 1 (0.23%) SugarCRM
Applications
1 45 (10.44%) Microsoft Excel
2 11 (2.55%) Microsoft Office
3 2 (0.46%) Microsoft PowerPoint
3 2 (0.46%) MS Visio
4 1 (0.23%) Spreadsheet
4 1 (0.23%) SPSS
Business Applications
1 8 (1.86%) Dynamics CRM
2 6 (1.39%) FastStats
2 6 (1.39%) PeopleSoft HCM
3 4 (0.93%) Markit EDM
4 2 (0.46%) Cognos TM1
5 1 (0.23%) Actimize
5 1 (0.23%) Dynamics AX
5 1 (0.23%) SAP BPC
Cloud Services
1 50 (11.60%) Amazon AWS
2 45 (10.44%) Microsoft Azure
3 8 (1.86%) Amazon EMR
4 6 (1.39%) Amazon Kinesis
5 5 (1.16%) Azure Data Factory
6 4 (0.93%) Amazon EC2
6 4 (0.93%) Amazon S3
6 4 (0.93%) Google Cloud Platform
6 4 (0.93%) Virtual Private Cloud
7 2 (0.46%) Amazon Glacier
7 2 (0.46%) Amazon SQS
7 2 (0.46%) AWS Lambda
7 2 (0.46%) Azure Functions
7 2 (0.46%) Cloud Computing
7 2 (0.46%) Data Lake Analytics
7 2 (0.46%) SaaS
7 2 (0.46%) Serverless
8 1 (0.23%) Azure Machine Learning
8 1 (0.23%) Boomi
8 1 (0.23%) Dynamics 365
Communications & Networking
1 1 (0.23%) CHAP
Database & Business Intelligence
1 231 (53.60%) Data Warehouse
2 216 (50.12%) SQL Server
3 205 (47.56%) SQL Server Integration Services
4 146 (33.87%) SQL Server Reporting Services
5 96 (22.27%) SQL Server Analysis Services
6 80 (18.56%) Big Data
7 77 (17.87%) Power BI
8 63 (14.62%) Relational Database
9 58 (13.46%) Hadoop
10 53 (12.30%) SQL Server 2012
11 48 (11.14%) BusinessObjects
12 47 (10.90%) NoSQL
12 47 (10.90%) SQL Server 2008
13 30 (6.96%) Apache Hive
13 30 (6.96%) OLAP
14 29 (6.73%) SQL Server 2016
15 26 (6.03%) SQL Server 2014
16 22 (5.10%) QlikView
17 20 (4.64%) Amazon Redshift
17 20 (4.64%) Microsoft Analysis Services
Development Applications
1 35 (8.12%) Team Foundation Server
2 27 (6.26%) Visual Studio
3 18 (4.18%) Jenkins
4 15 (3.48%) Git (software)
4 15 (3.48%) SQL Server Management Studio (SSMS)
5 10 (2.32%) Subversion
6 7 (1.62%) JIRA
6 7 (1.62%) Selenium
6 7 (1.62%) TeamCity
6 7 (1.62%) VSS/SourceSafe
7 6 (1.39%) Mercurial
7 6 (1.39%) Visual Studio Team System
8 5 (1.16%) ERwin
9 4 (0.93%) Eclipse
9 4 (0.93%) ER Studio
9 4 (0.93%) Octopus Deploy
9 4 (0.93%) ProC
10 2 (0.46%) Cucumber
10 2 (0.46%) Maven
10 2 (0.46%) tSQLt
General
1 171 (39.68%) Finance
2 38 (8.82%) Banking
3 31 (7.19%) Retail
4 21 (4.87%) Marketing
5 20 (4.64%) Legal
6 13 (3.02%) Advertising
7 10 (2.32%) Back Office
8 9 (2.09%) Law
9 8 (1.86%) General Ledger
10 5 (1.16%) Front Office
11 4 (0.93%) Investment Banking
12 3 (0.70%) Aerospace
12 3 (0.70%) Pharmaceutical
13 2 (0.46%) Games
13 2 (0.46%) Publishing
14 1 (0.23%) Financial Institution
14 1 (0.23%) International Banking
14 1 (0.23%) Multimedia
Job Titles
1 180 (41.76%) Developer
2 75 (17.40%) Analyst
3 73 (16.94%) SQL Developer
4 68 (15.78%) Business Intelligence Developer
5 56 (12.99%) Data Engineer
6 46 (10.67%) Architect
7 33 (7.66%) ETL Developer
8 32 (7.42%) Consultant
8 32 (7.42%) SSIS Developer
9 28 (6.50%) Senior Developer
10 27 (6.26%) Project Manager
11 25 (5.80%) Business Analyst
11 25 (5.80%) Data Architect
12 22 (5.10%) SQL BI Developer
12 22 (5.10%) SQL Server Developer
13 21 (4.87%) Big Data Engineer
14 19 (4.41%) Data Warehouse Developer
14 19 (4.41%) SQL Analyst
15 18 (4.18%) Business Developer
15 18 (4.18%) Business Manager
Libraries, Frameworks & Software Standards
1 54 (12.53%) .NET
2 53 (12.30%) XML
3 34 (7.89%) Web Services
4 21 (4.87%) MDX
5 16 (3.71%) Kafka
5 16 (3.71%) SOAP
6 15 (3.48%) RESTful
7 11 (2.55%) REST
8 10 (2.32%) Node.js
9 9 (2.09%) Apache Camel
9 9 (2.09%) GraphQL
9 9 (2.09%) NumPy
9 9 (2.09%) Pandas
9 9 (2.09%) Spring
9 9 (2.09%) Spring Boot
9 9 (2.09%) XSD
10 7 (1.62%) HTML
11 6 (1.39%) JSON
11 6 (1.39%) NHibernate
12 5 (1.16%) .NET Framework
Miscellaneous
1 58 (13.46%) Analytical Skills
2 33 (7.66%) Data Structures
3 31 (7.19%) Reinsurance
4 30 (6.96%) Fintech
5 23 (5.34%) Greenfield Project
6 19 (4.41%) Computer Science
7 16 (3.71%) Replication
8 14 (3.25%) Management Information System
9 11 (2.55%) Market Risk
9 11 (2.55%) Self-Motivation
9 11 (2.55%) Tandem
10 7 (1.62%) Algorithms
10 7 (1.62%) Reference Data
11 6 (1.39%) Clustering
11 6 (1.39%) Credit Risk
11 6 (1.39%) Spread Betting
12 4 (0.93%) Public Cloud
13 3 (0.70%) Analytical Mindset
13 3 (0.70%) Data Centre
13 3 (0.70%) Virtual Team
Operating Systems
1 24 (5.57%) Linux
2 17 (3.94%) Windows
3 16 (3.71%) Unix
4 6 (1.39%) AIX
4 6 (1.39%) HPUX
4 6 (1.39%) Solaris
5 5 (1.16%) Windows Server
5 5 (1.16%) Windows Server 2012
6 4 (0.93%) Red Hat Enterprise Linux
7 1 (0.23%) CentOS
7 1 (0.23%) Windows Server 2008
Processes & Methodologies
1 186 (43.16%) Business Intelligence
2 106 (24.59%) Agile Software Development
3 88 (20.42%) Analytics
4 83 (19.26%) Data Modelling
5 73 (16.94%) Data Integration
6 61 (14.15%) Data Management
7 54 (12.53%) Migration
8 53 (12.30%) Visualisation
9 49 (11.37%) Data Analysis
10 48 (11.14%) Business Analysis
11 43 (9.98%) ETL Development
12 42 (9.74%) Project Management
12 42 (9.74%) SDLC
13 39 (9.05%) Problem-Solving
14 37 (8.58%) Data Science
15 36 (8.35%) Kimball Methodology
16 34 (7.89%) Scrum
17 31 (7.19%) Stakeholder Management
18 28 (6.50%) Data Analytics
19 27 (6.26%) Performance Tuning
Programming Languages
1 313 (72.62%) SQL
2 134 (31.09%) T-SQL
3 68 (15.78%) Python
4 56 (12.99%) Java
5 54 (12.53%) C#
6 26 (6.03%) PowerShell
7 24 (5.57%) JavaScript
7 24 (5.57%) Scala
8 21 (4.87%) R
9 18 (4.18%) Data Analysis Expressions (DAX)
10 13 (3.02%) VBA
11 12 (2.78%) VB
12 10 (2.32%) C
13 7 (1.62%) Bash Shell
13 7 (1.62%) Shell Script
14 6 (1.39%) PL/SQL
15 5 (1.16%) C++
16 4 (0.93%) Go
16 4 (0.93%) PHP
17 3 (0.70%) Perl
Qualifications
1 41 (9.51%) Degree
2 13 (3.02%) Security Cleared
3 10 (2.32%) Computer Science Degree
4 9 (2.09%) MCITP
4 9 (2.09%) Microsoft Certification
4 9 (2.09%) Microsoft Certified Architect
5 4 (0.93%) Master's Degree
6 3 (0.70%) ISEB
6 3 (0.70%) ISTQB Foundation Certification
6 3 (0.70%) PhD
6 3 (0.70%) SC Cleared
7 2 (0.46%) AWS Certification
8 1 (0.23%) Numerate Degree
8 1 (0.23%) Postgraduate
8 1 (0.23%) PRINCE2 Certification
8 1 (0.23%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 68 (15.78%) Data Quality
2 28 (6.50%) QA
3 10 (2.32%) GDPR
4 5 (1.16%) PMO
5 1 (0.23%) MiFID
5 1 (0.23%) SLA
5 1 (0.23%) Solvency II
System Software
1 17 (3.94%) Docker
2 7 (1.62%) HDFS
3 2 (0.46%) Apache Flume
3 2 (0.46%) VMware Infrastructure
Systems Management
1 10 (2.32%) Kubernetes
2 9 (2.09%) Docker Swarm
3 5 (1.16%) Oozie
4 4 (0.93%) Ansible
5 3 (0.70%) Grafana
5 3 (0.70%) HP Quality Center
5 3 (0.70%) Prometheus
6 2 (0.46%) Hadoop YARN
6 2 (0.46%) Opscode Chef
6 2 (0.46%) Packer
6 2 (0.46%) Terraform
7 1 (0.23%) Failover Clustering
7 1 (0.23%) Kibana
7 1 (0.23%) logstash
7 1 (0.23%) Mesos
7 1 (0.23%) Microsoft Clustering
Vendors
1 113 (26.22%) Microsoft
2 68 (15.78%) Tableau
3 58 (13.46%) Oracle
4 42 (9.74%) Informatica
5 39 (9.05%) SAP
6 20 (4.64%) Talend
7 14 (3.25%) IBM
8 12 (2.78%) Workday
9 11 (2.55%) Red Hat
10 8 (1.86%) MicroStrategy
11 6 (1.39%) PeopleSoft
12 5 (1.16%) Cognos
12 5 (1.16%) Perforce
13 4 (0.93%) Ab Initio
13 4 (0.93%) Algorithmics
13 4 (0.93%) Apigee
13 4 (0.93%) Siebel
13 4 (0.93%) Splunk
14 3 (0.70%) Alteryx
14 3 (0.70%) SnapLogic