Replying to @johnathan27
I’m Johnathan - a full-stack engineer who ships web applications from ground-up to production. Next.js for web, Supabase for backend, and AI/LLMs where they add real value. 8+ years building AI-powered products for healthcare, fintech, real estate, and SaaS teams.
I worked on the backend data layer for Cylinder Health - a specialized GI care platform that has now helped over 145,000 patients manage digestive conditions through clinician-backed, personalized care plans.
My piece of the stack: the clinical records layer and the EHR ingestion pipeline.
━━━ What "FHIR-compliant" actually means when you build it ━━━
FHIR (Fast Healthcare Interoperability Resources) is the standard that lets healthcare systems talk to each other. In theory it's clean. In practice, every EHR vendor - Epic, Athena, Cerner - sends you data in their own dialect of FHIR, with custom extensions, missing fields, and inconsistent date formats.
So the ingestion pipeline wasn't just "normalize JSON into Postgres." It was:
→ Model the core FHIR resources correctly: Patient, Observation, Condition, CarePlan - each with the right cardinality and relationships
→ Write normalization logic that could handle what real EHRs actually send, not what the spec says they should send
→ Output a PostgreSQL schema queryable by both the application layer (fast, indexed, relational) and the clinical team (human-readable, auditable, filterable by condition/patient/date)
━━━ Why this matters beyond healthcare ━━━
Any platform where multiple data sources feed a single operational layer - fintech aggregators, multi-ERP SaaS, IoT pipelines - hits the same problem: you don't control the upstream data quality, but downstream users expect consistency.
The FHIR normalization pattern translates directly.
Building something in healthtech, or dealing with messy multi-source data ingestion? Happy to talk through the architecture.
Co-Founder building ambitious software at the intersection of AI, automation, visualization, and creative systems. Currently building HelioraAI, a celestial intelligence platform, and working on autoretto, an autonomous music production pipeline. Shipping fast, learning faster.
normalizing fhir data across different ehr vendors sounds like a nightmare but the kind of nightmare that actually matters. clean data layer is everything when you're dealing with patient outcomes
I’m Johnathan - a full-stack engineer who ships web applications from ground-up to production. Next.js for web, Supabase for backend, and AI/LLMs where they add real value. 8+ years building AI-powered products for healthcare, fintech, real estate, and SaaS teams.
Exactly - Everything looks fine until a CarePlan references an Observation that got dropped in normalization, and now a clinician is making decisions on incomplete data.
The part that changed how I think about data pipelines generally: in most software, bad data is a bug you fix. In clinical systems, bad data has a downstream human consequence. That constraint forces a level of defensiveness in the schema design you don't always apply elsewhere.