Planning Automation/Analytics Intern
Core
Intern supporting digitalization of Production Planning by developing Power BI dashboards, automating reporting workflows, and building tools to simplify daily planning activities for the Monterrey plant.
Role type
Intern, IC data analyst & automation developer
Builds
Power BI dashboards, automated reporting workflows, data processing scripts
Domain
Manufacturing / Production Planning / Supply Chain
Deliverable
dashboards & analysis
Required skills
Power BI (dashboard development, data modeling, Power Query, DAX), Excel (data cleaning, transformation, validation), Programming fundamentals, Analytical thinking
Preferred skills
Python (pandas, workflow automation), SQL, Relational databases, APIs, Power Automate, Git, Manufacturing/Supply Chain domain knowledge
Technologies
Power BI, Excel, Python, SAP, SQL, Git
Responsibilities
Map planning processes to identify automation opportunities; Design and maintain Power BI dashboards; Automate data extraction and reporting; Develop scripts to process operational data; Integrate data from SAP and Excel; Build reporting capabilities for production metrics; Implement data quality checks; Test automation outputs with planners; Document code and procedures; Support users with troubleshooting and training