Legal & Professional Services
Staffing and intake analytics for a growing law firm
The firm’s first central analytics system, joining HR, call-center and marketing data to answer how many people they need and where leads come from.
0 → 1
first single source of truth for the firm
- Client
- Hirsch Law Group
- Location
- Philadelphia, USA
The problem
Headcount, call-center and campaign data lived in separate tools. Staffing calls were made on instinct and marketing spend could not be tied to intake.
What I built
- 01
Designed the data architecture and ETL across HR, operations and marketing systems.
- 02
Built headcount, staffing-gap forecasting and call-center capacity models.
- 03
Linked campaign spend to intake to show marketing ROI by channel.
The result
- Leadership can answer “how many agents do we need?” with data.
- Staffing decisions moved from guesswork to forecasts.
- Marketing budget decisions tied to actual intake.