Apply on Employer Site

AlohaCare · 3 weeks ago

Financial Planning & Analysis Data Manager

Honolulu, HI

Full-time

Onsite

Senior Level, Lead/Staff

$90K/yr - $125K/yr

10+ years exp

AlohaCare is a local, non-profit health plan serving Hawai`i’s low-income residents. The Financial Planning and Analysis Data Manager will lead strategic financial planning and analysis activities, working collaboratively across departments to improve operational efficiency and drive financial success for the organization.

Health CareHealth DiagnosticsHospitalMedical

Responsibilities

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

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

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 facilitating finance data requests, conducting financial analysis and data validation

All other duties assigned

Adhere to regulatory compliance and quality guidelines as well as AlohaCare policies and procedures

Responsible for maintaining AlohaCare’s confidential information in accordance with AlohaCare policies, and state and federal laws, rules and regulations regarding confidentiality. Employees have access to AlohaCare data based on the data classification assigned to this job title

Qualification

Financial forecastingData analysisActuarial modelingProject managementHealthcare financeRegulatory complianceAnalytical toolsLeadership skillsCommunication skillsInterpersonal skillsProblem-solvingTime management

Required

Bachelor's degree with emphasis in business administration, mathematics, statistics, data analysis, accounting/finance or healthcare administration or equivalent combination of education and experience

Minimum of 10 years of professional work experience in a managed care or healthcare environment, demonstrating the ability to perform the duties required for the position

Experience with actuarial modeling & IBNR reserve setting, MCO rate setting process and cycle

Achieves results, builds trust, communicate effectively, customer and quality focused

Excellent interpersonal skills with the ability to communicate with all levels of the organization

Strong interpersonal, facilitation and leadership skills with ability to interact with various departments/ project teams

Excellent, effective, and precise written and oral communication skills; speak clearly and persuasively in positive or negative situations

Ability to organize, coordinate and supervise large projects in a timely, creative and effective manner

Ability to solve problems, analyze, think critically, make good judgment and make fair decisions

Experience in project management, management reporting and analysis and excellent in building, maintaining and working with spreadsheets

Able to effectively and methodically implement, manage, monitor, track and/or report on assigned tasks and projects

Possesses excellent time management and organizational skills; is dependable, enthusiastic, self-starting, and self-motivated. Uses time effectively, reacts professionally under pressure

Demonstrated strong skills in providing solutions and/or troubleshooting complex accounting issues

Excellent leadership, communication, and analytical skills

Able to effectively work in a fast-paced and changing environment, manage multiple projects and priorities across multiple teams/projects and in a matrixed environment

Must be customer service oriented and be able to work in a diverse, demanding and evolving environment with strong conflict and problem resolution skills

Advanced skills in analytical/reporting tools (Access, SQL, Stata, SAS, SPSS)

Advanced skills in Microsoft Programs, including Word, Excel, Access, Outlook and PowerPoint

Experience in the operation of general office equipment to include PC, fax/copy machine and phone system