Business Operations, Automation Analyst

Ford Motor Company

. Track, evaluate, and forecast operational budget expenditures, specifically overtime and travel, against annual financial targets .

Posted 9/29/2026part-timeNaucalpan de Juárez • MexicoMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong analytical problem-solving skills and proficiency in Microsoft Excel for data analysis and reporting. Capable of deploying workflow automation using tools like Microsoft Power Automate and Python, while effectively communicating technical processes to multidisciplinary teams.

Highest-signal resume keywords

Microsoft Excel ProficiencyVBA Macro DevelopmentPython ProgrammingWorkflow AutomationGenerative AI Tools Familiarity

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingAdvanced FormulasPivot TablesSQLData ManipulationCapacity PlanningKPI ReportingOperational Budget TrackingWorkload AnalysisProcess Improvement

Soft Skills

Analytical Problem-SolvingClear CommunicationProactive Process Improvement

Tools & Technologies

Microsoft Power AutomateExcel VBAGenerative AI ToolsMicrosoft Copilot

Industry Keywords

EngineeringInformation SystemsOperational Health ScorecardsPurchase OrdersResource Allocation

Tech Stack

Tools & technologies

PythonSQLVBA

About the role

Key responsibilities & impact

Track, evaluate, and forecast operational budget expenditures, specifically overtime and travel, against annual financial targets
Coordinate preparation, routing, and tracking of Purchase Orders and administrative approvals
Maintain team rosters, organizational charts, and team communication matrices
Build and maintain dynamic dashboards, operational health scorecards, and KPI reports
Conduct workload analyses and resource allocation studies for capacity planning and engineering decision-making
Identify administrative bottlenecks
Deploy workflow automation using Microsoft Power Automate, Excel VBA, and Python
Integrate AI productivity tools to streamline reporting and documentation

Requirements

What you’ll need

Currently enrolled in the final year or recently graduated in Engineering (Mechanical, Mechatronics, Aeronautical, Automotive), Computer Science, Information Systems, or a related technical discipline, or equivalent practical experience
Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, and data modeling
Experience or interest in writing VBA macros
Foundational knowledge of programming or scripting logic such as Python, SQL, or similar, applied to data manipulation and workflow automation
Practical familiarity with generative AI tools such as Microsoft Copilot or LLMs
Analytical problem-solving skills
Ability to structure complex information and proactively drive continuous process improvements
Professional working proficiency in English, written and verbal
Ability to document technical processes and communicate clearly with multidisciplinary teams

Benefits

Comp & perks

Equal opportunity and diverse, inclusive workplace commitment
Internship/trainee opportunity to accelerate career development