Period
to 20 February 2018

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 February 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > London
6 months to
20 Feb 2018
Same period 2017 Same period 2016
Rank 116 115 91
Rank change year-on-year -1 -24 +3
Permanent jobs citing ETL 1,960 1,918 2,898
As % of all permanent IT jobs advertised in London 2.78% 2.75% 3.40%
As % of the Processes & Methodologies category 3.04% 3.04% 3.79%
Number of salaries quoted 1,541 1,612 2,408
London median annual salary £58,500 £60,000 £57,500
Median salary % change year-on-year -2.50% +4.35% -
10th Percentile £40,000 £38,250 £42,250
90th Percentile £87,500 £85,000 £85,000
England median annual salary £52,500 £52,500 £51,500
% change year-on-year - +1.94% -1.90%

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 64,398 63,032 76,541
As % of all permanent IT jobs advertised in London 91.44% 90.51% 89.78%
Number of salaries quoted 52,630 53,398 64,882
London median annual salary £60,000 £60,000 £55,000
Median salary % change year-on-year - +9.09% -
10th Percentile £36,250 £33,750 £33,750
90th Percentile £92,500 £90,000 £87,475
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 February 2018.

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 February 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
Central London -10 480 £60,000 - 82
West London +22 99 £50,000 -9.09% 31
South London +15 47 £52,500 -17.97% 4
East London +6 16 £45,000 -2.70% 12
North London +5 15 £42,500 -26.72%
ETL
England

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

1 1,324 (67.55%) SQL
2 1,047 (53.42%) Business Intelligence
3 987 (50.36%) Data Warehouse
4 923 (47.09%) SQL Server
5 719 (36.68%) SQL Server Integration Services
6 637 (32.50%) Analytics
7 572 (29.18%) Agile Software Development
8 565 (28.83%) Finance
9 546 (27.86%) Microsoft
10 508 (25.92%) SQL Server Reporting Services
11 493 (25.15%) T-SQL
12 418 (21.33%) Data Modelling
13 413 (21.07%) SQL Server Analysis Services
14 406 (20.71%) Big Data
15 395 (20.15%) Oracle
16 385 (19.64%) Python
17 324 (16.53%) Tableau
18 308 (15.71%) Java
19 306 (15.61%) Hadoop
20 305 (15.56%) Data Management
21 268 (13.67%) Analytical Skills
22 263 (13.42%) Degree
23 259 (13.21%) Amazon AWS
24 255 (13.01%) Visualisation
25 252 (12.86%) Data Quality
26 245 (12.50%) Power BI
27 236 (12.04%) Apache Spark
28 231 (11.79%) Relational Database
29 221 (11.28%) Microsoft Azure
30 214 (10.92%) Informatica

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 236 (12.04%) Apache Spark
2 117 (5.97%) SAS
3 114 (5.82%) Apache
4 62 (3.16%) Elasticsearch
5 45 (2.30%) Tomcat
6 38 (1.94%) Apache Solr
6 38 (1.94%) IIS
7 28 (1.43%) Confluence
8 25 (1.28%) SharePoint
9 20 (1.02%) JBoss
10 18 (0.92%) Apache Airflow
11 17 (0.87%) Apache Pig
12 10 (0.51%) WebSphere
13 7 (0.36%) Oracle SOA Suite
14 6 (0.31%) Luigi
15 5 (0.26%) Gentran
15 5 (0.26%) Oracle Workflow
16 4 (0.20%) BizTalk Server
16 4 (0.20%) Tuxedo
16 4 (0.20%) WebLogic
Applications
1 134 (6.84%) Microsoft Excel
2 54 (2.76%) SPSS
3 30 (1.53%) Microsoft Office
4 14 (0.71%) Microsoft PowerPoint
5 12 (0.61%) MS Visio
6 3 (0.15%) Chatbot
6 3 (0.15%) Spreadsheet
7 2 (0.10%) Microsoft Project
8 1 (0.051%) Weka
Business Applications
1 30 (1.53%) Dynamics CRM
2 27 (1.38%) Markit EDM
3 18 (0.92%) NetSuite
4 16 (0.82%) Elite 3E
5 13 (0.66%) Cognos TM1
5 13 (0.66%) Eagle PACE
6 10 (0.51%) Cognos Business Intelligence
7 9 (0.46%) Dynamics AX
8 7 (0.36%) Maximo
8 7 (0.36%) Salesforce.com CRM
9 6 (0.31%) Relativity
10 5 (0.26%) Oracle Receivables
11 4 (0.20%) CSG Singleview
11 4 (0.20%) Dynamics NAV
11 4 (0.20%) Oracle EBS
11 4 (0.20%) Oracle ERP
11 4 (0.20%) PeopleSoft CRM
12 2 (0.10%) Cognos Planning
12 2 (0.10%) SAP ERP
12 2 (0.10%) SAP InfiniteInsight
Cloud Services
1 259 (13.21%) Amazon AWS
2 221 (11.28%) Microsoft Azure
3 80 (4.08%) Google Cloud Platform
4 52 (2.65%) SaaS
5 40 (2.04%) Cloud Computing
6 32 (1.63%) Amazon S3
7 28 (1.43%) Amazon Kinesis
8 26 (1.33%) Azure Machine Learning
8 26 (1.33%) GitHub
9 19 (0.97%) Office 365
10 18 (0.92%) Amazon EMR
11 16 (0.82%) PaaS
12 15 (0.77%) IaaS
13 14 (0.71%) AWS Lambda
13 14 (0.71%) Serverless
14 11 (0.56%) Amazon EC2
15 10 (0.51%) Azure Data Factory
16 8 (0.41%) Cortana Intelligence Suite
16 8 (0.41%) Dynamics 365
16 8 (0.41%) Google Analytics
Communications & Networking
1 31 (1.58%) Firewall
2 16 (0.82%) HTTP
3 10 (0.51%) Kerberos
4 4 (0.20%) Ethernet
4 4 (0.20%) FTP
4 4 (0.20%) Internet
4 4 (0.20%) Network Security
4 4 (0.20%) TCP/IP
4 4 (0.20%) Wireless
5 3 (0.15%) HTTPS
5 3 (0.15%) SMS
5 3 (0.15%) SNMP
6 2 (0.10%) 3G
6 2 (0.10%) 4G
6 2 (0.10%) Broadband
6 2 (0.10%) Cisco ASA
6 2 (0.10%) LAN
6 2 (0.10%) SSL
6 2 (0.10%) VPN
6 2 (0.10%) WAN
Database & Business Intelligence
1 987 (50.36%) Data Warehouse
2 923 (47.09%) SQL Server
3 719 (36.68%) SQL Server Integration Services
4 508 (25.92%) SQL Server Reporting Services
5 413 (21.07%) SQL Server Analysis Services
6 406 (20.71%) Big Data
7 306 (15.61%) Hadoop
8 245 (12.50%) Power BI
9 231 (11.79%) Relational Database
10 167 (8.52%) NoSQL
11 160 (8.16%) QlikView
12 135 (6.89%) RDBMS
13 128 (6.53%) OLAP
14 120 (6.12%) BusinessObjects
15 119 (6.07%) Amazon Redshift
15 119 (6.07%) Apache Hive
16 114 (5.82%) MySQL
17 103 (5.26%) SQL Server 2012
18 98 (5.00%) SQL Server 2008
19 92 (4.69%) HBase
Development Applications
1 89 (4.54%) JIRA
2 59 (3.01%) Team Foundation Server
3 53 (2.70%) Git (software)
4 42 (2.14%) TeamCity
4 42 (2.14%) Visual Studio
5 40 (2.04%) Subversion
6 37 (1.89%) SQL Server Management Studio (SSMS)
7 31 (1.58%) Jenkins
8 29 (1.48%) Selenium
9 15 (0.77%) InstallShield
9 15 (0.77%) Toad
10 14 (0.71%) VSS/SourceSafe
11 13 (0.66%) Cucumber
11 13 (0.66%) Octopus Deploy
12 12 (0.61%) Oracle APEX
13 11 (0.56%) ERwin
14 10 (0.51%) HP UFT
14 10 (0.51%) Rational Functional Tester
15 9 (0.46%) Eclipse
16 8 (0.41%) RStudio
General
1 565 (28.83%) Finance
2 152 (7.76%) Retail
3 136 (6.94%) Banking
4 117 (5.97%) Marketing
5 85 (4.34%) Advertising
6 68 (3.47%) Investment Banking
7 63 (3.21%) Retail Banking
8 52 (2.65%) Legal
9 47 (2.40%) Front Office
10 45 (2.30%) Games
11 38 (1.94%) Law
11 38 (1.94%) Pharmaceutical
12 35 (1.79%) Publishing
12 35 (1.79%) Telecoms
13 28 (1.43%) Corporate Banking
14 26 (1.33%) Private Banking
15 14 (0.71%) Billing
15 14 (0.71%) Polish Language
16 12 (0.61%) Back Office
17 10 (0.51%) Manufacturing
Job Titles
1 774 (39.49%) Developer
2 296 (15.10%) Business Intelligence Developer
3 289 (14.74%) Analyst
4 245 (12.50%) SQL Developer
5 188 (9.59%) Architect
6 179 (9.13%) Data Engineer
7 165 (8.42%) Consultant
8 150 (7.65%) SSIS Developer
9 142 (7.24%) ETL Developer
10 130 (6.63%) Data Architect
11 109 (5.56%) Senior Developer
12 96 (4.90%) SSRS Developer
13 84 (4.29%) Business Analyst
13 84 (4.29%) Data Warehouse Developer
14 83 (4.23%) SQL BI Developer
15 80 (4.08%) Business Developer
16 72 (3.67%) DBA
17 71 (3.62%) SSAS Developer
18 70 (3.57%) SQL Analyst
19 69 (3.52%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 187 (9.54%) .NET
2 143 (7.30%) Web Services
3 103 (5.26%) XML
4 98 (5.00%) Kafka
5 75 (3.83%) MDX
6 64 (3.27%) HTML
7 52 (2.65%) JSON
8 48 (2.45%) AngularJS
9 42 (2.14%) React
10 40 (2.04%) ASP.NET
11 39 (1.99%) J2EE
12 34 (1.73%) Node.js
13 33 (1.68%) Pandas
14 30 (1.53%) Middleware
14 30 (1.53%) NumPy
15 29 (1.48%) Oracle GoldenGate
16 27 (1.38%) Backbone.js
16 27 (1.38%) CSS
17 26 (1.33%) Angular 2
17 26 (1.33%) SOAP
Miscellaneous
1 268 (13.67%) Analytical Skills
2 146 (7.45%) Computer Science
3 92 (4.69%) Management Information System
4 68 (3.47%) Data Structures
5 55 (2.81%) Algorithms
6 54 (2.76%) Fintech
7 41 (2.09%) Greenfield Project
8 40 (2.04%) Replication
8 40 (2.04%) User Experience
9 39 (1.99%) Life Science
10 30 (1.53%) Client/Server
11 28 (1.43%) Enterprise Software
12 27 (1.38%) Credit Risk
12 27 (1.38%) N-Tier
13 26 (1.33%) Virtual Team
14 17 (0.87%) Equities
15 14 (0.71%) Hedge funds
15 14 (0.71%) PMI
16 13 (0.66%) Clustering
16 13 (0.66%) Reference Data
Operating Systems
1 191 (9.74%) Linux
2 109 (5.56%) Windows
3 108 (5.51%) Unix
4 36 (1.84%) Windows Server
4 36 (1.84%) Windows Server 2012
5 15 (0.77%) Windows 7
6 12 (0.61%) Windows Server 2008
7 8 (0.41%) CentOS
8 6 (0.31%) Oracle Linux
8 6 (0.31%) Solaris
9 4 (0.20%) Ubuntu
10 3 (0.15%) Red Hat Enterprise Linux
11 2 (0.10%) AIX
11 2 (0.10%) Amazon Linux
11 2 (0.10%) Apple iOS
11 2 (0.10%) HPUX
11 2 (0.10%) Mesosphere
12 1 (0.051%) VMS
Processes & Methodologies
1 1,047 (53.42%) Business Intelligence
2 637 (32.50%) Analytics
3 572 (29.18%) Agile Software Development
4 418 (21.33%) Data Modelling
5 305 (15.56%) Data Management
6 255 (13.01%) Visualisation
7 210 (10.71%) Data Integration
8 185 (9.44%) Data Science
9 184 (9.39%) Data Architecture
10 183 (9.34%) Performance Tuning
11 181 (9.23%) SDLC
12 174 (8.88%) Data Governance
12 174 (8.88%) Kimball Methodology
13 167 (8.52%) Data Analytics
14 159 (8.11%) Data Visualisation
15 155 (7.91%) Data Analysis
16 151 (7.70%) Scrum
17 142 (7.24%) Machine Learning
18 123 (6.28%) Mentoring
19 120 (6.12%) ETL Development
Programming Languages
1 1,324 (67.55%) SQL
2 493 (25.15%) T-SQL
3 385 (19.64%) Python
4 308 (15.71%) Java
5 177 (9.03%) C#
6 140 (7.14%) R
7 121 (6.17%) JavaScript
8 120 (6.12%) Scala
9 113 (5.77%) PL/SQL
10 88 (4.49%) PowerShell
11 65 (3.32%) PHP
12 49 (2.50%) Data Analysis Expressions (DAX)
13 43 (2.19%) Shell Script
14 42 (2.14%) VBA
15 39 (1.99%) Bash Shell
16 38 (1.94%) Perl
17 28 (1.43%) VB
18 22 (1.12%) Ruby
19 21 (1.07%) VBScript
20 13 (0.66%) C
Qualifications
1 263 (13.42%) Degree
2 80 (4.08%) Computer Science Degree
3 31 (1.58%) Master's Degree
4 23 (1.17%) Security Cleared
5 20 (1.02%) ISEB
6 19 (0.97%) ITIL Certification
7 18 (0.92%) Microsoft Certification
8 17 (0.87%) PhD
9 14 (0.71%) ISTQB
9 14 (0.71%) PMI Certification
10 11 (0.56%) MBA
11 9 (0.46%) CEH
11 9 (0.46%) CISSP
11 9 (0.46%) GCIH
11 9 (0.46%) OSCP
12 7 (0.36%) Numerate Degree
13 6 (0.31%) PRINCE2 Certification
14 5 (0.26%) MCSE
15 4 (0.20%) MCSD
15 4 (0.20%) Microsoft Certified Architect
Quality Assurance & Compliance
1 252 (12.86%) Data Quality
2 136 (6.94%) QA
3 51 (2.60%) GDPR
4 36 (1.84%) SLA
5 18 (0.92%) GCP
6 13 (0.66%) EMIR
6 13 (0.66%) MiFID
7 11 (0.56%) CRD IV
8 9 (0.46%) GPG13
8 9 (0.46%) ISO/IEC 27001
9 8 (0.41%) PMO
10 7 (0.36%) Actionable Recommendations
11 6 (0.31%) COBIT
12 5 (0.26%) Sarbanes-Oxley
13 4 (0.20%) Solvency II
14 2 (0.10%) Dodd-Frank
14 2 (0.10%) HL7
14 2 (0.10%) IFRS
14 2 (0.10%) IFRS 9
15 1 (0.051%) HIPAA
System Software
1 56 (2.86%) HDFS
2 42 (2.14%) Active Directory
3 27 (1.38%) Apache Flume
4 23 (1.17%) Docker
5 9 (0.46%) Apache ZooKeeper
5 9 (0.46%) Snort
6 6 (0.31%) Virtual Machines
7 5 (0.26%) VMware Infrastructure
8 3 (0.15%) Hyper-V
9 2 (0.10%) MapR-FS
10 1 (0.051%) Microsoft Virtual Server
10 1 (0.051%) Virtual Servers
Systems Management
1 30 (1.53%) Oracle Enterprise Manager
2 26 (1.33%) Hadoop YARN
3 20 (1.02%) Terraform
4 16 (0.82%) Oozie
5 15 (0.77%) SCCM
5 15 (0.77%) Single Sign-On
6 11 (0.56%) Ansible
6 11 (0.56%) Mesos
7 9 (0.46%) Suricata
8 8 (0.41%) Ambari
8 8 (0.41%) Puppet
9 7 (0.36%) Opscode Chef
9 7 (0.36%) Oracle Identity Manager
10 6 (0.31%) Failover Clustering
11 5 (0.26%) CA Single Sign-On
11 5 (0.26%) Kubernetes
12 4 (0.20%) Packer
12 4 (0.20%) Rundeck
13 3 (0.15%) Fluentd
13 3 (0.15%) QRadar
Vendors
1 546 (27.86%) Microsoft
2 395 (20.15%) Oracle
3 324 (16.53%) Tableau
4 214 (10.92%) Informatica
5 165 (8.42%) Talend
6 107 (5.46%) Google
7 104 (5.31%) Alteryx
8 103 (5.26%) SAP
9 84 (4.29%) Cloudera
10 80 (4.08%) Teradata
11 77 (3.93%) Cognos
12 76 (3.88%) MicroStrategy
13 68 (3.47%) Salesforce.com
14 57 (2.91%) Netezza
15 48 (2.45%) IBM
16 47 (2.40%) Ab Initio
17 33 (1.68%) Hortonworks
18 22 (1.12%) Twitter
19 21 (1.07%) MapR
20 20 (1.02%) Vertica