Position Summary

To be a driven business analyst who can work on complex Analytical problems and help the customer in better business decision making especially in the area of pharma/life sciences (domain).

Job Responsibilities

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, Agile 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 straightforward 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.
Ens

📌 Project Lead Noida
🏢 Axtria
📍 Noida