
Closed
Posted
Paid on delivery
Brief A: Construction Lead Intake, Scoring & Classification Engine Job title: Build a Construction Lead Intake & Scoring System (CSV → API) Project type: Backend + simple admin settings panel Timeline: 3–4 weeks Engagement: Fixed-price or hourly Overview We are a flooring company that receives regular CSV dumps of new construction proposals (building permits). We need a backend system that ingests these files, cleans the data, enriches it (geocoding, classification), calculates a 0–100 lead score, and exposes everything via a clean REST API. This will serve as the “brain” that feeds our mapping/routing tool (being built separately). Core features CSV intake & standardisation Accept CSV uploads (manual via web UI or watched folder script). Map columns: BP ID, Issue Date, Owner name/address/city & postal code/phone/email, Project Address, Project Details, Project Amount, Contractor name/address/city & postal code/phone/email, Project Type (category list provided). Clean/normalise phone numbers and addresses. Geocode all addresses using Google Geocoding API and store lat/lon. Handle missing fields gracefully. Automatic lead classification No phone number (neither owner nor contractor) → status = “Visit In-Person”. Contractor name contains keywords (excavating, engineers, consultants, associates, architects, design, etc.) → status = “Acquire Number” (i.e., need to obtain the builder/owner’s phone). Has a usable phone number → status = “Calling Queue”. Admin must be able to later mark certain owner types (e.g., “designers”) as “Unfit” (low conversion) and optionally move them to a different bucket. Lead scoring engine (0–100) Configurable weighted sum model. Default factors: Proposal timing (how close Issue Date is to a manually set “ideal window” in months) Regional historical conversion rate (computed from past outcomes) Project value (log‑normalised) Project type suitability (per‑category conversion history) Data completeness (has phone + email) Admin panel to adjust weights and the ideal timing window. Score is calculated for every lead and stored. Admin settings UI (simple web pages) Login for one admin. Upload CSV, view recent batches. Adjust lead scoring weights. Manage keyword list for subcontractor detection. Mark owner types as “unfit”. Manual score overrides per lead (optional). REST API for the mapping system GET /leads – returns paginated list of active leads (all non‑visited) with scores, statuses, full details, lat/lon. POST /outcomes – receives visit outcomes from the rep’s software/mapping tool (e.g. “measurement booked”, “no interest”). Lead is then marked as visited and excluded from future queries. Simple auth (API key or token). Technical specs Backend: Python (Flask/FastAPI) or Node.js – whichever you’re faster with. Database: PostgreSQL (PostGIS extension not mandatory for this piece, but should be compatible). Deployment: Provide a Docker container or clear instructions to run on a cloud VM. Code quality: Environment variables for secrets, clear README, minimal test coverage. Deliverables Fully working backend with admin UI (can be minimal, functional). API documentation (OpenAPI/Swagger or simple markdown). Sample CSV and test outcomes that prove the scoring and API flow. Setup guide. Skills needed Backend development, experience with CSV ETL pipelines. Google Geocoding API. Basic scoring logic implementation. Creating clean APIs. (Plus) Experience with lead scoring or construction data. Budget & Timeline Timeline: 3–4 weeks.
Project ID: 40584911
314 proposals
Remote project
Active 1 min ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
314 freelancers are bidding on average $2,721 CAD for this job

Hi — Elias here from Miami. I understand you're looking to develop a construction lead intake, scoring, and classification engine. The goal here is to efficiently manage and evaluate leads to prioritize high-quality opportunities. What usually matters most here is scalability and maintainability. As lead volume increases, ensuring the system can handle dynamic scoring and classification without bottlenecks is essential. A common issue in systems like this is integrating various data sources while keeping workflows straightforward. My approach would involve designing a modular backend with a focus on API-driven architecture. This would allow for flexible integrations and future expansion, ensuring the system remains robust and adaptable. I’ve worked on similar systems that required complex data handling and real-time scoring, which has taught me how to structure for both stability and growth. A few questions to better understand the scope: Q1 – What specific user roles and permissions do you envision for this system? Q2 – Are there particular data sources or APIs you plan to integrate for lead scoring? Q3 – What are your expectations for system scalability in terms of lead volume? Happy to go through the details and suggest the best technical approach. Looking forward to hearing from you.
$5,000 CAD in 17 days
7.8
7.8

⭐⭐⭐⭐⭐ Build a Construction Lead Intake & Scoring System with Ease ❇️ Hi My Friend, I hope you're doing well. I reviewed your project needs and see you are looking for a construction lead intake and scoring system. Look no further; Zohaib is here to help you! My team has successfully completed 50+ similar projects in backend development and data processing. I will create a system that ingests CSV files, cleans and enriches data, calculates lead scores, and provides a REST API for your mapping tool—all within your budget. ➡️ Why Me? I can efficiently build your construction lead intake and scoring system as I have 5 years of experience in backend development, CSV processing, API creation, and data enrichment. My expertise includes using Python and PostgreSQL, ensuring a robust solution tailored to your needs. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to our conversation! ➡️ Skills & Experience: ✅ Backend Development ✅ CSV ETL Pipelines ✅ Google Geocoding API ✅ Data Enrichment ✅ Lead Scoring Logic ✅ REST API Development ✅ PostgreSQL ✅ Python (Flask/FastAPI) ✅ Docker Deployment ✅ Data Normalization ✅ Admin UI Creation ✅ Project Management Waiting for your response! Best Regards, Zohaib
$1,208 CAD in 2 days
7.9
7.9

As a part of the MHTechFusion engineering team, I am Sardar Hasnain, a seasoned full-stack developer specializing in Python and Node.js backend architecture. For several years, my team has constructed intelligent systems that integrate various data sources, including CSVs and REST APIs. We have extensive experience in handling data extraction, transformation, loading (ETL), and geocoding through services like the Google Geocoding API required for this project. Moreover, at MHTechFusion, we excel in building clean, well-documented APIs, and I'm confident we can deliver a streamlined REST API to power your mapping/routing tool effectively. Additionally, we are skilled in implementing scoring logic - an essential component needed to calculate lead scores based on your defined parameters. Our adaptable approach will allow us to mold the system to your needs, allowing you to adjust weights and fine-tune lead scoring via an intuitive admin panel. Finally, our broad skill set in AWS, Docker, Kubernetes, and familiarity with PostgreSQL allows us to deploy complete systems efficiently. We assure you clean code with clear README documentation - essential for maintaining the system in the future.
$6,000 CAD in 30 days
7.2
7.2

The part that decides whether this system is actually useful is data quality on ingest — permit CSVs are messy, with inconsistent phone formats, duplicate BP IDs across dumps, and addresses that geocode ambiguously, so I'd build the intake to normalise phones (libphonenumber), dedupe on BP ID so re-uploaded files don't create doubles, and cache geocoding results so you're not paying Google to re-geocode the same address every dump. The scoring and classification I'd build as a configurable rules engine rather than hard-coded logic — your "Visit In-Person" and "Acquire Number" rules, the contractor keyword list, and the 0–100 weighting all editable from the admin settings panel, so you can tune them without a developer. Stack: Node/Express (or Python/FastAPI) with PostgreSQL and PostGIS for lat/lon, exposing a clean REST API ready for your mapping tool to consume. I'd deliver in milestones — intake and cleaning first, then scoring, then the API — so you see real data flowing through early. I can start right away.
$10 CAD in 1 day
6.7
6.7

Hello, I HAVE CREATED SIMILAR LEAD MANAGEMENT, SCORING, AND DATA PROCESSING SYSTEMS BEFORE AND I CAN SHOW YOU. I have carefully reviewed your requirements and understand the complete scope, including CSV ingestion, data normalization, Google Geocoding API integration, configurable lead scoring, classification engine, admin panel, REST APIs, PostgreSQL, Docker deployment, and API documentation. I have 10+ years of experience in Python (FastAPI/Flask), PostgreSQL, ETL pipelines, API development, automation, and business intelligence systems. I can build a scalable, well-documented backend with configurable scoring logic, secure APIs, and a clean admin interface that is easy to maintain and extend. We will follow an Agile development methodology throughout the project. I will provide 2 years of free ongoing support, complete source code, and assist you from development through deployment. I am available on desk as per your convenient time zone and will work on your project until you are satisfied with my work. Thanks, Christina
$600 CAD in 21 days
6.8
6.8

Hello, As a seasoned backend developer with a focus on Python, I'm confident I am the professional you need to bring your construction lead scoring system to life. My expertise in building API platforms will ensure that you have a smooth, efficient process for ingesting and managing your CSV dumps of new construction proposals. For instance, I will incorporate Google Geocoding API to accurately geocode all addresses using this project's lat/lon functional requirement. My experience with creating clean APIs will also be invaluable as I develop your REST API for the mapping system, providing you with GET and POST endpoints that return actionable data for your team. Additionally, my background in basic scoring logic implementation makes me adept at employing a configurable weighted sum model like you've described. This means I can make the lead scoring engine intelligent, taking into account factors such as proposal timing, regional historical conversion rate, project value, project type suitability, and data completeness. Having worked on numerous projects requiring complex ETL pipelines and clean API designs, I am confident that my broad range of skills is exactly what you require. You'll also appreciate my proficiency with tools like Flask/FastAPI or Node.js and PostgreSQL/PostGIS that align perfectly with your project's technological specifications. Lastly, should you choose me for this role, you'll gain not only a reliable partne Thanks!
$3,335 CAD in 3 days
6.3
6.3

Hi, I'd handle this using Python + FastAPI because it keeps the system clean, scalable, and easy to extend later. The biggest improvement will come from storing raw data separately from processed results so scoring logic can be adjusted without reprocessing everything. For the geocoding and scoring, I worked on a similar lead routing system where address accuracy caused some delays until we added address standardization first. The scoring model needed two iterations before matching historical conversion patterns closely enough. All changes will be committed in small, reviewable steps and tested against sample CSVs before affecting live data. The admin panel will include undo options for scoring overrides and status changes. You’ll get consistent lead quality for your mapping tool, with scoring that adapts to your best-performing project types and regions. If this aligns with your needs, I’d be happy to review your current CSV format and suggest the quickest path to integrate the intake. Thanks, Denis.
$3,005 CAD in 30 days
6.2
6.2

Hello!, This is James from Hollywood... I read your project description carefully, and the goal is clear: you need a Construction Lead Intake, Scoring & Classification Engine that can capture leads, score them with defined rules, and classify them so your team can act quickly. I’m a senior Full-Stack & AI Engineer with about 15 years of experience in Python, backend development, API building, and automation. I’ve built production systems for lead processing, workflow automation, internal tools, and rule-based decision engines, so this is right in my lane. My approach would be: 1. Review your intake sources and scoring criteria 2. Design a clean backend/API for lead capture and processing 3. Build the scoring and classification logic 4. Add validation, logging, and easy future updates 5. Test with sample leads before launch A few relevant examples of work I’ve handled: - lead intake and routing system for a local service company - scoring engine for a B2B CRM workflow - Python API for automated data classification Could you please clarify the following questions to help me better understand the project? 1. What are the lead sources and expected input format, API, forms, CSV, webhook, etc.? 2. Do you already have scoring rules defined, or should I help design the logic? 3. What should the final output be, database record, API response, dashboard view, or all of them? If you want someone who pays attention to the details and builds this cleanly from the start, I’m ready
$4,200 CAD in 11 days
6.3
6.3

Hello, I will build the CSV intake, scoring, and classification engine so your flooring company's building permit dumps are cleaned, geocoded, scored 0 to 100, and exposed via REST API, ready to feed your separate mapping/routing tool. On a similar ETL pipeline for permit data, structuring the classification logic as a rule chain (no phone, keyword match, then calling queue) made it simple for the client to add new keyword groups without touching code. I will set yours up the same way. Questions: 1) For the geocoding volume, roughly how many leads per CSV batch are you expecting (hundreds, thousands)? 2) Will the admin settings UI need multi user support later, or is single admin login the long term plan? Share a sample CSV file and I will confirm column mapping and have the data model ready within two days. Looking forward to your response. Best regards, Kamran
$11 CAD in 30 days
6.4
6.4

Hi, I've built CSV ingestion pipelines with geocoding and scoring logic before, so the CSV to clean API flow here is familiar work. In 15 years of full-stack development, and as CTO leading 50+ products, this is the kind of backend we do often. One thing worth deciding early: the keyword rule for "Acquire Number" will misfire on edge cases, for example a contractor named "Design Build Homes" that does have a phone. Do you want keyword detection to override a present phone number, or only apply when no phone exists? That choice changes the classification order. I'd suggest FastAPI plus PostgreSQL, with the scoring weights and keyword list stored in the DB so the admin panel edits them live. We can start with a first milestone on CSV intake and geocoding so you only release once that piece works. Which column layout does your CSV use today? Adil
$2,415.42 CAD in 21 days
6.0
6.0

With Web Crest, you're not just getting a technical team; you’re choosing a partner with a deep understanding of API development, backend expertise, and the specific skills required for this project. Our experience in constructing ETL (extract, transform, load) pipelines and working with Google Geocoding API makes us well-equipped to handle your CSV intake and standardization needs. We're also skilled in creating clean, scalable APIs – an important aspect of your project. In terms of our technical capabilities, our proficiency with Python, Flask/FastAPI stack matches your requirement for the backend language. Moreover, our knowledge of PostgreSQL Database with PostGIS extension compatibility stands us in good stead for your project. We're fervent about ensuring code quality, and we commit to provide environment variables for secrets, a clear README, and deliver minimal test coverage. What sets us apart is our business-focused approach to secure high-performance solutions that go beyond functional requirements. In addition to that, we possess valuable insights into lead scoring techniques and substantial construction data experience which should significantly impact the effectiveness of our scoring engine implementation. Choosing us isn't just about getting the job done - it’s about partnering with a team determined to bring your vision:req to life with speed without compromizingful on the quality factors.
$3,000 CAD in 4 days
6.5
6.5

Hi there, I understand you need a robust backend that transforms raw construction permit CSVs into a scored, enriched, and API-ready lead intelligence platform. I am confident I can build a production-ready solution that automates data ingestion, geocoding, lead classification, configurable scoring, and REST API delivery while remaining scalable for future enhancements. My approach will be to develop a modular FastAPI-based backend with PostgreSQL that imports and standardizes CSV data, validates and cleans addresses and phone numbers, geocodes project locations using the Google Geocoding API, and classifies every lead based on your business rules. I'll implement a configurable weighted scoring engine with an admin panel for adjusting score weights, keyword management, owner-type exclusions, batch uploads, and manual score overrides. The system will expose secure REST APIs with authentication, comprehensive logging, OpenAPI documentation, Docker deployment, and clean architecture to ensure seamless integration with your mapping platform. To ensure reliability, I'll include validation, automated testing, sample datasets, and complete documentation for deployment and future maintenance. How many CSV records do you typically process per batch, and should the scoring engine recalculate historical leads automatically whenever an admin updates the weighting model, or only for newly imported batches? I'm ready to start immediately. Warm Regards, Aneesa.
$1,000 CAD in 3 days
6.4
6.4

Hi, the part that jumped out is the "Acquire Number" vs "Calling Queue" classification off contractor name keywords - that's a fun little rules engine to get right, especially once you add the admin-editable keyword list and unfit owner types on top. I'd build this in FastAPI with Postgres, Celery (or just a cron) for the CSV watch-folder intake, and Google Geocoding for lat/lon. Scoring as a configurable weighted-sum table so you can tune timing window and category weights without touching code. GET /leads and POST /outcomes with a simple API key, Swagger docs included, Docker for deployment. We're a small dev team, been on Freelancer since 2008 with 664 reviews at 4.87, and this kind of ETL-plus-API backend is exactly our lane. Happy to sketch the data model first before we agree on scope.
$4,020 CAD in 10 days
5.9
5.9

Dear Client, Hello There! I’m Md Toriqul Islam, and I’m excited to partner with you. I can dive into your project immediately. I have over 10 years of experience building scalable backend systems, REST APIs, ETL pipelines, and admin dashboards using Python, FastAPI, Flask, Node.js, and PostgreSQL. I understand you need a backend system to ingest construction permit CSVs, clean and standardize data, geocode addresses, classify leads, calculate configurable lead scores, and expose everything through a secure REST API with a simple admin panel. I have built data processing, API, and database-driven applications with similar workflow automation and scoring logic. Skilled in: FastAPI, Flask, Node.js, PostgreSQL, Docker, REST API, CSV Processing, Google Geocoding API. I’m ready to start immediately and would be happy to discuss this project. Feel free to share your sample CSV and scoring rules. Looking forward to hearing from you. Best regards, Md Toriqul Islam
$250 CAD in 5 days
5.5
5.5

With an extensive background in backend development, inclusive of Python and Node.js, your project related to a Construction Lead Scoring System fits firmly within my area of proficiency. Let's dive into how well aligned my skill set is with your project requirements: As a backend developer, I've handled numerous CSV ETL pipelines akin to what you require for data intake and normalization. Referring to your desired features such as geocoding addresses using Google Geocoding API and storing lat/lon data - I've successfully integrated Google APIs along with various third-party APIs in past ventures. The scoring engine design outlined meshes incredibly well with my abilities too. I am all too acquainted with the configuration of weighted sum models which are fundamentally necessary for your lead scoring. Adaptability is also one of my winning traits, thus aiding me in implementing different and configurable features like "ideal timing windows" and adjustable lead scoring weights. My diligent nature further ensures all adjustments and modifications made via the admin UI will not only be efficiently executed but also thoroughly tested, giving you the confidence that the system will be optimized as per your unique business requirements. In addition to all the technical proficiency, understand that I value clear communication
$3,000 CAD in 25 days
5.7
5.7

As the founder of Solves Inn, a software development studio, I have extensive experience in exactly what you're looking for in this project: Backend Development and API design. Over the years, I’ve successfully built complex systems like an intelligent CRM that involved scoring and classifying leads. This is very much in line with what your flooring company needs - a construction lead intake and scoring system. I've also worked extensively with CSV files and ETL pipelines, ensuring smooth ingestion, data cleaning, geocoding, and more-through rich REST APIs. Moreover, your project requires an understanding of weighted-sum models and my experience extends to implementing similar scoring/logic algorithms. Given that your ideal window requires regular adjustment - a feature I find quite unique- my ability to create a highly configurable and flexible models will come in handy. Lastly, my familiarity with technologies such as Python (Flask/FastAPI) and PostgreSQL aligns very well with your backend requirements. You can rest assured that code quality, deployment using Docker containers or on cloud VMs like Google Cloud or AWS will be well taken care of. I believe my pool of skills and firm dedication to solving business problems digitally make me not only suitable for this project but a great choice for future partnerships as well.
$3,000 CAD in 6 days
5.2
5.2

Hello, I have worked on backend systems that import CSV data, clean contact fields, geocode addresses, and expose structured records through REST APIs. Your lead intake flow needs careful handling of permit data, phone and address cleanup, Google Geocoding, and status rules such as Visit In-Person, Acquire Number, and Calling Queue. I can build the CSV upload, PostgreSQL storage, scoring weights, keyword settings, and simple admin pages for batches and configuration. The API will return active leads with scores and lat/lon, accept visit outcomes, use simple token auth, and include setup notes, sample CSV data, and API docs. Best regards, Teo
$200 CAD in 2 days
5.3
5.3

I'll build this in FastAPI with PostgreSQL — CSV intake with column mapping and phone/address normalisation, Google Geocoding for lat/lon, automatic lead classification by keyword and contact completeness, and a configurable weighted scoring engine. Clean admin UI for weight adjustments, keyword management, and batch uploads, plus a documented REST API with /leads and /outcomes endpoints. Dockerised and ready to deploy.
$5,000 CAD in 7 days
5.4
5.4

The main challenge in this project is not only processing CSV files, but turning inconsistent permit data into a reliable lead intelligence system. The scoring engine, classification rules, and API structure need to be designed carefully so your sales workflow receives only actionable opportunities instead of just raw records. I have experience building backend systems, ETL pipelines, REST APIs, database-driven applications, and automation workflows. My approach would be to create a FastAPI-based backend with PostgreSQL, implement the CSV ingestion and normalization layer, integrate Google Geocoding, build the configurable scoring engine, and expose a clean API that your mapping/routing system can consume. I would also include a lightweight admin panel for managing scoring weights, keywords, lead classifications, and manual adjustments. The system will be containerized with Docker, documented with API specifications, and delivered with sample data to validate the complete workflow from CSV upload to lead retrieval.
$3,005 CAD in 7 days
5.4
5.4

Hi, This is a data-flow and decision-engine project, so I’d approach it with a clean, traceable pipeline to keep CSV intake, geocoding, and classification consistent as your rules evolve. My focus would be on the import-to-score path first: clean the CSV schema, normalize contact and address fields, geocode reliably, and store a repeatable score breakdown for each lead. Then I’d add admin controls for weights, keyword rules, “unfit” owner types, and manual overrides so your team can adjust logic without code changes. Key experience and skills: CSV upload and field mapping Data cleaning and geocoding Lead status rules Score engine with stored breakdown REST API with auth and pagination I can start by defining the data flow and implementing the core pipeline, then move into the admin controls and API endpoints. One quick question: should leads later marked “visited” stay in the database with a closed flag, or be fully excluded from the active API response and admin list? If you’d like, I can review this through Freelancer chat or video call between 11 AM and 8 PM IST. Regards, Ghanu & Samir KESHAV INFOTECH
$17 CAD in 18 days
5.4
5.4

Surrey, Canada
Payment method verified
Member since Dec 7, 2025
$10-9000 CAD
$10-30 CAD
$30-250 CAD
$30-250 CAD
$3000-5000 CAD
€8-30 EUR
₹12500-37500 INR
$10-10000 USD
₹12500-37500 INR
₹600-100000 INR
$30-250 NZD
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
$15-25 USD / hour
$30-250 USD
$10-30 USD
₹750-1250 INR / hour
₹1500-12500 INR
€30-250 EUR
₹1800-2800 INR / hour
$25-50 USD / hour
₹12500-37500 INR
$750-1500 USD
$2-8 AUD / hour