BI & Analytics Intern: Dashboards & Data Insights

Pepsi Bottling Ventures; Raleigh, Northern (NC, KY); Hybrid; USD 25,000 - 34,000; Part time

Job summary

Pepsi Bottling Ventures in Raleigh, NC is seeking a Business Systems Analyst Intern to join our BI team. The role focuses on gathering requirements, building dashboards, and delivering reporting solutions to support business decisions.

You will analyze data, document processes, and assist in migrating reporting assets from Power BI to Sigma, while collaborating with stakeholders across functions. This hands-on internship offers exposure to analytics, data modeling, and operational insights.

Qualifications

• Pursuing degree in Finance, Business, Data Analytics, or Accounting.
• Open to students of all academic classifications.
• Strong analytical skills to interpret data and draw insights.
• Proficiency with Microsoft Excel including pivot tables and large datasets.
• Interest in business analytics, reporting, or data-driven decision-making.
• Excellent problem-solving and attention to detail.
• Effective communication with technical and non-technical stakeholders.
• Curiosity, initiative, and willingness to learn new technologies.
• Must possess a valid driver's license and reliable transportation for local travel.
• Experience with Power BI or BI tools preferred.
• Exposure to data analytics, reporting, dashboard development, or data modeling preferred.
• Previous coursework or projects in business analytics, finance, reporting, or data visualization preferred.

Responsibilities

• Gather requirements from business stakeholders, BI team, data engineers.
• Develop dashboards and reporting solutions.
• Analyze data and document processes.
• Support migration of reporting assets from Power BI to Sigma.
• Model data and develop analytics for reporting needs.
• Create curated datasets for analytics and operations.
• Leverage BI tools to deliver business insights.
• Collaborate with cross-functional partners to ensure requirements are met.

Skills

Analytical thinking

Pivot tables

Stakeholder communication

Curiosity

Education

Finance degree

Data analytics

Accounting degree

Tools

Power BI

Excel

Job description

Pepsi Bottling Ventures in Raleigh, NC is seeking a Business Systems Analyst Intern to join our BI team. The role focuses on gathering requirements, building dashboards, and delivering reporting solutions to support business decisions.

You will analyze data, document processes, and assist in migrating reporting assets from Power BI to Sigma, while collaborating with stakeholders across functions. This hands-on internship offers exposure to analytics, data modeling, and operational insights.