Senior Analyst - Planning & Reporting
Dentsu
5 - 10 years
Bengaluru
Posted: 31/01/2026
Job Description
Job Description:
1. Power BI Report Testing & Quality Assurance
Conduct end‑to‑end functional and data testing for new/enhanced reports before UAT and production release.
Validate calculations, filters, hierarchies, navigation, RLS/OLS, visuals, and KPIs for accuracy and business relevance.
Perform regression testing during refresh cycles, model changes, or source updates.
Collaborate with BI developers to triage, track, and retest defects.
2. Daily Data Quality Control (QC)
Review daily QC checks for data availability, completeness, and refresh status.
Diagnose data gaps, spikes, mismatches using source extracts and refresh logs.
Work with Tech teams on refresh failures or schedule delays.
Recommend improvements for QC automation and monitoring.
3. Functional Data Understanding & Source System Awareness
Build strong knowledge of core source systems and data flows (UMS, SAC, BPC, D365, market reporting).
Track upstream changes and assess impact on report logic, models, and visuals.
Engage with SMEs to understand KPIs, definitions, mappings, and metric uplift needs.
4. Issue Resolution & Collaboration with BI Tech Team
Perform detailed root‑cause analysis for data discrepancies, refresh failures, performance issues, and visual inconsistencies.
Work closely with BI Tech teams for timely resolution.
Document findings, RCA notes, and recommendations.
5. Metadata, Glossary & Documentation Management
Maintain and update the RCoE report glossary with business definitions, KPIs, and source logic.
Support reporting catalogue alignment and maintenance.
Ensure version control, test scripts, access logs, and issue logs are well‑organized and audit‑ready.
6. Governance, Compliance & Ways of Working
Provide updates in governance forums on testing status, data issues, and access compliance.
Contribute to continuous improvement in testing frameworks, QC automation, and knowledge sharing.
Required Skills & Experience
3–5 years in Power BI testing, data validation, QC, or BI support (6–8 years total experience).
Finance domain knowledge (P\&L, Revenue, Margins, Cost Centres) is a plus.
Exposure to UMS, SAC, BPC, D365, or similar systems.
Hands‑on SQL or advanced Excel for data validation.
Ability to diagnose complex data and refresh issues across upstream systems.
Experience collaborating with global, cross‑functional teams.
Strong analytical, documentation, and communication skills.
Experience with QA automation or monitoring tools is an advantage.
Location:
BangaloreBrand:
BcoeTime Type:
Full timeContract Type:
PermanentAbout Company
Dentsu is a global advertising and digital marketing agency headquartered in Tokyo, Japan. It is part of the Dentsu Group Inc., one of the largest advertising and communications groups in the world. Dentsu specializes in providing integrated marketing solutions, including digital marketing, media planning, content creation, data analytics, public relations, and customer experience management. The company operates across numerous industries and markets, serving clients with innovative strategies to drive brand growth and engagement. With a strong focus on technology and creativity, Dentsu aims to deliver impactful, data-driven campaigns tailored to modern consumer behavior.
Services you might be interested in
Improve Your Resume Today
Boost your chances with professional resume services!
Get expert-reviewed, ATS-optimized resumes tailored for your experience level. Start your journey now.
