Demand Planning Analyst Intern

Job description

**Who we are:**IRCA Group, an Advent portfolio company, was founded in Italy in 1919, and it is a leading international B2B provider of high-quality semi-finished ingredients such as chocolate, decorations, creams, inclusions, nuts and pistachios, pastry mixes, gelato ingredients, and other essential solutions for industrial clients or other independent artisanal producers.With more than 2.400 employees, 19 production facilities worldwide, and €1.4 billion in revenues, IRCA Group has a solid track record of growth and international expansion. **What do we offer:** - A dynamic, international, and inclusive environment with exposure to global projects and stakeholders - The opportunity to shape and lead the digital transformation agenda of a fast-growing international organization - High visibility with executive leadership and the ability to influence strategic business decisions - Professional development and international career opportunities - The chance to drive innovation through emerging technologies, advanced analytics, AI, automation, and digital solutions **Purpose of Position:** We are currently looking for a talented and motivated Data Analyst Intern to join our Demand Planning team in the Supply Chain department. ### Description of Main Activities/Responsibilities: - **Demand Planning Support:** Assist the team in managing demand planning activities for specific business areas, collaborating closely with Sales and Marketing departments to collect, clean, and structure company data. - **Forecast Model Maintenance**: Support the update and monitoring of statistical demand forecasting models. - **Power BI** Dashboard Development: - Collaborate on the creation, maintenance, and updating of interactive reports and dashboards in Power BI to monitor key KPIs such as Forecast Accuracy and Bias. - **S&OP Meeting Preparation**: Contribute to the preparation of reporting, presentations, and Executive Summaries for periodic Sales & Operations Planning (S&OP) and ILT (Integrated Leadership Team) meetings. - **Sales Analysis**: Support sales analysis against historical data to identify consumption patterns, seasonality, and anomalies, helping to prevent stockout or overstock situations. - **Exploration of AI Tools**: Experiment with and apply native Power BI AI features (e.g., Anomaly Detection, Smart Narratives) under the tutor's guidance to optimize and speed up data synthesis. - **New Product Introduction** (NPI) Follow-up: Collaborate on monitoring the sales performance of new launches during their first months on the market, supporting the team in applying predictive models by analogy. - **Switch Code Monitoring**: Support the mapping of product transitions (Phase-In / Phase-Out), helping to monitor the consumption of remaining stock for outgoing codes to eliminate obsolescence. - **Ad-Hoc Analysis:** Support the team in developing spot analyses and scenario simulations to address specific requests from management. ### Requirements: **Education**: Data Science/Analyst, Statistics, Economics, Business, Engineering, or a related fields. **Professional Skills:** Strong analytical skills and attention to detail. **Language Skills**: Proficiency in Italian and English is mandatory **Computer Skills**: Proficiency in data analysis tools such as Excel and PBI (pivot tables, database management) and/or statistical tools like Python, R, or SQL. **Behavioural Requirements**: Excellent communication and relational and problem-solving skills. ### Details: **Meal vouchers**: €8 for each day spent at the office **Remuneration**: starting from 900,00 € / month