Period
to 5 July 2020

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 5 July 2020 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
5 Jul 2020
Same period 2019 Same period 2018
Rank 54 81 83
Rank change year-on-year +27 +2 +5
Contract jobs citing ETL 98 198 223
As % of all contract jobs advertised in the City of London 3.58% 2.96% 3.13%
As % of the Processes & Methodologies category 4.10% 3.30% 3.54%
Number of daily rates quoted 69 148 182
Median daily rate £500 £480 £490
Median daily rate % change year-on-year +4.17% -2.04% -2.00%
10th Percentile £361 £406 £367
90th Percentile £675 £638 £661
Central London median daily rate £508 £480 £500
% change year-on-year +5.73% -4.00% -
Number of hourly rates quoted 0 1 0
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 2,391 5,991 6,298
As % of all contract IT jobs advertised in the City of London 87.26% 89.62% 88.27%
Number of daily rates quoted 1,689 4,647 5,000
Median daily rate £518 £525 £513
Median daily rate % change year-on-year -1.43% +2.44% +2.50%
10th Percentile £331 £350 £331
90th Percentile £675 £675 £688
Central London median daily rate £505 £525 £500
% change year-on-year -3.81% +5.00% +2.04%
Number of hourly rates quoted 49 70 101
Median hourly rate £35.00 £20.75 £18.70
Median hourly rate % change year-on-year +68.67% +10.96% -3.36%
10th Percentile £12.48 £11.25 £12.75
90th Percentile £48.70 £54.03 £33.75
Median hourly rate £35.00 £21.09 £19.38
% change year-on-year +65.96% +8.85% +14.24%

ETL
Job Vacancy Trend in the City of London

Job postings citing ETL as a proportion 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

3-month moving average daily rate quoted in jobs citing ETL in the City of London.

Daily rate trend for ETL in the City of London

ETL
Daily Rate Histogram in the City of London

Daily rate distribution for jobs citing ETL in the City of London over the 6 months to 5 July 2020.

Daily rate histogram for ETL in the City of London

ETL
Contractor Hourly Rate Trend in the City of London

3-month moving average hourly rates quoted in jobs citing ETL in the City of London.

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 5 July 2020. 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 - 1 £400 -
ETL
Central London

For the 6 months to 5 July 2020, 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 66 (67.35%) SQL
2 48 (48.98%) Data Warehouse
3 44 (44.90%) Agile Software Development
4 38 (38.78%) Business Intelligence
5 34 (34.69%) Finance
6 32 (32.65%) Data Modelling
7 29 (29.59%) Python
8 28 (28.57%) SQL Server Integration Services
9 27 (27.55%) Kimball Methodology
10 25 (25.51%) SQL Server
11 23 (23.47%) Azure
12 22 (22.45%) Microsoft Excel
13 21 (21.43%) DevOps
14 20 (20.41%) SDLC
14 20 (20.41%) Microsoft
15 19 (19.39%) Analytics
16 17 (17.35%) AWS
17 16 (16.33%) T-SQL
17 16 (16.33%) SQL Server Reporting Services
18 15 (15.31%) Machine Learning
19 14 (14.29%) NoSQL
19 14 (14.29%) SQL Server Analysis Services
19 14 (14.29%) Informatica
19 14 (14.29%) Analytical Skills
20 13 (13.27%) Requirements Gathering
20 13 (13.27%) Information Management
20 13 (13.27%) Migration
20 13 (13.27%) Change Management
20 13 (13.27%) Data Architecture
20 13 (13.27%) Data Integration

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 7 (7.14%) SAS
2 6 (6.12%) Elasticsearch
3 5 (5.10%) Apache Spark
4 2 (2.04%) Apache Airflow
4 2 (2.04%) Confluence
4 2 (2.04%) Oracle Workflow
5 1 (1.02%) Apache
5 1 (1.02%) Apache Pig
5 1 (1.02%) Apache Pulsar
5 1 (1.02%) IBM HTTP Server
5 1 (1.02%) Mule
5 1 (1.02%) Tomcat
5 1 (1.02%) WebLogic
Applications
1 22 (22.45%) Microsoft Excel
2 2 (2.04%) Adobe Illustrator
2 2 (2.04%) InDesign
2 2 (2.04%) Photoshop
3 1 (1.02%) Microsoft PowerPoint
Business Applications
1 1 (1.02%) Magento
1 1 (1.02%) Shopify
Cloud Services
1 23 (23.47%) Azure
2 17 (17.35%) AWS
3 11 (11.22%) Power Platform
4 7 (7.14%) Azure Data Factory
5 5 (5.10%) GCP
6 4 (4.08%) Azure Machine Learning
6 4 (4.08%) Azure Stack
7 2 (2.04%) AWS CloudFormation
7 2 (2.04%) Google Docs
8 1 (1.02%) Amazon EC2
8 1 (1.02%) Amazon Kinesis
8 1 (1.02%) Amazon S3
8 1 (1.02%) AWS Lambda
8 1 (1.02%) PaaS
8 1 (1.02%) SaaS
8 1 (1.02%) Serverless
Communications & Networking
1 1 (1.02%) WebEx
Database & Business Intelligence
1 48 (48.98%) Data Warehouse
2 28 (28.57%) SQL Server Integration Services
3 25 (25.51%) SQL Server
4 16 (16.33%) SQL Server Reporting Services
5 14 (14.29%) NoSQL
5 14 (14.29%) SQL Server Analysis Services
6 13 (13.27%) Big Data
7 11 (11.22%) Data Lake
7 11 (11.22%) Power BI
8 10 (10.20%) Hadoop
9 8 (8.16%) Microsoft Analysis Services
10 6 (6.12%) PowerPivot
10 6 (6.12%) SSDT
11 4 (4.08%) Apache Hive
11 4 (4.08%) Azure SQL Data Warehouse
11 4 (4.08%) MySQL
11 4 (4.08%) PostgreSQL
11 4 (4.08%) SAS EBI
12 3 (3.06%) OLAP
12 3 (3.06%) Star Schema
Development Applications
1 8 (8.16%) Team Foundation Server
2 6 (6.12%) SQL Server Management Studio (SSMS)
2 6 (6.12%) Visual Studio
3 4 (4.08%) GitLab
3 4 (4.08%) Jenkins
4 2 (2.04%) JIRA
4 2 (2.04%) Toad
5 1 (1.02%) Eclipse
5 1 (1.02%) Git (software)
5 1 (1.02%) Postman
5 1 (1.02%) Subversion
General
1 34 (34.69%) Finance
2 6 (6.12%) Banking
3 4 (4.08%) Retail
4 3 (3.06%) Law
4 3 (3.06%) Marketing
4 3 (3.06%) Public Sector
5 2 (2.04%) Back Office
5 2 (2.04%) Billing
5 2 (2.04%) Financial Institution
5 2 (2.04%) General Ledger
6 1 (1.02%) Front Office
6 1 (1.02%) Investment Banking
6 1 (1.02%) Publishing
Job Titles
1 23 (23.47%) Analyst
1 23 (23.47%) Developer
2 20 (20.41%) Data Engineer
3 19 (19.39%) Architect
4 14 (14.29%) SQL Analyst
5 13 (13.27%) Data Warehouse Analyst
5 13 (13.27%) Technical Analyst
6 12 (12.24%) ETL Analyst
7 11 (11.22%) Data Architect
8 10 (10.20%) SQL Data Analyst
9 8 (8.16%) Business Intelligence Analyst
10 7 (7.14%) SQL Developer
10 7 (7.14%) SSIS Analyst
11 6 (6.12%) Azure Engineer
11 6 (6.12%) Data Modeller
11 6 (6.12%) Data Warehouse Developer
11 6 (6.12%) ETL Developer
12 5 (5.10%) Business Intelligence Architect
12 5 (5.10%) Business Intelligence Developer
12 5 (5.10%) DevOps Engineer
Libraries, Frameworks & Software Standards
1 9 (9.18%) Web Services
1 9 (9.18%) XML
2 7 (7.14%) MDX
2 7 (7.14%) XML Schema
3 3 (3.06%) .NET
3 3 (3.06%) Celery
3 3 (3.06%) LDAP
3 3 (3.06%) RabbitMQ
4 2 (2.04%) REST
5 1 (1.02%) .NET Core
5 1 (1.02%) .NET Framework
5 1 (1.02%) Apache NiFi
5 1 (1.02%) GraphQL
5 1 (1.02%) JSON
5 1 (1.02%) Kafka
5 1 (1.02%) PySpark
5 1 (1.02%) SailPoint
5 1 (1.02%) Swagger
5 1 (1.02%) XSLT
Miscellaneous
1 14 (14.29%) Analytical Skills
2 5 (5.10%) Reinsurance
3 3 (3.06%) Blog
3 3 (3.06%) Public Cloud
4 2 (2.04%) Credit Risk
4 2 (2.04%) Enterprise Software
4 2 (2.04%) Equities
4 2 (2.04%) Fixed Income
4 2 (2.04%) Management Information System
4 2 (2.04%) NHS
4 2 (2.04%) Self-Motivation
5 1 (1.02%) Data Structures
5 1 (1.02%) Derivative
5 1 (1.02%) Greenfield Project
5 1 (1.02%) Hybrid Cloud
5 1 (1.02%) Market Risk
5 1 (1.02%) Reference Data
5 1 (1.02%) Robotics
5 1 (1.02%) Tandem
5 1 (1.02%) Taxonomies
Operating Systems
1 7 (7.14%) Unix
2 4 (4.08%) Linux
3 3 (3.06%) Mac OS X
4 1 (1.02%) Windows
Processes & Methodologies
1 44 (44.90%) Agile Software Development
2 38 (38.78%) Business Intelligence
3 32 (32.65%) Data Modelling
4 27 (27.55%) Kimball Methodology
5 21 (21.43%) DevOps
6 20 (20.41%) SDLC
7 19 (19.39%) Analytics
8 15 (15.31%) Machine Learning
9 13 (13.27%) Change Management
9 13 (13.27%) Data Architecture
9 13 (13.27%) Data Integration
9 13 (13.27%) Information Management
9 13 (13.27%) Migration
9 13 (13.27%) Portfolio Management
9 13 (13.27%) Requirements Gathering
10 12 (12.24%) Data Development
11 10 (10.20%) Problem-Solving
11 10 (10.20%) Scrum
12 8 (8.16%) Data Analysis
12 8 (8.16%) Data Governance
Programming Languages
1 66 (67.35%) SQL
2 29 (29.59%) Python
3 16 (16.33%) T-SQL
4 11 (11.22%) R
5 8 (8.16%) Java
6 7 (7.14%) Data Analysis Expressions (DAX)
7 5 (5.10%) C#
8 4 (4.08%) PL/SQL
9 3 (3.06%) Shell Script
10 2 (2.04%) Perl
10 2 (2.04%) SAS Macro
10 2 (2.04%) Scala
11 1 (1.02%) Bash Shell
11 1 (1.02%) BeanShell
11 1 (1.02%) JavaScript
11 1 (1.02%) PowerShell
11 1 (1.02%) SOQL
11 1 (1.02%) VBA
11 1 (1.02%) VC++
Qualifications
1 6 (6.12%) SC Cleared
1 6 (6.12%) Security Cleared
2 3 (3.06%) Degree
3 2 (2.04%) AWS Certification
3 2 (2.04%) Computer Science Degree
Quality Assurance & Compliance
1 11 (11.22%) Solvency II
2 7 (7.14%) GDPR
3 5 (5.10%) QA
4 4 (4.08%) Data Quality
4 4 (4.08%) IFRS
System Software
1 4 (4.08%) Docker
2 1 (1.02%) Apache Flume
2 1 (1.02%) HDFS
2 1 (1.02%) Virtual Machines
Systems Management
1 5 (5.10%) Kubernetes
2 4 (4.08%) Kibana
3 3 (3.06%) Grafana
3 3 (3.06%) Kubeflow
3 3 (3.06%) Terraform
4 1 (1.02%) Control-M
4 1 (1.02%) Oozie
Vendors
1 20 (20.41%) Microsoft
2 14 (14.29%) Informatica
3 11 (11.22%) Oracle
4 8 (8.16%) Alteryx
5 6 (6.12%) Tableau
6 4 (4.08%) Cadence
6 4 (4.08%) Cloudera
6 4 (4.08%) SAP
7 3 (3.06%) Google
8 2 (2.04%) Adobe
8 2 (2.04%) DocuSign
8 2 (2.04%) IBM
8 2 (2.04%) Pega
9 1 (1.02%) BMC
9 1 (1.02%) Cognos
9 1 (1.02%) Demandware
9 1 (1.02%) MapR
9 1 (1.02%) Salesforce.com
9 1 (1.02%) ServiceNow
9 1 (1.02%) Talend