Business Analyst

Bic Group; Polska; Hybrid; PLN 120,000 - 170,000; Full time

Job summary

BIC World is seeking a skilled Business Analyst for a hybrid role in Poland. You will manage monthly customer data sets (sell-in / sell-out), maintain data dictionaries, and produce regular sales reports to drive better business decisions.

The ideal candidate has a university degree in Science, advanced English, expert Excel with VBA, and strong Power BI and SQL knowledge. Experience with Cognos, MS Access, and ERP like JDE is a plus.

Qualifications

• University degree in Science and advanced English required.
• Strong proficiency in Excel with VBA for data manipulation.
• Experience with Power BI and SQL for data analysis.
• Familiarity with Cognos and ERP systems (JDE is a plus).

Responsibilities

• Manage monthly customer data (sell-in / sell-out) and inventories.
• Prepare regular sales reports by DOS, customers, and product categories.
• Create and maintain data dictionaries for products and customer hierarchies.
• Deliver Sales Reports trainings across the organization.
• Support automation of reporting and data integration from multiple sources.

Skills

Advanced English

Excel with VBA

Power BI

SQL

Cognos

ERP familiarity (JDE)

Attention to details

Education

University degree in Science

Tools

MS Excel

Power BI

SQL

Cognos

MS Access

JDE ERP

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