Job Title: Snowflake Administrator
Location: Boston, MA (Hybrid)
Job Summary:
We are seeking a skilled and experienced Snowflake Administrator to manage and optimize our Snowflake Data Cloud environment. The ideal candidate will be responsible for the configuration, maintenance, monitoring, and performance tuning of our Snowflake environment to ensure optimal performance, security, and availability of data services.
Key Responsibilities:
- Administer and manage Snowflake environments including user roles, warehouses, databases, and schemas.
- Monitor and optimize the performance and cost of Snowflake resources (warehouses, queries, storage).
- Set up and manage security, including user access, RBAC, network policies, and data masking.
- Automate provisioning and scaling of Snowflake compute resources.
- Collaborate with data engineers, developers, and analysts to support data pipelines, integrations, and reporting needs.
- Implement best practices for data governance, data quality, and compliance within Snowflake.
- Perform backup, recovery, and disaster recovery planning and testing for Snowflake environments.
- Stay updated with Snowflake features and recommend enhancements or changes.
- Monitor query performance using Snowflake Query History and Performance Views.
- Integrate Snowflake with external tools such as AWS, Azure, GCP, DBT, Informatica, Fivetran, etc.