Senior Financial Analyst - Multiple Positions

Columbus, OH

Executive, Legislative, and Other General Government Support

About the position

The Office of Financial Affairs assists in the establishment of Ohio Department Health's (ODH) long and short-range fiscal goals and objectives. The office provides the agency with the overall fiscal administration support through its various unit operations including accounting, purchasing, budgeting and grants administration. The office oversees the department's Compliance and Accountability Unit and biennial budget process; provides technical assistance to agency decision-makers and provides daily monitoring and analysis of agency spending trends. Applicants that apply to this posting will be assigned to one of the Office of Financial Affairs teams. * Cash Management Team: processes all federal revenue for the department and administers the fiscal aspects and/or budgetary activities of the department's federal grants. Cash Management plans and manages all federal cash draws, refunds, and reconciliations to ensure accountability of all funds. Federal payment requests of all funds are also made via the multiple federal systems. * Grant Financial Reporting Team: oversees the administration of federal grants from point of application to close-out. This includes coordinating internal sign-offs, processing carry-forward requests, completing periodic grant expenditure reports to the federal agency, and monitoring expenditures & processing grant adjustments to correct reporting expenditures. During audits of federal grants, acts a liaison to state and federal auditors. * Grants Subgrant Team: oversees the (sub-recipient) grant process (through GMIS) that awards funds to entities for providing services at the local level. This process includes posting & reviewing applications; reviewing budgets; monitoring expenditures; processing quarterly payments; closing-out grants; and establishing purchase orders. * Accounts Payable (AP): receives and forwards supplier invoices to program staff for review and payment approval and sends approved invoices and supporting documentation to OSS for vouchering in OAKS. Provides AP technical assistance to suppliers, staff, OBM and OSS to resolve payment issues. This unit also processes Intrastate Transfer Vouchers (ISTV's) and EDI invoices in OAKS and mails warrants returned to agency for additional processing.

Responsibilities

• Coordinates, monitors & administers fiscal aspects of assigned duties & independently prepares & analyzes a variety of financial statements.
• Independently researches, analyzes &/or reconciles various revenue/expenditure reports & monitors grant account balances to ensure availability of funding by revenue sources & that funds/grants have been appropriately charged.
• Prepares financial statements & accounting reports (e.g. 272 Federal Quarterly Cash Report, daily cash reports, vouchers & payroll payables, revenue deposits, drawdowns, Federal Financial Reports (FFR), annual Schedule of Expenditures of Federal Awards, Business Intelligence (BI) reports).
• Completes the Personnel Review Process for cost variances when compared to prior reported cost (increased/decreased personnel cost); analyze awards &/or contracts involving departmental revenues & expenditures (e.g., interagency agreements, grants, federal &/or other funding) to establish revenue & expenditure projection schedules.
• Research revenue &/or disbursement problems/issues for internal/external customers via phone, email & in person utilizing various software applications (e.g., Grants Management Information Systems [GMIS], Word, Excel, Ohio Administrative Knowledge System [OAKS] & other related agency-specific software).
• Interpret Ohio Department of Health (ODH) policies & procedures (e.g., state & federal regulations, Ohio Grants Administrative Policies & Procedures (OGAPP), Generally Accepted Principles & Practices (GAPP), Cash Management Improvement Act) to determine allowable expenditures & activities.
• Utilizes OAKS to reconcile grant database to department's internal system with relation to all grant awards, revenue & expenditures/disbursements; reviews & documents receipt of Notice of Grant Award (NGAs) & subrecipient; analyzes & prepares various accounting adjustments (e.g., spreadsheet journals, journal vouchers, book adjustments).
• Ensures established documents processing policies & procedures are followed to maintain accounting controls & systems (e.g., proper form usage, proper approvals in place before further processing, proper files maintained for reference & audit purposes).
• Researches & gathers data for development of grant documentation with historical information; verifies, processes, & may or may not prepare required federal/state financial reports (e.g., 269's, 272's, 435's, audit confirmation request, petty cash revenue audit) & contract billings.
• Analyzes OAKS revenue reports for assigned grant accounts to ensure revenue is deposited in the correct account & that unused federal funds are returned to reconcile any discrepancies in a grant (e.g., grant history, request to return monies &/or process request for invoice).
• Provides technical assistance via phone, computer & in person (e.g., training/work direction, contract clarification, cost allocation, budgeting & report preparation, grant special conditions, determines appropriateness of expenditures & activities).
• Acts as a liaison between the department & representatives of various federal &/or subrecipient agencies & interacts with various department personnel.
• As directed assists supervisor in updating & recommending changes in fiscal policies &/or procedures for OFA, ODH staff &/or external entities & provides guidance & training on fiscal requirements (e.g., writes & updates desk procedures); as directed may or may not approves subrecipient applications submitted for multiple ODH programs & establishes any necessary special conditions to grant applications.

Requirements

• 42 mos. exp. or 42 mos. trg. in accounting &/or finance to include an advanced level of experience in spreadsheet software.
• Or completion of undergraduate core program in business administration, accounting, finance or related field; 18 mos. exp. or 18 mos. trg. in accounting &/or finance to include an advanced level of experience in spreadsheet software.
• Or completion of graduate core program in business administration, accounting, finance or related field; 6 mos. exp. or 6 mos. trg. in accounting &/or finance to include an advanced level of experience in spreadsheet software.
• Or 12 mos. exp. as Financial Analyst, 66562.
• Or equivalent of Minimum Class Qualifications for Employment noted above. NOTE: Successful completion of the Fiscal Academy may be substituted for 4 mos. of required accounting/fiscal experience referenced in this portion of the minimum qualifications.