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

Mount Sinai Health System•New York, NY

7d•Hybrid

About The Position

This is a 100% remote position with one required onsite visit per year to New York, NY. The Data Science Analyst II is a senior member of the Pharmacy Analytics team, focused on improving pharmacy financial performance, operational efficiency, and clinical decision-making through data analysis, reporting, and automation. The role involves cross-functional collaboration with Pharmacy, Finance, 340B, Supply Chain, and Clinical Operations to create data products for strategic decision-making. Key responsibilities include developing interactive dashboards, optimizing SQL queries for data integration from various sources (Epic Clarity, Caboodle, Oracle Cloud, Azure, etc.), and supporting initiatives like drug spend tracking, waste reduction, budget forecasting, inventory reconciliation, and 340B compliance. The position requires a strong understanding of pharmacy workflows, healthcare finance, and medication data to provide insights and Business Intelligence (BI) solutions that support strategic planning and performance measurement.

Requirements

BA or BS degree minimum, in a relevant field of study
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

Nice To Haves

Master's degree preferred
PhD, MD or DO program may be substituted for three years of experience.

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, Care Management, Medical Directors, Quality and Documentation, 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 Sinai's 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.