Snowflake Lead Data Engineering

Siri InfoSolutions Inc; New York (NY); On-site; USD 110,000 - 130,000; Full time

Benefits offered by this job

Discretionary Incentive

Medical Coverage

Parental Leaves

Training Reimbursement

Commuter Benefits

Job summary

Synchrony Systems Inc. seeks a Snowflake Lead Data Engineer for an onsite full-time role in New York, NY. The candidate will design and lead Snowflake-based data platforms, integrate AI/ML use cases, and coordinate with offshore teams. Strong Snowflake and Python skills plus insurance domain knowledge are required.

Role demands 8+ years of experience, base salary range of $110,000–$130,000 per year, with benefits. W2 employment only, on-site 5 days.

Qualifications

• Extensive Snowflake experience with data modeling, schema design and security.
• Hands-on Python development for data pipelines and AI enablement.
• Experience integrating Cortex AI or similar AI capabilities on cloud platforms.
• Insurance domain knowledge (P&C or specialty) is strongly preferred.
• Proficient in ETL tools, notably Talend ETL, and cloud data platforms (AWS).

Responsibilities

• Lead onsite for end-to-end Snowflake solution design and development.
• Oversee Snowflake schemas, tables, views, streams, tasks, and Snowpipes.
• Enforce performance optimization practices including warehouse sizing and query tuning.
• Own Snowflake security architecture: RBAC, data masking, row/column security.
• Coordinate code promotion across environments using CI/CD.
• Develop batch and near real-time ingestion pipelines using Talend, Qlik Replicate, Snowpipe.
• Ensure data quality checks, reconciliation, and schema drift handling.
• Guide integration from insurance source systems into Snowflake.
• Enable AI/ML use cases on Snowflake and support Python-based data processing.
• Support ML models lifecycle with data engineering and monitoring.

Skills

Snowflake

Cortex AI

Python

Insurance Domain

Talend ETL

Job description

My name is Sudher Vurakaranam, and I represent Synchrony Systems Inc. We are currently supporting an implementation partner on a full-time opportunity. Based on your background, your experience may align well with this role.

Position Details:

Role:

Snowflake Lead Data Engineering

Locations:

New York, NY

Employment Type:

Full-Time (W2 only)

Work Model:

5days Onsite

Compensation: Base salary range of

$110,000 $130,000 per year, plus benefits

Experience Range

Min 8+ Years and Max 25 Years

Work Authorization

Who can work on a full-time W2 basis without sponsorship

Note:

• This role is not open for C2C/C2H/1099 or any contract arrangements
• This opportunity is available for candidates who can work on a full-time W2 basis without sponsorship.

Job Description

Must Have Technical/Functional Skills:

Snowflake, Cortex AI, Python and Insurance Domain on AWS Cloud, Talend ETL

Roles & Responsibilities

The Snowflake Lead will serve as the onsite technical lead for enterprise data platform, responsible for end to end Snowflake solution design, development leadership, and AI/advanced analytics enablement. The role requires deep hands on expertise in Snowflake, strong data engineering fundamentals, and the ability to integrate AI/ML driven use cases into the Snowflake ecosystem while coordinating with offshore teams.

Snowflake Production Support

Perform root cause analysis for job failures and data analysis & fixes

Perform Month End Closing Activities

Snowflake Development & Architecture

Lead design and development of Snowflake schemas, tables, views, streams, tasks, and Snowpipes

Define and enforce best practices for performance optimization (warehouse sizing, clustering, query tuning)

Own Snowflake security architecture: RBAC, role hierarchy, data masking, row/column level security

Oversee promotion of code across environments using CI/CD practices

Data Engineering & Integration

Lead development of batch and near real time ingestion pipelines using Talend / Qlik Replicate / Snowpipe

Ensure data quality checks, reconciliation, and schema drift handling

Guide integration from insurance source systems (Policy, Claims, Billing, Reinsurance) into Snowflake

Provide technical oversight for SQL, Python, and ELT based transformations

AI / Advanced Analytics Enablement

Enable AI/ML use cases on Snowflake, including:

• o Feature engineering datasets for ML models
• o Snowpark (Python) based data processing
• o Integration with external ML platforms (Databricks / SageMaker / Azure ML where applicable)

Support AI driven insights such as:

• o Claims triage & risk scoring
• o Fraud detection inputs
• o Premium leakage and pricing analytics

Guide teams in using Python, SQL, and Snowflake native capabilities for data science workloads

Core Technical Skills

Snowflake: Advanced SQL, Performance Tuning, Security, Snowpipe, Streams & Tasks

Data Engineering: ELT/ETL patterns, data modeling, CDC concepts

Python: Data processing, automation, Snowpark (preferred)

Strong understanding of cloud data platform architecture (AWS preferred)

AI / Analytics Skills

Hands on exposure to AI/ML pipelines (feature preparation, training data creation)

Experience supporting ML models through data engineering and operationalization

Familiarity with Python ML libraries (scikit learn, pandas, NumPy) applied from a data engineering perspective

Understanding of model lifecycle support (data refresh, monitoring, retraining inputs)

Domain & Soft Skills

Insurance domain experience (P&C / Specialty Insurance strongly preferred)

Strong communication skills for onsite customer interaction

Ability to translate business requirements into scalable data & AI solutions

TCS Employee Benefits Summary:

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Thank you for your time and consideration.

Privacy Note:

We respect your online privacy. To unsubscribe from future emails, please reply with "Unsubscribe" in the subject