Period
to 18 July 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 18 July 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
18 Jul 2018
Same period 2017 Same period 2016
Rank 75 87 96
Rank change year-on-year +12 +9 -6
Permanent jobs citing ETL 463 348 421
As % of all permanent IT jobs advertised in the City of London 4.15% 3.38% 3.10%
As % of the Processes & Methodologies category 4.50% 3.74% 3.39%
Number of salaries quoted 420 332 370
City of London median annual salary £65,000 £60,000 £57,500
Median salary % change year-on-year +8.33% +4.35% -4.17%
10th Percentile £42,500 £41,250 £37,500
90th Percentile £85,000 £78,750 £82,625
Central London median annual salary £65,000 £60,000 £57,500
% change year-on-year +8.33% +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,282 9,315 12,433
As % of all permanent IT jobs advertised in the City of London 92.16% 90.49% 91.47%
Number of salaries quoted 9,144 8,381 11,247
City of London median annual salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.17% +4.35% +4.55%
10th Percentile £37,000 £35,000 £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 18 July 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 18 July 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 +14 18 £45,000 -10.00%
ETL
Central London

For the 6 months to 18 July 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 319 (68.90%) SQL
2 265 (57.24%) Data Warehouse
3 264 (57.02%) SQL Server
4 248 (53.56%) SQL Server Integration Services
5 232 (50.11%) Business Intelligence
6 175 (37.80%) Finance
7 169 (36.50%) SQL Server Reporting Services
8 159 (34.34%) Microsoft
9 145 (31.32%) SQL Server Analysis Services
10 139 (30.02%) T-SQL
11 111 (23.97%) Agile Software Development
12 95 (20.52%) Analytics
13 94 (20.30%) Data Modelling
14 91 (19.65%) Power BI
15 84 (18.14%) Big Data
16 71 (15.33%) Oracle
17 66 (14.25%) Hadoop
17 66 (14.25%) Data Quality
18 65 (14.04%) Data Integration
18 65 (14.04%) SDLC
19 63 (13.61%) Tableau
20 62 (13.39%) SQL Server 2012
20 62 (13.39%) Relational Database
21 60 (12.96%) Analytical Skills
22 59 (12.74%) Python
23 58 (12.53%) Data Management
23 58 (12.53%) Microsoft Azure
24 57 (12.31%) .NET
25 56 (12.10%) OLAP
25 56 (12.10%) NoSQL

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 41 (8.86%) Apache Spark
2 19 (4.10%) SAS
3 17 (3.67%) SharePoint
4 6 (1.30%) Apache
5 5 (1.08%) Elasticsearch
6 4 (0.86%) IIS
6 4 (0.86%) Jupyter
7 3 (0.65%) Confluence
7 3 (0.65%) Oracle Workflow
8 2 (0.43%) Apache Pig
8 2 (0.43%) Apache Solr
Applications
1 37 (7.99%) Microsoft Excel
2 9 (1.94%) Microsoft Office
3 1 (0.22%) Microsoft PowerPoint
3 1 (0.22%) MS Visio
3 1 (0.22%) SPSS
Business Applications
1 9 (1.94%) PeopleSoft HCM
2 6 (1.30%) Markit EDM
3 5 (1.08%) Cognos TM1
4 4 (0.86%) Dynamics CRM
5 3 (0.65%) FastStats
5 3 (0.65%) SAP BPC
6 1 (0.22%) Actimize
6 1 (0.22%) CSG Singleview
6 1 (0.22%) Dynamics AX
6 1 (0.22%) PeopleSoft CRM
Cloud Services
1 58 (12.53%) Microsoft Azure
2 44 (9.50%) Amazon AWS
3 12 (2.59%) Amazon EMR
4 10 (2.16%) Amazon Kinesis
5 5 (1.08%) GitHub
6 4 (0.86%) Azure Data Factory
7 3 (0.65%) Google Cloud Platform
8 2 (0.43%) Amazon EC2
8 2 (0.43%) Amazon Glacier
8 2 (0.43%) Amazon S3
8 2 (0.43%) Google Analytics
8 2 (0.43%) Virtual Private Cloud
9 1 (0.22%) AWS Lambda
9 1 (0.22%) Azure Machine Learning
9 1 (0.22%) Cloud Computing
9 1 (0.22%) OpenShift
9 1 (0.22%) SaaS
9 1 (0.22%) Serverless
Communications & Networking
1 1 (0.22%) CHAP
1 1 (0.22%) Firewall
Database & Business Intelligence
1 265 (57.24%) Data Warehouse
2 264 (57.02%) SQL Server
3 248 (53.56%) SQL Server Integration Services
4 169 (36.50%) SQL Server Reporting Services
5 145 (31.32%) SQL Server Analysis Services
6 91 (19.65%) Power BI
7 84 (18.14%) Big Data
8 66 (14.25%) Hadoop
9 62 (13.39%) Relational Database
9 62 (13.39%) SQL Server 2012
10 56 (12.10%) NoSQL
10 56 (12.10%) OLAP
11 44 (9.50%) BusinessObjects
12 43 (9.29%) SQL Server 2008
13 30 (6.48%) Apache Hive
14 29 (6.26%) OLTP
15 28 (6.05%) QlikView
15 28 (6.05%) SQL Server 2016
16 24 (5.18%) Snowflake Schema
17 23 (4.97%) Star Schema
Development Applications
1 36 (7.78%) Team Foundation Server
2 24 (5.18%) Visual Studio
3 20 (4.32%) Git (software)
4 17 (3.67%) SQL Server Management Studio (SSMS)
5 9 (1.94%) JIRA
6 7 (1.51%) ERwin
6 7 (1.51%) Jenkins
7 6 (1.30%) ER Studio
8 5 (1.08%) Subversion
8 5 (1.08%) TeamCity
8 5 (1.08%) VSS/SourceSafe
9 4 (0.86%) Bitbucket
9 4 (0.86%) Mercurial
9 4 (0.86%) Selenium
9 4 (0.86%) Visual Studio Team System
10 3 (0.65%) RStudio
11 2 (0.43%) Eclipse
12 1 (0.22%) PowerDesigner
12 1 (0.22%) ProC
12 1 (0.22%) WebDriver
General
1 175 (37.80%) Finance
2 39 (8.42%) Banking
3 26 (5.62%) Legal
3 26 (5.62%) Marketing
4 20 (4.32%) Retail
5 14 (3.02%) Advertising
6 11 (2.38%) Back Office
7 10 (2.16%) Law
8 9 (1.94%) Front Office
9 7 (1.51%) General Ledger
10 4 (0.86%) International Banking
10 4 (0.86%) Publishing
11 3 (0.65%) Investment Banking
12 2 (0.43%) Aerospace
13 1 (0.22%) Billing
13 1 (0.22%) Games
13 1 (0.22%) Pharmaceutical
13 1 (0.22%) Telecoms
Job Titles
1 190 (41.04%) Developer
2 84 (18.14%) SQL Developer
3 82 (17.71%) Business Intelligence Developer
4 77 (16.63%) Analyst
5 56 (12.10%) ETL Developer
6 52 (11.23%) Data Engineer
7 51 (11.02%) SSIS Developer
8 49 (10.58%) Architect
9 34 (7.34%) Data Architect
9 34 (7.34%) Project Manager
10 33 (7.13%) SQL Server Developer
10 33 (7.13%) SSRS Developer
11 32 (6.91%) Consultant
12 29 (6.26%) Business Analyst
13 28 (6.05%) Data Warehouse Developer
14 24 (5.18%) Business Intelligence Analyst
14 24 (5.18%) SQL BI Developer
15 23 (4.97%) Big Data Engineer
15 23 (4.97%) Project Analyst
16 22 (4.75%) Business Manager
Libraries, Frameworks & Software Standards
1 57 (12.31%) .NET
2 34 (7.34%) Web Services
3 33 (7.13%) MDX
3 33 (7.13%) XML
4 24 (5.18%) Kafka
5 16 (3.46%) REST
6 15 (3.24%) JSON
7 14 (3.02%) SOAP
8 11 (2.38%) Node.js
9 6 (1.30%) HTML
9 6 (1.30%) RESTful
9 6 (1.30%) XSD
10 5 (1.08%) Elastic Stack
10 5 (1.08%) LINQ
10 5 (1.08%) NumPy
10 5 (1.08%) Pandas
11 4 (0.86%) ASP.NET
11 4 (0.86%) Natural Language Processing
11 4 (0.86%) scikit-learn
12 3 (0.65%) WSDL
Miscellaneous
1 60 (12.96%) Analytical Skills
2 27 (5.83%) Data Structures
3 26 (5.62%) Greenfield Project
4 24 (5.18%) Fintech
4 24 (5.18%) Self-Motivation
5 22 (4.75%) Reinsurance
6 17 (3.67%) Tandem
7 13 (2.81%) Computer Science
7 13 (2.81%) Management Information System
7 13 (2.81%) Replication
8 9 (1.94%) Algorithms
9 7 (1.51%) Reference Data
9 7 (1.51%) Virtual Team
10 6 (1.30%) Credit Risk
10 6 (1.30%) Market Risk
11 5 (1.08%) Clustering
12 3 (0.65%) Public Cloud
13 2 (0.43%) Data Centre
13 2 (0.43%) Derivative
13 2 (0.43%) Enterprise Software
Operating Systems
1 17 (3.67%) Windows
2 14 (3.02%) Linux
3 13 (2.81%) Unix
4 7 (1.51%) Solaris
4 7 (1.51%) Windows Server
5 6 (1.30%) AIX
5 6 (1.30%) HPUX
5 6 (1.30%) Windows Server 2012
6 4 (0.86%) Red Hat Enterprise Linux
7 2 (0.43%) Windows Server 2008
8 1 (0.22%) Oracle Linux
Processes & Methodologies
1 232 (50.11%) Business Intelligence
2 111 (23.97%) Agile Software Development
3 95 (20.52%) Analytics
4 94 (20.30%) Data Modelling
5 65 (14.04%) Data Integration
5 65 (14.04%) SDLC
6 58 (12.53%) Data Management
7 54 (11.66%) Kimball Methodology
8 51 (11.02%) Project Management
9 49 (10.58%) Data Analysis
10 45 (9.72%) Visualisation
11 44 (9.50%) Business Analysis
12 43 (9.29%) Migration
13 41 (8.86%) Data Science
13 41 (8.86%) Problem-Solving
14 37 (7.99%) Mentoring
14 37 (7.99%) Stakeholder Management
15 36 (7.78%) ETL Development
16 33 (7.13%) Performance Tuning
17 32 (6.91%) Machine Learning
Programming Languages
1 319 (68.90%) SQL
2 139 (30.02%) T-SQL
3 59 (12.74%) Python
4 50 (10.80%) Java
5 46 (9.94%) C#
6 33 (7.13%) PowerShell
7 30 (6.48%) Scala
8 21 (4.54%) R
9 18 (3.89%) JavaScript
10 16 (3.46%) Data Analysis Expressions (DAX)
11 10 (2.16%) PL/SQL
11 10 (2.16%) VB
11 10 (2.16%) VBA
12 7 (1.51%) Shell Script
13 5 (1.08%) C
13 5 (1.08%) PHP
14 4 (0.86%) Go
15 3 (0.65%) Bash Shell
16 2 (0.43%) Groovy
16 2 (0.43%) Perl
Qualifications
1 49 (10.58%) Degree
2 15 (3.24%) Security Cleared
3 11 (2.38%) Microsoft Certification
4 9 (1.94%) MCITP
4 9 (1.94%) Microsoft Certified Architect
5 8 (1.73%) Master's Degree
6 6 (1.30%) Computer Science Degree
7 5 (1.08%) ISEB
8 3 (0.65%) MBA
8 3 (0.65%) PRINCE2 Certification
8 3 (0.65%) SC Cleared
9 2 (0.43%) AWS Certification
9 2 (0.43%) ISTQB Foundation Certification
9 2 (0.43%) PhD
9 2 (0.43%) PMI Certification
10 1 (0.22%) ITIL Certification
10 1 (0.22%) MCSA
10 1 (0.22%) MCSE
10 1 (0.22%) Postgraduate
10 1 (0.22%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 66 (14.25%) Data Quality
2 23 (4.97%) QA
3 15 (3.24%) GDPR
4 8 (1.73%) PMO
5 1 (0.22%) MiFID
5 1 (0.22%) SLA
System Software
1 11 (2.38%) HDFS
2 4 (0.86%) Docker
3 3 (0.65%) Apache Flume
4 1 (0.22%) Active Directory
4 1 (0.22%) Hyper-V
4 1 (0.22%) Virtual Machines
Systems Management
1 6 (1.30%) Hadoop YARN
2 5 (1.08%) Mesos
2 5 (1.08%) Oozie
3 4 (0.86%) Control-M
3 4 (0.86%) HP Quality Center
4 3 (0.65%) Failover Clustering
4 3 (0.65%) Microsoft Clustering
4 3 (0.65%) Terraform
5 2 (0.43%) Ansible
5 2 (0.43%) Opscode Chef
5 2 (0.43%) Packer
6 1 (0.22%) Grafana
6 1 (0.22%) Kibana
6 1 (0.22%) logstash
6 1 (0.22%) Prometheus
Vendors
1 159 (34.34%) Microsoft
2 71 (15.33%) Oracle
3 63 (13.61%) Tableau
4 44 (9.50%) SAP
5 35 (7.56%) Informatica
6 15 (3.24%) Cognos
6 15 (3.24%) IBM
6 15 (3.24%) Workday
7 14 (3.02%) MicroStrategy
8 13 (2.81%) Talend
9 10 (2.16%) PeopleSoft
10 6 (1.30%) Cloudera
10 6 (1.30%) Hortonworks
11 5 (1.08%) Hyperion
11 5 (1.08%) Tagetik
12 4 (0.86%) Google
12 4 (0.86%) HP
12 4 (0.86%) MapR
12 4 (0.86%) Splunk
13 3 (0.65%) Ab Initio