Senior Financial Analyst - Multiple Positions

About Us

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.
  
  

What You'll Do

• 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.
  
  

Additional Duties

• Performs other related accounting duties.
• Provides technical assistance & guidance on fiscal matters to ODH program consultants, subrecipients & ODH staff (e.g., ensures understanding & adherence to federal, state & ODH rules & guidelines, provides direction on correct preparation of budgets, interpretation of OGAPP policy, proper submission & completion of required fiscal documents).
• Uses proper business English & grammar when creating reports, letters, emails.
• As directed works with supervisor to retrieves financial information from resources (e.g., GMIS, OAKS, BI) & may or may not assist supervisor in providing projections for the annual budget.
• Trains agency staff on fiscal policies & procedures as instructed (e.g., FFR, GMIS training & presentations to subrecipients & ODH staff).
• Verifies &/or provides coding on returned monies for deposits, grants, subrecipient; as directed may or may not reconciles federal revenues processed through the ODH revenue processing system with the federal revenues deposited into the State Treasury on a daily basis.
• As directed may or may not work with supervisor to ensure all departmental monies have been accounted for; prepares adjustments for prior year expenditures.
• Reviews revenue report daily to ensure that federal monies are posted correctly; as directed may or may not act as backup for the printing of the daily Vital Chek® warrant.
• As assigned, serves as a member of a disaster recovery/business resumption team, incident response team, or similar public health response team which may include the conduct of operations on a 24/7 basis at remote locations & other duties as assigned.
  
  

Selection Process

Positions are filled through a two-part assessment process, which consist of a test and structured interview. Applicants in this pool must pass the test and interview to be eligible for selection. Selection will be based on the most qualified applicant, using qualifications, experience, and education (QEE). Where applicants are substantially equal, seniority shall be the determining factor.

Qualifications

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.
  
  

Job Skills: Accounting and Finance

Technical Skills: Clerical & Data Entry, Basic Documentation

Professional Skills: Analyzation, Attention to Detail, Problem Solving

Organization

Health

Agency Contact Name and Information

HR will contact applicants selected to interview

Unposting Date

Ongoing

Work Location

Health Department Building

Primary Location

United States of America-OHIO-Franklin County-Columbus

Compensation

29.23

Schedule

Full-time

Work Hours

8AM-5PM, Mon-Fri

Classified Indicator

Classified

Union

OCSEA

Primary Job Skill

Accounting and Finance

Technical Skills

Basic Documentation, Accounting and Finance, Clerical & Data Entry

Professional Skills

Analyzation, Attention to Detail, Problem Solving

Agency Overview

This is a reposting. Please reapply to this new posting for consideration of position(s).

Our mission at the Ohio Department of Health (ODH) is “advancing the health and well-being of all Ohioans”. Our agency is committed to building a modern, vibrant public health system that creates the conditions where all Ohioans flourish