Lead Analyst - PepsiCo Novosibirsk, Russia

About PepsiCo

PepsiCo is one of the world's leading food and beverage companies, with a portfolio that includes iconic brands like Pepsi, Lay's, Gatorade, and Quaker. Operating in over 200 countries, PepsiCo employs more than 300,000 people globally and generates annual revenues exceeding $90 billion. In Russia, PepsiCo has a strong presence, focusing on innovation in snacks, beverages, and sustainable practices. As a leader in the FMCG sector, PepsiCo invests heavily in supply chain excellence, demand planning, and data-driven decision-making to deliver products consumers love.

Our Novosibirsk operations are central to Siberia's distribution network, supporting efficient sales forecasting and planning for a dynamic market. Joining PepsiCo means contributing to a company committed to sustainable growth, community impact, and employee development.

Role Overview

The Lead Analyst position in Novosibirsk is pivotal for optimizing PepsiCo's demand planning processes. You will spearhead 9-week demand forecasts, collaborate with sales teams, and drive KPI improvements to minimize losses and enhance forecast accuracy. This full-time role demands analytical prowess, FMCG expertise, and strong communication skills to support cross-functional teams in achieving sales targets.

Ideal for professionals with 2+ years in demand forecasting, this position offers exposure to advanced tools like Excel and Power Query, while contributing to mid-term 18-week planning strategies.

Key Responsibilities

Demand Forecasting and Planning

Formulate precise 9-week demand forecasts per client, adhering to strict timelines and company regulations. Develop preliminary sales forecasts by integrating base trends, promotional impacts, and external factors. Critically evaluate input data and volumes influenced by market dynamics.

Coordination and Control

Align forecasts with sales teams and key clients, adapting formats for supply chain functions. Monitor daily sales plan execution, demand deviation explanations, and authorize adjustments to 6-week rolling plans. Track KPIs such as forecast accuracy, stock losses (SL), and write-offs due to short-term errors.

Reporting and Analytics

Deliver timely standard reports for demand planning processes and respond to top management requests. Prepare operational analytical reports and contribute to 18-week mid-term demand forecasts. Organize cross-functional meetings to elevate planning quality using business-oriented KPIs.

Projects and Collaboration

Actively engage in departmental projects on sales planning, analytics, and business systems. Foster internal communications and cross-functional interactions to sustain business processes and meet strategic goals. Consult sales teams on processes and tools for optimal performance.

Qualifications & Requirements

To excel as Lead Analyst at PepsiCo, candidates must hold a higher education degree and possess professional mastery of MS Office, particularly Excel. Knowledge of forecasting methodologies, project management experience, and at least 2 years in demand forecasting are essential. Familiarity with FMCG sales dynamics is required, with Power Query proficiency highly desirable.

Strong organizational skills, the ability to lead projects, and experience in efficient process setup will set you apart. Fluency in Russian is necessary, with English as a plus for global interactions.

Benefits & Perks

PepsiCo offers a premium compensation package tailored to Russia's competitive landscape. Enjoy a salary estimated at $65,000-$95,000 USD annually (adjusted for local market with upside buffer), performance incentives, and comprehensive health coverage. Additional perks include subsidized meals, transportation allowances, and access to fitness programs.

Employees benefit from PepsiCo's global learning platform with courses in analytics, leadership, and supply chain. Parental leave, flexible hours, and hybrid work options promote work-life balance in Novosibirsk's vibrant setting.

Career Growth

At PepsiCo, career progression is data-driven and merit-based. Lead Analysts often advance to Senior Planner, Demand Planning Manager, or Supply Chain Director roles. Our internal mobility program has seen 70% of managers promoted from within last year. Access mentorship, certifications in SAP/ERP systems, and international rotations to accelerate your path in FMCG analytics.

Novosibirsk serves as a hub for regional leadership, offering visibility to Moscow and global HQ opportunities.

Why Join Us

Choose PepsiCo for impact: your forecasts directly influence million-unit distributions across Russia. Work with cutting-edge tools in a collaborative environment prioritizing innovation and sustainability. PepsiCo's commitment to zero-net emissions by 2040 aligns with purpose-driven careers. In Novosibirsk, enjoy a supportive team, modern facilities, and proximity to cultural landmarks like the Novosibirsk Opera.

Be part of a company where 80% of employees recommend us as a great place to work (Glassdoor ratings).

Role FAQs

What is the work schedule?

Full-time, standard business hours with flexibility for hybrid arrangements.

Is relocation support provided?

Yes, for qualified internal or external candidates from other regions.

What tools will I use daily?

Advanced Excel, Power Query, ERP systems, and PepsiCo's proprietary planning software.

Are there opportunities for international travel?

Occasional, for cross-regional projects and training.

How does PepsiCo support professional development?

Through PepsiCo University, certifications, and personalized career plans.

Ready to forecast the future of PepsiCo in Russia? Apply now and elevate your career in demand planning excellence. (Word count: 1,248)