Description:
The Financial Analyst (Commercial Finance) analyzes and reviews all pricing, LTA, QS and recovery related topics and actively participates in preparing forecasts / budgets as well as in month end closing activities for related topics.
Primary Responsibilities:
- Work with regional sales teams on to be up to date with all pricing related topics (including LTA, QS, recovery and other type of price changes)
- Participation in audits of monthly net new business reporting
- Participation in annual sales budget reports preparation and supporting with fixing all noted issues
- Preparing adhoc reports as needed such as for the investor relations, treasury, communications, and SEC departments
- Tracking contractual and non-contractual LTA for North America, by customer, product line, and by operating division.
- Provide data for, and assist with, the preparation of monthly revenue accruals.
- Work closely with plants to understand, with each month’s actuals, what LTA has been implemented and what has been declared, but not yet hitting the financial statements.
- Report monthly activity for LTA, prepare monthly LTA roll-forward for Corporate and E&Y. Review with E&Y on a quarterly basis all LTA movements, roll-forwards, and reconciliation schedules.
- Meet weekly, with commercial teams, to understand all changes to both contractual and non-contractual LTA assumption implementation, and other pricing strategies.
- Analyze sales variances by OEM on a monthly, quarterly, and full year basis for actuals, forecast, and budget.
- Provide weekly development of sales releases, by plant, to support the weekly flash.
- Develop quarterly analysis, for Corporate Treasury, of revenue and material cost by foreign currency.
- Support of ongoing ad hoc requests for revenue, sales, and volume analysis. Stay current on Global OEM programs and trends
- Stay current on Global OEM programs and trends
- May, on occasion, be required to perform duties other than those specified in this description
Education and Qualifications:
- Bachelor’s degree is preferred or one to three years working in forecasting or finance
- Proficient in Microsoft Office Applications with emphasis on Excel and PowerPoint
- Knowledge of SAP BPC, Hyperion HFM, or similar consolidation software is preferred
- Prior experience in the automotive industry is preferred
- Ability to communicate effectively with internal cross-functional teams
- Strong project management skills and the ability to handle a variety of business issues on a daily basis
- Analytical thought process and decision making will be required
- Ability to bring issues to resolution quickly
- Willingness and ability to travel, as necessary