Senior Data Analyst - FCSD

Senior Data Analyst - FCSD 

We made history and now we work to transform the future – for our customers, our communities and our families. You'll see your work on the road every day, helping people move freely and pursue their dreams. At Ford, you can build more than vehicles. Come build what matters.

In this position... 

We are seeking a highly skilled and motivated Senior Data Analyst to join the Ford Customer Service Division. In this critical role, you will be instrumental in transforming complex data into actionable insights, driving strategic decisions that enhance our customer service operations and optimize parts sales performance. You will leverage your expertise in data analysis, visualization, and cloud-based platforms to support various stakeholders across the organization.

What you'll do...

• Data Analysis & Reporting: Perform in-depth analysis of customer service data and parts sales performance. Develop and maintain regular reports and dashboards to monitor key metrics, identify trends, and provide comprehensive insights to business leaders.
• KPI Monitoring & Optimization: Track and analyze Key Performance Indicators (KPIs) related to parts sales, including: 
  • Retail "sell-out" from dealerships to end customers.
  • "Sell-in" to dealers (dealer wholesale).
  • "Sell-in" to Ford Automotive Distributors (FADs) covering sales to dealerships and the overall aftermarket.
  • Identify drivers behind performance fluctuations and recommend strategies for improvement.
• Parts Pricing: Able to support PCM analysis to inform parts pricing as needed. 
  • Understand price strategies and ability to prepare pricing scenarios
• Independent Repairers: Supports programs which rely on invoice data and the ability to curate the data for reporting, insights and strategy development. 
  • Able to perform data matching / de-duping in order to provide the appropriate insight
• Dashboard Development: Design, develop, and maintain interactive and user-friendly dashboards using Qlik Sense, enabling business users to explore data independently and make informed decisions.
• Data Pipeline & Architecture: Maintain robust data pipelines and workflows using Alteryx. Lead the migration of existing Alteryx workflows to Google-based products, ensuring data integrity and efficiency.
• Cloud Data Management: Work extensively within the Google Cloud Platform (GCP), creating and managing tables in Google BigQuery to support analytical needs and reporting requirements.
• Insight Generation: Proactively identify opportunities for data-driven improvements in customer service processes and parts sales strategies. Translate complex analytical findings into clear, concise, and actionable recommendations for various business stakeholders.
• Stakeholder Collaboration: Build strong, collaborative relationships with internal customers (business leads) to understand their data needs, gather requirements, and deliver tailored analytical solutions.
• Team Collaboration: Work closely with members of the Global Data, Analytics and Insights team to ensure consistency, leverage best practices, and contribute to the overall data strategy of the company.
• Data Quality & Governance: Ensure the accuracy, reliability, and consistency of data used for analysis and reporting.

Key Performance Indicators (KPIs) for Success in this Role:

• Timeliness and accuracy of parts sales reporting (sell-out, dealer wholesale, FAD sell-in).
• Impact of insights on customer service efficiency and parts sales growth.
• Efficiency and reliability of data pipelines and dashboards.

You'll have...

• Bachelor’s degree in data science, Statistics, Computer Science, Business Analytics, Finance, or a related quantitative field.
• 5+ years of progressive experience as a Data Analyst, preferably in the automotive industry or a related customer service/parts environment.
• 5+ years of experience using statistical analysis techniques and data modeling principles.
• 5+ years of experience translating complex data into clear, concise, and actionable business insights for non-technical audiences.
• 3+ years of experience using Alteryx for data blending, transformation, and workflow automation.
• 3+ years of experience using Qlik Sense for dashboard development, data visualization, and reporting.

Even better, you may have...

• Master's degree preferred.
• Proven experience with Google Cloud Platform (GCP) services, particularly with Google BigQuery for data warehousing and querying.
• Demonstrated ability to migrate and optimize data processes between different platforms (e.g., Alteryx to GCP).
• Advanced SQL skills for data extraction, manipulation, and analysis.
• Excellent analytical, problem-solving, and critical thinking skills.
• Strong communication (written and verbal) and presentation skills.
• Exceptional attention to detail and organizational skills.

You may not check every box, or your experience may look a little different from what we've outlined, but if you think you can bring value to Ford Motor Company, we encourage you to apply!

As an established global company, we offer the benefit of choice. You can choose what your Ford future will look like: will your story span the globe, or keep you close to home? Will your career be a deep dive into what you love, or a series of new teams and new skills? Will you be a leader, a changemaker, a technical expert, a culture builder…or all of the above? No matter what you choose, we offer a work life that works for you, including:

• 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. 

This position is leadership level 6 and ranges from $112,680-212,760.

Final determination of salary grade will be based on candidate's skills and experience, and base salary will be set within the applicable range according to job scope, responsibility and competitive market value.

For more information on salary and benefits, click here: https://fordcareers.co/LL6

Visa sponsorship is not available for this position.

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.

We are an Equal Opportunity Employer. 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. In the United States, if you need a reasonable accommodation for the online application process due to a disability, please call 1-888-336-0660.

This position is hybrid. Candidates who are in commuting distance to a Ford hub location may be required to be onsite four or more days per week. #LI-Hybrid #LI-MK1