Financial Planning & Analysis Data Manager

Financial Planning & Analysis Data Manager

Aloha Care is a local, non‑profit health plan serving Hawai`i’s low‑income residents with free Medicaid and dual Medicare health insurance coverage. Our members include children, seniors and adults residing on all islands. We provide comprehensive benefits and managed care services with an emphasis on healthy living habits and preventive primary health care. Our approach is to meet the whole‑person health and social needs of members.

Through our community partnerships we offer innovative services such as connection to social service agencies, Native Hawaiian healing services and in‑home primary care for qualified members. Our mission is to serve in the true spirit of aloha by ensuring and advocating for access to quality health care for all. We are Hawaii’s third‑largest health plan and offer a wide network of quality primary care, specialists, hospitals, pharmacies and many other providers across the state.

Aloha Care employees have a passion for helping Hawai`i’s most underserved communities. Our caring culture is fundamental to our company‑wide team approach to providing high quality services. We support our employees with a supportive and positive work environment, healthy work‑life balance, continuous communication, and a generous benefits package. Leadership empowers and engages employees by recognizing outstanding job performance and collaboration. We encourage participation in volunteer and educational opportunities and value honesty, respect and trust‑building.

Open‑door, two‑way, frequent communication is encouraged. Our benefits package includes low‑cost medical, dental, drug and vision insurance, paid time‑off, 401(k) employer contribution, referral bonus and pre‑tax transportation and parking programs.

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, collaborating across departments to improve operational efficiency, analyze financial performance, and drive overall financial success.

• Serve as a subject matter expert, offering informal mentorship and sharing best practices to enhance team expertise.
• Develop and execute complex calculations for provider incentives under P4P and other quality programs.
• Support the design and implementation of shared savings and value‑based purchasing initiatives.
• Develop the financial forecast and annual operating budget, including monthly/quarterly reforecasting and variance analysis.
• Lead efforts to develop and enhance the Finance data warehouse for robust architecture, data integrity, and optimized reporting.
• Calculate and reconcile State risk share settlements on a quarterly and annual basis.
• Provide detailed drill‑down analysis for cost of care and administrative expense initiatives.
• Support annual negotiations with DHS MED‑Quest for adequate capitation rates.
• Deliver analysis of core product financial indicators for recurring and ad‑hoc research.
• Assist with preparation of internal financial and operating reports, including monthly statements, KPIs, Finance Committee and Board of Directors reports.
• Assist with preparation of external financial and operating reports for regulatory agencies (HI DOI, HI DHS MED‑QUEST, NAIC).

• Oversee and analyze monthly capitation calculations and reconciliations.
• Perform cost of care analysis, identifying key cost drivers.
• Prepare 'Run Rate' analytical reports and reconcile prior period adjustments.
• Forecast and monitor the IBNR process and risk‑sharing agreements.
• Provide oversight to reinsurance programs and monthly reconciliations.
• Prepare ongoing provider risk pool statements and annual reserves.

• Prepare supporting schedules and analysis for annual financial and regulatory audits.
• Support Risk Based Capital (RBC) and statutory reserve calculations.
• Assist Medicare bid cycle by facilitating finance data requests and analysis.
• Adhere to…