Snowflake Account Administrator
FreedomPay · Philadelphia, PA · 4 days ago
OTHRFull-time
Key Responsibilities
- Administer and maintain Snowflake accounts across development, QA, UAT, production, and disaster recovery environments.
- Support environment consistency across Snowflake accounts, including configuration alignment, controlled access separation, and operational readiness.
- Manage Snowflake users, roles, privileges, grants, warehouses, resource monitors, and account-level settings.
- Provision, deprovision, and audit user access using least-privilege RBAC practices.
- Support SSO and MFA integration for Snowflake access, including coordination with Azure AD / Microsoft Entra ID where applicable.
- Monitor and support performance of Snowflake workloads that operate against very large tables, including identifying query, warehouse, and process-level issues that may impact reliability, cost, or runtime.
- Support data retention requirements by helping administer and monitor relevant Snowflake account, database, schema, and object-level configurations.
- Assist with account monitoring, warehouse usage, credit consumption visibility, resource monitors, and operational health checks.
- Maintain operational runbooks and documentation for onboarding, access changes, environment administration, incident response, and account recovery.
- Partner with security, infrastructure, data engineering, analytics, and application teams to support secure and reliable Snowflake operations.
- Provide general production support for Snowflake administrative and operational needs.
Required Experience
- Prior hands-on experience as a Snowflake administrator, Snowflake platform administrator, or Snowflake account administrator in a production environment.
- Experience administering Snowflake across multiple environments such as development, QA, UAT, production, and disaster recovery.
- Demonstrated experience managing Snowflake users, roles, grants, privileges, warehouses, resource monitors, and account-level configuration.
- Experience implementing and maintaining RBAC, least-privilege access, SSO, MFA, and access-control practices in Snowflake.
- Familiarity with Azure AD / Microsoft Entra ID integration concepts for authentication, identity, and access management.
- Experience supporting auditability through access reviews, user activity monitoring, administrative action tracking, and related operational controls.
- Familiarity with data retention concepts and the administrative controls needed to support retention requirements.
- Experience supporting large-scale Snowflake environments with very large data sets, including tables containing hundreds of billions to trillions of rows.
- Experience monitoring, troubleshooting, and supporting performance management for queries, pipelines, jobs, and operational processes that depend on very large Snowflake tables.
- Strong SQL skills and the ability to troubleshoot Snowflake operational, access, or configuration issues.
- Experience with account monitoring, query history, billing or consumption oversight, and usage governance.
- Ability to work cross-functionally with security, IAM, infrastructure, data engineering, analytics, and application teams.