Snowflake Engineer

Anaptyss; Dadri; On-site; INR 900,000 - 1,700,000; Full time

Job summary

Anaptyss is seeking a Data Warehouse Engineer to lead Snowflake data warehousing efforts, designing scalable models, managing environments, and driving performance, security, and cost governance across analytics platforms.

You will collaborate with Platform Administrators, Data Engineers, and BI teams to optimize datasets for Power BI, Qlik, and other analytics tools, while ensuring uptime and enterprise standards.

Qualifications

• 5+ years of advanced SQL development in Snowflake, including query optimization and ETL/ELT.
• 3+ years hands-on Snowflake administration including RBAC, security, and cost governance.
• 4+ years designing, developing, and maintaining dbt projects with CI/CD integration.

Responsibilities

• Design enterprise Snowflake models with conformed dimensions and semantic views.
• Build and optimize SQL transformations across Snowflake layers.
• Coordinate deployments via Git/CI/CD and ensure release readiness across environments.
• Collaborate with Data Engineers and BI teams to optimize datasets for analytics tools.
• Maintain governance, lineage, and architectural diagrams for Snowflake solutions.

Skills

Snowflake SQL

Snowflake Administration

dbt

Git / Version Control

CI/CD Pipelines

Tools

GitHub

GitLab

Bitbucket

Job description

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

• 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.

Environment & 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 masking policies.
• Support audit requests, compliance checks, and evidence gathering for reviews.
• Govern secure internal and external data sharing.

Cost Management

• Produce recurring consumption reports to support conduct cost optimization analysis.
• Recommend improvements in warehouse sizing, retention policies, storage optimization, and compute scheduling.

Cross-Functional Collaboration

• Work with Data Engineers to coordinate ingestion design, transformation logic, and schema updates.
• Partner with BI teams to optimize datasets for Power BI, Qlik, and analytical tools.
• Align with Platform Administrators on environment setup, migrations, and operational readiness.

Documentation & Governance

• Maintain transformation specifications, lineage, and architectural diagrams.
• Ensure models and pipelines comply with governance policies and development standards.
• Collaborate with Platform Administrators and the vendor to ensure reporting platform uptime and timely escalation of reporting issues.

Skills & Tools Requirements

• Snowflake SQL: 5+ years of advanced SQL development experience, including complex query optimization, data modeling, performance tuning, and ETL/ELT development within Snowflake environments.
• Snowflake Administration: 3+ years of hands-on experience administering Snowflake platforms, including security, role-based access control (RBAC), warehouse management, monitoring, performance optimization, and cost governance.
• dbt (Data Build Tool): 4+ years of experience designing, developing, and maintaining scalable data transformation frameworks using dbt, including testing, documentation, and CI/CD integration.
• Git / Version Control: 5+ years of experience using Git-based source control systems (GitHub, GitLab, or Bitbucket) for collaborative development, branching strategies, code reviews, and release management.
• CI/CD Pipelines & Deployment Automation: 5+ years of experience implementing and supporting CI/CD pipelines for data warehouse and analytics deployments, including automated testing, code promotion, release management, and deployment automation using Azure DevOps, GitHub Actions, GitLab CI/CD, or equivalent platforms