Salesforce Data Migration Specialist (Legacy Extraction Expert)

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 tot his job