Job Title: Salesforce Data Migration Specialist (Legacy Extraction Expert) Location: Remote Contract Type: Project-Based (Est. 4-8 Weeks) Compensation: [Insert Range, e.g., $60-$100/hr] - Make this high enough to get a pro.
The Mission: CodeBright is migrating a utility rebate management system OFF Salesforce and onto a modern proprietary architecture (PostgreSQL). We need a Data Engineer who understands the dark corners of the Salesforce data model to extract 10+ years of historical records—specifically complex file attachments.
This is NOT a standard "Salesforce Admin" role. We do not need dashboards or flows. We need a script-heavy data extraction strategy.
What You Will Do:
• Architect the Exit: Design the ETL strategy to move data from Salesforce Sales/Service Cloud to a JSON/SQL schema.
• The Hard Part (Files): Extract ~1TB of historical attachments. You must be an expert in querying ContentVersion and ContentDocumentLink to preserve the parent-child relationships between files and their original records.
• Schema Mapping: Map custom Salesforce objects (Projects, Measures) to our new database structure.
• Validation: Prove the data integrity (Record Counts, File Checksums) between Source and Destination.
Who You Are:
• Technical: You are comfortable writing custom Python, Node.js, or SQL scripts to hit the Salesforce Bulk API. You don't rely solely on the Data Loader wizard.
• Experience: You have successfully performed a "Salesforce-to-Custom-DB" migration before.
• Detail Oriented: You know that "Project_ID_c" in Salesforce needs to link to "project_id" in Postgres without breaking.
Required Tech Stack:
• Salesforce Bulk API / REST API
• Python (Pandas/SimpleSalesforce) or Node.js (JSforce)
• SQL / PostgreSQL
• ETL Tools (Talend, Jitterbit, or similar)
How to Apply: Please submit your resume and a brief answer to this question: "How do you handle the extraction of 'ContentDocument' files while maintaining their link to the parent 'Opportunity' object during a migration?"
Note: This is a key personnel role for a municipal government contract bid. We are selecting our Data Migration Lead now to include in our proposal, with work commencing immediately upon contract award (Estimated March 2026).
Job Type: Contract
Pay: $60.00 - $100.00 per hour
Application Question(s):
• Do you have experience extracting 'ContentDocument' or 'Attachment' files from Salesforce and preserving their parent-record relationships outside of the Salesforce ecosystem? Yes/No, please elaborate
• Have you performed a data migration where the destination was NOT another Salesforce instance (e.g., SFDC to SQL/Postgres)? (Yes/No/elaborate)
• Which tool do you prefer for high-volume Salesforce extraction: The Bulk API, Jitterbit/MuleSoft, or custom Python scripts? Please explain why in one sentence
Work Location: Remote
Apply Now
Apply Now