Database Modeler

Role OverviewWe are seeking a highly skilled Database Modeler to support the data modernization and centralization of a statewide Health Management System. This role focuses on data modeling, Master Data Management (MDM), and Master Patient Index (MPI) implementation within a cloud-driven environment. The ideal candidate will bring strong expertise in data governance, data quality, and healthcare data standards, ensuring secure, accurate, and scalable data systems aligned with compliance requirements. Key Responsibilities

• Develop and maintain a comprehensive data dictionary, including data definitions, naming standards, and version control processes
• Integrate data standards into the Software Development Lifecycle (SDLC) for consistency across teams
• Provide subject matter expertise in Master Patient Index (MPI) design and implementation
• Evaluate existing system architecture and design cloud-based MPI solutions
• Collaborate with stakeholders to cleanse and standardize patient data, resolving duplicates and inconsistencies
• Apply Master Data Management (MDM) rules for data matching, merging, and record linking
• Define and implement data governance policies ensuring quality, security, and compliance with HIPAA
• Conduct data quality assessments to identify gaps, redundancies, and inconsistencies
• Establish data lineage, validation, and deduplication strategies
• Support cloud migration and HMS centralization initiatives
• Ensure compliance with all data security and confidentiality standards

Scope of Work

• Deliver hands-on data modeling and MDM solutions for healthcare system modernization
• Design and implement a cloud-based Master Patient Index (MPI)
• Build and maintain enterprise-level data governance frameworks
• Work closely with cross-functional teams (technical + business)
• Ensure alignment with modernization and cloud transformation goals while maintaining strict compliance standards

• Strong expertise in data modeling, data governance, and MDM frameworks
• Experience with healthcare data systems and patient data management
• Knowledge of data quality, deduplication, and data lineage concepts
• Ability to analyze complex data environments and provide practical solutions
• Strong communication skills to translate technical concepts for business users
• Experience working in structured SDLC environments
• High attention to detail with strong documentation skills

Preferred Qualifications

• Experience with Master Patient Index (MPI) implementations
• Exposure to cloud platforms (AWS, Azure, or GCP)
• Familiarity with data governance tools and data quality platforms
• Understanding of healthcare interoperability standards (HL7, FHIR)