Job description

ABOUT 9AMHEALTH 9amHealth is an AI-enabled virtual specialty care platform focused on managing high-cost chronic conditions at scale. The company partners with employers, health plans, and pharmacy benefit managers to deliver comprehensive, cost-effective medical care for individuals living with obesity, diabetes, hypertension, and dyslipidemia. Members receive access to specialized clinicians, including endocrinologists, obesity medicine specialists, and clinical pharmacists, at-home lab testing, prescription medications, and lifestyle support. 9amHealth was founded in 2021 and is backed by leading healthcare investors like Define Ventures, SemperVirens, 7Wire Ventures, and The Cigna Group Ventures. About the Role We are looking for a Data Analyst to join our Data & Analytics team and become the analytics partner to our Customer Success organization. Your primary mission: ensure that the clients we serve (large employers and health plans) receive best-in-class reporting, from recurring Quarterly Business Reviews to ad hoc analyses that answer the questions they care about most. You will own the reporting lifecycle end to end. That means building the data models and dashboards in Looker, writing the Python and SQL that power them, and sitting with Customer Success to understand what story the data needs to tell. We are looking for someone who does not wait to be told what to analyze. You see a pattern, dig in, form a hypothesis, and bring insights to the table before anyone asks. A strong sense of business context and the curiosity to understand why numbers move is just as important as the technical skills to query them. We also expect this person to actively leverage AI tools in their daily analytics work and to identify opportunities where AI can improve our reporting, analysis, and client deliverables. Whether that means using AI-assisted coding to accelerate development, applying LLMs to summarize or interpret data, or proposing entirely new AI-powered analytics capabilities for our clients, we want someone who sees AI as a force multiplier and is eager to push the boundaries of what our data team can deliver. What you'll do: - Own client-facing analytics: build, maintain, and continuously improve the dashboards and reports used in Quarterly Business Reviews and ad hoc client requests. - Partner closely with the Customer Success team to understand client needs, translate business questions into analytical frameworks, and deliver insights that strengthen client relationships. - Design and build production-quality LookML models, explores, and dashboards in Looker, serving as the team's Looker subject matter expert. - Write complex SQL queries across Redshift, Aurora/MySQL, and Athena to extract, transform, and analyze data at scale. - Develop Python scripts and notebooks for data wrangling, automated reporting, and analytical workflows that go beyond what SQL alone can do. - Leverage AI tools (e.g., Claude, GitHub Copilot, Cursor) in day-to-day analytics work to accelerate query development, code generation, data exploration, and documentation. - Identify and champion AI-powered use cases within the analytics workflow, such as automated anomaly detection, natural-language data summarization, predictive insights for client reporting, or AI-assisted QBR narrative generation. - Proactively explore data to surface trends, anomalies, and opportunities, and present findings with clear business context and actionable recommendations. - Define and monitor data quality metrics for client-facing reporting, ensuring accuracy, consistency, and timeliness. - Collaborate with the Data Engineering team to define data model requirements, validate pipeline outputs, and improve the analytical data layer. - Document reporting logic, data definitions, and analytical methodologies to enable self-service and knowledge sharing across teams. - Contribute to the evolution of our BI strategy, including dashboard governance, naming conventions, and version control practices for LookML. What you need: - 5+ years of professional experience in a data analyst, analytics engineer, or BI-focused role. - Deep expertise in Looker, including strong command of LookML: building and maintaining models, views, explores, derived tables, and parameterized dashboards. This is the primary BI tool for the role. - Expert-level SQL: complex joins, window functions, CTEs, subqueries, and query performance tuning. You should be comfortable writing SQL as your primary analytical language. - Strong Python skills for data analysis, scripting, and automation. You should be able to write clean, well-structured Python to query databases, transform data, build automated reports, and support analytical workflows. - Proficiency with AI-assisted development and analytics tools (e.g., Claude, ChatGPT, GitHub Copilot, Cursor). You should already be using AI to write code faster, explore data more efficiently, and improve the quality of your analytical output. - Strong appetite for integrating AI into analytics workflows. You actively look for opportunities where AI can automate, enhance, or transform how data is analyzed and delivered, and you are comfortable experimenting with new tools and approaches. - Self-starter mentality: you proactively identify problems, dig into data without being asked, form hypotheses, and bring insights to stakeholders with actionable recommendations. - Strong business acumen and the ability to understand the "so what" behind the numbers. You can connect data patterns to business outcomes and communicate findings to non-technical stakeholders. - Experience building and delivering recurring client or stakeholder reports (e.g., QBRs, executive dashboards, performance reviews). - Excellent communication and presentation skills, with the ability to tailor the depth and framing of analysis to different audiences (Customer Success, clients, leadership). - Familiarity with cloud data warehouses (Redshift preferred) and data lake concepts (S3, Parquet). Nice to have: - Experience in health tech, digital health, or healthcare services, including familiarity with healthcare-specific data (claims, clinical, eligibility, pharmacy, outcomes measurement). - Hands-on experience building or deploying AI-powered analytics features, such as automated reporting narratives, anomaly detection, classification models, or LLM-based data summarization. - Familiarity with AWS data services (Glue, Athena, S3, CloudWatch). - Experience with event-based analytics platforms such as Mixpanel or Amplitude. - Exposure to dbt or similar analytics engineering tools for managing transformation logic. - Familiarity with version control (Git) for LookML and analytical code. - Prior experience working closely with Customer Success, Account Management, or client-facing teams. - Background in a startup or high-growth environment where you wore multiple hats and owned outcomes end to end. WHAT YOU CAN EXPECT AT 9AMHEALTH At 9amHealth, you'll join the exciting environment of a startup with the stability of highly experienced founders that have successfully built a business from scratch. We foster a collaborative learning mindset and a passion for improvement. You'll work with a brand-new product alongside a small, flexible team of people eager to shape technology, infrastructure, and culture. Our team members are spread across the globe, with physical sites in San Diego, California, and Vienna, Austria, but we value your culture regardless of where you work. Additionally, we provide a professional development budget and support continuing education, empowering our team to grow alongside the company. Team members have the opportunity to make a meaningful impact on chronic disease management and patient outcomes while contributing to a collaborative, mission driven culture focused on improving healthcare accessibility and affordability. Full-Time/W2 Positions Only: We offer a comprehensive benefits package, including health, dental, and vision insurance, along with flexible PTO and work from home options. OUR COMMITMENT TO DIVERSITY AND INCLUSION Diabetes disproportionately impacts BIPOC (black, indigenous, and people of color) 9am.health communities. We are committed to creating a workforce that reflects our patients and creating a positive healthcare experience for them. We welcome applications from people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, and foreign born residents.

Requirements

Must-haves

Own client-facing analytics: build, maintain, and continuously improve the dashboards and reports used in Quarterly Business Reviews and ad hoc client requests.
Partner closely with the Customer Success team to understand client needs, translate business questions into analytical frameworks, and deliver insights that strengthen client relationships.
Design and build production-quality LookML models, explores, and dashboards in Looker, serving as the team's Looker subject matter expert.
Write complex SQL queries across Redshift, Aurora/MySQL, and Athena to extract, transform, and analyze data at scale.
Develop Python scripts and notebooks for data wrangling, automated reporting, and analytical workflows that go beyond what SQL alone can do.
Leverage AI tools (e.g., Claude, GitHub Copilot, Cursor) in day-to-day analytics work to accelerate query development, code generation, data exploration, and documentation.
Proactively explore data to surface trends, anomalies, and opportunities, and present findings with clear business context and actionable recommendations.
Define and monitor data quality metrics for client-facing reporting, ensuring accuracy, consistency, and timeliness.
Collaborate with the Data Engineering team to define data model requirements, validate pipeline outputs, and improve the analytical data layer.
Document reporting logic, data definitions, and analytical methodologies to enable self-service and knowledge sharing across teams.
Contribute to the evolution of our BI strategy, including dashboard governance, naming conventions, and version control practices for LookML.
5+ years of professional experience in a data analyst, analytics engineer, or BI-focused role.
Deep expertise in Looker, including strong command of LookML: building and maintaining models, views, explores, derived tables, and parameterized dashboards. This is the primary BI tool for the role.
Expert-level SQL: complex joins, window functions, CTEs, subqueries, and query performance tuning. You should be comfortable writing SQL as your primary analytical language.
Strong Python skills for data analysis, scripting, and automation. You should be able to write clean, well-structured Python to query databases, transform data, build automated reports, and support analytical workflows.

Nice-to-haves

Familiarity with cloud data warehouses (Redshift preferred) and data lake concepts (S3, Parquet).
Experience in health tech, digital health, or healthcare services, including familiarity with healthcare-specific data (claims, clinical, eligibility, pharmacy, outcomes measurement).
Hands-on experience building or deploying AI-powered analytics features, such as automated reporting narratives, anomaly detection, classification models, or LLM-based data summarization.
Familiarity with AWS data services (Glue, Athena, S3, CloudWatch).
Experience with event-based analytics platforms such as Mixpanel or Amplitude.
Exposure to dbt or similar analytics engineering tools for managing transformation logic.
Familiarity with version control (Git) for LookML and analytical code.
Prior experience working closely with Customer Success, Account Management, or client-facing teams.
Background in a startup or high-growth environment where you wore multiple hats and owned outcomes end to end.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aipythonsqlgollmawsaccessibility

Platform: ashby
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

Pto

Professional Development