Lead Clinical Data Warehouse Engineer - Scientific Computing & Data

The Scientific Computing & Data group at the Icahn School of Medicine at Mount Sinai partners with scientists to accelerate scientific discovery. To achieve these aims, we support a cutting-edge high-performance computing (HPC) and data ecosystem along with MD/PhD-level support for researchers. The group is composed of a high-performance computing team, the research clinical data warehouse team and a research data services team. The Scientific Computing and Data group operate the secure enclave for the Kidney Precision Medicine Project (KPMP) clinical data warehouse and data lake for the KPMP. The Kidney Precision Medicine Project (KPMP) is an ambitious, multi-year project funded by the National Institute of Diabetes and Digestive and Kidney Diseases (NIDDK) with the purpose of understanding and finding new ways to treat chronic kidney disease (CKD) and acute kidney injury (AKI).

The Lead Clinical Data Warehouse Engineer is a senior technical specialist responsible for leading the ongoing development of the Kidney Precision Medicine Project (KPMP) data warehouse, a centralized multimodal data repository for biomedical research. In this position, the Lead Clinical Data Warehouse Engineer will work with other members of the data warehouse team and KPMP to expand the functionality and integrate new multimodal data sources into the data warehouse. The KPMP data warehouse is built on the Microsoft SQL Server technology stack, with data extracted from KPMP’s clinical systems, and transformed into OHDSI’s Observational Medical Outcomes Partnership (OMOP) Common Data Model.

This position is responsible for driving and leading the technology direction of current and future development in an area of expertise which may include application development, systems programming, data management, etc. This individual may function as a team lead and influences strategic technical implementation and provides creative solutions for very complex requirements often leading large project efforts. Project Scope: Large complex programs and strategic initiatives involving multiple sites or up to 40 integrated work tracks.

• Design, build, test, maintain and control data pipelines and ETL jobs for integrating data into the KPMP data warehouse. Such data pipelines are implemented in T-SQL stored procedures, SSIS and SQL Agent jobs, and make extensive use of metadata-driven dynamic SQL and Varigence's BIML.
• Develop standards and procedures for database and data pipeline design, operational management and ongoing maintenance.
• Design, build, test, maintain, and control other processes for data management, including management and loading of flat files in a variety of formats (e.g. csv, tsv, pipe-delimited, XML, JSON.)
• Facilitate design sessions, code walkthroughs, peer reviews, and produce technical documentation.
• Performance tuning of database objects, stored procedures, ETL jobs, and related scripts to optimize both end-user customer queries and data pipeline ETL processing.
• Monitor scheduled ETL jobs and other processes to ensure expected functioning and uptime of data pipelines. Lead and/or coordinate the troubleshooting and remediation of all ETL job failures in a timely manner. On call support is sometimes required.
• Deliver world class customer service in all interactions with customers, stakeholders, and other teams within Mount Sinai's Digital & Technology Partners (DTP) organization. Maintain a customer-focused approach to provide solutions that are science/research driven.
• Maintain patient privacy and the integrity and security of healthcare data in all databases and systems, including compliance with all applicable laws, regulations, and Mount Sinai's policies related to the Institutional Review Board (IRB), patient privacy and IT cybersecurity. These laws include but are not limited to, the "Common Rule" (45 CFR Part 46), HIPAA (45CFR Part 164), 42 CFR Part 2, and New York's Article 27-F.
• Work effectively and collaboratively with other IT professionals throughout Mount Sinai.
• As a senior technical lead, independently investigate and stay abreast of new and emerging technologies that Scientific Computing & Data could leverage to provide new capabilities, to boost efficiencies or quality, and/or lower operating costs.
• May act as a Project Leader.
• May assist the DBAs with database administration tasks, including user provisioning and access permissions, backups, environment restorations, capacity planning and load monitoring, performance tuning, etc.
• May assist with the design, build, test and performance tuning of reports and dashboards in SSRS, Microsoft Power BI, Tableau, or similar business intelligence tools.

• Perform related duties as assigned or requested.

• Bachelors degree in a technical discipline; Masters degree preferred
• 12-15 years preferred of related experience, including 8 years of experience with the design, development and maintenance of relational databases and ETL jobs/data pipelines.

Preferred:

• Expert knowledge of data warehousing principles: database design/3NF, dimensional modeling (e.g. types of fact tables, slowly changing dimensions), change data capture/bi-temporal versioning, incremental data loads, maintain transparent data lineage, etc.
• Expert level ETL development experience with Microsoft SSIS, Visual Studio, SQL Server Data Tools and SQL Agent jobs is required. Prior experience with other ETL tools is a plus.
• Expert level Microsoft T-SQL development skills are required: stored procedures, user defined functions, sequences, advanced T-SQL features, metadata or parameter driven dynamic SQL, and the use of Linked Servers. Experience with Oracle PL/SQL and/or PostgreSQL, PL/pgSQL is a strong plus.
• Prior experience working with healthcare data is strongly preferred, which may include electronic health records, medical and pharmacy billing & claims, and/or healthcare cost accounting systems. Experience with Epic Systems Corporation's Clarity & Caboodle reporting databases in strongly preferred.
• Strong consultative customer service and communications skills (verbal and written) to effectively interact with researchers, clinicians, hospital administrators, and other IT personnel.
• Knowledge of ETL development best practices is required, including explicit source-to-target mappings; pattern-based and parameter driven development; and rigorous version control using GIT, BitBucket, Microsoft Teams Foundation Server (TFS), or equivalent.
• Experience with DevOps and Software Development Life Cycle (SDLC) best practices. Experience with Agile methodologies (Scrum, Kanban) and tools (Atlassian, Jira and Confluence) is a strong plus.
• Strong knowledge of relational and dimensional data modeling principles and best practices.
• Excellent critical thinking, problem solving, multi-tasking and collaboration skills.
• Fast learner with the ability to work independently and productively in a fast-paced environment.
• Experience with database administration tasks in a MS SQL Server environment is a plus: database configuration, performance tuning indexes, partitioning, materialized views, and other methods for improving query performance; user provisioning and access permissions; backups and restorations.
• Experience working with MS SSRS, MS Power BI, Tableau or similar business intelligence tools.
• Scripting experience (shell, Python, PERL or similar) .
• Some experience with HL7 messages and web services interfaces (e.g. REST API).
• Experience with OMOP.

Compensation Statement

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 $145,200.00 - $217,875.00 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.

Non-Bargaining Unit, J18 - AI and Human Health - ISM, Icahn School of Medicine

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 largest academic medical systems in the New York metro area, with more than 48,000 employees working across eight hospitals, more than 400 outpatient practices, more than 300 labs, a school of nursing, and a leading school of medicine and graduate education. Mount Sinai advances health for all people, everywhere, by taking on the most complex health care challenges of our time — discovering and applying new scientific learning and knowledge; developing safer, more effective treatments; educating the next generation of medical leaders and innovators; and supporting local communities by delivering high-quality care to all who need it. Through the integration of its hospitals, labs, and schools, Mount Sinai offers comprehensive health care solutions from birth through geriatrics, leveraging innovative approaches such as artificial intelligence and informatics while keeping patients’ medical and emotional needs at the center of all treatment. The Health System includes more than 9,000 primary and specialty care physicians; 13 joint-venture outpatient surgery centers throughout the five boroughs of New York City, Westchester, Long Island, and Florida; and more than 30 affiliated community health centers. We are consistently ranked by U.S. News & World Report's Best Hospitals, receiving high "Honor Roll" status, and are highly ranked: No. 1 in Geriatrics, top 5 in Cardiology/Heart Surgery, and top 20 in Diabetes/Endocrinology, Gastroenterology/GI Surgery, Neurology/Neurosurgery, Orthopedics, Pulmonology/Lung Surgery, Rehabilitation, and Urology. New York Eye and Ear Infirmary of Mount Sinai is ranked No. 12 in Ophthalmology. U.S. News & World Report’s “Best Children’s Hospitals” ranks Mount Sinai Kravis Children's Hospital among the country’s best in several pediatric specialties. The Icahn School of Medicine at Mount Sinai is ranked No. 11 nationwide in National Institutes of Health funding and in the 99th percentile in research dollars per investigator according to the Association of American Medical Colleges. Newsweek’s “The World’s Best Smart Hospitals” ranks The Mount Sinai Hospital as No. 1 in New York and in the top five globally, and Mount Sinai Morningside in the top 20 globally.

Equal Opportunity Employer

The Mount Sinai Health System is an equal opportunity employer, complying with all applicable federal civil rights laws. We do not discriminate, exclude, or treat individuals differently based on race, color, national origin, age, religion, disability, sex, sexual orientation, gender, veteran status, or any other characteristic protected by law. We are deeply committed to fostering an environment where all faculty, staff, students, trainees, patients, visitors, and the communities we serve feel respected and supported. Our goal is to create a healthcare and learning institution that actively works to remove barriers, address challenges, and promote fairness in all aspects of our organization.

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.