Business Analyst (Gurugram)

Business Analyst (Gurugram)

21 Nov
|
Cars24
|
Gurugram

21 Nov

Cars24

Gurugram

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

Robust 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.

📌 Business Analyst (Gurugram)
🏢 Cars24
📍 Gurugram

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: business analyst (gurugram) / gurugram

Subscribe to this job alert:

Get the latest job offers by email for: business analyst (gurugram) / gurugram