Data Engineering & Analytics Intern
Built the dbt models behind Pennant's support reporting, then found and fixed the attribution bug that had been hiding 442,000 tickets.
- Built three production dbt models on Snowflake transforming 11M+ support events into reporting tables covering 1.19M tickets across 93 teams serving home health, hospice, and senior living affiliates.
- Shipped four Tableau dashboards giving operations leaders team, staff, and ticket-level visibility, validating every metric against both Snowflake and the source system.
- Rebuilt team-attribution logic to capture sub-day handoffs the prior model missed, correcting the routing team's volume from 76K to 518K tickets handled.
- Presented the revised model and metric definitions to department leadership, securing new attribution standards.