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.

• 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.

• 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