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

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.

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.