Business Analyst - Automotive

Job PurposeTo analyze and improve the performance of automotive dealership sales operations by delivering data-driven insights, forecasting trends, and supporting strategic decision-making.The role also incorporates project management responsibilities, ensuring that business improvement initiatives, process enhancements, and cross-functional projects are effectively planned, executed, and delivered to maximize revenue, operational efficiency, and customer satisfaction.Key ResponsibilitiesSales Performance AnalysisMonitor daily, weekly, and monthly sales performance across new and used vehicles against targets.Analyze sales trends across models, branches, and customer segments.Track conversion rates, enquiry sources, and lead aging to optimize the sales funnel.Identify performance gaps and recommend corrective actions.Forecasting & Market InsightsDevelop sales forecasts and demand plans using historical data and market intelligence.Conduct competitor benchmarking and market analysis to support pricing and promotional strategies.Identify emerging trends and provide forward-looking business insights.CRM & Lead ManagementAnalyze CRM data, including lead response times, follow-up effectiveness, and pipeline progression.Identify inefficiencies in lead handling and recommend process improvements.Support optimization of digital campaigns and lead generation performance.Inventory & Vehicle Allocation AnalysisMonitor stock levels by model, variant, color, and location to improve inventory turnover.Support vehicle allocation and inter-branch transfer strategies based on demand patterns.Identify stock aging risks and recommend corrective measures.Sales Process OptimizationMap and evaluate the end-to-end vehicle sales journey to identify bottlenecks.Collaborate with sales teams to streamline workflows, approvals, and customer touchpoints.Drive initiatives to enhance operational efficiency and customer experience.Project Management & ExecutionLead and coordinate cross-functional projects related to sales performance improvement, process optimization, and business transformation.Define project scope, timelines, milestones, and deliverables aligned with business objectives.Track project progress, manage risks/issues, and ensure timely delivery.Facilitate project meetings, stakeholder updates, and escalation management.Ensure initiatives are executed in line with strategic priorities and measurable outcomes.Reporting & DashboardsDevelop and maintain dynamic dashboards for Sales Managers and leadership.Prepare daily, weekly, and monthly performance reports with actionable insights.Provide executive-level summaries and presentations for decision-making.Customer Behavior & RetentionAnalyze customer purchase behavior, repeat sales, trade-ins, and segmentation trends.Support development of loyalty programs and retention strategies.Provide insights to enhance customer lifecycle management and engagement.Collaboration & Stakeholder ManagementCollaborate with Sales, Finance, Marketing, IT, and Operations teams to align analytics with business needs.Act as a key liaison between data, business functions, and leadership.Support strategic initiatives such as dealership expansion, network optimization, and new model launches.Governance & Continuous ImprovementEnsure accuracy, consistency, and integrity of data across systems and reports.Establish standardized reporting frameworks and processes.Drive continuous improvement initiatives across sales operations and performance management.Required Qualifications & Experience3–5 years of experience in a Business Analyst, Sales Analyst, or Commercial Analyst role within:Automotive dealerships or authorized distributorsAutomotive OEMs (supporting dealer network sales)Must have strong finance backgroundProven experience in managing or supporting cross-functional projectsTechnical SkillsAdvanced MS Excel (formulas, pivot tables, dashboards)Data visualization tools (Power BI, Tableau, or equivalent)CRM systems (Salesforce, AutoMate, CDK, or similar)Dealer Management Systems (DMS) (AutoLine, Kerridge, SAP DMS, etc.)Core CompetenciesAnalytical & Data-Driven ThinkingProject Management & ExecutionSales & Commercial AcumenProcess OptimizationStakeholder Management & CollaborationProblem Solving & Decision SupportCommunication & Presentation SkillsAttention to Detail & Delivery DisciplineApplicants are requested to share their most recent resume.We thank all applicants for their interest.However, only those qualified individuals who closely meet the qualifications of the position will be contacted. The details of the position are only a summary; other duties may be assigned as necessary.