The Pharmacy Financial Analyst analyzes and interprets financial data to advise and support Pharmacy strategic decision-making and achieve Pharmacy business objectives, financial optimization, and 340B program compliance, across retail pharmacy, 340B contract pharmacy, and clinical medication dispensaries.  Monitor 340B compliance across all business lines thru the coordination, and completion of Pharmacy internal auditing according to auditing standards and regulatory requirements. Tracks variances between financial projections and actual results to identify and troubleshoot differences and recommend adjustments or improvements. 

Pharmacy Data Analysis 

Performs routine and ad-hoc pharmacy data analysis utilizing data from Mosaic’s electronic medical record, insurance claims, 340B partners and Mosaic’s retail pharmacy to optimize 340B program performance. Maintains thorough understanding of data sources, information architecture, and documentation workflows for pharmacy programs. Analyzes and interprets financial data to advise and support strategic decision-making and achieve organization pharmacy financial objectives. Utilizes tools such as Tableau, Alteryx, SQL, Business Objects, Epic Reporting Workbench, and Excel to answer ad hoc medication, 340B, and retail pharmacy data requests. Provides internal stakeholders with actionable pharmacy data, participates in relevant workgroups and project teams supporting data availability and quality and understanding. Coordinates with external partners to ensure bi-directional secure, reliable and accurate data file transmission. Monitor and maintain data transmission of Electronic Health Record encounter files to contracted third-party agencies. Reviews 340B referral prescriptions weekly to determine eligibility for 340B savings.

Pharmacy Reporting and Financial Analysis 

Optimize net revenue and cash flow across all lines as well as conducting 340B referral prescription capture. Creates and routinely monitors monthly and annual reports for pharmacy and 340B that clearly document utilization, savings, problem areas, and exceptions or discrepancies, to be passed on to pharmacy leadership and administration. Develops routine reports that are a by-product of the inventory process and software, allowing for concise information to be communicated to the leadership responsible for 340B inventory management. Ensures that reporting meets organizational, regional, national, state, and federal requirements/guidelines.

Pharmacy Auditing 

Conducts and documents internal audits that follow current regulatory compliance Reports and reviews any audit findings to the Pharmacy Operations Manager.  These audits include, but are not limited to:  Internal contract Pharmacy audits Internal monthly audits of all 340B-eligible locations to verify adherence with the 340B Program guidelines Internal patient record audits to assure patient eligibility for 340B medications including clinic eligibility, eligible provider and appropriate EMR documentation Internal 340B purchasing and utilization audits or compliance assessments Quarterly reviews of the new 340B pricing list to search for and quickly address costly change Collaborates with the Pharmacy Operations Manager to process data requests and prepare reports for external auditors or regulatory bodies. Monitors and reports 340B compliance and risk management activities and findings to Pharmacy Operations Manager. Reviews data to identify trends, incidents, problems, and areas of noncompliance. Reviews internal processes, transactions, documentation, and systems to validate compliance, evaluate effectiveness, identify issues, and prepare reports and recommendations for remediation.

Education and Advising

Serves as internal consultant for identifying potential data sources and developing new performance opportunities for Pharmacy programs. Uses data to assist improvement teams in developing change strategies and evaluate improvement efforts for Pharmacy programs. Provides access to and interpretation of business intelligence for monitoring Pharmacy performance, compliance and developing business strategy. Presents summaries of trends in writing, graphically, and orally.

Work Experience:  Three years of relevant experience required. Data analysis and audit experience required. Pharmacy and 340B program experience preferred. 

Education, certification and licensure:  High school diploma or equivalent required. Bachelor’s degree preferred. Pharmacy Technician certification preferred.

Skills & Knowledge: Developing complex spreadsheets, custom charts, referential dashboards, and advanced formulas. Advanced skills with relational databases, preferably using Microsoft Access or Crystal Reports. Knowledge of prescription drugs and electronic health records. Must have excellent communication skills and ability to interact with a diverse population and professionally represent Mosaic Medical, strong team working and collaborative skills, ability to multi-task, attention to detail, excellent organizational skills, and customer service.  Intermediate ability and experience in computer applications, specifically electronic medical records system, Excel, Power Point and MS Office.

Who We Are: 

Mosaic Community Health prides itself on being an innovative health system that pioneers unique and creative ways to provide and improve patient access to health care. Since our founding in 2002 we have proudly served insured and uninsured patients regardless of age, ethnicity, or income. 

We focus on a holistic approach to patient care by incorporating behavioral health, pharmacy, and nutrition support to serve patients in the most meaningful way. At Mosaic Community Health, you will work with incredibly dedicated and mission-centered peers and be part of a dynamic team-based environment. 

Mosaic Community Health offers more than just a job, it is a lifestyle. A lifestyle of serving others. A lifestyle of being an integral part of your community. A lifestyle that offers work/life balance. A lifestyle of enjoying the outdoors!