SIOP & Demand Planning Intern (Analytics)

Allegion; Carmel (IN); On-site; USD 25,000 - 39,000; Full time

Job summary

Allegion Canada Inc. in Carmel, IN offers a Supply Chain Intern role focused on demand planning and SIOP analytics. You will collaborate with Sales, Product Management, Finance, Operations, and IT to build automated reports, dashboards, and support a 2027 planning solution rollout.

This internship provides hands-on exposure to end-to-end supply chain processes. Qualified students will work on data transformation, reporting automation, and cross-functional validation while developing expertise in

Qualifications

• Currently pursuing a Bachelor's degree (junior standing) or a Master's degree in Supply Chain Management, Analytics, Statistics, or a related field.
• Proficiency in Excel.
• Familiarity with Power BI or Tableau, and Python or R.

Responsibilities

• Build automated exception reporting for commercial distribution programs, using rule-based logic to accelerate SIOP review and decision-making.
• Develop Canada Commercial SIOP reporting tools and dashboards that mirror U.S. capabilities.
• Clean, transform, and map data to support new reports, dashboards, and automation efforts, validating outputs with subject-matter experts.
• Partner with Commercial, Distribution, Operations, Finance, and IT teams to gather requirements and support testing, validation, and configuration for a new demand planning solution (contingent on funding and project timeline).
• Develop and validate demand planning reports sourced from the new solution, benchmarking outputs against legacy data and SIOP requirements.

Skills

Excel proficiency

Python

R

Education

Bachelor's degree (junior standing) or Master's in related field

Tools

Power BI

Tableau

Job description

Allegion Canada Inc. in Carmel, IN offers a Supply Chain Intern role focused on demand planning and SIOP analytics. You will collaborate with Sales, Product Management, Finance, Operations, and IT to build automated reports, dashboards, and support a 2027 planning solution rollout.

This internship provides hands-on exposure to end-to-end supply chain processes. Qualified students will work on data transformation, reporting automation, and cross-functional validation while developing expertise in