🌿 Back to all jobs
🥝 Lead Data Warehouse Engineer - Scientific Computing & Data
Mount Sinai Health System | New York, United States | Posted April 12, 2026
Job Description
DescriptionResponsibilitiesDesign 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.