> Markdown version of [/jobs/ext/4608229-etl-team-lead](https://www.wearedevelopers.com/jobs/ext/4608229-etl-team-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # ETL Team Lead - **Company:** Canal Insurance - **Location:** Greenville, SC, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Automation of Tests, Code Review, Computer Programming, Databases, Data as a Services, Extract Transform Load (ETL), Fraud Prevention and Detection, PostgreSQL, Microsoft SQL Server, Oracle Databases, Windows PowerShell, Scrum Methodology, Power BI, Kusto Query Language, DataOps, SAP (Applications), PL-SQL, SQL Databases, SQL Server Integration Services, Data Streaming, Transact-SQL, Management of Software Versions, Scripting, Data Ingestion, Azure Data Factory, Sap Business Objects, Event Driven Architecture, Data Lakes, Collibra, Hubspot, Code Restructuring, Stream Analytics, Data Pipelines, Guidewire, Databricks - **Published:** November 6, 2026 - **Apply:** https://www.careerbuilder.com/job-details/etl-team-lead-greenville-sc--c9db1d3f-5665-450c-a796-21ac45814f7a ## About the Role Team Lead/Manager, Database Extract Transform and Load (ETL), Insurance, Life Insurance, Flexible Spending Accounts, Employee Assistance Plan, Team Lead/Manager, Database Extract Transform and Load (ETL), Production Support, Operational Support ## Description 1. Production Support, Operations & Reliability + The ETL Team Lead owns end-to-end operational support for Canal's existing data stack: o Monitor daily ETL loads across SQL jobs, DHIC (GW DataHub and InfoCenter) and legacy SSIS packages. o Work with AMS team where necessary to troubleshoot pipeline failures, performance issues, schema mismatches, permissions issues, and cloud resource failures. o Work with AMS team where necessary to perform root-cause analysis and to implement permanent fixes. o Ensure SLA adherence and on-time delivery of critical reporting datasets for scheduled ETL jobs . o Provide direction for both AMS and ETL Developers for Legacy & Current ETL maintenance. o Refactor or retire outdated or redundant ETL processes. 2. 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 + Oracle PL-SQL Scripting + SAP BODS (SAP BusinessObjects Data Services) + PostgreSQL Scripting 3. Operational Excellence + Work with AMS team to assist with the creation and/or enhancement of operational runbooks, SOPs, monitoring dashboards, and incident response workflows. + Partner with other IT operational segments, business SMEs, and AMS team to minimize downtime and to ensure that business SLAs are met. + Improve upon existing, as well as implement new proactive for daily processing. 4. Business Continuity + Work with AMS team to ensure development support coverage for critical data pipelines (rotation-based). + Support month-end and quarter-end financial reporting cycles. + Coordinate production releases and validate deployments. + The ETL Tech Lead will become the steady-state technical owner of the entire data operations layer during the Canal modernization journey. 5. Technical Leadership & Collaboration + Serve as technical lead guiding onshore/offshore developers. + Review code, enforce best practices, and mentor junior engineers. 6. Partner with Scrum Masters, Project Mangers, Enterprise Architecture, QA Automation, Change Management, and AMS support teams. 7. Data Ingestion, ETL/ELT Development & Optimization + Develop reusable ingestion patterns for Guidewire DataHub and InfoCenter, HubSpot, Telematics, and other facets of the business. + Work with Canal Architects to modernize existing ETL workloads using Delta Lake, Medallion Architecture, and Fabric Lakehouse. + Build scalable data ingestion pipelines using potential upcoming technology (Azure Data Factory, MS Fabric , Databricks, Synapse Pipelines, etc.). + Work to bring in Internal and External integrations data into the platform. 8. Real-Time, Streaming & Event-Driven Engineering + Proven experience designing and implementing real-time data pipelines using Event Hub, Fabric Real-Time Analytics, Databricks Structured Streaming, and KQL-based event processing. + Develop and enable real-time operational insights and automation capabilities-including Telematics alerting, FNOL automation, and fraud/VNOS/VNOP detection-through event-driven architectures and streaming analytics. 9. Modern Azure Data Stack Leadership + Lead the strategy, design, and engineering of Canal's modern Azure data ecosystem using next-generation tools and Medallion Architecture, including: o Implementing Medallion Architecture (Bronze/Silver/Gold) across Fabric Lakehouse, Warehouse, Eventhouse, and KQL Database. o Leveraging Delta tables with schema enforcement, ACID compliance, and versioning. 10. Data Modeling, Curation & Governance + Develop curated, analytics-ready datasets to support Power BI, operational reporting, and advanced analytics use cases. + Assist Canal architect with implementation of Data Governance tools. + Establish robust data quality, validation, alerting, and observability frameworks to maintain accuracy, consistency, and trust in enterprise data. 11. AI/ML Data Enablement (Optional) + Prepare ML-ready datasets for pricing, risk, fraud detection, underwriting, claims leakage, and predictive insights.