ETL Team Lead

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 specializes in insurance for commercial trucking and specialty transportation operations. Canal was founded in 1939 and is located in Greenville, South Carolina. At Canal, we recognize that our success would not be possible without the hard work and dedication of our employees. We know that happiness and productivity go hand in hand, and to that end, we consciously cultivate a culture that enables us to recruit and retain the very best talent in the business.

A Culture With YOU in Mind

• Located in beautiful downtown Greenville, SC
• Employee referral program
• Casual dress code
• Innovation-focused & customer-centric
• 80+ years of industry expertise
• Committed to giving back to our community
• Unquestioned integrity and commitment

Benefits at Canal

• 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

Major Accountabilities

• Production Support, Operations & Reliability
  • The ETL Team Lead owns end-to-end operational support for Canal's existing data stack:
    • 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 programmingOracle PL-SQL Scripting
  • SAP BODS (SAP BusinessObjects Data Services)
  • PostgreSQL Scripting
• 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.
• 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.
• Technical Leadership & Collaboration
  • Serve as technical lead guiding onshore/offshore developers.
  • Review code, enforce best practices, and mentor junior engineers.
• Partner with Scrum Masters, Project Mangers, Enterprise Architecture, QA Automation, Change Management, and AMS support teams.
• 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.
• 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.
• Lead the strategy, design, and engineering of Canal’s modern Azure data ecosystem using next-generation tools and Medallion Architecture, including:
  • Implementing Medallion Architecture (Bronze/Silver/Gold) across Fabric Lakehouse, Warehouse, Eventhouse, and KQL Database.
  • Leveraging Delta tables with schema enforcement, ACID compliance, and versioning.
• 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.
• AI/ML Data Enablement (Optional)
  • Prepare ML-ready datasets for pricing, risk, fraud detection, underwriting, claims leakage, and predictive insights.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.