Senior Market Research Analyst

ZF Group•Farmington Hills, MI

18d•Onsite

About The Position

The Senior Market Research Analyst will be primarily responsible for maintaining the Advanced Driver Assist Systems (ADAS) and High-Performance Computing (HPC) business unit sales and volume forecasts for OEM customers in North America. The position also supports various deliverables of the Market Planning department, which include vehicle production tracking, sales variance analysis, supporting new business acquisition, and competitive intelligence.

Requirements

Bachelor’s Degree in Finance, Management or a technical field
4-6 years prior experience in sales planning/forecasting, sales/account management, or financial forecasting
Very strong skills in Microsoft Excel (Pivot Tables, Slicers, VLookups) and Microsoft Powerpoint (Graphs/Charts, Embedded MS Files).
Proficiency in using Microsoft Excel

Nice To Haves

Prior experience with Power Apps and/or Power B.I. is preferred

Responsibilities

Updating/managing ADAS and HPC product line pricing/volume data using a combination of Microsoft Excel worksheets and the online Strategic Planning Tool.
Regularly meeting with Sales staff to review forecasted product line data and make appropriate updates, ensuring adherence to company guidelines.
Ensuring high quality and integrity of forecasted data and working with a global team to support milestones and deliverables. Working closely with Market Planning colleagues in other regions to ensure consistency in planning processes.
Conducting quarterly and ad-hoc variance analyses of forecasted product line sales/volume, and providing explanations of key forecast change drivers.
Assisting in tracking new business pursuit, making regular updates to quoted pricing and expected business award timing.
Supporting Sales and Portfolio teams with presentation materials created using forecasted data.