Snowflake Administrator (NOT a Developer Role)
- Snowflake
- AWS
- Python
- Unix
- ELT
- EC2
- EKS
- SQL
- RBAC
- Okta
- Tableau
- SAS
- JDBC
- CI/CD
- Linux
- AWS S3
- Devops
Location: Plano, TX (Onsite – Local Candidates Highly Preferred)
Job Type: Full-Time / Contract (Specify as needed)
Experience Required:13+ Years (Strong Snowflake Administration Experience Mandatory)
This isstrictly a Snowflake Administrator role, not a Snowflake Developer position. Candidates must haveextensive hands-on administration, infrastructure, and platform management experience in Snowflake environments.
We are seeking a highly experiencedSnowflake Administrator to manage, optimize, and support Snowflake environments across development, sub-production, and production landscapes. The ideal candidate will have deep expertise inSnowflake administration, automation, performance tuning, security, and cloud infrastructure (AWS), along with strong scripting capabilities in Python and Unix.
Key Responsibilities
Snowflake Administration
-
Administer Snowflake environments (Dev, QA, Prod, Global)
-
Create and manage:
-
Databases, schemas, tables, views
-
External stages and storage integrations
-
-
Manage and optimize:
-
Multi-cluster warehouses
-
Query performance and workload scaling
-
-
Implement and manage Snowflake features:
-
Streams, Tasks, Cloning, Time Travel
-
Automation & Scripting
-
DevelopPython scripts to automate Snowflake administrative tasks
-
Enhance and maintainPython-based ELT pipelines
-
UtilizeUnix shell scripting for automation and operational efficiency
Cloud & Infrastructure (AWS)
-
Work with AWS services including:
-
S3, EC2, EKS
-
-
Support Snowflake integration with cloud infrastructure
-
Optimize data pipelines and storage efficiency
Performance Optimization
-
Improve query performance using:
-
Materialized Views
-
Clustering
-
Micro-partitioning
-
Result caching
-
-
Debug and optimize SQL queries and business logic
Security & Access Management
-
Implement and manage:
-
Role-Based Access Control (RBAC)
-
User roles and privileges
-
-
Configure and maintain:
-
SSO (Okta), AD group integration
-
Encryption policies
-
Network policies
-
Row-level and masking policies
-
Data Integration & Tools
-
Support integrations with:
-
Tableau
-
SAS
-
Python
-
JDBC-based applications
-
-
Troubleshoot data issues and ensure data integrity
CI/CD & Deployment
-
Manage CI/CD pipelines for Snowflake deployments
-
Oversee schema changes and version control
-
Ensure smooth release and deployment processes
Continuous Improvement
-
Identify opportunities to:
-
Automate manual processes
-
Optimize data workflows
-
Reduce operational costs
-
-
Ensure scalability and reliability of Snowflake platform
Must-Have Skills
-
13+ years of IT experience with strong Snowflake Administration focus
-
Hands-on expertise in:
-
Snowflake architecture and administration
-
Streams, Tasks, Time Travel, Cloning
-
-
StrongPython scripting for automation
-
Experience withUnix/Linux shell scripting
-
Deep understanding ofAWS (S3, EC2, EKS)
-
Strong experience in:
-
Performance tuning and query optimization
-
Security (RBAC, SSO, Okta, AD integration)
-
-
Experience managingmulti-environment Snowflake setups
Nice-to-Have Skills
-
Experience withCI/CD tools and DevOps practices
-
Exposure todata warehousing and ELT frameworks
-
Knowledge ofTableau, SAS integrations
-
Experience inenterprise-scale Snowflake deployments
Education
-
Bachelor's or Master's degree in Computer Science, Information Technology, or related field
Work Model
-
Onsite – Plano, TX
-
Local candidates preferred (high priority)
Snowflake Administrator (NOT a Developer Role) · Veracity Software Inc