Business Intelligence Specialist

Employer: Danone
Domain:
  • Pharmacy - Health
  • Internet - eCommerce
  • Sales
  • Job type: full-time
    Job level: 0 - 1 years of experience
    Location:
  • BUCHAREST
  • Updated at: 02.07.2020
    Short company description

    Our Mission:

    Bringing health through food to as many people as possible, guided by our 4 values: HUMANISM, OPENESS, PROXIMITY and ENTHUSIASM (HOPE).
    These values reflect the way we treat each other as individuals, but also the world around us. They helped us grow every year and share our vision with the whole world.

    This way Danone Group unites individuals from different locations and cultures that are living the same values. We have over 100.000 colleagues, we are active in over 140 countries and we are the prefered brand of over 900 mil consumers!

    Globally, Danone Group is No. 1 for Fresh Dairy Products, bringing a legacy of almost 100 years in producing yogurts. Danone holds No.2 market position worldwide for Early Life Nutrition, considering the markets it operates.

    In Romania we are present ever since 1997 and we produced our first yogurt in our Bucharest factory in 1999. Since then we produce over 1 mil yogurts daily and we are leader of local yogurts market. Our secret: the teamwork and collaboration of 400 colleagues all around the country.

    Find out more accessing: http://www.danone.ro/ or http://www.danone.com/

    Requirements

    Your profile:
    •University / Master’s degree
    •Experience on analytic responsibilities is a plus
    •Excellent Excel skills (Macro included)
    •Fluency in English, both written and spoken
    •Highly interested in numbers, figures, reports & strong analytical skills & sense for details
    •Willingness to learn, curiosity to move things forward
    •Ability to build relations with key functions/teams (especially field team population)

    Responsibilities

    -Evidence of Distributor Contracts;
    -Data analyze sell- in for distributors;
    -Issuing discounts for distributors:;
    - Monthly: request to the Master date issuing the discounts ;
    -Quarterly: Prepare centralization of efficiency discount;
    - Drop-size report processing => grading;
    -Analyze Top12 results => award decision: YES / NO & percentage;
    -Data collection for ASM: Danone Select (DNN & Alpro), Tradi & AFH promo differences (issued DNN vs. market);
    -Other projects (Results for Personalized Distribution Plans), bonus for co distribution, other bonuses, etc;
    -Verification of accuracy data received from ASM (various "key control");
    -Total CAF data processing, CAF Top12;
    -Centralization of amounts / discounts value for each distributor => transformation in% discount;
    No of POS report:
    - until the end of the month reminder to ASM that they must send until the 05th of the month info regarding No of POS;
    -Report centralization - up to the 6th of the month;
    -Distributor database management;
    - Ensures of receiving of the sales report from Asm responsible for each distributor (in the agreed format together with IT);
    - Frequency: at least once a month for the previous month (final report);
    - Check the report to be in the same format as the other precedents;
    - Posts the report received (corrected) on the OneDrive server;
    - Notifies IT after posting the reports;
    - Maintenance of the database for each distributor regarding stores, agent allocation, city, urban / rural.

    Other info

    -Various reports dedicated to Proximity channel analysis on-demand or agreed ;
    -Danone commissions calculation;
    -Bonus MMT;
    -Danone sales force commissions;

    -Discounts centralization and issuance ;
    -Monthly promotions;
    -In store dominance;
    -Free goods / budget management registration;
    -Implementation of "on invoice" promotions;
    -Managing credit notes and promo, pricing, listing forms for Proximity channel;
    -Free goods management for Proxy channel;
    -Estimate promotional costs for the finance department;
    -Evidence of Danone Select contracts ;
    -Respect both Danone and Legal legislations on: Environment, Health and Safety, Food Safety and Hygiene;
    -Ensure the responsible use of Danone properties;
    -Act as a positive example on H&S, Working Conditions and Well-being.