数据工程师
岗位摘要
设计、构建并维护云数据仓库(BigQuery、Redshift或Snowflake)的生产数据管道,实现从数据采集到分析就绪模型的全流程;开发并管理主要广告平台(Google Ads、GA4、Meta、TikTok、DV360等)的API及连接器集成,确保数据准确采集
登录后保留你的岗位线索
邮箱登录后可继续查看完整职责、任职要求和原岗位入口,并使用收藏与浏览记录沉淀适合自己的机会。
岗位职责
- 设计、构建并维护云数据仓库(BigQuery、Redshift或Snowflake)的生产数据管道,实现从数据采集到分析就绪模型的全流程
- 开发并管理主要广告平台(Google Ads、GA4、Meta、TikTok、DV360等)的API及连接器集成,确保数据准确采集
- 将广告活动、支出和性能数据建模为清晰、文档完善的数据集,供媒体、分析和客户服务团队使用
- 监控管道健康状况,执行分类法合规性检查,排查并解决数据与平台界面的差异问题
- 与分析师、策略师和广告运营团队合作,将报告和测量需求转化为可扩展的数据模型
任职要求
- 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
登录后查看完整岗位详情
使用邮箱验证码登录后,可查看完整职责、任职要求、原岗位入口,并继续使用收藏和浏览记录。列表摘要保持公开,完整详情用于保护数据质量和降低恶意抓取。