Financial Analyst, Supply Chain

Ford Motor • Dearborn, MI

4d • Hybrid

About The Position

The Material Freight Lead Analyst position works within the MP&L Controller’s Office and partners closely with the NAML (NA Material Logistics) operating team. The primary deliverables are to understand the freight costs within the logistics network, develop data modeling and analysis to identify efficiencies to drive optimal cost levels within the network, and ensure the right level of premium freight cost is utilized to deliver materials timely.

Requirements

• Bachelor’s degree in accounting or finance
• At least 5 years of relevant experience
• Strong interpersonal and communication skills; ability to develop strong, positive working relationships with the MP&L operating team and other organizations
• Strong analytical and problem-solving skills; ability to work with and organize large amounts of data
• Ability to work independently and manage multiple assignments

Nice To Haves

• Ability to reassess and adapt schedule to changing priorities
• Possess a process improvement mindset; implement new methods and ideas
• Proficiency with MS Excel and opportunity to learn new data modeling software (e.g., QlikView, Power Aps, Tableau, or Opencode)

Responsibilities

• Analyze large amounts of data (using data modeling tools) from various sources to identify freight payment trends to support tracking, forecasting, and reporting of freight expense
• Work in conjunction with NAML to understand logistics network operation, carrier contract economics, and payment authorization systems
• Participate in continuous improvement roadmap discussions with NAML to identify and implement network savings to meet annual efficiency and premium freight objectives
• Assist with development of Budget and Business Plan financials and provide analysis to support Year-over-Year efficiency and premium freight targets
• Prepare material freight accrual, identify cost drivers, and allocate cost to vehicle lines by market in IMPRS
• Prepare materials and lead review of liabilities with Global Controller, PWC and NA Accounting
• Lead freight cost submissions for Forward Model cycle plan studies including PD SoMP reviews
• Prepare and ensure correct segment reporting
• Special projects and assignments throughout the year
• Maintain Python/Alteryx workflows, and other analytical tools

Benefits

• Immediate medical, dental, vision and prescription drug coverage
• Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care and more
• Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more
• Vehicle discount program for employees and family members and management leases
• Tuition assistance
• Established and active employee resource groups
• Paid time off for individual and team community service
• A generous schedule of paid holidays, including the week between Christmas and New Year’s Day
• Paid time off and the option to purchase additional vacation time

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level