Lead Data Warehouse Engineer
hace 2 días
New York
Description The Scientific Computing & Data group at the Icahn School of Medicine at Mount Sinai (ISMMS) accelerates scientific discovery by supporting a high-performance computing and research data ecosystem. This includes a data commons and two clinical research data warehouses: one for ISMMS and one for the Kidney Precision Medicine Project (KPMP), a multi-institutional research consortium () funded by the National Institute of Diabetes and Digestive and Kidney Diseases (NIDDK). Both warehouses use Microsoft SQL Server and the OMOP Common Data Model. The Lead Data Warehouse Engineer is a senior technical specialist responsible for leading development, maintenance, and operations of these research data warehouses. The role collaborates with warehouse team members and research stakeholders to expand functionality and integrate new data sources. Data transformations are built in Transact-SQL stored procedures, with SSIS used for orchestration. 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 ETL/ELT processes using T-SQL stored procedures, SSIS, and SQL Agent; apply metadata-driven design for extensibility., • 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 • 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., • Expert-level experience with Microsoft SQL Server technologies: T-SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, Linked Servers, SSIS, Visual Studio, SSDT, and SQL Agent., • 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)., • Preferred experience with Azure Synapse, Azure Data Factory, Oracle PL/SQL, PostgreSQL PL/pgSQL., • Experience with SQL Server administration: configuration, performance tuning, partitioning, materialized views, permissions, backups & restorations., • Preferred experience with scripting in Windows & Linux (PowerShell, Python, or similar); HL7; web services/REST APIs; reporting tools like SSRS, Power BI, Tableau. 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.
