Data Science Analyst II - Pharmacy Reporting - Digital and Technology Partners - Remote

Mount Sinai Medical Center; New York (NY); Hybrid; USD 87,692 - 131,538; Full time

Job summary

Mount Sinai Health System is seeking a Data Science Analyst II to advance pharmacy analytics and drive data-driven decisions across the health system. You will build interactive dashboards, optimize SQL queries, and collaborate with Pharmacy, Finance, 340B, Supply Chain, and Clinical Operations to deliver impactful data products.

The role emphasizes healthcare finance, medication data, and cross-functional engagement, with a focus on novel analytics, reporting, and BI delivery to improve

Qualifications

• BA or BS degree minimum; Master’s degree preferred.
• 5+ years analytics development experience, preferably in health care.
• Strong SQL, Tableau, Excel; experience with Epic Clarity, Caboodle, Oracle Cloud.
• Understanding of 340B program compliance, hospital pharmacy operations.
• Excellent communication skills with stakeholders.

Responsibilities

• Analyze data requests using IT, enrollment, claims, pharmacy, clinical, financial and other data sources.
• Collaborate with stakeholders to identify reporting requirements and BI tools.
• Develop data analyses, reports, and dashboards for senior management.
• Mentor junior analysts and ensure data quality and governance.
• Support data warehouse improvements and BI tool deployment.

Skills

SQL proficiency

Tableau

Excel

Epic Clarity

Caboodle

Oracle Cloud

Healthcare analytics

Education

BA or BS degree minimum

Master’s degree preferred

Tools

Epic Clarity

Caboodle

Oracle Cloud

Job description

Description

This is a 100% remote position - requires 1 day onsite a year at 150 E 42nd Street, New York, NY location

The Data Science Analyst II 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 II collaborates with stakeholders from across the organization to develop sophisticated analytics to provide information, insights and BI (Business Intelligence) solutions that contribute to sound strategic planning, decision‑making, goal setting, and effective performance measurement. The Data Science Analyst II 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.

Responsibilities

• Analyzes data requests using information technology, enrollment, claims, pharmacy, clinical, contract, medical management, financial, administrative and other corporate data from both modeled and disparate internal and external sources.
  • Works with departmental staff to identify requirements for reporting and / or business intelligence tools.
  • Identifies necessary data, data sources and methodologies.
  • Collects, organizes, integrates, analyzes and interprets data.
  • Leverages advanced statistical analysis methods to create insightful recommendations and conclusions that may be communicated to the stakeholder.
  • Identifies and addresses expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions. Works to improve data quality where possible within created analytical models. Feeds data quality issues back to IT or identified data stewards to facilitate creation of high quality metrics.
  • Develops and may present reports, analyses and findings to senior management and others as scheduled or requested.
• Responsible for one or more of the following stakeholder groups:
  • Contracting and Commercialization May assist in the modeling and forecasting contract scenarios, measuring ongoing performance and identify trends in performance to inform our clinical or contracting staff to improve contract outcomes.
  • Care Management Helps to identify, understand and prioritize at‑risk members in need of care management. Helps stratify our membership to optimally use resources to focus on the patients most in need, currently or in the future.
  • Medical Directors Helps to identify utilization trends and variations across the different categories of health care services to assist the Medical Directors to focus their efforts to maximize contract performance and clinical effectiveness.
  • Quality and Documentation Helps to link payer quality and documentation opportunities into operational analytic processes to maximize our quality scores, top line revenue and optimize the use of resources in concert with MS Health System contracts.
  • I.T. / High Performance Computing in any ongoing projects.
• Takes a proactive role as liaison/analyst for internal stakeholders, understands their needs and translates them into reporting and analytic solutions.
• Effectively communicates with stakeholders and customers and ensures all requests are properly triaged, recorded and tracked.
• Adheres to corporate standards for performance metrics, data collection, data integrity, query design, and reporting format to ensure high quality, meaningful analytic output.
• Helps identify and understand data from internal and external sources for competitive, scenario and performance analyses, and financial modeling to gain member/provider insight into new and existing processes and business opportunities.
• Works closely with IT on the ongoing improvement of Mount Sinais integrated data warehouse, driven by strategic and business needs, and designed to ensure data and reporting consistency throughout the organization.
• Develops and maintains project work plans, including critical tasks, milestones, timelines, interdependencies and contingencies. Tracks and reports progress. Keeps stakeholders apprised of project status and implications for completion.
• Provides technical support to data analytics functions as they relate to varied business units, and technical expertise on the selection, development and implementation of various reporting and BI tools tied to business unit reporting requirements. Creates new BI reports and interactive dashboards as required.
• Prepares clear, well‑organized project‑specific documentation, including, at a minimum, analytic methods used, key decision points and caveats, with sufficient detail to support comprehension and replication.
• Ensures customers are adequately trained to use self‑service BI tools and dashboards.
• Mentors level I Analysts, and teaches others within the organization on how to a) define meaningful process and performance measures, b) develop BI queries, and c) generate and use management reports effectively.
• Shares development and process knowledge with other analysts in order to assure redundancy and continuously builds a core of analytical strength within the organization.
• Demonstrates advanced level proficiency with the principles and methodologies of process improvement. Applies these in the execution of responsibilities in support of a process focused approach.
• Other duties as assigned.

Qualifications

• BA or BS degree minimum, in a relevant field of study; Master’s degree preferred.
• 5 years minimum in analytics development expertise, preferably in health care, or for a health provider, health plan or accountable care organization, including either:
  • Working knowledge of a health care EMR such as Epic/Clarity, aCW, etc.; a payor claims system such as Facets, Amisys, etc.; or a hospital/provider system such as IDX, Soarian, etc.
  • 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.
  • Excellent communication skills with the ability to explain data insights to both technical and non‑technical audiences.
  • PhD, MD or DO program may be substituted for three years of experience.

Non‑Bargaining Unit, 223 - DTP Enterprise Data & Analytics - MSH, Mount Sinai Hospital

Employer Description

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 $87,692 - $131,538 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.