ETL Lead

Production Support, Operations & Reliability

The ETL Team Lead owns end-to-end operational support for Canal’s existing data stack:

Ensure success of day-to-day production Operations.

Monitor daily ETL loads across SQL jobs, DHIC (GW Data Hub and Info Center) and legacy SSIS packages.

Work with AMS team where necessary to troubleshoot pipeline failures, performance issues, schema mismatches, permissions issues, and cloud resource failures.

Work with AMS team where necessary to perform root-cause analysis and to implement permanent fixes.

Ensure SLA adherence and on-time delivery of critical reporting datasets for scheduled ETL jobs .

Provide direction for both AMS and ETL Developers for Legacy & Current ETL maintenance.

Refactor or retire outdated or redundant ETL processes.

Maintain and improve existing pipelines that utilize the following technologies:

• Microsoft SQL Server Database programming
• T-SQL Scripting
• SQL Server Integration Services
• Microsoft Powershell
• Guidewire Data Hub and Info Center
• Oracle Database programming
• SAP BODS (SAP Business Objects Data Services)