Data Modeler

Job Title: Data Modeler (Healthcare Domain)

Location: Philadelphia, PA (Hybrid – 3 days/week from office)

Role Summary:

We are seeking a skilled Data Modeler with strong experience in healthcare data environments to design, develop, and maintain enterprise-level data models. The ideal candidate will have hands-on expertise in data modeling, SQL, and data warehousing, along with the ability to analyze business requirements and translate them into scalable data solutions.

Key Responsibilities:

• Design and develop conceptual, logical, and physical data models for enterprise data warehouse (DWH) environments

• Build and maintain data models integrating data from multiple external and internal sources

• Develop and manage enterprise data warehouse structures, ensuring data is centralized and accessible across the organization

• Work with both OLTP systems and data warehouse architectures, ensuring proper data flow and transformation

• Write and optimize complex SQL queries for data extraction, validation, and analysis

• Collaborate with business stakeholders to gather requirements and perform data analysis (BA responsibilities)

• Translate business requirements into scalable and efficient data models

• Ensure data quality, consistency, and governance across systems

• Document data models, data flows, and architecture clearly for technical and non-technical stakeholders

• Support integration of healthcare data standards and ensure compliance with industry regulations

Required Skills & Qualifications:

• Strong domain experience in Healthcare data (claims, clinical, EHR, etc.)

• Hands-on experience in data modeling (conceptual, logical, physical)

• Strong knowledge of SQL with the ability to write complex queries

• Experience in enterprise Data Warehouse (DWH) environments

• Understanding of OLTP systems and data warehousing concepts

• Experience designing data models that integrate and store data from external sources

• Strong understanding of database design, normalization, and relationships

• Ability to clearly explain data modeling concepts and design decisions

• Experience performing business analysis, requirement gathering, and data analysis

• Strong communication and documentation skills

Preferred Qualifications:

• Experience with healthcare data standards (HL7, FHIR, ICD, etc.)

• Familiarity with data modeling tools (ERwin, ER/Studio, PowerDesigner, etc.)

• Experience working in Agile environments