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

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 stakehol…