Data Warehouse Architect/Modeler

| Chicago | Hybrid
Sorry, this job was removed at 12:15 p.m. (CST) on Wednesday, April 15, 2020
Find out who's hiring remotely in Chicago.
See all Remote Data + Analytics jobs in Chicago
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

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
Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
  • People Operations
    • GolangLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • SwiftLanguages
    • GCPLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • SparkFrameworks
    • TensorFlowFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • SQLiteDatabases
    • LookerAnalytics
    • TableauAnalytics
    • FigmaDesign
    • ConfluenceManagement
    • Google DriveManagement
    • Google DocsManagement
    • Google SlidesManagement
    • JIRAManagement
    • TrelloManagement
    • DocuSignCRM
    • SalesforceCRM
    • MarketoLead Gen
    • Google HangoutsCollaboration
    • SlackCollaboration
    • ZoomCollaboration

Location

Our Chicago office is located in downtown River North. Right on the river and close to neighborhoods like Fulton Market, Central Business District, Lincoln Park, and Streeterville, it's a lively area with convenient transportation access and is home to many bars, restaurants, and coffee shops.

An Insider's view of Tempus AI

What’s the vibe like in the office?

The casual setting here in the Chicago office makes everyone less intimidating and more approachable. It's nice to be in an environment where our day-to-day work actually makes a difference, I feel valued. Tempus is also great at welcoming everyone with different backgrounds.

Alexis

Clinical Lab Associate

How do you collaborate with other teams in the company?

I collaborate with various hiring teams on a daily basis. Through weekly meetings, strategic planning, events, and messaging, hiring teams and I have built a collaborative hiring process and have become trusted partners to bring top talent to Tempus. We rely on honest communication, shared goals, and the right tools to set us up for success!

Emma

Recruiter

How does the company support your career growth?

I am always looking for the next opportunity to grow my career, and Tempus has a wealth of opportunities in many departments. Through emerging leaders programs and ongoing conversations with my managers, Tempus has always been supportive in guiding me to find work that is fun, interesting, and maximizes my potential.

Aaron

Senior Operations Manager

What are some things you learned at the company?

One of the things that molded my growth was seeing how much thought goes into the decisions, and how much leadership seeks feedback from the people around them, to help understand the impact of decision-making. Just being a sponge in the room is inspiring. I adapted the styles of many leaders here and use that to create my own leadership style.

Anita

Laboratory Operations Manager

What are Tempus AI Perks + Benefits

Tempus AI Benefits Overview

Health Insurance
Dental Insurance
Vision Insurance
Life Insurance
Short-Term Disability Insurance
Flexible Spending Account
Commuter Benefits
Parental Leave
Charitable Matching Program
Employee Assistance Program (EAP)
Pet Insurance
Company Cafeteria with Breakfast, Lunch & Grab & Go Options
Stocked Kitchen with Snacks
On-Site Barista
Discounted Gym Membership
Discounted Divvy Membership
Diversity & Inclusion Initiatives
Team & Company Outings

Culture
Volunteer in local community
Open door policy
OKR operational model
Team based strategic planning
Pair programming
Open office floor plan
Employee resource groups
Employee-led culture committees
Hybrid work model
Flexible work schedule
Remote work program
Diversity
Highly diverse management team
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Wellness programs
Mental health benefits
Financial & Retirement
401(K)
Company equity
Charitable contribution matching
Child Care & Parental Leave Benefits
Generous parental leave
Family medical leave
Vacation & Time Off Benefits
Unlimited vacation policy
Generous PTO
All staff in Tempus’ laboratories are subject to Tempus’ separate laboratory PTO policies.
Paid volunteer time
Paid holidays
Paid sick days
Flexible time off
Bereavement leave benefits
Office Perks
Commuter benefits
Company-sponsored outings
Free snacks and drinks
Some meals provided
Company-sponsored happy hours
Onsite office parking
Recreational clubs
Relocation assistance
Meditation space
Mother's room
Onsite gym
Professional Development Benefits
Job training & conferences
Lunch and learns
Promote from within
Mentorship program
Continuing education available during work hours

More Jobs at Tempus AI

Easy Apply
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Tempus AIFind similar jobs like this