About the Client
The client is a healthcare technology provider specializing in software solutions that unify the care journey across elderly and community-based care programs. The client offers an interoperable care management platform that integrates EHR, TPA, and care coordination functionalities into a single ecosystem. The client aims to provide person-centered care across post-acute and home-based environments. With a vision to build seamless connections across healthcare, the organization focuses on value-based care. This helps to enhance outcomes for both providers and patients through the power of integrated technology and healthcare expertise.
Business Challenges Faced by the Client
The client is focused on building a care coordination and analytics platform to improve patient outcomes and operational efficiency. But the major barrier in achieving this was disconnected data systems. Data fragmentation across multiple systems makes it difficult to gain a unified view of patients and care programs. Also, the existing legacy system could not support growing data volumes and healthcare data analysis requirements. Cost forecasting is complex due to disparate data sources and inconsistent reporting. Due to limited internal expertise in modern data engineering, actionable insights and strategic decision-making were affected.
Kasmo’s Solution
We implemented an end-to-end solution for Snowflake data migration, ensuring a smooth, efficient, and fully managed transition. This solution included-
Data Ingestion Using Openflow
Our experts automated the extraction of data from disparate sources into Snowflake using Openflow. This included integrating multiple relational databases (RDS), Netsuite, Jira, Salesforce, and other operational systems into a unified pipeline. This helps to gain a single data view while preserving data integrity, allowing downstream layers to receive timely and accurate datasets without manual intervention.
DBT Enablement
Configured the DBT (Data Build Tool) environment within Snowflake to manage transformations, model creation, and CI/CD pipelines. The DBT setup included documentation sites to visualize lineage and model dependencies, providing the client with transparency and governance. This integration allowed teams to manage and maintain models efficiently while reducing deployment errors.
Gold Layer (Business Data Marts)
Developed curated business data marts aligned with key performance indicators (KPIs) for Sales, Finance, Patient 360, and Product Performance. These marts provided actionable insights for decision-making and reporting while ensuring alignment with business goals and needs.
Dynamic Table Implementation
We used Snowflake Dynamic Tables to gain near real-time refresh for datasets, along with DBT incremental models. Target lags and refresh policies were defined for each data domain, allowing automated updates for the Gold layer while balancing cost and performance. Metrics were monitored to track refresh efficiency and system performance.
Data Governance Policies
Established Role-based security (RLS) and data governance policies using Snowflake to protect sensitive healthcare data. Also ensured full compliance with HIPAA and other regulatory requirements, enabling the client to securely share and analyze data across departments.
Reporting and Analytics
Our experts built and validated analytical dashboards in Sigma, aligned to the client’s defined KPIs and business metrics. Used advanced AI/ML capabilities with Cortex and built a scalable system while maintaining predictable cost controls.
Key Results Achieved
Through Snowflake data migration, the client gained substantial improvements across data management, analytics, and operational efficiency. Key outcomes include:
Unified Patient Journeys: Successfully integrated data across EHR, claims, financial, and care coordination systems. This helped to gain a holistic view of patient data and created a single source of truth.
Predictive Analytics and AI: Enabled advanced AI models to predict hospitalization risk, disenrollment, functional decline, and optimize resource allocation.
Enhanced Compliance and Reporting: Improved reporting capabilities and ensured adherence to care program regulations.
Real-Time Insights: Enabled secure data sharing and actionable insights to providers, agencies, and clients.
Scalable Adoption: Expanded platform usage from 8K to 24K+ users across 142+ client organizations, ensuring seamless scalability.
