Fiscal College Intern (PN 20036323)

State of Ohio; Columbus (OH); On-site; USD 17,000 - 25,000; Part time

Benefits offered by this job

Medical Coverage

Paid time off

Education and Development Funds

Job summary

State of Ohio's Developmental Disabilities - Central Office is seeking a Part-time Fiscal College Intern to support Medicaid cost reporting and financial analysis. The role offers exposure to cost reports, rate calculations, and reconciliation tasks within the Fiscal Administration Division of the Ohio Department of Developmental Disabilities.

The intern will work with Medicaid, use MITS, QuickBooks, and Excel to assist in data preparation, reporting, and financial tracking, while developing

Qualifications

• Must be enrolled in an accredited college or university.
• Preferred degree paths include Accounting, Business Management, and Public Management.

Responsibilities

• Assist in the preparation of Medicaid Cost Reports.
• Work with Medicaid to calculate interim rates.
• Incorporate audit adjustments into cost reports and calculate final rates.
• Assist with developmental center cost report settlements.
• Assist in preparation and analysis of revenue and expenditure tracking for developmental center internal accounts.
• Prepare bank reconciliation reports and use MITS for remittance details.

Skills

Basic Documentation

Budgeting

Mathematical Ability

Accounting and Finance

Clerical & Data Entry

Records Management

Analyzation

Attention to Detail

Interpreting Data

Education

Accounting

Business Management

Public Management

Tools

Excel

MITS

QuickBooks

OAKS BI

DCIMS/Excel

Job description

Job Description - Fiscal College Intern (PN 20036323) (2600063U)

Fiscal College Intern (PN 20036323) ( 2600063U )

Organization

Developmental Disabilities - Central Office

Agency Contact Name and Information : Jacob Lowry - [e-mail]

Schedule

Part-time

Work Hours : M-F, Hours Will Vary

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

Unposting Date

Ongoing

Work Location

Columbus Developmental Center 1601 West Broad Street Columbus 43222-1087

Primary Location

United States of America-OHIO-Franklin County-Columbus

Other Locations

United States of America-OHIO-Guernsey County-Cambridge

Agency Overview Job Description

Join Our Team!

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

Why Work for the State of Ohio

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
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period .
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems ( such as OPERS, STRS, SERS, and HPRS ) &Optional Deferred Compensation ( Ohio Deferred Compensation )

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Qualifications

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

Supplemental Information

No additional materials will be accepted after the closing date; in addition, you must clearly demonstrate how you meet minimum qualifications.

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.

Ohio is a Disability Inclusion State and strives to be a Model Employer of Individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws. To request a reasonable accommodation due to disability, please contact the ADA Coordinator by email at [e-mail].

Drug-Free Workplace

The State of Ohio is a drug free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39), and as outlined in the posting.