Job Specifications
Snowflake Data Engineer (with Terraform)
Location - Washington, DC and NYC Hybrid (3-4 days in a week)
Duration - 6+ Month
Job Description:
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 (GitHub, GitLab CI, Jenkins, etc.) to enable automated plan/apply and PR-based change control
Automate deployment of Snowflake TASK objects (scheduled and 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 or 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
Suggested qualifications (optional)
Strong hands-on experience with Snowflake platform internals and best practices
Proven experience designing and implementing Terraform modules for Snowflake and cloud resources
Familiarity with Git-based CI/CD workflows and automated infrastructure testing
Experience with secrets management solutions (HashiCorp Vault, AWS Secrets Manager, Azure Key Vault, GCP Secret Manager)
Good understanding of data ingestion patterns (Snowpipe, external tables, streaming) and production migration strategies
About the Company
Visionary Innovative Technology Solutions LLC (VITS) has been founded on the principle of partnering with our clients - to provide a smarter way of working. VITS as one of the leading service provider deliver a broad range of Staffing and Consulting services that help create valuable relationships between our clients, their customers, employees and regulatory authorities. We as a talent-driven firm and e-Verified employer serve various verticals like BFSI, Healthcare, Life Sciences, Energy, Retail, Telecom, Logistics, Market...
Know more