Pune, Maharashtra

Job Summary

We are seeking a highly skilled Snowflake Engineer with 8+ years of overall IT experience, including 3+ years of solid hands-on experience in Snowflake-based data engineering. The ideal candidate brings deep expertise in modern data pipeline engineering, metadata-driven ingestion, and AI-enabled data processing, along with strong consultative and stakeholder engagement skills.

Key Responsibilities

Key Responsibilities

1. Data Pipeline Engineering

Design and develop scalable, high-performance data pipelines using SnowSQL, Snowpark, and Snowflake native capabilities

Build and optimize ELT/ETL frameworks supporting both batch and real-time workloads

Implement robust ingestion pipelines from diverse enterprise systems

2. Metadata-Driven Ingestion

Design and implement metadata-driven ingestion frameworks for scalable onboarding of datasets

Handle ingestion across multiple formats including XML, CSV, JSON, and Parquet

Automate ingestion, validation, and transformation processes

3. AI/GenAI Integration (Cortex AI)





Leverage Snowflake Cortex AI capabilities to enable AI-driven data transformations, enrichment, and insights generation

Collaborate with business and analytics teams to enable AI-powered data consumption use cases

Contribute to building intelligent, automated data pipelines and semantic layers

4. Data Modeling & Transformation

Develop scalable data models supporting analytics and reporting layers

Build transformations using Snowpark, SQL, and Snowflake native features

Optimize query performance and data access patterns

5. Data Delivery & Reporting Enablement

Deliver analytics-ready datasets in predefined formats for reporting tools (Power BI, Tableau, etc.)

Work closely with business stakeholders to ensure data usability and alignment with reporting requirements

6. Performance Optimization & Governance

Implement best practices for performance tuning, clustering, and cost optimization

Ensure data quality, go

📌 Data Lead (Pune)
🏢 HCLTech
📍 Pune