Cars24 logo

Business Analyst

Cars24
India

Posted:15 hours ago

Job Description

Analytics
Permanent
Gurgaon

You will be a core builder of Cars24's AI analytics infrastructure. This is not a maintenance role — you will design, build, and deploy AI agents, extend our Power BI semantic layer, optimize our data pipelines, and directly impact decisions made by analysts, business unit heads, and the CEO.

If you have ever wanted to build something that an entire org uses every day — this is it.


WHAT YOU WILL DO

AI Agent Development

  • Build and maintain our Claude-powered Slack analytics bot (multi-turn, tool-calling, SQL-generating agents)

  • Extend agent capabilities: anomaly detection, proactive morning briefings, multi-agent orchestration

  • Reduce hallucination/wrong-answer rate to <5% — own the quality bar

  • Connect agents to StarRocks via XMLA and direct SQL interfaces

Power BI & Semantic Layer

  • Build and extend DAX measures on Microsoft Fabric F64

  • Debug complex DAX (USERELATIONSHIP, CALCULATE context, time intelligence)

  • Document new measures with the rigor of a product engineer

  • Inject semantic layer definitions into agent system prompts for governed, accurate answers

Data Engineering

  • Write production-grade SQL on Snowflake / StarRocks (CTEs, window functions, complex joins)

  • Contribute to dbt gold layer models and YAML metric definitions

  • Automate insight generation — eliminate Google Sheets dependencies across your scope

Insight & Impact

  • Deliver minimum 3 deep insights per quarter that lead to stakeholder action

  • Visit hubs, listen to CJ calls, connect with customers — get grounded in the business

  • Think as a Growth Partner, not a data provider


SKILLS & REQUIREMENTS


✅ Must Have

❌ Red Flags

Python (5+ years, production use)

Google Sheets workarounds (we are eliminating these)

SQL — complex queries, optimization

Drag-and-drop only BI usage

LLM API integration (Anthropic / OpenAI)

'AI experience' = only prompting ChatGPT

Built at least one agent/bot / tool-calling system

Needs hand-holding on data model design

Power BI & DAX (intermediate to advanced)

Reactive mindset — waits for tasks, doesn't find problems

Understands semantic layers & metric governance

Can't explain CALCULATE context in DAX

Team leadership — has led or mentored analysts

Strong IC — can build end-to-end independently


BONUS SKILLS (WILL STAND OUT)

  • Experience with LangChain, LangGraph, CrewAI, or AutoGen

  • XMLA or Power BI REST API integration

  • dbt (models, tests, YAML metric definitions)

  • FastAPI for wrapping AI agents as web services

  • StarRocks or Snowflake query optimization

  • Hex, ThoughtSpot, or other modern BI tooling


HIRING TEAM: KEY INTERVIEW QUESTIONS

Use these 3 questions to filter real builders from resume-padders:


Q1

"Walk me through how you'd build an agent that answers business questions from a database — what are the failure modes and how do you handle them?"
Tests: agent thinking, hallucination awareness, system design

Q2

"A DAX measure using USERELATIONSHIP is returning wrong results. Walk me through how you debug it."
Tests: real Power BI depth vs surface-level knowledge

Q3

"We have a 'City' column with an 'ALL' row (total) and 17 individual cities. Write a SQL query that computes a 'Rest of Cities' row — ALL minus the 17 cities — without double-counting."
Tests: real SQL thinking under business constraints


WHAT WE OFFER

  • Work on a genuinely AI-first analytics stack — not a future plan, a present reality

  • Direct impact: your agents will be used by 98 analysts and business leaders daily

  • Growth Partner Program — quarterly cash rewards for top performers

  • Access to Microsoft Fabric F64, Snowflake, Claude API, and modern tooling

  • Mentorship from a Head of Analytics building a world-class org from scratch

  • Hybrid working — Gurugram HQ with flexibility


GROWTH PARTNER PROGRAM

This role is eligible for the CARS24 Growth Partner Program. Top 3 performers each quarter — rated across AI-first delivery, automation, insight quality, and business impact — receive a cash reward. This is not a bonus scheme. It is a recognition that the best analysts create business outcomes, not just reports.


HOW TO APPLY

Send your CV and a brief note (max 200 words) answering this: "Describe one agent or automated system you have built — what problem did it solve, and what broke first?"

Applications without this note will not be reviewed. We care about builders.


AI-First. No Jugaad. No GSheets. Just Impact.

Skills Required

Analytics Power BI SQL Data Engineering Google Sheets Python API Integration Team Leadership Rest API Integration WEB Services Query Optimization System Design

Learn the skills this job asks for

See your skill gap for Business Analyst →

Free courses, interview questions and practice for each skill.

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Cars24 logo
Cars24

RecommendedJobs for You

Clover Infotech logo

Business Analyst

Clover Infotech

Mumbai, Navi mumbai

Jarus Technologies logo

Business Analyst

Jarus Technologies

Hyderabad

Nohitatu Technologies logo

Business Analyst

Nohitatu Technologies

Chennai

QKTech logo

Mumbai

Valtech logo

Bengaluru

Nouryon logo

Mumbai