Business Systems Analyst Intern

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 nations largest private bottler and distributor of Pepsi beverages. Pepsi Bottling Ventures is based in NC SC MD & DE.

APPLICATION INSTRUCTIONS:

CURRENT PBV EMPLOYEE please login to Workday to complete the job application. Please do not apply here apply internally through Workday.

If you are NOT a current employee please click Apply and complete job application.

Job Description

Pepsi Bottling Venturesis seeking a Business Systems Analyst Intern to join our team in Raleigh NC.

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 Suntorys 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 PepsiCos 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 Natures 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.

Wed love to receive your application and talk with you about your interest in the position if the overview below describes you.

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 drivers 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.

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- or via e-mail at

Required Experience:

Intern