Data Engineer (SQL Developer)

| Greater NYC Area
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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

  • Design, develop, and optimize data structures, ETL/ELT solutions, stored procedures, and functions using SQL and modern, cloud-based ETL/ELT technologies.
  • Work with team architects and internal stakeholders across the company in areas such as data science, clinical and molecular SMEs, and source system data producers to refine business requirements during development.
  • Evaluate completeness of source system data by performing a profiling analysis.
  • Deploy code with established CI/CD change management guidelines.
  • Monitor performance of production processes and recommend areas for improvement.
  • Triage issues reported by users in production systems. 
  • Analyze existing SQL queries for performance improvement opportunities.
  • Implement solutions to proactively monitor data quality with traceability to source systems.
  • Maintain data warehouse ecosystem documentation such as ER Diagrams, data dictionaries, process descriptions, data catalog, etc. according to team standards.

Why we’re looking for you:

  • Domain knowledge in healthcare or genomics.
  • Knowledge of dimensional and relational database modeling concepts such as referential integrity, normalization, etc.
  • Ability to translate business requirements into SQL code.
  • Ability to adapt quickly in a rapidly changing environment while effectively managing multiple projects and priorities simultaneously.
  • Exceptional SQL skills in an enterprise data warehouse environment.
  • Experience with ETL/ELT and BI architectures, concepts and frameworks.
  • Knowledge of data management best practices like incremental vs full loads, how to handle deleted data in source systems, insert-only vs merge architecture, etc.
  • Background working with high volume and high velocity data warehouses.
  • Emphasis on data quality, unit testing, and creating testing frameworks for reliable data.
  • Comfortable working with stakeholders and SMEs across the company.
  • Enjoys a fast-paced environment with a variety of small projects and bigger initiatives. 
  • Flexible to changing priorities. 

Bonus points for:

  • Experience with AWS or GCP architecture
  • Experience working with clinical and/or genomic data
  • Experience writing and debugging Python (SQL is required)
  • Familiarity with modern ELT tools such as DBT
  • Familiarity working within containerized environments
#LI-BL1
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
    • GolangLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • GCPLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • SparkFrameworks
    • TensorFlowFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • SQLiteDatabases
    • JIRAManagement

Location

Mid-Town Manhattan

An Insider's view of Tempus

How does the company support your career growth?

I have frequent meetings with my manager, solely about the direction I want to lead my career in. The most amazing part about having these discussions is that the focus is on how Tempus can help me succeed. Having that guidance and motivation is really beneficial.

Patrick McCormick

Junior Clinical Data Abstractor

What are Tempus Perks + Benefits

Tempus Benefits Overview

Health Insurance
Dental Insurance
Vision Insurance
Life Insurance
Short Term Disability Insurance
Flexible Spending Account
Commuter Benefits
Parental Leave
Charitable Matching Program
Mental Health Support Platform
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
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Flexible Work Schedule
Remote Work Program
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Happy Hours
Relocation Assistance
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Diversity Program
Promote from within
Customized development tracks
More Jobs at Tempus26 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Legal
Project Mgmt
Sales
Content
Content
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Developer
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Developer
new
New York
Data + Analytics
new
New York
Data + Analytics
new
New York
Developer
new
New York
Data + Analytics
new
New York
Developer
new
New York
Design + UX
new
New York
Data + Analytics
new
New York
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Tempus's full profileSee more Tempus jobs