inBeat Agency

Data Engineer

Posted 11 Days Ago

Remote

5 Locations

Mid level

Remote

5 Locations

Mid level

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.

The summary above was generated by AI

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.

Top Skills

Airbyte

Data Engineering

Duckdb

ETL

Fivetran

Llm Integration

Meta Ads

Motherduck

Singer

SQL

Tiktok Ads

Similar Jobs

Zapier

Data Engineer

22 Days Ago

Remote

Mid level

Artificial Intelligence • Productivity • Software • Automation

As a Data Engineer at Zapier, you'll build scalable data systems, enhance product functionality through data, and collaborate with teams to improve data access and usability.

Top Skills: AWSAzureDatabricksGCPPythonSparkSQLTypescript

Spotify

Data Engineer

Yesterday

In-Office or Remote

Toronto, ON, CAN

Junior

Music

The role involves building and maintaining data processing tools on Google Cloud Platform, collaborating to improve the data ecosystem, and ensuring scalability for Spotify’s data needs.

Top Skills: DataflowFlinkGoogle Cloud PlatformPythonSparkStorm

Xpanse

Data Engineer

Yesterday

Remote

Entry level

Fintech • Software

The Data Engineer supports design and development of data systems and pipelines, executes data tasks, collaborates with teams, and troubleshoots data issues, focusing on continuous learning and participation in data quality assurance.

Top Skills: AWSAzureGCPGitJavaPythonSQL

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.