Business Analyst

Bic Group; Clichy; Presencial; EUR 55.000 - 85.000; Jornada completa

Descripción de la vacante

BIC World is seeking a data and analytics professional to manage sell-in/sell-out data, build BI dashboards, and drive data-driven decisions in Île-de-France. You will own data coherence, create reporting tools, and train teams in Sales Reporting across the organization.

The role emphasizes automation and the development of new data tools and processes to support business growth. The ideal candidate has 3+ years in a similar role, a science degree, and advanced English.

Formación

• University degree in Science with advanced English proficiency.
• Very high proficiency in MS Excel including VBA.
• Strong Power BI skills (Query, Pivot).
• Relational database background; SQL experience advantageous.
• Experience with Cognos and MS Access is beneficial.
• Understanding of sales processes and data management.

Responsabilidades

• Oversee monthly customer data (sell-in/sell-out) and ensure data coherence.
• Prepare regular sales reports and analyses by DOS, customers, and categories.
• Create and maintain data dictionaries for products and customer hierarchies.
• Provide Sales Reports trainings across the organization.
• Support tool development and automation for reporting and data integration.
• Act as key user for SFA system; coordinate tool maintenance and trainings.
• Automate manual tasks and optimize Sales Reps routes and processes.
• Develop new functionalities for BIC bespoke needs (trade fairs, POSM).

Conocimientos

Excel VBA

Power BI

SQL

Cognos

MS Access

ERP JDE

Data modeling

Educación

University degree in Science

Herramientas

JDE

Descripción del empleo

JoinBIC World, acommunity of brandsdedicated to creating ingeniously simple and joyful products that have been part of hearts and homes for over 75 years. We are committed togrowing our iconic and innovative brandsby 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. At BIC World, you are empowered to take ownership of your career and use your unique perspective to make a meaningful, global impact on our mission.

Key responsibilities/Tasks:

• 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

Candidate Profile:

• 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 (SQL is an advantage)
• Reporting systems knowledge (Cognos is an advantage)
• Sales landscape and processes understanding
• MS Access knowledge
• Knowledge of any ERP (JDE is an advantage)
• Problem solving
• Ability to work under pressure

Previous / Professional Experience

• 3+ years in similar role
• Experience of work with details and with big databases and data management

BIC World is an Equal Opportunity Employer. We strongly commit to hiring people with different backgrounds and experiences to help us build better products, make better decisions, and better serve our customers. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, veteran status, disability status, or similar characteristics. All employment is decided based on qualifications, merit, and business need.

BIC World is not seeking assistance or accepting unsolicited resumes from search firms for this employment opportunity. Regardless of past practice, all resumes submitted by search firms to any team member at BIC via email, or directly to a BIC team member in any form without a valid written search agreement in place for that position will be deemed the sole property of BIC, and no fee will be paid in the event the candidate is hired by BIC as a result of the referral or through other means.