Data Warehouse Architect/Modeler

| Chicago
Apply now

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.

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
Apply now

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • AWSLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • SQLiteDatabases
    • tableuAnalytics
    • JIRAManagement
    • SalesforceCRM

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

Culture
Volunteer in local community
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Paid Holidays
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Diversity Program
Lunch and learns
Promote from within
Time allotted for learning
More Jobs at Tempus100 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Operations
Product
Project Mgmt
Sales
Content
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Content
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Content
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Content
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
HR
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Apply now
Save jobView Tempus's full profileSee more Tempus jobs