Fiscal College Intern (PN 20036323)

Ohio Department of Developmental Disabilities; Columbus (OH); On-site; USD 28,000 - 33,000; Part time

Job summary

The Ohio Department of Developmental Disabilities is accepting applications for a College Intern in the Fiscal Administration Division. The role supports Medicaid cost reporting, interim rate calculations, and reconciliation tasks within Columbus locations.

Ideal candidates are enrolled in an accredited college, pursuing accounting/finance-related programs, with strong Excel and data-analysis skills. Part-time schedule with on-site work at the Columbus Developmental Center.

Qualifications

• Must be enrolled in an accredited college or university.
• Preferred Degree Programs include Accounting, Business Management, Public Management.
• Preferred Experience: Microsoft Office (emphasis on Excel) and data analysis.

Responsibilities

• Assists in the preparation of Medicaid Cost Reports.
• Works with Medicaid to calculate interim rates.
• Incorporates audit adjustments into cost reports and calculates final rates.
• Assist with developmental center cost report settlements.
• Works with Medicaid to negotiate final settlement.
• Uses MITS to pull monthly remittance advices.
• Submits Medicaid claims to MITS using Excel worksheets.
• Assists in review and analysis of fiscal records.
• Provides technical assistance with QuickBooks for internal funds/accounts.
• Assists in preparation and analysis of revenue and expenditure tracking.
• Assists in preparation and submission of state/federal fiscal reports.
• Establish deliverables.
• Reconciles QuickBooks balances to old ledgers (DCIMS/Excel).
• Prepares bank reconciliation reports between QuickBooks and bank statements.
• Uses OAKS BI reporting tools to generate balance and voucher/detail reports.
• Uses Excel functions to create reports and forecast expenditures, revenue, and cash.

Skills

Attention to Detail

Data Analysis

Analytical Thinking

Education

Accounting

Business Management

Public Management

Tools

Microsoft Office

Excel

Job description

Accepting applications for a College Intern in our Fiscal Administration Division The Ohio Department of Developmental Disabilities (DODD) mission is to partner with people and communities to support Ohioans with developmental disabilities and their families in realizing their version of a good life.

Ohio Is The Heart Of Opportunity, And We Envision Ohio As The Best Place In The Nation For People With Developmental Disabilities To Thrive. Our Core Values Reflect Our Focus On The Experience Of Each Person We Support

• Inclusion
• Partnership
• Respect

The Division of Human Resources provides quality services to attract, motivate, manage and retain a diverse and competent workforce. The division emphasizes customer service based on consultation and communication with the DODD workforce in order for the agency to more effectively carry out its mission and values.

What You'll Do

• Assists in the preparation of Medicaid Cost Reports
• Works with the Department of Medicaid to calculate interim rates
• Incorporates audit adjustments into the cost report, calculates final rates
• Assist with developmental center cost report settlements,
• Works with Department of Medicaid to negotiate final settlement
• Uses Medicaid Information Technology System (MITS) to pull monthly remittance advices
• Use the Excel work sheet to submit Medicaid claims to MITS to be processed for payment
• Assists supervisor in review and analysis of fiscal records
• Provides technical assistance in the use of QuickBooks with developmental center internal funds/accounts
• Assists in preparation and analysis of revenue and expenditure tracking for developmental center internal accounts
• Assists in preparation & submission of required state and/or federal fiscal reports
• Establish deliverables
• Reconcile QuickBooks balance to old ledgers (DCIMS/Excel),
• Prepare Bank reconciliation reports for various accounts between QuickBooks and Bank Statements
• Uses Ohio Administrative Knowledge System (OAKS) Business Intelligence reporting tools to generate & Balance reports (e.g., voucher detail, general ledger, encumbrance balance, revenue/cash balance, etc.)
• Uses Excel functions (e.g., logical lookup & reference, statistical & math functions) to create reports, track & forecast expenditures, revenue & cash.

Minimum Qualifications

• Must be enrolled in an accredited college or university.

Preferred Degree Programs

• Accounting
• Business Management
• Public Management

Preferred Experience

• Microsoft Office (emphasis on Excel)
• Data analysis

Organization

Developmental Disabilities - Central Office

Agency Contact Name and Information

Jacob Lowry - [e-mail]

Unposting Date

Ongoing

Work Location

Columbus Developmental Center

Primary Location

United States of America-OHIO-Franklin County-Columbus

Other Locations

United States of America-OHIO-Guernsey County-Cambridge

Compensation

$20.00 for undergrad, $24.00 for graduate students

Schedule

Part-time

Work Hours

M-F, Hours Will Vary

Classified Indicator

Unclassified

Union

Exempt from Union

Primary Job Skill

Internship

Technical Skills

Basic Documentation, Budgeting, Mathematical Ability, Accounting and Finance, Clerical & Data Entry, Records Management

Professional Skills

Analyzation, Attention to Detail, Interpreting Data