Developer needed for AP callsI, data enrichment and data hygiene
Rozpočet: $30.0 - $45.0
HOURLY / PART_TIME
⭐ 5.00 (3)
United States
data-extraction, crawlers, python, data-scraping, salesforce-platform, quality-control, api
Understood. Here is a plain-text version designed for Upwork using only bold headings, hyphens, and spacing.
**Developer Needed for API Data Pull, Fuzzy Matching, Salesforce Import and Quality Control**
We are seeking a developer or data specialist for a one-time data project that may become a recurring monthly assignment.
**PROJECT OVERVIEW**
The project involves:
* Pulling data from a public database through an API
* Cleaning and structuring the extracted data
* Comparing the new data against existing Salesforce records
* Identifying matches, duplicates and new records
* Preparing and importing the final dataset into Salesforce
* Creating a clear quality-control process
**SCOPE OF WORK**
The selected freelancer will be responsible for:
* Extracting data from a public database using API calls
* Cleaning, normalizing and structuring the dataset
* Fuzzy matching the new data against existing Salesforce records
* Categorizing records as:
* Existing matches
* Likely duplicates
* New records
* Records requiring manual review
* Preparing the final data for Salesforce import or upsert
* Importing the data into Salesforce or providing a clean import file, depending on the agreed approach
* Creating a quality-control report showing:
* Match confidence levels
* Records excluded or flagged
* Import errors
* Changes made to the data
* Documenting the workflow so it can be repeated monthly
**REQUIRED EXPERIENCE**
Applicants should have experience with:
* API integrations and data extraction
* Python or a similar scripting language
* Data cleaning and normalization
* Fuzzy matching and deduplication
* Salesforce Data Loader, Bulk API or similar import tools
* Salesforce import and upsert procedures
* Data quality-control workflows
* Working with incomplete or imperfect CRM data
**PREFERRED EXPERIENCE**
The following experience would be helpful but is not required:
* Real estate, land, property, permitting or public-record datasets
* AscendixRE or another Salesforce-based commercial real estate CRM
* Designing scalable, recurring data workflows
**DELIVERABLES**
* Extracted and cleaned dataset
* Match results against existing Salesforce records
* Final Salesforce import or upsert file, or completed import
* Quality-control and exception report
* Brief documentation of the process
* Recommendations for converting the project into a recurring monthly workflow
**ENGAGEMENT TYPE**
This is initially a one-time project. If the work is accurate, well documented and repeatable, we would like to make it a recurring monthly assignment.
**TO APPLY**
Please include:
* Examples of similar API, data-cleaning or Salesforce projects
* Your recommended approach to fuzzy matching and quality control
* Details of your Salesforce import or upsert experience
* Your estimated timeline
* Whether you prefer a fixed-price or hourly engagement
Otvoriť na Upwork