Data Modeler, Healthcare Revenue Cycle Analytics

Machine Learning Technologies, LLC; Weehawken (NJ); Presencial; USD 89.000 - 126.000; Jornada completa

Descripción de la vacante

Machine Learning Technologies, LLC seeks an experienced Data Modeler with a healthcare background to support Revenue Cycle Analytics initiatives. You will partner with business stakeholders, analysts, and data engineers to define reporting needs and design scalable data models that enable reliable analytics.

The ideal candidate has hands-on data modeling, strong SQL skills, and experience with ERwin (or ER/Studio) to translate business requirements into practical technical designs within

Formación

• Hands-on experience in data modeling for data warehouse, reporting, and analytics solutions.

Responsabilidades

• Partner with Revenue Cycle Analytics stakeholders to gather, clarify, and document business requirements, reporting needs, metrics, and data definitions.
• Analyze source systems, datasets, and existing reporting structures to identify data relationships, dependencies, and gaps.
• Develop and maintain conceptual, logical, and physical data models using ERwin or similar data modeling tools.
• Define entities, attributes, primary and foreign keys, relationships, data granularity, and historical tracking requirements.
• Design dimensional data models, including fact and dimension tables, to support reporting and analytical use cases.
• Develop source-to-target mappings and document transformation logic, business rules, metadata, and data lineage.
• Collaborate with data engineering teams to translate models into implementable data structures and integration workflows.
• Use SQL for data profiling, relationship validation, reconciliation, discrepancy analysis, and data quality assessment.
• Partner with business stakeholders to establish consistent definitions for revenue cycle metrics across reporting solutions.
• Support implementation validation and UAT to ensure delivered datasets meet business and reporting requirements.
• Maintain data models, data dictionaries, mapping specifications, and knowledge-transfer documentation.

Conocimientos

Data modeling

SQL

ERwin

ER/Studio

Healthcare domain

Data profiling

Data quality

Data lineage

Requirements gathering

Communication

Self-directed

Herramientas

ERwin Data Modeler

ER/Studio

Descripción del empleo

Machine Learning Technologies, LLC seeks an experienced Data Modeler with a healthcare background to support Revenue Cycle Analytics initiatives. You will partner with business stakeholders, analysts, and data engineers to define reporting needs and design scalable data models that enable reliable analytics.

The ideal candidate has hands-on data modeling, strong SQL skills, and experience with ERwin (or ER/Studio) to translate business requirements into practical technical designs within