Senior Business Analyst

redBus; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

redBus is seeking a senior analytics leader to drive Advanced Analytics, Modeling, and RCA. Lead RCAs on booking shifts, apply cohort analysis, and build predictive models to unlock revenue and efficiency.

You will oversee BI engineering and data architecture, govern ETL pipelines, ensure data quality, and mentor a team of data analysts while partnering with Product, BizDev, and Engineering to turn analytics into real product impact.

Qualifications

• Expert RCA leadership on volatile business shifts and quick interventions.
• Cohort analysis, funnel tracking, and forecasting to predict demand.
• Heuristic and predictive modeling to unlock revenue and efficiencies.

Responsibilities

• Oversee enterprise Power BI dashboards with complex DAX logic and data quality.
• Govern ETL pipelines and data architecture using SSIS/SSAS/modern tools.
• Maintain data models, transformations, SQL views, and procedures.
• Lead, mentor, and benchmark performance for a data analytics team.
• Collaborate with Product, BizDev, and Engineering to deploy analytics features.
• Drive revenue optimization, pricing analytics, funnel management, and loyalty analysis.

Skills

Advanced SQL & T-SQL

Python for EDA/ML

BI Stack (SSIS/SSAS/SSRS)

Product Analytics tracking (GA/GTM)

Tools

SSIS

SSAS

SSRS

Power BI

Google Analytics

Google Tag Manager

Job description

• Advanced SQL & T-SQL: Expert-level database query optimization, view creation, and deep structured analytical querying
• Advanced Programming: Hands-on capability in Python for exploratory data analysis (EDA), hypothesis testing, and implementing fundamental Machine Learning (ML) models
• Microsoft BI Stack: Solid foundation across SSIS, SSAS, and SSRS ecosystems
• Modern Product Analytics: Experience tracking user behavior via Google Analytics, Google Tag Manager, or clickstream events is highly preferred.

1. Advanced Analytics, Modeling & RCA:

• Root-Cause Analysis (RCA): Lead complex RCAs on volatile business shifts (e.g., sudden booking drops or cancellation spikes) and deliver quick-turnaround strategic interventions
• Rule Based Frameworks: Apply cohort analysis, funnel tracking, and statistical forecasting techniques to predict peak seasonal travel demand
• Advanced Decision Models: Build heuristic and predictive data models to unlock alternative ancillary revenue streams and operational efficiencies

2. BI Engineering & Data Architecture Management:

• Data Visualization Integration: Oversee the construction of enterprise-level Power BI dashboards utilizing complex DAX logic and Power Query to surface executive-level insights
• ETL Pipeline Governance: Supervise the development and continuous execution of data pipelines using SSIS, SSAS, or modern data orchestrators
• Data Quality Assurance: Maintain ownership over data modeling, transformation structures, SQL views, and procedures to guarantee data validity.

3. Team Leadership & Stakeholder Management:

• Team Mentorship: Lead, mentor, and define performance benchmarks for a high-performing team of data analysts.
• Cross-Functional Collaboration: Act as the primary consultant for Product Managers, Business Development heads, and Engineering teams to transform raw analytics into real feature deployments

4. Strategic Business Drive & Domain Analytics:

• Revenue & Pricing Optimization: Analyze demand-supply gaps, inventory utilization patterns, and dynamic pricing effectiveness across routes and geographies
• Conversion & Funnel Management: Deep-dive into customer checkout cohorts, shopping cart drop-offs, and cancellation bottlenecks to drive user retention
• Campaign & Loyalty Analysis: Partner with marketing teams to design, track, and optimize customer rewards and sales promotion campaigns.