Reporting & Analytics Analyst with French

September 18, 2024

PepsiCo

Kraków

Overview:

Location Overview

Working with inspiring and experienced colleagues, you'll find that the atmosphere in our city-centre office in Kraków is informal and engaging. With drive and ingenuity, our teams deliver vital services to Pepsi Co employees around the world. With an active, get-things-done culture, this is a place where your dynamism and agility will make a difference.

Role Overview

As a Reporting & Analytics Analyst your role will be to support French OT Sales agenda and be responsible for maintaining, analyzing and reporting the main information related to sales assessment and execution of the whole business plans with different customers in organized trade channel. It will require a collaboration with all departments supporting sales in terms of solving issues and implementing business actions

Responsibilities:

Identify suitable data / insight sources
Collect, clean & consolidate internal and external data from multiple sources
Capture, track, analyze and perform analysis of customer, category performance, volume, revenue profitability and other, based on sell data in preparation for performance reviews and ad-hoc requests.
Based on analysis develop monthly reports on the performance, collect customer specific data to track and analyze results by channel and customer, prepare relevant reporting for such.
Maintain and update data and data analysis data bases
Send out data request to customer/distributor/internal stakeholders
Reconciliate with customer and internal files data promotion numbers
Analyze performance KPIs (storage costs, preparation costs, delivery costs)

Qualifications:

1-3 years of working experience in a similar position
Intermediate knowledge of MS Excel (knowledge of SAP applications would be an advantage)
Analytical mindset allowing to collect and examine a large volume of data, and identify trends.
Ability to analyze data and draw conclusions in order to find actionable, results-oriented solutions
Fluency in English and French
Great organizational skills, ability to prioritize tasks at fast-paced, dynamic environment
Good attention to details
Exceptional written and oral communication skills