Apply Now

ETL Tech Lead [Canal Insurance]

• Posted 30+ days ago • Updated 56 minutes ago

Contract W2

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

Databricks
Change Management
Power BI
Guidewire
Data Lakes
databases
Collibra
PostgreSQL
dashboards
Automation
Enterprise Architecture
data quality
data pipelines
architecture
Data Modelling
Accounting
governance
Azure Data Factory
Event Driven Architecture
Incident Response
Maintenance
Business Continuity
Mentoring
Code Review
Coordination Skills
Extract Transform Load (ETL)
Leadership
Data Ingestion
Automation of Tests
Insurance Claim Processing
Stock Control
Artificial Intelligence
Microsoft SQL Server
PL-SQL
Computer Programming
Code Restructuring
Management of Software Versions
Data Streaming
Offshore Work
Operational Excellence
Analytical Procedures
Oracle Databases
DataOps
Financial Underwriting
Operational Support and Analysis
Kusto Query Language
Telematics
Curation
Data as a Services
Development Support
Digital Enablement
Fraud Prevention and Detection
Hubspot
Operational Reporting

Databricks
Change Management
Power BI
Guidewire
Data Lakes
databases
Collibra
PostgreSQL
dashboards
Automation
Enterprise Architecture
data quality
data pipelines
architecture
Data Modelling
Accounting
governance
Azure Data Factory
Event Driven Architecture
Incident Response
Maintenance
Business Continuity
Mentoring
Code Review
Coordination Skills
Extract Transform Load (ETL)
Leadership
Data Ingestion
Automation of Tests
Insurance Claim Processing
Stock Control
Artificial Intelligence
Microsoft SQL Server
PL-SQL
Computer Programming
Code Restructuring
Management of Software Versions
Data Streaming
Offshore Work
Operational Excellence
Analytical Procedures
Oracle Databases
DataOps
Financial Underwriting
Operational Support and Analysis
Kusto Query Language
Telematics
Curation
Data as a Services
Development Support
Digital Enablement
Fraud Prevention and Detection
Hubspot
Operational Reporting

Summary

Client: Canal Insurance

Role: ETL Team Lead

Location: Greenville, SC

Type : Contract to Hire

Visa: required non sponsorship visa candidates

Rate: Competetive

Job Details

Description

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 programming
- Oracle 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.
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.
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:
  - 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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 80117324
Position Id: 2026-2363
Posted 30+ days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

ETL Engineer

St. Louis, Missouri

•

Today

Description Location: Hybrid in St Louis, MO Job Type: Contract-to-hire Company: The name of our partner organization will be disclosed during the interview process. This is not a direct role with LaunchCode; it is a position through LaunchCode, working with one of our partner companies. Disclaimer: We are unable to provide work sponsorship for this role. We are unable to consider candidates for this role who have a current or future work sponsorship need (this includes those holding extende

Full-time

USD 58.00 - 82.00 per hour

ETL Manager

Colorado

•

Today

ETL Manager Greenwood Village, CO (4 days onsite, 1 day remote) Hybrid Role $60 - $70 per hour Long-term ongoing contract with potential for conversion ABOUT THE ROLE Our client's Video Insights organization is seeking an ETL Manager to join their high-priority data group in Greenwood Village, CO. This role begins as an individual contributor, providing support to ETL developers and learning the environment, technology stack, and development patterns. Within a few months, you will transition to

Contract

$60.00 - $70.00

Data Engineer

Norfolk, Virginia

•

Today

Description: On-site in Norfolk, VA Our client seeks a Data Engineer to design, build, integrate, and sustain secure enterprise data solutions that enable reliable analytics, reporting, operational insight, and informed decision-making. The role develops scalable data pipelines, integrates diverse data sources, improves data quality and availability, and supports cloud and on-premises platforms in a mission-critical environment. The Data Engineer collaborates with business intelligence, cybers

Contract

Staff Software Engineer

Austin, Texas

•

Today

CDK Global, LLC seeks Staff Software Engineer at its facility located at 11809 Domain Drive, Suite 200, Austin, TX 78758. #LI-DNI JOB DESCRIPTION: Apply specialized expertise in large-scale data engineering, ETL architecture, database design, and cloud migration across Azure and AWS platforms. Architect and implement enterprise ETL and data processing systems using Azure Data Factory, SSIS, AWS Glue, and cloud storage platforms such as Azure Data Lake and AWS S3. Design and maintain data mode

Full-time

Search all similar jobs