Business Analyst – Retail Performance & Stock Optimization

Business Analyst – Retail Performance & Stock Optimization

Join Dan John as a Business Analyst focused on transforming retail data into actionable insights that drive performance, stock optimization, and margin improvement.

OBIETTIVO DEL RUOLO

Support retail, merchandising, product, and finance functions by improving performance interpretation, ensuring data quality, and advancing reporting dashboards.

RESPONSABILITÀ

• Analyze sales, performance, and KPI across stores, channels, and categories, identifying trends, anomalies and opportunities.
• Define and monitor retail KPI (conversion, UPT, ATV/AUR, sell-through, markdown, margin, stock rotation) and produce insights for management.
• Monitor sell‑in, sell‑out, inventory and support distribution optimization, highlighting criticality (stock rotures, overstock, slow mover) and proposing corrective actions.
• Project, maintain and evolve Power BI reports and dashboards, structuring datasets, improving usability and consistency.
• Preserve data quality: consistency checks, reconcilia, identification of irregularities, and maintain data loading flows.
• Support collection budget definition and variance analysis (mix, timing, pricing, rotation).
• Support balance strategy and monitor results (sell‑through, markdown, margin, performance per cluster/store).
• Participate in implementing an S&OP evolution tool.

REQUISITI

• Degree in economics, quantitative disciplines or equivalent experience.
• Experience in retail (preferably fashion/apparel).
• Advanced Excel (pivot, advanced functions, structured dataset management; Power Query desirable).
• Solid Power BI: dashboard creation, DAX, Power Query.
• Excellent English (written and spoken).
• Experience handling imperfect data: exceptions, checks, reconciliations.

PLUS

• SQL basic (SELECT, JOIN, GROUP BY).
• ETL tools (KNIME or similar).
• Data modeling concepts (star schema, relationships, granularity) and governance principles.
• Experience on multi‑country/multi‑store networks and clustering.

COMPETENZE PERSONALI

• Autonomy and ownership.
• Clear communication and synthesis.
• Precision, method and data quality focus.
• Team collaboration and cross‑functional cooperation.