Enter a job title or keyword
Lead Snowflake Data Engineer New York City, NY
Job Location:
Job Location:
New York City, NY - USA
Monthly Salary:
Not provided by the employer
Monthly Salary:
Posted:
19 May 2026 (30+ days ago)
Posted:
Application Deadline:
16 August 2026
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Title: Lead Snowflake Data Engineer
New York City NY
Position: Onsite/ Contract
Glider Assessment Required: Yes
Interview Mode: Virtual F2F(Local Only)
JD:
We are seeking a Lead Snowflake Data Engineer to design own and deliver end-to-end data engineering solutions in modern cloud environments. This role focuses on building scalable high-performance data pipelines using Snowflake and Cortex AI with full lifecycle ownership-from ingestion and transformation to modeling optimization and consumption.
Key Responsibilities
Lead the design and development of end-to-end ELT pipelines using Snowflake
Architect scalable data models optimized for performance cost and analytics consumption
Build and maintain backend data services using Python and PySpark
Leverage Snowflake Cortex AI to enable advanced analytics and intelligent data products
Drive performance tuning across pipelines including query optimization clustering and warehouse scaling
Enforce best practices in data governance security and compliance
Collaborate across business analytics and engineering teams to deliver high-quality solutions
Provide technical leadership and mentorship to engineering teams
Communicate architecture decisions and trade-offs effectively in client-facing environments
Required Qualifications & Technical Expertise
10 years of experience or equivalent ownership of production-grade data platforms
Deep expertise in:
o Snowflake (data modeling performance tuning optimization)
o Python and PySpark
o Advanced SQL
Proven ability to design and deliver end-to-end data pipelines (ingestion transformation modeling consumption) in cloud environments (AWS preferred)
Required: Ownership of at least one production-grade Snowflake pipeline end-to-end
Strong foundation in modern data warehousing:
o Dimensional modeling (star/snowflake schemas)
o ELT/ETL design patterns
o Data marts and optimization strategies
Experience with distributed data processing and large-scale datasets
Hands on experience with Snowflake Cortex AI integration
Working knowledge of or similar frameworks
Strong understanding of data governance security and compliance
Ability to:
o Clearly explain and defend architectural decisions
o Design systems that perform reliably at scale
o Balance performance cost and maintainability
Technical Depth (Must Be Demonstrated)
Candidates should be able to clearly explain and apply the following in real-world scenarios:
Snowflake Performance & Scaling
Warehouse scaling modes (auto-scale multi-cluster) and when to use them
Clustering keys and performance trade-offs
Cost vs performance optimization strategies
Snowflake Storage & Optimization
Micro-partitioning and its impact on pruning and query performance
Practical optimization techniques for large datasets
End-to-End Pipeline Design
Designing a complete ELT pipeline using Snowflake
Deciding where transformations should occur (Snowflake vs external processing)
Ensuring scalability maintainability and performance across the pipeline Engagement.
---
Location
New York New York United States
