ETL Team Lead

Canal Insurance Company•Greenville, SC

22h

About The Position

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 Career growth & advancement opportunities Comprehensive benefits package 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

Requirements

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
Proven experience designing and implementing real-time data pipelines using Event Hub, Fabric Real-Time Analytics, Databricks Structured Streaming, and KQL-based event processing.

Responsibilities

Production Support, Operations & Reliability
Maintain and improve existing pipelines
Operational Excellence
Business Continuity
Technical Leadership & Collaboration
Partner with Scrum Masters, Project Mangers, Enterprise Architecture, QA Automation, Change Management, and AMS support teams.
Data Ingestion, ETL/ELT Development & Optimization
Real-Time, Streaming & Event-Driven Engineering
Modern Azure Data Stack Leadership
Data Modeling, Curation & Governance
AI/ML Data Enablement (Optional)