Must have - Healthcare domain knowledge is required for this role (EPIC, Cerner etc.)
- Work with Data modeler to develop conceptual, logical, and physical data models aligned with IBM UDMH
- Create source-to-target mapping documents and data lineage documentation.
- Extend IBM UDMH models to fit Ascensions custom requirements.
- Data Analysis & Profiling:
- Conduct comprehensive data profiling across systems likeEpic, Cerner, Athena, and Oracle FDI
- Assess data granularity, quality, volume, and frequency.
- Collaboration & Documentation:
- Work with cross-functional teams to gather requirements and define subject-area models.
- Align with data modeling standards and naming conventions.
- Document metadata and maintain governance protocols.
- Tool Usage:
- Experience with ER/Studio, ERwin, PowerDesigner for modeling
- Use SQL, Python, and Unix for ETL scripting and data transformation.
- Familiarity with Snowflake, Hadoop, Spark, and cloud platforms like AWS and Azure.
