Data Engineer

Dentsu

Job Location:

Toronto - Canada

Monthly Salary: $ 70 - 80

Posted on: 18 hours ago

Vacancies: 1 Vacancy

Job Summary

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.

Werelooking for a Data Engineer with35years of hands-on experience to join our team.Youllown 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 andmaintainproduction data pipelines ina cloud data warehouse BigQueryRedshift 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 healthinclusive 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:

35years of professional data engineering experience including production deployments ona major cloud data warehousesuch asBigQuery Redshift or Snowflake.

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

Demonstrated experience working with advertising platform datapulling 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 taxonomyaudienceand cost data.

Experience with a workflow orchestrator (AirflowDagster 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 withdbtfor transformation and modelling.

Familiarity with Looker StudioPowerBI or similarfor downstream BI enablement.

Exposure to marketing measurement worksuch asMMM MTA incrementality testing or clean-room environments (Ads Data Hub Meta Advanced Analytics Amazon Marketing Cloud).

Experience withbroader cloud platformservicessuch asGCP(Cloud Functions Pub/Sub Dataflow) AWS (Lambda S3 Glue) or Azure equivalents.

Exposure to Databricks or otherlakehouseplatforms for large-scale data processing.

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

Additional information

Vacancy:Is this posting for the purposes of filling an existing vacancy Y/N

The salary range for this position is$70k-80k. Actual salary within thesalary range will be based on avariety of factors including relevantexperience knowledge and skills.A range of medical dental RRSPpaid time off and/or other benefitsalso are available to all permanentemployees.

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.

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 or to begin a conversation about your individual accessibility needs throughout the hiring process.

Location:

Toronto

Brand:

Dentsu Media

Time Type:

Full time

Contract Type:

Permanent

Required Experience:

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 f...