ETL Lead

Hadiamondstar Software Solutions LLC; South Carolina; On-site; USD 90,000 - 120,000; Full time

Job summary

Canal is seeking an ETL Team Lead to own the end-to-end operational support of the data stack and ensure the success of day-to-day production operations.

You will monitor daily ETL loads across SQL jobs, DHIC DataHub and InfoCenter and collaborate with the AMS team to troubleshoot failures, perform root-cause analysis, and implement permanent fixes while ensuring SLA adherence.

Qualifications

• Experience leading ETL/production support teams.
• Proficient in SQL Server and SSIS.
• Ability to perform root-cause analysis and implement fixes.

Responsibilities

• Own end-to-end operational support for the data stack.
• Monitor daily ETL loads across SQL jobs, DHIC, and SSIS.
• Troubleshoot pipeline failures and permissions issues with the AMS team.
• Perform root-cause analysis and implement permanent fixes.
• Ensure SLA adherence and timely delivery of reporting datasets.
• Guide AMS and ETL Developers for legacy and current ETL maintenance.
• Refactor or retire outdated ETL processes.
• Maintain and improve pipelines using listed technologies.

Skills

ETL operations

Production support

Troubleshooting

Root cause analysis

SLA management

Team leadership

Tools

Microsoft SQL Server

T-SQL

SQL Server Integration Services

Microsoft PowerShell

Guidewire DataHub

Guidewire InfoCenter

Oracle Database

SAP BODS

Job description

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:

• Microsoft SQL Server Database programming
• T-SQL Scripting
• SQL Server Integration Services
• Microsoft Powershell
• Guidewire DataHub and InfoCenter
• Oracle Database programming
• SAP BODS (SAP BusinessObjects Data Services)