Snowflake Platform Admin

Location:
Dallas, TX / Minneapolis, MN (3 Days onsite/week)

Hire Type:
Full Time

Job Summary:

We are seeking an experienced Snowflake Platform Engineer with strong expertise in Snowflake administration, Dev Ops, Infrastructure as Code (IaC), and Terraform-based automation. The ideal candidate will be responsible for designing, deploying, securing, and automating enterprise-scale Snowflake environments while ensuring adherence to governance, security, and operational best practices.

The candidate must possess deep knowledge of Snowflake platform engineering, RBAC implementation, network security controls, warehouse lifecycle management, and CI/CD-driven infrastructure deployment. Experience in building fully automated Snowflake provisioning frameworks using Terraform is essential.

• Design, deploy, and manage enterprise-scale Snowflake environments.
• Build and maintain Snowflake platform standards, governance models, and operational procedures.
• Provision and manage databases, schemas, warehouses, integrations, roles, and security objects.
• Implement scalable and reusable Snowflake architecture patterns.
• Optimise Snowflake performance, resource utilisation, and operational costs.

• Develop and maintain Terraform modules for Snowflake infrastructure provisioning.
  • Virtual Warehouses
  • Databases and Schemas
  • RBAC Roles
  • Users and Service Accounts
  • Storage Integrations
  • External Stages
  • Resource Monitors
• Create reusable IaC frameworks that support multi-environment deployments.
• Implement Git Ops principles and automated deployment pipelines.

• Design and maintain CI/CD pipelines for Snowflake platform deployments.
• Integrate Snowflake infrastructure deployment with Azure Dev Ops, Git Hub Actions, Git Lab CI, or Jenkins.
• Automate change management, validation, testing, and release processes.
• Implement environment promotion strategies across Development, QA, UAT, and Production.
• Develop automated rollback and recovery procedures.

• Design and implement Role-Based Access Control (RBAC) frameworks.
• Define and maintain Snowflake security standards and governance policies.
• Configure and manage:
  • Private Connectivity
  • SSO Integration
  • MFA Controls
  • Data Access Governance
• Conduct security reviews and access audits.
• Ensure compliance with enterprise security and regulatory requirements.

• Automate warehouse provisioning and lifecycle management.
• Implement auto-scaling and auto-suspend policies.
• Monitor warehouse utilisation and recommend optimisation opportunities.
• Define resource management strategies to improve performance and control costs.

• Implement monitoring, alerting, and observability frameworks.
• Troubleshoot platform issues and resolve production incidents.
• Perform root cause analysis and implement preventive measures.
• Maintain platform documentation, runbooks, and operational procedures.
• Partner with Data Engineering, Security, Architecture, and Operations teams.
• Provide technical leadership and platform guidance.
• Participate in architecture reviews and platform governance discussions.
• Mentor junior engineers and promote automation-first practices.