Financial Planning & Analysis Analyst

FORD COMPONENT SALES•Dearborn, MI

About The Position

Ford Component Sales, LLC (FCS) is a wholly owned subsidiary of Ford Motor Company aligned with the Ford Customer Service Division (FCSD). We are a flexible sales organization that directs resources toward revenue opportunities identified by FCSD. We are in search of a Financial Planning & Analysis Analyst that collaborates with finance, sales, and department managers to analyze and assist in the divisional forecasting and budgeting functions which will include providing financial analysis on a regular basis and assisting the business units with the preparation and interpretation of monthly financial analysis reports. Support the operations and finance teams to drive financial reporting processes, product line profitability models, trend analyses, and ad hoc reports.

Requirements

Bachelor’s degree in finance, accounting, economics, or related field
At least five years of finance, business analytics, or planning experience required
Strong Microsoft Excel experience is a must, including the use of V-Lookups, formulas, and database functions
Excellent analytical, financial modeling, and presentation skills
Must have a thorough understanding of advanced financial analysis techniques using spreadsheet software as well as specialized financial forecasting
Communicates well both orally and in writing

Responsibilities

Collects financial and operating results from company systems and databases and integrates results into forecast development and performance monitoring reports
Performs monthly analysis of the major material commodities, analyzing prior period trends and forward estimates to determine the impact on the business unit
Prepares volumes and cost analysis and incorporate into forecasts
Designs reports that present both actual and budget data in a concise manner for use by management in decision making
Performs/assists with audits as required (supplier, processes, etc.)
Assists with implementation of the budget and business plans
Analyzes budget and business plan through various comparison and variance reports (metrics)
Works with both finance and business managers to makes changes where necessary
Develops comparisons between budget/actual/forecast
Prepares PowerPoint slides and graphs related to budget/actual/forecast for BPR meeting
Analyzes and defines requirements for data, workflow, logical processes, and control
Adheres to Ford Finance Manual
Other duties may be assigned