Senior Data Modeler / Canonical Data Architect
Remote
1+ Year
* Design Conceptual, Logical, Canonical and Physical Data Models for healthcare payer domains.
* Develop canonical models covering Member, Enrollment, Eligibility, Claims, Claim Lines, Provider, Plan, Benefits, Authorization and Payment.
* Define standardized entities, attributes, relationships, cardinality, business definitions and data standards.
* Perform source-to-canonical and canonical-to-target mapping across multiple payer systems.
* Strong understanding of OLTP data modeling, normalization/denormalization and dimensional modeling.
* Hands-on experience with Aurora PostgreSQL/MySQL and advanced SQL, including query optimization and performance tuning.
* Experience with data modeling tools such as ER/Studio, Erwin, Sparx Enterprise Architect, PowerDesigner or Oracle Data Modeler.
* Experience with data governance, metadata, lineage, data dictionaries, business glossaries and data quality.
* Strong payer knowledge including Member, Eligibility, Claims/Claim Lines, Provider, ICD-10, CPT, HCPCS, NPI and 837/835/834 transactions.
* Experience integrating canonical models with AWS/cloud data platforms, Data Lakes, Databricks/Snowflake and Member 360/Claims Analytics.