Lead Clinical Data Warehouse Engineer

Overview 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 is a cloud‑based SAP HANA data platform that contains patient data generated from the clinical care processes at the Mount Sinai Health System. 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, transform, augment, and integrate data from source systems 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. Qualifications Bachelor’s degree in a technical field; Master’s preferred. 12–15 years of related experience, including 7+ years designing, developing, and maintaining relational databases, data pipelines, and dimensional/OLAP warehouses. Preferred Qualifications Expert knowledge of data warehousing: 3NF & dimensional modeling (fact tables, SCDs), change data capture, incremental loads, data lineage, source‑to‑target mappings, pattern‑based & parameter‑driven development. Expert‑level experience with data engineering technologies: SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, data transformation tools, and job orchestration tools. 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 & restoration. 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 $145,200 - $217,875 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. #J-18808-Ljbffr Icahn School of Medicine at Mount Sinai