Key Responsibilities
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 DataHub and InfoCenter) 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:
1 Microsoft SQL Server Database programming
2 T-SQL Scripting
3 SQL Server Integration Services
4 Microsoft Powershell
5 Guidewire DataHub and InfoCenter
6 Oracle Database programming
7 Oracle PL-SQL Scripting
8 SAP BODS (SAP BusinessObjects Data Services)
9 PostgreSQL Scripting

ETL Lead

Similar Other Jobs