Financial Analyst, Supply Chain

Ford; Dearborn (MI); On-site; USD 65,000 - 166,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Paid time off

Flexible benefits program

Tuition assistance

Job summary

Ford Motor Company in Dearborn, MI seeks a Material Freight Lead Analyst to analyze freight costs, build data models, and drive network cost efficiencies within MP&L. This role partners with the NA Material Logistics team, supporting budgeting and year-over-year efficiency targets.

The candidate will develop models, prepare accruals, and lead regulatory reporting while maintaining Python/Alteryx workflows and collaborating with Global Controller and accounting teams.

Qualifications

• Bachelor's degree in accounting or finance required.
• Strong data analysis and modeling skills.
• Experience with data tools and financial planning is a plus.

Responsibilities

• Analyze large data sets to identify freight payment trends for forecasting and reporting.
• Understand logistics network operation, carrier contract economics and payment systems.
• Lead cost reduction initiatives and support budgeting and business planning.

Skills

Data analysis

SQL

Python

Alteryx

Excel

Interpersonal skills

Education

Bachelor's degree in accounting or finance

Tools

QlikView

Power BI

Tableau

Opencode

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)

You may not check every box, or your experience may look a little different from what we've outlined, but if you think you can bring value to Ford Motor Company, we encourage you to apply!

As an established global company, we offer the benefit of choice. You can choose what your Ford future will look like: will your story span the globe, or keep you close to home? Will your career be a deep dive into what you love, or a series of new teams and new skills? Will you be a leader, a changemaker, a technical expert, a culture builder...or all of the above? No matter what you choose, we offer a work life that works for you, including:

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