Job Description
We are looking for an experienced Senior Healthcare Data Modeler with deep expertise in Medicare, Medicaid, and Claims data. The candidate will be responsible for designing, developing, and maintaining scalable, high-quality data models that support analytics, reporting, regulatory compliance, and downstream applications.
Key Responsibilities
Design and develop conceptual, logical, and physical data models for healthcare datasets
Work extensively with Medicare, Medicaid, and Claims data (Professional, Institutional, Pharmacy)
Analyze source data systems and translate business requirements into optimized data models
Develop and maintain dimensional models (star/snowflake) for data warehouses and marts
Ensure data models support HIPAA compliance, CMS reporting, and regulatory standards
Collaborate with data engineers, analysts, and business stakeholders to ensure accurate data representation
Optimize data models for performance, scalability, and data quality
Define data standards, naming conventions, and best practices
Support ETL/ELT design, data lineage, and metadata management
Perform data validation and reconciliation to ensure model accuracy
Review and improve existing data models to support new healthcare initiatives
Mandatory Skills
12+ years of experience in data modeling and data architecture
Strong hands-on experience with US Healthcare data:
Medicare
Medicaid
Claims (Medical, Institutional, Pharmacy)
Expertise in data modeling tools (ERwin, ER/Studio, Lucidchart, or similar)
Strong knowledge of relational databases (Oracle, SQL Server, PostgreSQL, Snowflake, Redshift)
Experience with dimensional modeling, normalization, and denormalization techniques
Solid understanding of HIPAA, CMS, and healthcare compliance standard