Snowflake Architect & Developer

Posted Yesterday
Be an Early Applicant
Hyderabad, Telangana, IND
In-Office
Expert/Leader
Big Data • Cloud • Analytics • Consulting
The Role
Design and govern Snowflake data platforms, including ingestion, modeling, security, performance, cost optimization, and data sharing. Build data pipelines, applications, and AI solutions using Snowflake Cortex, RAG, semantic models, and natural-language-to-SQL. Develop with SQL, Python, dbt, Snowpark, and Cortex Code, while establishing CI/CD, DataOps, governance, and responsible AI practices. Lead design reviews, mentor developers, and translate business requirements into technical roadmaps.
Summary Generated by Built In

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.


Skills Required

  • BTech, MTech, or MCA degree
  • 8+ years of experience in data engineering, data warehousing, or architecture
  • 3+ years of hands-on Snowflake experience
  • Expert SQL skills
  • Strong Python skills
  • Hands-on experience with Snowflake Cortex AI, including LLM Functions, Cortex Search, Cortex Analyst, or Cortex Agents
  • Practical experience using Cortex Code or comparable AI coding assistants in data engineering workflows
  • Deep knowledge of Snowflake internals, including micro-partitioning, clustering, caching, query profiling, and workload management
  • Experience with data modeling and ELT frameworks; dbt preferred
  • Experience with orchestration tools such as Airflow
  • Experience with at least one AWS cloud service or environment
  • Strong understanding of data security, governance, and compliance
  • Excellent communication and stakeholder management skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Dublin, OH
414 Employees
Year Founded: 2018

What We Do

DATAECONOMY is a global, cloud-first data and AI consultancy delivering enterprise-grade solutions through an innovative intellectual-property suite. Its work spans data and BI platform modernization, self-service AI, data mesh and fabric, master data management, governance, cloud enablement, digital engineering, knowledge graphs, and machine lakes supporting cybersecurity and financial-crime use cases for enterprise clients.

Similar Jobs

Optum Logo Optum

Technical Product Manager

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Hyderabad, Telangana, IND
160000 Employees

Optum Logo Optum

Senior Data Engineering Lead

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Hyderabad, Telangana, IND
160000 Employees

Optum Logo Optum

Technical Product Manager

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Hyderabad, Telangana, IND
160000 Employees

Optum Logo Optum

Senior Coding Quality Analyst

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Hyderabad, Telangana, IND
160000 Employees

Similar Companies Hiring

Scotch Thumbnail
Artificial Intelligence • eCommerce • Fintech • Payments • Retail • Software • Analytics
US
35 Employees
Milestone Systems Thumbnail
Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account