Power BI & Automation Intern — Production Planning

Dematic; Guadalupe; Sur place; MXN 207 000 - 289 000; Temps partiel

Résumé du poste

Dematic in Monterrey, Mexico, seeks a student to help digitalize Production Planning by building Power BI dashboards, automating reporting workflows, and creating tools to simplify daily planning. You will work with SAP data and operational data to deliver reliable insights for the plant.

The role blends development and business analysis, requiring Power BI skills, Excel data handling, and intermediate English, with part-time on-site work while you complete your degree.

Qualifications

• Currently pursuing a technical degree.
• Power BI experience including dashboards, data modeling, Power Query, and DAX.
• Strong Excel data cleaning and transformation skills.
• Understanding of programming fundamentals and translating business requirements into technical solutions.
• Intermediate English and ability to collaborate with operations teams.
• Availability to work part-time at the Monterrey plant while studying.

Responsabilités

• Map existing planning processes and reporting workflows to identify automation opportunities.
• Design, develop, and maintain Power BI dashboards with data models, Power Query, 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.

Connaissances

Power BI

Data modeling

Power Query

DAX

Python scripting

Excel

English (intermediate)

Formation

Pursuing degree in Computer Science / Software Engineering / Information Systems / Data Science

Outils

Python (pandas)

SQL

Git

Power Automate

Description du poste

Dematic in Monterrey, Mexico, seeks a student to help digitalize Production Planning by building Power BI dashboards, automating reporting workflows, and creating tools to simplify daily planning. You will work with SAP data and operational data to deliver reliable insights for the plant.

The role blends development and business analysis, requiring Power BI skills, Excel data handling, and intermediate English, with part-time on-site work while you complete your degree.