
Closed
Posted
Paid on delivery
Build a property-ownership data pipeline — Montreal real estate (contract, milestone-paid, remote) I run a commercial real estate brokerage in Montreal. I'm building a private database that maps every multi-residential building in a neighbourhood to the people and companies that actually own it — including owners hidden behind numbered companies. You'll build the data pipeline and database from scratch. It has to be clean enough to grow for years. What you'll build Ingest Quebec open data (Montreal assessment roll CSV, Registre des entreprises bulk export) into Supabase / Postgres Schema: Properties · Entities (people + companies) · Links · Sources — keyed on matricule and NEQ, not address strings Monthly refresh that's idempotent — re-run it ten times, same result, no duplicates Link engine: connect entities by shared director / shared address / same name+address. Confident matches auto-link; anything fuzzy goes to a human review queue, never auto-merged Flag portfolio owners (3+ properties) Push scored targets to [login to view URL] via API Monthly diff report: new sales, ownership changes, new buildings Phase 2 (separate quote): contact-enrichment waterfall across Apollo, RocketReach and Lusha APIs, with source + confidence logged per contact Stack: Python, PostgreSQL/Supabase, REST APIs. You should be comfortable using AI coding tools (Cursor, Claude Code, Copilot) and using an LLM API to parse messy text fields when it makes sense. Who I'm looking for Software Engineering, Computer Science or AI student/recent grad — McGill or Concordia preferred, Montreal-based a plus (you'll understand what REQ and the rôle d'évaluation are) You've shipped at least one data pipeline that ran unattended for months You care about the boring parts: keys, dedup, provenance, tests, a runbook someone else can follow You push back when a spec is wrong How it works Milestone 0 — paid test, $100: download the Montreal open-data roll, filter one borough to 5+ unit residential buildings, load it into Supabase with a clean schema. Two to three hours. This is real work, not a quiz. Milestones 1–3: schema + ingestion → link engine + review queue → Monday push + monthly diff. Phase 1 budget: $2,000–2,500, paid per milestone on delivery. Phase 2 quoted separately after Phase 1 ships. NDA + IP assignment signed before Milestone 0. To apply, answer one question: describe a data pipeline you built that ran on its own for 3+ months. What broke, and what did you do about it? Skip the cover letter. Phase 2 — Contact enrichment bot (quoted separately, after Phase 1 ships) Build a bot that finds the best way to reach each scored owner in the database and writes every result into the Contacts table. What it does Runs only on owners flagged as targets — never the whole database Strict waterfall, in this order, stopping when a verified mobile or direct line is found: [login to view URL] API — corporate email + phone on company-name and director-name matches RocketReach API — personal mobile + email on director name + city Lusha API — mobile fallback Web search — company site, LinkedIn, Canada411, Google — only when the three APIs return nothing Every hit becomes a new row in Contacts: entity_id · type · value · source · confidence score · date found. Nothing is overwritten Cross-checks: if two sources return the same number, confidence goes up; if a number belongs to a different person with the same name, it's flagged, not stored as the owner's Owners with no result after the full waterfall are tagged "field / direct mail" and pushed to [login to view URL] with the mailing address from the rôle Logs API credit usage per run so cost per found contact is visible Respects rate limits and each provider's terms
Project ID: 40711881
215 proposals
Remote project
Active 12 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
215 freelancers are bidding on average $2,016 CAD for this job

I am a recent Computer Science graduate from McGill University with experience in developing and managing robust data pipelines. I have worked with Python and PostgreSQL to create scalable and efficient data systems. My expertise includes designing clean schemas and implementing automated refresh cycles to maintain data integrity over long periods. A recent project involved building a pipeline that processed large datasets to provide insights for a retail analytics company. This system operated autonomously for six months, reliably updating data stores nightly. Initially, we faced issues with script failures due to unexpected data formats. I implemented logging and error-handling improvements, and established a robust mechanism for anomaly detection and reporting, ensuring resilience. I am keen to apply my skills to your "Montreal Realty Ownership Tracing Pipeline" project and am interested in the intersection of real estate and data automation. Please let me know how I can further discuss my fit for this role.
$3,000 CAD in 25 days
8.4
8.4

Hi — Elias here from Miami. I understand you're looking to build a data pipeline for property ownership in Montreal. This project involves consolidating data while ensuring its accuracy and accessibility for future analysis. The real technical challenge typically lies in integrating diverse data sources while maintaining data integrity. A common issue in such systems is ensuring the pipeline can scale with increasing data volumes. The tricky part is often managing the ETL process efficiently, especially when incorporating external APIs or varied data formats. My approach would start with a robust architecture that prioritizes scalability and maintainability. I’d focus on building a solid ETL framework using Python and PostgreSQL, ensuring that each step in the data flow is reliable and well-documented for future expansion. I've worked on similar projects, including real estate data systems and automated pipelines, which provided insights into potential pitfalls and best practices. A few questions to better understand the scope: Q1 – What specific data sources will you integrate into the pipeline? Q2 – Are there particular user roles or access levels we need to consider for data security? Q3 – How frequently do you expect the data to be updated or refreshed? Happy to go through the details and suggest the best technical approach. Looking forward to hearing from you.
$2,500 CAD in 10 days
8.0
8.0

⭐⭐⭐⭐⭐ Build a Property-Ownership Data Pipeline for Montreal Real Estate ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project details and see you're looking for someone to build a property-ownership data pipeline. You don't need to look any further; Zohaib is here to help you! My team has successfully completed 50+ similar projects in data management. I will design a clean and efficient data pipeline that can grow with your needs. My approach includes ingesting open data into Supabase/Postgres and ensuring a smooth monthly refresh without duplicates. ➡️ Why Me? I can easily create your data pipeline as I have 5 years of experience in data engineering, focusing on database design and data integration. My expertise includes Python, PostgreSQL, and API development. I also have a strong grip on data quality management and automation tools to ensure your project runs smoothly. ➡️ Let's have a quick chat to discuss your project in detail and I can show you samples of my previous work. Looking forward to it! ➡️ Skills & Experience: ✅ Python ✅ PostgreSQL ✅ Data Ingestion ✅ API Development ✅ Data Quality Management ✅ Schema Design ✅ Automation ✅ Data Analysis ✅ Monthly Reporting ✅ Data Deduplication ✅ Data Linking ✅ Problem Solving Waiting for your response! Best Regards, Zohaib
$1,800 CAD in 2 days
7.9
7.9

I built a data pipeline that ran unattended for months with scheduled ingestion, data validation, deduplication and processing across structured and unstructured sources. The main issues were API/data-source changes, inconsistent records and occasional failed runs. I handled these with idempotent processing, stable source keys, validation checks, error logging, retries and clear runbooks so failures could be identified and recovered without creating duplicates. For your Montreal property pipeline, I’d apply the same principles around matricule/NEQ keys, provenance, idempotent monthly refreshes, confidence-based entity linking, and human review for fuzzy matches. I’m also comfortable with Python, PostgreSQL/Supabase, REST APIs and LLM-assisted data processing. Let's schedule an online meeting to discuss your project in detail. Thanks
$2,250 CAD in 7 days
7.3
7.3

Hi, I'm Denis, a full-stack developer who has built several data pipelines running unattended in production. I understand what you're building—a clean, maintainable ownership-tracing system for Montreal real estate that stays accurate and deduped over time. I've worked on similar systems where messy source data needed normalization, deduplication, and linking across multiple identifiers. The key insight is that the boring parts—schema design, idempotency, provenance tracking, and review queues—make pipelines survive months of operation. My approach is straightforward. First, I'd design a solid schema around matricule and NEQ as primary keys, avoiding address-string matching. Then I'd build the ingestion layer to be fully idempotent—reruns produce identical results with no duplicates. For the linking engine, I'd implement confidence scoring: high-confidence pairs auto-link, fuzzy matches go to your review queue, and everything logs source and reasoning for auditing. The trickiest part is fuzzy matching logic. I'd use LLM-assisted parsing for messy text fields where useful, but keep core matching rules explicit and testable. You'll know exactly why two entities linked and can refine rules as you learn your data. One realistic risk: Quebec's open data formats might shift or have quality issues we discover during Milestone 0. I'd handle this by building the ingestion layer modularly, so schema changes don't break the pipeline. I can start right away. Let's discuss the detai
$1,500 CAD in 20 days
6.2
6.2

Hello!, I am a Florida-based senior software engineer, and this project stands out because the hard part is not just scraping data, it is building a reliable ownership tracing pipeline for Montreal real estate that stays accurate and maintainable. I’d handle it in clear phases: 1) confirm the exact sources and ownership rules 2) design a clean PostgreSQL schema for properties, entities, transfers, and milestones 3) build the ETL/scraping layer with validation, retries, and deduplication 4) add API integration where available, plus an audit trail 5) package it so you can run and extend it without headaches I pay attention to the details others miss, because one bad record can break the whole chain. My goal is a dependable pipeline, not a quick script. Relevant examples: - parcel-title tracking system for a regional analytics startup - municipal records ETL pipeline with PostgreSQL and Python - ownership-change dashboard for a private real estate team - document-to-database ingestion workflow for a legal data app Quick questions: 1) Which exact sources should this cover for Montreal ownership tracing? 2) Do you want ongoing updates, historical backfilling, or both? 3) Should the handoff be scripts only, or a full runnable service with logging? If you want someone who will think through the data model before coding, I’m your guy. -James
$2,400 CAD in 6 days
6.3
6.3

The fragile part of this project isn’t loading the CSVs — it’s keeping the matricule/NEQ‑keyed universe perfectly stable across monthly refreshes while the link engine evolves. Pipelines like this break when a tiny schema assumption changes or when fuzzy matches accidentally merge two unrelated entities. Getting idempotency right is the real work. I’ve built unattended pipelines where the ingestion layer, dedup logic and link rules had to survive messy government data. The biggest lesson was enforcing strict keys early, logging provenance for every field, and treating “maybe” matches as toxic unless a human approves them. My approach here would be to start with a minimal but durable schema in Supabase, then build ingestion functions that normalize roll + REQ data before anything touches the link engine. The link engine itself should operate in layers: deterministic matches first, fuzzy matches quarantined with full context, and a diff report generated from stable snapshots. A pipeline I shipped ran for about six months pulling municipal permit data. What broke was upstream format drift: a column changed type without notice, causing silent partial loads. I fixed it by adding schema‑validation gates, hashing raw files, and writing a small anomaly detector that flagged unexpected row deltas before ingestion. If you want, I can walk through how I’d structure Milestone 0. Juan Pablo
$2,250 CAD in 7 days
6.4
6.4

Hi, A pipeline that must re-run ten times with the same result lives or dies on the keys, and you already named the right ones: matricule and NEQ, not address strings. That's the part I'd nail first. My question on the link engine: for the human review queue, do you want the fuzzy candidates scored and ranked, or just flagged? I'd score them so your reviewer works top down and the confident auto-links stay untouched. I've built REST API integrations and unattended data workflows on Postgres, and we run an internal system that parses messy text with OpenAI and Claude APIs into structured records. BD Automation: internal, AI-parsed BD data pipeline. On the paid Milestone 0, I'd load one borough filtered to 5+ unit residential with a clean Properties, Entities, Links, Sources schema so you see the provenance model before committing further. Which borough do you want first? Adil
$1,999.32 CAD in 21 days
6.0
6.0

Hi I have recent experience on freelancer.com doing similar application for NY and NJ states. It was extracting data from sheriff sales, transforming and saving to Supabase. It was run based on some schedule, four times daily and was refreshing a data. It works unattended for months and getting fed to the specific AI solutions for business purposes. I would build this using Python and domain specific modules like Playwright or Selenium or httpx and curl-cffi modules to get the data. For operations on data I would use Numpy, Scipy and Pandas. For visualization I would use Matplotlib and Seaborn. I’m happy to discuss the details over chat, and I will respond promptly. Thanks for your attention Archil
$1,500 CAD in 7 days
6.2
6.2

Hello Sir, Have you considered a demo to visualize how our robust data pipeline can streamline your Montreal Realty project? We offer a meticulous approach to data integrity and ownership tracing while ensuring future scalability and precision in linking entities. Let's discuss how we can tailor this solution to fit your vision. Best, Smith
$2,250 CAD in 7 days
5.8
5.8

I built a python ETL pipeline that pulled structured and semi-structured data from multiple external sources, normalized it, deduplicated records using stable composite keys, and ran automatically on a Linux server. The main issue after running unattended was upstream data changing unexpectedly, including missing fields, duplicate records, and occasional request failures. I fixed it by making ingestion idempotent, adding schema validation, retry/error logging, deterministic upserts, and integrity checks so failed records could be reviewed without breaking the full run.
$2,250 CAD in 7 days
5.4
5.4

With over a decade of experience in software engineering, AI development, and database administration, my team at Fourge are experts in building robust, long-running data pipelines - just like the one you're seeking for Montreal Realty Ownership Tracing. We don't just deliver software; we transform ideas into solid, scalable digital products. For example, we recently built a data pipeline for a financial institution that ran autonomously for more than 3 years, ingesting and processing millions of transactions daily without a hitch.
$1,500 CAD in 7 days
5.6
5.6

Greetings, I see you're looking to build a comprehensive data pipeline to trace property ownership in Montreal, focusing on multi-residential buildings and hidden owners. My approach would start with ingesting the open data sources you mentioned and structuring it in Supabase/PostgreSQL, ensuring a clean schema that supports future growth. I’d implement a robust link engine to connect entities intelligently while maintaining a review queue for any uncertain matches. In a previous project, I developed a data pipeline that managed real-time updates for an e-commerce platform. When it faced a downtime issue, I quickly identified the root cause in the API integration and adjusted the error handling to prevent future occurrences. My attention to detail and commitment to best practices will ensure your project runs smoothly. Best regards, Saba Ehsan
$1,600 CAD in 7 days
5.1
5.1

Hi there, I'm Karthik, a software engineer with over 15 years of experience in building robust data pipelines. I’m excited about the opportunity to develop the Montreal Realty Ownership Tracing Pipeline. I have extensive experience with Python, PostgreSQL, and REST APIs, and I'm well-versed in using AI coding tools. For your project, I will ensure a clean schema and efficient ingestion of Quebec open data into Supabase/Postgres. I'll implement a reliable linking engine that addresses your requirements for confident matches and a human review queue for fuzzy matches. My focus will be on data integrity, deduplication, and comprehensive testing, ensuring the pipeline runs unattended without issues. Regarding the data pipeline I built: I created a real-time analytics pipeline for e-commerce that operated for 6 months. It faced occasional API rate limits, which I resolved by implementing a robust error-handling mechanism and queue system. I am ready to begin with the paid test and look forward to discussing how I can contribute to your project. Best, Karthik
$2,250 CAD in 7 days
5.7
5.7

Hello I built a nightly data pipeline that ingested SaaS product usage and billing data from multiple APIs (Stripe, Chargebee, internal event logs) into a Postgres warehouse, then pushed curated metrics to a dashboard and CRM for churn/expansion alerts. It ran on its own for about a year, with jobs orchestrated via cron + lightweight Python runners and idempotent upserts keyed on customer and invoice IDs. What broke first was upstream change and bad data: one provider silently added new fields and changed a status enum, which caused a subtle misclassification of “trial” vs “active” accounts. Later, API rate limits and occasional 500s started causing partial loads. I fixed it by tightening schema validation, adding explicit mapping layers between raw and curated tables, and introducing per‑source health checks with alerting. On the ingestion side I switched to paginated, retry‑aware clients with backoff, made every step idempotent (upsert on natural keys, soft‑delete on missing records), and wrote a small runbook so someone else could debug failures from logs and diff reports without me.
$2,250 CAD in 7 days
5.2
5.2

Hello, After reviewing your project requirements, I understand that you need a reliable real estate data pipeline that can ingest public datasets, normalize ownership information, create entity relationships, and maintain a clean long-term database. I have experience with Python data pipelines, ETL workflows, PostgreSQL/Supabase databases, API integrations, data cleaning, deduplication, and automation. I can build the ingestion system, structured schema, matching logic, review workflow, and reporting pipeline with proper source tracking and documentation. The key challenge in this project is connecting fragmented ownership data while avoiding incorrect merges. My approach would be to create a source-driven data model, use confidence scoring for entity matching, keep uncertain cases in a review queue, and build idempotent monthly refresh jobs so the database remains accurate over time. I have a couple of quick questions: • Which Montreal open-data sources are already approved for Phase 1, and do you have sample CSV/export formats available? • For the matching engine, do you prefer a rules-first approach initially or adding LLM-assisted parsing for complex ownership cases from the beginning? I would be glad to discuss the pipeline architecture and help build a scalable foundation for your real estate intelligence platform. Best regards, Carlos.
$1,500 CAD in 14 days
5.4
5.4

Matricule plus NEQ as keys is what lets a monthly refresh run ten times and land on the same rows. Your question: at MacKenzie & MacKenzie Consulting (2022-2026) I built the data pipelines and warehousing behind the React/Reflex apps that put results in front of end users, and they ran for years, not months. What breaks in that kind of pipeline is upstream, not code: a source file changes a column or encoding with no notice, and a run that reports success writes bad rows. So ingest gets a schema check that fails loudly and stops the run, every write is an upsert on a stable key so a re-run repairs rows instead of duplicating them, and a row-count diff against last month goes into the log so a silent drop shows up. For Milestone 0, I'd filter the rôle d'évaluation to one borough and 5+ unit residential, load it keyed on matricule with the raw row kept in Sources, and hand you the schema plus a short runbook. The part I'd watch in Phase 1 is address matching against the REQ export, since its addresses are free text and need normalising before they can be a link rule; anything below a set score goes to the review queue, never merged. Send the NDA and IP assignment and you'll have Milestone 0 back within two days of signing.
$2,000 CAD in 7 days
5.0
5.0

Hello. I have previously built unattended data pipelines using Python, PostgreSQL, APIs, deduplication logic, and entity-matching workflows, with a strong focus on data provenance, idempotent processing, and production reliability. The "boring" engineering details in this project are exactly where I do my best work. 1. Can you share the Montreal assessment roll and REQ bulk-export formats you expect to use for Milestone 0, including any known schema changes between monthly releases? 2. For the human review queue, do you already have preferred confidence thresholds and review fields, or would you like me to design the matching/scoring model? Your answers will greatly help me understand the project, and my approach would be simple: establish stable matricule/NEQ-based schemas first, build reproducible ingestion with source provenance and tests, then add conservative entity linking with fuzzy matches routed to review rather than risking incorrect ownership merges. I can start immediately, and I understand this is not just a scraper but the foundation of a long-term commercial intelligence database, so I will prioritize correctness, traceability, maintainability, and a pipeline you can confidently run month after month. Let's discuss this project further Best regards, Jeff Chong.
$2,250 CAD in 7 days
5.0
5.0

Hi there, I think the main goal is to build a reliable exam platform where the core testing flow works smoothly and AI adds real value before and after each attempt. I’d structure the app around secure authentication, question-bank management, randomized timed exams, scoring and MySQL result history, then integrate an AI chat panel that is disabled during active exams. For the study layer, I’d analyze each student’s incorrect answers and topic-level performance to generate targeted recommendations using the LLM through a backend API. I’d keep API keys in environment variables, document the setup, make the UI responsive, and structure the backend so voice assistance or proctoring can be added later without rebuilding the foundation. Looking forward to work with you. Thanks
$1,600 CAD in 7 days
4.7
4.7

Hello Client, I am eager to contribute to your Montreal real estate ownership tracing pipeline with my extensive experience in building robust data pipelines utilizing Python and PostgreSQL. I understand the critical importance of clean schema design keyed reliably on unique identifiers such as matricule and NEQ to ensure data integrity and provenance over time. My approach emphasizes idempotent In a prior project, I developed a multi-source real estate data pipeline that ran unattended for over six months, integrating public datasets into a centralized PostgreSQL warehouse with automated monthly refreshes. When unexpected schema changes broke ingestion, I implemented schema validation, alerting, and automated rollback to mitigate downtime and data corruption—measures that would be directly applicable here. I am confident in designing your Supabase-backed pipeline, creating a link engine for entity resolution, and delivering clean, maintainable code with thorough tests and documentation. I welcome signing an NDA and appreciate your milestone-based approach. I also have experience leveraging AI-assisted coding tools to parse complex, unstructured text data precisely. Thank you for considering my bid—I look forward to collaborating with you on building a reliable, long-term data foundation for your property ownership analysis. Best regards, Özgür
$1,500 CAD in 7 days
4.9
4.9

Laval, Canada
Member since Sep 15, 2026
$15-25 USD / hour
$10-30 USD
$8-15 USD / hour
₹12500-37500 INR
$2-8 USD / hour
$30-250 USD
₹12500-37500 INR
$250-750 USD
₹1500-12500 INR
€8-30 EUR
$25-50 USD / hour
₹3000-5000 INR
$30-250 USD
$10-30 USD
$8-15 USD / hour
$15-25 USD / hour
$15-25 USD / hour
₹5000-20000 INR
₹750-1250 INR / hour
$250-750 USD