Senior Snowflake Admin

7 days ago

Charlotte, NC, United States Inficare Full time
Job Title: Senior Snowflake Admin

Location: Charlotte, NC(Hybrid)

Hiretype: Contract

Job Summary

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 GCP).
  • 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).


Ayishika Deb Choudhury

InfiCare Staffing | 22375 Broderick Drive #225 Dulles, VA 20166

ayishika@inficaretech.com

  • Senior Snowflake Data Scientist

    1 week ago

    Charlotte, NC, United States Inficare Full time

    Job Summary The Senior Snowflake Data Scientist will lead the development, deployment, and operationalization of machine learning and statistical models that solve complex business problems and drive strategic decision-making. This role requires an expert blend of statistical rigor, advanced programming, and deep knowledge of leveraging Snowflake's ecosystem...

  • Senior Snowflake Data Scientist

    2 weeks ago

    Charlotte, NC, United States Inficare Full time

    Job Summary The Senior Snowflake Data Scientist will lead the development, deployment, and operationalization of machine learning and statistical models that solve complex business problems and drive strategic decision-making. This role requires an expert blend of statistical rigor, advanced programming, and deep knowledge of leveraging Snowflake's ecosystem...

  • Senior Snowflake Data Scientist

    1 week ago

    Charlotte, NC, United States Inficare Full time

    Job Summary The Senior Snowflake Data Scientist will lead the development, deployment, and operationalization of machine learning and statistical models that solve complex business problems and drive strategic decision-making. This role requires an expert blend of statistical rigor, advanced programming, and deep knowledge of leveraging Snowflake's ecosystem...

  • Senior Snowflake Data Engineer

    1 week ago

    Charlotte, NC, United States Inficare Full time

    Job Summary The Senior Snowflake Data Engineer will be responsible for designing, building, and optimizing highly scalable and robust data pipelines within the Snowflake cloud data platform. This role requires expertise in modern data warehousing principles, advanced SQL, ETL/ELT methodologies, and proficiency in programming languages like Python or Scala to...

  • Senior OpenShift Admin

    3 days ago

    Charlotte, NC, United States Experis Full time

    Our client, a leading technology firm, is seeking a Senior OpenShift Admin Engineer to join their team. As a Senior OpenShift Admin Engineer, you will be part of the platform engineering team supporting critical production environments. The ideal candidate will have strong problem-solving skills, excellent communication abilities, and a collaborative mindset...

  • Senior OpenShift Admin

    2 weeks ago

    Charlotte, NC, United States Experis Full time

    Our client, a leading technology firm, is seeking a Senior OpenShift Admin Engineer to join their team. As a Senior OpenShift Admin Engineer, you will be part of the platform engineering team supporting critical production environments. The ideal candidate will have strong problem-solving skills, excellent communication abilities, and a collaborative mindset...

  • Lead snowflake data engineer

    2 weeks ago

    Charlotte, NC, United States USM Full time

    Start Date: Interview Types Skills Snowflake Data Engin.. Visa Types Green Card, US Citiz.. I have an opening for a Lead Snowflake Data Engineer. Hybrid on site in Hartford, NC or Charlotte, NC Long term Must be on TEKsystems W2.. total pay is 75-78 per hour Need to be very senior level Data Engineer and need to have focused on snowflake the last...

  • Snowflake Developer

    6 days ago

    Charlotte, NC, United States Diverse Lynx Full time

    Role: Snowflake Developer Location: Remote Duration: FULL TIME Job Description : Responsibilities Data Integration - Provide data integration services for all batch/real-time data Movement in data warehouse, data platforms (data lake) and dependent data marts (Cloud/OnPrem) Data Analysis - Sources, compiles, and interprets data. Performs analysis...

  • Snowflake Developer

    7 days ago

    Charlotte, NC, United States Diverse Lynx Full time

    Role: Snowflake Developer Location: Remote Duration: FULL TIME Job Description : Responsibilities Data Integration - Provide data integration services for all batch/real-time data Movement in data warehouse, data platforms (data lake) and dependent data marts (Cloud/OnPrem) Data Analysis - Sources, compiles, and interprets data. Performs analysis...

  • Snowflake Developer

    3 days ago

    Charlotte, NC, United States Diverse Lynx Full time

    Role: Snowflake Developer Location: Remote Duration: FULL TIME Job Description : Responsibilities Data Integration - Provide data integration services for all batch/real-time data Movement in data warehouse, data platforms (data lake) and dependent data marts (Cloud/OnPrem) Data Analysis - Sources, compiles, and interprets data. Performs analysis...