Work
Data Processing

Lead Gen Data Pipeline

A market center had 3,400+ leads sitting in spreadsheets across three years of export files: inconsistent formats, duplicate phone numbers, agents who had left the brokerage, leads attributed to teams that had reorganized. The pipeline cleaned, deduped, and reconciled it all against the current active roster, producing a CRM-ready import that was actually actionable.

Role
Engineer.
Year
2024
Stack
Python·Pandas·CSV Processing·Data Cleaning

Outcomes.

  • 3,400+ historical lead records cleaned and reconciled.
  • Duplicates collapsed, departed agents reassigned.
  • CRM-ready output: lead-to-active-agent assignment in one import.

Want something like this?

Send a message