Job Summary
Job Description: Snowflake Engineer (8+ Years Experience)
Role Overview
We are seeking a highly skilled Snowflake Engineer with 8+ years of overall IT experience, including 3+ years of strong 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, governance, security, and compliance standards
• Monitor, troubleshoot, and continuously improve pipelines
7. Stakeholder Engagement & Technical Consulting
• Provide technical consultation on data architecture, ingestion strategies, and Snowflake capabilities
• Act as a trusted advisor in data engineering and platform decisions
Skill Requirements
Required Skills & Experience
- 8+ years of overall IT experience with 3+ years in Snowflake engineering
- Strong expertise in:
- Snowflake (SnowSQL, Snowpark, Snowpipe, Streams/Tasks)
- Pipeline design and data engineering frameworks
- Metadata-driven ingestion architectures
- Hands-on experience with:
- File formats: Parquet (must), CSV, XML, JSON
- Experience delivering data in predefined formats for reporting and analytics
- Strong proficiency in SQL and data modeling
- Hands-on experience or exposure to Snowflake Cortex AI (required)
- Excellent communication, presentation, and stakeholder management skills
- Strong technical consulting and problem-solving mindset
Good-to-Have Skills
- Experience with DBT (Data Build Tool)
- Knowledge of PL/SQL or procedural SQL programming
- Exposure to cloud platforms (AWS/Azure/GCP)
- Familiarity with CI/CD pipelines and version control systems