Blog
In-depth guides, tutorials, and best practices for database design, data architecture, and healthcare data modeling.
The honest guide to free and low-cost data modeling tools for healthcare data engineers — covering ER diagramming, DDL conversion, schema validation, HL7 parsing, and NPI lookup, by actual use case.
Showing 1–6 of 60 posts
A production-ready healthcare claims data model covering professional, institutional, and pharmacy claims — with full SQL schema, adjudication history, diagnosis tables, and key reporting queries.
A practical segment-by-segment guide to translating HL7 v2 messages (ADT, ORU, DG1, AL1) into FHIR R4 resources — with real JSON examples and the common pitfalls that break translation pipelines.
Every DDL syntax difference between MySQL and PostgreSQL — data types, AUTO_INCREMENT, ENUM, indexes, case sensitivity, and function replacements — with exact conversion examples.
A data contract is a formal agreement between the team that produces data and the teams that consume it — specifying schema, quality rules, SLAs, and ownership. In healthcare, where a schema change in the claims pipeline can break downstream HEDIS calculations, data contracts are a stability mechanism, not a formality.
HCC risk adjustment determines how much revenue a health plan receives for each Medicare Advantage member. The data model behind it — from diagnosis code ingestion to RAF score calculation — is one of the most consequential schemas a payer data engineer will build.
Get the latest healthcare data architecture articles delivered to your inbox.