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.