ETL Lead

Job Title: ETL Team Lead
Location-Type: Remote (Greenville, SC preferred; onsite required first week for training)
Start Date: ASAP
Duration: Contract-to-Hire (duration to be confirmed)
Compensation Range: $60-64/hr W2 during contract period, $120-125K bonus conversion
Benefits: Eligible for Health, Dental, Vision, and 401K
Visa Sponsorship: Not eligible for visa sponsorship

Job Description:
The ETL Team Lead serves as the primary technical owner of the organization's end-to-end data operations, leading onshore and offshore teams to maintain legacy platforms while driving modernization onto a next-generation Azure data stack.

Job Summary
Monitor and support daily ETL loads across SQL jobs, legacy SSIS packages, and Guidewire DataHub and InfoCenter environments, ensuring SLA adherence and on-time delivery of critical reporting datasets.
Troubleshoot and resolve pipeline failures, performance issues, schema mismatches, and cloud resource failures in collaboration with the AMS team, performing root-cause analysis and implementing permanent fixes.
Provide technical direction to onshore and offshore ETL developers for both legacy platform maintenance and new Azure-based development, reviewing code and enforcing best practices.
Refactor or retire outdated ETL processes and maintain existing pipelines spanning SQL Server, SSIS, Oracle, PostgreSQL, SAP BODS, and PowerShell.
Design and build scalable data ingestion pipelines using Azure Data Factory, Microsoft Fabric, Databricks, and Synapse Pipelines, aligned to Medallion Architecture (Bronze, Silver, Gold).
Develop reusable ingestion patterns for insurance source systems including Guidewire DataHub and InfoCenter, HubSpot, and Telematics.
Support production releases, coordinate deployments, validate changes, and provide coverage during month-end and quarter-end financial reporting cycles.
Partner with Scrum Masters, Project Managers, Enterprise Architecture, QA Automation, Change Management, and business SMEs to minimize downtime and ensure business SLAs are met.

Minimum Requirements:
8 years of ETL design and development experience, including hands-on SQL Server management, SSIS, SSRS, and T-SQL scripting.
2-4 years of experience building ETL and ELT solutions in Azure, including demonstrated experience with Microsoft Fabric.
Experience working with insurance platforms and the ability to speak substantively to insurance industry data environments.
Proven experience leading and coordinating onshore and offshore development teams in an ETL or data engineering context.
Strong production support background including performance tuning, incident response, and root-cause analysis.
Consistent, long-term engagement history on positions (candidates with a pattern of short contracting stints will not be considered).

Preferred Qualifications:
Experience with Guidewire DataHub and InfoCenter, or demonstrated willingness and ability to learn the platform.
Familiarity with Delta Lake, Medallion Architecture, and Fabric Lakehouse modernization patterns.
Experience with real-time and event-driven pipeline design using Event Hub, Databricks Structured Streaming, or KQL-based processing.
Experience with Oracle PL-SQL, SAP BODS, or PostgreSQL in a data operations context.
Familiarity with data governance frameworks, data quality observability tools, and enterprise data modeling practices.