Demand Planning Analyst Intern

IRCA GroupGallarate, LombardyHybridInternshipListed 2 weeks ago

Apply now

About this role

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