Job Title: Senior Snowflake Platform Engineer
Duration: 6+ Months with possible extension
Location: Cincinnati, OH
Job Title: Senior Snowflake Platform Engineer
Job Summary
We are seeking a Senior Snowflake Platform Engineer to manage, secure, optimize, and maintain an enterprise Snowflake platform. The ideal candidate will have extensive hands-on experience in Snowflake administration, advanced SQL, query performance tuning, platform security, warehouse optimization, and production troubleshooting.
The candidate will work closely with Data Engineering, Architecture, Security, and business teams to ensure platform reliability, scalability, governance, and cost efficiency.
Key Responsibilities
• Administer and support the Snowflake platform, including user and role management, access controls, virtual warehouses, and operational monitoring.
• Analyze and optimize query performance, warehouse utilization, concurrency, and compute costs.
• Implement role-based access control (RBAC), role hierarchies, grants, least-privilege access, and secure authentication.
• Establish standards for warehouse sizing, auto-suspend, auto-resume, resource monitors, and workload management.
• Monitor platform health, troubleshoot production issues, perform root cause analysis, and implement preventive measures.
• Manage Snowflake database objects, schemas, tables, views, retention settings, and resource cleanup.
• Support integrations with AWS services, including S3, IAM, Glue, and enterprise data pipelines.
• Automate administrative tasks using SQL, Python, shell scripting, and APIs.
• Develop monitoring dashboards, operational documentation, access review procedures, and cost reports.
• Collaborate with engineering and architecture teams on platform enhancements, security, governance, and enterprise data initiatives.
Required Qualifications
• Extensive hands-on experience administering Snowflake in a production enterprise environment.
• Strong understanding of Snowflake architecture, virtual warehouses, micro-partitions, caching, query execution, and resource consumption.
• Advanced SQL skills and proven experience in query performance tuning and optimization.
• Practical experience implementing Snowflake RBAC, role hierarchies, grants, and access policies.
• Experience with warehouse sizing, workload management, resource monitoring, and compute cost optimization.
• Strong production support, troubleshooting, incident management, and root cause analysis skills.
• Knowledge of database administration, data governance, and enterprise security practices.
• Excellent analytical, problem-solving, communication, and documentation skills.
Preferred Qualifications
• Experience integrating Snowflake with AWS S3, IAM, Glue, and data ingestion pipelines.
• Proficiency in Python or shell scripting for administrative automation.
• Experience with Terraform or other Infrastructure as Code (IaC) tools.
• Familiarity with Snowflake ACCOUNT_USAGE, ORGANIZATION_USAGE, QUERY_HISTORY, and resource monitors.
• Knowledge of masking policies, row access policies, network policies, and authentication integrations.
• Experience with multi-cluster warehouses, replication, failover, and business continuity.
• SnowPro Core or SnowPro Advanced certification.
• Experience in financial services or other regulated enterprise environments.
Core Skills
Snowflake Platform Administration | Advanced SQL | Performance Tuning | Security and Access Management | RBAC | Cost and Warehouse Optimization | AWS Integration | Automation | Production Operations and Troubleshooting | Platform Engineering