Founder-led people analytics & hiring automation

People data you can put in front of the board.

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

People analytics

Headcount, attrition, hiring and cost numbers that reconcile across your HRIS, ATS, payroll and finance plan.

HRIS 212Finance 205ATS 219→ 212

Also

Hiring automation & AI

Approval workflows, bulk plan updates and interview briefings built on your own data.

HeadcountAttritionTime to fillQuality of hireCompensationWorkforce planning
276changes shipped and reviewed in five months
206hiring-plan changes synced in one validated upload
20+people and finance dashboards rebuilt or built new
30+data-quality bugs found and fixed at the source

From a five-month embedded engagement with a multi-country tech scale-up

Services

What I can take off your plate.

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

People reporting you can trust

Dashboards for headcount, attrition, time to fill, quality of hire and compensation, each built on one agreed definition.

Voluntary attrition, rolling 12 monthsvoluntary exits (L12M) ÷ average headcount (L12M)
Owner: People Analytics · agreed with Finance

Workflow

Hiring workflow automation

Role requests, approvals and reminders that keep your ATS, HRIS and finance plan in step, without anyone chasing.

New role request→Budget owner→Finance gate→Synced to ATS

AI

AI for talent teams

Briefings built from the application, scorecard and earlier feedback, sent to every interviewer before the call.

Interview briefing · 13:45
Senior Data Engineer · Priya Nair, 14:00 with you
  • Led an Airflow migration at a 400-person fintech
  • Round 1 flagged: probe dbt testing depth

Foundation

Data foundation and ongoing support

The pipelines, models and tests underneath it all, plus an analyst on call when a number looks off.

HRISATSPayrollFinance
Warehouse + dbt412 tests passed

Selected work

Proof, without exposing client environments.

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

206 plan changes, one validated upload

The hiring plan lived in the ATS, the HRIS and the finance forecast, and the three drifted apart.

  • An internal app for role requests, backfills and approvals
  • A change log with the budget impact of every change, split by approval gate
  • Automatic backfill and out-of-plan emails routed by role and org
SnowflakeStreamlitdbt~15 users

Interview Intelligence · AI for talent teams

Every interviewer briefed before the call

Interviewers joined calls without reading the application, and scorecards came in late or thin.

  • A Slack briefing per interviewer from the application, scorecard and past feedback
  • Re-sent automatically when an interview moves
  • A draft scorecard after each call, linked to the ATS
Snowflake CortexAirflowSlackClaude

Reporting rebuild · people reporting

20+ reports rebuilt before the old BI tool shut down

Report logic lived in legacy BI views nobody fully trusted, and the old environment was being retired.

  • All BI logic moved into tested dbt models
  • 10 finance and 5 people-ops reports rebuilt
  • New performance, onboarding, org health and rewards dashboards
LookerdbtSnowflake

Pipelines and cost · data foundation

A 63% cost jump explained before anyone asked

Slow full refreshes of recruiting data, few tests, and warehouse costs rising without a clear reason.

  • Recruiting ingestion moved to incremental loads on Airflow
  • Daily refreshes with Slack alerts, tests and freshness checks
  • A monthly cost breakdown by project
AirflowAirbytedbt 1.11

Numbers that were wrong, and what fixed them

AreaWhat was happeningBeforeAfter
Interview countsCounting logic multiplied interviews in the TA dashboards1,331 shown176 actual
Office historyOffice came from each person's current record instead of their history, so past months were mislabeled after transfers269 employee-monthsPoint-in-time history
Position IDsA precedence bug tied applications to the wrong position151 applicationsFixed at the source
Job levelsAn opening's level silently overrode the real offer levelWrong levelOffer level wins
Performance ratingsRatings stopped updating after post-review calibrationStale ratingsCalibrations synced
Hiring planRe-hire rows duplicated filled roles, caught before a weekly business reviewDouble-countedOne row per role

How the work moves

A simple method, from first call to handover.

Small, reviewed changes on the tools you already pay for, with a written update every week.

  1. 01

    Day 1

    A free 30-minute call

    We talk through the question behind the project and who needs the answer.

  2. 02

    Days 1 to 3

    Readiness audit

    I map your systems, check access and spot-check the numbers. You get a written report and a fixed quote.

  3. 03

    Week 1 onward

    Build in small pieces

    Reviewed, tested changes on your warehouse and BI tool, with a written update every week.

  4. 04

    Final week

    Handover

    Documentation, a walkthrough for your team and 30 days of fixes. Keep me on monthly if you like.

Pricing

Start with a bounded decision, at a fixed price.

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

3-day Readiness Audit

A short, fixed-price check that you have what a project needs before you commit to one.

  • Map of your HR systems and data sources
  • Access, permissions and owners checklist
  • Spot check of headcount, hires and exits
  • Gaps in how key metrics are defined
  • A written report with the next step

$2,4003 days · credited toward any project booked within 30 days

A clear plan and a fixed quote

Discovery and business case

Know what to build, what it's worth and what it costs before you commit.

  • Interviews with HR, TA, finance and IT
  • Review of current reports and workarounds
  • Opportunity, solution, benefits and effort
  • Phased roadmap with priorities
  • Fixed quote and statement of work

$5,000About 2 weeks

Numbers that match finance

People data foundation and reporting

One source of truth for your people data, and the dashboards leaders use.

  • HRIS, ATS, payroll and finance in one warehouse
  • New pipelines, or broken ones fixed
  • Headcount, hires and exits audited against finance
  • Quality tests, freshness checks and alerts
  • Headcount, attrition and hiring dashboards

$36,000About 9 weeks

Faster time to fill

Hiring workflow automation

Hiring requests and plan changes that move without chasing.

  • Request forms for new roles and backfills
  • Approvals routed by budget owner and gate
  • Validated bulk uploads for planning cycles
  • Approved changes synced to ATS and finance
  • Reminders and a change log with budget impact

$32,000About 8 weeks

Better-prepared interviewers

AI interview briefings

Every interviewer walks in knowing the candidate.

  • A briefing from application, scorecard and feedback
  • Delivered in Slack or email before each interview
  • A draft scorecard after, linked to your ATS
  • Coverage tracking for briefings and scorecards
  • Runs in your warehouse, with access controls

$16,000About 4 weeks

An analyst without the hire

Ongoing partnership

A people analytics engineer on your team, without the recruiting process.

  • Roughly 2.5 days a week of dedicated time
  • New dashboards, metrics and analysis
  • Fixes and upkeep as your tools change
  • A written summary each month
  • Month to month, with 30 days' notice

$10,000/moMonth to month

Estimate your project
Estimated total $38,400 about 10 weeks Talk it through

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

The person framing the work does the work.

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.

I work inside your stack

Your warehouse, BI tool, ATS and HRIS. No new platform to buy, and nothing that stops working when I leave.

Numbers first, then dashboards

Definitions are agreed and reconciled before anything is charted, so the first dashboard is one people trust.

Every change is reviewable

Pull requests, tests and a written weekly update, so you always know what moved and why.

Built to hand over

Documentation, a walkthrough and 30 days of fixes. The goal is a team that runs it confidently without me.

Tools I use every day

SnowflakeBigQuerydbtAirflowLookerStreamlitSnowflake CortexClaude CodeAshbyGreenhousePersonioCulture AmpSlackGitHub

FAQ

Questions people ask before the first call.

Which tools do you work with?

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.

We don't have a data warehouse yet. Can you still help?

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.

How do you handle sensitive employee data?

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.

How soon will we see something working?

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.

Can you work alongside our own data team?

Yes. Code goes into your repository through pull requests your team reviews, so nothing depends on me after handover.

What happens 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?

Bring the messy version.

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.

raj@forclarity.company