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
1. 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).
2. 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.
3. 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.
4. 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