Data Science and Business Insights Lead

1 мес. назад

2000–3000 USD / мес.КолумбияАргентинаЧили+2LeadRemote

sqlbigquerydbtdata modeling

Lead role managing data science and business insights at a virtual behavioral health practice focusing on mental wellness for women, responsible for ownership of data stack and reporting.

О компании

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.
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.

Требования

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

Условия

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

Как откликнуться

HR Screen: The first phase involves an initial screening with HR. During this stage, we will discuss your experience, skills, and alignment with Luna Joy's values and culture. This step ensures that you meet the basic qualifications and provides an opportunity for you to learn more about the company and the role.
Second Phase with Hiring Manager: Candidates who pass the HR screen will move on to an interview with the Hiring Manager. In this phase, we dive deeper into your technical abilities, role-specific competencies, and how you approach challenges. The Hiring Manager will assess your fit within the team and your ability to contribute to Luna Joy's mission.
Offer Stage: After the second phase, successful candidates will move to the offer stage. We will present a formal offer that includes compensation, benefits, and any additional details about the role. This is also your opportunity to ask any final questions before making your decision.
Onboarding & Training: Once the offer is accepted, the onboarding process begins. You will be guided through setting up tools, learning about Luna Joy's systems and workflows, and engaging in any role-specific training. This phase ensures a smooth transition into your new role, setting you up for success from day one.

Другое

Job Title: Data Science and Business Insights Lead
Department: Product
Reports to: COO
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.
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.
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.
At Luna Joy, we are committed to fostering a diverse, inclusive, and equitable workplace where all team members feel valued and respected. We believe that diversity of backgrounds, experiences, and perspectives strengthens our ability to support women’s mental health. We encourage individuals from all backgrounds, including those from historically underrepresented groups, to apply and join us in creating a positive impact in our communities. Everyone is welcome at Luna Joy, and we are dedicated to building a work environment where you can thrive and bring your whole self to work.