Case Study: Clinical Intelligence Platform
Built a Snowflake-Centric Data Platform to Identify High-Risk Patients at Scale
Tools: Snowflake · DBT · Airflow · Power BI · Python
Driving 35% Higher Conversions
-
Integrated 15+ data sources into a centralized data warehouse.
-
Standardized KPI definitions across clinical, financial, and operational domains.
-
Launched curated datasets and self-service dashboards using Power BI.
-
Introduced data SLAs, documentation, and a request intake system to streamline support.
-
Tools: Snowflake, DBT, Airflow, Power BI, Jira
Key Results
-
Increased data availability by 40%
-
Reduced ad hoc reporting workload by 35%
-
Cut time-to-insight from days to under 1 hour
-
Improved executive decision-making with cross-domain KPI dashboards (e.g., missed appointments, medication adherence, patient churn).
Year
2025
ARcare’s care teams struggled to identify high-risk patients and act in time. Data was fragmented across 15+ unconnected systems—EMR, billing, pharmacy, scheduling—and updated manually. Reporting cycles were slow, siloed, and inconsistent, resulting in missed interventions, delayed decisions, and clinician frustration.
The Problem
The Challenge
Key Pain Points
-
Siloed Source Systems: No unified view across clinical and operational data
-
Inconsistent KPIs: Metrics varied by team, undermining executive alignment
-
Manual Reporting Load: Analysts overwhelmed by ad hoc, reactive requests
-
Limited AI Readiness: Infrastructure couldn’t support predictive modeling
My Approach
Key Initiatives
-
Developed DBT models to build high_risk_registry, no_show_predictions, and care_gap_summary
-
Integrated Atlan to tag PHI/PII, track lineage, metadata catalog and manage access
-
Embedded Power BI dashboards with role-level filtering for clinical teams
-
Enabled SQL, and Python access to Snowflake for advanced analysis and modeling
-
Automated workflows with Airflow, incorporating SLAs and monitoring
Results That Matter
40+
Clinics Refreshed for High-risk patient identification
<1hr
Time-to-insight
80%
Ad hoc reduction
3x
BI adoption
Key Takeaways & Insights
-
Data as a product creates accountability and unlocks reusability
-
Snowflake + DBT offered flexibility, scalability, and performance
-
Governance and usability were as critical as speed and automation
-
Empowering care teams with timely, trusted data helped drive real-world clinical impact
“Our outreach team no longer waits for reports. They log in, filter by site, and see who to call today. That’s impact.” — Clinical Director
