Overview
• Sales System Governance: Oversee the functionality and performance of sales-related systems, ensuring seamless integration, accuracy, and reliability. Collaborate with IT teams to troubleshoot issues and implement system enhancements.
• Data Integrity: Perform regular data validation, cleansing, and quality checks to ensure data accuracy within sales systems and reports. Be the owner of database integrations and information quality, guaranteeing upgrades
• Business Scorecards & Reporting: Contribute to have automated business scorecards and Power BI dashboards for sales and execution performance, ensuring accessibility and usability. Support organizational adoption of data-driven decision-making and dashboard usage.
• Process Enhancement: Identify opportunities for process improvement within sales operations. Implement automation and streamline reporting workflows to enhance efficiency and reduce manual effort.
• G2M Capabilities and Tools adoption: Collaborate with teams to leverage digital tools that empower G2M strategies, including Distributors Integration Systems, Sales Force Automation and Force Manager. Ensure teams have the necessary tools to drive growth and optimize sales processes.
• Process Efficiency and Improvement: Develop projects that streamline processes, preparing the company for future challenges and driving operational excellence.
• Cross-Functional Collaboration: Collaborate closely with sales teams to understand their data needs and provide analytical support. Partner with trade marketing, supply, planning, and net revenue team to align reporting efforts and provide actionable insights.
• Continuous Learning: Stay updated with emerging trends, technologies, and best practices in sales analytics and reporting to contribute innovative
Responsibilities
1. Advanced analytics, statistical skills, and business savvy to transform data into business opportunities:- Ability and experience in transforming data into concrete insights and actionable plans
2. Data treatment:
3. - Data cleaning, preparation, and mining: Ensure the data is ready to be analyzed (normalized, standard & clean). Discover hidden patterns that enable the company to take decisions and discover new opportunities.
4. - Data visualization/ Dashboards: Use tools to be able to visualize data & hidden insights and to provide an impactful source of new opportunities. Ensure we discover new sources of data, specifically digital & unused data sources such as API's, open data, etc… (by using Power BI, Tableau or Qlik sense…)
5. - Data modeling: knowledge and use of statistical tools that allow deeper analysis with big amount of data (Python, SQL, R, etc)
6. Keep up-to-date changes and upgrades needed on Pepsico Systems (G-Conector; SFA; Power BI; Force Manager);
7. Responsible for guaranteeing quality Power BI dashboards and other sales KPI's reporting tools.
8. Project Management:
9. schedule priorities, identify risks, and propose action plans together with the manager
10. - align with different stakeholders' business requirements to deliver projects according to business priorities
Qualifications
11. Bachelor's degree in Engineering, Data Science, Economics or Management, Information Systems, or a related field. An advanced degree is a plus.
12. Strong analytical skills with the ability to manipulate and interpret complex data sets
13. Proficiency in data visualization and analytical tools (, Tableau, Power BI, Qliks) and MS Office Suite.
14. Experience with database management and SQL queries.
15. Detail-oriented mindset with a focus on data accuracy and quality.
16. Problem-solving attitude with a proactive approach to process improvement.
17. Strong communication skills to effectively assure change management and digital tools adoption by technical and non-technical stakeholders.
18. Strategic thinking and a proactive approach to identifying business opportunities.
19. Ability to work independently and collaboratively within cross-functional teams.
20. Familiarity with FMCG industry dynamics, processes, and key performance indicators (KPIs).
21. Fluent in English and Portuguese, with a good level of Spanish (preferred);
22. Ability to communicate and present fluently.
Differentiating competencies required:
23. Strong analytical and technology skills
24. Ability to work in a high-pressure environment with several projects
25. Able to give presentations in a highly impactful way
26. Adaptability to constant uncertainty and contingencies daily arising
27. Persuasion to convince senior leaders
28. Complex coordination of several departments (internal/external)
29. Good balance between commercial drive and analytical skills
30. Strong relationship-building skills with internal/external partners and senior staff