Data Warehouse Architect / Data Modeler

| Chicago

About our teams: Tempus is executing on the mission to create the world’s largest, integrated dataset of molecular and clinical data. At Tempus, products are owned and developed by small, autonomous teams composed of developers, designers, data scientists, 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 cancer research and treatment.

Tempus builds software as nimble as our teams. Our modern tech stack - React, NodeJS, and Python on AWS - 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 engineers, product managers, scientists, and operators to integrate structured data from source systems in multiple complex domains (clinical records, genomics, NGS lab, 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 (relational, NoSQL).
  • Advocate and educate engineering team members on data modeling rules, standards, and best practices.
  • Evaluate completeness of source system data models and data by profiling partner data.
  • Implement solutions to proactively monitor data quality with traceability to source systems.

Why we’re looking for you:

  • You have strong experience and knowledge of 3NF, dimensional (star schema), and data vault modeling techniques.
  • You have applied exceptional SQL skills in an enterprise data warehouse environment.
  • You have knowledge of ETL/ELT and BI architectures, concepts and frameworks.
  • 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 Vertabelo or Erwin.
  • You have domain knowledge in healthcare.

Bonus points for:

  • Experience with AWS architecture
  • Experience working with clinical and/or genomic data
  • Experience writing and debugging Python
  • Chairing a data governance board for a complex organization
  • Implementing master, reference, or metadata management solutions
Read Full Job Description

Location

600 WEST CHICAGO AVENUE, Chicago, IL 60654

An Insider's view of Tempus

What makes someone successful on your team?

We value creativity in ideation, autonomy in execution, and a healthy tendency to always question the status quo.

Ash

Lead Data Scientist

What are Tempus Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
Child Care & Parental Leave Benefits
Generous Parental Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Fitness Subsidies
Professional Development Benefits
Diversity Program
More Jobs at Tempus75 open jobs
All Jobs
Data + Analytics
Dev + Engineer
HR
Internships
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
HR
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Product
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
HR
new
Chicago
Sales
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Operations
new
Chicago