Data Modeler

Job Title : Data Modeler

Location : Long Beach, CA (Preferred) - Remote acceptable

About the Role :

We are seeking an experienced Data Modeler to support enterprise data initiatives for a major U.S. healthcare payer, with heavy emphasis on Medicare Advantage and core payer operational systems. The ideal candidate possesses strong data modeling expertise, a deep understanding of modern cloud-based data architectures, and the ability to translate business needs into scalable, high-quality data solutions.

Key Responsibilities :

Design, develop, and maintain logical and physical data models for enterprise systems.

Collaborate with cross-functional teams to convert business requirements into scalable data structures.

Ensure data integrity, normalization, optimization , and overall model quality.

Partner with ETL developers and data engineers to implement models in data warehouses, EDH, and data lakes .

Document data dictionaries, metadata, relationships, and business rules per enterprise standards.

Support data governance , privacy, and compliance requirements (PHI / PII).

Perform data profiling , assess data quality, and define DQ rules and transformation logic.

Required Skills :

5+ years in data modeling, data architecture, or database design.

Hands-on experience with ERwin, PowerDesigner , or similar modeling tools.

Strong SQL skills (Oracle, SQL Server, PostgreSQL).

Strong understanding of dimensional modeling, normalization, relational data structures , and data warehousing.

Experience with Azure Cloud , Data Lakes, and Enterprise Data Hubs.

Strong ability to convert business requirements into technical specifications.

Knowledge of API data formats (JSON, XML).

Excellent communication and stakeholder collaboration skills.

Preferred Qualifications :

Experience with healthcare payer data (claims, provider, member).

Background in data governance and MDM .

Expertise in performance tuning and optimisation.