About the role

We have moved our analytics from Tableau to Google Cloud, with a dbt semantic layer on top of Trakkia data. We now want someone who owns this stack end to end and builds AI-driven analytics on it.

You will be the person the business trusts for numbers: asset utilisation, cycle times, flow-wise P&L;, and customer reports. You will also own the correctness of master data, especially flow and contract data, so that what Trakkia bills matches what the contract says.

Key responsibilities

Data platform and modelling

- Own the GCP analytics stack: BigQuery warehouse, dbt models and the semantic layer built on Trakkia's PostgreSQL data.
- Build and maintain reliable pipelines from Trakkia into BigQuery, with tests, documentation and freshness checks.
- Define single, agreed metric definitions (utilisation, cycle time, loss/damage, billable days, turns) used by every team.

Analytics and reporting

- Build dashboards in Looker / Looker Studio for operations, finance, sales and leadership.
- Produce customer-facing reports such as asset utilisation, scan adherence and pool-sizing analyses.
- Run ad-hoc analyses on pool sizing, cycle-time overruns, losses and flow profitability, and present transparent recommendations.

AI-driven analytics

- Build AI-assisted analytics on Google tools (Gemini in BigQuery / Looker, Vertex AI): natural-language querying, anomaly detection and automated insights.
- Use LLMs to automate recurring reports, data-quality checks and commentary.
- Support the Technology team in building AI agents on top of Trakkia data.

Master and contract data ownership

- Keep flow, contract, rate and customer master data in Trakkia correct and in line with signed contracts.
- Reconcile master data against contracts and billing, flag mismatches,



and drive fixes with Ops and Accounts.
- Set up data-quality rules and monthly audits so errors are caught before billing.

Must-have requirements

- 3+ years in data analytics or analytics engineering.
- Hands-on experience setting up or running an AI-based data analytics setup (e.g. Gemini/Vertex AI, LLM-based querying or automated insights) in a real business.
- Strong SQL; comfortable writing complex queries on large relational datasets.
- Working experience with Google Cloud data tools: BigQuery and Looker or Looker Studio.
- Experience with dbt (models, tests, documentation) or a comparable transformation layer.
- Python for data work (pandas, API calls, simple automation).
- Sharp eye for data quality; able to reconcile numbers across systems and explain gaps.
- Clear communication with non-technical teams; able to turn a business question into a metric and a recommendation.
- Able to work from our Gurgaon office.

Good to have

- Background in manufacturing, supply chain, logistics or B2B industrial businesses.
- Familiarity with asset tracking, RFID or IoT data.
- Understanding of commercial contracts, rate cards and usage-based billing.
- Experience with PostgreSQL and Django data models.
- Exposure to building AI agents or LLM workflows (prompting, retrieval, function calling).
- Prior Tableau experience, to help users move to the new stack.

Why join

- Own the full data and AI stack at a growing company, not one slice of it.
- Your work directly drives billing accuracy, customer decisions and how we scale.
- Work closely with the founders and the Technology lead on real AI use cases, not demos.

Pay: ₹470,000.00 - ₹800,000.00 per year

Benefits

- Health insurance
- Paid sick time
- Paid time off

Work Location: In person

📌 AI Engineer (Gurugram)
🏢 Trakkia Technologies Private
📍 Gurugram