Finance & Analytics Intern: Build Insights & Planning Dashboards

Kent; Muscatine (IA); On-site; USD 21,000 - 30,000; Full time

Job summary

Kent is seeking a Finance & Business Analytics Intern in Muscatine, Iowa, to gain hands-on experience across Finance, Accounting, FP&A, Costing and Demand Planning using Dynamics 365, OneStream, Power BI and Excel.

You will analyze processes, design accounting steps, and build dashboards and reports to turn data into insights that support business decisions, while collaborating across teams and learning governance and controls.

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.

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 requirements.
• Other duties as assigned.

Skills

Analytical thinking

Attention to detail

Communication

Team collaboration

Education

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

Tools

Power BI

Excel

OneStream

Dynamics 365

ERP systems

Job description

Kent is seeking a Finance & Business Analytics Intern in Muscatine, Iowa, to gain hands-on experience across Finance, Accounting, FP&A, Costing and Demand Planning using Dynamics 365, OneStream, Power BI and Excel.

You will analyze processes, design accounting steps, and build dashboards and reports to turn data into insights that support business decisions, while collaborating across teams and learning governance and controls.