Sales and Reporting Analyst

Ford Motor; Pretoria; On-site; ZAR 360,000 - 480,000; Full time

Job summary

An automotive company is seeking a Full-Time Analyst in Pretoria to support dealers and manage analytical tasks. Key responsibilities include reporting on claims data, assisting with dealer queries, and maintaining product information across various platforms. A bachelor's degree and extensive experience in analytical reporting are required, along with strong Excel and data analysis skills.

Qualifications

• 3 years Sales and Analytical Reporting Experience.
• Insurance Background is an advantage.
• Strong technical skills in data reporting and analysis.

Responsibilities

• Supporting dealers in product queries and training.
• Managing product costing and supplier onboarding.
• Ensuring timely completion of pricing updates on platforms.

Skills

Advanced Excel skills

Excellent Communication Skills

Data Analysis Skills

Power BI

Cognos

Education

3 Year Diploma / Bachelor's degree

Tools

SQL

Tableau

Crystal Reports

Microsoft Access

Job description

Description

• 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

Responsibilities

Supporting dealers in product queries and training if required

Supporting dealers in portal queries

Following on incorrect policies sold to F&Is

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 / bachelors degree or equivalent

3 years Sales and Analytical Reporting Experience

Insurance Background (Advantage)

Required Experience :

Key Skills

Cognos,Microsoft Access,SQL,Crystal Reports,Financial Report Writing,Power BI,Pivot tables,ssrs,Tableau,Regulatory Reporting,SAS,Data Analysis Skills

Employment Type : Full-Time

Experience : years

Vacancy : 1