Data Science and Business Insights Lead

Job Title: Data Science and Business Insights Lead Department: Product Reports to: COO About Luna Joy Luna Joy is a leading provider of mental health services, specializing in supporting women through their mental wellness journey. We offer holistic therapy and medication management to help women overcome challenges like postpartum mental health issues. Our dedicated team of professionals works in a collaborative, autonomous, and remote environment, ensuring comprehensive care for our clients. We are rapidly expanding and committed to improving access to quality mental health services across the U.S. Job Overview LunaJoy is a virtual behavioral health practice. Nearly every operating number the company runs on- provider utilization, payer mix, lead and referral conversion, clinician capacity by state, and weekly leadership scorecards- is produced by one dbt project on BigQuery. This role owns that project. This is a sole-owner seat. You will be the only person whose full-time job is the data stack: you set the modeling standards, you triage the broken sync at 8 am, you decide what a metric means, and you are the person Finance, Clinical Ops, Growth, and the exec team come to when they need a number they can defend. There is no data team above you to escalate architecture decisions to, and no analyst below you to hand ad-hoc queries off to. That autonomy is the appeal of the job and also its main demand; we are hiring for judgment as much as for SQL. The role is open because the current owner is departing. Expect a documented handover, not a cold start: the project carries a maintained CLAUDE.md, a DATA_MODELS.md data-model reference with a grain and terminology glossary, an Electronic Medical Record source-system data dictionary, declared exposures, and dbt tests. As part of the Luna Joy team, you will play an essential role in directly contributing to supporting the mental health journey of one million women with purpose-driven innovation, unwavering compassion, and transformative care. You will need the speed to adapt quickly and efficiently, as well as the drive to be 1% better every day, constantly striving for improvement. Additionally, you will demonstrate compassion and contribute to a positive work environment by giving and getting joy in your daily interactions. These values will enable you to make effective contributions to key areas of focus and responsibility. Key Responsibilities: Data Modeling (dbt + BigQuery) 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 Ingestion and Pipelines 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 Reporting and BI Delivery 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 Analysis and Stakeholder Partnership 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, capa