Financial Planning & Analysis Analyst

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. ESSENTIAL FUNCTIONS 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 EDUCATION AND EXPERIENCE To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. 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 We offer an attractive and competitive compensation and benefits package, which includes medical, dental, vision, paid holidays, 401(k), disability, and tuition reimbursement assistance. If you take pride in your work and are committed to personal and professional success, we want to talk to you. Please visit www.fordcomponentsalesllc.com to learn more. FCS is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law