Planning Automation/Analytics Intern

We offer:

Key Responsibilities:

• Map existing planning processes and reporting workflows to identify and prioritize automation opportunities.
• Design, develop, and maintain Power BI dashboards, including data models, Power Query transformations, and DAX measures.
• Automate recurring data extraction, consolidation, validation, and reporting activities using approved tools.
• Develop scripts and utilities, preferably in Python, to process operational data and reduce repetitive manual tasks.
• Integrate data from SAP exports, Excel files, and other approved sources into consistent reporting solutions.
• Build reporting capabilities for material availability, production readiness, backlog, capacity, schedule adherence, and delivery performance.
• Implement data quality checks and exception reports to identify missing, inconsistent, or duplicate information.
• Test and validate automation outputs with planners before implementation.
• Document code, data sources, business rules, and operating procedures to support maintenance and knowledge transfer.
• Support users with troubleshooting, training, and continuous improvement of developed tools.

Tasks and Qualifications:

Required Qualifications:

• Currently pursuing a degree in Computer Science, Software Engineering, Information Systems, Data Science, or a related technical field.
• Hands-on Power BI experience is required, including dashboard development, data modeling, Power Query, and basic DAX.
• Strong Excel skills and experience cleaning, transforming, and validating data.
• Understanding of programming fundamentals and the ability to translate business requirements into technical solutions.
• Strong analytical thinking, attention to detail, and problem-solving skills.
• Ability to explain technical concepts clearly and collaborate with operational teams.
• Intermediate English.
• Availability to work part-time at the Monterrey plant while continuing university studies.

Preferred Qualifications:

• Python experience, particularly with pandas, Excel processing, and workflow automation.
• Familiarity with SQL, relational databases, APIs, or Power Automate.
• Basic knowledge of version control, preferably Git.
• Interest in manufacturing, supply chain, and production planning.

Academic or personal projects demonstrating Power BI and automation skills are welcome; prior professional experience is not required.