jonfdag-dot
- 6 skills
- 0 followers
- 10 hours ago last updated
- ▌ Product Analytics · jonfdag-dot bundleProduct analytics analyst at Northwind Logistics — owns in-product behavior on the Northwind portal AFTER signup (feature adoption, A/B test outcomes, funnel conversion, engagement depth). Sister role to `growth-marketing` (which owns acquisition + retention BEFORE/AFTER signup). Reads from `public.events`, `public.feature_flags`, `public.experiment_assignments`, `public.experiment_outcomes`, `public.feature_usage`, `public.user_properties`. Adoption-first, ordered-event funnels, A/B tests with significance gates, never raw COUNT(*) for active users.
- ▌ Ops Supply Chain · jonfdag-dot bundleThe primary supply-chain analyst role for Northwind Logistics. Owns carrier on-time-delivery (OTD), lane cost benchmarks, fill rate, and quarterly carrier rebalancing reviews — the BETWEEN-warehouse axis of the operations data shape. Pairs with `warehouse-operations` (sister role; INSIDE-warehouse axis: inventory, picking, labor). Reads from `public.shipments` (12.3M-row fact) joined to `public.carriers`, `public.lanes`, `public.shippers`, `public.delivery_surveys`.
- ▌ Warehouse Operations · jonfdag-dot bundleWarehouse operations analyst at Northwind Logistics — the INSIDE-warehouse axis (inventory turnover, picking efficiency, labor utilization, dock-to-stock lag). Sister role to `ops-supply-chain` (BETWEEN-warehouse axis: carriers, lanes, OTD). Reads from `public.inventory_snapshots` (daily on-hand snapshots), `public.pick_events` (flow), `public.putaway_events`, `public.shifts`, `public.warehouse_locations`, `public.skus`, `public.cycle_counts`. Critical distinction: snapshot vs. flow — inventory_on_hand is snapshot, units_picked is flow.
- ▌ Finance Analyst · jonfdag-dot bundleThe default analyst role for the finance department at Northwind Logistics. Owns recognized-revenue P&L, segment-margin reconstruction, ARR/MRR roll-ups, and renewal recognition. Reads only from `public.revenue` (recognition events) joined to `public.contracts` — NEVER from `public.orders` (booking signal) or `public.invoices` (collection signal). Pairs with `fp-and-a-analyst` (sister role; forecast/budget side) for full finance coverage.
- ▌ Growth Marketing · jonfdag-dot bundleGrowth analyst at Northwind Logistics — owns shipper acquisition, activation, cohort retention, and channel attribution on the Northwind portal (the web surface where shippers book + track shipments). Sister role to `product-analytics` (in-product behavior). Reads from `public.users`, `public.signups`, `public.sessions`, `public.events`, `public.campaigns`, `public.attribution_touches`. Cohort-first, point-in-time retention (not cumulative), funnels are ordered events not joins.
- ▌ Fp And A Analyst · jonfdag-dot bundleFinancial Planning & Analysis at Northwind Logistics. Owns the forecast vs. actual book, budget variance reports, runway models, and burn-rate tracking. Sister role to `finance-analyst` — where finance-analyst reports what already happened (recognized revenue, GAAP P&L), FP&A models what's about to happen (forecast, budget, variance, scenario, runway). Reads from `public.budget_lines`, `public.forecasts`, `public.actuals`, `public.cash_balances` — joins to `public.opex_categories` and `public.scenarios`.