Description

Lead Snowflake development, architecture, and production support for scalable data and AI solutions.

This role is on-site.

Responsibilities

• Lead design and development of Snowflake schemas, tables, views, streams, tasks, and Snowpipes.
• Perform root cause analysis for job failures and execute data analysis and fixes.
• Own Snowflake security architecture including RBAC, role hierarchy, data masking, and row/column level security.
• Define and enforce best practices for performance optimization such as warehouse sizing, clustering, and query tuning.
• Oversee code promotion across environments using CI/CD practices and support month-end closing activities.

Required Skills

• 11+ years of experience in data engineering or related fields.
• Advanced proficiency in Snowflake, including SQL, performance tuning, and security features.
• Strong background in data modeling, ELT/ETL patterns, and CDC concepts.
• Experience with Python for data processing, automation, and CI/CD pipelines.
• Proficiency with Talend and Dbt for data transformation workflows.
• Understanding of cloud data platform architecture, specifically AWS.
• Hands-on exposure to AI/ML pipelines, including feature preparation and model operationalization.

Preferred Skills

• Experience with Snowpark and Python ML libraries (scikit-learn, pandas, NumPy).
• Domain experience in Insurance (P&C / Specialty Insurance).

Key Skills

Education

Any Gradute