In this role you will be helping to support the following tasks:

- Business Operations Management:
- Track and analyze budget usage, specifically regarding personnel & non-personnel, ensuring alignment with annual forecasts.
- Manage the creation and tracking of Purchase Orders (POs) and budget approvals.
- Maintain accurate Team Rosters, Organizational Charts, and Distribution Lists.

- Data Analysis & Reporting:

- Develop "Health Charts" and dashboards to visualize status for business-related tasks.

- Conduct ad-hoc resource studies and workload analysis to support VHE leadership.
- Process Automation & Optimization:

- Analyze current administrative workflows (reporting, tracking, roster management) to identify bottlenecks.
- Develop and deploy automation solutions (using Excel VBA/Macros, Python, PowerBI Power Automate) to reduce manual data entry.

- Leverage AI tools (e.g., Large Language Models, Copilot, Opencode) to summarize meeting notes, draft communications, and accelerate data analysis.

Qualifications

- Education: Currently enrolled in the final year or recently graduated in Engineering (Mechanical, Mechatronics, Aeronautical, Automotive) or a related technical discipline.
- Technical Proficiency:
- Advanced Microsoft Office: Deep knowledge of Excel is required. Experience creating Macros or using VBA is highly preferred.
- Coding & Scripting: Familiarity with basic coding logic (Python, SQL, or similar) to assist in automating data tasks.




- AI Literacy: Interest in and familiarity with using AI tools to improve productivity and streamline processes (LLM, opencode, etc).
- Core Competencies:
- Analytical Mindset: Ability to sort through complex databases and visualize data effectively.
- Proactivity: A self-starter who looks for ways to improve existing systems without being asked.
- Communication: Strong English proficiency (written, reading, and oral) with the ability to document agreements and technical processes clearly.

- Preferred (Bonus) Skills:

- Experience with data visualization tools (e.g., Power BI, Tableau).
- Understanding of Automotive Systems.

- Strong English Proficiency (written, read, and oral).

At Ford Motor Company, we believe freedom of movement drives human progress. With our incredible plans for the future of mobility, we have a wide variety of opportunities for you to accelerate your career and help us define tomorrow’s transportation.

Ford Product Development is utilizing Design Thinking & User Experience methods to deliver breakthrough products and services that will delight our customers. Our employees are laser-focused on bringing innovative, exciting, and sustainable ideas to life. From autonomy and electrification, to smart mobility technologies, our Product Development teams around the world are working together with excitement to make smart vehicles for a smart world.

📌 Business Operations & Automation Analyst Ford Champ (Naucalpan de Juárez)
🏢 Ford Motor
📍 Naucalpan de Juárez