Financial Analyst/Planner Specialist - Property Accounting

Hiring Department: UI Health Finance

Location: Chicago, IL USA

Requisition ID: 1024537

Posting Close Date: 5/10/2024

About the University of Illinois Chicago

UIC is among the nation’s preeminent urban public research universities, a Carnegie RU/VH research institution, and the largest university in Chicago. UIC serves over 34,000 students, comprising one of the most diverse student bodies in the nation and is designated as a Minority Serving Institution (MSI), an Asian American and Native American Pacific Islander Serving Institution (AANAPSI) and a Hispanic Serving Institution (HSI). Through its 16 colleges, UIC produces nationally and internationally recognized multidisciplinary academic programs in concert with civic, corporate and community partners worldwide, including a full complement of health sciences colleges. By emphasizing cutting-edge and transformational research along with a commitment to the success of all students, UIC embodies the dynamic, vibrant and engaged urban university. Recent “Best Colleges” rankings published by U.S. News & World Report, found UIC climbed up in its rankings among top public schools in the nation and among all national universities. UIC has nearly 260,000 alumni, and is one of the largest employers in the city of Chicago.

This is a full-time and benefits eligible position. UI Health offers competitive salaries commensurate with experience. In addition all full time benefits eligible positions include a comprehensive benefits package which include; Health, Dental, Vision, Life, Disability & AD&D insurance, a defined benefit pension plan as well as paid leave which includes; Vacation, Holiday and Sick. In addition we offer tuition waivers for employees and dependents. Click for a complete list of Employee Benefits

UI Health is seeking a Financial Analyst/Planner Specialist (Property Accounting) to join our Hospital Finance team. This role is responsible for accounting and reporting of Hospital and Clinics assets, which includes analysis of the invoices related to new acquisitions to determine appropriate reporting and accounting of assets. Perform reconciliations and analyses, journal entries, and financial and statistical input for reports and surveys. Provide analytics for Hospital's $2.6B (annual) in gross revenue and $800M (annual) in net patient revenue. Additional duties include managing and accounting Hospital leases to comply with GASB 87 leases and Hospital software subscriptions to comply with GASB 96 subscription-based IT arrangement.

Duties & Responsibilities:

• Obtain preliminary data and begin analysis for appropriate classification, anticipate acquisitions and projects based on the capital budget, coordinate with budgeting for periodic capital report.
• Develop or use form(s) for tracking, classification, and database maintenance.
• Download from Banner or other systems the various accounts that would provide transactional data. Use of Fabweb will be required. Investigate and correct any anomalies.
• Investigate, explore and utilize resources to meet departmental needs and requirements to provide information and enhance existing reports.
• Coordinate activities of the various sections within the department and with non-departmental users as needed related to data.
• Coordinate interaction with Banner, Fabweb and other systems as it relates to obtaining data.
• Manage Hospital and Clinics compliance related to Property Accounting and Reporting which includes determining department Directors are following the University of Illinois Medical Center Management Policy and Procedures (EC 4.06) regarding responsible custodianship of equipment.
• Coordinate with Materials Management, University Accounting or University Insurance when appropriate.
• Other reports are prepared, and analyses are performed on an ad hoc basis.
• Perform other related duties and participate in special projects as assigned.

Minimum Qualifications Required:

1. Any one or combination totaling four (4) years (48 months) from the categories below:

A. college coursework comparable to that in a field related to financial analysis/planning such as accounting, business administration, economics, finance, statistics, or a closely related field

• 30 semester hours equals one (1) year (12 months)
• Associate Degree (60 semester hours) equals eighteen (18) months
• 90-semester hours equals two (2) years (24 months)
• Bachelor’s Degree (120 semester hours) equals three (3) years (36 months)
• Master’s Degree equals four (4) years (48 months)

B. work experience in developing financial or economic analyses, research designs, strategic plans, or data models.

2. One (1) year (12 months) of professional level progressively responsible financial work experience.

Preferred Qualifications:

• Prepare financial and statistical reports that are used for monthly financial closes.
• Monthly reports include but not limited to, patient revenue analysis, miscellaneous/other income, days cash on hand, Physician Transfer and Professional Services fees.
• Reports also include Quarterly receivable reports required by Illinois State Comptroller’s Office and annual GAAP (Interagency Net Receivable) reports.
• Prepare receivable and payable audit schedules which are part of prepared by auditee (PBA) reports provided to external auditors (Financial, Federal, State and Compliance) and other stakeholders.
• Reconcile receivables of all Hospital general ledger accounts which requires coordinating and working with different departments in the University to resolve reconciling items.
• Manage monthly accrual process working with Directors of Hospital units. Reviews accruals and prepays submitted by Hospital units.
• Manage property accounting of all Hospital fixed assets. During the close, Cash, Revenue and A/R Reports are generated using Banner and Epic systems generated reports.
• Running reports on Professional services from the Banner and Eddie Systems and distributing them for further analysis used primarily by Cost Reimbursement professionals.
• Drawing information from Illinois Comptroller reports for use in Bank Reconciliations.
• Other responsibilities include preparing requisitions and submitting invoices for payment when necessary for lease or other purchases.
• Generating data for surveys.
• Familiarity with and practical knowledge of Microsoft Office modules of Word, Excel and Outlook for data processing methods and techniques involved in current computer systems.
• For preparing most of the analytical, statistical and financial reports, use of mainframe system (Banner) downloads and Excel for spreadsheet entry is necessary.
• Analytical skills are important, therefore being trained in accounting or a related field is important.
• Preparing ratios (using financial and statistical data) and noting trends or highlighting/investigating anomalies is key to the position.
• Learning and using a mainframe system (Banner) is important for running general ledger reports for ad-hoc financial activity. The employee must be able to prepare and enter journal entries (journal vouchers) to enter transactions.
• Using the mainframe system for requisitions and accounts payable is important. Learning I-Buy will be beneficial as the procurement system is being migrated to the I-Buy system.
• Eddie and Document Direct have available reports that are then used for analyses. Knowing the contents, the ability to produce, and having the ability to recognize anomalies is important.
• Drawing information from the Illinois Controller website reports for use in Bank Reconciliations is required.
• Gathering data for audits on accruals, and other Prepared-by-Auditee schedules requires using Excel and pdf software.

To Apply: For fullest consideration click on the Apply Now button, please fully complete all sections of the online application including adding your full work history with specific details of your duties & responsibilities for each position held. Fully complete the education, licensure, certification and language sections. You may upload a resume, cover letter, certifications, licensures, transcripts and diplomas within the application.

Please note that once you have submitted your application you will not be able to make any changes. In order to revise your application you must withdraw and reapply. You will not be able to reapply after the posting close date. Please ensure the application is fully completed and all supporting documents have been uploaded before the posting close date. Illinois Residency is required within 180 days of employment

The University of Illinois System is an equal opportunity employer, including but not limited to disability and/or veteran status, and complies with all applicable state and federal employment mandates. Please visit Required Employment Notices and Posters to view our non-discrimination statement and find additional information about required background checks, sexual harassment/misconduct disclosures, and employment eligibility review through E-Verify.

The university provides accommodations to applicants and employees. Request an Accommodation