AI-Ready Data Warehouse Lead Engineer

Mount Sinai; New York (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

The Icahn School of Medicine at Mount Sinai seeks a Lead Data Warehouse Engineer to guide the ongoing integration of multi-modal clinical data into the AIR.MS warehouse. You will assess data integration state, plan metadata integration, and lead implementation with the AIR.MS platform teams.

The role requires 12–15 years of relevant experience, including 7 years designing and maintaining relational databases and data pipelines.

Qualifications

• Bachelors degree in a technical discipline; Masters degree preferred.
• 12-15 years preferred of related experience, including 7 years designing, developing, and maintaining relational databases, data pipelines, and dimensional/OLAP warehouses.

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 data pipelines that extract/capture data from source systems, transform and augment those data, and integrate it into a multi-modal data repository.
• Lead design sessions, code walkthroughs, peer reviews, and produce technical documentation.
• Mentor junior engineers in data warehousing, data engineering skills, and operational support.

Skills

SQL

Data warehousing

Dimensional modeling

Change data capture

Incremental loads

Data lineage

Source-to-target mappings

DevOps practices

Agile (Scrum/Kanban)

JIRA & Confluence

Git version control

Communication skills

Healthcare data knowledge

Hadoop/Spark/Kafka

Education

Bachelor's degree in a technical discipline

Master's degree preferred

Tools

SAP HANA

MySQL

Hadoop

Spark

Kafka

Job description

The Icahn School of Medicine at Mount Sinai seeks a Lead Data Warehouse Engineer to guide the ongoing integration of multi-modal clinical data into the AIR.MS warehouse. You will assess data integration state, plan metadata integration, and lead implementation with the AIR.MS platform teams.

The role requires 12–15 years of relevant experience, including 7 years designing and maintaining relational databases and data pipelines.