Data Warehousing Engineer – Snowflake
We are looking for a hands-on Data Warehousing Engineer with solid experience building and supporting production data platforms using Snowflake.
The role requires solid experience across data warehousing, data modeling, ingestion, transformation, performance optimization, governance, and production support. You will work closely with U.S.-based customers and stakeholders and take ownership of solutions from development through production support.

Key Responsibilities:
• Design and develop scalable data warehouse solutions using Snowflake.
• Build and maintain data ingestion and ELT/ETL pipelines.
• Develop dimensional models, data marts, and reusable data structures.
• Implement data transformation, validation, reconciliation, and quality controls.
• Optimize Snowflake performance, warehouse utilization, and cost.
• Implement security, RBAC, data access, and governance standards.
• Monitor and support production data pipelines and resolve issues.
• Maintain technical documentation, data dictionaries, and lineage.




• Work directly with business and technical stakeholders to understand requirements and deliver solutions.
• Take ownership of assigned deliverables through implementation and production support.

Required Technical Skills:
Snowflake
• Virtual Warehouses and Micro-partitions
• Streams, Tasks, and Snowpipe
• Dynamic Tables
• Time Travel and Zero-Copy Cloning
• Secure Data Sharing
• Resource Monitors
• Performance and cost optimization

Data Engineering & Modeling
• Advanced SQL and query optimization
• Incremental data loading patterns
• Dimensional modeling and Slowly Changing Dimensions (SCD)
• Data Vault concepts
• Canonical and conformed data models
• Data quality and reconciliation

Security & Governance
• RBAC and access control
• Secure views and policy-based security
• PII and sensitive data protection
• Data governance and lineage

Preferred Tooling Experience
• Transformation: dbt
• Orchestration: Airflow, Az

📌 Snowflake Engineer (Chennai)
🏢 Gantec
📍 Chennai