Snowflake Engineer (Cortex & Data Engineering)
Core
Design, develop, and optimize Snowflake data solutions supporting enterprise analytics, reporting, and data-driven decision-making.
Role type
Senior IC Snowflake Data Engineer (Cortex & ELT)
Builds
Scalable batch and near real-time ingestion/processing pipelines, enterprise-grade ELT/ETL frameworks, and AI-powered data solutions.
Domain
Cloud Data Warehousing & AI/ML
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Snowflake architecture, complex SQL development, stored procedures/UDFs/views, ELT/ETL pipeline design, performance tuning, RBAC/governance, CI/CD, Git, Infrastructure as Code
Preferred skills
Snowflake Cortex, Snowpark (Python), dbt, RAG/vector search, LLM applications, Python development, regulated industry experience
Technologies
Snowflake Cortex, Snowpark, AWS, Azure, GCP, dbt, Python, SQL, Git, CI/CD
Responsibilities
Design and optimize Snowflake data solutions for enterprise analytics; build scalable ingestion and processing pipelines using Snowpipe, Streams, Tasks, and Dynamic Tables; develop advanced SQL-based solutions including stored procedures and UDFs; implement enterprise-grade ELT/ETL pipelines; tune query performance and workload optimization; implement secure, governed data solutions using RBAC and data sharing; design and support data warehouse, mart, and lakehouse architectures; integrate data from cloud, on-premises, API, and SaaS sources; provide production support, monitoring, and incident resolution; support AI and advanced analytics initiatives using Snowflake Cortex and Snowpark.
