US Complexity Reduction Analyst

At Ford Motor Company, we believe freedom of movement drives human progress. We also believe in providing you with the freedom to define and realize your dreams. With our incredible plans for the future of mobility, we have a wide variety of opportunities for you to accelerate your career potential as you help us define tomorrow’s transportation.

Working within our Marketing, Sales & Service organization gives you the opportunity to advance the Ford reputation as a visionary vehicle and mobility services company delivering a trusted customer experience. We’re looking for insightful individuals with the marketing, sales and service expertise to turn data-driven insights into innovative solutions that enhance sales and customer loyalty. If you have an audience-first mindset, join us and be the eyes, ears and voice of Ford.

What you’ll be able to do:

• Deliver analytics to support the corporate strategy to re-frame inventory and deliver stock order complexity reduction.
• Drive metrics to identify new business opportunities and changing market conditions to enable data-driven decision making.
• Key member of the team responsible for an enterprise-wide approach to data management and reporting.
• Develop, design, improve, and generate contact center reports for end users taking highly complex information and producing user-friendly reports
• Ensure the integrity of reports and 100% accuracy of all reports and anticipate the development of all new reports and report improvements
• Provide organizational training for new users, training on new reports/report improvements, and continued organizational awareness of reports availability
• Provide production support through problems analysis and resolution to correct deficiencies within reporting applications
• Seek out new opportunities to evaluate data through the utilization of new technologies and tools
• Actively participate in call routing discussions to identify data collection and reporting needs.
• SME in terms of process and data collection for all applications
• Provide training and support in basic MS Office programs, Mail Merge and other programs as needed
• Analyze and interpret reports to identify performance gaps
• Develop procedures and operating instructions for all reporting processes and applications
• Work Environment and Personnel Development
• Must be comfortable working remotely and with minimal day-to-day direction
• Build a positive work environment that fosters successful team performance
• Build skill sets and continue to develop proficiency of the department’s systems and miscellaneous
• Work on activities and/or projects as requested by senior leadership or field leadership
• Provide support and troubleshooting pertaining to dashboard, reporting and mail merge errors
• Support requests for data extrapolation as requested by department managers and their teams
• Must be available to work varied shifts.

The minimum requirements we seek:

• Bachelor's degree
• 3 years of experience in data and reporting analyst
• 5 years of experience in Microsoft Excel to include VBA, macros, pivot tables, SharePoint Reporting and Access Databases

Our preferred requirements:

• Zone Manager or Dealer contact experience helpful - strong understanding of key Ford systems.
• Strong analytical ability required
• Must be able to draw conclusions from raw data and summarize results quickly and efficiently
• Advanced Excel formulas, Pivot Tables, Charting/Visualizations, Reporting, and Dashboard building
• Proven experience with MS office suite including Excel, Word, PowerPoint, Visio, Access
• Excellent written and verbal communication skills to communicate effectively across a management levels
• Good problem-solving skills - able to creatively resolve complex situations
• Proven ability to manage multiple, concurrent activities
• Proven ability to perform in a fast-paced environment and with minimal direction
• Strives to create a supportive environment conducive to continuous improvement
• Translates problems into practical solutions
• Provide excellent customer service for internal and external customers on questions and issues.
• Provide follow up reporting for a variety of program initiatives.

What you’ll receive in return:

As part of the Ford family, you’ll enjoy excellent compensation and a comprehensive benefits package that includes generous PTO, retirement, savings and stock investment plans, incentive compensation and much more. You’ll also experience exciting opportunities for professional and personal growth and recognition.

If you have what it takes to help us redefine the future of mobility, we’d love to have you join us.

Candidates for positions with Ford Motor Company must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire.

Visa sponsorship is not available for this position.

We are an Equal Opportunity Employer committed to a culturally diverse workforce. All qualified applicants will receive consideration for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability status or protected veteran status.