Business analyst in distributor sales

Join BIC World, a community of brands dedicated to creating ingeniously simple and joyful products that have been part of hearts and homes for over 75 years. We are committed to growing our iconic and innovative brands by reimagining everyday essentials in new, sustainable, and responsible ways. Our culture encourages a «roll up your sleeves and get the job done» mindset, ensuring self-starters, problem solvers, and innovative thinkers can truly thrive.

• Managing monthly Customer data (sell-in / sell-out of Distributors / Distributors Inventories database) and control their coherence and relevance
• Preparing regular sales reports and analysis by DOS, customers, product categories;
• Creation and maintaining of various data dictionaries in terms of products and Customers hierarchies for best possible data insights
• Perform Sales Reports trainings to various functions across organization
• Sales teams target split tools preparation for all DOSs
• Anticipation/assessment of new business requirements and “industrializing” them (if possible) into new/existing tools
• Key user and responsibility for SFA system
• system provider choice and tender if needed
• user trainings
• day-to-day administration of the tool – promotions definition, product, Customer database management, ongoing surveys etc.
• automated reporting tools creation and maintenance
• development of new functionalities dedicated for special BIC needs: e.g. Trade Fairs competition, POSM materials tracking etc.
• Transferring manual tasks done by Sales Reps to automated mode
• Sales Reps route optimization process leading
• Integration of data from different sources in terms of both sell-in and sell-out
• Sales Order Excel document creation and maintenance
• Excel expert – supporting of various roles with development of tools helping them to work more efficiently

• University degree in Science with min. advanced English;
• Very high proficiency in MS Excel incl VBA
• High capabilities in Power BI tools (Query, Pivot);
• Relational model data base background
• Reporting systems knowledge
• Sales landscape and processes understanding
• Process automation mindset
• MS Access knowledge
• Knowledge of any ERP
• Pedagogical skills
• Problem solving
• Entrepreneurial spirit - hands on
• Ability to work under pressure
• Attention to details
• 3+ years in similar role
• Experience of work with details and with big databases and data management
• Будет плюсом: SQL is an advantage; Cognos is an advantage; JDE is an advantage

• Условий в вакансии нет