Snowflake Engineer

Gantec Corporation; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Gantec Corporation is seeking a hands-on Data Warehousing Engineer with 4–5 years of real-world experience to own and operate production-grade data platforms. You will work with U.S.-based stakeholders to deliver robust Snowflake architectures, enterprise data models, and reliable ELT pipelines while ensuring governance and cost optimization.

Responsibilities include data warehousing, modeling, quality, governance, and performance tuning, with preferred Snowflake certifications and tooling such

Qualifications

• 4–5 years of real-world data engineering experience
• Experience building and operating production-grade data platforms
• Strong knowledge of cloud warehousing, modeling, governance, and performance tuning

Responsibilities

• Design and operate production-grade Snowflake data warehouse solutions
• Develop enterprise data models, data dictionaries, and data lineage documentation
• Build robust ELT pipelines with monitoring and observability
• Implement automated data quality and reconciliation frameworks
• Optimize performance and cost of data platforms, collaborate with stakeholders

Skills

Data engineering fundamentals

Advanced SQL

Dimensional modeling

SCDs & Data Vault

Incremental loading patterns

Tools

dbt

Git

CI/CD

Terraform

Power BI

Tableau

Looker

Job description

Experience: 4-5 Years (Hands-on, Production Experience Required)

We are looking for a true, hands-on Data Warehousing Engineer who has built and operated real production-grade data platforms — not just experimented with AI-assisted tools or prompt-based workflows. This role is for professionals who understand data engineering fundamentals, cloud warehousing, modeling, governance, and performance tuning — and who take full ownership of systems used daily by business teams. You will work closely with U.S.-based customers and stakeholders, providing high-quality delivery, operational support, and continuous improvement.

Key Responsibilities:

• Data Warehouse & Modeling
• Data Transformation & Quality
• Performance & Cost Optimization
• Governance, Security & Compliance
• Operations, Support & Stakeholder Engagement

Required Technical Expertise:

Strong working knowledge of:

• Virtual Warehouses & Micro-partitions
• Streams, Tasks, and Snowpipe
• Secure Data Sharing & Resource Monitors
• Dynamic Tables
• Advanced SQL, query optimization, and execution plan analysis
• Experience with incremental loading patterns
• Dimensional modeling, SCDs, and Data Vault concepts
• Canonical and conformed data design

Security & Governance

• RBAC and access control architecture
• Secure views and policy-driven security

Preferred Snowflake Certifications:

Snowflake certifications are strongly preferred and will be considered an advantage

Preferred Certifications Include:

• SnowPro Advanced (Data Engineer / Architect / Administrator)
• Other Snowflake-affiliated certifications

Please specify in your application:

• Number of Snowflake certifications held
• Date (Month/Year) of your most recent certification

Active or recently renewed certifications will be given preference

Preferred Tooling Experience:

• Transformation: dbt (preferred)
• DevOps: Git, CI/CD, Infrastructure as Code (Terraform)
• BI Tools: Power BI, Tableau, Looker

You will be expected to deliver:

• Production-ready Snowflake architecture and environment standards
• Enterprise data models, data dictionaries, and lineage documentation
• Robust ELT pipelines with monitoring and observability
• Automated data quality and reconciliation framework
• Performance and cost optimization playbooks

Who Should Apply

This role is ideal if you:

• Have 4–5 years of real-world data engineering experience
• Have supported live analytics platforms used by business teams
• Have worked with international / U.S.-based stakeholders
• Prefer engineering depth over “tool-only” or “prompt-only” roles

This role is not suitable if your primary experience is limited to: