Engagement: Contract-to-hire
Location: Remote
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.
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.
Top Skills
inBeat Agency Montréal, Québec, CAN Office
Montréal, Quebec, Canada
Similar Jobs
What you need to know about the Montreal Tech Scene
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal
