Financial Analyst at Ford Pro in 6100 Mercury Dr, Dearborn, MI, 48126

Summary: Ford Pro is a company that strategically partners with operations to drive business results and enhance industry leadership. They are seeking a Financial Analyst to analyze data, develop financial models, and support logistics operations to optimize freight costs within the network. Responsibilities: - Analyze large amounts of data (using data modeling tools) from various sources to identify freight payment trends to support tracking, forecasting, and reporting of freight expense - Work in conjunction with NAVL to understand logistics network operation, carrier contract economics, and payment authorization systems - Participate in continuous improvement roadmap discussions with NAVL to identify and implement network savings to meet annual efficiency and premium freight objectives - Assist with development of Budget and Business Plan financials and provide analysis to support Year-over-Year efficiency and premium freight targets - Prepare vehicle freight accrual, identify cost drivers, and allocate cost to vehicle lines by market in IMPRS - Prepare materials and lead review of liabilities with Global Controller, PWC and NA Accounting - Lead vehicle freight cost submissions for Forward Model cycle plan studies including PD SoMP reviews - Prepare and ensure correct segment reporting - Special projects and assignments throughout the year - Maintain Alteryx workflows, and other analytical tools Required Qualifications: - Bachelor's degree in Accounting or Finance - Strong interpersonal and communication skills; ability to develop strong, positive working relationships with the MP&L operating team and other organizations - Strong analytical and problem-solving skills; ability to work with and organize large amounts of data - Ability to work independently and manage multiple assignments - Ability to reassess and adapt schedule to changing priorities - Possess a process improvement mindset; implement new methods and ideas - Proficiency with MS Excel and opportunity to learn new data modeling software (e.g., QlikView, Tableau) Preferred Qualifications: - Proficiency in data modeling and visualization software such as Alteryx, QlikView, or Tableau - Knowledge of Power Apps and Power BI - Experience understanding logistics network operations or carrier contract economics - Familiarity with Ford-specific systems like IMPRS or the PD SoMP review process - Experience preparing materials for and leading reviews with external auditors (e.g., PWC) or Global Controllers Required Skills: Data modeling, Alteryx, QlikView, Tableau, MS Excel, Power Apps, Power BI, Logistics network operations, Carrier contract economics, IMPRS, PD SoMP review process, Financial analysis, Budget and Business Plan financials, Process improvement mindset Benefits: Immediate medical, dental, vision, and prescription drug coverage, Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care, and more, Family building benefits, including adoption and surrogacy expense reimbursement, fertility treatments, and more, Vehicle discount program for employees and family members, and management leases, Tuition assistance, Established and active employee resource groups, Paid time off for individual and team community service, A generous schedule of paid holidays, including the week between Christmas and New Year’s Day, Paid time off and the option to purchase additional vacation time.