Lead Finance and Grant Analyst Full Time NEW

Under the supervision of the Finance Coordinator, in a cross-functional capacity, monitors grant compliance and analyzes financial data in order to manage all aspects of the Ryan White grant program and report on the financial status of the multiple grants within the program as well as each projects finances. Ensure payments are posted within the individual RW program areas appropriate accounts, allocate site specific expenses, calculate drawdowns, and manage payroll cost category calculations for each grant. Processes complex Grant required Ryan White reports, including line item budget and narrative reports, allocation reports, expense reports, and a complex reporting tool with specific cost categories related to each Grant. Maintain separate spreadsheet specific to the patient revenue, including Ryan White 340B revenue and non-grant related expenses. Assist staff with the reconciliation of 340B pharmacy revenue specific to each program.

Essential Functions

Works daily in the general ledger financial software. Reviews general ledger for compliance with Generally Accepted Accounting Principles. Reviews and monitors the general ledger on a continual basis. Prepares and enters account corrections to the integrated financial system, including journal entries. Also performs various general ledger reconciliations.

Responsible for grant program, financial reporting and deadlines. May perform complex, specialized grant accounting functions, prepare expense spreadsheets, comparing grant expenditures to the grant budget, writing pertinent financial grant narrative and complies with periodic financial reporting and reimbursement submitted requirements.

Contributes to and participates in the development of the annual Health Department budget. Assists with monitoring and tracking budget outcomes including revenue and expenditure projections.

Design and implement a systematic method for compiling, collecting, organizing, analyzing and disseminating required documentation and information needed for programmatic, administrative, clinical and financial reporting, invoicing, grant solicitations, and audits/site visits. Evaluate the effectiveness and efficiency of the RW programs.

Query data from the Electronic Health Records system and CareWare system to import into excel, verify the accuracy and produce report and articulate and explain results, issues, and exceptions.

Contributes to and participates in the development of the annual operating CHC budget. Assists with monitoring and tracking budget outcomes including revenue and expense projections on a monthly, quarterly, and annual basis.

Develop and manage Ryan White complex budgets within various cost categories. Develop and manage grant and department budgets. Attend grant meetings, submit initial grant budget and/or amended grand budgets. Conducts periodically scheduled grant accounting for various divisions. Prepares expense spreadsheets, comparing grant expense to the annual budget, and prepares grant-related financial reports.

Attend Ryan White grant meetings and, based on programmatic changes, submit initial grant submission budget and/or amend budgets. Provide programmatic and technical support to the RW Program Manger to determine service outcome measures. Develops a working relationship with the RW Program Manager and provides month end accounting reports to the Manager for each grant and program and review with the Manager.

Process Ryan White grant allocation and expense reports using excel spreadsheets. These reports serve as a reference to determine how grant recipients allocate and subsequently expend funds in each budget period. Also participates in Ryan White grant reporting, including monthly, quarterly, and annual reports for funders as requested.

Participate in the Ryan White site visit audits every year to answer questions from review