- Configure Snowflake account and objects including warehouses, databases, schemas, roles, and users.
- Set up and manage access control using Snowflake's role-based access control (RBAC) model.
- Optimize warehouse sizing, scaling policies, and auto-suspend/resume to balance performance and cost.
- Implement and maintain data sharing, data masking, and row-level security features.
- Set up integration with external tools such as ETL platforms, BI tools (e.g., Tableau, Power BI), and cloud services (e.g., AWS, Azure, GCP).
- Configure and monitor resource monitors, alerts, and usage tracking.
- Assist in data loading and transformation workflows using Snowpipe, stages, and tasks.
- Support DevOps and CI/CD pipelines for deploying Snowflake objects and configurations via tools like Terraform or Git.
- Document configuration standards, security protocols, and operational runbooks.
- Stay up to date on new Snowflake features and propose improvements accordingly.
Skills and Experience Required:
Required:
- 2+ years of experience working with Snowflake in a configuration, administration, or DevOps capacity.
- Solid understanding of SQL, Snowflake-specific syntax, and cloud data warehousing concepts.
- Experience configuring roles, policies, and access controls within Snowflake.
- Knowledge of data governance practices and security features in Snowflake