Fiscal College Intern (PN 20036323)

State of Ohio
  • Columbus, OH
    17 days ago

    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.

    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

    Numbers & Facts

    LocationColumbus, OH

    Skills

    • Accountingunmatched
    • Business Intelligence Softwareunmatched
    • Cost Reportingunmatched
    • Customer Support/Serviceunmatched
    • Data Analysisunmatched
    • Expense Analysisunmatched
    • Expense Trackingunmatched
    • Financial Analysisunmatched
    • Financial Reportingunmatched
    • General Ledger Accountingunmatched
    • Human Resourcesunmatched
    • Information Technology & Information Systemsunmatched
    • Intuit Quickbooksunmatched
    • Mathematicsunmatched
    • Medicaidunmatched
    • Microsoft Officeunmatched
    • Negotiation Skillsunmatched
    • Payment Processingunmatched
    • Reconciliationunmatched
    • Reporting Skillsunmatched
    • Revenue Analysisunmatched
    • Revenue Forecastingunmatched
    • Technical Supportunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder