Business Operations & Automation Analyst Ford Champ

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.

• 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).