Lead Snowflake Data Engineer

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.

Roles and 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
Design systems that perform reliably at scale
Balance performance cost and maintainability
Operate independently within complex enterprise environments
Deliver production-grade scalable data solutions

Required Skills:
10 years of experience or equivalent ownership of production-grade data platforms
Deep expertise in Snowflake (data modeling performance tuning optimization)
Strong experience with Python and PySpark
Advanced SQL expertise
Proven ability to design and deliver end-to-end data pipelines in cloud environments (AWS preferred)
Ownership of at least one production-grade Snowflake pipeline end-to-end
Strong foundation in dimensional modeling (star/snowflake schemas)
Experience with ELT/ETL design patterns
Experience with data marts and optimization strategies
Experience with distributed data processing and large-scale datasets
Hands-on experience with Snowflake Cortex AI integration
Strong understanding of data governance security and compliance
Experience with Snowflake warehouse scaling modes clustering keys and optimization strategies
Strong communication and stakeholder management skills

Preferred Skills:
Working knowledge of or similar frameworks
Vendor-facing consulting experience
Experience in financial services environments
Strong mentoring and leadership experience