Sales and Reporting Analyst

Ford Motor Company; Pretoria; On-site; ZAR 200,000 - 300,000; Full time

Job summary

A leading automotive company in Pretoria is looking for a candidate to handle sales and analytical reporting. The ideal applicant will possess a Bachelor's degree and have at least 3 years of relevant experience, along with strong skills in Excel and communication. Responsibilities include data reporting and supporting dealers with queries. This position offers an excellent opportunity to contribute to a forward-thinking team.

Qualifications

• Minimum 3 years of Sales and Analytical Reporting Experience.
• Insurance Background is an advantage.

Responsibilities

• Accurate and on-time data reporting.
• Coordinate regular data extracts from contract systems.
• Response time to dealer and customer queries.

Skills

Data reporting

Advanced Excel skills

Excellent Communication Skills

Alteryx data systems

Education

3 Year Diploma or Bachelor's degree

Job description

Overview

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

Responsibilities

• Accurate and on time data reporting
• Daily, weekly and Monthly task driven assign
• Response time to dealer and customer queries
• Advanced Excel skills
• Advanced PowerPoint Skills
• Excellent Communication Skills
• Alteryx data systems (Advantage)
• Insurance Background
• Supporting dealers in product queries and training if required
• Supporting dealers in portal queries
• Following on incorrect policies sold to F&I’s
• Cancellation of policy letters to customers on Ford Protect Products
• PO Creation on Ariba
• Approving Invoices from suppliers
• New Supplier onboarding process
• Product Costing
• New Plan Request Form completion for new products
• Completion of Pricing sheet for dealer portals
• Responsible for Dealer Portal testing on codes, pricing, M&M codes, contract wording
• Customer complaints
• Responsible for ensuring pricing update and testing is concluded on third party platforms when FMCSA does pricing reviews
• Responsible for updating portals with M&M codes when we have new launches on different vehicles
• Create, review and edit sales brochures as required on website and sign off on Ford Protect content. Update third parties when revised
• Responsible for updating Dealer View to ensure updated content on marketing assets.
• Coordinate regular data extracts from contract systems to internal users and external users.
• Providing claims data for products cost
• Supporting with claims analysis reporting
• Coordinate with ESB finance team for claims cost analysis.
• Provide support for strategy development and other tasks as requested by the management team.

Qualifications

• 3 Year Diploma / bachelor’s degree or equivalent
• 3 years Sales and Analytical Reporting Experience
• Insurance Background (Advantage)

About Us

For more information, see Ford Motor Company’s mission and values and our commitment to mobility and customer experience.

About The Team

Marketing, Sales & Service plays an important role in Ford’s revitalization as a modern, progressive vehicle and mobility services company delivering a trusted customer experience. Candidates should have a vast depth of knowledge and expertise in implications of data and taking actions based on those, as well as have a passion for the lifetime value of a customer. Ford MS&S embraces an audience-first mindset and way of doing business that improves customer loyalty, vehicle repurchase, as well as additional sales of vehicles, parts, accessories and services. We are the eyes, ears and voices of Ford, meeting customer demand by delivering the right products to the right dealers at the right time.