Data Modeler

Primary Responsibilities

• Design and implement enterprise data models and data architecture for large, complex healthcare systems.
• Translate business and technical requirements into scalable data models and end-to-end data solutions.
• Develop data strategies, roadmaps, and data management solutions supporting analytics and enterprise reporting.
• Design normalized OLTP, OLAP, MDM, and dimensional models, including Star schemas, SCDs, role-playing dimensions, hierarchies, and data classification.
• Develop and review complex SQL queries, stored procedures, DDL, DML, and DCL using ANSI standards.
• Optimize SQL queries and analyze database performance.
• Define and implement data quality, profiling, governance, security, metadata management, MDM, archival, and migration strategies.
• Ensure compliance with healthcare data security and privacy requirements, including HIPAA, PHI, and PII.
• Collaborate with Data Managers, Data Integration Leads, Data Engineers, and business stakeholders.
• Provide technical leadership, problem-solving, presentations, and recommendations for complex data initiatives.

Required Skills & Qualifications

• 8+ years of experience in Data Modeling, Data Architecture, or Data Management.
• 5+ years of hands-on experience with Erwin Data Modeler.
• 5+ years of experience working with healthcare data and healthcare information systems.
• Strong experience with Medicaid, Medicare, and Commercial healthcare datasets; Medicaid experience is highly preferred.
• 7+ years of advanced SQL experience, including complex queries, stored procedures, DDL, DML, DCL, and query optimization.
• Strong expertise in OLTP, OLAP, MDM, and dimensional data modeling.
• Experience with Star schemas, Slowly Changing Dimensions (SCD), role-playing dimensions, dimensional hierarchies, and data classification.
• Strong knowledge of Data Governance, Data Quality, Data Profiling, Data Security, Metadata Management, MDM, Data Archival, and Data Migration.
• Strong understanding of HIPAA, PHI, PII, and healthcare data privacy/security requirements.
• Excellent problem-solving, communication, influencing, presentation, and stakeholder management skills.
• Ability to work independently and take ownership of complex data initiatives.

Preferred Skills

• Experience with Microsoft Azure data services, including Azure Data Lake Storage, Azure Data Factory, Microsoft Purview, and Azure Maps.
• Experience with Snowflake.
• Experience with Power BI or Tableau.
• Experience designing and implementing large-scale healthcare data warehouse and analytics solutions.