Senior Analyst

  • Education: Bachelor's degree in Finance, Business Administration, Accounting, Economics, Public Administration, or a quantitative data field.
  • Experience: 4-6 years of corporate finance, financial planning & analysis (FP&A), or public sector fund accounting experience.
  • Required Experience: At least 2 years working within an LMHA, public behavioral health network, state-funded healthcare system, or a Medicaid-heavy health provider environment.
  • Technical Skills: Expert-level mastery of Microsoft Excel (Power Query, Power Pivot, macros, data tables). Proficient with business intelligence software (Power BI or Tableau) and state-mandated reporting portals or enterprise accounting databases. [5]

Key Responsibilities

Strategic Forecasting & Scenario Modeling (35%)

  • Dynamic Planning: Build, maintain, and stress-test the LMHA's rolling multi-year financial forecasting models to ensure long-term fiscal health.
  • Pro-Forma Business Analysis: Develop ROI models, break-even analyses, and financial pro-formas to evaluate proposed clinical expansions, new satellite clinics, or telehealth initiatives.
  • Funding Scenario Planning: Construct predictive "what-if" models to assess the financial impact of changes to state contract allocations, regional Medicaid reimbursement rates, or clinical staffing levels.

State Reporting, Compliance & Fund Optimization (30%)

  • State Cost Reporting: Lead the compilation, analysis, and submission of mandatory state healthcare cost reports, ensuring accurate overhead and clinical cost allocations.
  • Contract Metric Tracking: Monitor and model state-mandated performance metrics (e.g., target population service caps, crisis response times, and utilization quotas) to protect state funding tranches. [1]
  • Audit Protection & Allowability: Review budget structures against state accounting guides to ensure all expenditures comply with uniform grant management standards and avoid funding clawbacks.
  • Public Funds Reconciliation: Partner with the accounting team to ensure local tax appropriations, state general revenue, and federal block grants are tracked within appropriate fund-accounting structures.

Clinical Revenue & Productivity Analytics (25%)

  • Revenue Cycle Partnership: Collaborate weekly with the Billing and Revenue Manager to extract Electronic Health Record (EHR) claims data, analyze payer-mix behavior, and forecast net patient revenue.
  • Clinician Productivity Modeling: Build dashboards evaluating provider utilization, time-allocation logs, cost-per-encounter, and revenue-generation benchmarks across clinical teams (e.g., Crisis, Adult, Child & Adolescent). [2]
  • Denial & Leakage Analytics: Track structural insurance and Medicaid denial trends to quantify lost revenue and identify process flaws within clinical documentation or front-desk collections.

Variance Reporting & Executive Data Visualization (10%)

  • Executive Dashboards: Design and distribute highly visual, monthly KPI dashboards for the CFO, clinic directors, and board members.

Monthly Variance Reviews: Lead the investigation of month-end budget vs. actual variances, proactively flagging structural spending abnormalities in personnel or overhead before they impact cash flow. [3, 4

Full Time

Great Benefits

Tyler