Senior Budget Analyst Position
Primary Location: United States of America-OHIO-Franklin County
Work Locations: Columbus Dev Ctr Admin Bldg 1810 Sullivant Avenue Columbus 43222
Organization: Developmental Disabilities - Central Office
Classified Indicator: Classified
Bargaining Unit / Exempt: Bargaining Unit
Schedule: Full-time
Work Hours: 8:00am - 5:00pm
Compensation: $28.80 per hour
Unposting Date: Jan 13, 2022, 11:59:00 PM
Job Function: Accounting and Finance
Agency Contact Name: Ohio Department of Developmental Disabilities/Division of Human Resources
Agency Contact Information: (614) 466-2508
Senior Budget Analyst (PN 20036272)
(210009W3)
Description
Remote Work Available
Researches, analyzes, projects/formulates, adjusts & monitors allocations (e.g., spending patterns, fund distribution, chart of accounts, cost allocations, forecasting, etc.) in the Department of Developmental Disabilities’ (DODD) Division of Fiscal Administration, Office of Budget Services: Researches, generates reports, & consults with subject matter staff to determine Medicaid program estimates for projecting costs; updates chart of accounts (e.g., annual & biennial budget projection, updates speed charts,); forecasts, based upon quantitative analysis & research, DODD & Medicaid expenditures & revenue, appropriation, allotment & allocation, & cash balances for all funding sources; reviews past, current & existing budget & spending to conduct cost benefit analysis; reviews spending patterns to prevent deficits & recommends approval/disapproval of proposed expenditures &/or budget revisions; recommends possible solutions where needed; reviews projections & forecasts revenue patterns; generates various reports (Business Intelligence, Ohio Administrative Knowledge System) to monitor results of expenditures & revenue; performs variance analysis; uses computer to create various reports & analyses (e.g., expenditure/cost projections &/or other statistical/quantitative analyses) & updates file information.
Prepares payroll projections, variance analysis & prepares financial reports, etc.; projects & monitors expenditure levels of Medicaid waiver programs for specific county board providers; completes federal reports of estimated &/or actual expenditures; advises Department of Medicaid, Job & Family Services & County Boards of DD program staff concerning fiscal matters (e.g., explains state, federal &/or departmental policies & procedures), assists in developing DODD’s biennium & internal annual budgets; evaluates & monitors budget implementation to include reporting to chain of command; projects & forecasts revenues using appropriate statistical analysis; automates & evaluates worksheets for efficiency to aide users in gaining accurate & useful information regarding spending & revenues; prepares reconciliations (e.g., reconciliations for Medicaid payments to OAKS, General Ledger to subsidiary Ledgers, etc.); keeps cash balance projections up to date; codes expenditures paid by Developmental Centers (DCs) &/or Central Office (e.g., Waivers, ICF); monitors DCs spending for accuracy of coding; performs fiscal analysis; responds to requests for information.
Develops, tracks & prepares financial analysis of proposed legislation or policy change; prepares controlling board requests; respond to audit findings & requests for information from various sources (e.g., divisions, other state/county or federal agencies, etc.); designs & develops procedures/guidelines to ensure compliance; completes special reports as assigned by Fiscal Office & Budget staff, evaluates &/or participates in evaluation of budget operations (e.g., determine improvements, edits & changes required); assists in responding to audit findings to achieve compliance; participates on budget team/group to bring about change & efficiencies for customers & to research & analyze data, trends or legislative/rule changes; prepares &/or reviews projection/forecast models for special projects &/or program areas with multiple funding sources; prepares periodic financial reports, position/option papers related to analysis; uses Excel functions (e.g., logical, lookup & reference, statistical & math functions) to create reports, projections, & analysis (cost benefit, What-If), track & forecast expenditures, revenue & cash; responds to questions from DODD staff; attends meetings with DODD/DC staff & training sessions offered by other state agencies; completes other duties as assigned within scope of position.
Qualifications
Completion of graduate core program in accounting, public finance, public administration or business administration; 12 mos. exp. in fiscal management & control involving use of quantitative/statistical analysis (e.g., probability statistics, linear regression, multiple variable regression, computer regression analysis models, trend analysis, forecasting cost benefit analysis).
-Or completion of undergraduate core program in accounting, public finance, public administration or business
administration; 24 mos. exp. in fiscal management & control involving use of quantitative/statistical analysis (e.g.,
probability statistics, linear regression, multiple variable regression, computer assisted regression analysis models, trend
analysis, forecasting cost benefit analysis).
-Or 12 mos. exp. as Budget Analyst, 63261.
-Or 4 yrs. experience in budgeting that included fiscal management & control involving use of quantitative/statistical analysis (e.g., probability statistics, linear regression, multiple variable regression, computer assisted regression analysis models, trend analysis, forecasting cost benefit analysis).
-Or equivalent of Minimum Class Qualifications for Employment noted above.
Knowledge of accounting; quantitative/statistical analysis; budgeting; public or business administration or public finance; agency policies & procedures*; federal &/or state statutes governing budgeting & fiscal management*; ERP systems* (e.g., OAKS FIN) &/or federal accounting system*. Skill in operation of electronic devices (e.g., computer, tablet, cell phone) & applicable software applications (e.g., spreadsheets, databases, word processing); OAKS BI reporting*. Ability to apply quantitative/statistical analysis & methods (e.g., forecasting, cost/benefit analysis) to determine available funding & project overages & shortages in appropriations & compare actual expenditures against estimated expenditures; use proper research methods in gathering data; gather, collate & classify information about data, people or things; research & interpret historical data in terms of fiscal, programmatic, social, political &/or economic trends; deal with many variables & recommend resolutions; prepare comprehensive reports containing analysis; evaluate financial impact of state/federal policy changes on programs; handle general & sensitive inquiries from governmental employees/officials, representatives of recipient organizations &/or general public.
(*)Developed after employment
Supplemental Information:
Current Department of Developmental Disabilities OCSEA employees shall receive first consideration pursuant to Article 17 of the collective bargaining agreement.
Hourly wage will be paid at step 1, unless otherwise specified by collective bargaining agreement or rules outlined in the ORC/OAC.
No additional materials will be accepted after the closing date; in addition, you must clearly demonstrate how you meet minimum qualifications.
DODD is an affirmative action and equal opportunity employer. To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform job functions, unless such accommodation would cause an undue hardship.
Background Check Information
The final candidate selected for the position will be required to undergo a criminal background check. Rule 5123-2-02, “Background Investigations for Employment,” outlines disqualifying offenses that will preclude an applicant from being employed by the Department of Developmental Disabilities.