Senior ETL Tech Lead - Insurance Data Ops

Delan Associates, Inc; Greenville (SC); On-site; USD 110,000 - 160,000; Full time

Job summary

Delan Associates, Inc. seeks an ETL Lead in Insurance domain to own end-to-end data operations. You will supervise production support, monitor ETL loads across SQL workloads, and guide onshore/offshore developers to maintain critical datasets.

Responsibilities include troubleshooting pipeline issues, implementing permanent fixes, refining runbooks, and driving modernization with Delta Lake, Fabric Lakehouse, and Medallion-style architectures. Onsite in Greenville, SC.

Qualifications

• 12+ years of ETL/Data Warehousing experience.
• Strong SQL, SSIS, and ETL design & development skills.
• Experience leading onshore/offshore teams and reviews.
• Proven ability to troubleshoot complex data pipelines and root-cause analysis.

Responsibilities

• Own end-to-end operational support for the data stack and ensure SLA adherence.
• Monitor daily ETL loads across SQL jobs and data hubs; troubleshoot failures and performance issues.
• Provide direction to AMS and ETL developers; mentor juniors and review code.
• Refactor or retire outdated ETL processes and build scalable ingestion pipelines.
• Modernize workloads using Delta Lake, Medallion Architecture, Fabric Lakehouse; explore Azure Data Factory/Databricks/Synapse pipelines.

Skills

Production Support

Operations & Reliability

Mentoring & Coaching

Technical Leadership

Code Review

Cross-functional Collaboration

ETL Best Practices

Tools

SQL Server

T-SQL

SQL Server Integration Services (SSIS)

Microsoft PowerShell

Guidewire Data Hub

Info Center

Oracle PL-SQL

Oracle Database

SAP BODS

Delta Lake

Databricks

Fabric Lakehouse

Job description

Delan Associates, Inc. seeks an ETL Lead in Insurance domain to own end-to-end data operations. You will supervise production support, monitor ETL loads across SQL workloads, and guide onshore/offshore developers to maintain critical datasets.

Responsibilities include troubleshooting pipeline issues, implementing permanent fixes, refining runbooks, and driving modernization with Delta Lake, Fabric Lakehouse, and Medallion-style architectures. Onsite in Greenville, SC.