Senior Data Modeler

Tempus AI, Inc.; Chicago (IL); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Incentive compensation

Restricted stock units

Medical benefits

Job summary

Tempus AI, Inc. is seeking a Data Model Manager in Chicago, Illinois, to lead the integration of clinical data from various systems. You'll work with a team of clinicians, data scientists, and engineers to establish data modeling best practices and ensure data quality.

Ideal candidates have significant domain knowledge in healthcare informatics and exceptional SQL skills, with experience in data modeling techniques, including 3NF and dimensional modeling.

Qualifications

• You have applied exceptional SQL skills in an enterprise data warehouse environment.
• You have experience and knowledge of different data modeling techniques (e.g. 3NF, dimensional, and data vault).
• You have experience with data modeling tools like Erwin.

Responsibilities

• Manage an enterprise data model in collaboration with the team.
• Author and maintain entity-relationship diagrams and data documentation.
• Implement solutions to transform source data to a common data model.

Skills

Domain knowledge in healthcare and informatics data

SQL skills in an enterprise data warehouse environment

Experience with data modeling techniques

Knowledge of ETL/ELT and BI architectures

Experience with data modeling tools like Erwin

Tools

BigQuery

Python

dbt

Job description

Passionate about precision medicine and advancing the healthcare industry? Recent advancements in underlying technology have finally made it possible for AI to impact clinical care in a meaningful way. Tempus' proprietary platform connects an entire ecosystem of real-world evidence to deliver real-time, actionable insights to physicians, providing critical information about the right treatments for the right patients, at the right time.

Tempus is executing on the mission to create the world’s largest, integrated dataset of multimodal healthcare and clinical data. At Tempus, products are owned and developed by small, autonomous teams composed of developers, designers, data scientists, clinicians, and product managers. You and your team set the goals, build the software, deploy the code, and contribute to a growing software platform that will make a lasting impact in the field of cardiovascular research and treatment.

Tempus builds software as nimble as our teams. Our modern tech stack – Python, dbt and BigQuery on GCP – allows our teams to iterate rapidly and lead our industry in innovation. Our decentralized, microservice architecture and emphasis on automation allow us to deliver advanced solutions with confidence, and at scale.

What You’ll Do

• 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.

Why we’re looking for you

• 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

• 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
• Experience working with dbt
• Implementing master, reference, or metadata management solutions

Salary: $110,000-$160,000 (Illinois); $120,000-$170,000 (NYC/Boston). The expected salary range above is applicable if the role is performed from Illinois and may vary for other locations (California, Colorado, New York). Actual salary may vary based on qualifications and experience.

Tempus offers a full range of benefits, which may include incentive compensation, restricted stock units, medical and other benefits depending on the position.

We are an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.