HR & Recruitment
A Berlin-based embedded recruiting agency running multiple concurrent client engagements had outgrown its spreadsheet-based processes. We designed and built a centralised operations platform that gave the entire team — leadership, talent partners, and clients — a shared, real-time view of recruitment activity for the first time.
Recruitment data lived in multiple disconnected Google Sheets, manually maintained by different team members. There was no reliable way to track talent partner output across clients, monitor NPS and candidate feedback trends, or produce client-facing reports without assembling them by hand each time. The data itself had accumulated inconsistencies — varying name formats, role titles, and salary entries — that made any cross-dataset analysis unreliable.
We built a custom recruitment analytics platform on top of the agency's existing Google Sheets infrastructure — no migration, no disruption to live data. The platform has three core components:
Reporting Dashboard
A live analytics layer covering hiring activity, time-to-fill, offer conversion rates, NPS scores, and talent partner performance — filterable by client, role type, and time period. Leaders and talent partners can see the same data simultaneously, in the same format.
Client Portal
A secure, branded portal giving each client a dedicated view of their own hiring data. Access is controlled entirely by the agency — clients authenticate via Magic Link (no passwords, no Google account required), and the ops team can grant, revoke, or adjust access through an admin interface without touching any code.
Data Normalisation Layer
Before any reliable analytics were possible, we built a reconciliation layer in the backend that standardises inconsistent records across historical data — resolving mismatched talent partner names, client name variants, and formatting differences — so that cross-dataset joins produce accurate results.
Work that was previously invisible — or only known to whoever built the spreadsheet — is now visible to everyone who needs it. The team can track output across every active engagement in one place, clients have direct access to their own data without waiting for a manual report, and the ops team manages all of it without writing a line of code.
Next Step