Data Modeler with a healthcare

Machine Learning Technologies, LLC; Weehawken (NJ); On-site; USD 89,000 - 126,000; Full time

Job summary

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

Qualifications

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

Responsibilities

• 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.

Skills

Data modeling

SQL

ERwin

ER/Studio

Healthcare domain

Data profiling

Data quality

Data lineage

Requirements gathering

Communication

Self-directed

Tools

ERwin Data Modeler

ER/Studio

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Data Modeler with a healthcare

Duration: 10 Months + Extension

Bill Rate: $78/hour (C2C)

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization:US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Seeking an experienced Data Modeler with a healthcare background to support Revenue Cycle Analytics initiatives. The resource will partner with business stakeholders, analysts, and data engineering teams to understand reporting requirements, assess source data, and design scalable data models that enable reliable and consistent analytics.

The ideal candidate will bring strong hands-on experience in data modeling, SQL, and data modeling tools such as ERwin, along with a solid understanding of healthcare revenue cycle processes and the ability to translate business requirements into practical technical designs.

Roles and Responsibilities

• 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.

Required Qualifications

• Hands-on experience in data modeling for data warehouse, reporting, and analytics solutions.
• Experience with ERwin Data Modeler, ER/Studio, or comparable enterprise data modeling tools.
• Healthcare domain experience, preferably in Revenue Cycle Analytics.
• Strong SQL skills for data profiling, analysis, reconciliation, and validation.
• Strong understanding of conceptual, logical, physical, and dimensional data modeling.
• Experience with fact/dimension modeling, data relationships, keys, granularity, and historical data management.
• Ability to translate business requirements into data models, source-to-target mappings, and technical specifications.
• Strong communication skills with experience working directly with business stakeholders, analysts, and engineering teams.
• Ability to work independently and deliver within defined timelines..

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.