Finance Intern: Build Budgets, Forecast & Insights

Pepsi Bottling Ventures LLC; Lincoln (NE); On-site; USD 21,000 - 30,000; Part time

Job summary

Pepsi Bottling Ventures is seeking a Financial Analyst Intern to join our Finance team in Raleigh, NC. This role provides hands-on experience in budgeting, forecasting, reporting, and financial analysis within a manufacturing and distribution environment.

You will support month-end close, develop dashboards, and assist in preparing management reports for business leaders. The internship emphasizes collaboration, data-driven insights, and professional growth in a dynamic setting.

Qualifications

• Currently pursuing a bachelor’s degree in Finance, Accounting, Economics, Business Administration, Data Analytics, or a related field.
• Strong analytical skills and comfort working with numbers, data, and financial information.
• Proficiency with Microsoft Excel; experience with formulas, pivot tables, and data analysis preferred.
• Proficiency with creating dashboards and business intelligence tools
• Strong attention to detail, organization, and follow-through.
• Ability to manage multiple priorities and meet deadlines in a fast-paced environment.
• Effective written and verbal communication skills.
• Curiosity, initiative, professionalism, and a collaborative mindset.

Responsibilities

• Assist with the preparation of recurring financial reports, dashboards, and performance summaries for Finance and business leaders.
• Support budgeting and forecasting processes by gathering data, updating financial models, and tracking performance against plan.
• Analyze financial and operational results to identify trends, variances, risks, and opportunities.
• Help prepare variance analysis and commentary for monthly close, forecast updates, and management reporting.
• Partner with Finance team members to collect, validate, and organize data from multiple sources.
• Support ad hoc analyses related to revenue, expenses, profitability, capital spending, productivity, or other business priorities.
• Assist in improving reporting templates, processes, and data visualization tools.
• Prepare clear, concise presentations and summaries that communicate findings to stakeholders.

Skills

Analytical skills

Data analysis

Dashboards

Communication

Multi-tasking

Education

Pursuing bachelor’s degree in Finance, Accounting, Economics, Business Administration, Data Analytics

Tools

Excel

Power BI

Job description

Pepsi Bottling Ventures is seeking a Financial Analyst Intern to join our Finance team in Raleigh, NC. This role provides hands-on experience in budgeting, forecasting, reporting, and financial analysis within a manufacturing and distribution environment.

You will support month-end close, develop dashboards, and assist in preparing management reports for business leaders. The internship emphasizes collaboration, data-driven insights, and professional growth in a dynamic setting.