Period
to 19 November 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 19 November 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
19 Nov 2018
Same period 2017 Same period 2016
Rank 83 88 91
Rank change year-on-year +5 +3 -9
Permanent jobs citing ETL 408 352 373
As % of all permanent IT jobs advertised in the City of London 3.66% 3.47% 3.21%
As % of the Processes & Methodologies category 4.00% 3.78% 3.55%
Number of salaries quoted 384 326 345
City of London median annual salary £60,000 £57,500 £60,000
Median salary % change year-on-year +4.35% -4.17% +4.35%
10th Percentile £41,250 £43,750 £38,800
90th Percentile £85,000 £78,750 £82,500
Central London median annual salary £60,000 £57,500 £60,000
% change year-on-year +4.35% -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,209 9,305 10,516
As % of all permanent IT jobs advertised in the City of London 91.63% 91.76% 90.45%
Number of salaries quoted 9,099 8,410 9,586
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,750 £36,225 £35,000
90th Percentile £95,000 £93,750 £90,000
Central London median annual salary £62,500 £60,000 £57,500
% change year-on-year +4.17% +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 19 November 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 19 November 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 +4 12 £50,000 -4.76%
ETL
Central London

For the 6 months to 19 November 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 299 (73.28%) SQL
2 201 (49.26%) Data Warehouse
3 192 (47.06%) SQL Server
4 190 (46.57%) Business Intelligence
5 171 (41.91%) SQL Server Integration Services
6 137 (33.58%) Finance
7 130 (31.86%) SQL Server Reporting Services
8 122 (29.90%) Agile Software Development
8 122 (29.90%) T-SQL
9 107 (26.23%) Microsoft
10 94 (23.04%) Power BI
11 88 (21.57%) Data Modelling
12 87 (21.32%) Analytics
13 86 (21.08%) SQL Server Analysis Services
14 76 (18.63%) Python
15 75 (18.38%) Big Data
16 71 (17.40%) Tableau
17 68 (16.67%) Java
18 66 (16.18%) XML
19 64 (15.69%) C#
19 64 (15.69%) Relational Database
20 63 (15.44%) Visualisation
21 62 (15.20%) Microsoft Azure
22 61 (14.95%) Data Quality
23 58 (14.22%) Oracle
23 58 (14.22%) Analytical Skills
24 56 (13.73%) Data Management
25 55 (13.48%) BusinessObjects
26 54 (13.24%) .NET
26 54 (13.24%) Amazon AWS

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.56%) Apache Spark
2 19 (4.66%) SAS
3 18 (4.41%) SharePoint
4 6 (1.47%) Apache Pig
5 4 (0.98%) Apache
5 4 (0.98%) Elasticsearch
6 3 (0.74%) IIS
7 2 (0.49%) Apache Airflow
8 1 (0.25%) Luigi
8 1 (0.25%) NServiceBus
8 1 (0.25%) SugarCRM
Applications
1 53 (12.99%) Microsoft Excel
2 7 (1.72%) Microsoft Office
3 2 (0.49%) Microsoft PowerPoint
3 2 (0.49%) MS Visio
4 1 (0.25%) Spreadsheet
Business Applications
1 23 (5.64%) Dynamics CRM
2 9 (2.21%) FastStats
3 3 (0.74%) PeopleSoft HCM
4 2 (0.49%) Markit EDM
5 1 (0.25%) Actimize
5 1 (0.25%) Dynamics AX
5 1 (0.25%) Relativity
Cloud Services
1 62 (15.20%) Microsoft Azure
2 54 (13.24%) Amazon AWS
3 22 (5.39%) Azure Data Factory
4 9 (2.21%) Serverless
5 8 (1.96%) Azure Functions
6 6 (1.47%) Amazon EC2
7 5 (1.23%) Amazon S3
7 5 (1.23%) Data Lake Analytics
7 5 (1.23%) Google Cloud Platform
8 4 (0.98%) Amazon EMR
8 4 (0.98%) Apigee
8 4 (0.98%) Virtual Private Cloud
9 3 (0.74%) Amazon Kinesis
10 2 (0.49%) Amazon Glacier
10 2 (0.49%) Amazon SQS
10 2 (0.49%) AWS Lambda
10 2 (0.49%) Boomi
10 2 (0.49%) Cloud Computing
10 2 (0.49%) Dynamics 365
10 2 (0.49%) SaaS
Communications & Networking
1 1 (0.25%) CHAP
1 1 (0.25%) SAN
Database & Business Intelligence
1 201 (49.26%) Data Warehouse
2 192 (47.06%) SQL Server
3 171 (41.91%) SQL Server Integration Services
4 130 (31.86%) SQL Server Reporting Services
5 94 (23.04%) Power BI
6 86 (21.08%) SQL Server Analysis Services
7 75 (18.38%) Big Data
8 64 (15.69%) Relational Database
9 55 (13.48%) BusinessObjects
10 54 (13.24%) Hadoop
11 43 (10.54%) SQL Server 2008
12 39 (9.56%) SQL Server 2012
13 37 (9.07%) NoSQL
14 32 (7.84%) SQL Server 2016
15 29 (7.11%) Data Lake
16 27 (6.62%) SAP Data Services
17 26 (6.37%) Apache Hive
17 26 (6.37%) OLAP
17 26 (6.37%) PostgreSQL
18 23 (5.64%) Microsoft Analysis Services
Development Applications
1 28 (6.86%) Team Foundation Server
2 24 (5.88%) Jenkins
3 23 (5.64%) Git (software)
4 19 (4.66%) Visual Studio
5 16 (3.92%) Subversion
6 12 (2.94%) TeamCity
7 10 (2.45%) Selenium
8 9 (2.21%) Octopus Deploy
8 9 (2.21%) SQL Server Management Studio (SSMS)
8 9 (2.21%) Visual Studio Team System
9 8 (1.96%) tSQLt
10 6 (1.47%) Mercurial
10 6 (1.47%) VSS/SourceSafe
11 5 (1.23%) Eclipse
11 5 (1.23%) SpecFlow
12 4 (0.98%) JIRA
12 4 (0.98%) ProC
13 3 (0.74%) ER Studio
13 3 (0.74%) ERwin
13 3 (0.74%) RStudio
General
1 137 (33.58%) Finance
2 39 (9.56%) Retail
3 19 (4.66%) Banking
4 10 (2.45%) Law
4 10 (2.45%) Marketing
5 9 (2.21%) Advertising
5 9 (2.21%) Legal
6 8 (1.96%) General Ledger
7 4 (0.98%) Games
7 4 (0.98%) Investment Banking
8 3 (0.74%) Aerospace
8 3 (0.74%) Pharmaceutical
9 2 (0.49%) Financial Institution
9 2 (0.49%) Publishing
10 1 (0.25%) Front Office
10 1 (0.25%) German Language
10 1 (0.25%) Multimedia
10 1 (0.25%) Retail Banking
10 1 (0.25%) Social Science
10 1 (0.25%) Spanish Language
Job Titles
1 174 (42.65%) Developer
2 78 (19.12%) Analyst
3 62 (15.20%) Business Intelligence Developer
4 60 (14.71%) SQL Developer
5 58 (14.22%) Data Engineer
6 39 (9.56%) Senior Developer
7 31 (7.60%) Architect
7 31 (7.60%) Consultant
8 26 (6.37%) Java Developer
9 25 (6.13%) ETL Developer
9 25 (6.13%) SQL BI Developer
10 24 (5.88%) Data Analyst
11 20 (4.90%) SQL Analyst
12 19 (4.66%) Senior Java Developer
12 19 (4.66%) SSIS Developer
13 17 (4.17%) Business Developer
13 17 (4.17%) Data Architect
13 17 (4.17%) SQL Server Developer
14 16 (3.92%) Business Intelligence Analyst
15 15 (3.68%) Applications Support
Libraries, Frameworks & Software Standards
1 66 (16.18%) XML
2 54 (13.24%) .NET
3 42 (10.29%) Web Services
4 26 (6.37%) SOAP
5 25 (6.13%) RESTful
6 19 (4.66%) Apache Camel
6 19 (4.66%) Spring
6 19 (4.66%) Spring Boot
7 18 (4.41%) GraphQL
8 15 (3.68%) MDX
9 12 (2.94%) Kafka
9 12 (2.94%) NumPy
9 12 (2.94%) Pandas
9 12 (2.94%) XSD
10 11 (2.70%) ASP.NET
11 9 (2.21%) REST
11 9 (2.21%) SciPy
12 8 (1.96%) HTML
12 8 (1.96%) JSON
13 7 (1.72%) Node.js
Miscellaneous
1 58 (14.22%) Analytical Skills
2 42 (10.29%) Reinsurance
3 37 (9.07%) Data Structures
4 26 (6.37%) Fintech
5 22 (5.39%) Computer Science
6 15 (3.68%) Market Risk
7 12 (2.94%) Algorithms
8 11 (2.70%) Management Information System
9 10 (2.45%) Replication
10 9 (2.21%) Spread Betting
11 7 (1.72%) Self-Motivation
12 6 (1.47%) Credit Risk
12 6 (1.47%) Greenfield Project
13 4 (0.98%) Clustering
13 4 (0.98%) Data Centre
13 4 (0.98%) Public Cloud
13 4 (0.98%) Reference Data
13 4 (0.98%) Tandem
14 3 (0.74%) Analytical Mindset
14 3 (0.74%) User Experience
Operating Systems
1 35 (8.58%) Linux
2 17 (4.17%) Windows
3 14 (3.43%) Unix
4 5 (1.23%) AIX
4 5 (1.23%) HPUX
4 5 (1.23%) Solaris
4 5 (1.23%) Windows Server
4 5 (1.23%) Windows Server 2012
5 4 (0.98%) Red Hat Enterprise Linux
6 1 (0.25%) CentOS
6 1 (0.25%) Windows Server 2008
Processes & Methodologies
1 190 (46.57%) Business Intelligence
2 122 (29.90%) Agile Software Development
3 88 (21.57%) Data Modelling
4 87 (21.32%) Analytics
5 63 (15.44%) Visualisation
6 56 (13.73%) Data Management
7 52 (12.75%) Data Integration
8 45 (11.03%) Data Analysis
8 45 (11.03%) Kimball Methodology
9 43 (10.54%) Migration
10 42 (10.29%) Business Analysis
11 37 (9.07%) Problem-Solving
12 36 (8.82%) ETL Development
13 33 (8.09%) Scrum
14 30 (7.35%) Data Science
15 29 (7.11%) Test Automation
16 26 (6.37%) Data Analytics
16 26 (6.37%) Data Engineering
16 26 (6.37%) Data Visualisation
16 26 (6.37%) SDLC
Programming Languages
1 299 (73.28%) SQL
2 122 (29.90%) T-SQL
3 76 (18.63%) Python
4 68 (16.67%) Java
5 64 (15.69%) C#
6 45 (11.03%) PowerShell
7 42 (10.29%) JavaScript
8 21 (5.15%) Data Analysis Expressions (DAX)
9 19 (4.66%) R
10 18 (4.41%) VBA
11 12 (2.94%) Scala
12 10 (2.45%) C
12 10 (2.45%) VB
13 7 (1.72%) Bash Shell
14 6 (1.47%) C++
15 5 (1.23%) U-SQL
16 4 (0.98%) PHP
17 3 (0.74%) MATLAB
17 3 (0.74%) PL/SQL
17 3 (0.74%) Shell Script
Qualifications
1 22 (5.39%) Degree
2 11 (2.70%) Computer Science Degree
3 10 (2.45%) Security Cleared
4 3 (0.74%) MCITP
4 3 (0.74%) Microsoft Certification
4 3 (0.74%) Microsoft Certified Architect
4 3 (0.74%) PhD
4 3 (0.74%) SC Cleared
5 2 (0.49%) AWS Certification
5 2 (0.49%) ISEB
5 2 (0.49%) ISTQB Foundation Certification
5 2 (0.49%) Master's Degree
6 1 (0.25%) Numerate Degree
6 1 (0.25%) Postgraduate
6 1 (0.25%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 61 (14.95%) Data Quality
2 44 (10.78%) QA
3 7 (1.72%) GDPR
4 2 (0.49%) SLA
4 2 (0.49%) Solvency II
5 1 (0.25%) ISO/IEC 27001
5 1 (0.25%) MiFID
5 1 (0.25%) PMO
System Software
1 29 (7.11%) Docker
2 3 (0.74%) Apache ZooKeeper
2 3 (0.74%) HDFS
2 3 (0.74%) VMware Infrastructure
3 2 (0.49%) Apache Flume
4 1 (0.25%) Virtual Machines
Systems Management
1 20 (4.90%) Kubernetes
2 19 (4.66%) Docker Swarm
3 6 (1.47%) Oozie
4 5 (1.23%) Ansible
5 4 (0.98%) Grafana
6 3 (0.74%) Prometheus
6 3 (0.74%) Terraform
7 2 (0.49%) Automic
7 2 (0.49%) Control-M
7 2 (0.49%) Opscode Chef
7 2 (0.49%) Packer
8 1 (0.25%) Kibana
8 1 (0.25%) logstash
Vendors
1 107 (26.23%) Microsoft
2 71 (17.40%) Tableau
3 58 (14.22%) Oracle
4 51 (12.50%) SAP
5 32 (7.84%) Informatica
6 25 (6.13%) Talend
7 21 (5.15%) Red Hat
8 10 (2.45%) IBM
9 7 (1.72%) Workday
10 6 (1.47%) Jedox
11 5 (1.23%) Cloudera
11 5 (1.23%) Google
11 5 (1.23%) MicroStrategy
12 4 (0.98%) Algorithmics
12 4 (0.98%) Hortonworks
12 4 (0.98%) Perforce
12 4 (0.98%) Salesforce.com
12 4 (0.98%) SnapLogic
12 4 (0.98%) Splunk
12 4 (0.98%) Teradata