GAAP Financial Reporting Analyst

HMSA•Honolulu, HI

19h

About The Position

The GAAP Financial Reporting Analyst prepares financial reports and analyses for month-end close, regulatory and tax filings, bank covenant compliance, and audit support. The role prepares the Income Statement, Balance Sheet, and Trial Balance for monthly close meetings; maintains PC-based reporting software and resolves validation errors; and works with actuarial, underwriting, government accounting and reporting, and other finance and accounting teams to obtain timely information. The analyst attends monthly close meetings, documents and distributes meeting summaries and follow-up items, and prepares minutes for internal audit submission. The position independently analyzes revenue and expenses for HMSA and its subsidiary and affiliate companies, researches variances, presents findings and recommendations to management, and reconciles source data to reported amounts. The analyst also prepares quarterly, semi-annual, and annual reports for the BCBSA, including the QFR, LR, RBC, and annual budget report, and assists with online report submissions from other areas. The role prepares quarterly bank letters related to line-of-credit covenants and supporting materials, supports tax and regulatory filings such as Form 720 and the ACA PCORI fee, obtains executive signatures and mails forms, and prepares general-ledger account schedules for internal and external auditors. Other responsibilities may be assigned or directed.

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).
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 the Income Statement, Balance Sheet, and Trial Balance for monthly close meetings in accordance with GAAP.
Maintain PC-based reporting software and resolve validation errors.
Coordinate with actuarial, underwriting, government accounting and reporting, and other finance and accounting teams to obtain accurate and timely information.
Attend monthly close meetings, take notes, distribute detailed summaries and follow-up items, and prepare meeting minutes for internal audit submission.
Analyze revenue and expense data for HMSA and its subsidiary and affiliate companies; research variances and fluctuations; and present findings and recommendations to management.
Reconcile information from source data to reported amounts.
Prepare quarterly, semi-annual, and annual reports for the BCBSA, including QFR, LR, RBC, and annual budget reports.
Assist with online submission of reports from other areas to the BCBSA as needed.
Prepare quarterly letters to banks to comply with line-of-credit covenants and support them with materials such as current ratio, minimum liquidity, and financial statements formatted according to SAP.
Ensure bank letters are filed in a timely manner.
Support data compilation for tax and regulatory filings, including Form 720 and the ACA PCORI fee; obtain executive signatures and mail forms on time.
Prepare supporting schedules that describe general-ledger account balances for internal and external auditors.
Perform other assigned or directed responsibilities and duties.