Financial Analyst, MP&L

Ford-Motor-Company; Dearborn (MI); Hybrid; USD 87,000 - 145,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Paid time off

Tuition assistance

Vehicle discount program

Employee resource groups

Job summary

Ford Motor Company is seeking a Material Freight Lead Analyst to partner with the MP&L Controller’s Office in Dearborn, MI. The role focuses on understanding freight costs, building data models, and identifying efficiencies to ensure timely material delivery and optimized freight spend.

The ideal candidate has a bachelor’s degree in accounting or finance and at least five years of relevant experience, with strong analytical and communication skills.

Qualifications

• Bachelor’s degree in accounting or finance.
• At least 5 years of relevant experience.
• Strong analytical and communication skills.
• Ability to work independently and manage multiple assignments.

Responsibilities

• Analyze freight data to track trends and costs.
• Collaborate with NAML on logistics and contracts.
• Lead cost-saving initiatives and budget analyses.
• Maintain Python/Alteryx workflows.
• Prepare accruals and segment reporting.
• Support Liabilities reviews with Global Controller and others.

Skills

Data modeling

Python

Alteryx

MS Excel

Communication

Analytical thinking

Education

Bachelor's degree in accounting or finance

Tools

QlikView

Power Apps

Tableau

Power BI

Job description

We made history and now we work to transform the future – for our customers, our communities and our families. You'll see your work on the road every day, helping people move freely and pursue their dreams. At Ford, you can build more than vehicles. Come build what matters.

Finance strategically partners with operations to drive outstanding business results and enhance Ford’s industry leadership. When you join us, you’ll be able to contribute financial expertise that impacts all areas of our company, including planning, manufacturing, marketing and global distribution.

In this 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.

What you'll do...

• 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

You’ll have...

• 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

Even better, you may have...

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

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.

This position is a salary grade 5 and ranges from $65,100-$109,300.

This position is a salary grade 6 and ranges from $74,300-$124,500.

This position is a salary grade 7 and ranges from $86,600-$144,900.

This position is a salary grade 8 and ranges from $99,100-$166,200.

Final determination of salary grade will be based on candidate's skills and experience, and base salary will be set within the applicable range according to job scope, responsibility and competitive market value.
Internal applicants: moving into this role may result in an adjustment to your current compensation based on the posted pay range for this role, taking into consideration your qualifications and other relevant factors.

For more information on salary and benefits, click here: https://fordcareers.co/GSR
Visa sponsorship is not available for this position.

Candidates for positions with Ford Motor Company must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire.
We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status. In the United States, if you need a reasonable accommodation for the online application process due to a disability, please call 1-888-336-0660.

This position is hybrid with a requirement to be onsite four or more days per week. #LI-Hybrid #LI-JB5