ole Overview
The Data Warehouse Engineer serves as the primary technical lead for the Snowflake data warehousing ecosystem. This role is responsible for designing scalable data models, managing Snowflake environments, optimizing performance and cost, enforcing security policies, and supporting analytics and enterprise reporting platforms, including Business Objects (BIC), across the organization. The DW Engineer ensures that Snowflake is stable, secure, and aligned with enterprise architecture standards, and collaborates with Platform Administrators and third‑party vendors to ensure reporting platform uptime and timely escalation of issues impacting reporting availability.
Key Responsibilities
Data Modeling & Architecture
• Design enterprise‑level Snowflake models including conformed dimensions, fact tables, and semantic views.
• Document ERDs, modeling assumptions, and physical/logical architectures.
• Establish and enforce modeling standards, naming conventions, and performance optimization patterns.

Transformation & Automation




• Build advanced SQL transformations across all Snowflake layers.
• Implement automated workflows using Tasks, Streams, procedures, and time‑based orchestration.
• Support schema evolution and large‑scale data integration patterns.

Workplace & Release Management
• Coordinate Snowflake schema and object deployments via Git or CI/CD pipelines.
• Own release readiness for Snowflake across Dev, Test, and Prod.
• Ensure new models, views, RBAC changes, and stored procedures are validated prior to promotion.

Performance Optimization
• Conduct performance tuning through micro‑partition analysis, clustering, query plan reviews, and caching strategies.
• Implement Resource Monitors, usage alerts, and proactive performance dashboards.
• Review warehouse utilization to ensure compute resources are right‑sized and cost‑optimized.

Security, RBAC & Controls
• Design and maintain Snowflake role hierarchies, object privileges, row‑level security, and

📌 Snowflake Engineer (Noida)
🏢 Anaptyss
📍 Noida