Snowflake Lead – Data Engineering

Delan Associates, Inc; New York, Town of Texas (NY, WI); On-site; USD 150,000 - 190,000; Full time

Job summary

Delan Associates, Inc is seeking a Snowflake Lead for Data Engineering to drive on-site data platform initiatives in New York. The role demands 12+ years in data engineering, 8+ years in Snowflake development, and 4+ years of technical leadership across onshore and offshore teams, with P&C insurance domain expertise.

Responsibilities include advanced Snowflake development, SQL optimization, data modeling, and leading data pipelines (ELT/ETL) with Talend.

Qualifications

• 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.

Skills

Snowflake

SQL

Python

ETL/ELT

Data modeling

CI/CD for Snowflake

AWS

Data Warehousing

Leadership

Talend ETL

Qlik Replicate

Snowflake Cortex AI

Real-time ingestion

Production support

SQL optimization

Stakeholder communication

Tools

Talend Open Studio

Qlik Replicate

Snowflake Cortex AI

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