Staff Data Architect

Komodo Health

3d • $181,000 - $260,000 • Hybrid

About The Position

At Komodo Health, our mission is to reduce the global burden of disease, and we believe that smarter use of data is essential to this mission. We have built the Healthcare Map, the industry’s largest, most complete, precise view of the U.S. healthcare system. The Healthcare Map serves as our foundation for a powerful suite of software applications, helping us answer healthcare’s most complex questions for our partners. We are helping our clients unlock critical insights to track detailed patient behaviors and treatment patterns, identify gaps in care, address unmet patient needs, and reduce the global burden of disease. We are looking for ambitious, supportive individuals with diverse backgrounds but a shared passion to deliver on our mission to reduce the burden of disease — and enjoy the journey along the way.

The Data Infrastructure team at Komodo designs, builds, and maintains the foundational systems that power our data ecosystem, including JupyterHub for data exploration, Airflow for workflow orchestration, Snowflake for scalable data warehousing, and Databricks for advanced analytics and machine learning. Beyond keeping these platforms reliable, scalable, and secure, the team owns data governance, cost and FinOps discipline, and compliance alignment (HIPAA, SOC2) across the stack.

This role exists to architect and optimize Komodo's data infrastructure so that data access, processing, and analysis are seamless, performant, and cost-efficient. As the Staff Snowflake Architect, you will own the reliability, performance, scalability, and governance of our Snowflake environment, while shaping its integration with Databricks and adjacent data stores. You will partner closely with analytics engineers, data scientists, infrastructure, and customer success teams, setting the standards the broader organization adopts while meeting the security and compliance demands of a rapidly evolving healthcare data landscape.

Requirements

• 8+ years in data engineering or warehousing, including 5+ years of hands-on experience managing large-scale Snowflake environments (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 (RBAC) to support governance, cost attribution, and ownership.
• 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.
• Proven ability to operate strategically and tactically, partnering with analytics engineers, data scientists, and infrastructure teams to align performance and cost strategy with business objectives while delivering hands-on, measurable results.
• Judgement & Creativity: Applies AI strategically, knowing how to use the right tools at the right time to solve problems or generate new ideas. Uses AI to accelerate feedback loops, test ideas, and make informed decisions faster. Applies both judgment and creativity when working with AI and understands its limitations.
• Curiosity & Initiative: Demonstrates curiosity and initiative in exploring new AI tools and workflows relevant to their role. Has developed or shared AI-enhanced workflows, automations, or prompts with others.
• Integration & Productivity: Brings a reflexive AI mindset and uses AI as a natural part of their process to iterate, research, and deliver better work. Comfortable working in AI-enhanced environments across writing, data analysis, content creation, or design. Regularly leverages AI tools such as Notion AI, Perplexity, Claude, Descript, Runway, Midjourney, or Microsoft Copilot i.e. to improve speed, clarity, or creative output.

Nice To Haves

• 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.

Responsibilities

• Own the architecture and long-term roadmap for Snowflake, define how it integrates with Databricks and adjacent data stores, and evaluate and pilot new features and cost-optimization tooling.
• 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.
• Assist customer success in triaging customers encountering database or query performance issues, performing root cause analysis and implementing sustainable fixes.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed