Senior Financial Analyst

Schedule: Full-time

Works under general direction of Department of Administrative Ser-vices (DAS), Administrative Support Division (ASD), Office of Finance, Billing & Cash Management Unit to examine &/or analyze ac-counting records, financial statements, or other financial reports to assess accuracy, completeness & conformance to reporting & procedural standards: ·

Prepares daily cash analysis and monitors balances.

Researches and analyzes customer usage and utilization based on multiple sources & compiles it in consumable format; create reports and presentations for stakeholders.

Creates and reviews consumption files to be interfaced into the Ohio Administrative Knowledge System (OAKS).

Independently manages timely collection and validation of consumption data from program offices.

Independently resolves errors, modify data &/or determines appropriate action. Work with program offices to resolve data is-sues if discrepancies are found; Creates credits or adjusted billings and maintains audit trail.

Utilizes BI reports to analyze open receivables by customer, and assists in reviewing open receivable items.

Tracks progress on accounts by entering conversation notes via OAKS and other systems; enters dispute flags on invoices from customer communication.

Processes mail delivery, codes checks, and monitors deposits on a daily basis & makes inquiries in various databases and applications (Ohi-oBuys, KeyNavigator, Salesforce, CBOSS, OAKS).

Prepare checks received in-house for submission to KeyBank Lockbox for processing.

Makes sure checks are completed accurately (e.g., signed not post-dated, numeric amount equals written amount, payee is correct, check is not expired, check has been endorsed for de-posit); contact customers regarding returned checks.

Determines nature of receipt & selects appropriate customer code & speed chart for applying receipt in OAKS.

Monitors KeyBank Lockbox daily and prepares deposit pack-ages to Cash Management Supervisor for approval; reconcile deposits in OAKS.

Updates chart field coding for established speed charts & rea-son codes & creates new reason codes in OAKS as directed by supervisor.

Monitors revenue share payments in OhioBuys application.

Processes source deposits, as needed, including deposit modifications, payroll check-off deposits bi-weekly, electronic fund transfers, & credit card payments from CBOSS system.

Processes monthly aging statements for distribution to customers; Creates and maintains customer records in OAKS.

Requests warrants for refunds.

Prepares reconciliations between source systems, participates in audit request documentation and SWCAP reviews.

Creates surplus refunds via SalesForce by compiling coding from various agencies.

Create trend reports to analyze and verify data which may require creation of complex Excel spreadsheets using formulas, pivot tables, logical Excel statements, graphs, conditional formatting and other Excel functions. Responds to a variety of customer questions regarding approved billing methodologies, rates, open receivables and disputes; responds to invoice receipt, confirm payment application, services provided via email, ServiceNow tickets, messaging and phone calls); escalates delinquent accounts to supervisor when necessary.

Performs other related duties as assigned:

Performs variety of clerical & fiscal tasks to facilitate operations efficiency.

Attends meetings & training in area of responsibility.

Provides weekly & monthly status reports for management.

Provides assistance with special Office of Finance projects as assigned by supervisor.

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