Senior Data Modeler / Canonical Data Architect

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.