inBeat Agency

Data Engineer

Posted 11 Days Ago

5 Locations

Remote

Mid level

AdTech • Agency • Marketing Tech

The Role

The Data Engineer will build a creative intelligence pipeline, connecting ad data to ETL processes, enabling time-series queries, and documenting the setup for handoff.

Summary Generated by Built In

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.