Ford Motor Company is seeking to perform in-depth analysis and modeling of used vehicle residual values, auction prices, and market drivers for the U.S. and Canadian used vehicle markets to support key business processes through accurate forecasting, quantifying value gaps, and providing actionable insights to management and business customers.
Requirements
- 1+ years of experience conducting statistical analysis in a business or academic setting
- 1+ years of experience with one or more of the following tools: Data Gathering & Analysis skills/tools (e.g. SAS, Python, SQL, BigQuery, Alteryx, etc.) AND Visualization skills/tools (e.g. Qlik Sense, Tableau, Power BI, etc.)
- Experience with Excel and PowerPoint
- Proficiency in Python for data analysis and model development
- Familiar with various modeling methodologies, including economics, econometrics, statistics, and data mining
- Be able to utilize all major modeling techniques as applied to short and long-term volume and price forecasts
- Be able to quickly convert a real business requirement into a solvable modeling problem, sort out relevant information, and judge the solution against business reality
Responsibilities
- Perform in-depth analysis and modeling of used vehicle residual values, auction prices, and market drivers
- Develop and maintain models to quantify the relationship between auction prices and key used vehicle residual value drivers
- Provide used vehicle residual value forecasting to support key business processes
- Quantify and decompose used vehicle residual value gaps between brands and vehicles
- Provide data analysis visualization and prepare presentation materials to share with management and business customers
- Apply and integrate latest analytical tools and data sources to more accurately model used vehicle prices
- Execute both descriptive and inferential ad hoc requests for management and business customers in a timely manner
Other
- Ability to effectively communicate, both verbal and written, across different levels of the organizations
- Have excellent time management skills and be able to handle working on multiple projects at the same time
- Be able to make reasonable judgments and conclusions with limited information and resources
- Be aspirational and curious in technical excellence and innovation
- Have a lifetime learning attitude
