Lead Data Warehouse Engineer - Scientific Computing & Data

Mount Sinai Health System

FULL_TIME Computer Occupations
Apply Now
Location
New York, New York, United States
Posted
April 12, 2026

Job Description


Description

Responsibilities
  • Design databases and pipelines that balance functionality, performance, cost, and development time; evaluate technical options with the product manager.
  • Design, build, test, and maintain ETL/ELT processes using T-SQL stored procedures, SSIS, and SQL Agent; apply metadata-driven design for extensibility.
  • Serve as a team leader; contribute to project planning, work breakdown, dependency sequencing, and release management.
  • Develop and promote standards, conventions, design patterns, DevOps/SDLC best practices, and operational procedures for pipelines and warehouse maintenance.
  • Mentor junior engineers in data warehousing, data engineering skills, and operational support.
  • Design, build, and maintain data management processes, including loading flat files (csv, tsv, pipe-delimited, JSON).
  • Lead design sessions, code walkthroughs, peer reviews, and produce technical documentation.

    • Job Details

    • Job Type
      FULL_TIME
    • Category
      Computer Occupations
    • Date Posted
      April 12, 2026
    • Application Deadline
      May 22, 2026