Senior Data Modeler

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

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.

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.