数据工程师
岗位摘要
设计、构建和维护云数据仓库(BigQuery/Redshift/Snowflake)中的生产数据管道,从数据摄取到分析就绪模型的全流程;开发和管理与主要广告平台的API及连接器集成,包括Google Ads、GA4、Meta、TikTok、DV360等,实现数据自动化摄取
登录后保留你的岗位线索
邮箱登录后可继续查看完整职责、任职要求和原岗位入口,并使用收藏与浏览记录沉淀适合自己的机会。
岗位职责
- 设计、构建和维护云数据仓库(BigQuery/Redshift/Snowflake)中的生产数据管道,从数据摄取到分析就绪模型的全流程
- 开发和管理与主要广告平台的API及连接器集成,包括Google Ads、GA4、Meta、TikTok、DV360等,实现数据自动化摄取
- 将广告系列、支出和绩效数据建模为干净、有文档的数据集,确保媒体、分析和客户服务团队的数据可信度
- 监控管道健康状况,包括税收分类合规性,排除数据差异问题并端到端负责修复
- 与分析师、策略师和广告运营团队合作,将报告和衡量需求转化为可扩展的数据模型
任职要求
- 3-5年专业数据工程经验,包括在BigQuery、Redshift或Snowflake等主流云数据仓库上进行生产部署
- 扎实的SQL技能和Python开发能力,用于管道开发、数据转换逻辑和自动化任务
- 具有广告平台数据工作经验,熟悉从平台API或连接器获取数据并与平台报告对账的流程
- 理解广告数据核心概念:展示量、点击量、转化量、归因窗口、UTM分类、受众和成本数据
- 熟练使用工作流编排工具(Airflow/Dagster/Prefect)和版本控制工具(Git)进行协作开发
- 具备与媒体策划师、分析师和客户负责人等非技术利益相关者直接沟通和交付的能力
加分项
- Experience with
- 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).
- broader cloud platform
- services
- (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.
- Additional information
- Vacancy
- Is this posting for the purposes of filling an existing vacancy [
- 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.
- 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
- Canada.Recruitment@dentsu.com
- or to begin a conversation about your individual accessibility needs throughout the hiring process.
- Location
- Toronto
- Dentsu Media
- Time Type
- Full time
- Contract Type
- Permanent
登录后查看完整岗位详情
使用邮箱验证码登录后,可查看完整职责、任职要求、原岗位入口,并继续使用收藏和浏览记录。列表摘要保持公开,完整详情用于保护数据质量和降低恶意抓取。