Senior Data Modeler - Healthcare Data & Analytics Lead

Jobtailor; Illinois; On-site; USD 120,000 - 170,000; Full time

Job summary

Jobtailor in Illinois seeks a Data Model Specialist to manage an enterprise data model in collaboration with clinicians and data scientists, ensuring alignment with clinical needs.

You will design and maintain ER diagrams and data dictionaries, implement data transformations, and monitor data quality to ensure reliable analytics.

Qualifications

• Domain knowledge in healthcare and informatics data.
• Experience with data modeling techniques (3NF, star schema, Data Vault).
• Exceptional SQL skills in an enterprise data warehouse.
• Knowledge of ETL/ELT and BI architectures.
• Experience implementing ETL/ELT and BI solutions.
• Ability to articulate the impact of database technology decisions.
• Experience with data modeling tools such as Erwin, Vertabelo or Lucidchart.

Responsibilities

• Manage an enterprise data model collaborating with clinicians and data scientists.
• Author and maintain entity-relationship diagrams and data dictionaries.
• Implement solutions to transform source data to a common data model.
• Collaborate with clinicians to implement and validate feature definitions.
• Monitor data quality with traceability to source systems.
• Evaluate completeness of source data models.

Skills

SQL

Data modeling techniques

Healthcare domain knowledge

ETL/ELT knowledge

BI architectures

Database decision impact

Data modeling tools

Tools

Erwin

Vertabelo

Lucidchart

Job description

• Manage an enterprise data model collaborating with clinicians and data scientists
• Author and maintain entity-relationship diagrams and data dictionaries
• Implement solutions to transform source data to a common data model
• Collaborate with clinicians to implement and validate feature definitions
• Monitor data quality with traceability to source systems
• Evaluate completeness of source data models

Requirements

• domain knowledge in healthcare and informatics data
• experience and knowledge of different data modeling techniques (e.g. 3NF, dimensional (star schema), and data vault)
• exceptional SQL skills in an enterprise data warehouse environment
• knowledge of ETL/ELT and BI architectures
• experience implementing ETL/ELT and BI solutions
• ability to articulate the impact of database technology decisions
• experience with data modeling tools like Erwin, Vertabelo or Lucidchart

🔍 ATS Optimization Keywords
Below are skills and terms extracted directly from this job posting to improve Applicant Tracking System (ATS) visibility. This unique feature helps candidates tailor their applications more effectively — a feature exclusive to JobTailor job listings.

Hard Skills

• Data Modeling Techniques
• SQL
• ETL
• ELT
• Data Quality Monitoring
• Data Transformation
• Entity-Relationship Diagrams
• Data Dictionaries
• Data Vault
• Dimensional Modeling

Soft Skills

• Collaboration
• Communication
• Articulation of Impact