Senior Data Engineer – Content Ops & Site Quality
dentsu · Posted Oct 1
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 the Data Engineering ecosystem supporting Content Operations and Site Quality at Merkle (dentsu), managing large-scale data pipelines, data models, analytics infrastructure, and AI-driven solutions for business and analytics teams. The work spans SQL Server, Iceberg, PySpark, ECS and Airflow pipelines alongside Adobe Analytics data, plus AI/LLM-based solutions such as RAG and agent applications. This Senior Data Engineer will own and optimize production data assets, build scalable processing solutions, and partner with stakeholders on solution design and roadmap development.
What you will do
- Own and manage Data Engineering activities supporting Content Ops and Site Quality.
- Develop, maintain, and optimize data pipelines supporting approximately 150 MDP tables, 2 SSAS Cubes, and multiple Airflow workflows.
- Build and maintain scalable data processing solutions using SQL Server, Iceberg, PySpark, ECS, and Airflow.
- Troubleshoot data quality, pipeline, performance, and production issues and drive them through to resolution.
- Support data modeling and development of reliable datasets for downstream analytics and reporting.
- Develop and enhance AI/LLM-based solutions, including RAG and agent-based applications.
- Contribute to an AI agent/RAG solution that enables users to translate Adobe Analytics requirements into SQL queries.
- Maintain and enhance the Client’s chatbot assistant, including updates, new capabilities, and ongoing performance improvements.
- Identify opportunities to leverage AI and automation to simplify data and analytics workflows.
- Partner with business and analytics stakeholders to understand requirements and translate them into scalable technical solutions.
- Contribute to solution design, technical discussions, and roadmap development.
- Clearly communicate complex technical concepts and solutions to non-technical stakeholders.
Skills used in this role
What the employer is looking for
- Strong hands-on experience in Data Engineering with SQL and PySpark.
- Experience with SQL Server, SSAS, Airflow, and modern data platforms.
- Experience working with Iceberg and cloud/container-based environments such as ECS.
- Strong understanding of data modeling, ETL/ELT, data pipelines, and data quality.
- Experience with Adobe Analytics or similar digital analytics platforms.
- Exposure to AI/LLM solutions, RAG, AI agents, or Generative AI applications.
- Strong problem-solving and troubleshooting skills.
- Ability to work independently and manage multiple production-critical data assets.
Preferred qualifications
- Experience building RAG/agentic AI applications using LLMs.
- Experience converting business/analytics requirements into SQL and data solutions.
- Experience with APIs, Python, and cloud technologies.
- Experience developing stakeholder-facing analytics or AI solutions.
- Strong communication and stakeholder management skills.
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