Senior Snowflake Admin

Overview

On Site
$DOE
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)

Skills

databases
Configure
Platform Administration & Governance Provisioning & Configuration: Design
provision
and manage Snowflake accounts
virtual warehouses
schemas
and resource monitors following best practices.

Job Details

Senior Snowflake Admin

Location Charlotte, NC (Onsite Hybrid Local)

Duration Long term

Job Description:

The Senior Snowflake Administrator will be a key member of the Data Platform team, responsible for the architecture, administration, security, and optimization of the enterprise-wide Snowflake Cloud Data Platform. This role requires an expert-level understanding of Snowflake's architecture and advanced capabilities, ensuring the platform is scalable, secure, highly available, and cost-efficient for all business data needs.

Key Responsibilities

1. Platform Administration & Governance

Provisioning & Configuration: Design, provision, configure, and manage Snowflake accounts, virtual warehouses, databases, schemas, and resource monitors following best practices.

Security & Access Control: Implement and govern the Snowflake security model, including Role-Based Access Control (RBAC), network policies, and Multi-Factor Authentication (MFA).

Data Protection: Define and enforce data encryption, data masking, and other security policies to protect sensitive PII/PCI data and ensure regulatory compliance (e.g., GDPR, HIPAA).

Data Sharing: Implement and manage secure data sharing and cross-region replication strategies for internal and external consumers.

2. Performance & Cost Optimization

Monitoring & Alerting: Configure and maintain monitoring, logging, and alerting for the Snowflake environment (e.g., resource utilization, query performance, and capacity).

Performance Tuning: Lead the effort to analyze and optimize Snowflake query performance, warehouse sizing, clustering keys, and caching strategies.

Cost Management: Proactively manage and optimize Snowflake consumption and costs through resource monitoring, workload management, and capacity planning.

3. Automation & DevOps

CI/CD Integration: Integrate Snowflake administration tasks and database deployments into CI/CD pipelines (e.g., using tools like Jenkins, Azure DevOps, or GitLab).

Infrastructure as Code (IaC): Automate the provisioning and management of Snowflake objects and infrastructure using tools like Terraform or Python/Snowflake APIs.

Scripting: Develop and maintain complex SQL scripts, stored procedures, and potentially Python/Shell scripts for administrative and automation tasks.

4. Collaboration & Leadership

Best Practices: Define, document, and evangelize organizational standards, best practices, and methodologies for Snowflake usage, development, and administration.

Troubleshooting: Act as the final escalation point for complex platform issues, performance bottlenecks, and service disruptions.

Mentorship: Provide technical guidance and mentorship to data engineers, analysts, and junior administrators on Snowflake features and optimization techniques.

Minimum Qualifications

  • 5+ years of experience in Data Warehouse or Database Administration, with at least 2-3 years dedicated to Snowflake administration.
  • Expert-level proficiency in SQL and deep understanding of data warehousing concepts.
  • Strong hands-on experience with Snowflake architecture (Virtual Warehouses, Storage, Caching, Micro-partitions).
  • Experience with Role-Based Access Control (RBAC) implementation in Snowflake.
  • Familiarity with at least one major cloud platform (AWS, Azure, or Google Cloud Platform).
  • Excellent problem-solving, communication, and documentation skills.

Preferred Skills & Certifications

  • Snowflake certification (e.g., Snowflake SnowPro Administrator).
  • Experience with data integration tools (e.g., Fivetran, Talend, Informatica, or dbt).
  • Proficiency in a scripting language like Python or JavaScript.
  • Experience with Infrastructure as Code (IaC) tools like Terraform.
  • Familiarity with CI/CD tools (e.g., Jenkins, GitHub Actions, Azure DevOps).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.