Ford Motor Company
Ford Motor Company
Ford Motor Company is a United States-based automotive manufacturer with a history dating to 1903. In addition to developing and producing vehicles, the company is expanding its focus across mobility services, digital experiences, and software. Ford’s work also includes sustainability efforts and environmental targets, reflecting an approach that connects transportation, innovation, community impact, and responsible business practices.

Business Operations Automation Analyst – Hybrid in Naucalpan de Juarez

Part-time hybrid role at Ford Motor Company focused on budget tracking, purchasing coordination, resource planning, and operational reporting. The position uses Excel VBA, Python, Power Automate, and AI productivity tools to automate workflows.

Description

  • Monitor, assess, and forecast overtime and travel spending against annual operating budgets
  • Coordinate the preparation, approval routing, and tracking of purchase orders
  • Keep team rosters, organization charts, and communication matrices up to date
  • Create and manage operational dashboards, health scorecards, and KPI reports
  • Analyze workloads and resource allocation to support capacity planning and engineering decisions
  • Spot administrative bottlenecks and opportunities for improvement
  • Implement workflow automation with Microsoft Power Automate, Excel VBA, and Python
  • Use AI productivity tools to improve reporting and technical documentation

Requirements

  • Final-year student or recent graduate in mechanical, mechatronics, aeronautical, automotive, computer science, information systems, or a related technical field, or equivalent practical experience
  • Advanced Microsoft Excel capability, including formulas, pivot tables, and data modeling
  • Experience with or interest in developing VBA macros
  • Basic programming or scripting knowledge, such as Python or SQL, for data manipulation and workflow automation
  • Hands-on familiarity with generative AI tools including Microsoft Copilot or large language models
  • Strong analytical and problem-solving ability
  • Ability to organize complex information and proactively improve processes
  • Professional proficiency in written and spoken English
  • Ability to document technical processes and communicate effectively with multidisciplinary teams

Benefits

  • Commitment to equal opportunity and a diverse, inclusive workplace
  • Internship or trainee experience designed to support career development

Related Jobs