"Alerted.org

Job Description

The Data Science Analyst III serves as a senior member of the Pharmacy Analytics team, advancing Mount Sinai’s mission through high-impact data analysis, reporting, and automation to improve pharmacy financial performance, operational efficiency, and clinical decision-making. This role works cross-functionally with stakeholders from Pharmacy, Finance, 340B, Supply Chain, and Clinical Operations to deliver data products that inform strategic decisions across the Health System.

The Analyst plays a key role in developing interactive dashboards and optimizing SQL queries to integrate data from Epic Clarity, Caboodle, Oracle Cloud, Azure, wholesaler systems, and other vendor sources. A strong understanding of pharmacy workflows, healthcare finance, and medication data is essential, as this position supports critical initiatives such as drug spend tracking, waste reduction, budget forecasting, inventory reconciliation, and 340B compliance reporting.

The Data Science Analyst III demonstrates sound and a more advanced understanding of the healthcare domain, technical data manipulation and analytic development skills and impact the patient community of the Mount Sinai Health System. Serves as mentor to others in the Data Science team and takes the lead role in project initiatives.

Qualifications

+ BA or BS degree minimum, in a relevant field of study; Masters degree preferred.Prefer degree in Data Science, Computer Science, Public Health, Healthcare Administration, Pharmacy, Finance, or a related field

+ 7 years+ years minimum, higher preferred of experience in healthcare analytics or pharmacy finance, preferably within a hospital or health system.

+ Advanced proficiency in SQL (Oracle/OCI preferred), Tableau, Excel, and working with large relational databases (Epic Clarity/Caboodle, Oracle Cloud).

+ Strong understanding of 340B program compliance, hospital pharmacy operations, and medication utilization.

+ Demonstrated ability to manage complex projects, prioritize tasks, and deliver accurate, actionable insights under tight timelines.

+ Excellent communication skills with the ability to explain data insights to both technical and non-technical audiences.

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 $106,108.00 - $166,399.92 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, 223 - DTP Enterprise Data & Analytics - MSH, Mount Sinai Hospital

Responsibilities

+ Design and maintain interactive dashboards and reporting tools to monitor pharmacy expense trends, utilization, and key performance indicators.

+ Manage and maintain Pharmacy DataMart ETL processes, ensuring timely and accurate integration of data from various external sources, including wholesalers, claims systems, and financial platforms.

+ Develop complex SQL logic to join, transform, and reconcile data from Epic, QS1, Oracle Cloud, 340B claims data, and wholesaler purchase feeds.

+ Support 340B program reporting by building custom reports, identifying eligible encounters/claims, and automating audit-ready documentation.

+ Collaborate with Pharmacy Finance and Supply Chain teams to analyze actual vs. budgeted drug spend, model year-end projections, and support variance analysis across facilities.

+ Monitor medication waste, off-label utilization, and high-cost medication trends through clinical and financial data linkage.

+ Lead the development and automation of data pipelines to support timely reporting and data-driven decision-making.

+ Translate complex technical outputs into clear visualizations and executive-level summaries for leadership review.

About Us

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 Statement

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 the role is $106108 - $166399.92 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.