Ph3Business Analyst – Retail Performance Stock Optimization /h3pJoin Dan John as a bBusiness Analyst /b focused on transforming retail data into actionable insights that drive performance, stock optimization, and margin improvement. /ph3OBIETTIVO DEL RUOLO /h3pSupport retail, merchandising, product, and finance functions by improving performance interpretation, ensuring data quality, and advancing reporting dashboards. /ph3RESPONSABILITÀ /h3ulliAnalyze sales, performance, and KPI across stores, channels, and categories, identifying trends, anomalies and opportunities. /liliDefine and monitor retail KPI (conversion, UPT, ATV/AUR, sell-through, markdown, margin, stock rotation) and produce insights for management. /liliMonitor sell‑in, sell‑out, inventory and support distribution optimization, highlighting criticality (stock rotures, overstock, slow mover) and proposing corrective actions. /liliProject, maintain and evolve Power BI reports and dashboards, structuring datasets, improving usability and consistency. /liliPreserve data quality: consistency checks, reconcilia, identification of irregularities, and maintain data loading flows. /liliSupport collection budget definition and variance analysis (mix, timing, pricing, rotation). /liliSupport balance strategy and monitor results (sell‑through, markdown, margin, performance per cluster/store). /liliParticipate in implementing an SOP evolution tool. /li /ulh3REQUISITI /h3ulliDegree in economics, quantitative disciplines or equivalent experience. /liliExperience in retail (preferably fashion/apparel). /liliAdvanced Excel (pivot, advanced functions, structured dataset management; Power Query desirable). /liliSolid Power BI: dashboard creation, DAX, Power Query. /liliExcellent English (written and spoken). /liliExperience handling imperfect data: exceptions, checks, reconciliations. /li /ulh3PLUS /h3ulliSQL basic (SELECT, JOIN, GROUP BY). /liliETL tools (KNIME or similar). /liliData modeling concepts (star schema, relationships, granularity) and governance principles. /liliExperience on multi‑country/multi‑store networks and clustering. /li /ulh3COMPETENZE PERSONALI /h3ulliAutonomy and ownership. /liliClear communication and synthesis. /liliPrecision, method and data quality focus. /liliTeam collaboration and cross‑functional cooperation. /li /ul /p #J-18808-Ljbffr