PLEASE NOTE: It is a 100% Onsite position in New York, NY JOB DESCRIPTION: 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 ownershipfrom ingestion and transformation to modelling, 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...