Data Engineer

Dentsu Canada, Inc.; Toronto; On-site; CAD 70,000 - 80,000; Full time

Benefits offered by this job

Medical insurance

Dental

RRSP

Paid time off

Job summary

Dentsu Canada, Inc. is seeking a Data Engineer in Toronto to own ingestion, modeling, and delivery of data from advertising platforms into reliable pipelines in a cloud data warehouse.

You will design, implement, and maintain data pipelines, APIs/connectors, and data models to support reporting, analytics, and activation for clients. Collaboration with analysts and ad-ops is essential.

Qualifications

• 3–5 years of professional data engineering experience.
• Experience with BigQuery, Redshift or Snowflake in production deployments.
• Strong SQL and Python for pipeline development and transformations.
• Experience with advertising platform data, APIs or connectors (e.g., Google Ads, GA4, Meta, TikTok, DV360).
• Understanding of marketing data concepts: impressions, clicks, conversions, attribution windows, UTM taxonomy.

Responsibilities

• Design, build, and maintain production data pipelines in a cloud data warehouse.
• Develop and manage API and connector-based integrations with major advertising platforms.
• Model campaign, spend, and performance data into clean, well-documented datasets.
• Monitor pipeline health and fix data discrepancies end-to-end.
• Partner with analysts, strategists, and ad-ops to translate reporting needs into scalable data models.
• Contribute to data quality, documentation, and engineering standards.

Skills

SQL

Python

Advertising data

Workflow orchestration

Git

Stakeholder communication

Tools

BigQuery

Redshift

Snowflake

Looker Studio

PowerBI

dbt

GCP

AWS

Azure

Job description

Job Description

Our mission is to Drive Business Performance. We use data to create personalized and connected experiences that deliver transformative business outcomes. Our role is to ensure our clients meet their quantifiable business goals every day, consistently, in every market. We are entirely focused on delivering better business results through optimization, creation and analysis across all digital platforms. Our scope ranges from recommending how to use content more effectively to optimizing daily media channel performance and maximizing visibility in eCommerce platforms.

We're looking for a Data Engineer with 3–5 years of hands-on experience to join our team. You'll own the ingestion, modelling, and delivery of data from the advertising platforms our clients run on — building reliable pipelines in a cloud data warehouse (BigQuery, Redshift, or Snowflake) that power reporting, analytics, and activation.

Accountabilities

Design, build, and maintain production data pipelines in a cloud data warehouse — BigQuery, Redshift, or Snowflake — from ingestion through to analytics-ready models.

Develop and manage API and connector-based integrations with major advertising platforms: Google Ads, GA4, Meta, TikTok, DV360, Campaign Manager 360, LinkedIn Ads, and similar.

Model campaign, spend, and performance data into clean, well-documented datasets that media, analytics, and client-services teams can trust.

Monitor pipeline health inclusive of enabling taxonomy compliance, troubleshoot data discrepancies against platform UIs, and own the fix end-to-end.

Partner with analysts, strategists, and ad-ops to translate reporting and measurement needs into scalable data models.

Contribute to data quality, documentation, and engineering standards across the team.

Qualifications

3–5 years of professional data engineering experience, including production deployments on a major cloud data warehouse such as BigQuery, Redshift, or Snowflake.

Strong SQL skills and solid Python (or equivalent) for pipeline development and transformation logic.

Demonstrated experience working with advertising platform data, pulling from platform APIs or connectors (e.g., Google Ads, GA4, Meta, TikTok, DV360) and reconciling it against platform reporting.

Understanding of advertising data concepts: impressions, clicks, conversions, attribution windows, UTM taxonomy, audience and cost data.

Experience with a workflow orchestrator (Airflow, Dagster, Prefect, or similar) and version control (Git).

Comfort working directly with non-technical stakeholders (media planners, analysts, and account leads) to scope and deliver.

Nice to have

Experience with dbt for transformation and modelling.

Familiarity with Looker Studio, PowerBI, or similar for downstream BI enablement.

Exposure to marketing measurement work such as MMM, MTA, incrementality testing, or clean-room environments (Ads Data Hub, Meta Advanced Analytics, Amazon Marketing Cloud).

Experience with broader cloud platform services such as GCP (Cloud Functions, Pub/Sub, Dataflow), AWS (Lambda, S3, Glue), or Azure equivalents.

Exposure to Databricks or other lakehouse platforms for large-scale data processing.

Prior experience at a media agency, ad-tech vendor, or in-house marketing data team.

Salary and benefits

The salary range for this position is $70k-80k. Actual salary within the salary range will be based on a variety of factors including relevant experience, knowledge, and skills.

A range of medical, dental, RRSP, paid time off, and/or other benefits also are available to all permanent employees.

AI Disclosure

[dentsu] utilizes artificial intelligence tools as part of its recruitment process, as during the sourcing and screening stages. All other parts of the dentsu application and hiring processes do not utilize artificial intelligence tools.

Inclusion & Accessibility

We know through experience that different ideas, perspectives and backgrounds foster a stronger and more creative work environment that delivers better business results. We strive to create workplaces that reflect the clients we serve and where everyone feels empowered to bring their full, authentic selves to work. We are committed to working with our candidates from all ability levels throughout the recruitment process to ensure that they have what they need to be at their best. If you need accommodation during the application or interview process, please contact [e-mail] or to begin a conversation about your individual accessibility needs throughout the hiring process.

Location & Employment type

Location: Toronto

Brand: Dentsu Media

Time Type: Full time

Contract Type: Permanent

About dentsu

For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way. Find out more about us.

Who we are

Our Social Impact

Our work