Staff Data Architect

We Breathe Life Into Data 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. That’s why we built the Healthcare Map — the industry’s largest, most complete, precise view of the U.S. healthcare system — by combining de-identified, real-world patient data with innovative algorithms and decades of clinical experience. 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. Across the healthcare ecosystem, we’re 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. As we pursue these goals, it remains essential to us that we stay grounded in our values: be awesome, seek growth, deliver “wow,” and enjoy the ride. At Komodo, you will be joining a team of ambitious, supportive Dragons 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 Opportunity at Komodo Health The Data Infrastructure team at Komodo designs, builds, and maintains the foundational systems that power our data ecosystem: 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. Looking back on your first 12 months at Komodo Health, you will have accomplished… Reduced database spend by at least 15% through optimization, automation, and warehouse right-sizing. Improved average query performance for critical workloads by 20% or more, meeting or exceeding established SLAs. Designed and implemented automated monitoring and alerting for anomalous warehouse usage, query slowdowns, and cost spikes. Established and documented Snowflake performance and cost management best practices, resulting in adoption by 70%+ of engineering and analytics teams. Delivered a reference architecture and standardized governance model (tagging, ownership attribution, and sensitivity classification) spanning Snowflake and adjacent platforms, improving cost transparency, compliance alignment, and the consistency of how teams build on the data platform. You will accomplish these outcomes through the following 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. What you bring to Komodo Health (required): 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.\ Expectations of AI Use in this role (required): 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. Additional skills and experience we’ll prioritize… 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. #LI-Remote The pay range for each job posting reflects a minimum and maximum range of annual base pay that we reasonably expect to pay for this position within the US. We carefully consider multiple business-related factors when determining compensation, including job-related skills, work experience, geographic work location, relevant training and certifications, business needs and market demands. The starting annual base pay for this role is listed below. This position may be eligible for performance-based bonuses as determined in the Company’s sole discretion and in accordance with a written agreement or plan. This role may also be eligible for equity awards. In addition, this role is eligible for benefits including, but not limited to, comprehensive health, dental, and vision insurance; flexible time off and holidays; 401(k) with company match; disability insurance and life insurance; and leaves of absence in accordance with applicable state and local laws and regulations and company policy. San Francisco Bay Area and New York City: $208,000 — $260,000 USD All Other US Locations: $181,000 — $225,000 USD Komodo's AI Standard At Komodo, we're not just witnessing the AI revolution – we're leading it. This is a pivotal moment in time, where being first to market with AI transforms industries and sets the bar. We've already established industry leadership in leveraging AI to revolutionize healthcare, and we expect every team member to contribute. AI here isn't optional; it's foundational. We expect you to integrate AI into your daily work – from summarizing documents to automating workflows and uncovering insights. This isn't just about efficiency; it's about making every moment more meaningful, building on trust in AI, and driving our collective success. Join us in shaping the future of healthcare intelligence. Where You’ll Work Komodo Health has a hybrid work model with hubs in San Francisco, New York City, and Chicago. Roles vary — some can be performed from anywhere in the country, others are scoped to a specific region, and some are based near one of our hubs. For hub-based Dragons, we're building intentional in-office rhythms alongside the flexibility that's core to how we work. Whatever your setup, expectations will always be clear before you join. Equal Opportunity Statement Komodo Health provides equal employment opportunities to all applicants and employees. We prohibit discrimination and harassment of any type with regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. By submitting your application, you acknowledge that you have read and understand Komodo Health’s Privacy Notice for Employees and Contractors . This notice explains how we collect, use, and retain applicant data.