Snowflake Admin - 100% Remote

Position Overview

We are seeking an experienced Snowflake Administrator to join the enterprise data architecture and operations team supporting pharmaceutical data initiatives.

The candidate will be responsible for the architecture, administration, security posture, performance tuning, and operational monitoring of large-scale Snowflake data cloud environments integrated with AWS/Azure and enterprise analytics platforms.

Key Responsibilities

• Platform Administration & Architecture: Design, configure, deploy, and maintain multi-cluster Snowflake environments, databases, virtual warehouses, schemas, and resource monitors.
• Security & Governance: Implement and maintain Role-Based Access Control (RBAC), Object-Level Access Control (DAC), dynamic data masking, row-level security, column-level security, and network policies. Manage integration with Single Sign-On (SSO/SAML via Okta or Azure AD).
• Cost Governance & Optimization: Monitor credit utilization, warehouse concurrency, query performance, and storage metrics; implement auto-suspend, auto-resume, and scaling policies to optimize cloud spending.
• Data Integration & Pipeline Support: Configure and manage automated data ingestion pipelines using Snowpipe, external stages (AWS S3 / Azure Blob), streams, and tasks.
• Performance Tuning & Troubleshooting: Profile query execution plans, optimize caching, manage clustering keys, and resolve query latency or locking issues across concurrent user workloads.
• Backup, Recovery & Data Sharing: Leverage Snowflake Time Travel, Fail-safe, zero-copy cloning, and secure data sharing across business units and external third-party partners.
• Infrastructure as Code (IaC) & Automation: Automate Snowflake deployments, schema migrations, and CI/CD operations using tools such as Terraform, Schemachange, Python, or dbt.
• Compliance & Audit: Support data privacy regulations (HIPAA, GxP, GDPR) by establishing audit logging, access review workflows, and compliance reporting.