Senior Data Modeler
$120,000–$170,000 year
On-siteChicago, Illinois, United States or New York City, New York, United States
Job Summary
Manage an enterprise data model in collaboration with clinicians, data scientists, engineers, and product managers to integrate clinical data from source systems across multiple complex domains. Author and maintain entity-relationship diagrams, data dictionaries, API specs, and translation documentation at multiple abstraction levels while implementing solutions to transform source data into a common data model. Collaborate to validate feature definitions for clinical endpoints and proactively monitor data quality with traceability to source systems. Advocate for data modeling rules, standards, and best practices across the engineering team. This role supports Tempus' mission to create the world's largest integrated dataset of multimodal healthcare and clinical data, utilizing a modern tech stack including Python, dbt, and BigQuery on GCP.
Required Qualifications
- 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, concepts and frameworks, and experience implementing them
- experience with data modeling tools like Erwin, Vertabelo or Lucidchart
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.