Project Leader

Axtria - Ingenious Insights

Dadri

On-site

INR 1,200,000 - 1,800,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Axtria - Ingenious Insights in India is seeking a Snowflake Developer to build and optimize Snowflake-based data lakehouse pipelines and leverage Cortex for AI-enabled transformations. You will implement ELT workflows, manage data quality, and collaborate with data scientists to embed AI/ML logic within Data Lake programs.

The role requires hands-on Snowflake and SQL proficiency, experience with dbt and Airflow, and familiarity with cloud platforms (AWS/Azure/GCP).

Qualifications

  • Hands-on Snowflake experience with data lakehouse architecture.
  • Strong SQL with performance tuning and Snowflake features (Streams, Tasks, Time Travel).
  • Experience with ELT tooling (dbt) and orchestration (Airflow).
  • Familiarity with cloud platforms (AWS/Azure/GCP) and data lake / lakehouse patterns.

Responsibilities

  • Ingest and integrate data into Snowflake data pipelines.
  • Develop and optimize ELT pipelines using Snowflake features.
  • Collaborate with data scientists to enable AI/ML in pipelines.
  • Optimize queries, manage costs, and ensure data quality and governance.

Skills

Snowflake
Advanced SQL
Python
ELT/ETL
dbt
Airflow
AWS
Azure
GCP
RBAC

Tools

dbt
Airflow
Git
CI/CD

Job description

Job Title: Snowflake Developer (Data Lake Program with Snowflake Cortex)
Role Overview

The Snowflake Developer is responsible for building and optimizing data pipelines and analytical datasets within a Snowflake-based data lakehouse. This role also includes leveraging Snowflake Cortex to enable AI-driven data transformations, natural language processing, and intelligent data applications directly within the data platform.

Key Responsibilities
  • Data Ingestion & Integration
  • Develop and maintain scalable data ingestion pipelines (batch and near real-time).
  • Load data from databases, APIs, files, and streaming systems into Snowflake.
  • Handle structured and semi-structured data (JSON, Parquet, Avro, CSV).
  • Integrate Snowflake with cloud storage platforms (S3, Azure Data Lake, GCS).
  • Data Transformation (ELT)
  • Build ELT pipelines using Snowflake SQL and native features (Streams, Tasks, Dynamic Tables).
  • Implement transformations across Bronze, Silver, and Gold layers.
  • Use tools like dbt for modular, reusable, and testable transformations.
  • Snowflake Cortex & AI Enablement
  • Leverage Snowflake Cortex functions within SQL for AI-powered transformations.
  • Implement use cases such as:
    • Text summarization of large datasets (logs, documents)
    • Sentiment analysis and classification
    • Natural language enrichment of datasets
  • Work with vector embeddings and similarity search for semantic use cases.
  • Assist in building AI-ready datasets for downstream analytics and ML.
  • Collaborate with data scientists to integrate AI/ML logic into Snowflake pipelines.
  • Support simple prompt engineering within Cortex functions for optimized outputs.
  • Data Modeling
  • Design and implement analytical data models (star schema, snowflake schema).
  • Build fact and dimension tables optimized for BI and AI use cases.
  • Ensure datasets are structured for both analytics and AI consumption.
  • Performance & Cost Optimization
  • Optimize SQL queries and Snowflake workloads.
  • Use clustering, caching, and efficient compute strategies.
  • Monitor warehouse usage and control costs, including Cortex consumption.
  • Data Quality & Validation
  • Implement data validation checks and quality frameworks.
  • Ensure accuracy, completeness, and consistency of data.
  • Debug and resolve pipeline and data issues.
  • Security & Governance
  • Apply RBAC, masking policies, and row-level security.
  • Ensure compliance with data governance and privacy standards.
  • Maintain proper documentation and lineage for datasets.
  • Collaboration & Agile Delivery
  • Work with architects, analysts, and AI/ML teams.
  • Translate business and AI use cases into technical implementations.
  • Participate in Agile development processes.
Required Skills & Qualifications
Core Snowflake Skills
  • Strong hands-on experience with Snowflake.
  • Advanced SQL skills with performance tuning.
  • Experience with Snowflake features:
    • Streams, Tasks, Dynamic Tables
    • Time Travel, Zero-Copy Cloning
Snowflake Cortex & AI Skills
  • Basic to intermediate experience with Snowflake Cortex functions.
  • Understanding of:
    • Generative AI concepts (LLMs, embeddings)
    • Text processing and NLP basics
  • Familiarity with:
    • Prompt engineering techniques
    • Semantic search and vector similarity concepts
Data Engineering Skills
  • Experience with ELT/ETL tools (dbt, Airflow, Informatica).
  • Knowledge of cloud platforms (AWS / Azure / GCP).
  • Familiarity with data lake/lakehouse architecture.
Programming & Tools
  • Proficiency in SQL and working knowledge of Python.
  • Experience with Git and CI/CD pipelines.
Soft Skills
  • Strong analytical and problem-solving abilities.
  • Good communication and collaboration skills.
  • Willingness to learn and adapt to AI-driven data technologies.
Preferred Qualifications
  • Snowflake certification (SnowPro Core).
  • Experience working on AI-enabled data platforms.
  • Exposure to vector databases or RAG architectures.
  • Familiarity with BI tools (Power BI, Tableau, Looker).
  • Understanding of DataOps / MLOps practices.
Key Deliverables
  • Scalable and reliable data pipelines.
  • AI-enriched datasets using Snowflake Cortex.
  • Optimized queries and cost-efficient workloads.
  • High-quality, analytics- and AI-ready data models.
Success Metrics
  • Pipeline reliability and performance.
  • Adoption of AI-powered data transformations.
  • Query efficiency and cost optimization (including Cortex usage).
  • Data quality and stakeholder satisfaction.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Associate Principal Engineer
Associate Principal Engineer

Nagarro • Kondapur

On-site
INR 3,500,000 - 6,000,000
Snowflake Cortex AI Engineer
Snowflake Cortex AI Engineer

Luxoft • India

Remote
INR 2,400,000 - 3,600,000
Data Platform Architect
Data Platform Architect

Accenture PLC • Coimbatore District

On-site
INR 3,600,000 - 6,000,000
Snowflake Cortex SPCS Data Engineer
Snowflake Cortex SPCS Data Engineer

Infocepts • Pune District

On-site
INR 1,200,000 - 1,700,000
Data Architect I_Snowflake Architect
Data Architect I_Snowflake Architect

UST • Pune District

On-site
INR 3,500,000 - 7,000,000
Senior Snowflake Data Engineer
Senior Snowflake Data Engineer

AlgoLeap Technologies Pvt Ltd. • Hyderabad

On-site
INR 3,800,000 - 5,600,000
Associate Principal Engineer
Associate Principal Engineer

Nagarro • Hyderabad

On-site
INR 4,000,000 - 7,000,000
Snowflake Data Engineer
Snowflake Data Engineer

EY • India

Hybrid
INR 1,500,000 - 2,500,000
Data Science
Data Science

VMC Soft Technologies • Dadri

On-site
INR 1,200,000 - 2,600,000
Snowflake Architect, Data Warehousing
Snowflake Architect, Data Warehousing

Cvent, Inc. • Gurugram District

On-site
INR 1,800,000 - 3,600,000