Senior Data Modeler

About the role

Tempus is seeking a Data Modeler to join our dynamic team. This role involves managing an enterprise data model in collaboration with clinicians, data scientists, engineers, product managers, and operators to integrate clinical data from various complex domains.

Responsibilities

• Manage an enterprise data model in collaboration with clinicians, data scientists, engineers, product managers, and operators to integrate clinical data from source systems in multiple complex domains (clinical records, EHR data, ECG data, radiology, et al.)
• Author and maintain entity-relationship diagrams, data dictionaries, API specs, and data translation documentation at multiple levels of abstraction (conceptual, logical, physical) and across multiple data store technologies (transactional, analytical)
• Implement solutions to transform source data to a common data model
• Collaborate with clinicians and data scientists to implement and validate feature definitions for clinical endpoints aligned with modeling priorities
• Implement solutions to proactively monitor data quality with traceability to source systems
• Evaluate completeness of source system data models and data by profiling partner data
• Advocate and educate engineering team members on data modeling rules, standards, and best practices

Requirements

• You have domain knowledge in healthcare and informatics data
• You have experience and knowledge of different data modeling techniques (e.g. 3NF, dimensional (star schema), and data vault)
• You have applied exceptional SQL skills in an enterprise data warehouse environment
• You have knowledge of ETL/ELT and BI architectures, concepts and frameworks, and experience implementing them
• You understand and can clearly articulate the long-term impacts of key decisions between database technologies (relational, MPP, NoSQL) and have experience architecting solutions across multiple technologies
• You have experience with data modeling tools like Erwin, Vertabelo or Lucidchart
• Bonus points for experience with GCP architecture, particularly with BigQuery, experience working with clinical and cardiovascular (echo, cath, ECG) data, experience with Epic tables, experience with HL7 data, experience writing and debugging Python, and experience working with dbt
• Experience implementing master, reference, or metadata management solutions

Qualifications

• Master's degree in Computer Science, Informatics, or related field
• 5+ years of experience in data modeling and integration
• Proven track record of successful data modeling projects
• Strong understanding of data warehousing and data management principles
• Experience with Python, dbt, and BigQuery on GCP
• Experience with Epic tables, HL7 data, and cardiovascular data

Skills

• Data modeling
• ETL/ELT
• BI architectures
• Python
• dbt
• BigQuery on GCP
• Epic tables
• HL7 data
• Cardiovascular data

Benefits

Tempus offers a full range of benefits, including incentive compensation, restricted stock units, medical and other benefits depending on the position. We are an equal opportunity employer.