Website Vedanthu

Business Data Analyst – Vedantu

Opportunity Overview

Attribute Details
Organization Vedantu (EdTech / LIVE Learning Platform)
Position Title Business Data Analyst
Experience Requirement 1 – 2 Years in Business / Data Analytics
Primary Location Bengaluru, Karnataka, India
Department / Team Business Intelligence & Analytics
Employment Type Full-Time, Permanent
Target Sector Educational Technology (EdTech) & E-Learning
Core Technical Stack Advanced SQL, Advanced Excel / Google Sheets, BI Tools (Tableau / Power BI / Looker Studio)

Business Intelligence & Stakeholder Workflow

The Business Data Analyst at Vedantu bridges technical data extraction with operational decision-making, converting raw learning and engagement metrics into actionable insights for business teams:

┌───────────────────────────────────────────┐
│ 1. Business Requirements & Problem Framing│ ➔ Partner with teams to define analytical frameworks & metric definitions
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. SQL Extraction & Data Cleaning         │ ➔ Write & optimize SQL queries across multi-source student/course databases
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Dashboarding & Trend Analysis          │ ➔ Build tracking dashboards and proactively identify anomalies, opportunities, & trends
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. Executive Storytelling & Recommendations│ ➔ Translate "so what" metrics into clear, actionable presentations for stakeholders
└───────────────────────────────────────────┘

Key Responsibilities

  • KPI Dashboard Construction: Design, launch, and maintain business dashboards (Excel, Google Sheets, Power BI, Tableau, or Looker Studio) to track core EdTech metrics.

  • SQL Query Optimization: Extract, clean, and analyze multi-source transactional and user engagement data using efficient SQL scripts.

  • Proactive Insight Mining: Analyze user patterns to uncover retention trends, funnel bottlenecks, and operational opportunities without waiting for explicit requests.

  • Stakeholder Alignment: Translate non-technical business queries into structured analytical frameworks and communicate findings back to leadership in simple terms.

  • Data Quality Governance: Conduct audits to ensure data consistency, calculation accuracy, and metric alignment across all business dashboards.

Qualification Matrix & Technical Skill Stack

Core Requirements

Category Specifications
Professional Experience 1 to 2 years of experience in a business or data analyst role.
Database Querying Strong proficiency in SQL (joins, aggregations, CTEs, subqueries).
Spreadsheets & BI Advanced Excel / Google Sheets skills; experience or exposure to Tableau, Power BI, or Looker Studio is a plus.
Analytical Mindset Exceptional critical thinking to extract the “so what” behind top-level conversion and retention metrics.
Communication Skills Ability to present complex technical findings clearly to non-technical business partners and leadership.

Key Focus Areas for Interview Preparation

  1. EdTech Product & Business Metrics: Prepare to discuss key funnel and engagement metrics such as CAC (Customer Acquisition Cost), Trial-to-Paid Conversion, LTV, DAU/MAU, and Course Completion/Retention Rates.

  2. Applied SQL Mechanics: Practice live SQL coding scenarios focused on customer cohort analysis, user retention calculations, and multi-table data aggregation.

  3. Data Storytelling & Case Scenarios: Prepare examples demonstrating how you went beyond reporting numbers to deliver a recommendation that directly impacted business execution

To apply for this job email your details to yasminrifaya86@gmail.com