Senior Design Architect
Montera Infrastructure
Cloud
Staff Snowflake Architect
Komodo Health
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $179,000 - $275,000 per year
Job Level
Lead
Tech Stack
AirflowAWSAzureGoogle Cloud PlatformPythonSQLTableauTerraform
About the role
- Architect and optimize Komodo’s data infrastructure to enable seamless data access, processing, and analysis.
- Enhance the reliability, performance, and scalability of Snowflake systems, ensuring they meet demands of healthcare data while adhering to security and compliance best practices.
- Analyze query execution plans, optimize clustering and partitioning, and guide engineering teams toward efficient schema and query design.
- Monitor warehouse consumption, adjust scaling policies, eliminate idle/overprovisioned compute, and implement automation to enforce cost controls.
- Build dashboards, scripts, and alerts for proactive performance and cost monitoring and 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.
- Partner with stakeholders to redesign high-cost, high-latency workloads delivering measurable performance gains and cost reductions.
- Design and implement automated monitoring and alerting for anomalous warehouse usage, query slowdowns, and cost spikes.
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.
- 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.
- Regularly leverages AI tools such as Notion AI, Perplexity, Claude, Descript, Runway, Midjourney, or Microsoft Copilot.
Benefits
- 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.
- Comprehensive health, dental, and vision insurance.
- Flexible time off and holidays.
- 401(k) with company match / 401k Retirement Plan.
- Disability insurance and life insurance.
- Leaves of absence in accordance with applicable state and local laws and regulations and company policy.
- Paid time off for vacation, sickness, holiday, and bereavement.
- 100% company-paid life insurance and long-term disability insurance.
- Prepaid legal assistance.
- Competitive total rewards package.
- Hybrid work model and remote work options (roles may be completely remote based anywhere in the country listed).
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SnowflakeSQLPythonTerraformquery optimizationmetadata taggingrole-based access controldata warehouse managementcost optimizationautomation
Soft skills
strategic thinkingtactical executioninfluencingcuriosityinitiativecreativityjudgmentcollaborationcoachingproblem-solving
