Skip to main content
Loading
loadingbar
Loading, Please wait..!!

Lead Clinical Data Warehouse Engineer

  • Lead Clinical Data Warehouse Engineer job type Posted on: Oct 29, 2026
  • Lead Clinical Data Warehouse Engineer experience level Icahn School of Medicine at Mount Sinai
  • Lead Clinical Data Warehouse Engineer employment type New York, New York
  • Lead Clinical Data Warehouse Engineer salary Salary: $217,875 per year
  • Lead Clinical Data Warehouse Engineer employment type Onsite
  • Lead Clinical Data Warehouse Engineer salary Full-time

Point Apply Here APPLY LATER

Curious about compensation?

Explore the historical salary trends, average pay, and estimated compensation for Lead Clinical Data Warehouse Engineer roles in New York.

View Salary Guide →

Job Title :

Lead Clinical Data Warehouse Engineer

Job Type :

Full-Time

Job Location :

New York New York United States

Remote :

No

Jobcon Logo Job Description :

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 managerDesign, 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 repositoryServe as a team leader; contribute to project planning, work breakdown, dependency sequencing, and release managementDevelop and promote standards, conventions, design patterns, DevOps/SDLC best practices, and operational procedures for pipelines and warehouse maintenanceMentor junior engineers in data warehousing, data engineering skills, and operational supportDesign, 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 documentationTune database objects, stored procedures, and pipelines to optimize performance and minimize compute and storage costsMonitor database and pipeline operations; lead troubleshooting and remediation of failures; provide occasional after-hours on-call supportCollaborate with DBAs and system administrators on backups, performance tuning, statistics/index maintenance, and patchingProvide high-quality customer service to researchers, clinicians, and internal partners; maintain a science‑driven, customer-focused approachEnsure patient privacy and data security in compliance with IRB & cybersecurity policies, HIPAA, 42 CFR Part 2, NYS Article 27-F, and other regulationsStay current with emerging technologies to improve capabilities, efficiency, quality, or costIdentify improvements in procedures, technology, compliance, and data privacy/securityPeriodically assist DBAs with user provisioning, backups, restorations, capacity planning, and performance monitoringPerform related duties as assignedQualifications:Bachelor’s degree in a technical field; Master’s preferred12–15 years of related experience, including 7+ years 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 developmentExpert-level experience with data engineering technologies: SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, data transformation tools, job orchestration tools for data processingExperience with DevOps/SDLC best practices; Agile (Scrum, Kanban) with JIRA and Confluence;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 environmentPreferred 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.Strength through Unity and InclusionThe 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.Compensation: The Mount Sinai Health System (MSHS) provides salary ranges that comply with the New York City Law on Salary Transparency in Job Advertisements. The salary range for the role is $145200 - $217875 Annually. Actual salaries depend on a variety of factors, including experience, education, and operational need. The salary range or contractual rate listed does not include bonuses/incentive, differential pay or other forms of compensation or benefits.

Jobcon Logo Position Details

Posted:

Oct 29, 2026

Reference Number:

10440_4476745726

Employment:

Full-time

Salary:

$217,875 per year

City:

New York

Job Origin:

APPCAST_CPC

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Lead Clinical Data Warehouse Engineer    Apply

Click on the below icons to share this job to Linkedin, Twitter!

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 managerDesign, 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 repositoryServe as a team leader; contribute to project planning, work breakdown, dependency sequencing, and release managementDevelop and promote standards, conventions, design patterns, DevOps/SDLC best practices, and operational procedures for pipelines and warehouse maintenanceMentor junior engineers in data warehousing, data engineering skills, and operational supportDesign, 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 documentationTune database objects, stored procedures, and pipelines to optimize performance and minimize compute and storage costsMonitor database and pipeline operations; lead troubleshooting and remediation of failures; provide occasional after-hours on-call supportCollaborate with DBAs and system administrators on backups, performance tuning, statistics/index maintenance, and patchingProvide high-quality customer service to researchers, clinicians, and internal partners; maintain a science‑driven, customer-focused approachEnsure patient privacy and data security in compliance with IRB & cybersecurity policies, HIPAA, 42 CFR Part 2, NYS Article 27-F, and other regulationsStay current with emerging technologies to improve capabilities, efficiency, quality, or costIdentify improvements in procedures, technology, compliance, and data privacy/securityPeriodically assist DBAs with user provisioning, backups, restorations, capacity planning, and performance monitoringPerform related duties as assignedQualifications:Bachelor’s degree in a technical field; Master’s preferred12–15 years of related experience, including 7+ years 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 developmentExpert-level experience with data engineering technologies: SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, data transformation tools, job orchestration tools for data processingExperience with DevOps/SDLC best practices; Agile (Scrum, Kanban) with JIRA and Confluence;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 environmentPreferred 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.Strength through Unity and InclusionThe 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.Compensation: The Mount Sinai Health System (MSHS) provides salary ranges that comply with the New York City Law on Salary Transparency in Job Advertisements. The salary range for the role is $145200 - $217875 Annually. Actual salaries depend on a variety of factors, including experience, education, and operational need. The salary range or contractual rate listed does not include bonuses/incentive, differential pay or other forms of compensation or benefits.

Loading
Please wait..!!