Job Description
Job Description The Scientific Computing and Data group at the Icahn School of Medicine at Mount Sinai partners with scientists to accelerate scientific discovery. To achieve these aims, we provide a cutting-edge high-performance computing and data ecosystem along with MD/PhD-level support for researchers and clinicians. The group is composed of a high-performance computing team, the research clinical data warehouse team and a research data services team.
The Healthcare Data Analyst will collaborate with clinical Informaticist and researchers to define and develop appropriate solutions for various reporting needs. These solutions typically involve extracting data from Mount Sinai's various relational databases, data cleansing, and reformatting into analytic data sets. Solutions may also involve the design, testing, implementation, and ongoing maintenance of data marts. Primary duties are outlined below.
Responsibilities - Assist with translating end-user data requests into technical specifications and specific data elements required for data set, report, or data mart development.
- Assist with requirements elicitation for new reporting and data requests by interacting with end users.
- SQL programming, testing, and performance tuning to fulfill data requests.
- Manage and version control SQL scripts for re-usability.
- Develop custom ETL jobs and/or packages to extract data from various sources and load them into the Mount Sinai Data Warehouse or data marts.
- Design and develop custom database schemas within the Data Warehouse, as needed.
- Test reports and data extracts, and perform volume testing in live environments. Ensure that customers are satisfied with data provided to them.
- Monitor ETL executions and data-load processes as part of routine Data Warehousing operations. Troubleshoot and resolve ETL job failures. On-call support is sometimes required.
- Design, implement, test, deploy, and manage data marts that align with the Data Warehouse architecture and enterprise data strategy.
- Perform related duties as assigned or requested.
Qualifications - Bachelor degree in Computer Science or a related discipline; advanced degree preferred.
- Minimum of 5 years' experience working with electronic health record (EHR) and/or healthcare claims data; experience with Epic's Clarity & Caboodle databases is needed.
- Prior experience working with healthcare terminologies and code sets (e.g., ICD-10, RxNorm, LOINC, CPT), and building or using value sets for specific reporting use cases.
- Ability to articulate technical and organizational approaches to meeting clinical data needs.
- Team player with experience leading and collaborating cross-team to ensure successful delivery of solutions.
- Fast learner with the ability to work both independently and in a team environment.
- Highly proficient with SQL programming and professional experience with multiple SQL dialects (e.g., Microsoft -SQL, Oracle PL/SQL).
- Ability to write complex SQL queries, scripts, and stored procedures.
- Ability to assess query performance (e.g., query execution plans) and recommend improvements (e.g., query refactoring, indexing, table partitioning).
- Experience with Microsoft SQL Server. Experience with other relational databases (Oracle, PostgreSQL) is a strong plus.
- Strong understanding of the principles of relational and dimensional data modeling.
- Experience with software development best practices, including all phases of the Software Development Life Cycle (SDLC) and rigorous code version control with tools like Git or SVN.
- Prior experience working in a research environment and/or knowledge of research Common Data Models (e.g., OMOP, i2b2, PCORnet, ACT) is a plus; experience with the OMOP Common Data Model is strongly preferred.
Compensation Statement The Mount Sinai Health System (MSHS) provides a salary range to comply with the New York City Law on Salary Transparency in Job Advertisements. The salary range for this role is $99,200.00 - $148,800.00 Annually. Actual salaries depend on a variety of factors, including experience, education, and hospital 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, 092 - High Performance Computing - ISM, Icahn School of Medicine
About Us Strength Through Diversity The Mount Sinai Health System believes that diversity, equity, and inclusion are key drivers for excellence. We share a common devotion to delivering exceptional patient care. When you join us, you become a part of Mount Sinai's unrivaled record of achievement, education, and advancement as we revolutionize medicine together. We invite you to participate actively as a part of the Mount Sinai Health System team by:
- Using a lens of equity in all aspects of patient care delivery, education, and research to promote policies and practices to allow opportunities for all to thrive and reach their potential.
- Serving as a role model confronting racist, sexist, or other inappropriate actions by speaking up, challenging exclusionary organizational practices, and standing side-by-side in support of colleagues who experience discrimination.
- Inspiring and fostering an environment of anti-racist behaviors among and between departments and co-workers.
At Mount Sinai, our leaders strive to learn, empower others, and embrace change to further advance equity and improve the well-being of staff, patients, and the organization. We expect our leaders to embrace anti-racism, create a collaborative and respectful environment, and constructively disrupt the status quo to improve the system and enhance care for our patients. We work hard to create an inclusive, welcoming and nurturing work environment where all feel they are valued, belong and are able to advance professionally.
Explore more about this opportunity and how you can help us write a new 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 43,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 approximately 7,400 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 and top 20 in Cardiology/Heart Surgery, 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. 14 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.
The Mount Sinai Health System is an equal opportunity employer. We comply with applicable Federal civil rights laws and does not discriminate, exclude, or treat people differently on the basis of race, color, national origin, age, religion, disability, sex, sexual orientation, gender identity, or gender expression. We are passionately committed to addressing racism and its effects on our faculty, staff, students, trainees, patients, visitors, and the communities we serve. Our goal is for Mount Sinai to become an anti-racist health care and learning institution that intentionally addresses structural racism."
EOE Minorities/Women/Disabled/Veterans
Job Tags
Traineeship, Local area,