Finance Intern: Analytics, FP&A & Dashboards

Kent Consumer Brands Americas, LLC; Muscatine (IA); On-site; USD 25,000 - 39,000; Full time

Job summary

Kent Consumer Brands Americas, LLC is offering a Finance & Business Analytics Intern position in Muscatine, IA. The role focuses on data analysis, process improvement, and report development across Finance, Accounting, FP&A, Costing, and Demand Planning using Dynamics 365, OneStream, Power BI, and Excel.

The internship provides exposure to budgeting, forecasting, and management reporting, with opportunities to turn data into actionable insights and support business decisions.

Qualifications

• Pursuing a bachelor’s degree in a relevant field.
• Proficiency with Microsoft Excel and data organization.
• Exposure to Power BI, ERP systems, OneStream, or similar reporting tools preferred.
• Strong analytical and problem-solving skills with attention to detail.
• Effective written and verbal communication skills.

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.

Skills

Analytical thinking

Problem solving

Attention to detail

Communication

Multitasking

Education

Bachelor's degree in Business Analytics, Finance, Accounting, Economics, Information Systems, Data Analytics

Coursework in analytics, statistics, accounting, finance, information systems, or database concepts

Tools

Power BI

OneStream

Excel

ERP systems

Job description

Kent Consumer Brands Americas, LLC is offering a Finance & Business Analytics Intern position in Muscatine, IA. The role focuses on data analysis, process improvement, and report development across Finance, Accounting, FP&A, Costing, and Demand Planning using Dynamics 365, OneStream, Power BI, and Excel.

The internship provides exposure to budgeting, forecasting, and management reporting, with opportunities to turn data into actionable insights and support business decisions.