Snowflake Architect

Summary

Join Komodo Health's Data Infrastructure team as a Snowflake DBA to architect and optimize the company's data infrastructure. You will enhance the reliability, performance, and scalability of Snowflake systems, ensuring they meet the demands of a rapidly evolving healthcare data landscape. Over the first year, you will reduce Snowflake compute credit spend, improve average query performance, design automated monitoring, establish best practices, and partner with stakeholders to optimize workloads. Responsibilities include analyzing query execution plans, monitoring warehouse consumption, building monitoring dashboards, establishing metadata tagging, creating documentation, and assisting customer success with performance issues. Komodo Health offers a hybrid work model and a competitive total rewards package including medical, dental, and vision coverage, 401k, paid time off, life and disability insurance, and more.

Requirements

• 5+ years of hands-on experience managing large-scale Snowflake environments, including warehouse sizing, resource monitoring, query optimization, and security governance in a production setting
• Demonstrated success reducing query runtimes and eliminating bottlenecks through deep understanding of clustering, partitioning, caching, and execution plans
• A track record of reducing data warehouse spend by implementing auto-scaling strategies, eliminating idle compute, and partnering with engineering teams to rewrite or restructure high-cost workloads
• Expert-level SQL combined with proficiency in Python, Terraform, or similar for automation, monitoring, and orchestration of Snowflake resources
• Strong background in implementing metadata tagging, role-based access control
• Experience working closely with analytics engineers, data scientists, and infrastructure teams to align performance tuning and cost strategies with broader business objectives
• Deep familiarity with Snowflake integrations in AWS/Azure/GCP environments and with tools such as Databricks, Airflow, dbt, Keebo, and observability platforms like New Relic or Tableau
• Ability to operate strategically and tactically, influencing long-term architecture decisions while delivering hands-on solutions that drive measurable performance and cost outcomes

Responsibilities

• Analyze query execution plans, optimize clustering and partitioning, and guide engineering teams toward efficient schema and query design
• Monitor warehouse consumption, adjust scaling policies, and eliminate idle/overprovisioned compute. Implement automation to enforce cost controls
• Build dashboards, scripts, and alerts for proactive performance and cost monitoring. Integrate Snowflake telemetry with observability platforms
• Establish metadata tagging for cost attribution, sensitivity classification, and resource ownership; align with compliance requirements
• Create and maintain documentation, run enablement sessions, and coach teams on Snowflake best practices for query performance and cost efficiency
• Pilot and recommend Snowflake features, cost optimization tools, and new approaches to scaling data workloads efficiently
• Assist customer success in triaging customers encountering database or query performance issues, performing root cause analysis and implementing sustainable fixes

Preferred Qualifications

• Experience with ClickHouse, ScyllaDB and other high performance DBaaS products
• Experience with Temporal for ETL workflow management
• Knowledge of data governance, security practices, and compliance requirements like SOC2 or HIPAA

Benefits

• Comprehensive health, dental, and vision insurance
• Flexible time off and holidays
• 401(k) with company match
• Disability insurance and life insurance
• Leaves of absence in accordance with applicable state and local laws and regulations and company policy
• Medical, dental and vision coverage
• 401k Retirement Plan
• Prepaid legal assistance
• Paid time off for vacation, sickness, holiday, and bereavement
• 100% company-paid life insurance and long-term disability insurance