Data Architect, Komodo Health

• 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
• Experience with ClickHouse, ScyllaDB and other high performance DBaaS products

Desirable

• The Data Infrastructure team at Komodo designs, builds, and maintains the foundational systems that power our data ecosystem
• This includes managing JupyterHub for data exploration, Airflow for orchestrating workflows, Snowflake for scalable data warehousing, and Databricks for advanced analytics and machine learning
• The team ensures these tools are reliable, scalable, and secure to meet the needs of our engineers, data scientists, and analysts
• This role exists to architect and optimize Komodo’s data infrastructure to enable seamless data access, processing, and analysis
• The Data Architect will enhance the reliability, performance, and scalability of our systems, ensuring they meet the demands of a rapidly evolving healthcare data landscape while adhering to best practices for security and compliance
• Looking back on your first 12 months at Komodo Health, you will have accomplished…
• Reduced Snowflake compute credit 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
• Partnered with stakeholders to redesign high-cost, high-latency workloads, delivering measurable performance gains and cost reductions
• Implemented a standardized tagging and governance model for Snowflake databases, schemas, and warehouses to improve ownership attribution, compliance alignment, and cost transparency
• You will accomplish these outcomes through the following 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
• Expectations of AI Use in this role:
• 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
• 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
• 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