Manager - OTC Business Analysis-1 (Bengaluru)

Manager - OTC Business Analysis-1 (Bengaluru)

09 Oct
|
Diageo
|
Bengaluru

09 Oct

Diageo

Bengaluru

Job Summary

The Reporting Manager - Customer Spend owns performance reporting and analytics for customer spend - trade spend, claims, deductions, and Condition Contract activity - across the markets GBS supports. The role turns fragmented, manual data into a single, trusted view of spend performance, risk, and health, and equips leadership with the dashboards, models, and narratives needed to make faster, evidence-based decisions.

Success in this role requires robust technical reporting skills (Python, Power BI, advanced Excel), hands-on knowledge of SAP S/4HANA data, the judgement to translate numbers into a clear business story, and the presence to present that story convincingly to senior stakeholders.

Role Responsibilities

- Performance Reporting Insights - Own the end-to-end customer spend reporting framework, including daily/weekly/monthly dashboards covering claims volume, spend accuracy, ageing, rejection rates, and risk-tier performance.
- Performance Reporting Insights - Design and build automated, self-service Power BI dashboards (data modelling, DAX measures and refresh pipelines) sourced from SAP S/4HANA, Anaplan and Excel-based trackers.
- Performance Reporting Insights - Extract, model and reconcile customer spend data directly from SAP S/4HANA, including condition contracts and Settlement Management, rebate accruals and settlements, customer deductions and dispute cases, and the related billing and FI postings. Use CDS views, standard reports and Fiori analytical apps to build one trusted data set.
- Performance Reporting Insights - Write Python-based scripts to automate recurring data consolidation, cleansing, and reconciliation across customer spend data sources, reducing manual reporting effort.




- Performance Reporting Insights - Build advanced Excel models (pivot-driven, macro/VBA-enabled) for scenario analysis, variance tracking, and FTE or cost-impact assessments.
- Performance Reporting Insights - Conduct deep-dive and root-cause analysis on claim rejections, processing delays, and spend variances; convert findings into clear, quantified, decision-ready insights.
- Performance Reporting Insights - Prepare and deliver advanced, executive-ready presentations that translate complex spend data into a concise business narrative for senior leadership.
- Performance Reporting Insights - Partner with CIO, Commercial, and Finance leadership to define KPIs, scorecards, and risk-based reporting models (e.g., high/medium/low risk validation tiers), and to pressure-test the numbers behind any business case before it reaches leadership.
- Data Governance Continuous Improvement - Maintain data integrity and standardised definitions across customer spend reporting; proactively identify and reconcile discrepancies between source systems and summary reporting.
- Data Governance Continuous Improvement - Reconcile SAP S/4HANA accruals, condition contract balances and settlements against the general ledger and reporting outputs, and explain any gaps to Finance.
- Data Governance Continuous Improvement - Flag data quality, methodology,



or reconciliation gaps in existing reporting and business cases, and recommend fixes before figures are presented externally.
- Data Governance Continuous Improvement - Support the design, testing, and rollout of new reporting tools, automation, and process improvements across the customer spend value chain.
- Data Governance Continuous Improvement - Act as the reporting subject-matter expert for SAP S/4HANA changes and enhancements. Define reporting requirements, support data mapping and user acceptance testing, and make sure KPIs stay consistent through system changes.
- Data Governance Continuous Improvement - Apply structured, agile ways of working (backlog prioritisation, iterative delivery) to continuously improve reporting speed and accuracy.
- Stakeholder Management - Act as the trusted analytics partner to Commercial, Finance, Customer, and CIO teams on all customer spend performance questions.
- Stakeholder Management - Present findings and recommendations confidently to senior and executive audiences, adapting depth and format to the audience.
- Stakeholder Management - Collaborate cross-functionally to ensure reporting reflects operational reality and supports, rather than duplicates, existing processes.

Key Competencies

This role is technically hands-on. Candidates should be able to demonstrate, not just describe, the following:

- Python - Advanced

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Manager - OTC Business Analysis-1 (Bengaluru)
🏢 Diageo
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: manager - otc business analysis-1 (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: manager - otc business analysis-1 (bengaluru) / bengaluru