From: 2022
Geo-Location Recruiting Engine: Distance Matrix Analytics for a US Healthcare Staffing Firm
A US healthcare staffing firm needed to match doctors to job openings based on realistic commute times. Checking this by hand was slow, and the routing service they started with became too expensive to run at scale.
We built an automated pipeline and Power BI dashboard that calculates driving distance and travel time between every candidate and job directly from their PostgreSQL database. Recruiters can now filter by commute time and place physicians who are more likely to stay.
- Project duration
- 3+ months
- Industries
- Healthcare Staffing & Recruitment
The Challenge
A leading US healthcare recruitment firm specializing in doctor placement needed an efficient way to match physician candidates to job openings based on precise commute metrics.
Evaluating match suitability manually across state lines was time-consuming, while initial external routing APIs quickly became cost-prohibitive.
Furthermore, non-monotonic data refreshes and missing job linkages repeatedly broke downstream reporting, limiting pipeline visibility.
The Solution
We engineered an automated geospatial reporting pipeline and interactive Power BI dashboard that calculates pairwise candidate-to-job distances and travel times directly from the firm’s PostgreSQL database ("Eye to Eye"). The solution streamlines physician placement through four core modules:
- Automated ETL Pipeline: Extracted and cleaned candidate and job records, deduplicating entries to maintain one primary record per state.
- Geospatial & Distance Engine: Geocoded candidate and job ZIP codes into exact latitude/longitude coordinates, switching to cost-optimized routing APIs (NextBillion.ai) with strict US-data filtering to calculate precise driving distances (miles) and travel times (minutes).
- Robust Data Synchronization: Designed a dynamic join-based refresh workflow between active and source data, replacing broken incremental ID logic to reliably detect and append new candidates and job posts.
- Interactive Matching Dashboard: Built a Power BI portal featuring aggregate KPI cards (Total Jobs, candidate/job summary details), interactive slicers (Distance, Commute Time, Job Status, State, City), side-by-side commute distribution charts, an integrated location map, and candidate-job match detail tables.
The Results
The Distance Matrix platform transformed how recruiters match doctors with healthcare facilities across the nation. The robust PostgreSQL refresh model ensured continuous data reliability, empowering placement specialists to filter candidates by realistic commute times and maximize physician retention.
Technologies Used
Project category
Built with