🔔 FCM Loaded

Senior Analyst - Planning & Reporting

Dentsu

5 - 10 years

Bengaluru

Posted: 31/01/2026

Getting a referral is 5x more effective than applying directly

Job Description

The Senior Analyst – Power BI Testing ensures the accuracy, reliability, and robustness of RCoE’s Power BI reporting suite. The role involves end to end testing of new and updated reports, conducting daily data quality checks, validating data against source systems, identifying root causes of data or refresh issues, and maintaining key documentation such as glossaries and metadata. The analyst partners closely with BI developers and Tech teams, builds strong functional understanding of source systems, and supports high standards of data integrity and reporting consistency across a global finance environment.

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:

Bangalore

Brand:

Bcoe

Time Type:

Full time

Contract Type:

Permanent

About 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.