Senior Data Modeler

Responsibilities

• Designs, implements, and documents more complex data architecture and data modeling solutions
• Participates in project specific architectural working groups to provide expertise in modeling
• Provides architectural inputs on the data management and consumption layers, access and security requirements
• Documents data flows from origination and acquisition points
• Governs the expansion of existing data architecture
• Creates first cut physical model DDL and SQL for implementation by the DBA
• Creates, validates, and updates the data dictionary by coordinating with data governance team and business users
• Facilitates model review sessions and revises data modeling standards and guidelines
• Plays a key role in designing the Silver and Gold analytical layers in Snowflake

• Bachelor's degree or advanced degree (where required)
• 5+ years of experience in related field
• In lieu of degree, 7+ years of experience in related field
• Experience leading other data modelers in a successful full life-cycle enterprise data warehousing effort
• Healthcare domain experience preferred especially EHR/Clinical domain
• Exposure working on Snowflake platform
• Experience and exposure with HL7 FHIR (Fast Healthcare Interoperability Resources) profiles and resources in order to map enterprise data or source data to appropriate FHIR resources
• Working experience on ERStudio or similar data modeling tool
• Extensive experience of ER and Dimensional modeling concepts