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.

• 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

• 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

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