Manager, Financial Planning & Analysis (FP&A), Reconciliation

Overview

This role ensures the accuracy, completeness, and integrity of financial reconciliations for Aetna Federal Plans. Responsibilities include establishing and maintaining reconciliation standards, supporting timely completion of reconciliations as PSHB volume grows, and ensuring reconciliation processes and documentation meet OPM, OIG, and external audit requirements.

The position reports to the Lead Director, FP&A, and collaborates closely with Claims Reporting, IT & Business Analysis, and other stakeholders to resolve variances, strengthen controls, and improve operational efficiency.

Responsibilities

• Lead month-end, quarter-end, and year-end reconciliation processes for claims, working capital, and related balance sheet accounts.
• Research, analyze, and resolve reconciling items and financial variances; partner with data owners to ensure timely resolution.
• Lead efforts to address and clear reconciliation backlogs, including aged or complex outstanding items.
• Develop, document, and maintain reconciliation procedures, SOPs, templates, and consistent preparer/reviewer standards.
• Identify reconciliation and control gaps and recommend process improvements to strengthen accuracy, compliance, and audit readiness.
• Provide reconciliation documentation and support for OPM, OIG, and agreed-upon procedures (AUP) engagements.
• Serve as a key point of contact for external auditors regarding reconciliation-related matters.
• Partner with IT & Business Analysis to identify opportunities to automate manual reconciliation activities and improve data source quality and reliability.
• Provide guidance, training, and mentorship to analysts on reconciliation methodologies, standards, documentation, and best practices.
• Participate in departmental and cross-functional projects as needed.

Requirements

• 5+ years of experience in account reconciliation, financial accounting, or related discipline, including experience with complex and high-volume reconciliations.

Preferred Qualifications

• Healthcare or health insurance finance experience, preferably involving FEHB, PSHB, or other federal programs.
• Familiarity with OPM, OIG, or AUP audit environments.

Technical Skills

• Advanced proficiency in Excel, including lookups, pivot tables, and reconciliation templates for large datasets.
• Experience with SQL or similar tools used to extract, analyze, and validate claims and financial data.
• Experience working with general ledger and financial reporting systems.
• Working knowledge of data warehouse environments and reconciliation automation.
• Ability to develop clear, well-organized, and audit-ready workpapers and supporting documentation.

Education

• Bachelor’s degree required in accounting, Finance, or a related field, or equivalent years of related experience.

Compensation & Benefits

• Pay Range: $66,330.00 - $145,860.00
• This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on experience, education, geography, and other relevant factors.
• Eligibility: This position is eligible for a bonus, commission, or short-term incentive program in addition to the base pay range listed above.
• Benefits (based on eligibility): medical, dental, vision, paid time off, retirement savings options, wellness programs, and other resources.

Location

• Not specified.

Schedule

• Anticipated weekly hours: 40
• Time type: Full time

Application Notes

• Anticipated application window close date: 10/29/2026
• Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws.