Senior Financial Analyst

• This position is hybrid eligible under the current DAS teleworking agreement

About Us:

Led by Director Kathleen C. Madden, the Ohio Department of Administrative Services is the engine of state government, providing innovative solutions and supporting the efficient operation of state agencies, boards and commissions.

The Administrative Services Division, Office of Finance team is seeking a Senior Financial Analyst to join their team!

What You'll Do:

Independently research & analyze complex service and billing information to prepare invoices.

• Independently resolve errors, modify data &/or determine appropriate action. Researches and analyzes customer usage and utilization based on multiple sources & compiles it in consumable format

• Create invoice files and upload files to be interfaced into the Ohio Administrative Knowledge System (OAKS)

• Confirm appropriate authority to invoice prior to issuing bills (e.g., Ohio Revised Code/Ohio Administrative Code, OBM rate approval memo, contracts, MOUs, etc.)

• Independently manage timely collection and validate of consumption data from program offices

• Work with program areas to resolve data issues if discrepancies are identified. Ensure data is accurate prior to invoicing

• Perform final verification of invoicing files prior to upload to OAKS. Monitor posted invoices to validate successful billings

• Resolve errors by issuing credits and/or adjusted billings

• Verify that the adjustments properly reflect the intended out- comes in OAKS.

• Utilize data from multiple sources to create reports/ presentations for stakeholders.

• Monitor billing data and cycles to ensure accurate billing and timeliness of invoices.

• Ensure billings are occurring on schedule by tracking all types of billings, their associated cycles, and activity.

• Be mindful of Generally Accepted Accounting Principles (GAAP), Statewide Cost Allocation Plan (SWCAP), and other governing principles and/or regulations

Create trend reports to analyze and verify billing data which may require creation of complex Excel spreadsheets using formulas, pivot tables, logical Excel statements, graphs, conditional formatting and other Excel functions. Create ad-hoc reporting.

Liaison with customers (e.g., state agencies, board & commissions, & local government entities) to troubleshoot any financial issues

• Accurately communicate and inform customers of approved billing methodologies, rates, or other information to keep customers informed. Research customer discrepancies/complaints using multiple financial systems including OAKS and program specific source systems

• Escalate to supervisor as needed

Perform other related duties as required

• Provides ongoing training, formally and informally, to external and internal customers

• Meet with program areas to suggest process improvement, review current practices, or other action items as necessary

What's in it for you:

At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full-time and part-time employees. For a list of all the State of Ohio Benefits, visit our Total Rewards website! Our benefits package includes:

Medical Coverage

• Quality, affordable, and competitive medical benefits are offered through the available Ohio Med plans.

Dental, Vision and Basic Life Insurance

• Dental, vision, and basic life insurance premiums are free after completed eligibility period. Length of eligibility period is dependent on union representation.

Time Away From Work and Work/Life Balance

• Paid time off, including vacation, personal, and sick leave

• 11 paid holidays per year

• Childbirth/Adoption leave

Employee Development Funds

• The State of Ohio offers a variety of educational and professional development funding that varies based on whether you are a union-exempt employee or a union-represented employee.

Ohio Public Employees Retirement System

• OPERS is the retirement system for State of Ohio employees. The employee contributes 10% of their salary towards their retirement. The employer contributes an amount equal to 14% of the employee's salary. Visit the OPERS website for more information.

Deferred Compensation

• The Ohio Deferred Compensation program is a 457(b) voluntary retirement savings plan. Visit the Ohio Deferred Compensation website for more information.

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

Knowledge, Skills, and Abilities

Knowledge

• Business Administration*;

• Laws, rules & regulations relating to purchasing (e.g., Ohio Revised Code & Ohio Administrative Code)*;

• Generally accepted accounting principles;

• Human relations

• Standardized financial reporting;

• OAKS Financial module

Skill

• Operation of personal computer & associated hardware/software (e.g., MS Word, Excel, Outlook, Cognos, OAKS, Service Now, other billing systems)

Abilities

• Read, comprehend & record figures accurately

• Use proper research methods to gather, collect, and interpret data to draw valid conclusions;

• Interpret complex information with a large number of fiscal variables and determine specific course of action

• Prepare meaningful, concise, accurate, complex reports;

• Work independently on most tasks or work with coworkers on group projects

• Communicate effectively in written & oral form

• Develop and maintain good rapport with customers

• Developed after employment

Job Skills: Accounting and Finance, Research, Records management, Verbal communication, Interpreting data