The Finance & Business Analytics Intern will gain hands-on experience supporting Finance, Accounting, FP&A, Costing, and Demand Planning through data analysis, process improvement, and report development. This role provides an opportunity to apply classroom knowledge to real-world business challenges using Microsoft Dynamics 365, OneStream, Power BI, and Excel. Working across teams, the intern will help improve processes, strengthen reporting, and turn data into meaningful insights that support business decisions.
- This position is designed and intended to be performed in Muscatine, Iowa.
PRIMARY DUTIES & RESPONSIBILITIES:
- Analyze the end-to-end customer short-pay process and recommend improvements from shipment through deduction resolution.
- Assist in designing a Dynamics 365 accounting process to recognize estimated short pays at shipment, subject to Finance and Accounting review and approval.
- Streamline short-pay intake, coding, research, approval, clearing, and root-cause reporting to reduce fines, fees, and avoidable deductions.
- Enhance the trade-spend calendar and support analytics used for accruals, forecasting, promotional planning, and accountability for controllable spending.
- Partner with Cost Accounting to prepare standard-cost roll forwards, analyze cost changes, validate inputs, and document results.
- Support annual budgeting and periodic forecasting by preparing templates, validating data, analyzing variances, and consolidating submissions.
- Build and refine OneStream financial reports, dashboards, and management views that improve access to timely and actionable information.
- Develop Power BI reports and visualizations using governed data sources, clear definitions, and appropriate validation controls.
- Assist Demand Planning with reporting, forecast-accuracy analysis, exception reporting, and data preparation for planning discussions.
- Perform ad hoc financial and operational analysis, including profitability, working capital, inventory, SG&A, and trend analysis.
- Document processes, data definitions, report logic, controls, and user instructions to support repeatable and sustainable solutions.
- Participate in cross-functional meetings, communicate findings, track action items, and present recommendations to Finance leadership.
- Protect confidential business and financial information and follow established data-governance, internal-control, and safety requirement
- Other duties as assigned.
EDUCATION, EXPERIENCE AND/OR QUALIFICATIONS:
- Currently enrolled in a bachelor's degree program in Business Analytics, Finance, Accounting, Economics, Information Systems, Data Analytics, or a related field.
- Coursework in analytics, statistics, accounting, finance, information systems, or database concepts preferred.
- Proficiency with Microsoft Excel, including formulas, pivot tables, charts, and data organization.
- Exposure to Power BI, ERP systems, databases, OneStream, or similar reporting and planning tools preferred.
- Strong analytical and problem-solving skills with the ability to turn data into meaningful business insights.
- Strong attention to detail, organization, and ability to manage multiple assignments and deadlines.
- Effective written and verbal communication skills with the ability to clearly document work and communicate findings.
- Ability to work collaboratively, maintain confidentiality, take initiative, and learn new systems and processes.
TRAVEL:
- Minimal travel is expected. Occasional local travel to nearby company locations or operating sites may be required.
Safety is a top priority at KENT WORLDWIDE. All employees are expected to follow safety protocols and procedures to maintain a safe working environment.