Hawaii Medical Service Association
Senior Investment Accounting Analyst
Hawaii Medical Service Association, Honolulu, Hawaii, United States, 96814
Job Summary
**Hybrid Work Environment - Must reside in Hawaii **
Pay Range : $59,000 - $116,000
Note : Individuals typically begin between the minimum to middle of the pay range
Lead the investment accounting functions for HMSA as required by Generally Accepted Accounting Principles (GAAP), the State of Hawaii, and the National Association of Insurance Commissioners (NAIC). Record, reconcile, and analyze revenue transactions for all the Association's Self-Funded (AFM) groups. Coordinate exchange of this information with the Underwriting department. Perform quarterly reporting to the national Blue Cross and Blue Shield Association (BCBSA). Coordinate requests from external auditors for internally prepared documentation from various HMSA staff and departments and ensure timely completion of these requests.
Exempt or Non-Exempt
Exempt
Minimum Qualifications
Bachelor's degree with three years of related work experience; or an equivalent combination of education and related work experience.
Effective verbal and written communication skills.
Financial analysis skills.
Project coordination and documentation skills.
Knowledge of Generally Accepted Accounting Principles (GAAP).
Proficient working knowledge of Microsoft Office applications.
Duties and Responsibilities
Responsible for leading the recording and reporting of all investment transactions for the Association in accordance with GAAP, State of Hawaii Insurance Division, and NAIC guidance:
Obtains information from the Association's banks and trust company to record all investment transactions on a monthly basis to the general ledger (GL). Information is provided to an analyst to record into an automated investment subsidiary ledger. Reconciliation of the balances between the banks, subsidiary ledgers, and general ledgers are performed on a monthly basis. Follow-up with other analysts and banks are performed to resolve any discrepancies. Specific data is summarized and reports prepared to assist in the preparation of the Association's monthly financial statements.
Prepare investment information and adjustments on a quarterly basis in order to report investment transactions on a Statutory Basis (SAP) as required by the State of Hawaii and NAIC. Transactions are reconciled between GAAP and SAP and provided to Sr. Reporting Analysts in order to file quarterly regulatory reports.
Summarizes revenue/billing information from the Underwriting (UND) Department for Self-Funded (AFM) employer groups and the revenue recorded in the GL each month. This revenue and related accounts receivable balances by group must be reconciled to subsidiary ledgers maintained by the UND department. Any discrepancy is followed-up with the UND department. Aging reports on unpaid balances are also prepared and delinquent amounts are reported to the UND, Sales, and Executive departments.
Coordinate external auditor's requests on a semi-annual basis for various supporting worksheets and schedules. Requests from the auditors will be forwarded to the appropriate Finance staff and/or other internal departments. Due dates will be communicated with the appropriate preparer and follow-up will be performed for outstanding requests. Tracking of these requests and completion dates will also be documented.
Prepare quarterly and annual financial reports for the national BCBSA. Respond to requests for financial information from BCBSA. Assist with online submission of reports from other areas to the BCBSA.
Perform other reporting and reconciliation on various general ledger accounts. These will include cash accounts, prepaid assets, and revenues accounts. Communication with the appropriate departments will be made to resolve any discrepancies or unusual transactions.
Performs other duties as assigned.
#J-18808-Ljbffr
**Hybrid Work Environment - Must reside in Hawaii **
Pay Range : $59,000 - $116,000
Note : Individuals typically begin between the minimum to middle of the pay range
Lead the investment accounting functions for HMSA as required by Generally Accepted Accounting Principles (GAAP), the State of Hawaii, and the National Association of Insurance Commissioners (NAIC). Record, reconcile, and analyze revenue transactions for all the Association's Self-Funded (AFM) groups. Coordinate exchange of this information with the Underwriting department. Perform quarterly reporting to the national Blue Cross and Blue Shield Association (BCBSA). Coordinate requests from external auditors for internally prepared documentation from various HMSA staff and departments and ensure timely completion of these requests.
Exempt or Non-Exempt
Exempt
Minimum Qualifications
Bachelor's degree with three years of related work experience; or an equivalent combination of education and related work experience.
Effective verbal and written communication skills.
Financial analysis skills.
Project coordination and documentation skills.
Knowledge of Generally Accepted Accounting Principles (GAAP).
Proficient working knowledge of Microsoft Office applications.
Duties and Responsibilities
Responsible for leading the recording and reporting of all investment transactions for the Association in accordance with GAAP, State of Hawaii Insurance Division, and NAIC guidance:
Obtains information from the Association's banks and trust company to record all investment transactions on a monthly basis to the general ledger (GL). Information is provided to an analyst to record into an automated investment subsidiary ledger. Reconciliation of the balances between the banks, subsidiary ledgers, and general ledgers are performed on a monthly basis. Follow-up with other analysts and banks are performed to resolve any discrepancies. Specific data is summarized and reports prepared to assist in the preparation of the Association's monthly financial statements.
Prepare investment information and adjustments on a quarterly basis in order to report investment transactions on a Statutory Basis (SAP) as required by the State of Hawaii and NAIC. Transactions are reconciled between GAAP and SAP and provided to Sr. Reporting Analysts in order to file quarterly regulatory reports.
Summarizes revenue/billing information from the Underwriting (UND) Department for Self-Funded (AFM) employer groups and the revenue recorded in the GL each month. This revenue and related accounts receivable balances by group must be reconciled to subsidiary ledgers maintained by the UND department. Any discrepancy is followed-up with the UND department. Aging reports on unpaid balances are also prepared and delinquent amounts are reported to the UND, Sales, and Executive departments.
Coordinate external auditor's requests on a semi-annual basis for various supporting worksheets and schedules. Requests from the auditors will be forwarded to the appropriate Finance staff and/or other internal departments. Due dates will be communicated with the appropriate preparer and follow-up will be performed for outstanding requests. Tracking of these requests and completion dates will also be documented.
Prepare quarterly and annual financial reports for the national BCBSA. Respond to requests for financial information from BCBSA. Assist with online submission of reports from other areas to the BCBSA.
Perform other reporting and reconciliation on various general ledger accounts. These will include cash accounts, prepaid assets, and revenues accounts. Communication with the appropriate departments will be made to resolve any discrepancies or unusual transactions.
Performs other duties as assigned.
#J-18808-Ljbffr