Role: Senior Snowflake Platform Engineer
Location: Cincinnati, Ohio (Onsite)
Job Summary
Client is seeking an experienced Senior Snowflake Platform Engineer to manage, secure, optimize, and maintain its enterprise Snowflake data platform.
The ideal candidate will have extensive hands-on experience in Snowflake administration, advanced SQL, query performance tuning, warehouse optimization, security and access management, and production troubleshooting.
This role will focus on improving platform reliability, optimizing compute costs, implementing security best practices, and supporting AWS integrations. The engineer will collaborate with Data Engineering, Architecture, Security, and business teams to ensure the platform remains secure, scalable, and efficient.
Key Responsibilities
Manage day-to-day Snowflake platform administration, including users, roles, permissions, virtual warehouses, and resource monitoring.
Analyze and optimize SQL queries, warehouse utilization, concurrency, and compute costs.
Implement Role-Based Access Control (RBAC), least-privilege access, service accounts, and authentication integrations.
Establish standards for warehouse sizing, auto-suspend, auto-resume, resource monitors, and workload management.
Monitor platform health, troubleshoot production issues, conduct root cause analysis, and implement preventive measures.
Manage Snowflake database objects, including databases, schemas, tables, and views.
Support data integration between Snowflake and AWS services, including S3 and IAM.
Automate platform administration and operational tasks using SQL, Python, scripting, and APIs.
Develop monitoring dashboards, operational documentation, incident response procedures, and cost reports.
Implement security controls, data protection policies, and access reviews.
Collaborate with engineering and architecture teams on platform improvements and enterprise data initiatives.
Ensure platform reliability, operational efficiency, security, and compliance with enterprise standards.
Required Qualifications
Extensive hands-on experience administering Snowflake in a production enterprise environment.
Strong understanding of Snowflake architecture, virtual warehouses, micro-partitions, caching, and query execution.
Advanced SQL skills with proven experience in query performance tuning and troubleshooting.
Practical experience implementing Snowflake RBAC, role hierarchies, grants, and access policies.
Experience with warehouse sizing, resource utilization, workload management, and cost optimization.
Strong production support and troubleshooting skills, including root cause analysis.
Knowledge of database administration, data governance, and enterprise security practices.
Experience monitoring platform performance and improving operational reliability.
Strong problem-solving, communication, and technical documentation skills.
Technical Skills
1. Snowflake Platform Administration
Snowflake account and platform administration
Virtual warehouse management
Database, schema, table, and view management
Resource monitoring and platform maintenance
Snowflake architecture and query execution
2. SQL and Performance Optimization
Advanced SQL
Query performance tuning
Query history analysis
Warehouse utilization and concurrency optimization
Compute cost management
3. Security and Access Management
Role-Based Access Control (RBAC)
Role hierarchies and grants
Least-privilege access
Authentication integrations and service accounts
Masking policies and row access policies
Network policies and data protection
4. AWS Integration and Automation
AWS S3 and IAM integration
Data ingestion and processing integrations
Python and shell scripting
SQL automation and APIs
Terraform and Infrastructure as Code (IaC)
5. Monitoring and Production Operations
Snowflake ACCOUNT_USAGE views
ORGANIZATION_USAGE views
Resource monitors
Production incident management
Root cause analysis
Platform reliability and cost reporting
Preferred Qualifications
Experience integrating Snowflake with AWS S3, IAM, AWS Glue, and enterprise data pipelines.
Experience automating administrative tasks using Python or shell scripting.
Familiarity with Terraform or other Infrastructure as Code tools.
Knowledge of Snowflake replication, failover, multi-cluster warehouses, and business continuity.
Experience with advanced Snowflake security features and authentication mechanisms.
SnowPro Core or SnowPro Advanced certification.
Experience working in financial services, banking, or other regulated enterprise environments.
