Phamily
Transforming Healthcare Data Infrastructure with Scalable, Secure, & Insight-Driven Solutions
Improving Phamily’s Data Integration, Reporting Capabilities, and Backend Architecture for Smarter Healthcare Delivery

Home » Case Studies » Phamily
2020 - San Francisco, CA
Software Development
51-200 employees
Overview
Phamily is a healthcare technology platform that empowers patients and providers with secure, accessible, and scalable medical record management. With a mission to streamline and enhance the delivery of healthcare services, Phamily enables modern, digital-first experiences through efficient data practices.
Folio3 Data Services partnered with Phamily to transform their fragmented data operations into a streamlined, secure, and analytics-ready ecosystem. By focusing on backend data pipelines, integration with Electronic Health Record (EHR) platforms, and building centralized reporting infrastructure, Folio3 Data Services enabled Phamily to unlock the full potential of their healthcare data, without disrupting ongoing operations.

The Challenge
Centralizing Disparate Healthcare Data While Maintaining Compliance and Real-Time Access
As Phamily scaled its healthcare solutions, it encountered significant challenges in managing and operationalizing its growing volumes of data. Key issues included
Disjointed Data Sources: Aggregating real-time insights from multiple sources proved difficult without a centralized data architecture. Data silos created inefficiencies and delayed analytics.
Complex Integration with EHR Systems: Integrating with leading Electronic Health Record platforms such as Athenahealth and Epic—via protocols like FHIR, HL7, and CDC standards—demanded a robust and compliant data pipeline capable of secure, real-time interoperability.
Need for Actionable Insights from Operational Data: Phamily lacked a dedicated data warehousing layer to transform raw operational data into insights. Reporting on key metrics, such as enrollment funnels and conversion rates, was limited due to the absence of a structured analytics environment.
The Solution: End-to-End Data Infrastructure to Power Scalable, Compliant, and Insightful Healthcare Workflows
To overcome the challenges of managing multiple environments, securing developer access, and handling sensitive healthcare data across systems, Folio3 Data Services implemented a series of strategic infrastructure and backend enhancements tailored to Phamily’s specific needs. The solution was designed with scalability, security, and efficiency in mind. Key components of the solution included:
Backend-Driven Data Consolidation into BigQuery
Folio3 Data Services managed Phamily’s data ingestion workflows by consolidating all incoming healthcare data streams at the backend level. Data ... was formatted, validated, and routed through DataFusion into a centralized Google BigQuery warehouse. This approach enabled faster query performance, improved data governance, and cleaner analytics across large and diverse datasets. READ MORE >
EHR Integration via InterSystems IRIS
To facilitate seamless healthcare data exchange, Folio3 Data Services integrated Phamily’s data warehouse with InterSystems IRIS, a health ... care-grade platform designed for significant data interoperability. This integration reduces the secure exchange of patient and hospital records, enables advanced analytics, and supports real-time decision-making, all while ensuring compliance with HL7, FHIR, and other relevant healthcare standards. READ MORE >
Operational Data Warehouse and Reporting Infrastructure
To bridge the gap between raw operational data and actionable insights, Folio3 Data Services built a data warehouse directly on top of Phamily’s core database. Data marts were created for targeted analytical use cases, and Metabase was implemented as a front-end reporting layer. This enabled business teams to ... track user engagement, view enrollment funnels, and measure conversion rates in real-time, empowering them to make faster, data-driven decisions. READ MORE >
Technologies Used
GCP Data fusion
Google BigQuery
Metabase for reporting
InterSystems
Optum
Identity & Access Management
Athena
Data Integration
Analytics & Monitoring
Data Storage & Warehousing
GitHub Actions, OIDC Integration
Results & Achievements
The partnership with Folio3 Data Services caused significant improvements for Phamily, resulting in the following outcomes:
Unified, Scalable Data Pipeline via BigQuery
Phamily now benefits from an automated backend pipeline that routes all healthcare data into a centralized BigQuery warehouse. This transformation eliminated data silos, improved data accuracy, and enhanced the overall speed of querying and analytics, ... laying the groundwork for scalable, insight-driven healthcare operations. READ MORE >
Advanced Reporting with Real-Time Visibility
By building a dedicated data warehouse and integrating Metabase for visualization, Folio3 Data Services enabled Phamily to unlock previously hidden insights. Business teams gained full visibility into critical metrics, such as enrollment funnels and user conversion rates ... , enabling them to develop more informed strategies and optimize patient engagement. READ MORE >
EHR Integration with InterSystems in Progress
Folio3 Data Services has initiated a strategic integration between Phamily’s data ecosystem and InterSystems. Once fully deployed, this will enable secure, compliant, and real-time record synchronization across healthcare providers, allowing for robust ... interoperability with EHR platforms such as Athena and Optum. This effort supports future scalability and ensures readiness for complex healthcare data scenarios. READ MORE >
A Scalable Digital Infrastructure for Patient-Centric Healthcare
Through its collaboration with Folio3 Data Services, Phamily transformed its healthcare data operations, improving scalability, streamlining integration workflows, and enabling actionable insights through a centralized data architecture. With enhanced backend systems, robust EHR interoperability, and real-time analytics, Phamily is now better equipped to deliver connected, patient-focused healthcare experiences powered by intelligent data.
Ready to unlock the full potential of your healthcare data? Contact Folio3 Data Services today for a free consultation!