Planning Automation/Analytics Intern

Roboticsconnected; Guadalupe; Sur place; MXN 138 000 - 248 000; Temps partiel

Résumé du poste

Roboticsconnected in Monterrey is seeking a part-time intern to support the digitalization of Production Planning by building Power BI dashboards and automating reports.

You will translate SAP and other data into reliable insights, develop Python scripts, and collaborate with planners to ensure data quality and useful outputs.

This role blends development with business analysis and provides hands-on experience in manufacturing analytics.

Qualifications

• Pursuing a technical degree with strong fundamentals.
• Hands-on Power BI experience including dashboards, data models, Power Query, and basic DAX.
• Strong Excel skills for data cleaning and validation.
• Ability to translate business requirements into technical solutions.
• Intermediate English and collaboration with operations.
• Available to work part-time at the Monterrey plant.

Responsabilités

• Design, develop, and maintain Power BI dashboards.
• Automate reporting workflows.
• Integrate data from SAP exports, Excel, and other sources into reporting solutions.
• Develop Python scripts to automate tasks and data processing.
• Document code, data sources, and business rules for maintenance.
• Test and validate outputs with planners before deployment.
• Support users with troubleshooting and continuous improvement.

Connaissances

Power BI

Excel

Python

Data modeling

DAX

Analytical thinking

English (Intermediate)

Team collaboration

Formation

Currently pursuing a degree in Computer Science, Software Engineering, Information Systems, Data Science, or related field

Outils

Power BI

Excel

Python

SQL

Git

Power Automate

Description du poste

Support the digitalization of Production Planning by developing Power BI dashboards, automating reporting workflows, and building tools that simplify daily planning activities. This role combines technical development and business analysis to transform SAP and operational data into reliable, actionable information for the Monterrey plant.

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.