Period
to 21 September 2019

The following table provides summary statistics for contract job vacancies advertised in the City of London with a requirement for ETL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ETL over the 6 months to 21 September 2019 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Extract, Transform and Load (ETL)
Central London > City of London
6 months to
21 Sep 2019
Same period 2018 Same period 2017
Rank 68 90 102
Rank change year-on-year +22 +12 -28
Contract jobs citing ETL 225 201 175
As % of all contract IT jobs advertised in the City of London 3.63% 2.88% 2.58%
As % of the Processes & Methodologies category 4.03% 3.30% 2.88%
Number of daily rates quoted 171 173 132
City of London median daily rate £500 £475 £500
Median daily rate % change year-on-year +5.26% -5.00% +11.11%
10th Percentile £381 £363 £385
90th Percentile £638 £613 £675
Central London median daily rate £500 £475 £500
% change year-on-year +5.26% -5.00% +11.11%
Number of hourly rates quoted 1 0 0
City of London median hourly rate £35.00 - -
Central London median hourly rate £35.00 - -

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the City of London with a requirement for process or methodology skills.

All Process and Methodology Skills
City of London
Contract vacancies with a requirement for process or methodology skills 5,579 6,092 6,076
As % of all contract IT jobs advertised in the City of London 89.98% 87.17% 89.50%
Number of daily rates quoted 4,362 4,849 4,744
City of London median daily rate £525 £505 £500
Median daily rate % change year-on-year +3.96% +1.00% +5.26%
10th Percentile £338 £331 £325
90th Percentile £675 £681 £675
Central London median daily rate £520 £500 £500
% change year-on-year +4.00% - +5.26%
Number of hourly rates quoted 72 102 57
City of London median hourly rate £19.25 £18.70 £18.70
Median hourly rate % change year-on-year +2.94% - -6.50%
10th Percentile £11.25 £13.02 £13.13
90th Percentile £53.50 £32.25 £31.05
Central London median hourly rate £19.75 £18.70 £18.70
% change year-on-year +5.61% - -6.50%

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
Contractor Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL in the City of London.

Contractor daily rate trend for ETL in the City of London

ETL
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing ETL in the City of London over the 6 months to 21 September 2019.

Contractor daily rate histogram for ETL in the City of London

ETL
Contractor Hourly Rate Trend in the City of London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ETL in the City of London.

Contractor hourly rate trend for ETL in the City of London

For the 6 months to 21 September 2019, IT contractor 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 contract job ads across the City of London region with a requirement for ETL.

1 163 (72.44%) SQL
2 112 (49.78%) Data Warehouse
3 104 (46.22%) SQL Server
4 100 (44.44%) Business Intelligence
5 86 (38.22%) SQL Server Integration Services
6 79 (35.11%) Data Modelling
7 67 (29.78%) Agile Software Development
8 66 (29.33%) Azure
9 65 (28.89%) Python
10 61 (27.11%) Microsoft
11 58 (25.78%) Finance
12 48 (21.33%) T-SQL
12 48 (21.33%) Power BI
12 48 (21.33%) Power Platform
13 41 (18.22%) Analytics
13 41 (18.22%) Java
14 40 (17.78%) SQL Server Reporting Services
15 38 (16.89%) AWS
16 36 (16.00%) SQL Server Analysis Services
16 36 (16.00%) Migration
17 32 (14.22%) Data Migration
18 30 (13.33%) Git (software)
19 26 (11.56%) Microsoft Excel
19 26 (11.56%) Dimensional Modelling
19 26 (11.56%) Kimball Methodology
19 26 (11.56%) DevOps
20 24 (10.67%) Apache Spark
20 24 (10.67%) Data Integration
20 24 (10.67%) Oracle
21 23 (10.22%) Data Analysis

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 24 (10.67%) Apache Spark
2 9 (4.00%) SharePoint
3 6 (2.67%) SAS
3 6 (2.67%) WebLogic
3 6 (2.67%) WebLogic Integration
4 3 (1.33%) Apache
4 3 (1.33%) Confluence
4 3 (1.33%) Elasticsearch
5 2 (0.89%) Apache Airflow
5 2 (0.89%) Apache Pig
5 2 (0.89%) Cloud Foundry
5 2 (0.89%) Jupyter
6 1 (0.44%) CMS
6 1 (0.44%) Sitecore CMS
Applications
1 26 (11.56%) Microsoft Excel
2 3 (1.33%) Microsoft Office
3 1 (0.44%) Microsoft PowerPoint
3 1 (0.44%) Mingle
3 1 (0.44%) MS Visio
3 1 (0.44%) Spreadsheet
3 1 (0.44%) SPSS
3 1 (0.44%) Stata
Business Applications
1 7 (3.11%) Oracle Financials
2 6 (2.67%) Dynamics CRM
2 6 (2.67%) Unit4 Business World
3 2 (0.89%) Markit EDM
4 1 (0.44%) Dynamics NAV
4 1 (0.44%) Eagle PACE
Cloud Services
1 66 (29.33%) Azure
2 48 (21.33%) Power Platform
3 38 (16.89%) AWS
4 19 (8.44%) Azure Data Factory
5 18 (8.00%) GCP
6 13 (5.78%) Serverless
7 10 (4.44%) Amazon S3
8 9 (4.00%) Amazon EMR
9 8 (3.56%) AWS Lambda
10 5 (2.22%) Amazon EC2
10 5 (2.22%) Azure Functions
10 5 (2.22%) GitHub
11 4 (1.78%) AWS CloudFormation
11 4 (1.78%) Cloud Computing
11 4 (1.78%) Heroku
11 4 (1.78%) PaaS
12 3 (1.33%) Dynamics 365
12 3 (1.33%) IaaS
13 2 (0.89%) Amazon Kinesis
13 2 (0.89%) Azure Stack
Communications & Networking
1 4 (1.78%) SMTP
2 3 (1.33%) Internet
3 1 (0.44%) LAN
Database & Business Intelligence
1 112 (49.78%) Data Warehouse
2 104 (46.22%) SQL Server
3 86 (38.22%) SQL Server Integration Services
4 48 (21.33%) Power BI
5 40 (17.78%) SQL Server Reporting Services
6 36 (16.00%) SQL Server Analysis Services
7 23 (10.22%) Hadoop
8 20 (8.89%) Big Data
9 19 (8.44%) Azure SQL Database
10 18 (8.00%) Amazon Redshift
10 18 (8.00%) Apache Hive
10 18 (8.00%) Data Lake
11 17 (7.56%) Azure SQL Data Warehouse
12 15 (6.67%) BigQuery
13 13 (5.78%) Relational Database
14 12 (5.33%) MySQL
14 12 (5.33%) NoSQL
14 12 (5.33%) PostgreSQL
15 11 (4.89%) QlikView
15 11 (4.89%) SQL Server 2016
Development Applications
1 30 (13.33%) Git (software)
2 16 (7.11%) Jenkins
3 11 (4.89%) Eclipse
3 11 (4.89%) JIRA
4 8 (3.56%) Visual Studio
5 5 (2.22%) Atlassian Bamboo
6 4 (1.78%) Team Foundation Server
7 3 (1.33%) Selenium
7 3 (1.33%) SpecFlow
7 3 (1.33%) SQL Server Management Studio (SSMS)
7 3 (1.33%) Visual Studio Team System
8 2 (0.89%) Bitbucket Server
8 2 (0.89%) Cucumber
8 2 (0.89%) Octopus Deploy
8 2 (0.89%) TeamCity
8 2 (0.89%) tSQLt
9 1 (0.44%) ERwin
9 1 (0.44%) MSTest
9 1 (0.44%) Vagrant
9 1 (0.44%) WebDriver
General
1 58 (25.78%) Finance
2 21 (9.33%) Retail
3 17 (7.56%) Banking
4 12 (5.33%) Investment Banking
5 7 (3.11%) Front Office
5 7 (3.11%) Public Sector
6 5 (2.22%) Publishing
7 2 (0.89%) Back Office
7 2 (0.89%) Environmental Health
7 2 (0.89%) Games
7 2 (0.89%) General Ledger
7 2 (0.89%) Marketing
8 1 (0.44%) Financial Institution
8 1 (0.44%) International Banking
Job Titles
1 89 (39.56%) Developer
2 37 (16.44%) Data Engineer
3 35 (15.56%) Business Intelligence Developer
4 29 (12.89%) Analyst
4 29 (12.89%) SQL Developer
5 24 (10.67%) ETL Developer
6 21 (9.33%) Architect
7 14 (6.22%) Data Analyst
8 13 (5.78%) SQL BI Developer
9 11 (4.89%) Data Architect
10 10 (4.44%) Azure Developer
10 10 (4.44%) Python Developer
11 9 (4.00%) Data Warehouse Developer
12 8 (3.56%) Lead Architect
12 8 (3.56%) Python Engineer
13 7 (3.11%) Consultant
14 6 (2.67%) Analyst Developer
14 6 (2.67%) Data Modeller
14 6 (2.67%) Technical Analyst
14 6 (2.67%) Technical Leader
Libraries, Frameworks & Software Standards
1 19 (8.44%) .NET
1 19 (8.44%) Kafka
2 16 (7.11%) Web Services
3 12 (5.33%) Middleware
4 10 (4.44%) MSMQ
4 10 (4.44%) SOAP
4 10 (4.44%) XML
5 8 (3.56%) REST
5 8 (3.56%) RESTful
6 7 (3.11%) J2EE
6 7 (3.11%) JSON
7 6 (2.67%) Pandas
8 5 (2.22%) PySpark
8 5 (2.22%) Spark Streaming
9 4 (1.78%) Apache Beam
9 4 (1.78%) NumPy
9 4 (1.78%) Visualforce
10 3 (1.33%) HTML
10 3 (1.33%) LAMP
10 3 (1.33%) MDX
Miscellaneous
1 21 (9.33%) Analytical Skills
2 17 (7.56%) Reinsurance
3 10 (4.44%) Data Structures
4 5 (2.22%) Replication
5 2 (0.89%) Client/Server
5 2 (0.89%) Cloud Native
5 2 (0.89%) Equities
5 2 (0.89%) Fixed Income
5 2 (0.89%) Greenfield Project
5 2 (0.89%) Management Information System
6 1 (0.44%) Enterprise Software
6 1 (0.44%) Linux Command Line
6 1 (0.44%) Market Risk
6 1 (0.44%) Reference Data
6 1 (0.44%) Self-Motivation
6 1 (0.44%) Social Media
6 1 (0.44%) Spread Betting
6 1 (0.44%) Tandem
6 1 (0.44%) Video Conferencing
6 1 (0.44%) Virtual Team
Operating Systems
1 13 (5.78%) Linux
2 10 (4.44%) Unix
3 2 (0.89%) VMS
4 1 (0.44%) Red Hat Enterprise Linux
4 1 (0.44%) Solaris
Processes & Methodologies
1 100 (44.44%) Business Intelligence
2 79 (35.11%) Data Modelling
3 67 (29.78%) Agile Software Development
4 41 (18.22%) Analytics
5 36 (16.00%) Migration
6 32 (14.22%) Data Migration
7 26 (11.56%) DevOps
7 26 (11.56%) Dimensional Modelling
7 26 (11.56%) Kimball Methodology
8 24 (10.67%) Data Integration
9 23 (10.22%) Data Analysis
9 23 (10.22%) Data Science
10 20 (8.89%) ETL Development
11 18 (8.00%) Visualisation
12 16 (7.11%) Data Architecture
12 16 (7.11%) Problem-Solving
12 16 (7.11%) Test Automation
13 15 (6.67%) Data Engineering
13 15 (6.67%) Scrum
14 14 (6.22%) Fintech
Programming Languages
1 163 (72.44%) SQL
2 65 (28.89%) Python
3 48 (21.33%) T-SQL
4 41 (18.22%) Java
5 14 (6.22%) Scala
6 13 (5.78%) C#
7 9 (4.00%) Data Analysis Expressions (DAX)
8 8 (3.56%) JavaScript
8 8 (3.56%) Perl
9 7 (3.11%) R
10 6 (2.67%) PL/SQL
11 4 (1.78%) Apex Code
11 4 (1.78%) Bash Shell
11 4 (1.78%) Shell Script
11 4 (1.78%) VBA
12 3 (1.33%) PowerShell
13 2 (0.89%) Kotlin
13 2 (0.89%) U-SQL
14 1 (0.44%) Go
14 1 (0.44%) MATLAB
Qualifications
1 5 (2.22%) Degree
2 4 (1.78%) Computer Science Degree
3 2 (0.89%) ISEB
3 2 (0.89%) ISTQB
3 2 (0.89%) SC Cleared
3 2 (0.89%) Security Cleared
4 1 (0.44%) ACCA
Quality Assurance & Compliance
1 14 (6.22%) Data Quality
2 8 (3.56%) GDPR
3 6 (2.67%) IFRS
3 6 (2.67%) Solvency II
4 5 (2.22%) QA
System Software
1 16 (7.11%) Docker
2 6 (2.67%) HDFS
3 3 (1.33%) Active Directory
3 3 (1.33%) Apache Flume
4 2 (0.89%) Oracle RAC
5 1 (0.44%) VirtualBox
Systems Management
1 10 (4.44%) Kubernetes
2 9 (4.00%) Hadoop YARN
3 6 (2.67%) Ansible
4 1 (0.44%) Docker Swarm
4 1 (0.44%) Red Hat Satellite
4 1 (0.44%) Terraform
Vendors
1 61 (27.11%) Microsoft
2 24 (10.67%) Oracle
3 20 (8.89%) Tableau
4 19 (8.44%) Informatica
5 16 (7.11%) Google
6 9 (4.00%) Salesforce.com
7 7 (3.11%) Teradata
8 6 (2.67%) CODA
8 6 (2.67%) Talend
9 5 (2.22%) Alteryx
9 5 (2.22%) Cloudera
9 5 (2.22%) SnapLogic
10 4 (1.78%) Guidewire
11 3 (1.33%) Databricks
12 2 (0.89%) Ab Initio
12 2 (0.89%) Birst
12 2 (0.89%) Hortonworks
12 2 (0.89%) IBM
12 2 (0.89%) SAP
12 2 (0.89%) Vertica