Earn 36,000 ($360.00)

Problem Description

We’re building an AI-powered marketing platform that connects to dozens of third-party data sources. We’ve already integrated platforms like Meta Ads, Google Ads, Pinterest Ads, and TikTok Ads — and we’re looking to scale our integrations pipeline with a freelance data engineer (2+ years experience).

You’ll help us:

• Implement new data ingestion pipelines from platforms like Shopify, Amazon, Klaviyo, and others.
• Navigate and complete developer approval processes for each integration.
• Manage back-and-forth communication with platform support teams — and translate feedback into clear, actionable tasks for our internal team.

The first 5 integrations we will focus on:

• Shopify
• Amazon Seller Central
• Klaviyo
• Notion
• Postscript (SMS)

(We will pay per integration completion)

---

Acceptance Criteria

API Integration

• Work with our team to define what data we want to pull and how it should be structured.
• Build and maintain API-based pipelines to ingest data into Postgres and BigQuery, using Python and SQL.
• Follow clean, scalable ETL patterns; handle pagination, auth, and rate limits.

Developer Approval & Feedback Loops

• Apply for developer access and ensure all required materials (technical specs, legal docs, demo access) are submitted.
• When platforms respond with questions or feedback, decipher exactly what they’re asking, and turn that into discrete internal tasks to unblock approval.
• Keep each platform’s approval thread active — no delays or dropped comms.

Collaboration & Coordination

• Track the status of ~3–5 integrations at once in our shared Notion workspace.
• Deliver daily updates and join 20-minute check-ins 3x/week.
• Coordinate with product and engineering to move quickly from prototype to production.

Definition of Done

• Integration is approved, implemented, validated internally, and documented.
• All feedback loops are closed and data is flowing reliably to our systems.

---

Technical Details

Core Stack & Tools

• Python, SQL
• Data Systems: Postgres and BigQuery
• APIs: RESTful endpoints (OAuth, API keys, webhook support)
• Tracking: Notion for project management, Slack/Zoom for sync

Requirements

• 2–3+ years of experience in data engineering or backend development
• Experience with REST APIs and building ETL pipelines
• Nice to haves: experience with DBT, and years working with marketing data and/or modeling data over-and-above pulling in raw data
• Strong understanding of OAuth/auth flows and API rate limits
• Excellent organization and written communication skills
• Able to independently manage multiple integration timelines