Business Data Analyst – (Automotive Business)

We are seeking a highly analytical and detail-oriented Aftersales Data Analyst to drive our aftersales business forward. In this role, you will be responsible for collecting, consolidating, and analyzing operational data across our 3 branches. You will transform raw numbers into actionable insights and build dashboards that empower our management team to optimize workshop efficiency, improve parts inventory management, and uncover new revenue opportunities. Key Responsibilities: 1. Data Management & Reporting Collect, consolidate, and report daily, weekly, monthly, and quarterly aftersales performance data across all 3 branches. Develop, maintain, and update interactive dashboards to monitor key performance indicators (KPIs) for Service, Workshop, and Parts operations. Track overall branch performance and compare actual results against monthly, quarterly, and annual targets. 2. Operations & Performance Analysis Workshop Performance: Analyze vehicle intake, repair types, turnaround time, workshop productivity/efficiency, and quality metrics (e.g., comeback jobs, repeat repairs). Parts & Inventory: Monitor parts sales, inventory turnover, stock accuracy, and inventory aging to support optimal stock planning and fill rates. Warranty & Claims: Track warranty job volumes, claim values, processing timelines, and analyze abnormal repair or rework cost trends. 3. Strategic Support & Forecasting Identify performance gaps, operational trends, and new opportunities to increase service and parts revenue. Provide data-driven insights to support revenue forecasting, parts demand planning, and target setting for each branch and department. Evaluate the effectiveness of aftersales promotions, service campaigns, and customer retention programs. Must-have Requirements: Bachelor’s degree in Business Administration, Marketing, Economics, Statistics, Data Analytics, or a related field. Minimum 3 years of experience in sales analysis, business analysis, data analysis, or sales support. Strong analytical and numerical skills with the ability to interpret raw data and convert it into meaningful, business-focused insights. High proficiency in Microsoft Excel (including Pivot Tables, charts, and data analysis functions). Excellent communication and presentation skills, with strong attention to detail and the ability to meet strict deadlines.