Business Systems Analyst Intern

Pepsi Bottling Ventures LLC; United States; On-site; USD 25,000 - 36,000; Full time

Job summary

Pepsi Bottling Ventures LLC is seeking a Business Systems Analyst Intern in Raleigh, NC. You will support the BI team by gathering requirements, developing dashboards, and documenting processes to drive business decisions. The role offers exposure to Power BI, Sigma, and data modeling in a fast-paced environment.

The internship is ideal for a curious student interested in leveraging data and technology to solve business challenges, with daily collaboration across stakeholders.

Qualifications

• Pursuing a relevant degree with interest in analytics and reporting.
• Strong analytical skills and ability to draw insights from data.
• Proficiency with Excel and pivot tables; familiarity with BI tools.

Responsibilities

• Gather requirements from business stakeholders and BI team.
• Build and maintain dashboards and reporting solutions.
• Support migration of reporting assets from Power BI to Sigma.
• Perform data modeling and analytics development for reporting needs.
• Document dashboards, processes, and rollout activities.
• Collaborate with cross-functional partners to ensure requirements are met.

Skills

Analytical skills

Excel

Power BI

Data visualization

Stakeholder communication

Education

Pursuing degree in Finance, Business, Data Analytics, Accounting

Tools

Sigma platform

Job description

Unbottle YOUR Potential at Pepsi Bottling Ventures! At Pepsi, we spread home-grown joy, in our special Pepsi Bottling Ventures way! Pepsi Bottling Ventures is the nation’s largest private bottler and distributor of Pepsi beverages. Pepsi Bottling Ventures is based in NC, SC, MD, & DE. Job Description Pepsi Bottling Ventures is seeking a Business Systems Analyst Intern to join our team in Raleigh, NC.

Business Systems Analyst Intern Role Overview

As a Business Systems Analyst Intern, you will support the Business Intelligence team by gathering requirements, developing dashboards and reporting solutions, analyzing data, and documenting processes that help drive business decisions and performance. This hands-on internship is ideal for a curious, analytical student interested in leveraging data and technology to solve business challenges.

Day-to-Day Responsibilities

• Participate in meetings with business stakeholders, Business Systems Analysts, data engineers, and BI team members to gather requirements and understand business challenges.
• Assist in identifying business needs and developing analytical solutions that support informed decision-making.
• Build, configure, enhance, and maintain dashboards and reporting solutions.
• Support the redesign and migration of existing reporting assets from Power BI to the Sigma platform.
• Perform data modeling and analytics development activities to support reporting and visualization needs.
• Customize curated datasets for analytical and operational reporting purposes.
• Leverage reporting, visualization, and AI-enabled tools to deliver meaningful business insights.
• Develop and maintain documentation for dashboards, reporting processes, requirements, and rollout activities.
• Identify opportunities for process improvements and support the implementation of recommended solutions.
• Collaborate with cross-functional partners to ensure reporting solutions meet business requirements and user expectations.

Required Qualifications

• Currently pursuing a degree in Finance, Business, Data Analytics, Accounting, or a related field.
• Open to students of all academic classifications (Freshman, Sophomore, Junior, and Senior).
• Strong analytical skills with the ability to interpret and draw insights from data.
• Proficiency with Microsoft Excel, including experience using pivot tables and working with large datasets.
• Demonstrated interest in business analysis, analytics, reporting, or data-driven decision-making.
• Strong problem-solving skills and attention to detail.
• Ability to communicate effectively with both technical and non-technical stakeholders.
• Curiosity, initiative, and a desire to learn new technologies and business processes.
• Must possess a valid driver’s license and have reliable transportation to support daily local travel to customer locations and company events.
• Experience with Power BI or other business intelligence and data visualization tools preferred.
• Exposure to data analytics, reporting, dashboard development, or data modeling concepts preferred.
• Familiarity with AI-enabled tools and an interest in leveraging technology to improve business outcomes preferred.
• Previous coursework or projects involving business analytics, finance, reporting, or data visualization preferred.

Compensation and Benefits

Starting hourly pay for this position is set based on location, confirmed job-related skills, experience, and education. Your recruiter will share more about the specific pay range for this position during the interview process.

Unfortunately, we will be unable to offer visa sponsorships to candidates.

Equal Opportunity Employment

EOE M/F/D/V Pepsi Bottling Ventures is an Equal Opportunity/Affirmative Action employer and will consider all qualified applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. All employment decisions are based on valid job-related requirements. If you are a qualified individual with a disability or a disabled veteran and are unable or limited in your ability to use or access our website, you may request a reasonable accommodation to express interest in a specific opening. You can request reasonable accommodation by calling 1-800-662-8792 or via e-mail at [e-mail].

Who We Are

We are jointly owned by Suntory and PepsiCo. Suntory is a family-owned business founded in Japan more than 125 years ago that is known globally for their beverages and innovative spirit. PepsiCo has a 125-year plus legacy as a global leader in convenient foods and beverages. We represent Suntory’s non-alcoholic beverage industry in the United States and have an 80-year plus legacy of providing PepsiCo products to the Carolinas and beyond.

What We Do

We make, sell, and distribute PepsiCo and other beverages. We do business in five states and sell PepsiCo beverages to most of the market in our geographic regions. We also develop our own line of beverages, producing and distributing a growing product line nationally.

What Makes Us Unique

We bring you the beverages you love. We bring PepsiCo’s beloved beverages and more to you and our customers. As a part of Suntory, we believe in dreaming big and boldly pursuing our dreams, growing for good, and giving back to society. We innovate to create new beverages, like our Nature’s Twist refreshing lemonade line, and we continuously expand our beverage portfolio to bring you and our customers joy.

What We Look for in Team Members

We value integrity, teamwork, accountability, creativity, and communication in all we do and expect the same from all team members.

Who We Are

We are jointly owned by Suntory and PepsiCo. Suntory is a family-owned business founded in Japan more than 125 years ago that is known globally for their beverages and innovative spirit. PepsiCo has a 125-year plus legacy as a global leader in convenient foods and beverages. We represent Suntory’s non-alcoholic beverage industry in the United States and have an 80-year plus legacy of providing PepsiCo products to the Carolinas and beyond.

What We Do

We make, sell, and distribute PepsiCo and other beverages. We do business in five states and sell PepsiCo beverages to most of the market in our geographic regions. We also develop our own line of beverages, producing and distributing a growing product line nationally.

What Makes Us Unique

We bring you the beverages you love. We bring PepsiCo’s beloved beverages and more to you and our customers. As a part of Suntory, we believe in dreaming big and boldly pursuing our dreams, growing for good, and giving back to society. We innovate to create new beverages, like our Nature’s Twist refreshing lemonade line, and we continuously expand our beverage portfolio to bring you and our customers joy.

What We Look for in Team Members

We value integrity, teamwork, accountability, creativity, and communication in all we do and expect the same from all team members.