Warehouse setup
Creates raw and analytics schemas, stages payroll/budget inputs, and converts source files into typed analytical tables.
Skill evidence
Postgres SQL work: finance and workforce analytics warehouse.
This page connects the Postgres SQL skill directly to the public GitHub repository built from the BudgetDB analytics work: data extraction, cleanup, employee normalization, cost modeling, QA checks, and executive-ready views.
Published project
PostgreSQL Finance & Workforce Analytics Warehouse
The repository shows how raw payroll, vendor, commission, T&E, and planning-style inputs become a reusable analytics layer for finance and people-operations reporting.
What this proves
CREATE SCHEMA, CREATE TABLE, CREATE VIEW, and CREATE OR REPLACE VIEW
COPY-based CSV ingestion with public-safe path placeholders
INSERT ... SELECT and ON CONFLICT DO UPDATE upsert logic
CTEs, LEFT JOINs, CROSS JOIN LATERAL, and generate_series month spines
REGEXP_REPLACE, REGEXP_SPLIT_TO_ARRAY, TRIM, LOWER, SPLIT_PART, and COALESCE
SUM, COUNT DISTINCT, FILTER, ROUND, CASE, and grouped reporting views
Bridge tables for manual match overrides and audit-friendly governance
Source-to-fact QA checks with variance and pass/review status
Repository work map
The GitHub project is organized around real analytics engineering tasks.
Each block below links the skill back to SQL files in the public repository.
Employee dimension
Builds a canonical employee layer with employee IDs, team, role, salary, benefits, employment windows, and normalized name keys.
Commission matching
Normalizes messy commission names, adds deterministic matching keys, and uses an override bridge for manual name-to-employee governance.
Monthly cost facts
Generates month-level payroll, benefits, vendor, commission, and T&E cost facts that can feed dashboards and executive reviews.
Cost allocation
Allocates software and vendor spend by employee and team using reusable views, headcount logic, and department ownership patterns.
Executive reporting
Creates monthly burn, annual spend, vendor dashboard, annual cost per employee, and executive operations insight views.
Skill summary
Postgres SQL is the foundation skill behind the BudgetDB story.
The repo shows the full path from extracting source files to building trusted views: raw schemas, cleaned tables, employee matching, monthly facts, scenario foundations, allocation logic, and executive QA.