Senior Snowflake Platform Engineer

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.