DataEconomy Technology/Software

Snowflake Architect & Developer

Hyderabad, India Hybrid Full-time

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