Finance Business Analyst

Overview of Position

This position is responsible for the creation and maintenance of business system control tables and financial mapping tables which create journal entries used to interface  underwriting results into the financial system for GAAP and Statutory reporting.  Ties out financial reports for client conversions to new and existing business systems and documents the financial results. Performs user acceptance testing on system modifications and works with IT on system enhancements or client programs being converted to business systems.  Performs peer reviews and other quality control in support of other Business Analyst and /or Senior Business Analysts on the Finance Business Systems team.   Compiles and maintains documentation pertinent to controls and tasks.  Answers questions about the financial interfaces from financial analysts in accounting/finance.   Works with members of other departments to implement new client programs and modify tables for existing ones.  Supports process improvement projects and provides feedback on suggested changes in process to improve efficiency.  Provides support for financial interface results and audit requests relative to same.  Focuses on third party administered (TPA) clients and programs. Typically works independently under general supervision.

What will be my duties and responsibilities in this job?

• Participate in the development and deployment of new client program migrations to the AIM business system and historical client program migrations from the legacy business system to the AIM business system.  Verify system data and calculations, and reconcile financial interface journals to expected results.  Compile User Acceptance Testing (UAT) exhibits used to evaluate client data conversions and new client implementations for management presentation to obtain approval for implementation. (35%)

• Create, maintain, test, and secure business system control tables and financial system interface mapping tables used to create journal entries for existing and new client program business results. Perform UAT when control tables, financial system interface tables, or programs are modified in the UDB and/or AIM. (25%)

• Participate in peer reviews of work done by peers in the Finance Business Systems team.  Investigate, correct, and mitigate errors found in control or interface tables. (10%)

• Perform analysis on program results to provide support to finance team relative to business system and interface journal entries.  Validate financial business system interfaces remain in compliance with GAAP and statutory requirements.  Reconcile data pulled by IT staff for internal or external audit requests to expected results.  (10%)

• Compile and maintain process and procedure documentation. Recommend and propose changes and improvements to existing procedures and processes to management. (10%)

• Compile exhibits used by IT to pull data for internal/external audit requests and reconcile the expected to actual results. (5%)

• Communicate status of assignments and projects to manager and TPA team members. (5%)

• Perform all other duties and participate in special projects assigned by management.

What are the requirements needed for this position?

Education, Certifications and Experience:

• Entry-Level to intermediate knowledge of accounting/finance practices and principles, as evidenced by a B.S. in Accounting or Finance

• Minor in Information Technology

• Minimum 2 years accounting or finance experience

 Knowledge, Skills and Abilities:

• Understanding of database theory

• Demonstrated knowledge of accounting/finance principals.

• Strong verbal and written communication skills

• Proficient with Microsoft Excel and Word

• Time management skills to stay focused and meet deadlines

• Able to multi-task and juggle assignments

• Able to adapt to changing priorities

• Strong problem solving abilities

• Strong attention to details

• Able to work effectively in a team environment

• Goal/results oriented

What other skills/experience would be helpful to have?

Education, Certifications and Experience:

• BS in Accounting or Finance

• Familiarity with insurance terminology

• Insurance accounting experience a plus

• Minimum 2 yrs Experience working with databases

• Experience with SharePoint and