Snowflake Platform Engineer / Architect

Can be local to, Cincinnati, OH or Detroit, MI or Dallas, TX

Must Have:
  Snowflake platform administration
  Advanced SQL and performance tuning
  Automation and AWS integration
  Cost and warehouse optimization
  Platform Engineering
  Production operations and troubleshooting
  Security and access management
 

Job Summary:
The Senior Snowflake Platform Engineer will provide hands-on technical leadership for the administration, reliability, security, performance, and cost optimization of the enterprise Snowflake platform. This role will partner with Data Engineering, Architecture, Security, and business teams to ensure a secure, scalable, and efficient data platform that supports critical enterprise workloads. The ideal candidate has deep, practical Snowflake administration experience, strong SQL and performance-tuning skills, and the ability to independently troubleshoot complex production issues and implement platform improvements.

Key Responsibilities:
Own day-to-day Snowflake platform administration, including user and role management, access controls, warehouse configuration, resource monitoring, and operational support.
Analyze and optimize query performance, warehouse utilization, concurrency, and compute costs using Snowflake monitoring and account usage capabilities.
Implement and maintain role-based access control (RBAC), least-privilege access, service accounts, authentication integrations, and data protection controls.
Establish platform standards for warehouse sizing, auto-suspend and auto-resume, resource monitors, workload isolation, and cost management.
Monitor platform health, investigate incidents, perform root cause analysis, and implement preventative measures to improve reliability.
Manage database objects and platform hygiene, including schemas, tables, views, retention settings, and obsolete resource cleanup.
Support data integration and connectivity with AWS services, including S3, IAM, and relevant data ingestion and processing tools.
Automate administrative tasks and operational processes using SQL, Python, scripting, and APIs.
Develop operational dashboards, documentation, and procedures for platform monitoring, incident response, access reviews, and cost reporting.
Collaborate with engineering teams on platform architecture, upgrades, new capabilities, and enterprise data initiatives.

Minimum Qualifications:
Extensive hands-on experience administering and supporting Snowflake in a production enterprise environment.
Strong knowledge of Snowflake architecture, virtual warehouses, micro-partitions, caching, query execution, and resource consumption.
Advanced SQL skills and demonstrated experience diagnosing and resolving query performance issues.
Practical experience implementing Snowflake RBAC, role hierarchies, grants, access policies, and secure access patterns.
Experience with warehouse sizing, workload management, cost monitoring, and compute optimization.
Experience troubleshooting production incidents and improving platform reliability.
Strong understanding of database administration, data governance, and enterprise security practices.
Ability to work independently, communicate effectively, and provide clear technical documentation.

Preferred Qualifications:
Experience integrating Snowflake with AWS S3, IAM, Glue, and enterprise data pipelines.
Python or shell scripting for automation and administrative tasks.
Experience with Terraform or other Infrastructure as Code tools.
Familiarity with Snowflake resource monitors, ACCOUNT_USAGE views, ORGANIZATION_USAGE views, and query history analysis.
Experience with Snowflake security features such as masking policies, row access policies, network policies, and authentication integrations.
Experience with Snowflake workload management, multi-cluster warehouses, replication, failover, and business continuity.
SnowPro Core or Advanced certification.
Experience in financial services or another regulated enterprise environment.