Financial Analyst

Polaris Pharmacy Services; Fort Lauderdale (FL); On-site; USD 65,000 - 95,000; Full time

Job summary

Polaris Pharmacy Services is seeking a Financial Analyst to join its Strategic Finance team in Fort Lauderdale. You will drive annual planning, quarterly reforecasts, and long-range modeling for a multi-site organization.

The role emphasizes expert Excel, site-level forecasting, KPI dashboards, and collaboration with finance leadership to deliver insights for executives.

Qualifications

• Bachelor's degree in finance, accounting, economics, or related field.
• 2–4 years of FP&A, corporate finance, public accounting, banking, or consulting experience.
• Expert-level Excel proficiency with proven model-building.
• Strong knowledge of ERP systems; Power BI, SQL or planning systems a plus.
• Comfort with AI tools in finance for analysis and automation.
• Solid understanding of financial statements and accounting fundamentals.

Responsibilities

• Support annual operating plan, quarterly reforecast, and long-range plan.
• Prepare and update site-level plans and forecasts for each pharmacy and infusion center.
• Update reforecast with schedules for revenue, drug cost, labor, and Opex.
• Maintain the long-range plan model and assumptions.
• Prepare monthly plan-vs-actual and variance reports at enterprise and site levels.
• Draft concise commentary; assist in monthly financial reporting and executive materials.
• Maintain KPI reporting including prescriptions, revenue per script, census, payer mix, labor productivity.
• Build/update models for business cases, pricing, and site performance reviews.
• Support M&A and partnership analyses with data gathering and inputs.
• Assist cash flow forecasting and working capital tracking.
• Identify opportunities to automate reports and document processes.

Skills

Advanced Excel

Executive communication

KPI reporting

AI in finance

ERP systems

Power BI

SQL

Scenario analysis

Education

Bachelor's degree in finance or related

Tools

Power BI

SQL

ERP systems (Sage Intacct)

Sage Intacct

Job description

Job Details: Job Location: Polaris Pharmacy Services of Ft Lauderdale - Ft. Lauderdale, FL 33309, Position Type: Full Time, Education Level: 2 Year Degree, Job Category: Admin - Clerical, 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

• 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