Please mention that you found this job on empllo.com. Thanks & good luck!
Tired of Manually Applying to Jobs?
Let JobCopilot do it for you!
Set your preferences and let your AI copilot handle the job search while you sleep.
- Applies for jobs that actually match your skills
- Tailors your resume and cover letter automatically
- Works 24/7—so you don't have to
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.
Meet JobCopilot: Your Personal AI Job Hunter
Automatically Apply to Remote Data Jobs. Just set your preferences and Job Copilot will do the rest—finding, filtering, and applying while you focus on what matters.
Help us maintain the quality of jobs posted on Empllo!
Is this position not a remote job?
Let us know!