Senior Analytics Engineer (Data + BI) — Healthcare

About this role

Analytics Engineer (Data + BI) — Healthcare
About FamilyWell
Background:
FamilyWell Health is an AI-enabled mental health start-up dedicated to solving the women’s mental health crisis by seamlessly embedding high quality, equitable, & affordable mental health care into OB/Gyn practices. FamilyWell provides comprehensive virtual mental health services designed specifically for integration into OB/Gyn practices utilizing the psychiatric collaborative care model. FamilyWell’s virtual care team model delivers evidence-based coaching, therapy, care coordination, and psychiatric services with specialized expertise in perinatal mental health and perimenopause/menopause.


About the role
Own the end-to-end data stack—from ingestion and warehousing to modeling and BI. You’ll maintain and refine our analytics platform (replica of our Postgres “Registry,” transforms, semantic layer, and dashboards), establish governance for PHI, and enable self-serve analytics across Care Ops, Business Ops, Sales, Partner Success and Revenue Cycle.


What you’ll do

• **Platform ownership**

• Maintain a warehouse (Snowflake) and connect it to source systems (EMR, RCM, patient engagement, scheduling, support tools).
• Implement ELT (currently using Meltano) (plus custom connectors when needed) and orchestration (dbt Cloud/CI).
• Own company data strategy, detailed architecture and design of replica, warehouse, and BI tool.
• **Modeling & metrics**

• Build curated marts and a governed semantic layer in dbt; define durable metrics (e.g., Time-to-Care, referral funnels, cancellations, provider capacity, cohort outcomes).
• Add data quality tests (dbt tests/Great Expectations), lineage, and alerts; resolve root causes quickly.
• **BI & enablement**

• Administer BI tool (currently Sigma), define roles/permissions, and ship high-leverage dashboards.
• Drive stakeholder discovery; translate questions into metrics, dashboards, and data contracts.
• Train teams on self-se...