Snowflake Data Engineer

Snowflake Data Engineer (with Terraform)

Role summary:

We are seeking a highly skilled Snowflake Data Engineer with strong expertise in Terraform to design, build, and manage scalable data workloads on Snowflake. The ideal candidate will be responsible for automating infrastructure deployment, orchestrating data pipelines, and ensuring efficient and secure data operations in a cloud environment.

Key Responsibilities:

• Design and implement Snowflake architecture components using Terraform modules, including accounts, databases, schemas, virtual warehouses, roles, users, grants, stages, pipes, tasks, and streams
• Develop reusable, versioned Terraform modules and maintain remote state backend and locking (S3/Azure/GCS + state locking)
• Integrate Terraform workflows into CI/CD pipelines (GitHu, GitLab CI, Jenkins, etc.) to enable automated plan/apply and PR-based change control
• Automate deployment of Snowflake TASK objects (scheduled/stream processing) and ensure safe migration strategies for production workloads.
• Implement security controls using least-privilege RBAC, object-level grants, and secrets management (HashiCorp Vault, cloud secret stores).
• Collaborate with data engineering teams to onboard pipelines (Snowpipe, ingestion stages, external tables) and ensure Terraform models match runtime needs
• Monitor, tune, and cost-optimize Snowflake compute usage and storage; implement resource monitors and alerting
• Build tests and validations for Terraform (unit/integration testing with Terratest or similar) and implement automated checks (policy-as-code / sentinel / OPA)
• Mentor teammates on Snowflake best practices, IaC patterns, and secure deployment workflows
• Automate deployment of data models, warehouses, and data sharing processes.
• Develop ETL/ELT solutions to ingest, transform, and load structured/unstructured data.
• Monitor performance, troubleshoot issues, and fine-tune queries, tasks, and stored procedures.
• Ensure compliance with data governance, access control, and audit requirements.

Required Skills & Experience

• SnowPro Core certification (required) or equivalent demonstrated Snowflake expertise
• Hands-on experience deploying Snowflake resources programmatically using Terraform or equivalent IaC tools
• Strong SQL skills for data modeling, query optimization, and troubleshooting (Snowflake-specific features such as clustering, micro-partitions, and materialized views)
• Familiarity with Snowflake features: Tasks, Streams, Snowpipe, Time Travel, Fail-safe, Data Sharing, Secure Views, and user/role management
• Experience with Terraform best practices: modules, workspaces, remote state, versioning, and secret handling
• Experience integrating IaC into CI/CD pipelines and implementing automated testing and policy checks
• Experience with at least one public cloud (AWS, Azure, or GCP) and the associated networking, storage, and IAM concepts
• Proficiency in scripting (Python, Bash, or similar) for automation and tooling.
• Experience in setting up and using AWS components, EMR, EC2, Lambda, ECR, ELB, Route53, S3.
• Strong Experience with python, Terraform, YAML, JSON, TOML, Snowsql, Flyway, preferred.

Certifications

• SnowPro Core (required)
• Terraform Associate (recommended)