Financial Analyst, Supply Chain

Lincoln Motor Company; Dearborn (LA); Hybrid; USD 65,000 - 166,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Parental leave

Tuition assistance

Vehicle discount program

Job summary

Ford Motor Company in the United States is seeking a Material Freight Lead Analyst to partner with MP&L and NA Logistics. You will analyze freight costs, build data models, and drive cost efficiencies to ensure timely material delivery.

The role requires a Bachelor’s in accounting/finance with 5+ years of experience, strong analytical and communication skills, and the ability to work independently in a hybrid on-site environment four days per week.

Qualifications

• Bachelor's degree in accounting or finance is required.
• At least 5 years of relevant experience.
• Strong interpersonal and communication skills with cross-functional teams.
• Strong analytical and problem-solving abilities with large data sets.
• Ability to work independently and manage multiple assignments.

Responsibilities

• Analyze large amounts of data from various sources to identify freight payment trends for tracking, forecasting, and reporting.
• Collaborate with NAML to understand logistics network operation, carrier contracts, and payment systems.
• Participate in continuous improvement discussions to identify network savings and efficiency targets.
• Assist with Budget and Business Plan financials and provide YoY efficiency analysis.
• Prepare material freight accruals, identify cost drivers, and allocate costs by vehicle lines.
• Lead review of liabilities with Global Controller, PWC and NA Accounting.
• Lead freight cost submissions for Forward Model cycle studies and PD SoMP reviews.
• Ensure correct segment reporting and support ad-hoc projects.
• Maintain Python/Alteryx workflows and other analytical tools.

Skills

Data analysis

Communication skills

Analytical thinking

Independent work

Time management

Education

Bachelor's degree in accounting or finance

Tools

MS Excel

QlikView

Power Apps

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,

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

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.