Period
to 7 December 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 7 December 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
7 Dec 2019
Same period 2018 Same period 2017
Rank 54 89 101
Rank change year-on-year +35 +12 -30
Contract jobs citing ETL 221 217 168
As % of all contract IT jobs advertised in the City of London 3.91% 3.04% 2.33%
As % of the Processes & Methodologies category 4.38% 3.47% 2.59%
Number of daily rates quoted 181 183 134
City of London median daily rate £520 £475 £500
Median daily rate % change year-on-year +9.47% -5.00% +11.11%
10th Percentile £390 £368 £402
90th Percentile £638 £613 £675
Central London median daily rate £515 £475 £488
% change year-on-year +8.42% -2.56% +8.33%
Number of hourly rates quoted 0 0 1
City of London median hourly rate - - £65.00
Central London median hourly rate - - £65.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,041 6,252 6,489
As % of all contract IT jobs advertised in the City of London 89.30% 87.67% 90.04%
Number of daily rates quoted 3,919 4,947 5,168
City of London median daily rate £525 £510 £501
Median daily rate % change year-on-year +2.94% +1.90% +5.37%
10th Percentile £325 £325 £325
90th Percentile £688 £675 £688
Central London median daily rate £513 £500 £500
% change year-on-year +2.50% - +5.26%
Number of hourly rates quoted 53 89 61
City of London median hourly rate £20.83 £18.70 £20.00
Median hourly rate % change year-on-year +11.39% -6.50% -
10th Percentile £12.04 £13.25 £13.30
90th Percentile £52.05 £33.40 £31.00
Central London median hourly rate £21.00 £19.00 £20.50
% change year-on-year +10.53% -7.32% +7.89%

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 7 December 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

ETL
Contract Job Locations in the City of London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the City of London region over the 6 months to 7 December 2019. 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
London Bridge +30 2 £400 -23.81%
ETL
Central London

For the 6 months to 7 December 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 156 (70.59%) SQL
2 108 (48.87%) Data Warehouse
3 98 (44.34%) Business Intelligence
4 90 (40.72%) SQL Server
5 76 (34.39%) SQL Server Integration Services
6 73 (33.03%) Python
7 69 (31.22%) Agile Software Development
8 62 (28.05%) Data Modelling
9 57 (25.79%) Finance
10 56 (25.34%) Microsoft
11 51 (23.08%) Azure
12 46 (20.81%) Analytics
13 43 (19.46%) Power BI
13 43 (19.46%) Power Platform
14 40 (18.10%) AWS
14 40 (18.10%) Java
15 38 (17.19%) T-SQL
16 32 (14.48%) SQL Server Reporting Services
16 32 (14.48%) SQL Server Analysis Services
17 31 (14.03%) Migration
18 30 (13.57%) Oracle
18 30 (13.57%) Kimball Methodology
19 28 (12.67%) DevOps
20 27 (12.22%) Data Science
20 27 (12.22%) Dimensional Modelling
20 27 (12.22%) Data Migration
21 26 (11.76%) Git (software)
22 24 (10.86%) Data Integration
22 24 (10.86%) Data Analysis
22 24 (10.86%) Apache Spark

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.86%) Apache Spark
2 9 (4.07%) SAS
3 6 (2.71%) Apache Airflow
3 6 (2.71%) Elasticsearch
3 6 (2.71%) WebLogic
3 6 (2.71%) WebLogic Integration
4 5 (2.26%) Apache
4 5 (2.26%) SharePoint
5 4 (1.81%) Jupyter
6 2 (0.90%) Apache Pig
6 2 (0.90%) Cloud Foundry
6 2 (0.90%) Confluence
6 2 (0.90%) Luigi
Applications
1 23 (10.41%) Microsoft Excel
2 1 (0.45%) Microsoft Office
2 1 (0.45%) MS Visio
2 1 (0.45%) Spreadsheet
Business Applications
1 8 (3.62%) Dynamics CRM
2 6 (2.71%) Oracle Financials
2 6 (2.71%) Unit4 Business World
3 1 (0.45%) Dynamics NAV
3 1 (0.45%) FastStats
3 1 (0.45%) FINCAD Analytics
3 1 (0.45%) Oracle FAH
3 1 (0.45%) Sparx Enterprise Architect
Cloud Services
1 51 (23.08%) Azure
2 43 (19.46%) Power Platform
3 40 (18.10%) AWS
4 22 (9.95%) GCP
5 14 (6.33%) Serverless
6 13 (5.88%) Azure Data Factory
7 10 (4.52%) Amazon S3
7 10 (4.52%) AWS Lambda
8 9 (4.07%) Amazon EMR
9 5 (2.26%) Amazon EC2
9 5 (2.26%) AWS CloudFormation
10 4 (1.81%) Amazon Kinesis
10 4 (1.81%) Azure Functions
10 4 (1.81%) GitHub
11 3 (1.36%) AWS Step Functions
12 2 (0.90%) Amazon CloudWatch
12 2 (0.90%) AWS CloudTrail
12 2 (0.90%) Azure Stack
12 2 (0.90%) Dynamics 365
12 2 (0.90%) Virtual Private Cloud
Communications & Networking
1 2 (0.90%) Internet
2 1 (0.45%) LAN
Database & Business Intelligence
1 108 (48.87%) Data Warehouse
2 90 (40.72%) SQL Server
3 76 (34.39%) SQL Server Integration Services
4 43 (19.46%) Power BI
5 32 (14.48%) SQL Server Analysis Services
5 32 (14.48%) SQL Server Reporting Services
6 21 (9.50%) Hadoop
7 18 (8.14%) Amazon Redshift
7 18 (8.14%) Azure SQL Database
7 18 (8.14%) Big Data
8 17 (7.69%) Apache Hive
8 17 (7.69%) BigQuery
9 14 (6.33%) QlikView
9 14 (6.33%) Relational Database
10 13 (5.88%) PostgreSQL
11 12 (5.43%) Azure SQL Data Warehouse
12 11 (4.98%) BusinessObjects
12 11 (4.98%) Data Lake
13 10 (4.52%) Snowflake Schema
13 10 (4.52%) Star Schema
Development Applications
1 26 (11.76%) Git (software)
2 15 (6.79%) Jenkins
3 10 (4.52%) Eclipse
4 9 (4.07%) JIRA
5 7 (3.17%) Visual Studio
6 5 (2.26%) Atlassian Bamboo
6 5 (2.26%) Selenium
6 5 (2.26%) Team Foundation Server
7 2 (0.90%) WebDriver
8 1 (0.45%) Bitbucket Server
8 1 (0.45%) Cucumber
8 1 (0.45%) GitLab
8 1 (0.45%) Maven
8 1 (0.45%) SQL Server Management Studio (SSMS)
8 1 (0.45%) Vagrant
8 1 (0.45%) Visual Studio Team System
General
1 57 (25.79%) Finance
2 18 (8.14%) Banking
3 12 (5.43%) Retail
4 11 (4.98%) Front Office
5 9 (4.07%) Investment Banking
6 5 (2.26%) Public Sector
7 3 (1.36%) Marketing
7 3 (1.36%) Publishing
8 2 (0.90%) Financial Institution
8 2 (0.90%) General Ledger
9 1 (0.45%) Back Office
9 1 (0.45%) Billing
9 1 (0.45%) Games
9 1 (0.45%) International Banking
9 1 (0.45%) Legal
Job Titles
1 86 (38.91%) Developer
2 39 (17.65%) Data Engineer
3 33 (14.93%) Analyst
4 30 (13.57%) Business Intelligence Developer
5 27 (12.22%) SQL Developer
6 24 (10.86%) ETL Developer
7 16 (7.24%) Architect
7 16 (7.24%) Data Analyst
8 14 (6.33%) Python Engineer
9 12 (5.43%) Data Warehouse Developer
9 12 (5.43%) Python Developer
9 12 (5.43%) SQL BI Developer
10 10 (4.52%) Data Architect
11 7 (3.17%) Azure Developer
11 7 (3.17%) Business Analyst
11 7 (3.17%) Consultant
12 6 (2.71%) Pentaho Developer
12 6 (2.71%) Power BI Developer
12 6 (2.71%) SQL Analyst
12 6 (2.71%) Test Leader
Libraries, Frameworks & Software Standards
1 19 (8.60%) Kafka
2 15 (6.79%) .NET
3 13 (5.88%) Web Services
4 10 (4.52%) Middleware
4 10 (4.52%) MSMQ
4 10 (4.52%) XML
5 8 (3.62%) Pandas
5 8 (3.62%) REST
6 7 (3.17%) J2EE
6 7 (3.17%) JSON
6 7 (3.17%) NumPy
7 6 (2.71%) SOAP
8 5 (2.26%) PySpark
9 4 (1.81%) Apache Beam
9 4 (1.81%) MDX
9 4 (1.81%) Spark Streaming
10 3 (1.36%) AngularJS
10 3 (1.36%) RESTful
10 3 (1.36%) SciPy
11 2 (0.90%) Protocol Buffers
Miscellaneous
1 18 (8.14%) Analytical Skills
2 17 (7.69%) Reinsurance
3 8 (3.62%) Data Structures
4 5 (2.26%) Algorithms
5 4 (1.81%) Equities
5 4 (1.81%) Fixed Income
6 3 (1.36%) Greenfield Project
6 3 (1.36%) Management Information System
6 3 (1.36%) Reference Data
6 3 (1.36%) Replication
6 3 (1.36%) User Experience
6 3 (1.36%) Virtual Team
7 2 (0.90%) Client/Server
7 2 (0.90%) Cloud Native
7 2 (0.90%) Derivative
8 1 (0.45%) Blog
8 1 (0.45%) Equity Derivative
8 1 (0.45%) Semantic Web
8 1 (0.45%) Spread Betting
8 1 (0.45%) Video Conferencing
Operating Systems
1 13 (5.88%) Unix
2 12 (5.43%) Linux
3 4 (1.81%) Windows
4 2 (0.90%) VMS
Processes & Methodologies
1 98 (44.34%) Business Intelligence
2 69 (31.22%) Agile Software Development
3 62 (28.05%) Data Modelling
4 46 (20.81%) Analytics
5 31 (14.03%) Migration
6 30 (13.57%) Kimball Methodology
7 28 (12.67%) DevOps
8 27 (12.22%) Data Migration
8 27 (12.22%) Data Science
8 27 (12.22%) Dimensional Modelling
9 24 (10.86%) Data Analysis
9 24 (10.86%) Data Integration
10 21 (9.50%) ETL Development
11 18 (8.14%) Scrum
11 18 (8.14%) Visualisation
12 15 (6.79%) Data Architecture
13 14 (6.33%) Fintech
14 13 (5.88%) Data Engineering
14 13 (5.88%) SDLC
14 13 (5.88%) TDD
Programming Languages
1 156 (70.59%) SQL
2 73 (33.03%) Python
3 40 (18.10%) Java
4 38 (17.19%) T-SQL
5 15 (6.79%) C#
5 15 (6.79%) PL/SQL
5 15 (6.79%) Scala
6 10 (4.52%) Perl
7 8 (3.62%) R
8 7 (3.17%) Data Analysis Expressions (DAX)
9 5 (2.26%) JavaScript
9 5 (2.26%) Shell Script
10 4 (1.81%) PowerShell
11 3 (1.36%) Bash Shell
11 3 (1.36%) Go
11 3 (1.36%) VBA
12 2 (0.90%) C++
12 2 (0.90%) Kotlin
12 2 (0.90%) MATLAB
13 1 (0.45%) C
Qualifications
1 5 (2.26%) Degree
2 4 (1.81%) Computer Science Degree
3 3 (1.36%) SC Cleared
3 3 (1.36%) Security Cleared
4 1 (0.45%) ISEB
4 1 (0.45%) ISTQB
4 1 (0.45%) Numerate Degree
Quality Assurance & Compliance
1 17 (7.69%) Data Quality
2 8 (3.62%) QA
3 7 (3.17%) IFRS
4 6 (2.71%) GDPR
4 6 (2.71%) Solvency II
5 1 (0.45%) Basel III
5 1 (0.45%) IFRS 9
System Software
1 18 (8.14%) Docker
2 4 (1.81%) HDFS
2 4 (1.81%) Oracle RAC
3 3 (1.36%) Active Directory
4 1 (0.45%) VirtualBox
Systems Management
1 14 (6.33%) Kubernetes
2 7 (3.17%) Hadoop YARN
3 4 (1.81%) Ansible
4 2 (0.90%) Kibana
5 1 (0.45%) Docker Swarm
5 1 (0.45%) Kubeflow
5 1 (0.45%) Terraform
Vendors
1 56 (25.34%) Microsoft
2 30 (13.57%) Oracle
3 23 (10.41%) Tableau
4 18 (8.14%) Google
5 15 (6.79%) Informatica
6 7 (3.17%) Alteryx
7 6 (2.71%) CODA
7 6 (2.71%) Teradata
8 5 (2.26%) Databricks
8 5 (2.26%) Salesforce.com
8 5 (2.26%) SAP
9 4 (1.81%) Cognos
9 4 (1.81%) Guidewire
9 4 (1.81%) Talend
10 3 (1.36%) Cloudera
10 3 (1.36%) IBM
10 3 (1.36%) SnapLogic
11 2 (0.90%) Hortonworks
11 2 (0.90%) Palantir
12 1 (0.45%) Birst