Solution
BAYADA is rebuilding its analytics estate as a Databricks Lakehouse organized around mastered entities — Client, Worker, Visit, Payor, Office, Candidate, Referrer — using a medallion architecture (Landing/Raw, Bronze, Silver, Enriched, Master Data, Gold) to consolidate practice management systems, an on-prem ODS, Snowflake, Workday, RiskConnect, and marketing and experience tools. Lakeflow Jobs and Asset Bundles orchestrate ingestion and CI/CD across the tiers, while Unity Catalog enforces ownership, access, lineage, and quality. Databricks SQL serves the curated Gold layer to finance, operations, and clinical analytics as the single source of truth, and Databricks Assistant plus an LLM-powered code converter accelerate Snowflake migration. Genie extends natural-language access on the same governed foundation, preparing BAYADA for AI agents in payroll, compliance, and clinical workflows.
Data flow
Source systems — practice management platforms, an on-prem ODS, Snowflake, Workday, RiskConnect, and marketing/experience tooling — feed a standardized ingestion layer into medallion tiers (Landing/Raw, Bronze, Silver, Enriched, Master Data, Gold) on the Databricks Lakehouse. Lakeflow Jobs and Asset Bundles orchestrate pipelines and CI/CD, while Unity Catalog enforces ownership, access, lineage, and quality. Databricks SQL serves the curated Gold layer to finance, operations, and clinical analytics, and Genie plus Sigma provide natural-language and self-service access on the same governed foundation.