Business Systems Analyst Intern

Suntory; Raleigh (NC); On-site; USD 28,000 - 41,000; Part time

Job summary

Pepsi Bottling Ventures is seeking a Business Systems Analyst Intern to join our team in Raleigh, NC. The role supports the Business Intelligence team by gathering requirements and developing dashboards to drive business performance.

This hands-on internship is ideal for a curious, analytical student interested in leveraging data and technology to solve business challenges and improve reporting capabilities across the organization.

Qualifications

• Strong analytical skills and ability to draw insights from data.
• Proficiency with Microsoft Excel, including pivot tables and large datasets.
• Experience with Power BI or similar BI tools preferred.
• Exposure to data analytics, reporting, dashboard development, or data modeling concepts preferred.

Responsibilities

• Gather requirements from business stakeholders and document them.
• Develop dashboards and reporting solutions to support decision-making.
• Build, configure, and maintain dashboards and reporting assets.
• Assist in migrating reporting assets from Power BI to the Sigma platform.
• Model data and perform analytics to support reporting needs.
• Create and maintain documentation for dashboards and processes.
• Collaborate with cross-functional teams to ensure reporting meets requirements.

Skills

Analytical skills

Excel (Pivot Tables)

Power BI experience

Business analytics interest

Education

Pursuing degree in Finance, Business, Data Analytics, Accounting, or related field

Tools

Power BI

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

We’d 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 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.

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]