Snowflake Architect & Developer
Job Summary
Experience Level: 10 - 15years
Location: Hyderabad
Qualification: BTech/MTech/MCA
Mode of Work: Hybrid
We are looking for a hands-on Snowflake Architect & Developer to design build and govern our Snowflake data platform and the AI-driven solutions on top of it. You will define the target architecture write production-grade code and use Snowflake Cortex AI and Cortex Code (CoCo) to deliver intelligent applications and speed up engineering delivery. You will work closely with data engineers analysts data scientists and business stakeholders.
Architecture & Platform Design
- Define and own the end-to-end Snowflake architecture: ingestion storage transformation serving and consumption layers.
- Design scalable data models (dimensional Data Vault medallion) and multi-account/multi-environment strategies.
- Establish standards for performance cost optimization (warehouse sizing resource monitors query tuning) and FinOps.
- Implement security and governance: RBAC row/column-level security masking policies tagging lineage and data sharing/marketplace patterns.
Cortex AI Solution Development
- Build GenAI and ML solutions using Cortex AI features such as LLM Functions (COMPLETE SUMMARIZE CLASSIFY EXTRACT SENTIMENT TRANSLATE) Cortex Search Cortex Analyst Cortex Agents and Document AI.
- Design RAG pipelines over structured and unstructured data including chunking embeddings and vector search.
- Develop natural-language-to-SQL experiences using semantic models and verified queries.
- Evaluate monitor and tune AI workloads for accuracy latency cost and responsible AI use.
CoCo (Cortex Code) Enablement & Development
- Use Cortex Code to accelerate SQL Python dbt and Snowpark development debugging refactoring and documentation.
- Define team guidelines prompt patterns and guardrails for AI-assisted development in Snowflake environments.
- Integrate CoCo into the SDLC including code review testing and CI/CD while maintaining governance and security.
Data Engineering & Development
- Build ELT/ETL pipelines using Snowpipe Streams Tasks Dynamic Tables and Snowpark.
- Develop stored procedures UDFs/UDTFs and external functions.
- Implement ingestion from cloud storage APIs CDC tools and streaming sources (Kafka etc.).
- Build Streamlit in Snowflake apps and Native Apps where applicable.
Delivery & Leadership
- Lead design reviews mentor developers and enforce coding and architecture standards.
- Translate business requirements into technical roadmaps and effort estimates.
- Set up CI/CD Infrastructure as Code and DataOps practices.
- 8 years in data engineering data warehousing or architecture; 3 years of hands-on Snowflake experience.
- Expert SQL and strong Python.
- Hands-on experience with Snowflake Cortex AI (LLM functions Cortex Search Cortex Analyst or Agents).
- Practical experience using Cortex Code (CoCo) or comparable AI coding assistants in data engineering workflows.
- Deep knowledge of Snowflake internals: micro-partitioning clustering caching query profiling and workload management.
- Experience with data modeling ELT frameworks (dbt preferred) and orchestration tools (Airflow etc.).
- Experience on at least one AWS cloud.
- Strong understanding of data security governance and compliance.
- Excellent communication and stakeholder management skills.
- Comprehensive Medical Coverage:
Health insurance of INR 7.0 Lakhs for you and your family (up to 6 members) ensuring complete peace of mind. - Robust Protection Plans:
Group Personal Accident Insurance and Group Term Life Insurance to safeguard you and your loved ones. - Retirement Benefits:
PF and Gratuity provided as per standard government regulations. - Flexible Work Options:
Enjoy hybrid work arrangements & flexible working hours. - Generous Leave Policy:
21 days of annual leave in addition to 10 company-declared holidays. - Employee Well-being Spaces:
Access to a dedicated break-out area with round-the-clock refreshments for relaxation and rejuvenation.
Required Skills:
Snowflake AWS Cortex AI
Required Education:
Any other degree