Ford Component Sales, LLC · 14 hours ago
Financial Planning & Analysis Analyst
Ford Component Sales, LLC (FCS) is a subsidiary of Ford Motor Company that focuses on revenue opportunities. They are seeking a Financial Planning & Analysis Analyst to collaborate with finance and sales teams to assist in forecasting, budgeting, and financial reporting processes.
AutomotiveCustomer ServiceElectronicsManufacturingProduct DesignSupply Chain ManagementTechnical Support
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
Qualification
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
Benefits
Medical
Dental
Vision
Paid holidays
401(k)
Disability
Tuition reimbursement assistance