Data Architect

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.

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 Ventures is seeking a Data Architect 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 integrity, teamwork, accountability, adaptability, and communication in all we do and expect 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

Data Architect Role Overview

Responsible for providing input on implementation and administration methodologies to management. Responsible for developing, optimizing, and oversee company’s logical, conceptual, and physical data model and provide recommendations. This role will be responsible for expanding, optimizing, and monitoring our expanding data pipelines through architecting, intelligent business logic, consistent data governance, testing, and continuous delivery.

Day-to-Day Responsibilities

• Drive the architectural vision and implementation of our data solutions, ensuring that technologies align with the overall business objectives.
• Advocate for and implement best data engineering and architectural practices, ensuring that the team produces high-quality, maintainable, and scalable code.
• Mentor and guide junior and mid-level team members, providing technical leadership and promoting a culture of continuous learning and innovation.
• Work closely with product managers, software developers, and other stakeholders to deliver features and improvements.
• Stay abreast of emerging technologies and trends in the marketplace, making recommendations for adoption where appropriate.
• Other duties as assigned.

Required Qualifications

• Bachelor’s degree in Business/IT/Computer science required.
• Master’s degree in computer science, or business analytics is a plus.
• Five to seven years of experience in technology-based roles..
• Strong understanding of data architecture, data modeling, and data warehousing concepts.
• Proven experience (3+ years) working as a Data/Solution architect with increasing responsibility.
• Proficiency in complex SQL, Unix Shell/Scripting, performance tuning, and database optimization.
• Strong knowledge of DevOps practices, tools, and techniques
• Experience in designing and building ingestion data pipelines using Snowpipe.
• Experience with data security and data access controls and design in Snowflake.
• Experience with ongoing updates to modeling principles, solutions, and methods within Snowflake.
• Data vault modeling design to data mart level, knowledge of DBT software would be a plus.
• Certified Snowflake cloud data warehouse Architect (Desirable)
• Certifications in a cloud platform would be a plus, AWS preferred.
• Working knowledge and experience in Agile methods
• Strong proficiency in programming languages such as SQL, Java, and Python
• Ability to understand and communicate clearly technical concepts and develop robust solutions.
• Emotional maturity to handle high change environment with changing priorities.

Compensation and Benefits

As part of your total compensation package, you will also receive the following benefits:

• Paid time off, including holidays, vacation days, personal days, parental leave, and bereavement leave
• 401(k) with a company match
• Medical, prescription, dental, and vision insurance options, as well as supplemental health plan options, including accident, critical illness, and hospitalization
• Saving and spending accounts
• Company-paid telemedicine services
• Free counseling and information services
• Wellness program
• Company-paid life insurance
• Company-paid disability coverage
• Adoption assistance
• Education assistance
• Legal service plan option
• Pay advance option

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 [email protected]