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