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]

• 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 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.

• 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.

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

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