Job Title: Snowflake Architect & Developer
Experience Level: 10 - 15years
Location
Hyderabad
Qualification: BTech/MTech/MCA
Mode
of Work: Hybrid
Role Summary
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.
Key Responsibilities
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.
Requirements
- 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.
Benefits
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.
Job description provided by DataEconomy.
View the original posting