Business Analyst

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

Job summary

BIC World in Warszawa is seeking a Business Analyst to manage monthly customer data, prepare sales reports, and build data dictionaries to enable deep insights.

You will train teams on Sales Reports, support automation, and drive data integration from multiple sources, improving efficiency and decision making.

The role requires strong Excel/VBA, Power BI, SQL basics, and experience with ERP systems; we value problem solving and detail orientation.

Qualifications

• University degree in Science or related field.
• Advanced English proficiency.
• Strong Excel skills (incl. VBA).
• Power BI data modelling and reporting experience.
• Relational database concepts and SQL basics.
• Experience with ERP systems (JDE preferred).
• Problem solving and data-driven mindset.

Responsibilities

• Manage monthly customer data (sell-in/sell-out, distributor inventories).
• Prepare regular sales reports and analyses by DOS, customers, and product categories.
• Create and maintain data dictionaries for products and customer hierarchies.
• Lead training on Sales Reports across functions.
• Develop and maintain automated reporting tools and new data-driven features.

Tools

Excel with VBA

Power BI

SQL

Cognos

MS Access

JDE ERP

Job description

Business Analyst

Warszawa, PL, 02-626Warszawa, PL, 02-626

BIC

Hybrid

Description:

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. 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.