Primary focus
People analytics
Headcount, attrition, hiring and cost numbers that reconcile across your HRIS, ATS, payroll and finance plan.
HRIS 212Finance 205ATS 219→ 212
Founder-led people analytics & hiring automation
I help HR, talent and finance teams connect their systems, fix the numbers that don't add up, and automate the manual work that slows hiring down, including AI tools like interview briefings built on the systems you already use.
Primary focus
Headcount, attrition, hiring and cost numbers that reconcile across your HRIS, ATS, payroll and finance plan.
HRIS 212Finance 205ATS 219→ 212
Also
Approval workflows, bulk plan updates and interview briefings built on your own data.
From a five-month embedded engagement with a multi-country tech scale-up
When to bring me in
The first question is usually "which number is right?". It's often the moment to fix the data underneath, not add another dashboard.
HR, finance and the ATS each report a different number, and someone reconciles them by hand before every leadership meeting.
Attrition, hiring and cost reports live in spreadsheets, and definitions change depending on who builds them.
Role requests, backfills and plan changes get chased manually, and the ATS drifts away from the finance plan.
A migration or tool sunset is the right moment to rebuild the data model, before the old logic gets copied across.
Services
Most HR teams already have the data. It's spread across an HRIS, an ATS, payroll and a finance model that each tell a slightly different story.
Reporting
Dashboards for headcount, attrition, time to fill, quality of hire and compensation, each built on one agreed definition.
voluntary exits (L12M) ÷ average headcount (L12M)Workflow
Role requests, approvals and reminders that keep your ATS, HRIS and finance plan in step, without anyone chasing.
AI
Briefings built from the application, scorecard and earlier feedback, sent to every interviewer before the call.
Foundation
The pipelines, models and tests underneath it all, plus an analyst on call when a number looks off.
Selected work
Five months embedded with the People Analytics team at a multi-country tech scale-up, working with TA and FP&A. A written summary went to the client every month.
Workforce Planner · hiring automation
The hiring plan lived in the ATS, the HRIS and the finance forecast, and the three drifted apart.
Interview Intelligence · AI for talent teams
Interviewers joined calls without reading the application, and scorecards came in late or thin.
Reporting rebuild · people reporting
Report logic lived in legacy BI views nobody fully trusted, and the old environment was being retired.
Pipelines and cost · data foundation
Slow full refreshes of recruiting data, few tests, and warehouse costs rising without a clear reason.
| Area | What was happening | Before | After |
|---|---|---|---|
| Interview counts | Counting logic multiplied interviews in the TA dashboards | 1,331 shown | 176 actual |
| Office history | Office came from each person's current record instead of their history, so past months were mislabeled after transfers | 269 employee-months | Point-in-time history |
| Position IDs | A precedence bug tied applications to the wrong position | 151 applications | Fixed at the source |
| Job levels | An opening's level silently overrode the real offer level | Wrong level | Offer level wins |
| Performance ratings | Ratings stopped updating after post-review calibration | Stale ratings | Calibrations synced |
| Hiring plan | Re-hire rows duplicated filled roles, caught before a weekly business review | Double-counted | One row per role |
How the work moves
Small, reviewed changes on the tools you already pay for, with a written update every week.
Day 1
We talk through the question behind the project and who needs the answer.
Days 1 to 3
I map your systems, check access and spot-check the numbers. You get a written report and a fixed quote.
Week 1 onward
Reviewed, tested changes on your warehouse and BI tool, with a written update every week.
Final week
Documentation, a walkthrough for your team and 30 days of fixes. Keep me on monthly if you like.
Pricing
Every package has a published price. Estimate your project below, and the proposal confirms scope and price before any work starts.
Start here · know you're ready
A short, fixed-price check that you have what a project needs before you commit to one.
$2,4003 days · credited toward any project booked within 30 days
A clear plan and a fixed quote
Know what to build, what it's worth and what it costs before you commit.
$5,000About 2 weeks
Numbers that match finance
One source of truth for your people data, and the dashboards leaders use.
$36,000About 9 weeks
Faster time to fill
Hiring requests and plan changes that move without chasing.
$32,000About 8 weeks
Better-prepared interviewers
Every interviewer walks in knowing the candidate.
$16,000About 4 weeks
An analyst without the hire
A people analytics engineer on your team, without the recruiting process.
$10,000/moMonth to month
Estimates only. After the audit or discovery, the proposal sets a fixed price and scope. Packages that share groundwork are discounted by the work saved.
Building the case for budget? The free attrition and vacancy cost calculator puts a number on what resignations and slow hiring cost you each year.
Direct accountability
I'm Raj Kothari, an analytics engineer. I work with HR, talent and finance teams on the part of people analytics that usually breaks: the data between systems. I build the models, dashboards and workflows that keep headcount, hiring and cost numbers consistent, from the HRIS all the way to the board pack.
My most recent engagement was five months embedded with the People Analytics team at a multi-country scale-up, working alongside TA and FP&A. The workforce planner, the interview briefings and the reporting rebuild on this page all came from that work.
I use AI tools like Claude Code every day, both to build faster and inside the tools I hand over. You work with me directly, from the first call to the last handover.
Your warehouse, BI tool, ATS and HRIS. No new platform to buy, and nothing that stops working when I leave.
Definitions are agreed and reconciled before anything is charted, so the first dashboard is one people trust.
Pull requests, tests and a written weekly update, so you always know what moved and why.
Documentation, a walkthrough and 30 days of fixes. The goal is a team that runs it confidently without me.
FAQ
Warehouses like Snowflake and BigQuery, dbt and Airflow for pipelines, and Looker or your existing BI tool. On the HR side: Ashby, Greenhouse and Lever; Personio, HiBob, BambooHR and Workday; plus Culture Amp and Enboarder.
Yes. The readiness audit tells you what you need, and setting up a warehouse can be part of the data foundation package. Many HR teams start from exports and spreadsheets.
Work happens inside your systems and accounts, with the minimum access needed. Compensation and other sensitive fields are restricted to the roles that should see them. I'm happy to sign your NDA and data processing agreement.
The readiness audit report arrives in three days. On a build, you see a first working version within the first few weeks, then weekly updates until handover.
Yes. Code goes into your repository through pull requests your team reviews, so nothing depends on me after handover.
You get documentation, a walkthrough for your team and 30 days of fixes. If you want ongoing help, the monthly partnership covers new reports, fixes and upkeep.
Have a people-data problem?
Pick a time for a free 30-minute call, or email me what your team is stuck on and I'll reply with how I'd approach it. No pitch, just an honest read of the problem.