
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
Project ID: 40619626
247 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
247 freelancers are bidding on average $4,022 CAD for this job

I can build this as a clean backend system with CSV ingestion, lead scoring, classification rules, admin settings, and a documented REST API. Your scope is well outlined, which is great because it reduces ambiguity and helps keep the build structured from day one. I’d likely use FastAPI + PostgreSQL for this so the API stays fast, maintainable, and easy to extend later. Dockerized delivery, environment-based config, and a clear setup guide can all be included.
$2,790 CAD in 24 days
9.4
9.4

Hi there, We understand you need a Construction Lead Intake & Scoring System that ingests CSV files, cleans and enriches the data, calculates a lead score, and exposes it via a REST API. Our team has experience with backend development, CSV ETL pipelines, and creating clean APIs, having worked on similar projects such as a learning platform website and an e-commerce website for a luxury leather retailer. We can deliver a fully working backend with an admin UI, API documentation, and a setup guide within the 3-4 week timeline. One question: Are there any specific security or authentication requirements for the API beyond the simple auth mentioned? Feel free to message us to discuss the details! — Webbook Studio
$2,150 CAD in 30 days
9.2
9.2

As a highly skilled and experienced freelancer leading CnELIndia, your construction lead intake and scoring system project would be in the hands of proven professionals. With an impressive 18 years in web and app development, we've made organizations' complex data handling processes seamless using Python et al. Resultantly, we have a proven ability to skillfully work with CSV ETL pipelines;databases like PostgreSQL;geocoding APIs such as Google's; implementing basic scoring logic like your project requires; creating clean APIs; as well as a host of other technology proficiencies you've outlined. Our record of consistently delivering projects on time and within budget rests on our relentless commitment to hard work that is second to none. Additionally, underpinning our portfolio of success are glowing testimonials from over 743 satisfied clients who have commended our expertise in transforming complex data sets into intuitive systems. While your project can be done by many freelancers, we carry a distinct advantage in our grasp of the unique challenges that arise in working with construction data. We understand first-hand the value delivered through quality leads, timely engagement, effective mapping tools for routing strategies and therefore we appreciate the gravity of this task ahead not just as an application but also as your potential partner in business growth.
$3,005 CAD in 45 days
9.0
9.0

Hi, With 19+ years of experience in web and software development, we at IT Flex Solutions India are perfectly poised to bring your vision to life. Your project requires a construction lead intake & scoring system that efficiently handles CSV uploads, data cleaning, geocoding, automatic classification, and a robust lead scoring engine. We've handled similar projects in the past and have a solid understanding of what it takes to create a superlative backend system. You needn't worry about execution as we are highly skilled in the backend development using technologies such as Python (Flask/FastAPI) or NodeJS - giving you the flexibility to choose what suits your requirement best. Our proficiency in utilizing Google Geocoding API and success with setting up basic scoring logic comes into sharp focus for this project. We've built clean APIs in the past that function flawlessly and aligns well with your need for a REST API. Moreover, we will also create an admin panel where you can effortlessly adjust lead scoring weights – providing endless customization possibilities. Thanks, SBM
$3,000 CAD in 28 days
9.1
9.1

Hi, I reviewed your Construction Lead Intake & Scoring System: ingest CSV uploads, normalize fields, geocode addresses, classify leads, compute a 0-100 score, and expose results via a REST API. I’ll build the backend pipeline with clean CSV ETL into PostgreSQL, design a robust schema and software architecture for lead batches, implement Google geocoding with retries, and add MySQL-style data hygiene patterns while using PostgreSQL storage. The lead classification rules (Visit In-Person / Acquire Number / Calling Queue), configurable weighted scoring model, and admin keyword management will be backed by REST endpoints: GET /leads and POST /outcomes, secured with a simple token. I focus on clean code, responsive iteration, and reliable deployments with Docker plus Swagger docs. Let’s discuss here now.
$150 CAD in 7 days
8.5
8.5

Hi — Elias here from Miami. I understand you need a system for managing construction leads with scoring and classification. The goal is to streamline your intake process and effectively prioritize leads. What usually matters most here is handling various lead sources and integrating them into a cohesive scoring system. A common issue in systems like this is ensuring the scoring logic is flexible and transparent. The tricky part is maintaining reliability as lead volume grows while ensuring automated scoring aligns with business objectives. My approach would involve designing a modular architecture, allowing for easy updates and integration with existing tools. By focusing on stability and maintainability, I can help future-proof the application and simplify workflows. I have experience building similar systems that required robust lead management and scoring, which taught me the importance of adaptability and clear data handling. A few questions to better understand the scope: Q1 – What user roles do you envision interacting with the system? Q2 – How do you plan to handle lead integrations? Q3 – What specific scoring criteria are most important to you? Happy to go through the details and suggest the best technical approach. Looking forward to hearing from you.
$5,000 CAD in 17 days
8.6
8.6

Hello, I will deliver the full CSV intake pipeline, scoring engine, and REST API for your flooring permit leads. The system will ingest your building permit dumps, clean and geocode addresses via Google Geocoding API, classify each lead into "Visit In-Person," "Acquire Number," or "Calling Queue," then assign a 0 to 100 weighted score stored in PostgreSQL. On a similar ETL project, building the keyword detection and classification as a configurable rule set (not hardcoded) saved the client hours of rework when their filter terms changed. I will structure yours the same way through the admin panel. Questions: 1) For the ideal timing window, is that one global value or does it vary by project type or region? Send me a message and we can go over the details. Best regards, Kamran
$11 CAD in 30 days
8.6
8.6

I am well-versed in developing backend systems and have extensive experience working with Python and Node.js for creating scalable applications. With a strong background in handling CSV pipelines and integrating APIs, I can efficiently develop the Construction Lead Intake & Scoring System as described in your project listing. My expertise includes working with the Google Geocoding API and establishing clean REST APIs, which aligns perfectly with your need for data enrichment through geocoding and API exposure. I have previously implemented lead scoring models and data cleaning solutions, ensuring accuracy and efficiency in ETL processes. My experience with PostgreSQL ensures compatibility with your project requirements, and I can set up a Dockerized deployment environment or provide instructions tailored to cloud VMs. I am interested in understanding more about specific admin panel features you might envision. Let's discuss how I can tailor my approach to meet your requirements and ensure a smooth integration. I am available to provide further details and answer any questions you may have.
$5,500 CAD in 30 days
8.5
8.5

Building a robust lead intake and scoring system requires a solid architecture that can handle incoming data points and process them against your specific criteria. I can develop a streamlined flow that captures your leads and assigns scores based on your requirements, ensuring you focus your efforts on the highest-value opportunities. With over 15 years of experience in PHP, JavaScript, and MySQL, I build custom backend solutions that go beyond simple templates. Whether this needs to integrate with your existing CRM or a custom database, I have the technical background to structure the logic for efficient data handling and reliable scoring. I can complete this system for $2584.27 within 1 day. Let me know if you want to jump on a quick call to map out the scoring logic so I can get to work.
$2,584.27 CAD in 1 day
8.1
8.1

Hey there, I can see the hidden challenge here: you don’t just need a CSV importer, you need a reliable decision engine that turns messy permit data into actionable leads. I’ve built backend systems like this with Python/Flask, FastAPI, and PostgreSQL-style data flows, including CSV normalization, geocoding, scoring logic, admin controls, and clean REST APIs. I’d structure the intake, cleanup, classification, and lead-score pipeline so each record is processed consistently, stored cleanly, and exposed through secure endpoints for your mapping tool. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. Would you like the scoring model to be rule-driven first, with historical conversion weighting added once enough outcome data accumulates? I can also keep the admin panel simple and functional for weight tuning, keyword rules, and manual overrides. Looking forward to your reply so we can finalize the exact plan. Thanks, Asad
$30 CAD in 3 days
8.3
8.3

Hi, Let's schedule a call and discuss there I’d build this in FastAPI with PostgreSQL, keeping CSV intake, geocoding, classification, scoring, and API delivery as separate modules. That will make the scoring rules easy to adjust later without touching the import pipeline. I’ve built SaaS platforms with configurable business rules, data imports, admin settings, REST APIs, background processing, and audit-friendly workflows. The 3–4 week timeline is realistic.
$6,000 CAD in 7 days
7.8
7.8

Hello!! I have similar kind of expertise and work experience for the {{ CONSTRUCTION LEAD INTAKE & SCORING SYSTEM }} I have built backend systems, data processing pipelines, CRM solutions, lead management platforms, and API-driven applications before and can share relevant experience. I have 10+ years of experience in backend development, Python, FastAPI, Node.js, PostgreSQL, REST API development, data automation, ETL pipelines, geolocation services, and scalable business applications. I can build a complete lead intake and scoring system that will handle CSV processing, data cleaning, address normalization, Google Geocoding integration, automated lead classification, configurable scoring logic, admin settings, and REST API integration for your mapping/routing platform. I will implement: • CSV upload and automated data processing workflow • Lead classification and status management • Configurable 0–100 scoring engine with adjustable weights • Geocoding and location data storage • Admin dashboard for managing settings, keywords, and lead controls • Secure REST APIs with authentication • Database design with clean and maintainable architecture • Docker deployment setup and documentation I will provide clean source code, technical documentation, API documentation, deployment instructions, test samples, and 2 years of FREE ongoing support after project completion. Thanks.
$500 CAD in 7 days
7.7
7.7

Building the "brain" that ingests permit CSVs, cleans and enriches them, scores each lead, and serves it all via a clean REST API is exactly the kind of backend I enjoy architecting well. I'd build it in Python (FastAPI) with PostgreSQL: a robust CSV parser that maps your columns and handles missing fields gracefully, phone/address normalisation, and Google Geocoding to store lat/lon (cached so you don't re-pay for repeat addresses). The classification and 0–100 scoring would live in a configurable rules engine — driven by your keyword lists and thresholds through the admin settings panel — so "Visit In-Person", "Acquire Number" and score weights can be tuned without code changes. Clean, documented endpoints will feed your mapping tool smoothly. I can start right away.
$10 CAD in 1 day
7.6
7.6

Hey, I’ve carefully reviewed your project, and I understand you need a reliable backend engine that transforms raw construction proposal data into actionable, prioritized leads for your sales workflow. I can help build a clean ETL pipeline and API-driven system that improves lead qualification and field efficiency. I will develop the CSV ingestion system, data cleaning and geocoding workflow, configurable scoring engine, admin settings panel, REST APIs, authentication, and deployment setup with documentation. I’ll ensure the system is structured for accurate scoring, easy adjustments, and smooth integration with your mapping tool. I have hands-on experience with similar backend, data processing, and API-driven applications and would be happy to share relevant examples during our discussion. One quick question: Do you already have historical lead outcomes available for calculating regional and project-type conversion rates, or should the system start collecting this data from launch? Portfolio: https://www.freelancer.com/u/Hammadhassan21 Best Regards, Hammad Hassan
$3,000 CAD in 20 days
7.6
7.6

Hi, I checked your "Construction Lead Intake & Scoring System" project and it looks like understanding the existing workflow will be important before making any changes. I've worked on similar PHP projects involving php, javascript, python, software architecture, mysql, postgresql, backend development, api development and prefer delivering work in small milestones so everything stays easy to review and adjust if needed. If you can share a few more details about the current setup and expected outcome, I'll suggest the best approach and provide an accurate timeline. ⭐ 5.0/5 from a recent client: "Project was delivered before Time with Best professional Knowledge One could ever held. Thanks for the support" Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.
$3,600 CAD in 51 days
7.7
7.7

Hi, The classification and scoring split you describe is the tricky part, not the CSV ingest. On a recent contract I built a deterministic ingestion pipeline with a secure CI setup, so idempotent re-imports and clean handling of missing fields is familiar ground. Secure CI Pipeline & Deterministic Ingestion: private client project, repeatable data ingest One design question early: your subcontractor keyword rule and the "Unfit" owner-type flag can collide (a lead could match both). I'd make status a resolved priority order stored per lead, so admin overrides never fight the auto-rules. Same for the score, stored on write, recalculated only when weights change. FastAPI plus Postgres, Dockerized, with a Swagger doc for the two endpoints your mapping tool consumes. Which category list and keyword set do you want seeded first? Adil
$2,090.22 CAD in 21 days
7.5
7.5

Hi, What you're building is essentially the decision engine for your sales process, so I'd focus on making the pipeline reliable, configurable, and easy to evolve rather than hardcoding business rules. I'd structure the solution into four independent modules: CSV Intake & Validation, Data Enrichment (normalization + geocoding), Lead Classification & Scoring, and REST APIs/Admin Panel. This keeps the scoring logic configurable while allowing future enhancements without affecting the ingestion pipeline. The admin panel will let you adjust scoring weights, keyword rules, owner classifications, and ideal timing windows without code changes. Every imported lead will follow the same standardized workflow before being exposed through secure APIs to your mapping application. Can you share a sample csc so I can get some idea about the data you receive. I will add the value as a technical partner not just as a developer to this project. I have few suggestions, can we discuss. Regards, Avinash Jain Procode IT Services
$2,350 CAD in 15 days
7.7
7.7

I'll build this in Python (FastAPI) with PostgreSQL: a CSV intake pipeline that normalizes phone numbers and addresses, geocodes through the Google Geocoding API, and runs your classification rules (no-phone to Visit In-Person, keyword-matched contractors to Acquire Number, else Calling Queue). The scoring engine will be a configurable weighted model covering timing, regional conversion rate, project value, type suitability, and data completeness, with an admin UI to adjust weights, manage the subcontractor keyword list, and mark owner types unfit. I'll expose GET /leads and POST /outcomes with token auth, package it in Docker, and include OpenAPI docs, a README, and sample CSV/outcome data to prove the flow end to end.
$1,500 CAD in 21 days
8.2
8.2

Hello!, I am a Florida-based senior software engineer(frontend, backend, ecommerce, etc) and I read your Construction Lead Intake & Scoring System brief carefully. The goal is clear: capture construction leads, score them accurately, and classify/rout them so the best opportunities are handled first. I have about 15 years of experience building backend systems, APIs, scoring logic, databases, and automation with PHP, JavaScript, Python, MySQL, and PostgreSQL. I build practical, maintainable systems that support real business decisions, not just basic forms. My approach would be: 1. Map the intake fields and scoring rules 2. Build the classification engine and database structure 3. Connect APIs, alerts, and admin views 4. Test edge cases so the scoring stays reliable as volume grows Relevant work includes: - a lead qualification dashboard for a home services platform - a custom intake and routing system for a commercial services agency - an internal scoring tool for a regional contractor network - an API-driven CRM automation layer for a B2B operations team Could you please clarify the following questions to help me better understand the project? 1. What fields should affect scoring, and are there any disqualifiers? 2. Is this a standalone system or an integration with an existing CRM/site? 3.
$4,200 CAD in 12 days
7.0
7.0

Hello, I have strong backend experience with CSV intake, data cleaning, geocoding, scoring logic, and REST APIs for business workflows. For this system, I can use Python with FastAPI, PostgreSQL, Google Geocoding API, and a small JavaScript admin UI for uploads, weights, keywords, and lead overrides. I will structure the Software Architecture around repeatable import batches, clear lead statuses, stored scores, and API key protected endpoints. The scoring model will support configurable weights, ideal timing windows, historical conversion inputs, and graceful handling of missing phone or address data. I will also provide Docker setup, API docs, sample CSV data, and a README. Best regards, Teo
$200 CAD in 2 days
6.8
6.8

Canada
Payment method verified
Member since Jul 31, 2026
$3000-20000 CAD
$10-10000 CAD
$30-250 CAD
$10-150 CAD
$10-9000 CAD
₹100-400 INR / hour
$30-250 USD
₹100-400 INR / hour
₹600-1500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD
$3000-5000 USD
£20-250 GBP
$15-25 USD / hour
₹12500-37500 INR
₹2500-3500 INR
$15-25 USD / hour
$250-750 USD
₹400-750 INR / hour
$100-200 USD
₹12500-37500 INR
₹600-1500 INR
₹750-1250 INR / hour
€250-750 EUR