Senior Data Reporting & Integration (Data Specialist)
Indexed description
About Dentsu
Led by Dentsu Group Inc. (Tokyo: 4324; ISIN: JP3551520004), a pure holding company established on January 1, 2020, the Dentsu Group encompasses two operational networks: dentsu Japan network, which oversees Dentsu’s agency operations in Japan, and dentsu international, its international business headquarters in London, which oversees Dentsu’s agency operations outside of Japan.
With a strong presence in approximately 145 countries and regions across five continents and with 65,000 dedicated professionals, the Dentsu Group provides a comprehensive range of client-centric integrated communications, media and digital services through its five leadership brands—Carat, dentsu X, iProspect, Dentsu Creative, and Merkle—as well as through Dentsu Japan Network companies, including Dentsu Inc., the world’s largest single brand agency with a history of innovation. The Group is also active in the production and marketing of sports and entertainment content on a global scale.
Role Description
The Senior Data Reporting & Integration plays a critical role in bridging data engineering, regional digital performance analytics, and cutting-edge AI technology to build a modern, automated data ecosystem for Dentsu and its regional clients.
Rooted in a Data Engineering background, this role is responsible for automatically pulling, transforming, and unifying cross-platform digital marketing data across multiple markets in the APAC region (Meta, TikTok, YouTube, Google, and diverse local/global platforms). Given the complexity of varying market metrics and definitions across APAC, the ideal candidate will standardize fragmented definitions into a single, scalable "Solid Data Structure", streamline high-volume multi-market data streams to eliminate one-time heavy reporting loads, design automated dashboards, and leverage AI Agents and API Integrations to drive efficiency and innovation. Working closely with the Product and Innovation teams, you will champion the effort to elevate Dentsu's data digital capabilities across regional markets.
Key Responsibilities
1. Data Reporting - Platform Integration & Data Unification (Solid Data Engine)
- Design, build, and maintain robust ETL/ELT data pipelines to automatically ingest multi-channel digital marketing data across multiple markets in the APAC region (Meta Ads, TikTok Ads, Google/YouTube Ads, DSPs, and market-specific regional digital platforms).
- Harmonize and unify disparate digital marketing metrics, taxonomy, and platform definitions across diverse APAC markets into a standardized, single source of truth ("Solid Data Structure").
- Optimize data architecture and pipeline performance to reduce heavy data loads, minimize latency, and drastically lower the operational effort required for one-time manual reporting.
- Manage RESTful APIs, webhooks, and third-party data connectors to ensure seamless, real-time or near-real-time multi-market data synchronization.
2. Automated Dashboarding, Reporting & Data Segmentation Analysis
- Develop, automate, and maintain dynamic, interactive regional and market-level dashboards (e.g., Looker Studio, Power BI, Tableau, or Custom Web Dashboards) for internal agency teams and regional enterprise clients.
- Conduct advanced audience, cross-market media performance, and creative segmentation analysis on top of the consolidated dataset to uncover strategic growth levers across APAC markets.
- Automate recurring regional and multi-market client reporting workflows to streamline agency operations and eliminate redundant manual reporting.
3. AI Agent Integration & Product Innovation
- Integrate AI Agents, LLM APIs, and intelligent workflow automation tools to process, query, and analyze complex multi-market digital datasets.
- Partner directly with Product & Innovation teams to embed AI capabilities into media reporting, predictive analytics, and automated multi-market insights generation.
- Develop seamless API integrations connecting regional digital platforms, internal agency tools, and custom AI Agents to drive operational productivity and elevate Dentsu's regional digital capabilities.
Qualifications & Skills
- Experience: 3-4+ years of total experience in Data Engineering, Data Analytics, or Data Integration, preferably managing multi-market / regional data scope (APAC) within a digital agency, ad-tech, or tech-enabled environment.
- Core Background: Strong Data Engineering foundational skills (Data Modeling, ETL/ELT pipelines, Big Data Warehousing & Optimization).
- Multi-Market & Domain Expertise: Deep understanding of digital marketing ecosystems, diverse platform metrics, and taxomony nuances across APAC markets (Meta, TikTok, Google, YouTube, Programmatic, local platforms).
- Technical Stack: Proficiency in Python / R and advanced SQL; deep experience with Cloud platforms (GCP / BigQuery, AWS, Azure); hands-on expertise with BI & Visualization tools (Looker Studio, Power BI, Tableau).
- API & Integration Expertise: Proven experience building integrations via RESTful APIs and platform APIs (Meta Graph API, TikTok Marketing API, Google Ads API, YouTube Analytics API, etc.).
- AI & Agent Capability: Practical experience or strong understanding of integrating AI Agents, OpenAI APIs, Anthropic, LangChain/LlamaIndex, or LLM-driven analytics automation workflows.
- Communication & Mindset: Strong English communication skills (written and spoken) with a highly analytical, problem-solving, and innovative mindset to collaborate across regional teams.
Become a Champion for Meaningful Progress
Our diverse and inclusive culture enables our employees to bring their whole selves to work and be proud of doing so. For us, this is the foundation for great innovation which, in turn, generates better outcomes for our people, partners and communities. This is why we encourage applications from people with disabilities, and of all ages, nationalities, backgrounds and cultures.
If you want to belong to one global network where opportunities are limitless – we look forward to welcoming you.
Dentsu Values
Will live the dentsu 8 Ways at all times: We Dream Loud, We Inspire Change, We Team Without Limits, We All Lead, We Make It Real, We Climb High, We Choose Excitement, We Are A Force For Good
Keeping connected
Please visit our website to find out more and connect with us on social.
www.dentsu.com
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search