AI-Ready Data Warehouse Lead Engineer

Mount Sinai Health System; New York (NY); On-site; USD 145,200 - 217,875; Full time

Job summary

Mount Sinai Health System seeks a Lead Data Warehouse Engineer for its Scientific Computing and Data team. This senior role involves leading the integration of diverse clinical data into the AIR.MS data warehouse. The ideal candidate will have extensive experience in data warehousing, relational databases, and a solid understanding of healthcare data. Responsibilities include designing databases, executing data integration plans, and mentoring junior engineers. This position offers a salary range of $145,200 - $217,875 annually, reflecting experience and need.

Qualifications

• 12-15 years of related experience preferred.
• 7 years of experience with relational databases, data pipelines, and OLAP warehouses.

Responsibilities

• Design databases and pipelines balancing functionality, performance, cost, and development time.
• Design, build, test, and maintain data pipelines.
• Mentor junior engineers in data warehousing and engineering skills.
• Serve as a team leader and contribute to project planning.

Skills

Data Warehousing

SQL

Data Engineering

Change Data Capture

Agile (Scrum, Kanban)

Education

Bachelors degree in a technical discipline

Masters degree preferred

Tools

SAP HANA

MySQL

Hadoop

Spark

Kafka

Job description

Mount Sinai Health System seeks a Lead Data Warehouse Engineer for its Scientific Computing and Data team. This senior role involves leading the integration of diverse clinical data into the AIR.MS data warehouse. The ideal candidate will have extensive experience in data warehousing, relational databases, and a solid understanding of healthcare data. Responsibilities include designing databases, executing data integration plans, and mentoring junior engineers. This position offers a salary range of $145,200 - $217,875 annually, reflecting experience and need.