1+ months

Data Engineer

San Francisco, CA 94102
Auto req ID: 191781BR

Job Description

The next great shift in consumer behavior driven by technological disruption is underway, and its happening in the food & beverage industry.

As other sectors have shifted to eCommerce-first business models in recent years, food & beverage has continued to rely predominantly on traditional brick & mortar models, but this is changing rapidly. New technologies are transforming every aspect of reaching consumers, from the rise of digital marketing and online grocery platforms, to the creation of supply chain tools that enable speedy at-home delivery. According to the Food Marketing Institute, 70% of U.S. consumers will shop online for groceries by 2024, with an estimated annual spend of $100 billion.

To deepen our efforts to seize this opportunity and lead the food & beverage industry into its remarkable next chapter, PepsiCo a global company with powerhouse brands including Frito-Lay, Gatorade, Pepsi-Cola, Quaker, and Tropicana is expanding its Global eCommerce Team. Were looking for the greatest minds in data & analytics, software development, machine learning optimization, and next-generation supply chain. Given PepsiCos incredible reach our foods and beverages are enjoyed more than one billion times a day in more than 200 countries and territories, and our value chain involves diverse partners ranging from farmers and food scientists to retailers and logistics specialists the challenges were addressing are complex and the solutions will be deeply impactful.

Although PepsiCo is a large multinational, the PepsiCo Global eCommerce Team prides itself on having the entrepreneurial, action-oriented culture of an exciting startup business. Our group includes startup founders, Silicon Valley veterans, food & beverage experts, and seasoned executives from digital transformation leaders such as Amazon and Walmart. Our goal is to build the technological products and capabilities that will reinvent our industry and make us the #1 food & beverage business in eCommerce for decades to come.

As a Data Engineer you will design and build technical solutions which leverage both Enterprise and Big Data as it relates to B2B and B2C eCommerce. You will work to improve the collection, storage, processing, and analysis of disparate data sets. You will drive initiatives with business partners and multi-functional technical teams to promote long term supportability and lead efforts to integrate data into the companys larger Enterprise Architecture.

Responsibilities:

  • Develop and Lead ETL processes to quickly prioritize data for analysis
  • Use SQL for data querying across enterprise platforms, including the construction of automated processes to facilitate ongoing business
  • Build out the necessary data structures optimized for eCommerce analytics, using the on-premise data warehouse and other structured and unstructured data warehousing/storage platforms
  • Provide technical design/development mentorship for data warehouse tools and initiatives
  • Partner with infrastructure and support teams to ensure the integrity of the environment
  • Provide business analytics guidance as needed to ensure data quality

Qualifications/Requirements

  • Preferred Qualifications:

  • Bachelor Degree in Computer Science, Engineering, or other STEM related area
  • 4 years of experience in Data Warehouse implementation, 2 years with a Masters
  • Development experience in ETL. Experience with SSIS a plus.
  • Experience with programming or scripting languages like PowerShell, Java, VB Script, PHP, Ruby, or R
  • Extensive experience writing SQL queries, with experience specifically on Teradata and SQL Server a plus
  • Familiarity with Hadoop, Map Reduce, and/or HDFS
  • Experience in working with AWS or other cloud computing platforms
  • Experience writing scripts to prepare, integrate, clean, run and analyze data using Hive, Pig, etc. a plus
  • Communicate to multiple levels of management within the organization as well as business partner

Relocation Eligible: Not Applicable
Job Type: Regular


All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

PepsiCo is an Equal Opportunity Employer: Female / Minority / Disability / Protected Veteran / Sexual Orientation / Gender Identity

Our Company will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the Fair Credit Reporting Act, and all other applicable laws, including but not limited to, San Francisco Police Code Sections 4901 - 4919, commonly referred to as the San Francisco Fair Chance Ordinance; and Chapter XVII, Article 9 of the Los Angeles Municipal Code, commonly referred to as the Fair Chance Initiative for Hiring Ordinance.

If you'd like more information about your EEO rights as an applicant under the law, please download the available EEO is the Law & EEO is the Law Supplement documents. View PepsiCo EEO Policy

Please view our Pay Transparency Statement","city":"San Francisco","state":"California

Categories

Posted: 2019-09-12 Expires: 2019-12-05

Performance with Purpose


Out performing ourselves is a rush. That's why we perform with purpose. Together, we blaze new trails, succeed, celebrate and then do something even bigger. We never settle for second best. At PepsiCo we're not just committed to performing well as individuals, but as a team, to strengthen the company as a whole.

Around the world, we're working hard to give people the tastes they crave and the nutrition they need. We dream globally and act locally, constantly innovating to sustain our planet, our people, our communities and our business practices. New markets mean new ways of doing business, and new ways of addressing health concerns, cultural differences and environmental challenges. Every day is an adventure, and an opportunity for personal and professional growth.

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Engineer

PepsiCo Inc.
San Francisco, CA 94102

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast