Job Description

1. Prepares financial reporting package for month end closing meetings in accordance with Generally Accepted Accounting Principles (GAAP):

• Prepares the Income Statement, Balance Sheet, and Trial Balance to be presented at monthly close meetings. Applies thorough knowledge of GAAP. Maintains PC-based software to prepare reports and resolve any validation errors. Develops working relationships with the Actuarial & Underwriting teams, Government Accounting & Reporting team, and other F&A units to obtain proper and timely information.
• Attend and take notes during monthly close meetings. Provide detailed summary to attendees after meeting with any follow-up items identified. Prepare detailed summary of meeting minutes for internal audit submission.
• Independently performs analysis of financial data for both revenue and expenses for HMSA and all of its subsidiary/affiliate companies. Assists in researching the nature and causes of variances and fluctuations in these accounts. Presents findings and recommendations to management. Performs various reconciliation of information from source data to reported amounts.

2. Prepares quarterly, semi-annual, and annual reports for the BCBSA, such as the quarterly financial report (QFR) and liquidity ratio (LR), RBC, and annual budget report. Assists with online submission of reports from other areas to the BCBSA, as needed.

3. Prepares quarterly letters to various banks in compliance with line of credit covenants. Assists in the preparation of supporting attachments such as the current ratio, minimum liquidity, and formatted financial statements in accordance with statutory accounting principles (SAP). Ensure that letters are filed in a timely manner.

4. Supports the compilation of data for various tax and regulatory filings, such as the Form 720 and Affordable Care Act (ACA) Patient-centered outcomes research institute (PCORI) fee. Assist in obtaining executive signatures and mailing forms timely.

5. Prepare supporting schedules for internal and external auditors to describe balances in the various general ledger accounts.

6. Performs all other miscellaneous responsibilities and duties as assigned or directed.

Qualifications

• Bachelor's degree in Accounting or related field and 2 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 but not limited to Word, Outlook, Excel, and PowerPoint
• Database manipulation software familiarity or relevant experience with data entry