Data Analyst II
$116k - $125k USD
Are you looking for a role in a company that's solving one of the greatest challenges of our lifetime? Ophelia helps people end their opioid use and restore their quality of life with respect for their time and dignity. Our mission is to make evidence-based treatments for opioid use disorder (OUD) accessible to everyone... and we're looking to bring more people onto our team to help us achieve it.
Ophelia is a venture-backed, healthcare startup that helps individuals with OUD by providing FDA-approved medication and clinical care through a telehealth platform. Our approach is discreet, convenient, and affordable. We've been successfully operating in 14 states for almost six years and we're excited to continue our growth. We are a team of physicians, scientists, entrepreneurs, researchers and White House advisors, backed by leading technology and healthcare investors working to re-imagine and re-build OUD treatment in America.
About the Role
As a Data Analyst at Ophelia, you will be the bridge between our data warehouse and our decision-makers. You will be responsible for diving into data to derive insights, identify trends, and tell powerful stories that influence our clinical and business strategies.
You will collaborate across teams to identify data-driven opportunities that propel the business forward, delivering high-quality data work using an agile methodology. Your contributions will ultimately influence key company domains, including company-level KPIs, clinical, commercial, business operations, and more.
Our data team leverages a robust stack within Google Cloud Platform (GCP), utilizing BigQuery, dbt, Rudderstack, and Lightdash. We also leverage various AI tools to enhance our productivity and analytical capabilities, and we are looking for a teammate who shares our excitement for evolving our technical workflows. Data is deeply embedded in our corporate culture, with widespread adoption of data products and a significant potential for further evolution.
In this fully remote position, you will report to our Analytics Manager and serve as a peer to other analysts and analytics engineers as our team expands. You will work closely with the broader Technology Team to cultivate a culture of data-driven decision-making, ultimately enhancing patient care. You'll oversee analytics across diverse domains like clinical operations, payor partnerships, and company KPIs, translating complex data into actionable narratives.
Together, we are dedicated to helping individuals with opioid dependence. While experience in this specific treatment area isn't required, ideally, you will possess knowledge of the healthcare landscape, including an understanding of health outcomes, benchmarks, systems, and regulatory compliance (HIPAA).
Responsibilities
- Strategic Insights: Transform raw data into narratives that explain the "why" behind various business questions, providing the "so-what" recommendations that influence our clinical and operational strategies.
- Cross-Functional Partnership: Act as the dedicated data partner for departments like Commercial, Business Operations, and Clinical Operations, helping them define KPIs and track progress against goals.
- BI Ecosystem Management: Build and curate a BI ecosystem that allows teams to answer their own questions with confidence, reducing the time from question to insight.
- Ad-hoc Exploration: Use SQL and business context expertise to rapidly answer urgent business questions and conduct exploratory research into new clinical or operational trends.
- Ensure Data Trust: Partner with the technical team to bridge the gap between backend data models and frontend business needs, ensuring our reporting layer remains the "single source of truth."
- Fostering a Data Culture: Act as a subject matter expert for Ophelia’s data assets, teaching others how to interpret data and championing evidence-based decision-making.
Skills & Competencies
- Analytical & Statistical Rigor: 2–4 years of experience in data analytics with a deep understanding of statistics and probability. You know how to distinguish signal from noise and ensure recommendations are mathematically sound.
- SQL Mastery: Advanced proficiency in SQL is a must (2+ years of experience). You are comfortable joining complex tables, using window functions, and optimizing queries within a cloud warehouse environment like BigQuery.
- User-Centric Visualization: Expertise in designing high-impact dashboards with a focus on usability (2+ years of experience). You build intuitive visuals that empower a diverse set of stakeholders to navigate data and find their own answers.
- Modern Data Foundations: A basic understanding of dimensional modeling and how data is structured. You are comfortable with Git, and have the technical curiosity to utilize modern tools like VS Code or Cursor to make dbt adjustments. Dbt experience is preferred by not required.
- Analytical Versatility: You thrive in environments where data is often semi-structured and projects span a wide variety of business domains. You are comfortable navigating ambiguity and shifting between diverse topics.
- Proactive Project Ownership: A habit of objective thinking and continuous learning, with the proven ability to lead analytical projects independently while collaborating effectively across a remote team.
- Mission & Industry Alignment: A passion for making evidence-based addiction treatment accessible. Experience in a regulated industry (healthcare, fintech, etc.) is a plus.
Our Benefits Include:
- Remote work anywhere in the United States
- Competitive medical, vision, and health insurance (many plans are fully covered for the employee!)
- Start with 20 days (4 weeks) of PTO, increasing to 5 weeks after 2 years and 6 weeks after 5 years of tenure
- 10 company holidays
- Work From Home Stipend
- 401k Contribution Platform
- Additional benefits offered through our benefits provider such as life insurance, short and long term disability, financial wellness, virtual primary care, among others!
#LI-Remote
Applicants must be authorized to work in the U.S. without a current or future need for visa sponsorship.
Ophelia Compensation Overview
- We set compensation based on the level and skills required for the role. We value pay transparency and equity, and are committed to fair pay. In order to prevent pay disparities and reduce time spent in negotiations, we take a “first and best” offer approach: this means we’re not holding any compensation back from our candidates, and you can feel confident that our pay is fair and does not vary based on the strength of someone’s negotiation skills.
- Compensation is dynamic at Ophelia: as long as the company performs well and meets our targets, there will be opportunities for increased compensation annually. We’re happy to discuss this approach and our bands if you have questions during the interview process.
Compensation Range
$116,000—$125,000 USD
Interested in learning more about Ophelia and this role? Apply to work with us!