Business Analyst

Bhanzu; Bengaluru; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Bhanzu is seeking a Business Analyst with hands-on Salesforce CRM experience and strong Excel/Google Sheets proficiency to support reporting, sales funnel analysis, and business performance tracking. You will collaborate with the Head of International Sales to analyze funnels, identify performance gaps, and deliver actionable insights across international markets.

Responsibilities include building Salesforce reports and dashboards, maintaining lead movement tracking, and driving revenue

Qualifications

• Hands-on Salesforce CRM experience with report creation and dashboards.
• Strong Excel/Google Sheets skills: pivot tables, charts, advanced lookups, SUMIFS/COUNTIFS.
• Experience in cleaning, validating, reconciling data, handling large datasets.

Responsibilities

• Own daily, weekly, and monthly reporting across countries, categories, teams, and sales reps.
• Build and maintain Salesforce reports and dashboards for lead movement, activities, conversions, revenue.
• Analyse the sales funnel from lead allocation to enrolment and payment.
• Identify conversion gaps and growth opportunities by lead source, geography, and sales cohort.
• Build and automate Excel/Sheets dashboards to improve accuracy and reduce manual reporting.
• Track lead ageing, follow-up adherence, and sales cycle duration.
• Support revenue forecasting, target planning, and business reviews with clear recommendations.
• Validate Salesforce data and coordinate corrections for inconsistencies.
• Evaluate campaigns, pricing changes, offers, and sales initiatives.

Skills

Salesforce CRM

Excel/Sheets

Data cleaning

Sales funnel analysis

Stakeholder comms

Data visualization

Tools

Salesforce Dashboards

Pivot tables

XLOOKUP/VLOOKUP

Job description

Bhanzu is looking for a Business Analyst with hands-on experience in Salesforce CRM and strong proficiency in Excel or Google Sheets to support reporting, sales funnel analysis, and business performance tracking. You will work closely with the Head of International Sales to analyse sales funnels, identify performance gaps, and deliver actionable insights across international markets.

Responsibilities

• Own daily, weekly, and monthly reporting across countries, categories, teams, and individual sales representatives.
• Build and maintain Salesforce reports and dashboards to track lead movement, sales activities, conversions, revenue, and target achievement.
• Analyse the sales funnel from lead allocation and connectivity to demo booking, demo completion, enrolment, and payment.
• Identify conversion gaps and growth opportunities by lead source, customer segment, grade group, geography, and sales cohort.
• Build and automate Excel or Google Sheets dashboards to improve accuracy and reduce manual reporting.
• Track lead ageing, follow-up adherence, sales productivity, revenue per enrolment, and sales cycle duration.
• Support revenue forecasting, target planning, and business reviews with clear recommendations.
• Validate Salesforce data and coordinate corrections for missing or inconsistent records.
• Evaluate the impact of campaigns, pricing changes, offers, and sales initiatives.

Preferred Skills

• Hands-on experience with Salesforce CRM, including report creation, dashboards, filters, and data extraction.
• Strong proficiency in Excel or Google Sheets: pivot tables, charts, XLOOKUP/VLOOKUP or INDEX-MATCH, SUMIFS/COUNTIFS, logical formulas, and date functions.
• Experience in data cleaning, validation, and reconciliation, with the ability to handle large datasets and build reusable reports.
• Ability to analyse sales funnels, conversion rates, revenue trends, and team productivity.
• Strong analytical thinking, attention to detail, ownership, and stakeholder communication.
• Ability to translate data into clear, actionable business recommendations.