HR / People Analytics Stack (Python, PostgreSQL, dbt, Metabase, FastAPI) overview

A people analytics platform for HR teams that consolidates headcount, attrition, compensation, and engagement data from HRIS sources into PostgreSQL, transforms it with dbt models into analytics-ready datasets, and exposes interactive dashboards via Metabase. FastAPI provides a programmatic API for custom integrations with recruiting tools and performance review systems. Pandas handles ad-hoc analysis notebooks. Designed for People Analytics teams in companies with 500+ employees who need self-serve workforce metrics without a full data warehouse. The tradeoff is data sensitivity — PII-heavy HR data demands strict access controls, row-level security, and audit logging that add operational overhead beyond a typical analytics stack.