What are the responsibilities and job description for the Data Engineer position at Pepsi Bottling Ventures and Careers?
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.
Job Description
Pepsi Bottling Ventures is seeking a Data Engineer to join our team!
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 Engineer Role Overview
Prepare data for analytical or operational uses within a data warehouse. The data engineer is typically responsible for building data pipelines to bring together information from different source systems. The data engineer will integrate, consolidate, and cleanse data and structure it for use in analytics applications. They will aim to make data easily accessible and to optimize their organization's data for use in Power BI.
Day-to-Day Responsibilities
- Designing and implementing data transformations, ingestion, and curation functions within a Snowflake environment. Responsible for all CI CD pipeline deployments.
- Build data models and table structures within Snowflake from various source systems, SAP, Workday, and other applications.
- Monitor, enhance, and improve processes across the technical solutions that feed the data warehouse through various systems.
- Optimizing data pipelines for performance and cost solutions.
- Administration and management of all users' access to the various tools in the landscape, including DBT, Snowflake, and DevOPS.
- Other duties as assigned.
Required Qualifications
- Bachelor’ 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 data analytics, data transformation, and data modeling.
- Strong in database management and data modeling fact and dimension tables.
- Data vault modeling design and experience.
- Previous experience as a data engineer on a startup Data Platform project.
- Strong knowledge of DevOps practices, tools, and techniques.
- Strong knowledge and experience with GIT OPS.
- Knowledge of DBT software would be a plus.
- Certifications in a cloud platform would be a plus, AWS preferred.
- Working knowledge and experience in Agile methods.
- SQL and Python experience or education.
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 rmssupport@pbvllc.com