Dataeconomy logo

Snowflake Architect & Developer

Hiring from
India
Work type
Hybrid
Posted

625,822 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

Job Description


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.


Similar jobs

Apply for this job100% free