Senior Analytics Engineer (Data + BI) - Healthcare

Familywell PLLC
Boston, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Boston, United States of America

Tech stack

Sql Data Warehouse
Airflow
Data analysis
Audit Trail
Google BigQuery
Cloud Computing
Continuous Integration
Information Engineering
Data Integrity
Data Retention
Python
PostgreSQL
Role-Based Access Control
Power BI
Salesforce
Tableau
Tokenization
Sql Optimization
Power Platform Integration
Fast Healthcare Interoperability Resources
Snowflake
Data Strategy
GIT
Performance Monitor
Health Level Seven International
Data Management
Hubspot
Zendesk
Terraform
Looker Analytics
Docker
Databricks

Job description

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., + 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-serve best practices and documentation.

  • Security & compliance Implement HIPAA-aligned controls: RBAC/ABAC, column-level masking/tokenization, audit logging, data retention, and least-privilege access.

  • Reliability & cost Monitor performance, freshness, and cost (warehouse, ELT, BI); optimize with SLAs for priority datasets.

Requirements

Do you have experience in Terraform?, Must-have

  • 4-7+ years in analytics engineering / data engineering / BI engineering, including end-to-end ownership of ELTBI.
  • Proficiency with: advanced SQL, dbt (or comparable transformation tooling), a cloud data warehouse (Snowflake preferred; BigQuery/Redshift/Databricks acceptable), and a BI platform (Sigma preferred; Looker/Tableau/Power BI acceptable)
  • Git-based CI/CD, Terraform, Docker.
  • Strong Python skills for light transformations and connector development; dexperience with an EL/ingestion framework (Meltano preferred; Airbyte, Singer SDK, Fivetran, or Stitch acceptable) and an orchestrator (Airflow, Prefect, Dagster, or similar)
  • Experience designing semantic layers (LookML, Metrics Layer, dbt semantic models).
  • Experience integrating healthcare data (EMR/RCM/claim/eligibility/scheduling/patient engagement); working knowledge of HL7/FHIR and healthcare data quirks (encounters, payers, CPT/ICD, denials).
  • HIPAA/PHI practices (de-identification, RBAC, audit logs) and vendor BAA familiarity.
  • Strong stakeholder skills: requirements gathering, translating KPIs, and documentation.

Nice-to-have

  • Data reliability tooling (Great Expectations/Monte Carlo/Elementary).
  • Background with CRM/support tools (Salesforce/HubSpot/Zendesk) and marketing/scheduling data.

Apply for this position