Data Modeler

Principal Data modeler (Must have Erwin Data Exp.) Remote 12 months + Top 3 Skills • Strong problem solving, influencing, communication, and presentation skills, self-starter. • Expertise in Data Modeling, Data Strategy and Roadmap for large and complex health entities and systems and implemented large scale end-to-end Data Management & Analytics solutions for more than one large client. • Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards. • Strong Healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets. • 5+ years of experience with Erwin data modeler Skills • Strong knowledge of regulatory security requirements regarding HIPPA, PHI, PII, and other health care data security standards. • Expertise with normalized OLTP, OLAP, MDM and Dimensional modeling techniques, Star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification. • Expert level SQL skills with direct experience writing complex analytic queries, stored procedures, DDL, DML and DCL. Thorough knowledge of query optimization techniques with the ability to write code to ANSI standards and inspect code written by other developers. • Expertise in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival and Data Migration strategies using appropriate tools. Preferred Skills • Experience with Microsoft Azure cloud infrastructure and services (Azure Data Lake Storage, Azure Data Factory, Purview, Azure Maps, etc.) • Experience with Snowflake DBMS • Experience with PowerBI or Tableau Ideal Candidate We want to be as specific as possible with our firms so they can find the type of candidate you’re looking for. Data modeler with Medicaid/Healthcare experience