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

Overview

The organization is seeking a Manager, Financial Planning & Analysis (FP&A) focused on Reconciliation for Aetna Federal Plans. This role ensures the accuracy, completeness, and integrity of financial reconciliations, establishes and maintains reconciliation standards, supports timely completion of reconciliations as PSHB volume grows, and prepares reconciliation processes and documentation to meet OPM, OIG, and external audit requirements.

This position reports to the Lead Director, FP&A, and collaborates with Claims Reporting, IT & Business Analysis, and other stakeholders to strengthen reconciliation processes, resolve variances, improve controls, and promote 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 and 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 the quality and reliability of data sources.
• 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.
• Bachelor’s degree required in accounting, Finance, or a related field or equivalent years of related experience.

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 support documentation.

Compensation & Benefits

• Pay Range: $66,330.00 - $145,860.00 (typical pay range for this role)
• This range represents the base hourly rate or base annual full-time salary for the job grade. Actual base pay offer depends on factors including experience, education, geography, and other relevant factors.
• This position is eligible for a bonus, commission, or short-term incentive program in addition to base pay.
• Benefits: Medical, dental, and vision coverage; paid time off; retirement savings options; wellness programs; and other resources based on eligibility.

Location

• Not specified in the provided job description.

Schedule

• Anticipated Weekly Hours: 40
• Time Type: Full time

Application Deadline

• Anticipated application window closes on: 10/29/2026

Equal Employment Opportunity

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state, and local laws.