Financial Analyst II - FP&A

This position will participate in the preparation and maintenance of the operating budget, monthly variance analyses, and database queries and reports. Along with these functions, this position will also participate in developing, monitoring, and reporting any assigned IEHP Program Dashboards.

1. Prepare monthly operational reports and evaluate financial performance by comparing and analyzing actual results with planned budget.
2. Develop and maintain financial reports using Oracle Hyperion financial reporting software.
3. Analyze past results, perform variance analysis, identify trends, and make recommendations for improvement.
4. Create accruals during month-end for business units, projects, or programs assigned.
5. Develop, monitor, and report monthly financial dashboard for assigned program or area of concentration.
6. Participate in the development of the operating budget and any periodic revisions necessary.
7. Prepare revenue budget and assist with medical costs budget.
8. Create ad-hoc reports and analysis when requested.
9. Provide support with requests from internal and external auditors.
10. Perform quality assurance on any work created that is shared both internally and externally to other business units within the organization.
11. Collect and prepare operational costs for Rate Development Template (RDT).

Minimum three years of business finance or related experience. Experience in budget to actual variance analysis. Experience in developing financial reports using ERP system reporting software. Experience working with Oracle and Hyperion or another ERP system.

Managed Care or related industry experience preferred, including but not limited to budgeting, planning, and capital management. Experience in statutory reporting a plus. Access, Word, PowerPoint and SQL experience a plus.

Bachelor’s degree in Accounting, Finance, Healthcare Administration, Business, or a related field from an accredited institution required.

Strong understanding of accounting/financial principles and methodologies. Strong knowledge and demonstrative proficiency utilizing Microsoft Excel. Principles and practices of health care industry and strategies, health care systems, capitated risk contracting, provider network structures and risk sharing arrangements a plus.

Ability to quickly gain an understanding of data requests (scope and purpose) and to produce accurate and useful reports. Synthesize data and communicate it clearly. Cross-train and back up other areas of the department. Intermediate skill level in Excel. Proficiency with Oracle Hyperion and Fusion ERP Systems. Familiarity with SQL or Access Databases.

Ability to work independently with medium level of supervision from both leadership and senior analysts. Ability to adapt to rapidly changing demands; thrives in a dynamic environment. Team Player who excels in collaborative environment. Strong attention to detail. Ability to communicate with all levels of management. Maintain effective working relationships with all levels of staff and management through effective communications whether verbally, in person, or in writing. Work cooperatively and effectively on group projects. Adhere to IEHP's policies and procedures.

The IEHP Team environment requires a Team Member to participate in the IEHP Team Culture. A Team Member demonstrates support of the Culture by developing professional and effective working relationships that include elements of respect and cooperation with Team Members, Members and associates outside of our organization.

This position requires the ability to sit at a computer workstation for an extended period. There is also moderate noise in such a business office environment with the use of computers, phones, and printers.