Financial Planning & Analysis Data Manager

Financial Planning & Analysis Data Manager

Aloha Care’s leadership empowers and engages its employees by recognizing outstanding job performance and collaboration. We share organization-wide updates during quarterly All Staff meetings. We encourage participation in volunteer and educational opportunities. We put a high value on honesty, respect, and trust-building. We encourage open-door, two-way, and frequent communication.

Aloha Care’s comprehensive benefits package includes low-cost medical, dental, drug and vision insurance, paid time-off, 401k employer contribution, referral bonus and pretax transportation and parking program.

The Opportunity:

The Financial Planning and Analysis Data Manager will play a crucial role in strategic financial decision-making and operational efficiency. Reporting to the Director of FP&A, this individual will lead Aloha Care’s strategic financial planning and analysis activities. This individual will work collaboratively across departments to improve operational efficiency, analyze financial performance, and drive the overall financial success of the organization.

Primary Duties and Responsibilities:

Strategic Planning and Financial Analysis:

• Serve as a subject matter expert to a team of finance professionals, offering informal mentorship and sharing best practices to enhance team expertise and to cultivate a high-performance culture.
• Develop and execute complex calculations for provider incentives under P4P and other quality programs, including shared savings and value-based purchasing initiatives, ensuring accuracy and alignment with organizational goals.
• Support the design and implementation of shared savings and value-based purchasing initiatives, applying financial expertise to drive cost containment and improve program efficiency.
• Develop the financial forecast and annual operating budget for the company, including monthly/quarterly reforecasting and variance analysis.
• Lead efforts to develop and enhance the Finance data warehouse, ensuring robust architecture, data integrity, and optimized reporting capabilities to enable enterprise-wide financial analysis and decision support.
• Lead the calculation and reconciliation of State risk share settlements on a quarterly and annual basis, ensuring accuracy, compliance, and timely delivery.
• Develop detailed drill-down analysis to provide actionable insights to the Medical Economics Workgroup for cost of care and administrative expense initiatives.
• Support annual negotiations with DHS MED-Quest to ensure adequate capitation rates.
• Deliver analysis of core product financial indicators for recurring and ad hoc research.
• Assist with the preparation of internal financial and operating reports, including monthly financial statements, KPIs, Finance Committee and Board of Director reports, etc.
• Assist with the preparation of external financial and operating reports, including Quarterly and Annual regulatory (HI DOI, HI DHS MED-QUEST, and NAIC) reports.

Operational Management and Financial Reporting:

• Oversee and analyze monthly capitation-related calculations and reconciliations of provider directed payments; ensure timely processing of directed payments.
• Perform cost of care analysis, identifying key cost drivers and monitor financial trends.
• Preparation of 'Run Rate' analytical reports and reconciliation of prior period adjustments.
• Forecast and monitor the IBNR process, reconciliations of provider directed payments, and risk-sharing agreements.
• Provide comprehensive oversight to the reinsurance programs, including monthly reconciliation of reinsurance receivables, and timely processing of recoveries.
• Forecast and reconcile the various risk sharing and risk corridor agreements.
• Prepare ongoing provider risk pool statements and timely, accurate annual provider risk pool reserves and ultimately settlements.

Compliance and

Risk Management:

• Assist with preparation of supporting schedules and analysis for annual financial and regulatory audits.
• Support preparation of Risk Based Capital (RBC), statutory required capital reserves, and regulatory performance bonds calculations; ensure regulatory compliance.
• Support the Medicare bid cycle by…