The Role
Supports business operations through budget and purchase order tracking, roster and organizational chart maintenance, dashboard development, resource studies, and workload analysis. Identifies administrative workflow bottlenecks and develops automation using Excel VBA, Python, Power BI, and Power Automate. Uses AI tools to summarize meetings, draft communications, and accelerate analysis. The role requires strong Excel, analytical, communication, and process-improvement skills, with an engineering education preferred.
Summary Generated by Built In
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).
About UsAt 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.About the TeamFord 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.
Skills Required
- Currently enrolled in the final year or recently graduated in Engineering, including Mechanical, Mechatronics, Aeronautical, or Automotive Engineering, or a related technical discipline.
- Advanced Microsoft Office proficiency, including deep knowledge of Excel.
- Familiarity with basic coding logic using Python, SQL, or similar.
- Strong English proficiency in written, reading, and oral communication.
- Ability to analyze complex databases and visualize data effectively.
- Proactive, self-starting approach to improving existing systems.
- Experience creating Excel macros or using VBA.
- Experience with data visualization tools such as Power BI or Tableau.
- Interest in and familiarity with AI productivity tools, including LLMs, Copilot, or Opencode.
- Understanding of automotive systems.
Ford Motor Company Compensation & Benefits Highlights
-
Healthcare Strength — Eligible employees can access medical, dental, and prescription coverage starting on the first day, with some zero-cost plan options and free mental health support. Benefits materials highlight comprehensive healthcare as a core pillar.
-
Retirement Support — Employees can enroll in a 401(k)-style plan from day one, and some salaried plans include a company match of $0.90 per dollar on the first 5% contributed. Official summaries also describe financial-planning support.
-
Parental & Family Support — The package includes paid parental leave, fertility, surrogacy, and adoption benefits, plus a ramp-up program for new parents returning to work. Flexible family-care days and other time-off options support caregiving needs.
Ford Motor Company Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Ford is a global company with shared ideals and a deep sense of family. From our earliest days as a pioneer of modern transportation, we have sought to make the world a better place – one that benefits lives, communities and the planet. We are here to provide the means for every person to move and pursue their dreams, serving as a bridge between personal freedom and the future of mobility. In that pursuit, our 186,000 employees around the world help to set the pace of innovation every day.
Ford Motor Company Offices
OnSite Workspace
Typical time on-site:
None
