Overview
- The person will be responsible to support reporting and automation requirements of the International Beverages business.
- The person should have very strong Business Intelligence skills and will play a critical role in executing key transformations and process simplifications.
Responsibilities
Extract shelf prices and other relevant data from third-party sources, such as Nielsen / Circana.Cleanse and transform data via Excel or Power BI, ensuring accuracy and consistency through mapping SKUs, correcting erroneous entries, and standardizing formats.Upload and integrate transformed data ensuring proper data flow and validation.Collaborate with local market teams to ensure data accuracy and alignment with business needs.Monitor data integrity and implement quality control checks throughout the data handling process.Troubleshoot and resolve any discrepancies or issues that arise during data extraction, transformation or upload stages.Develop and maintain comprehensive documentation of data processesQualifications
Key Skills / Experience Required
Minimum 6-7 Y of experience.Strong proficiency in Excel, including advanced formulas, pivot tables and data manipulation.Experience with Power BI or Power Query for data manipulation and analysis is must to have.Experience on working with Python is strongly preferred.Strong analytical and problem-solving skills with attention to detail.Ability to work independently and manage multiple tasks in a fast-paced environment.Differentiating Competencies Required
Complete understanding of BI reporting platformsSolution-oriented approach to problem solving / CreativeAbility to challenge requests in a constructive way that does not damage relationships or slow progressStrong analytical thinking with proven ability to connect data & to digestible representations to generate insightsGrowth mindset, positive attitude & strong interest in solving client challenges and dealing with multiple issuesWorking in a fast moving, rapidly changing and dynamic environmentSkills Required
Excel, Power Bi, Power Query, Python