Business Analyst – Retail Performance & Stock Optimization

Dan John; Roma; In loco; EUR 40.000 - 60.000; Tempo pieno

Descrizione del lavoro

An innovative retail company is seeking a Business Analyst focused on transforming retail data into actionable insights. This role involves analyzing sales performance and KPIs, supporting data quality checks, and evolving reporting dashboards using Power BI. The ideal candidate will possess a degree in economics, have retail experience, and demonstrate advanced skills in Excel and Power BI. Strong communication skills and the ability to work autonomously are essential for success in this role.

Competenze

• Degree in economics or equivalent experience is required.
• Experience in retail, preferably in fashion/apparel is essential.
• Advanced Excel skills are necessary along with solid Power BI expertise.

Mansioni

• Analyze sales and performance across stores and channels.
• Define and monitor retail KPI and produce insights for management.
• Project, maintain and evolve Power BI reports.

Conoscenze

Advanced Excel

Solid Power BI skills

Excellent English

Autonomy and ownership

Clear communication

Data quality focus

Formazione

Degree in economics or quantitative disciplines

Strumenti

Power BI

SQL

ETL tools

Descrizione del lavoro

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.