Finance & Analytics Intern — Power BI, OneStream & Excel

KENT WORLDWIDE

Muscatine (IA)

On-site

USD 25,000 - 36,000

Full time

2 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

KENT WORLDWIDE is seeking a Finance & Business Analytics Intern to support Finance, Accounting, FP&A, Costing, and Demand Planning through data analysis, reporting, and process improvements in Muscatine, Iowa. You will gain hands‑on experience with Dynamics 365, OneStream, Power BI, and Excel while collaborating across teams to turn data into actionable insights for business decisions.

Responsibilities include building dashboards, improving short-pay processes, budgeting support, and

Qualifications

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.

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.