Period
to 22 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 22 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > London
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 123 105 92
Rank change year-on-year -18 -13 -3
Permanent jobs citing ETL 2043 2218 2855
As % of all permanent IT jobs advertised in London 2.71% 2.91% 3.25%
As % of the Processes & Methodologies category 2.96% 3.21% 3.63%
Number of salaries quoted 1587 1859 2395
London median annual salary £56,000 £60,000 £57,500
Median salary % change year-on-year -6.67% +4.35% -
10th Percentile £40,000 £38,000 £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 69031 69078 78753
As % of all permanent IT jobs advertised in London 91.60% 90.65% 89.58%
Number of salaries quoted 53165 59470 66332
London median annual salary £60,000 £57,604 £55,000
Median salary % change year-on-year +4.16% +4.73% -
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 22 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 22 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 -4 432 £57,500 -4.17% 41
West London +17 96 £48,000 -12.73% 5
South London -2 41 £47,500 -17.39% 2
East London +11 30 £47,500 +8.57% 3
North London +11 14 £28,500 -51.69% 3
ETL
England

For the 6 months to 22 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 1408 (68.92%) SQL
2 1028 (50.32%) Business Intelligence
3 1014 (49.63%) SQL Server
4 991 (48.51%) Data Warehouse
5 767 (37.54%) SQL Server Integration Services
6 679 (33.24%) Finance
7 653 (31.96%) Agile Software Development
8 623 (30.49%) Microsoft
9 566 (27.70%) SQL Server Reporting Services
10 535 (26.19%) Analytics
11 524 (25.65%) T-SQL
12 479 (23.45%) Oracle
13 441 (21.59%) SQL Server Analysis Services
14 407 (19.92%) Data Modelling
15 397 (19.43%) Big Data
16 363 (17.77%) Python
17 347 (16.98%) Tableau
18 320 (15.66%) Visualisation
19 311 (15.22%) Analytical Skills
20 306 (14.98%) Data Management
21 283 (13.85%) Java
21 283 (13.85%) Degree
22 265 (12.97%) Hadoop
23 250 (12.24%) Relational Database
23 250 (12.24%) Power BI
24 247 (12.09%) Data Quality
25 242 (11.85%) SDLC
26 236 (11.55%) Performance Tuning
26 236 (11.55%) Banking
27 228 (11.16%) .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 186 (9.10%) Apache Spark
2 104 (5.09%) SAS
3 87 (4.26%) Apache
4 51 (2.50%) SharePoint
5 46 (2.25%) IIS
6 43 (2.10%) Tomcat
7 36 (1.76%) Confluence
8 28 (1.37%) Elasticsearch
9 24 (1.17%) Apache Airflow
10 17 (0.83%) Apache Pig
11 16 (0.78%) JBoss
11 16 (0.78%) Oracle SOA Suite
12 14 (0.69%) 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 4 (0.20%) Oracle Workflow
17 4 (0.20%) WebLogic
Applications
1 202 (9.89%) Microsoft Excel
2 50 (2.45%) SPSS
3 38 (1.86%) Microsoft Office
4 20 (0.98%) 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 26 (1.27%) Dynamics CRM
2 23 (1.13%) Cognos Business Intelligence
2 23 (1.13%) Markit EDM
3 9 (0.44%) Dynamics AX
3 9 (0.44%) Salesforce.com CRM
4 7 (0.34%) Cognos TM1
4 7 (0.34%) Dynamics NAV
5 5 (0.24%) Eagle PACE
5 5 (0.24%) Oracle EBS
5 5 (0.24%) Oracle ERP
6 4 (0.20%) Adobe Campaign
6 4 (0.20%) HFM
6 4 (0.20%) Oracle Receivables
7 3 (0.15%) Hyperion Planning
7 3 (0.15%) NetSuite
7 3 (0.15%) Siebel CRM
7 3 (0.15%) Unica
8 2 (0.098%) Eloqua
8 2 (0.098%) FastStats
8 2 (0.098%) SAP BPC
Cloud Services
1 213 (10.43%) Microsoft Azure
2 201 (9.84%) Amazon AWS
3 82 (4.01%) GitHub
4 65 (3.18%) SaaS
5 60 (2.94%) Google Cloud Platform
6 37 (1.81%) Cloud Computing
7 27 (1.32%) Azure Machine Learning
8 21 (1.03%) Office 365
9 19 (0.93%) IaaS
10 17 (0.83%) 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%) Cortana Intelligence Suite
15 6 (0.29%) Force.com
15 6 (0.29%) iPaaS
15 6 (0.29%) Salesforce Service Cloud
Communications & Networking
1 22 (1.08%) Firewall
2 17 (0.83%) Intranet
3 10 (0.49%) FTP
4 9 (0.44%) HTTP
4 9 (0.44%) Kerberos
5 5 (0.24%) LDAP
5 5 (0.24%) 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 1014 (49.63%) SQL Server
2 991 (48.51%) Data Warehouse
3 767 (37.54%) SQL Server Integration Services
4 566 (27.70%) SQL Server Reporting Services
5 441 (21.59%) SQL Server Analysis Services
6 397 (19.43%) Big Data
7 265 (12.97%) Hadoop
8 250 (12.24%) Power BI
8 250 (12.24%) Relational Database
9 200 (9.79%) QlikView
10 193 (9.45%) OLAP
11 177 (8.66%) NoSQL
12 162 (7.93%) BusinessObjects
13 157 (7.68%) SQL Server 2012
14 141 (6.90%) SQL Server 2008
15 123 (6.02%) RDBMS
16 106 (5.19%) MySQL
17 94 (4.60%) OLAP Cube
18 93 (4.55%) Oracle Database
19 87 (4.26%) Amazon Redshift
Development Applications
1 141 (6.90%) JIRA
2 132 (6.46%) Talend Open Studio
3 102 (4.99%) TeamCity
4 99 (4.85%) Visual Studio
5 84 (4.11%) Team Foundation Server
6 72 (3.52%) Git (software)
7 57 (2.79%) Subversion
8 48 (2.35%) SQL Server Management Studio (SSMS)
9 40 (1.96%) Jenkins
10 30 (1.47%) Selenium
11 21 (1.03%) RStudio
12 18 (0.88%) HP UFT
12 18 (0.88%) Rational Functional Tester
13 15 (0.73%) InstallShield
13 15 (0.73%) 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 679 (33.24%) Finance
2 236 (11.55%) Banking
3 162 (7.93%) Retail
4 148 (7.24%) Investment Banking
5 144 (7.05%) Marketing
6 137 (6.71%) Retail Banking
7 84 (4.11%) Legal
8 63 (3.08%) Telecoms
9 57 (2.79%) Front Office
10 50 (2.45%) Publishing
11 47 (2.30%) Advertising
12 45 (2.20%) Games
13 44 (2.15%) Manufacturing
14 42 (2.06%) Electronics
15 37 (1.81%) Law
16 35 (1.71%) Pharmaceutical
17 23 (1.13%) Corporate Banking
17 23 (1.13%) Private Banking
18 20 (0.98%) Back Office
19 17 (0.83%) Polish Language
Job Titles
1 908 (44.44%) Developer
2 309 (15.12%) Business Intelligence Developer
3 308 (15.08%) SQL Developer
4 294 (14.39%) Analyst
5 175 (8.57%) Architect
6 155 (7.59%) SSIS Developer
7 147 (7.20%) ETL Developer
8 146 (7.15%) Consultant
9 129 (6.31%) Data Engineer
10 120 (5.87%) Data Warehouse Developer
11 116 (5.68%) Senior Developer
12 113 (5.53%) SSRS Developer
13 104 (5.09%) Data Architect
14 101 (4.94%) SQL BI Developer
15 100 (4.89%) SQL Server Developer
16 94 (4.60%) DBA
17 88 (4.31%) SQL DBA
18 86 (4.21%) Business Developer
18 86 (4.21%) SSAS Developer
19 72 (3.52%) SQL Analyst
Libraries, Frameworks & Software Standards
1 228 (11.16%) .NET
2 138 (6.75%) Web Services
3 124 (6.07%) MDX
4 106 (5.19%) XML
5 91 (4.45%) ASP.NET
6 60 (2.94%) HTML
7 52 (2.55%) Kafka
8 50 (2.45%) Oracle GoldenGate
9 43 (2.10%) JSON
10 42 (2.06%) CSS
11 34 (1.66%) Pandas
12 33 (1.62%) ASP.NET MVC
13 32 (1.57%) AngularJS
14 30 (1.47%) .NET Framework
14 30 (1.47%) jQuery
15 28 (1.37%) J2EE
15 28 (1.37%) Node.js
16 26 (1.27%) D3.js
16 26 (1.27%) NumPy
17 25 (1.22%) SOAP
Miscellaneous
1 311 (15.22%) Analytical Skills
2 165 (8.08%) Computer Science
3 124 (6.07%) Management Information System
4 80 (3.92%) Data Structures
5 54 (2.64%) Replication
6 40 (1.96%) Client/Server
6 40 (1.96%) Enterprise Software
7 39 (1.91%) Fintech
7 39 (1.91%) Life Science
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%) Algorithms
11 23 (1.13%) N-Tier
12 17 (0.83%) Reference Data
13 15 (0.73%) Equities
14 14 (0.69%) Virtual Team
15 12 (0.59%) NHS
16 11 (0.54%) Blog
Operating Systems
1 149 (7.29%) Linux
2 119 (5.82%) Unix
3 85 (4.16%) Windows
4 26 (1.27%) Windows Server 2012
5 25 (1.22%) Windows Server
6 11 (0.54%) Windows 7
7 7 (0.34%) Android
8 6 (0.29%) Apple iOS
8 6 (0.29%) Ubuntu
9 5 (0.24%) Windows Server 2008
10 2 (0.098%) Mesosphere
10 2 (0.098%) Oracle Linux
Processes & Methodologies
1 1028 (50.32%) Business Intelligence
2 653 (31.96%) Agile Software Development
3 535 (26.19%) Analytics
4 407 (19.92%) Data Modelling
5 320 (15.66%) Visualisation
6 306 (14.98%) Data Management
7 242 (11.85%) SDLC
8 236 (11.55%) Performance Tuning
9 187 (9.15%) Kimball Methodology
10 186 (9.10%) Data Integration
11 174 (8.52%) Scrum
12 165 (8.08%) Data Visualisation
13 164 (8.03%) Data Architecture
14 159 (7.78%) Asset Management
15 154 (7.54%) Data Analysis
16 145 (7.10%) Data Analytics
16 145 (7.10%) Dimensional Modelling
17 142 (6.95%) ETL Development
18 138 (6.75%) DevOps
19 120 (5.87%) Data Governance
Programming Languages
1 1408 (68.92%) SQL
2 524 (25.65%) T-SQL
3 363 (17.77%) Python
4 283 (13.85%) Java
5 210 (10.28%) C#
6 164 (8.03%) PL/SQL
7 134 (6.56%) R
8 119 (5.82%) JavaScript
9 105 (5.14%) Scala
10 94 (4.60%) PowerShell
11 62 (3.03%) VBA
12 61 (2.99%) Shell Script
13 51 (2.50%) PHP
14 41 (2.01%) Data Analysis Expressions (DAX)
15 31 (1.52%) VB
16 19 (0.93%) Bash Shell
17 17 (0.83%) C
17 17 (0.83%) VB.NET
18 16 (0.78%) VBScript
19 15 (0.73%) Perl
Qualifications
1 283 (13.85%) Degree
2 99 (4.85%) Computer Science Degree
3 41 (2.01%) Microsoft Certification
4 28 (1.37%) Master's Degree
5 15 (0.73%) Security Cleared
6 11 (0.54%) MCSE
6 11 (0.54%) Numerate Degree
6 11 (0.54%) PMI Certification
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%) PhD
9 7 (0.34%) MCITP
10 6 (0.29%) ITIL Certification
10 6 (0.29%) Oracle Certification
11 5 (0.24%) CEH
11 5 (0.24%) CISSP
11 5 (0.24%) GCIH
11 5 (0.24%) ISTQB
Quality Assurance & Compliance
1 247 (12.09%) Data Quality
2 121 (5.92%) QA
3 36 (1.76%) SLA
4 22 (1.08%) GDPR
5 18 (0.88%) GCP
6 11 (0.54%) MiFID
6 11 (0.54%) PMO
7 9 (0.44%) CRD IV
7 9 (0.44%) EMIR
8 5 (0.24%) Actionable Recommendations
8 5 (0.24%) GPG13
8 5 (0.24%) ISO/IEC 27001
9 4 (0.20%) Solvency II
10 3 (0.15%) FATCA
10 3 (0.15%) IFRS
10 3 (0.15%) IFRS 9
11 2 (0.098%) COBIT
System Software
1 53 (2.59%) HDFS
2 28 (1.37%) Active Directory
3 15 (0.73%) Apache Flume
4 13 (0.64%) Docker
5 5 (0.24%) 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.73%) 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.24%) 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 623 (30.49%) Microsoft
2 479 (23.45%) Oracle
3 347 (16.98%) Tableau
4 197 (9.64%) Informatica
5 134 (6.56%) SAP
6 132 (6.46%) Talend
7 98 (4.80%) MicroStrategy
8 84 (4.11%) Alteryx
8 84 (4.11%) Cognos
9 75 (3.67%) Teradata
10 71 (3.48%) Google
11 62 (3.03%) Salesforce.com
12 57 (2.79%) Cloudera
13 42 (2.06%) IBM
14 37 (1.81%) Netezza
15 32 (1.57%) Ab Initio
16 27 (1.32%) MapR
17 26 (1.27%) Hortonworks
18 25 (1.22%) Sybase
19 22 (1.08%) Adobe