Epic Clarity Data Model Certified Consultant
We are seeking an Epic Clarity Data Model Certified Consultant to lead metadata extraction, lineage mapping, and governance alignment between Epic (Chronicles, Clarity, Caboodle) and Microsoft Purview for a multi‑hospital, Microsoft‑centric healthcare analytics environment. Key Responsibilities Metadata Extraction & Documentation Extract full Clarity/Caboodle schema (tables, columns, data types, descriptions, Chronicles mappings) using approved Epic utilities or SQL queries. Deliver export files (CSV/JSON) suitable for automated import into Microsoft Purview. Governance Mapping Translate Epic data definitions into business glossary terms and classifications for Purview. Identify PHI fields and advise on custom classification rules (e.g., MRN, FIN, CSN). Lineage & ETL Advisory Map lineage from Chronicles → Clarity → Caboodle → Azure (Synapse, Data Lake). Document ETL schedules, dependencies, and refresh cadence. Access & Security Alignment Collaborate with Security team to map Epic role‑based access to Azure AD groups and Purview Data Policies. Knowledge Transfer & Documentation Produce technical playbooks, data dictionaries, and training sessions for internal teams. Required Skills & Certifications Epic Certification — Epic Clarity Data Model (must be current/active). 5+ years hands‑on Clarity reporting & SQL optimization (SQL Server or Oracle). Demonstrated experience in at least one prior Epic‐to‐cloud data integration or migration project. Strong grasp of healthcare data governance, HIPAA, 42 CFR Part 2, and PHI handling. Ability to write and optimize SQL, design ETL specs, and work with source control. Proven stakeholder communication skills (Clinicians, HIM, Security, Data Engineering). Preferred / Nice‑to‑Have Caboodle, Cogito, or Epic Care Everywhere certifications. Experience with Microsoft Purview (Data Map, Glossary, Classification, Data Policies). Familiarity with Azure Data Factory, Synapse Pipelines, or equivalent ETL tools. Knowledge of FHIR or HL7 integration patterns.