Sc Plng Demand Planner

Responsibilities: See Second Language Qualifications: See Second Language Responsibilities (Secondary Language): Are you looking for a challenging opportunity in an organization with a dynamic, innovative and diverse environment?If so, your future is at PepsiCo. As a world class company, we seek excellence in everything we do. Therefore, we need talented and innovative people who are passionate about what they do.Now we are looking for this position:**Statistical Modeling Sr. Analyst****Main Purpose**We are PepsiCo. We are a diverse organization, spread among 200 countries and united by a shared set of values and goals. That’s why we Perform with Purpose. Together, we blaze new trails, succeed, celebrate and never settle for second best. At PepsiCo, we’re committed to performing well as individuals and in teams, to strengthen the company as a whole.Our employees are at the heart of PepsiCo. Through the Company's commitment to Talent Sustainability, we continue to support the development of employees. At PepsiCo, you get the best of both worlds: an entrepreneur’s mindset plus global 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 your drive. We will give you a platform to be daring on a global scale.- This position would be in the Demand Planning group which is a part of the Integrated Supply Chain sub-function in Frito-Lay's Operations function. The Demand Planning group’s primary responsibilities include:- 1) Maintain and enhance the demand forecasting statistical models- 2) Design, develop and publish metrics- 3) Provide analysis and support to the demand planners in the field**Accountabilities**- Assist demand planners with statistical model questions and investigate and troubleshoot SAS statistical model behavior with large data streams in the order of 10-200 GB of data. Communicate complex statistical analysis in nontechnical business language to demand planner and leadership.- Support the weekly execution of demand forecasting processes, such as product phase in/phase out, BDC removal, Top 25 process. Liaison with IT and other business functions to triage and resolve operational issues.- Generate weekly accuracy, bias, and exception reports. Administer the relief process for exception scenarios.- Support ad-hoc analytical needs as needed by developing programs, tools, analyzing data, and/or creating visualizations in Excel and/or Tableau.- Assist in deep-dive projects to incorporate business insights into optimizing SAS forecasting parameters to improve forecast accuracy. Conduct research on data and processes to identify root causes of supply chain issues such as low product supply, low sales, irregular promotions effects, seasonal changes in sales.Thank you so much for thinking about PepsiCo to start or continue your career Qualifications (Secondary Language):**Education/requirements**- Bachelor’s degree or master’s degree in business analytics, statistics, economics, engineering, or computer science.- Statistical modeling and programming using SAS or R or Python, preferably for demand forecasting.- Working with large volumes of data and proficiency in writing SQL queries on relational databases like Teradata, Oracle, DB2, and SQL Server.- UNIX, Perl scripting, shell scripting, and VBA macros on Excel- Creating insights and visualization using Tableau, PowerBI, and/or Excel/VBA.- Researching data and processes to identify root causes of supply chain issues such as low products supply, low sales, irregular promotions effects, seasonal changes in sales- Working with IT support teams on projects such as the technical implementation of supply chain tools and upgrading and supporting systems and software- Experience in implementing or using i2 demand forecasting software and understanding the demand planning process.- Excellent communication skills with the ability to translate business needs into IT requirements.- Ability to communicate statistical analysis into the nontechnical business language to demand planners and managers.