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

Extract, Transform and Load (ETL)
England > London
6 months to
20 Jun 2018
Same period 2017 Same period 2016
Rank 107 125 93
Rank change year-on-year +18 -32 +3
Permanent jobs citing ETL 2,165 1,916 2,717
As % of all permanent IT jobs advertised in London 3.12% 2.74% 3.31%
As % of the Processes & Methodologies category 3.41% 2.99% 3.62%
Number of salaries quoted 1,702 1,585 2,229
London median annual salary £60,000 £57,500 £57,500
Median salary % change year-on-year +4.35% - -4.17%
10th Percentile £38,775 £38,250 £41,250
90th Percentile £87,500 £83,750 £80,000
England median annual salary £53,500 £50,000 £52,500
% change year-on-year +7.00% -4.76% -1.87%

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 63,562 64,124 74,991
As % of all permanent IT jobs advertised in London 91.58% 91.60% 91.25%
Number of salaries quoted 51,230 52,481 64,491
London median annual salary £60,000 £60,000 £57,500
Median salary % change year-on-year - +4.35% +4.55%
10th Percentile £35,000 £34,000 £33,500
90th Percentile £95,000 £90,000 £86,250
England median annual salary £50,000 £50,000 £48,500
% change year-on-year - +3.09% +2.11%

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 June 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 June 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 -1 513 £65,000 +8.33% 70
West London +37 104 £50,000 +25.00% 29
South London +19 45 £47,500 -25.78% 3
East London 0 25 £67,500 +35.00% 20
North London -1 7 £47,500 +5.56% 1
ETL
England

For the 6 months to 20 June 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,441 (66.56%) SQL
2 1,103 (50.95%) Business Intelligence
3 1,070 (49.42%) Data Warehouse
4 1,008 (46.56%) SQL Server
5 862 (39.82%) SQL Server Integration Services
6 733 (33.86%) Analytics
7 648 (29.93%) Agile Software Development
8 621 (28.68%) Microsoft
9 600 (27.71%) Finance
10 576 (26.61%) SQL Server Reporting Services
11 572 (26.42%) Big Data
12 482 (22.26%) Data Modelling
13 479 (22.12%) T-SQL
14 458 (21.15%) Python
15 450 (20.79%) Hadoop
16 449 (20.74%) SQL Server Analysis Services
17 408 (18.85%) Oracle
18 383 (17.69%) Power BI
19 382 (17.64%) Java
20 331 (15.29%) Tableau
21 324 (14.97%) Microsoft Azure
22 314 (14.50%) Relational Database
23 308 (14.23%) Apache Spark
24 288 (13.30%) Amazon AWS
25 283 (13.07%) Analytical Skills
26 280 (12.93%) Degree
27 256 (11.82%) Data Quality
28 251 (11.59%) Data Management
29 245 (11.32%) Informatica
29 245 (11.32%) Visualisation

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 308 (14.23%) Apache Spark
2 115 (5.31%) SAS
3 98 (4.53%) Apache
4 68 (3.14%) Elasticsearch
5 38 (1.76%) SharePoint
6 37 (1.71%) Confluence
7 31 (1.43%) IIS
8 26 (1.20%) Apache Solr
9 25 (1.15%) Apache Pig
10 11 (0.51%) WebSphere
11 10 (0.46%) Apache Airflow
11 10 (0.46%) Tomcat
12 8 (0.37%) Oracle Workflow
13 7 (0.32%) NServiceBus
14 6 (0.28%) Jupyter
14 6 (0.28%) Luigi
15 5 (0.23%) WebLogic
15 5 (0.23%) WebLogic Portal
16 4 (0.18%) JBoss
16 4 (0.18%) Tuxedo
Applications
1 158 (7.30%) Microsoft Excel
2 40 (1.85%) Microsoft Office
3 36 (1.66%) MS Visio
4 19 (0.88%) SPSS
5 17 (0.79%) Spreadsheet
6 10 (0.46%) Microsoft PowerPoint
7 7 (0.32%) Microsoft Project
8 3 (0.14%) Stata
9 2 (0.092%) Chatbot
Business Applications
1 36 (1.66%) Markit EDM
2 23 (1.06%) Dynamics CRM
3 16 (0.74%) Cognos TM1
4 15 (0.69%) NetSuite
5 13 (0.60%) Cognos Business Intelligence
6 9 (0.42%) Maximo
6 9 (0.42%) PeopleSoft HCM
7 8 (0.37%) Dynamics AX
7 8 (0.37%) Salesforce.com CRM
8 7 (0.32%) Eagle PACE
9 6 (0.28%) Relativity
9 6 (0.28%) SAP BPC
10 4 (0.18%) CSG Singleview
10 4 (0.18%) FastStats
10 4 (0.18%) Oracle Receivables
10 4 (0.18%) PeopleSoft CRM
11 3 (0.14%) Actimize
11 3 (0.14%) Oracle Financials
11 3 (0.14%) SAP GRC
11 3 (0.14%) SAP Oil and Gas
Cloud Services
1 324 (14.97%) Microsoft Azure
2 288 (13.30%) Amazon AWS
3 87 (4.02%) Google Cloud Platform
4 54 (2.49%) Amazon EMR
5 40 (1.85%) SaaS
6 37 (1.71%) Azure Data Factory
7 31 (1.43%) Amazon S3
8 27 (1.25%) Cloud Computing
9 26 (1.20%) Amazon Kinesis
9 26 (1.20%) Serverless
10 25 (1.15%) AWS Lambda
11 19 (0.88%) IBM Cloud
12 18 (0.83%) Google Analytics
13 17 (0.79%) Amazon EC2
14 14 (0.65%) GitHub
15 13 (0.60%) PaaS
16 12 (0.55%) Force.com
17 10 (0.46%) IaaS
18 8 (0.37%) CloudFront
18 8 (0.37%) Data Lake Analytics
Communications & Networking
1 11 (0.51%) Firewall
1 11 (0.51%) Internet
1 11 (0.51%) Kerberos
1 11 (0.51%) SMS
2 10 (0.46%) HTTP
3 7 (0.32%) FTP
4 3 (0.14%) SSL
5 2 (0.092%) 3G
5 2 (0.092%) 4G
5 2 (0.092%) Cisco ASA
5 2 (0.092%) Ethernet
5 2 (0.092%) LAN
5 2 (0.092%) VPN
5 2 (0.092%) WAN
5 2 (0.092%) Wireless
6 1 (0.046%) CHAP
6 1 (0.046%) GoToMeeting
6 1 (0.046%) IP Telephony
6 1 (0.046%) Reverse Proxy
6 1 (0.046%) SAN
Database & Business Intelligence
1 1,070 (49.42%) Data Warehouse
2 1,008 (46.56%) SQL Server
3 862 (39.82%) SQL Server Integration Services
4 576 (26.61%) SQL Server Reporting Services
5 572 (26.42%) Big Data
6 450 (20.79%) Hadoop
7 449 (20.74%) SQL Server Analysis Services
8 383 (17.69%) Power BI
9 314 (14.50%) Relational Database
10 213 (9.84%) NoSQL
11 191 (8.82%) Apache Hive
12 162 (7.48%) OLAP
13 150 (6.93%) MySQL
14 139 (6.42%) RDBMS
15 133 (6.14%) Data Lake
16 129 (5.96%) SQL Server 2008
17 124 (5.73%) HBase
18 111 (5.13%) Amazon Redshift
18 111 (5.13%) BusinessObjects
19 107 (4.94%) SQL Server 2012
Development Applications
1 98 (4.53%) Git (software)
2 90 (4.16%) JIRA
3 77 (3.56%) Visual Studio
4 71 (3.28%) Team Foundation Server
5 65 (3.00%) Jenkins
6 52 (2.40%) SQL Server Management Studio (SSMS)
7 37 (1.71%) Subversion
8 33 (1.52%) TeamCity
9 31 (1.43%) Octopus Deploy
10 27 (1.25%) ERwin
10 27 (1.25%) Selenium
11 25 (1.15%) Visual Studio Team System
12 18 (0.83%) Atlassian Bamboo
13 15 (0.69%) Vagrant
14 14 (0.65%) Bitbucket
14 14 (0.65%) Cucumber
14 14 (0.65%) Mercurial
15 11 (0.51%) VSS/SourceSafe
16 10 (0.46%) Oracle APEX
17 9 (0.42%) RStudio
General
1 600 (27.71%) Finance
2 146 (6.74%) Banking
3 138 (6.37%) Advertising
4 137 (6.33%) Retail
5 134 (6.19%) Marketing
6 54 (2.49%) Games
7 46 (2.12%) Legal
8 36 (1.66%) Pharmaceutical
9 34 (1.57%) Telecoms
10 33 (1.52%) Investment Banking
11 29 (1.34%) Front Office
12 25 (1.15%) Billing
13 23 (1.06%) Law
14 22 (1.02%) Back Office
15 21 (0.97%) Manufacturing
16 19 (0.88%) Publishing
17 10 (0.46%) Local Government
18 7 (0.32%) Polish Language
19 6 (0.28%) Electronics
20 4 (0.18%) General Ledger
Job Titles
1 830 (38.34%) Developer
2 315 (14.55%) Business Intelligence Developer
3 295 (13.63%) Data Engineer
4 293 (13.53%) Analyst
5 279 (12.89%) SQL Developer
6 200 (9.24%) Consultant
7 199 (9.19%) Architect
8 154 (7.11%) ETL Developer
9 138 (6.37%) SSIS Developer
10 130 (6.00%) Data Architect
11 109 (5.03%) Business Intelligence Analyst
12 107 (4.94%) Big Data Engineer
13 103 (4.76%) Data Warehouse Developer
14 98 (4.53%) Senior Developer
15 92 (4.25%) SQL BI Developer
16 83 (3.83%) SSRS Developer
17 78 (3.60%) Business Analyst
18 70 (3.23%) Database Developer
19 66 (3.05%) Business Developer
20 64 (2.96%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 235 (10.85%) .NET
2 202 (9.33%) Kafka
3 146 (6.74%) XML
4 134 (6.19%) Web Services
5 86 (3.97%) MDX
6 60 (2.77%) HTML
7 58 (2.68%) RabbitMQ
8 51 (2.36%) JSON
9 43 (1.99%) NumPy
10 41 (1.89%) REST
11 40 (1.85%) Pandas
12 38 (1.76%) Middleware
13 35 (1.62%) JMS
14 34 (1.57%) Spark Streaming
14 34 (1.57%) Velocity
15 32 (1.48%) ASP.NET
16 30 (1.39%) HornetQ
17 28 (1.29%) AngularJS
17 28 (1.29%) WCF
18 27 (1.25%) Node.js
Miscellaneous
1 283 (13.07%) Analytical Skills
2 140 (6.47%) Management Information System
3 130 (6.00%) Computer Science
4 116 (5.36%) Fintech
5 81 (3.74%) Data Structures
5 81 (3.74%) Greenfield Project
6 62 (2.86%) Algorithms
6 62 (2.86%) Self-Motivation
7 51 (2.36%) Replication
8 42 (1.94%) Life Science
9 39 (1.80%) User Experience
10 37 (1.71%) Tandem
11 33 (1.52%) Enterprise Software
12 31 (1.43%) Credit Risk
13 29 (1.34%) Virtual Team
14 27 (1.25%) Market Risk
15 24 (1.11%) Fixed Income
15 24 (1.11%) Hedge funds
16 22 (1.02%) Equities
17 20 (0.92%) Derivative
Operating Systems
1 197 (9.10%) Linux
2 98 (4.53%) Unix
2 98 (4.53%) Windows
3 32 (1.48%) Solaris
4 27 (1.25%) AIX
4 27 (1.25%) HPUX
5 21 (0.97%) CentOS
5 21 (0.97%) Windows Server
6 15 (0.69%) Windows Server 2012
7 8 (0.37%) Ubuntu
7 8 (0.37%) Windows Server 2008
8 5 (0.23%) Amazon Linux
8 5 (0.23%) Red Hat Enterprise Linux
9 4 (0.18%) Oracle Linux
9 4 (0.18%) Windows 7
10 2 (0.092%) VMS
11 1 (0.046%) Android
Processes & Methodologies
1 1,103 (50.95%) Business Intelligence
2 733 (33.86%) Analytics
3 648 (29.93%) Agile Software Development
4 482 (22.26%) Data Modelling
5 251 (11.59%) Data Management
6 245 (11.32%) Visualisation
7 232 (10.72%) Data Science
8 225 (10.39%) Data Integration
9 217 (10.02%) Problem-Solving
10 207 (9.56%) Kimball Methodology
11 195 (9.01%) Performance Tuning
12 178 (8.22%) Scrum
13 173 (7.99%) Data Analysis
14 165 (7.62%) Data Governance
14 165 (7.62%) Machine Learning
15 162 (7.48%) Data Architecture
16 158 (7.30%) Data Analytics
17 154 (7.11%) Data Visualisation
18 153 (7.07%) Project Management
19 147 (6.79%) ETL Development
Programming Languages
1 1,441 (66.56%) SQL
2 479 (22.12%) T-SQL
3 458 (21.15%) Python
4 382 (17.64%) Java
5 229 (10.58%) C#
6 169 (7.81%) Scala
7 141 (6.51%) R
8 121 (5.59%) PowerShell
9 86 (3.97%) JavaScript
10 74 (3.42%) PL/SQL
11 72 (3.33%) Data Analysis Expressions (DAX)
12 71 (3.28%) Perl
13 63 (2.91%) Shell Script
14 40 (1.85%) PHP
15 38 (1.76%) VBA
16 29 (1.34%) Bash Shell
17 23 (1.06%) C++
18 21 (0.97%) MATLAB
19 17 (0.79%) VB
20 16 (0.74%) VBScript
Qualifications
1 280 (12.93%) Degree
2 58 (2.68%) Computer Science Degree
3 42 (1.94%) Security Cleared
4 34 (1.57%) ISEB
4 34 (1.57%) Master's Degree
5 30 (1.39%) Microsoft Certification
6 19 (0.88%) Microsoft Certified Architect
7 13 (0.60%) Numerate Degree
7 13 (0.60%) PhD
8 12 (0.55%) ISTQB
8 12 (0.55%) PMI Certification
9 11 (0.51%) MCITP
10 10 (0.46%) MCSD
10 10 (0.46%) SC Cleared
11 7 (0.32%) PMP
12 6 (0.28%) AWS Certification
12 6 (0.28%) PRINCE2 Certification
13 5 (0.23%) ITIL Certification
13 5 (0.23%) MCSA
13 5 (0.23%) TOGAF Certification
Quality Assurance & Compliance
1 256 (11.82%) Data Quality
2 140 (6.47%) QA
3 56 (2.59%) GDPR
4 15 (0.69%) GCP
5 11 (0.51%) PMO
6 10 (0.46%) SLA
7 9 (0.42%) Actionable Recommendations
8 7 (0.32%) COBIT
8 7 (0.32%) Sarbanes-Oxley
9 6 (0.28%) IFRS
9 6 (0.28%) IFRS 9
10 4 (0.18%) EMIR
10 4 (0.18%) GxP
10 4 (0.18%) MiFID
10 4 (0.18%) Solvency II
11 2 (0.092%) CRD IV
11 2 (0.092%) Dodd-Frank
11 2 (0.092%) HL7
12 1 (0.046%) Basel III
12 1 (0.046%) HIPAA
System Software
1 90 (4.16%) HDFS
2 63 (2.91%) Docker
3 49 (2.26%) Apache Flume
4 20 (0.92%) Active Directory
5 15 (0.69%) VirtualBox
6 8 (0.37%) Virtual Machines
7 7 (0.32%) Apache ZooKeeper
8 4 (0.18%) Hyper-V
8 4 (0.18%) VMware Infrastructure
9 1 (0.046%) Oracle RAC
Systems Management
1 45 (2.08%) Oozie
2 37 (1.71%) Ansible
3 35 (1.62%) Kubernetes
3 35 (1.62%) Terraform
4 32 (1.48%) Hadoop YARN
5 20 (0.92%) Mesos
6 17 (0.79%) Ambari
6 17 (0.79%) Single Sign-On
7 16 (0.74%) Docker Swarm
7 16 (0.74%) Puppet
8 13 (0.60%) Automic
8 13 (0.60%) Dollar Universe
9 9 (0.42%) Failover Clustering
10 8 (0.37%) Control-M
11 7 (0.32%) logstash
11 7 (0.32%) Microsoft Clustering
11 7 (0.32%) Oracle Enterprise Manager
11 7 (0.32%) Oracle Identity Manager
12 6 (0.28%) Grafana
12 6 (0.28%) Kibana
Vendors
1 621 (28.68%) Microsoft
2 408 (18.85%) Oracle
3 331 (15.29%) Tableau
4 245 (11.32%) Informatica
5 216 (9.98%) Talend
6 130 (6.00%) SAP
7 125 (5.77%) Cloudera
8 114 (5.27%) Google
9 88 (4.06%) IBM
10 77 (3.56%) Cognos
11 75 (3.46%) MicroStrategy
12 68 (3.14%) Alteryx
13 67 (3.09%) Salesforce.com
14 64 (2.96%) Hortonworks
15 48 (2.22%) Netezza
16 44 (2.03%) Teradata
17 39 (1.80%) Ab Initio
18 36 (1.66%) WorldPay
19 30 (1.39%) EXASOL
20 28 (1.29%) Cognizant