Financial Analyst

Position Overview

Polaris Pharmacy Services is seeking a Financial Analyst to join its Strategic Finance team. Reporting to the Manager of FP&A, the Analyst will be a key contributor to the company's planning cycle — the annual operating plan, the quarterly reforecast, and the long-range plan — and to monthly performance reporting.

The Analyst will build and maintain site-level models for our pharmacies and infusion centers, analyze results against plan, and turn data into clear insights for finance and operational leaders. This is a strong opportunity for a self-starting finance professional to gain broad exposure to healthcare finance, executive reporting, and strategic projects in a growing, multi-site organization. Expert-level Excel proficiency is a core requirement: much of this role is spent building, maintaining, and improving the models behind our plans, forecasts, and reports.

Key Responsibilities

Annual Plan, Quarterly Reforecast & Long-Range Plan

- Support the annual operating plan by preparing templates, gathering inputs from site and functional leaders, and consolidating results

- Prepare and update site-level plans and forecasts for each pharmacy and infusion center that roll up to the consolidated plan

- Update the quarterly reforecast, including supporting schedules for revenue, drug cost, labor, and operating expenses

- Maintain the long-range plan model and supporting assumptions under the direction of the Manager of FP&A

Reporting & Variance Analysis

- Prepare monthly plan-vs-actual and reforecast variance reports at the enterprise and site levels

- Research variances with Accounting and operational leaders and draft clear, concise commentary

- Assist in preparing the monthly financial reporting package and executive presentation materials

KPI & Dashboard Support

- Maintain KPI reporting, including prescriptions/doses dispensed, revenue and gross profit per script, census/beds served, payer mix, and labor productivity

- Partner with Business Intelligence to validate data and improve dashboards and automated reports

Financial Modeling & Ad Hoc Analysis

- Build and update models supporting business cases, new customer contracts, pricing, and site performance reviews

- Support M&A, joint venture, and partnership analyses by gathering data and maintaining model inputs

- Complete ad hoc analyses requested by finance leadership

Cash & Working Capital Support

- Support updating the weekly 13-week cash flow forecast with actual receipts and disbursements

- Track AR, inventory, and payables trends in partnership with Revenue Cycle Management and Purchasing

- Help prepare schedules supporting lender reporting and covenant calculations

Process Improvement

- Identify opportunities to automate recurring reports and reduce manual work, including by applying AI tools

- Document reporting processes, data sources, and model assumptions

Qualifications

Qualifications / Experience

- Bachelor's degree in finance, accounting, economics, or related field

- 2–4 years of experience in FP&A, corporate finance, public accounting, banking, or consulting

- Expert-level Excel proficiency (core requirement), with a proven track record of building and maintaining complex financial models (see Excel Expertise above)

- Strong financial systems knowledge; experience with Sage (e.g., Sage Intacct) or an equivalent ERP strongly preferred; Power BI, SQL, or planning-system experience a plus

- Comfortable using and integrating AI tools in finance work (e.g., for analysis, reconciliations, report automation, and drafting commentary), with sound judgment to validate AI-generated output

- Solid understanding of financial statements and accounting fundamentals

- Healthcare, pharmacy, or multi-site services experience a plus

- Strong attention to detail, organization, and ability to manage multiple deadlines

- Clear communicator who can explain numbers to non-finance partners

Excel Expertise (Core Requirement)

The Financial Analyst must be an Excel expert. Candidates should be able to demonstrate:

- Advanced formulas and functions – XLOOKUP/INDEX-MATCH, SUMIFS/COUNTIFS, nested logic, dynamic arrays, and date and text functions

- Financial model building – driver-based budget, forecast, and long-range plan models that link revenue, drug cost, labor, and operating expenses to EBITDA and cash

- Model design best practices – clean structure, separated inputs and outputs, consistent formatting, error checks, and models others can easily follow and audit

- Scenario and sensitivity analysis – data tables, scenario toggles, and what-if analysis for business cases and reforecasts

- Data handling at scale – pivot tables, Power Query, and Power Pivot to clean, combine, and analyze large ERP and operational data exports across many sites

- Consolidation and roll-ups – linking site-level files for pharmacies and infusion centers into a consolidated enterprise view

- Automation – streamlining recurring reports; macros/VBA experience a plus

- Presentation-ready outputs – clear charts, summary tables, and reports for finance and executive leadership