Engagement: Contract-to-hire
Location: Remote
Scope of Work
We need a hands-on Data Engineer to build out the backbone of our creative intelligence pipeline. The focus is on quickly standing up a system that pulls marketing assets from ad platforms, enriches them with AI analysis, and makes them queryable for pattern mining.
We are open to changing anything in the tool stack.
Responsibilities:
Connect Meta/TikTok ad data → ETL → MotherDuck/DuckDB.
Ensure creative asset URLs are accessible and linked to ad IDs.
Build schema + pipelines to run Gemini augmentations (hooks, pacing, overlays, beats, etc.) and store results in structured tables.
Enable time-series queries (spend, performance, retention) joined with creative insights.
Make outputs sliceable & pattern-ready for strategists and editors.
Document setup for easy handoff to internal teams.
Requirements:
Strong ETL + pipeline experience (Airbyte, Fivetran, Singer, or similar).
Comfortable with DuckDB/MotherDuck and SQL modelling.
API experience with Meta Ads / TikTok Ads.
Familiarity with AI/LLM integration (e.g., Gemini, OpenAI) a plus.
Contract-first mindset: able to deliver quick, working systems with clean documentation.
