Snowflake Administrator [US Shift]

Snowflake Administrator

Key Responsibilities

Snowflake Platform Administration

• Manage and administer the full Snowflake environment including:
• Warehouses, Databases, Schemas, Stages, File Formats, and Pipes.
• Resource monitors, virtual warehouses, and performance configurations.
• Oversee

  Snowflake account-level settings

  , parameter configurations, and global policies.

User, Role & Access Management

• Create, modify, and manage

  users, roles, and permissions

  following RBAC best practices.
• Implement and maintain secure access controls aligned with data governance policies.
• Periodically audit access privileges and ensure compliance with internal and external standards.

Security & Governance

• Implement

  Snowflake security features

  : masking policies, row-access policies, encryption, OAuth, SSO & MFA.
• Ensure compliance with company and industry security standards.
• Monitor platform usage to detect suspicious or unauthorized activities.

Performance Optimization

• Monitor query performance; troubleshoot slow-running queries.
• Optimize virtual warehouse sizes, auto-suspend, and auto-resume settings.
• Recommend improvements to schemas, clustering keys, data organization, and partitioning.

Data Pipeline Support

• Work closely with data engineers to support:
• Snowpipe configurations
• Streams & Tasks
• Internal and external stages (S3, Azure Blob, GCS)
• ETL/ELT integrations
• Support ingestion frameworks, resolve load failures, and monitor data flow health.

Cost Management

• Track and optimize compute and storage costs.
• Implement usage monitoring dashboards and alerts.
• Provide periodic cost reports and recommendations to leadership.

Maintenance & Monitoring

• Daily monitoring of Snowflake logs, warehouse consumption, and system health.
• Troubleshoot operational issues and coordinate with the engineering team for resolutions.
• Manage updates, patches, and Snowflake release assessments.

Documentation & Process Management

• Maintain documentation of platform configurations, standards, and processes.
• Develop SOPs for user management, cost controls, access requests, and query optimization.
• Train internal teams and support data enablement initiatives.

Collaboration

• Work closely with BI/Analytics, Data Engineering, DevOps, and IT security teams.
• Participate in architecture discussions and support the scaling of data platforms.
• Provide technical guidance on Snowflake best practices for ongoing and new projects.

Required Skills & Experience

• 3–7+ years

  of experience working with Snowflake as an administrator or platform engineer.
• Strong knowledge of

  Snowflake RBAC

  , security policies, and platform configuration.
• Solid experience in

  SQL, performance tuning, and query optimization

  .
• Hands-on experience with:

1. Snowflake Tasks, Streams, Stages, Snowpipe
2. Clustering and micro-partitioning
3. Warehousing strategies and performance features

• Experience with

  AWS / Azure / GCP cloud storage

  integrations (S3, Blob, GCS).
• Understanding of

  ETL/ELT pipelines

  , data ingestion frameworks, and orchestration tools.
• Familiarity with monitoring tools (Snowflake dashboards, Snowsight, or 3rd-party tools).
• Strong analytical and troubleshooting skills.
• Experience in

  data governance, compliance, and security

  practices.

Good to Have

• Experience with Python or SQL scripting for automation.
• Knowledge of DevOps tools like GitHub Actions, Azure DevOps, CI/CD pipelines.
• Experience with BI tools (Tableau, Power BI, Looker, etc.).
• SnowPro Core or Advanced Snowflake certification.
• Exposure to database systems like

  Oracle, SQL Server, MySQL, Postgres