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

Mount Sinai Morningside; New York (NY); On-site; USD 87,692 - 131,538; Full time

Job summary

Mount Sinai Morningside is seeking a Data Science Analyst II to lead advanced data analysis, reporting, and automation within the Pharmacy Analytics team. You will work across Pharmacy, Finance, 340B, Supply Chain, and Clinical Operations to deliver data products that drive strategic decisions for the health system.

The role emphasizes developing interactive dashboards, optimizing SQL queries, and integrating data from Epic Clarity, Caboodle, Oracle Cloud, and vendor sources to improve pharmacy

Qualifications

• Bachelor’s or higher in a relevant field; Master’s preferred.
• Minimum 5 years in analytics development, healthcare focus preferred.
• Strong SQL, Tableau, Excel skills with large relational databases.
• Experience with Epic Clarity/Caboodle, Oracle Cloud, and claim/EMR data sources.
• Knowledge of 340B program compliance and hospital pharmacy operations.

Responsibilities

• Analyze data requests from internal and external sources for reporting and BI.
• Develop and present reports and analyses to senior management.
• Collaborate with cross‑functional teams to translate needs into analytics.
• Contribute to data warehouse improvements and data quality initiatives.
• Mentor junior analysts and share BI best practices.

Skills

SQL

Tableau

Excel

Epic Clarity

Caboodle

Oracle Cloud

Education

Bachelor's degree

Master's degree

Tools

Facets

Amisys

IDX

Soarian

Job description

Job 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. The 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 solutions that contribute to sound strategic planning, decision‑making, goal setting, and effective performance measurement.

Responsibilities

• Analyze 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.
  • Work with departmental staff to identify requirements for reporting and / or business intelligence tools.
  • Identify necessary data, data sources and methodologies.
  • Collect, organize, integrate, analyze and interpret data.
  • Leverage advanced statistical analysis methods to create insightful recommendations and conclusions that may be communicated to stakeholders.
  • Identify and address expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions. Improve data quality where possible within the analytic models and feed data quality issues back to IT or identified data stewards.
  • Develop and, where appropriate, 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 – assist in modeling and forecasting contract scenarios, measuring ongoing performance and identifying trends to inform clinical or contracting staff.
  • Care Management – identify, understand and prioritize at‑risk members in need of care management.
  • Medical Directors – identify utilization trends and variations across categories of health care services.
  • Quality and Documentation – link payer quality and documentation opportunities into operational analytic processes.
  • I.T. / High Performance Computing – support ongoing projects.
• Takes a proactive role as liaison/analyst for internal stakeholders, translating needs into reporting and analytic solutions.
• Effectively communicate with stakeholders and customers, ensuring all requests are properly triaged, recorded and tracked.
• Adhere to corporate standards for performance metrics, data collection, data integrity, query design, and reporting format to ensure high‑quality, meaningful analytic output.
• Help identify and understand data from internal and external sources for competitive, scenario and performance analyses, and financial modeling.
• Work closely with IT on the ongoing improvement of Mount Sinai integrated data warehouse, driven by strategic and business needs.
• Develop and maintain project work plans, including critical tasks, milestones, timelines, interdependencies and contingencies; track and report progress.
• Provide technical support to data analytics functions across varied business units, and lead selection, development and implementation of reporting and BI tools.
• Prepare clear, well‑organized project‑specific documentation with analytic methods, decision points and caveats.
• Ensure customers are trained to use self‑service BI tools and dashboards.
• Mentor level I Analysts and teach others how to define meaningful metrics, develop BI queries and generate management reports.
• Share development and process knowledge with other analysts to build redundancy and analytical strength.
• Demonstrate advanced proficiency in process improvement methodologies.
• 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:
  • 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.

Compensation

The salary range for the role is $87,692 – $131,538 annually.

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.