Financial Analyst

The Center for Indigenous Health in the Department of International Health at the School of Public Health is seeking a Financial Analyst who will work under the supervision of the Financial Manager. The Financial Analyst will provide support in the areas of fiscal management, pre-award, post-award, non-sponsored awards, and payroll management.

The Financial Analyst will provide dedicated professional-level sponsored funds management for more than 80% of the time, with specific responsibilities for pre-award and post-award functions that include, but may not be limited to: proposal preparation, submission, budget development, account maintenance and oversight, billing/invoicing, reporting, compliance, and closeout. The Financial Analyst will work independently on a variety of grants/contracts that range from simple to highly complex. This role will also assist with some aspects of non-sponsored funds management.

Specific Duties & Responsibilities

Pre-award and post-award management

Pre-award management

• Submit grant proposals in Fibi for institutional review and approval, ensuring proposals are submitted on time and accurately.

• Work with Principal Investigators to prepare budgets and budget justifications for grant submissions.
• Partners with and act as the point of contact for departmental faculty, budgetary staff, and the Office of Research Administration in planning and developing application submissions to various federal offices, private agencies/foundations, and commercial companies.

Post-award management

• Review and approve SAP transactions, including online payments, journal transfers, shopping cards, and purchase orders, while ensuring all costs are allowable, allocable, and reasonable.

• Review and approve expense reimbursements, procurement, and corporate card transactions in Concur Expense, ensuring all costs are allocable, allowable, and reasonable.

• Process complex and non-routine journal transfers and oversee the institute’s faculty and student grants program.

• Keep abreast of institutional policies and the evolving financial regulatory environment and advise institute faculty and staff on best practices.

• Perform cost-benefit analysis; interpret and evaluate financial data and make recommendations based on results.

• Generate ad-hoc BW/Analysis reports to assist with institute strategic planning; develop forecasting models and projections.

• Manage related post-award processes, including award setup, review, account setup verification, and ensuring that staff is set up appropriately.

• Ensure that post-award responsibilities are completed, including budget distribution, account reconciliation, e-form setup, effort reporting, cost transfers, paying invoices, and paperwork finalization related to subcontract setup.

• Submit JAWS and SWIFT records; process and manage contracts for grants, contracts, and sub-contracts.

• Allocate budgets in SAP for new awards.

• Prepare sponsored invoices as necessary and run cash-collected reports to ensure all revenue is received; provide banking details to sponsors and work with Cash Accounting to post revenues to the proper cost centers and GLs.

• Process subcontractor invoices and generate goods receipts in SAP Central Receiving; conduct detailed invoice reviews and request supporting general ledger documentation as necessary, following the appropriate risk rating for the sub-recipient.

• Prepare monthly account reconciliations for review and make recommendations on future spending.

• Monitor projects to ensure expenditures are timely, within the project period, and in compliance with sponsor and university policy.

• Assist with reviewing and approving p-cards, T-cards, and reimbursements in Concur.

• Other responsibilities as assigned.

HR/Payroll

• Process various HR-related transactions in SAP, including Employment Actions, ISRs, and payroll cost transfers.
• Maintain internal salary tracking spreadsheets to allocate personnel salaries across various budget lines.
• Allocate salaries in SAP via payroll cost transfers (9027), ensuring e-forms are in compliance and processed within 90 days for sponsored funds.
• Assist with effort reporting.
• Assist with students, staff, and faculty new hire paperwork.
• Manage the payroll process for hourly workers (students and part-time staff) in TimesheetX.

Non-sponsored Account Management

• Manage and oversee non-sponsored accounts, including gift, endowment, and discretionary accounts. Provide monthly repor