Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS)
- Location
- New York, NY
- Posted
- 209 days ago
How well does your resume fit this job?
Upload your resume to see your score for this Mount Sinai Health System role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
The Scientific Computing and Data team at the Icahn School of Medicine at Mount Sinai partners with scientists and clinicians to accelerate scientific discovery.
The AI-Ready.Mount Sinai (AIR.MS) platform contains patient data generated from the clinical care processes at the Mount Sinai Health System. AIR·MS is a cloud-based, high-performance SAP HANA data platform with electronic health record (EHR) data in an OMOP data format. It also contains metadata from and links to raw data sets in other modalities, such as radiology, genomics and pathology.
Researchers can access the AIR.MS data through direct database access, AI agents, cohort query tools and the Minerva high-performance computer. AIR.MS ingests OHDSI’s Observational Medical Outcomes Partnership (OMOP)-formatted EHR data from the Mount Sinai Data Warehouse.
AIR.MS is integrated with Minerva, a high-performance computer with >21 petaflops of raw computational power and the raw radiology, genomics and pathology data sets. An expert team of 20+ PhD/MD computational scientists, biomedical informaticists and computer scientists partner with researchers and clinicians to effectively and efficiently utilize these resources for translational science.
The
Lead Data Warehouse Engineer is a senior technical specialist responsible for leading the ongoing integration of multi-modal clinical data into the AIR.MS data warehouse. The
Lead Data Warehouse Engineer will assess the state of data integration, identify opportunities for data integration based on researcher’s priorities, develop a plan to integrate metadata and data, and execute on the data integration. The incumbent will work collaboratively with other members of the AIR.MS data platform and Mount Sinai Data Warehouse teams to lead technical efforts for the integration of multi-modal data sets resulting in expanded AIR.MS functionality. The AIR.MS data warehouse is built on the SAP HANA technology stack and MSDW is built on MySQL.
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.
- 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.
- Tune database objects, stored procedures, and pipelines to optimize performance and minimize compute and storage costs.
- Monitor database and pipeline operations; lead troubleshooting and remediation of failures; provide occasional after-hours on-call support.
- Collaborate with DBAs and system administrators on backups, performance tuning, statistics/index maintenance, and patching.
- Provide high-quality customer service to researchers, clinicians, and internal partners; maintain a science driven, customer-focused approach.
- Ensure patient privacy and data security in compliance with IRB & cybersecurity policies, HIPAA, 42 CFR Part 2, NYS Article 27-F, and other regulations.
- Stay current with emerging technologies to improve capabilities, efficiency, quality, or cost.
- Identify improvements in procedures, technology, compliance, and data privacy/security.
- Periodically assist DBAs with user provisioning, backups, restorations, capacity planning, and performance monitoring.
- Perform related duties as assigned.
Bachelors degree in a technical discipline; Masters degree preferred
12-15 years preferred of related experience, including 7 years of experience designing, developing, and maintaining relational databases, data pipelines, and dimensional/OLAP warehouses.
Preferred
- Expert knowledge of data warehousing: 3NF & dimensional modeling (fact table types, SCDs), change data capture, incremental loads, data lineage, source-to-target mappings, pattern-based & parameter-driven development.
- Experience working with healthcare data
- Expert-level experience with data engineering technologies: SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, data transformation tools, job orchestration tools for data processing.
- Experience with DevOps/SDLC best practices; Agile (Scrum, Kanban) with JIRA and Confluence; version control with git.
- Strong communication and customer service skills for working with researchers, clinicians, administrators, and IT staff.
- Excellent critical thinking, problem-solving, multitasking, and collaboration skills; ability to work independently in a fast-paced environment.
- Preferred experience with healthcare data (EHR, billing/claims, cost accounting), Epic Clarity/Caboodle, data models (OMOP, i2b2, PCORnet).
- Experience with database administration: configuration, performance tuning, partitioning, materialized views, permissions, backups & restorations.
- Knowledge of Hadoop, Spark, Kafka and other big data technology stacks and streaming tools.
Employer Description
Strength through Unity and Inclusion
The Mount Sinai Health System is committed to fostering an environment where everyone can contribute to excellence. We share a common dedication to delivering outstanding patient care. When you join us, you become part of Mount Sinai’s unparalleled legacy of achievement, education, and innovation as we work together to transform healthcare. We encourage all team members to actively participate in creating a culture that ensures fair access to opportunities, promotes inclusive practices, and supports the success of every individual.
At Mount Sinai, our leaders are committed to fostering a workplace where all employees feel valued, respected, and empowered to grow. We strive to create an environment where collaboration, fairness, and continuous learning drive positive change, improving the well-being of our staff, patients, and organization.
Our leaders are expected to challenge outdated practices, promote a culture of respect, and work toward meaningful improvements that enhance patient care and workplace experiences. We are dedicated to building a supportive and welcoming environment where everyone has the opportunity to thrive and advance professionally. Explore this opportunity and be part of the next chapter in our history.
About the Mount Sinai Health System
Mount Sinai Health System is one of the nation’s leading integrated academic health systems and one of the largest in the New York metropolitan area. Its comprehensive system includes seven hospitals, more than 400 outpatient practices, over 600 research and clinical laboratories, the Icahn School of Medicine at Mount Sinai, the Graduate School of Biomedical Sciences, and the Mount Sinai Phillips School of Nursing. Together, the Health System comprises approximately 48,000 employees, more than 9,000 physicians, and 8,600 nurses.
As a leading learning health system, Mount Sinai combines clinical expertise with scientific discovery to improve patient care while training the next generation of health care and biomedical leaders. The Health System provides care across every stage of life, from prenatal care through geriatrics, while advancing personalized medicine through artificial intelligence, data science, and biomedical research.
Mount Sinai is consistently recognized among the nation’s leading academic health systems for patient care, research, and education. The Mount Sinai Hospital is ranked No. 1 in New York by Newsweek® and No. 7 in the U.S. on the magazine’s 2026 World’s Best Hospitals list and...
From Mount Sinai Health System's careers page, posted on April 27, 2026, first listed on Rolev.ai on November 22, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS) role at Mount Sinai Health System, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- Lead Data EngineerPetSmart · Phoenix, AZ
- lead data scientist, Staffing Algorithms (Nashville, TN)Starbucks · 1101 Church ST, Nashville, Tennessee, United…
- Lead Data ScientistTransUnion · Chicago, IL
- Lead Database Administrator------------------Need GC and USCUSM Business Systems · Washington, DC
- Lead Data EngineerAppian Corporation · McLean, VA
- Lead Data Platform EngineerCitigroup · Irving, TX · $126k – $189k/yr
Common questions
Where is the Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS) job at Mount Sinai Health System located?
This Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS) position at Mount Sinai Health System is located in New York, NY. Always check Mount Sinai Health System's application page for specific state eligibility or relocation policies.
How do I apply for the Lead Data Warehouse Engineer - Artificial Intelligence-Ready Mount Sinai (AIR.MS) position at Mount Sinai Health System?
This listing links directly to Mount Sinai Health System's application page. You can apply directly on Mount Sinai Health System's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.