ETL Tech Lead — Data Platform & Real-Time Ops

Canal Insurance Company; Greenville (SC); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Basic & Voluntary Life Insurance Plans

Short Term & Long Term Disability

401(k) plan with company match up to 6

Flexible Spending Accounts

Employee Assistance Programs

Generous PTO Plan

Job summary

Canal Insurance Company in Greenville, SC seeks an ETL Team Lead to own end-to-end data pipeline operations, oversee SQL Server, SSIS, and data platforms, and drive reliability across the data stack. You will mentor developers, coordinate with AMS, and lead modernization efforts with Delta Lake, Fabric Lakehouse, and Databricks, enabling real-time insights and robust governance for enterprise reporting.

The role engages cross-functional teams and requires strong leadership in a fast-paced

Responsibilities

• Own end-to-end operational support for Canal's data stack and ensure SLA adherence.
• Monitor daily ETL loads across SQL jobs, DHIC, and legacy SSIS packages.
• Troubleshoot pipeline failures and perform root-cause analysis with AMS.
• Refactor or retire outdated or redundant ETL processes.
• Develop reusable ingestion patterns for Guidewire DataHub, InfoCenter, HubSpot and Telematics.
• Lead onshore/offshore developers, review code, and mentor junior engineers.
• Collaborate with Scrum Masters, Project Managers, Enterprise Architecture and AMS support teams.
• Build real-time data pipelines and analytics using Event Hub, Databricks and Medallion Architecture.

Skills

Technical leadership

Problem solving

Mentoring

SLA management

Cross-team collaboration

Tools

SQL Server

T-SQL

SSIS

PowerShell

Guidewire DataHub

InfoCenter

Oracle PL-SQL

SAP BODS

PostgreSQL

Delta Lake

Databricks

Azure Data Factory

Fabric Lakehouse

Job description

Canal Insurance Company in Greenville, SC seeks an ETL Team Lead to own end-to-end data pipeline operations, oversee SQL Server, SSIS, and data platforms, and drive reliability across the data stack. You will mentor developers, coordinate with AMS, and lead modernization efforts with Delta Lake, Fabric Lakehouse, and Databricks, enabling real-time insights and robust governance for enterprise reporting.

The role engages cross-functional teams and requires strong leadership in a fast-paced