AI-powered scalable infrastructure + mental health services, starting…. Backed by Y Combinator.
About the role
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.
What they're looking for
- 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
More about this role
Job Title: Data Science and Business Insights Lead
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.
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...
Browse similar: AI jobs · AI startup jobs · Startup jobs · Remote jobs