Snowflake Administrator (NOT a Developer Role)
Role: Snowflake Administrator (NOT a Developer Role)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 is strictly a Snowflake Administrator role, not a Snowflake Developer position. Candidates must have extensive hands-on administration, infrastructure, and platform management experience in Snowflake environments.We are seeking a highly experienced Snowflake Administrator to manage, optimize, and support Snowflake environments across development, sub-production, and production landscapes. The ideal candidate will have deep expertise in Snowflake administration, automation, performance tuning, security, and cloud infrastructure (AWS), along with strong scripting capabilities in Python and Unix.Key ResponsibilitiesSnowflake AdministrationAdminister Snowflake environments (Dev, QA, Prod, Global)Create and manage:Databases, schemas, tables, viewsExternal stages and storage integrationsManage and optimize:Multi-cluster warehousesQuery performance and workload scalingImplement and manage Snowflake features:Streams, Tasks, Cloning, Time TravelAutomation & ScriptingDevelop Python scripts to automate Snowflake administrative tasksEnhance and maintain Python-based ELT pipelinesUtilize Unix shell scripting for automation and operational efficiencyCloud & Infrastructure (AWS)Work with AWS services including:S3, EC2, EKSSupport Snowflake integration with cloud infrastructureOptimize data pipelines and storage efficiencyPerformance OptimizationImprove query performance using:Materialized ViewsClusteringMicro-partitioningResult cachingDebug and optimize SQL queries and business logicSecurity & Access ManagementImplement and manage:Role-Based Access Control (RBAC)User roles and privilegesConfigure and maintain:SSO (Okta), AD group integrationEncryption policiesNetwork policiesRow-level and masking policiesData Integration & ToolsSupport integrations with:TableauSASPythonJDBC-based applicationsTroubleshoot data issues and ensure data integrityCI/CD & DeploymentManage CI/CD pipelines for Snowflake deploymentsOversee schema changes and version controlEnsure smooth release and deployment processesContinuous ImprovementIdentify opportunities to:Automate manual processesOptimize data workflowsReduce operational costsEnsure scalability and reliability of Snowflake platformMust-Have Skills13+ years of IT experience with strong Snowflake Administration focusHands-on expertise in:Snowflake architecture and administrationStreams, Tasks, Time Travel, CloningStrong Python scripting for automationExperience with Unix/Linux shell scriptingDeep understanding of AWS (S3, EC2, EKS)Strong experience in:Performance tuning and query optimizationSecurity (RBAC, SSO, Okta, AD integration)Experience managing multi-environment Snowflake setupsNice-to-Have SkillsExperience with CI/CD tools and DevOps practicesExposure to data warehousing and ELT frameworksKnowledge of Tableau, SAS integrationsExperience in enterprise-scale Snowflake deploymentsEducationBachelor's or Master's degree in Computer Science, Information Technology, or related fieldWork ModelOnsite - Plano, TXLocal candidates preferred (high priority)