Data Science and Business Insights Lead

Location: Remote

Department: Product

Location Type: REMOTE

Employment Type: FULL_TIME

• Maintain and extend a production dbt project of roughly 220 models spanning appointments, patients, charges and billing, providers, referrals, lead and outreach conversion, capacity, and clinical measures
• Continue the project's layering convention (staging → int → mart) for new work while keeping a large set of established flat dashboards/models stable and correct
• Own the semantics of the hard domain logic, multi-payer insurance billing sequences, fee-schedule matching with its fallback hierarchy, patient active/churn state, care-model classification, provider utilization and capacity
• Keep tests, documentation, and declared exposures current so that a change to an upstream model reveals what it will break before it breaks it

• Own the health of every source feeding the warehouse: the AMD practice-management system (ODBC), the internal warehouse, GoHighLevel CRM, Salesforce/Verifiable credentialing data, Airbyte-loaded external files, payroll, and GA4
• Diagnose and resolve sync failures, schema drift, source-freshness gaps, and the quirks that come with incrementally-synced upstream systems
• Maintain the Python build scheduler and the scripts that sit outside dbt

• Produce the recurring reporting layer, roughly 30 scheduled reports, including weekly analytics and referral reporting, monthly performance and forecasting, capacity and availability reports, and external partner-facing extracts
• Maintain the dashboards and Google Sheets / Connected Sheets that leadership and operators actually open, and keep the exposure layer honest about what depends on what
• Improve how numbers are presented, not just computed; a report nobody trusts or can read is not delivered

• Serve as the analytics partner to four groups:
  • Finance / RCM: charges, payments, adjustments, fee schedules, provider payroll, monthly performance, profitability
  • Clinical Ops/provider network: utilization and fill rates, capacity by state, hiring and enrollment pipeline, credentialing coverage, documentation and charge timeliness, quality metrics
  • Growth/partnerships: lead and referral conversion, source mix, time-to-conversion, care-partner and B2B pipeline, outreach targeting
  • Exec leadership: scorecards, weekly and monthly leadership reporting, and the ad-hoc question that arrives an hour before the board call
• Turn vague business questions into defensible answers, and push back when the question is the wrong one

• Handle protected health information responsibly and keep PHI out of places it shouldn't be
• Maintain test-data exclusion rules, business-rule definitions, and metric definitions that keep numbers consistent across reports
• Serve as the tie-breaker when two dashboards disagree.

• Expert SQL: not "comfortable with joins," but window functions, complex CTE pipelines, incremental logic, and the ability to reason about grain and fan-out in a 15-CTE model you did not write
• Production dbt experience: you have owned or substantially built a dbt project- models, tests, sources, exposures, macros, materialization strategy, and the discipline of refactoring without breaking downstream consumers
• Fluent in Google BigQuery, including its performance and cost characteristics
• Demonstrated end-to-end ownership of an analytics stack, including the parts that aren't modeling: broken pipelines, undocumented source systems, and stakeholders who need an answer today
• Strong written communication: in a remote, sole-owner role, your documentation and your written answers are the interface to the company
• Judgment and self-direction: you will decide what to build and in what order, and you will be right often enough that leadership stops needing to check

• None of these are required. Each one shortens your ramp.
• Python, for the build scheduler, scripting, and ingestion glue
• Airbyte or comparable ELT tooling; connector management and sync troubleshooting
• Git-based analytics workflows, code review, and CI for dbt
• Google Sheets / Connected Sheets as a delivery surface for non-technical stakeholders
• BI tooling and dashboard design
• Healthcare data experience, EHR or practice-management systems, claims, CPT coding
• Revenue-cycle management: fee schedules, payer mix, multi-payer billing, AR
• Behavioral or mental health operations specifically
• HIPAA and PHI governance in a data-team context
• CRM and credentialing source systems, GoHighLevel, Salesforce, Verifiable
• Provider credentialing, enrollment, or clinician capacity planning
• dbt semantic layer/metrics definitions
• Experience being the first or only data hire

• Days 1–15: Don't break the numbers.
  • Take over the recurring report calendar and keep it running on time. Work through CLAUDE.md and DATA_MODELS.md. Meet each stakeholder group and learn which reports they actually use. Get on-call for pipeline failures.
• Days 16-30: Own the domain.
  • Be able to trace any headline metric back to source and explain it. Handle ad-hoc requests without escalation. Close the documentation gaps the handover left, especially in billing and capacity logic.
• Days 31-45: Set direction.
  • Bring leadership a prioritized view of where the stack is fragile, what reporting is redundant, and what the next quarter of data work should be, with your recommendation, not just options.

• Mission-Driven Purpose: Be a part of an organization dedicated to improving access to mental health care, empowering individuals, and creating positive, lasting change in our communities.
• Remote-First Culture: Our remote-first environment is designed to support autonomy, help you create a work setup that fits your lifestyle, and enable you to make a meaningful impact.
• Collaborative & Inclusive Culture: Join a community of diverse talent who share your passion for making a difference. We foster a culture of collaboration, growth, and mutual support to help you thrive in your role.
• Rewarding Compensation: We recognize the value of your work with fair pay, bonuses, and opportunities for advancement as we continue to expand our reach and impact in the mental health space.

• Compensation Range: Open to evaluation based on location, experience, and qualifications, and applicable federal and state minimum wage requirements

• Access to educational resources and professional development opportunities
• Supportive community of like-minded professionals
• Performance-based bonuses and additional perks