Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in 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 20 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > London
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 121 107 92
Rank change year-on-year -14 -15 -3
Permanent jobs citing ETL 2037 2191 2885
As % of all permanent IT jobs advertised in London 2.71% 2.93% 3.24%
As % of the Processes & Methodologies category 2.96% 3.23% 3.62%
Number of salaries quoted 1578 1838 2423
London median annual salary £55,000 £60,000 £57,500
Median salary % change year-on-year -8.33% +4.35% -
10th Percentile £40,000 £38,750 £41,250
90th Percentile £85,000 £87,500 £86,250
England median annual salary £50,000 £52,500 £52,000
% change year-on-year -4.76% +0.96% -

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 London with a requirement for process or methodology skills.

All Process and Methodology Skills
London
Permanent vacancies with a requirement for process or methodology skills 68869 67817 79798
As % of all permanent IT jobs advertised in London 91.63% 90.61% 89.56%
Number of salaries quoted 52972 58374 67234
London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% -
10th Percentile £35,000 £33,750 £33,000
90th Percentile £90,000 £88,750 £86,250
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

ETL
Job Vacancy Trend in London

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

Job vacancy trend for ETL in London

ETL
Salary Trend in London

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

Salary trend for ETL in London

ETL
Salary Histogram in London

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

Salary histogram for ETL in London

ETL
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the London region over the 6 months to 20 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
Central London -8 424 £57,500 -4.17% 40
West London +27 97 £47,500 -13.64% 4
South London +4 42 £47,500 -17.39% 3
East London +20 31 £47,500 +8.57% 3
North London +9 15 £28,500 -51.69% 2
ETL
England

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

1 1404 (68.92%) SQL
2 1021 (50.12%) Business Intelligence
3 1015 (49.83%) SQL Server
4 984 (48.31%) Data Warehouse
5 768 (37.70%) SQL Server Integration Services
6 681 (33.43%) Finance
7 657 (32.25%) Agile Software Development
8 627 (30.78%) Microsoft
9 568 (27.88%) SQL Server Reporting Services
10 528 (25.92%) Analytics
11 521 (25.58%) T-SQL
12 485 (23.81%) Oracle
13 440 (21.60%) SQL Server Analysis Services
14 407 (19.98%) Data Modelling
15 394 (19.34%) Big Data
16 360 (17.67%) Python
17 348 (17.08%) Tableau
18 319 (15.66%) Visualisation
19 314 (15.41%) Analytical Skills
20 303 (14.87%) Data Management
21 284 (13.94%) Java
22 282 (13.84%) Degree
23 260 (12.76%) Hadoop
24 251 (12.32%) Power BI
25 250 (12.27%) Relational Database
26 246 (12.08%) Data Quality
27 245 (12.03%) SDLC
28 242 (11.88%) Banking
29 239 (11.73%) Performance Tuning
30 229 (11.24%) .NET

ETL
Co-occurring IT Skills in 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 181 (8.89%) Apache Spark
2 101 (4.96%) SAS
3 85 (4.17%) Apache
4 51 (2.50%) SharePoint
5 46 (2.26%) IIS
6 43 (2.11%) Tomcat
7 36 (1.77%) Confluence
8 28 (1.37%) Elasticsearch
9 24 (1.18%) Apache Airflow
10 17 (0.83%) Apache Pig
11 16 (0.79%) JBoss
11 16 (0.79%) Oracle SOA Suite
12 13 (0.64%) Apache Solr
13 10 (0.49%) CMS
13 10 (0.49%) WordPress
14 8 (0.39%) Gentran
15 7 (0.34%) Sitecore CMS
16 6 (0.29%) WebSphere
17 5 (0.25%) Oracle Workflow
18 4 (0.20%) WebLogic
Applications
1 205 (10.06%) Microsoft Excel
2 48 (2.36%) SPSS
3 37 (1.82%) Microsoft Office
4 19 (0.93%) Microsoft PowerPoint
5 13 (0.64%) MS Visio
6 4 (0.20%) Spreadsheet
7 1 (0.049%) Mathematica
7 1 (0.049%) Weka
Business Applications
1 27 (1.33%) Dynamics CRM
2 23 (1.13%) Cognos Business Intelligence
2 23 (1.13%) Markit EDM
3 11 (0.54%) Salesforce.com CRM
4 9 (0.44%) Dynamics AX
5 7 (0.34%) Cognos TM1
5 7 (0.34%) Dynamics NAV
6 5 (0.25%) Eagle PACE
6 5 (0.25%) HFM
6 5 (0.25%) Oracle Receivables
7 4 (0.20%) Adobe Campaign
7 4 (0.20%) Hyperion Planning
7 4 (0.20%) NetSuite
7 4 (0.20%) Oracle EBS
7 4 (0.20%) Oracle ERP
8 3 (0.15%) Hyperion Enterprise
8 3 (0.15%) Siebel CRM
8 3 (0.15%) Unica
9 2 (0.098%) Oracle Procure-to-Pay
9 2 (0.098%) SAP InfiniteInsight
Cloud Services
1 212 (10.41%) Microsoft Azure
2 197 (9.67%) Amazon AWS
3 86 (4.22%) GitHub
4 66 (3.24%) SaaS
5 59 (2.90%) Google Cloud Platform
6 37 (1.82%) Cloud Computing
7 27 (1.33%) Azure Machine Learning
8 21 (1.03%) Office 365
9 19 (0.93%) IaaS
10 16 (0.79%) Amazon Kinesis
11 14 (0.69%) Amazon S3
12 13 (0.64%) Google Analytics
12 13 (0.64%) PaaS
13 11 (0.54%) Dynamics 365
14 7 (0.34%) Amazon EC2
15 6 (0.29%) Amazon EMR
15 6 (0.29%) Azure Data Factory
15 6 (0.29%) Cortana Intelligence Suite
15 6 (0.29%) Force.com
15 6 (0.29%) Salesforce Service Cloud
Communications & Networking
1 22 (1.08%) Firewall
2 18 (0.88%) Intranet
3 10 (0.49%) FTP
4 9 (0.44%) HTTP
4 9 (0.44%) Kerberos
5 5 (0.25%) LDAP
5 5 (0.25%) TCP/IP
6 4 (0.20%) Network Security
7 3 (0.15%) HTTPS
7 3 (0.15%) Internet
7 3 (0.15%) SNMP
8 2 (0.098%) Broadband
8 2 (0.098%) NAS
8 2 (0.098%) SAN
9 1 (0.049%) GSM
9 1 (0.049%) VoIP
Database & Business Intelligence
1 1015 (49.83%) SQL Server
2 984 (48.31%) Data Warehouse
3 768 (37.70%) SQL Server Integration Services
4 568 (27.88%) SQL Server Reporting Services
5 440 (21.60%) SQL Server Analysis Services
6 394 (19.34%) Big Data
7 260 (12.76%) Hadoop
8 251 (12.32%) Power BI
9 250 (12.27%) Relational Database
10 199 (9.77%) QlikView
11 194 (9.52%) OLAP
12 174 (8.54%) NoSQL
13 161 (7.90%) BusinessObjects
14 157 (7.71%) SQL Server 2012
15 141 (6.92%) SQL Server 2008
16 122 (5.99%) RDBMS
17 105 (5.15%) MySQL
18 94 (4.61%) OLAP Cube
19 92 (4.52%) Oracle Database
20 85 (4.17%) Amazon Redshift
Development Applications
1 145 (7.12%) JIRA
2 131 (6.43%) Talend Open Studio
3 106 (5.20%) TeamCity
4 98 (4.81%) Visual Studio
5 84 (4.12%) Team Foundation Server
6 71 (3.49%) Git (software)
7 56 (2.75%) Subversion
8 46 (2.26%) SQL Server Management Studio (SSMS)
9 39 (1.91%) Jenkins
10 30 (1.47%) Selenium
11 20 (0.98%) RStudio
12 18 (0.88%) HP UFT
12 18 (0.88%) Rational Functional Tester
13 15 (0.74%) InstallShield
13 15 (0.74%) Toad
14 14 (0.69%) Maven
15 11 (0.54%) Octopus Deploy
15 11 (0.54%) VSS/SourceSafe
16 10 (0.49%) Oracle APEX
17 9 (0.44%) Eclipse
General
1 681 (33.43%) Finance
2 242 (11.88%) Banking
3 163 (8.00%) Retail
4 152 (7.46%) Investment Banking
5 142 (6.97%) Marketing
6 139 (6.82%) Retail Banking
7 84 (4.12%) Legal
8 63 (3.09%) Telecoms
9 57 (2.80%) Front Office
10 48 (2.36%) Advertising
10 48 (2.36%) Publishing
11 45 (2.21%) Games
12 44 (2.16%) Manufacturing
13 42 (2.06%) Electronics
14 37 (1.82%) Law
15 36 (1.77%) Pharmaceutical
16 23 (1.13%) Corporate Banking
16 23 (1.13%) Private Banking
17 20 (0.98%) Back Office
18 17 (0.83%) Polish Language
Job Titles
1 909 (44.62%) Developer
2 309 (15.17%) Business Intelligence Developer
3 305 (14.97%) SQL Developer
4 294 (14.43%) Analyst
5 175 (8.59%) Architect
6 154 (7.56%) SSIS Developer
7 149 (7.31%) ETL Developer
8 146 (7.17%) Consultant
9 127 (6.23%) Data Engineer
10 119 (5.84%) Data Warehouse Developer
11 116 (5.69%) Senior Developer
12 112 (5.50%) SSRS Developer
13 103 (5.06%) Data Architect
14 99 (4.86%) SQL BI Developer
15 98 (4.81%) SQL Server Developer
16 94 (4.61%) DBA
17 88 (4.32%) SQL DBA
18 87 (4.27%) Business Developer
19 84 (4.12%) SSAS Developer
20 72 (3.53%) SQL Analyst
Libraries, Frameworks & Software Standards
1 229 (11.24%) .NET
2 140 (6.87%) Web Services
3 125 (6.14%) MDX
4 106 (5.20%) XML
5 91 (4.47%) ASP.NET
6 61 (2.99%) HTML
7 50 (2.45%) Kafka
7 50 (2.45%) Oracle GoldenGate
8 43 (2.11%) CSS
8 43 (2.11%) JSON
9 34 (1.67%) ASP.NET MVC
9 34 (1.67%) Pandas
10 32 (1.57%) AngularJS
11 31 (1.52%) .NET Framework
12 30 (1.47%) jQuery
13 28 (1.37%) J2EE
13 28 (1.37%) Node.js
14 26 (1.28%) NumPy
14 26 (1.28%) SOAP
15 25 (1.23%) D3.js
Miscellaneous
1 314 (15.41%) Analytical Skills
2 163 (8.00%) Computer Science
3 125 (6.14%) Management Information System
4 82 (4.03%) Data Structures
5 54 (2.65%) Replication
6 40 (1.96%) Client/Server
6 40 (1.96%) Enterprise Software
6 40 (1.96%) Life Science
7 39 (1.91%) Fintech
8 32 (1.57%) Credit Risk
8 32 (1.57%) Greenfield Project
9 29 (1.42%) User Experience
10 28 (1.37%) Clustering
11 23 (1.13%) N-Tier
12 22 (1.08%) Algorithms
13 18 (0.88%) Reference Data
14 15 (0.74%) Equities
15 14 (0.69%) Virtual Team
16 12 (0.59%) NHS
17 11 (0.54%) Online Gambling
Operating Systems
1 150 (7.36%) Linux
2 119 (5.84%) Unix
3 85 (4.17%) Windows
4 26 (1.28%) Windows Server 2012
5 25 (1.23%) Windows Server
6 11 (0.54%) Windows 7
7 8 (0.39%) Android
8 7 (0.34%) Apple iOS
9 6 (0.29%) Ubuntu
10 5 (0.25%) Windows Server 2008
11 2 (0.098%) Mesosphere
11 2 (0.098%) Oracle Linux
Processes & Methodologies
1 1021 (50.12%) Business Intelligence
2 657 (32.25%) Agile Software Development
3 528 (25.92%) Analytics
4 407 (19.98%) Data Modelling
5 319 (15.66%) Visualisation
6 303 (14.87%) Data Management
7 245 (12.03%) SDLC
8 239 (11.73%) Performance Tuning
9 190 (9.33%) Kimball Methodology
10 185 (9.08%) Data Integration
11 175 (8.59%) Scrum
12 164 (8.05%) Data Visualisation
13 161 (7.90%) Asset Management
14 159 (7.81%) Data Architecture
15 152 (7.46%) Data Analysis
16 145 (7.12%) Dimensional Modelling
17 142 (6.97%) Data Analytics
17 142 (6.97%) ETL Development
18 139 (6.82%) DevOps
19 120 (5.89%) Migration
Programming Languages
1 1404 (68.92%) SQL
2 521 (25.58%) T-SQL
3 360 (17.67%) Python
4 284 (13.94%) Java
5 212 (10.41%) C#
6 165 (8.10%) PL/SQL
7 131 (6.43%) R
8 120 (5.89%) JavaScript
9 103 (5.06%) Scala
10 95 (4.66%) PowerShell
11 62 (3.04%) VBA
12 61 (2.99%) Shell Script
13 51 (2.50%) PHP
14 40 (1.96%) Data Analysis Expressions (DAX)
15 31 (1.52%) VB
16 19 (0.93%) Bash Shell
17 17 (0.83%) C
18 16 (0.79%) VB.NET
18 16 (0.79%) VBScript
19 15 (0.74%) Perl
Qualifications
1 282 (13.84%) Degree
2 99 (4.86%) Computer Science Degree
3 41 (2.01%) Microsoft Certification
4 28 (1.37%) Master's Degree
5 15 (0.74%) Security Cleared
6 11 (0.54%) MCSE
6 11 (0.54%) Numerate Degree
7 9 (0.44%) MBA
7 9 (0.44%) SC Cleared
8 8 (0.39%) ISEB
8 8 (0.39%) ITIL Foundation Certificate
8 8 (0.39%) PMI Certification
9 7 (0.34%) MCITP
9 7 (0.34%) PhD
10 6 (0.29%) Oracle Certification
11 5 (0.25%) CEH
11 5 (0.25%) CISSP
11 5 (0.25%) GCIH
11 5 (0.25%) ISTQB
11 5 (0.25%) OSCP
Quality Assurance & Compliance
1 246 (12.08%) Data Quality
2 121 (5.94%) QA
3 36 (1.77%) SLA
4 22 (1.08%) GDPR
5 18 (0.88%) GCP
6 12 (0.59%) MiFID
7 11 (0.54%) PMO
8 9 (0.44%) CRD IV
8 9 (0.44%) EMIR
9 5 (0.25%) Actionable Recommendations
9 5 (0.25%) GPG13
9 5 (0.25%) ISO/IEC 27001
10 4 (0.20%) Solvency II
11 3 (0.15%) FATCA
11 3 (0.15%) IFRS
11 3 (0.15%) IFRS 9
12 2 (0.098%) COBIT
System Software
1 52 (2.55%) HDFS
2 28 (1.37%) Active Directory
3 14 (0.69%) Apache Flume
4 13 (0.64%) Docker
5 5 (0.25%) Snort
6 4 (0.20%) Apache ZooKeeper
6 4 (0.20%) Microsoft Virtual Server
6 4 (0.20%) Virtual Servers
6 4 (0.20%) VMware Infrastructure
7 2 (0.098%) MapR-FS
8 1 (0.049%) Cronacle
8 1 (0.049%) Virtual Machines
Systems Management
1 23 (1.13%) Oracle Enterprise Manager
2 21 (1.03%) Oozie
3 15 (0.74%) SCCM
4 13 (0.64%) HP Quality Center
5 10 (0.49%) Control-M
6 7 (0.34%) Ansible
7 6 (0.29%) CA Single Sign-On
7 6 (0.29%) Hadoop YARN
8 5 (0.25%) Suricata
9 4 (0.20%) Ambari
9 4 (0.20%) Failover Clustering
9 4 (0.20%) Opscode Chef
9 4 (0.20%) Puppet
9 4 (0.20%) Terraform
10 3 (0.15%) Fluentd
10 3 (0.15%) QRadar
10 3 (0.15%) Rundeck
11 2 (0.098%) Docker Swarm
11 2 (0.098%) Kubernetes
11 2 (0.098%) yum
Vendors
1 627 (30.78%) Microsoft
2 485 (23.81%) Oracle
3 348 (17.08%) Tableau
4 198 (9.72%) Informatica
5 131 (6.43%) SAP
5 131 (6.43%) Talend
6 100 (4.91%) MicroStrategy
7 84 (4.12%) Alteryx
8 83 (4.07%) Cognos
9 73 (3.58%) Teradata
10 68 (3.34%) Google
11 64 (3.14%) Salesforce.com
12 53 (2.60%) Cloudera
13 43 (2.11%) IBM
14 36 (1.77%) Netezza
15 31 (1.52%) Ab Initio
16 26 (1.28%) MapR
17 25 (1.23%) Hortonworks
17 25 (1.23%) Sybase
18 22 (1.08%) Adobe