Senior Data Modeler

Jobtailor; Kentucky; On-site; USD 110,000 - 145,000; Full time

Job summary

Jobtailor seeks an experienced Data Architect to design and govern enterprise data architecture. Lead modeling efforts, define standards, and collaborate with stakeholders to map source data to standardized structures.

The role emphasizes data governance, security, and performance in Snowflake environments, with hands-on work in DDL/SQL and ERStudio across healthcare data domains.

Qualifications

• 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 full life-cycle enterprise data warehousing.
• Healthcare domain experience preferred, especially EHR/Clinical domain.
• Exposure working on Snowflake platform.
• Experience with HL7 FHIR profiles and resources to map enterprise data.
• Experience with ERStudio or similar data modeling tool.
• Extensive experience of ER and Dimensional modeling concepts.

Responsibilities

• Designs, implements, and documents complex data architecture and data modeling solutions.
• Participates in project-specific architectural groups to provide modeling expertise.
• Provides inputs on data management, access, and security requirements.
• Documents data flows from origination and acquisition points.
• Governs expansion of existing data architecture.
• Creates first-cut physical model DDL and SQL for DBA implementation.
• Builds and updates the data dictionary with governance teams and users.
• Leads model review sessions and updates data modeling standards.
• Contributes to designing Snowflake's Silver and Gold analytical layers.

Skills

Data architecture

Data modeling

Snowflake

ERStudio

HL7 FHIR

Healthcare domain

SQL

Data governance

Security concepts

Dimensional modeling

Education

Bachelor's degree or higher

Tools

ERStudio

Snowflake

Job description

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

Requirements

• 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