Data and Automation Engineer
Powered By Love, Inc. is a dynamic nonprofit organization transforming "Love in Action" into tangible community restoration. We are currently scaling our operations for our upcoming flagship community initiative, The 831 Experience. We are seeking a brilliant, fast-moving Data & Automation Engineer to build and deploy a proprietary, automated corporate lead generation engine hosted entirely within a collaborative Google Sheets interface.
This is a pure backend engineering and scripting project. You will design a "one-click lookup tool" that allows our team to simply enter a business name, instantly scrap data networks for decision-maker profiles, automatically sort prospects into campaign categories, and dynamically generate initial outreach text copy.
The ideal developer has deep experience with web scraping frameworks, custom API chain integrations, and populating cloud spreadsheets via lightweight automation workflows.
Core Responsibilities
- Web Scraping & Data Extraction: Write robust, lightweight scraping workflows to instantly crawl the live web and extract institutional history, regional footprints, and community involvement patterns.
- Decision-Maker Discovery: Chain contact discovery APIs to automatically pull and verify direct corporate email networks and organizational titles for regional managers.
- Algorithmic Sorting Filters: Develop backend sorting logic that seamlessly categorizes businesses into pre-set campaign buckets based on corporate giving behaviors.
- Text Generation Integration: Implement basic text-generation prompt logic to instantly output custom, tailored email outreach drafts inside our shared drives based on verified data inputs.
- Ecosystem Handover: Package, comment, and hand over clean source scripts for permanent organizational custody and future scale.
Project Timeline & Implementation Sprints
The core architecture for an expert with this specific background is standard automation work that must be fully coded, tested, and pushed into production within a 3 to 5 business day sprint window:
- June 24 – June 30 (Architecture & Alpha Testing): Connect primary script engines, tie into target lookup APIs, and verify early proof-of-concept searches inside our Google Drive environment with zero script breaks.
- July 1 – July 5 (Copy Integration & Production Launch): Finalize automation logic rules, lock in the dynamic pitch generation modules, and execute a formal platform walkthrough with the marketing team.
- July 6 (Live System Deployment): Platform goes fully live into production to unlock automated, high-volume email campaign campaigns right after the July 4th weekend.
- August Close-Out (Maintenance & Final Audit): Provide ad-hoc script support during campaign waves and execute final permanent code asset delivery.
Qualifications & Technical Skillsets
- Professional mastery of Python and standard data engineering environments.
- Hands-on development experience using web-scraping and browser automation tools such as BeautifulSoup, Scrapy, or Playwright.
- Demonstrated experience handling API webhooks, token authentication, and data parsing (JSON/XML).
- Strong capability to map script data outputs directly into cloud sheet ecosystems via Google Sheets/Drive APIs or similar setups.
- A results-driven developer who thrives on high-speed, 3-to-5 day building sprints and takes pride in creating permanent digital assets.
🗓️ The Optimized Pay & Launch Timeline
- June 24 – June 30 (The Build Window): The engineer codes, integrates the APIs, and deploys the alpha lookup engine into your master drive.
- July 1 – July 5 (The Testing Window): Your outreach team runs test files to ensure the email text generation and bucket sorting works flawlessly.
- July 6 (The Live System Launch): The system officially goes live into production, and your team starts firing off automated pitches right after the July 4th weekend.
- 💵 July 15th Payroll — Milestone 1 Payout: Released after the system has successfully run live in production for its first full week with zero system breaks.
- 💵 August 15th Payroll — Milestone 2 Payout: Released after the tool successfully supports your team's high-volume mid-summer outreach blitzes.
- 💵 August 31st Payroll — Milestone 3 Payout & Bonus Closeout: Final contract clear-out, script optimization, permanent code handover, and release of the performance bonus if fundraising metrics are met.