Statutory Financial Reporting Analyst

HMSA • Honolulu, HI

4h

About The Position

Prepares statutory financial reports for the State of Hawaii Insurance Division in accordance with the NAIC Accounting Practices and Procedures manual. Maintains separate SAP-based accounting records in Excel, converting GAAP balances to SAP balances through documented adjustments. Also prepares financial reports for the Blue Cross Blue Shield Association (BCBSA), supports auditors with schedules and explanations, and performs other assigned duties.

Requirements

• Bachelor’s degree in Accounting or a related field and two years of related work experience, or an equivalent combination of education and related work experience.
• Knowledge of Generally Accepted Accounting Principles (GAAP).
• Knowledge of Statutory Accounting Principles (SAP) and/or government accounting and reporting.
• Effective verbal and written communication skills.
• Financial analysis skills.
• Project coordination and documentation skills.
• Intermediate working knowledge of Microsoft Office applications, including Word, Outlook, Excel, and PowerPoint.
• Familiarity with database manipulation software or relevant data-entry experience.

Responsibilities

• Prepare and timely file the Association’s annual statement and required reports for the State of Hawaii Insurance Division, applying Statutory Accounting Principles (SAP) and resolving validation errors in PC-based reporting software.
• Prepare and timely file first-, second-, and third-quarter statements.
• Prepare supplemental quarterly and annual reports, including Risk-Based Capital (RBC) reports, supplemental investment schedules, and management discussion and analysis (MD&A).
• Maintain separate SAP accounting records and prepare journal entries related to SAP financial statements.
• Convert GAAP balances to SAP balances by developing and documenting adjustments; remain current on SAP legislation and accounting guidance and bring relevant changes to management and the team’s attention.
• Prepare quarterly, semi-annual, and annual reports for the BCBSA, including the quarterly financial report (QFR), liquidity ratio (LR), RBC, and annual budget report.
• Assist with online submission of reports from other areas to the BCBSA as needed.
• Provide internal and external auditors with supporting schedules and worksheets for general ledger account balances, explain GAAP-to-SAP adjustments, and communicate the basis for adjustments and balances.
• Perform other miscellaneous responsibilities and duties as assigned or directed.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level