Snowflake Administrator

We are seeking an experienced Snowflake Administrator located in the Dallas, TX area for a long-term contract engagement supporting enterprise cloud data infrastructure. The ideal candidate will be responsible for platform governance, RBAC security, compute warehouse optimization, automated deployments, and supporting scalable data pipelines in a multi-cloud environment.

Key Responsibilities

1. Platform Administration & Management

• Administer, manage, and scale enterprise Snowflake environments, databases, schemas, and virtual warehouses across production and non-production instances.
• Monitor and optimize Snowflake compute and storage costs, warehouse utilization, auto-scaling policies, and resource monitors.
• Configure and maintain core Snowflake capabilities including Time Travel, Zero-Copy Cloning, Data Sharing, Reader Accounts, and Failover/Replication.

2. Security, Governance & Compliance

• Design and implement granular Role-Based Access Control (RBAC), network policies, and object-level permissions.
• Administer data protection standards including dynamic data masking, row-access policies, column-level security, and encryption key management.
• Integrate Snowflake with enterprise Identity Providers (IdP) such as Okta or Azure AD for single sign-on (SSO) and automated provisioning (SCIM).

3. Automation, CI/CD & Integration

• Build and maintain administrative scripts using Python or Shell to automate user provisioning, database task monitoring, and maintenance workflows.
• Implement infrastructure-as-code and schema migration automated pipelines using Terraform, Git, and CI/CD tools.
• Support integrations between Snowflake and modern data ecosystem tools (dbt, Airflow, Azure Data Factory, Power BI, Tableau).

4. Monitoring, Performance & Support

• Diagnose and resolve query performance issues, micro-partition clustering problems, and execution bottlenecks using Snowflake Account Usage and Information Schema.
• Establish disaster recovery (DR) frameworks, high availability, and multi-region replication.
• Provide ongoing tier-3 technical support and operational monitoring for critical business pipelines.

Required Qualifications

• Experience: 5+ years of overall IT experience in Data Engineering / Database Administration, with 3+ years of dedicated Snowflake Administration experience.
• Location Constraint: Must reside within 50 miles of Dallas, TX (Local candidates only).
• Technical Proficiency:
• In-depth expertise in Snowflake Architecture, virtual warehouse sizing, data sharing, and resource governance.
• Strong mastery of SQL, stored procedures, and performance tuning.
• Solid understanding of underlying cloud infrastructure (AWS, Azure, or Google Cloud Platform).
• DevOps & Scripting:
• Hands-on scripting experience with Python or Bash.
• Experience with Git, Terraform, or modern CI/CD deployment workflows.
• Education: Bachelor’s degree in computer science, Information Systems, or equivalent practical experience.

Preferred Qualifications

• SnowPro Core Administrator or SnowPro Advanced Certification.
• AWS or Azure Cloud Administration certification.
• Prior experience in commercial real estate, corporate services, or financial data ecosystems.