Data Analyst – Sales & Business Analytics

Simple Energy; Bengaluru; Presencial; INR 600 000 - 900 000; Tempo integral

Resumo da oferta

Simple Energy in Bengaluru is seeking a Data Analyst for Sales and Business Analytics to turn sales, customer, and dealership data into actionable insights that enhance vehicle sales, RSA, Extended Warranty and accessories revenue. The role collaborates with Sales, Dealer Network, Finance, Service, Customer Care and Business teams to monitor performance and drive data-informed decisions.

The ideal candidate will have strong analytical ability, excellent Excel and BI skills, and the capability to

Qualificações

• 2–5 years of experience in data analytics or related field.
• Strong proficiency in Excel and BI tools.
• Ability to translate data into clear business insights and actions.

Responsabilidades

• Monitor and analyze sales, dealer network, and product data to drive decisions.
• Develop dashboards and reports for management review.
• Track KPIs such as sales, RSA, EW, and accessories performance.
• Collaborate with Sales, Finance, Service and Marketing to improve data quality and governance.
• Support data-driven planning for dealer network and campaigns.

Conhecimentos

Analytical skills

BI capabilities

Data storytelling

Formação académica

Bachelor's degree in a quantitative field

Ferramentas

Power BI

Excel

Descrição da oferta de emprego

Job Description – Data Analyst- Sales & Business Analytics

Location: Bengaluru

Experience: 2–5 years
Employment Type: Full-time

Role Purpose

We are looking for a Data Analyst – Sales & Business Analytics who will be responsible for converting sales, customer and dealership data into actionable insights to improve vehicle sales, RSA, Extended Warranty and Accessories business.

The role will work closely with Sales, Dealer Network, Finance, Service, Customer Care and Business teams to monitor business performance, identify gaps, track KPIs and drive data-based decision-making across the dealer network.

The ideal candidate should have strong analytical skills, excellent Excel/BI capabilities and the ability to translate data into clear business actions.

Key Responsibilities

1. Vehicle Sales Analytics
   • Track daily, weekly and monthly retail, wholesale, enquiry, booking and conversion performance.
   • Monitor dealership-wise, region-wise and model-wise sales performance.
   • Analyse enquiry test ride booking retail funnel.
   • Identify dealerships with performance gaps and highlight corrective actions.
   • Track sales targets vs. achievement and provide regular performance reports.
   • Analyse market, product and dealer-level trends to support sales planning.
   • Develop dashboards for management review.
2. RSA Business Analytics
   • Track RSA penetration dealership-wise, region-wise and salesperson-wise.
   • Monitor RSA attachment at the time of vehicle sale.
   • Identify dealerships with low RSA penetration and analyse reasons.
   • Track RSA sales, revenue and monthly trends.
   • Monitor RSA renewal opportunities and customer retention.
   • Prepare dealer-wise RSA performance rankings for review.
   • Work with Sales and Service teams to improve RSA penetration.
3. Extended Warranty Analytics
   • Track Extended Warranty attachment rate at vehicle retail.
   • Monitor dealer-wise and salesperson-wise EW performance.
   • Analyse EW penetration by model, geography and customer segment.
   • Track warranty expiry pipeline and identify renewal opportunities.
   • Monitor revenue generated through Extended Warranty.
   • Identify dealerships with low EW conversion and recommend corrective actions.
   • Create monthly EW performance dashboards.
4. Accessories Business Analytics
   • Track Accessories sales and revenue by dealership, model and region.
   • Monitor accessory attachment per vehicle.
   • Analyse popular and slow-moving accessories.
   • Track Accessories NDP / MRP / dealer margins, wherever applicable.
   • Identify opportunities to increase accessory penetration.
   • Monitor dealer-wise performance against accessory targets.
   • Analyse customer buying patterns and recommend accessory bundles/packages.
   • Support Sales teams with data for accessory upselling.
5. Dealer Performance Analytics
   • Develop a comprehensive Dealer Performance Dashboard covering:
     • Retail
     • Enquiries
     • Test Rides
     • Conversion
     • RSA
     • Extended Warranty
     • Accessories
     • Customer Experience / NPS
     • Target vs Achievement
   • Create dealer segmentation based on business performance.
   • Identify high-potential dealerships and underperforming dealerships.
   • Track action plans and measure improvement after interventions.
6. Sales Funnel & Customer Analytics
   • Analyse customer journey from Lead Enquiry Test Ride Booking Retail RSA/EW/Accessories.
   • Identify drop-offs at each stage of the funnel.
   • Analyse salesperson-level conversion.
   • Track repeat customers and referral opportunities.
   • Generate insights on customer behaviour and buying patterns.
7. MIS & Management Reporting
   • Prepare daily, weekly and monthly MIS for Sales & Distribution leadership.
   • Develop automated dashboards and reports to reduce manual reporting.
   • Provide business insights for monthly and quarterly reviews.
   • Highlight key deviations, trends and opportunities rather than only reporting numbers.
   • Prepare data for dealer reviews, regional reviews and management meetings.
8. Incentive & Campaign Analytics
   • Track dealer and salesperson performance against incentive schemes.
   • Measure the effectiveness of sales campaigns and promotional offers.
   • Analyse incremental sales generated through campaigns.
   • Calculate dealer eligibility for various incentive programs.
   • Provide post-campaign performance analysis and ROI insights.
9. Data Quality & Process Improvement
   • Ensure accuracy and consistency of data across DMS, CRM, ERP and other business systems.
   • Identify data gaps, duplication and inconsistencies.
   • Work with IT/DMS teams to resolve data-related issues.
   • Establish standard reporting formats and definitions for key KPIs.
   • Automate repetitive reports wherever possible