Snowflake Administrator

Abotts Inc; Lathrop, Northern (CA, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Abotts Inc. is seeking an experienced Snowflake Administrator to manage and optimize our Snowflake Data Cloud environment. You will oversee accounts, databases, schemas, warehouses, roles, and users, while enforcing RBAC and secure access protocols such as SSO and MFA.

The role requires hands-on Snowflake administration, performance tuning, and cost control across cloud platforms. As part of the Data Platform team, you will collaborate with Data Engineers and Developers to ensure data

Qualifications

• 3+ years of experience in Snowflake administration or cloud data platform operations.
• Hands-on experience administering Snowflake environments and managing security, access, and governance.
• Strong SQL skills and ability to troubleshoot database queries.

Responsibilities

• Administer and maintain Snowflake environments, including accounts, databases, schemas, warehouses, roles, and users.
• Implement RBAC and least-privilege access controls; manage SSO and MFA as applicable.
• Monitor performance, sizing, and costs; optimize warehouses and data sharing.
• Support data loading, unloading, and integration with Data Engineering teams.
• Maintain security, governance, and compliance by monitoring access and audits.

Skills

SQL proficiency

Analytical thinking

Troubleshooting

Communication

Stakeholder management

Independent & collaborative work

Education

Bachelor’s degree in CS/IT/Engineering or related field

Tools

Snowflake Data Cloud

Terraform

Informatica

dbt

Matillion

Fivetran

Python

CI/CD

DevOps

Terraform

Job description

Abotts Partners with singapore based tech giant to help migrate their public sector customer from Sybase to SQL server.

Abotts partners with NYPL to integrate with their partner libraries.

ABOTTS partners with County in Los Angeles to upgrade their court infrastructure into new technologies.

Upworks Inc partners with ABOTTS to build their Oracle Cloud Infrastructure (OCI) and migrate their custom applications to OCI.

Abotts partners with startup to manage and maintain their IT infrastructure and support SOC2 reporting.

Abotts Inc Partners with Gnorth consulting to deploy exadata and ODA for a large public sector customer.

Abotts Partners with singapore based tech giant to help migrate their public sector customer from Sybase to SQL server.

Abotts partners with NYPL to integrate with their partner libraries.

ABOTTS partners with County in Los Angeles to upgrade their court infrastructure into new technologies.

Upworks Inc partners with ABOTTS to build their Oracle Cloud Infrastructure (OCI) and migrate their custom applications to OCI.

Abotts partners with startup to manage and maintain their IT infrastructure and support SOC2 reporting.

Abotts Inc Partners with Gnorth consulting to deploy exadata and ODA for a large public sector customer.

Snowflake Administrator

Job Summary

We are seeking an experienced and detail-oriented Snowflake Administrator to manage, maintain, and optimize our Snowflake Data Cloud environment. The ideal candidate will be responsible for Snowflake platform administration, security and access management, performance monitoring, cost optimization, data governance, and operational support.

The candidate should have strong hands‑on experience with Snowflake administration and a solid understanding of cloud data warehousing, database concepts, security, and data platform operations.

Key Responsibilities

Snowflake Administration

• Administer and maintain the Snowflake environment, including accounts, databases, schemas, warehouses, roles, and users.
• Configure and manage Snowflake virtual warehouses based on workload and performance requirements.
• Monitor Snowflake platform health, usage, and overall performance.
• Manage Snowflake upgrades, new features, and configuration changes as applicable.
• Support production environments and resolve Snowflake-related operational issues.

User, Role & Access Management

• Create and manage Snowflake users, roles, and role hierarchies.
• Implement Role-Based Access Control (RBAC) and enforce the principle of least privilege.
• Manage authentication methods, including SSO and MFA, where applicable.
• Review and maintain user access and permissions in accordance with organizational security policies.
• Support user onboarding, access changes, and offboarding activities.

Performance & Workload Management

• Monitor query performance and identify long-running or inefficient queries.
• Analyze warehouse utilization and recommend appropriate sizing and scaling strategies.
• Configure warehouse auto-suspend and auto-resume settings.
• Work with data engineers and developers to troubleshoot performance issues and optimize workloads.
• Monitor concurrent workloads and resource utilization.

Cost Optimization

• Monitor Snowflake credit consumption and storage utilization.
• Identify opportunities to optimize warehouse usage and reduce unnecessary costs.
• Implement cost‑control measures such as resource monitors and usage alerts.
• Provide recommendations for efficient warehouse sizing and scheduling.
• Prepare regular reports on Snowflake usage and cost trends.

Security & Data Governance

• Implement and maintain Snowflake security best practices.
• Manage data access controls and security policies.
• Support data governance, auditing, and compliance requirements.
• Monitor access and administrative activities using Snowflake logs and audit capabilities.
• Assist with security reviews and compliance audits.

Data Operations & Support

• Support data loading, unloading, and integration activities in collaboration with Data Engineering teams.
• Monitor data pipelines and investigate data availability or access issues.
• Troubleshoot issues related to databases, schemas, stages, file formats, and data sharing.
• Support Snowflake data sharing and secure data exchange where required.
• Assist with backup, recovery, and data retention requirements.

Monitoring & Troubleshooting

• Monitor Snowflake usage, queries, workloads, and system activities.
• Investigate and resolve user access, performance, connectivity, and data-related issues.
• Perform root cause analysis (RCA) for recurring production incidents.
• Maintain incident records and contribute to continuous service improvements.
• Automate routine Snowflake administration tasks using SQL, Python, scripting, or other automation tools.
• Work with DevOps and Data Engineering teams to improve deployment and operational processes.
• Support Infrastructure-as-Code (IaC) and automated provisioning where applicable.
• Identify opportunities to improve platform reliability, security, performance, and operational efficiency.
• Maintain documentation for Snowflake architecture, configurations, access controls, and operational procedures.
• Develop administration runbooks and troubleshooting guides.
• Collaborate with Data Engineers, Data Architects, Developers, Security, and business teams.
• Provide guidance and support to users on Snowflake best practices.

Required Skills & Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.
• 3+ years of experience in Snowflake administration, database administration, or cloud data platform operations.
• Hands‑on experience administering Snowflake Data Cloud environments.
• Strong understanding of Snowflake architecture, including:
  • Databases and schemas
  • Virtual warehouses
  • Roles and RBAC
  • Storage and compute concepts
  • Data sharing
  • Resource monitors
• Experience with Snowflake security and access management.
• Strong SQL skills and experience troubleshooting database queries.
• Experience monitoring and optimizing Snowflake performance and costs.
• Knowledge of cloud platforms such as AWS, Microsoft Azure, or Google Cloud Platform (GCP).
• Understanding of data warehousing and ETL/ELT concepts.
• Strong analytical and troubleshooting skills.

Preferred Qualifications

• Snowflake certification, such as SnowPro Core Certification or other relevant Snowflake certifications.
• Experience with Snowflake integrations and data engineering tools.
• Familiarity with ETL/ELT tools such as Informatica, dbt, Matillion, Fivetran, or similar platforms.
• Experience with Python or scripting for automation.
• Knowledge of CI/CD and DevOps practices.
• Experience with Infrastructure-as-Code tools such as Terraform.
• Familiarity with data governance and compliance frameworks.
• Experience working in a cloud-based enterprise data environment.
• Strong problem‑solving and analytical skills.
• Attention to detail and a security‑focused mindset.
• Ability to manage and prioritize multiple operational tasks.
• Strong communication and stakeholder management skills.
• Ability to work independently and collaboratively in a cross‑functional environment.
• Proactive approach to performance monitoring and continuous improvement.

About the Role

This role is ideal for a Snowflake professional who enjoys managing and optimizing a modern cloud data platform. The Snowflake Administrator will play a key role in ensuring the security, reliability, performance, scalability, and cost efficiency of the organization’s Snowflake environment while supporting Data Engineering and business teams.