PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo's product portfolio includes a wide range of enjoyable foods and beverages, including many iconic brands – such as Lay’s, Doritos, Cheetos, Gatorade, Pepsi-Cola, Mountain Dew, Quaker and SodaStream – that generate more than $1 billion each in estimated annual retail sales.

At PepsiCo, you get the best of both worlds: an entrepreneur’s mindset plus reach and resources. Our collaborative culture and worldwide presence generate a stream of new opportunities to define the future and propel your life’s work. Bring your unique perspective. Bring curiosity. Bring ingenuity, and drive. We’ll give you a platform to be daring on a global scale.

Location: Must live 90 miles from Plano, TX PepsiCo Office Location. Role is hybrid with 2-3 days in office per week expected.

PepsiCo operates in an environment undergoing immense and rapid change. Big-data and digital technologies are driving business transformation that is unlocking new capabilities and business innovations in areas like eCommerce, mobile experiences and IoT. The key to winning in these areas is being able to leverage enterprise data foundations built on PepsiCo’s global business scale to enable business insights, advanced analytics and new product development. PepsiCo’s Data Management and Operations team is tasked with the responsibility of developing quality data collection processes, maintaining the integrity of our data foundations and enabling business leaders and data scientists across the company to have rapid access to the data they need for decision-making and innovation.

What PepsiCo Data Management and Operations does:

• Maintain a predictable, transparent, global operating rhythm that ensures always-on access to high-quality data for stakeholders across the company
• Responsible for day-to-day data collection, transportation, maintenance/curation and access to the PepsiCo corporate data asset
• Work cross-functionally across the enterprise to centralize data and standardize it for use by business, data science or other stakeholders
• Increase awareness about available data and democratize access to it across the company.

Job Description

As a member of the data engineering team, you will be the key domain expert overseeing PepsiCo's business process and drive a strong discussion for how Supply Chain, Financial, Consumer, Channel, Category business needs to be defined and prioritize by working very closely with business leads, data science team and data engineering team. You'll develop an in-depth understanding of business processes in and translate business requirements to data engineering team in technical way.

Responsibilities

• Discover, analyze, and scope data requirements & representing them in conceptual and logical data models
• Gather and analyze data pertaining to various business processes such as forecasts, capital requirements, inventory, logistic, manufacturing and production capacity to develop supply chain models. geographics, POS, pricing and promotion, store profile, e-commerce data to develop channel models.
• Create high-level process models (system interface diagrams, workflow & swim lane diagrams, data flow diagrams) to represent processes for the area under analysis
• Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape.
• Responsible to improve the quality of data in relation to defined expectations
• Perform analysis of system data to identify patterns, exceptions, and erroneous data.

Qualifications

• 4+ years of experience with data analysis & data profiling in project, business requirements definition or data engineering in CPG or Manufacturing Industry. Profiling experience in SQL; python/pyspark is a plus
• 3+ years’ work experience in the areas of Demand Planning, Supply Planning, Integrated Business Planning (IBP), Distribution Network Analysis, Manufacturing, Production Network Optimization, Transportation, or other areas related to Supply Chain. Have working experience with Master Data (Procudt,Customer,Location etc).
• 2+ years of strong Data Profiling experience & ability to identify trends and anomalies in the data to inform data model build out.
• Familiarity with SAP, SAP IBP, and/or O9 is a plus
• Experience in working with Datasets from POS Aggregators such as IRI, Nielsen, Kantar etc. is a plus
• Experience working with structured/unstructured datasets, ability to clearly document and communicate requirement to technical team members.
• Experience with Business Intelligence tools, SQLTools.

Education

• Bachelor’s Degree Required, Supply Chain and/or Operations Management focus is a plus, Masters Preferred.