Business Analyst

Bic Group; Warszawa; Hybrid; PLN 120,000 - 180,000; Full time

Job summary

BIC World in Warsaw, Poland seeks a Business Analyst to join our data-driven team. You will manage monthly distributor data, build regular sales reports by DOS and product category, and ensure data integrity across multiple sources.

The ideal candidate has strong Excel (VBA), Power BI, SQL, Cognos, and ERP familiarity; 3+ years in similar roles; fluent English; and a hands-on, problem-solving mindset to help automate tasks and empower the sales organization.

Qualifications

• English fluency is required for daily work.
• Strong Excel skills with VBA for automation.
• Proficient in Power BI data modeling and analysis.
• Experience with SQL and relational databases is preferred.
• Familiarity with Cognos or similar reporting tools is advantageous.

Responsibilities

• Manage monthly Customer data (sell-in/sell-out) and inventories for coherence.
• Prepare regular sales reports by DOS, customers, and product categories.
• Create and maintain data dictionaries for products and customers.
• Lead Sales Reports trainings across the organization.
• Prepare tools for Sales teams target split across DOSs.

Skills

MS Excel (incl VBA)

Power BI (Query, Pivot)

SQL

Cognos

Relational databases

Education

University degree in Science

Tools

JDE ERP

MS Access

Job description

Select how often (in days) to receive an alert:

Business Analyst

BIC

Hybrid

Description:

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
• Process automation mindset
• MS Access knowledge
• Knowledge of any ERP (JDE is an advantage)
• Pedagogical skills

• Problem solving
• Entrepreneurial spirit - hands on
• Ability to work under pressure
• Attention to details

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.