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.