Sr. Associate
dentsu · Posted Sep 29
Integrated advertising, marketing, media, and business transformation services
Get a personal compatibility score
Add a resume for personal matches
About the role
The role sits within dentsu/Merkle's data engineering function, which owns the end-to-end data supply chain that powers analytics and AI for global clients. The stack covers multi-source onboarding through Adverity, transformation in Trifacta, governed data landing in Databricks with Unity Catalog, SQL/PySpark transformation, dbt and GitHub orchestration, and reporting in Power BI on a medallion architecture. This position builds and maintains ingestion, transformation, governance, and data quality pipelines that deliver certified, AI-ready datasets for Analytics, Media, Product, and Engineering teams.
What you will do
- Onboard and normalize multi-source data through Adverity, standing up and maintaining Data Refinery pipelines that connect marketing, media, and platform sources into a single, reliable ingestion layer.
- Ingest, model, and reconcile DSP data (e.g., DV360, The Trade Desk, Amazon DSP) against CM360 ad-server delivery, applying programmatic media expertise to distinguish buy-side activation and bidding from independent ad serving/counting, and to resolve impression, spend, and attribution discrepancies between platforms.
- Manage and maintain data transformations in Trifacta, building governed, repeatable wrangling recipes that cleanse, standardize, and shape raw inputs into analytics-ready structures.
- Govern data assets in Databricks Unity Catalog, managing catalogs, schemas, permissions, lineage, and metadata to keep data secure, consistent, and discoverable across the platform.
- Develop and optimize further transformations in Databricks using SQL, PySpark, notebooks, and workflows, extending refined data through the medallion (bronze/silver/gold) architecture into curated, consumption-ready models.
- Design, run, and monitor data quality health checks in Databricks, including row-level integrity, schema and version validation, reconciliation logic, and automated error logging, to embed trust and observability at every stage of the pipeline.
- Working understanding and familiarity to apply modular, tested, and documented transformation orchestration, and GitHub for version control, CI/CD, code review, and change governance across SQL, Python, and YAML assets.
- Design modular, reusable, and well-documented data models that support analytics, reporting, and AI enablement, with clear definitions, lineage, and business context.
- Collaborate with analysts, engineers, and business leads to translate raw, multi-source data into governed, insight-ready datasets that support performance reporting and downstream decisioning.
- Contribute to data quality standards, monitoring, and the platform roadmap, defining best practices for reusable components, transformation patterns, and observability that scale across teams and clients.
- Prepare certified, well-modeled datasets for the consumption layer and reporting tools such as Power BI, ensuring metrics are consistent, governed, and traceable to source.
Skills used in this role
What the employer is looking for
- 4-6+ years of experience as a Data Engineer or in a similar role building and operating scalable, production data pipelines.
- Bachelor’s Degree in Computer Science, Engineering, Information Systems, or a related field required; Graduate degree preferred.
- Hands-on experience with Adverity for data onboarding and normalization, including building and maintaining Data Refinery ingestion pipelines across multiple marketing and media sources.
- Proven experience managing data transformations in Trifacta (Alteryx Designer Cloud), including building governed, repeatable wrangling recipes for cleansing and standardization.
- Advanced expertise with Databricks, including Unity Catalog governance (catalogs, permissions, lineage, metadata), transformation development in SQL and PySpark, and Databricks Workflows, Notebooks, and Jobs.
- Demonstrated experience designing and operating data quality health checks, including integrity tests, reconciliation logic, schema validation, and automated monitoring, within a Databricks environment.
- Familiarity with dbt (dbt Labs) for transformation orchestration and testing, and with GitHub for version control, CI/CD, and code governance in a collaborative development workflow.
- Strong proficiency in SQL and Python for data engineering, transformation, and automation.
- Working knowledge of medallion (bronze/silver/gold) architecture, data modeling, lineage, and governance best practices for analytics-ready data.
- Self-starter with the ability to learn new tools quickly and deliver scalable, well-documented solutions across the data stack, driving continuous improvement and measurable impact.
Preferred qualifications
- Experience in advertising, marketing, or digital media environments, particularly performance reporting, reconciliation automation, or data quality optimization.
Benefits and support
- Compensation and benefits are detailed in the job posting
About dentsu
Dentsu Group Inc. is an integrated growth and transformation partner to the world's leading organizations, delivering comprehensive media, customer experience management (CXM), and creative services. Operating globally across approximately 120 countries, the agency combines deep human insights, creative innovation, and advanced data technologies to accelerate business growth. Headquartered in Tokyo, Japan, Dentsu has a rich heritage of shaping the advertising and marketing industry since 1901.
- Industry
- Advertising
- Company size
- 67000+ employees
- Founded
- 1901-07-01
- Location
- Tokyo, Japan
- Funding stage
- Public Company
Funding
Public Company
- 2022-03-29Post Ipo
Leadership
Takeshi Sano
Representative Executive Officer, President & Global CEO
Yoshimasa Watahiki
Representative Executive Officer, EVP & Global Chief Corporate Affairs Officer
Shigeki Endo
Executive Officer & Global CFO
Beth Ann Kaminkow
CEO, Dentsu Americas & Chief Global Client Officer
Yuichi Toyoda
CEO, Dentsu APAC
Recent coverage
Campaign Middle East
dentsu ventures into Hollywood with 'The Angry Birds Movie 3'2026-10-06
Dentsu
Carat Named Media Network Of The Year At Cannes Lions 20262026-06-22
Dentsu
Dentsu Unveils Next Evolution Of Dentsu.Connect, Industry's First Truly Agentic AI-Powered Operating System For Modern Marketing2026-04-07
Dentsu
Dentsu Announces New Global Management Structure — Further Contributing to Client Growth by Strengthening Execution Capabilities2026-02-13