Snowflake Lead – Data Engineering

Delan Associates, Inc

Apply to this job
NY, TX Until 9/28/2026 12+ years exp First posted July 30, 2026 Last posted July 30, 2026
Job description

Snowflake Lead – Data Engineering

San Antonio, TX / New York, NY (Onsite)

Local to San Antonio, TX / New York, NY only!

P&C / Specialty Insurance exp Must

Must-Have Skills – Snowflake Lead (Data Engineering)

* 12+ years of Data Engineering / Analytics experience

* 8+ years of hands-on Snowflake development and production support

* 4+ years as a Technical Lead managing onshore/offshore teams

* 4+ years in Property & Casualty (P&C) Insurance domain

* Strong experience with Snowflake (Advanced SQL, Snowpipe, Streams, Tasks, Performance Tuning, Security/RBAC)

* Hands-on expertise in Talend ETL / Talend Open Studio

* Strong Python programming (including Snowpark preferred)

* Experience with Snowflake Cortex AI / AI-enabled analytics

* Strong AWS Cloud data platform experience

* Expertise in Data Engineering, ELT/ETL pipelines, CDC, and Data Modeling

* Experience with CI/CD for Snowflake deployments

* Production support, Root Cause Analysis, and Month-End Closing activities

* Knowledge of Qlik Replicate and real-time/batch data ingestion

* AI/ML data engineering experience (feature engineering, ML data pipelines, fraud detection, risk scoring)

* Strong SQL optimization, query tuning, and warehouse performance optimization

* Excellent stakeholder communication and customer-facing leadership skills

About this role

Summary

Lead data engineering projects using Snowflake, ETL, Python, AI, and cloud technologies.

Job title

Snowflake Lead – Data Engineering

Experience level

12+ years

Minimum experience

12+ years exp

Industry

insurance

Location requirements

onsite in NY or TX, local to San Antonio or New York

Salary

Not specified

Management role

Yes

Skills & keywords

Required skills

snowflakesqltalendpythonawsetldata modelingci/cdperformance tuningsecurity/rbac

Preferred skills

snowparksnowflake cortex aiml data pipelinesreal-time data ingestionfraud detection

Specializations

snowflakeetlpythonaicloud
Locations

Structured locations inferred from the posting.

New York, NY, USA

On-site City

Txurdinaga, Otxarkoaga - Txurdinaga, Bilbao, Bizkaia, Spain

On-site City