Manager - OTC Business Analysis-1

diageo; Bengaluru; On-site; INR 1,200,000 - 1,900,000; Full time

Job summary

Diageo in Bengaluru, India, seeks a Reporting Manager for Customer Spend to own performance reporting and analytics across markets supported by GBS. You will turn fragmented data into a single trusted view of spend, risk and health, enabling leadership with dashboards, models and narratives for faster, evidence-based decisions.

The role requires strong technical reporting skills (Python, Power BI, advanced Excel), hands-on SAP S/4HANA knowledge, and the ability to present a compelling business

Responsibilities

• Own end-to-end customer spend reporting framework including dashboards for claims, spend accuracy and risk.
• Design and build automated Power BI dashboards sourced from SAP S/4HANA, Anaplan and Excel trackers.
• Extract, model and reconcile spend data from SAP S/4HANA including settlements, rebates and deductions.
• Write Python scripts to automate data consolidation and reconciliation.
• Build advanced Excel models for scenario analysis and cost impact assessments.
• Present insights to senior leadership with clear business narratives.

Skills

Python

Power BI

Advanced Excel

Data Modelling

Tools

SAP S/4HANA

Anaplan

Job description

Job Description

About us

With over 200 brands sold in nearly 180 countries, Diageo is home to some of the world's most iconic drinks. From Johnnie Walker and Guinness to Tanqueray, Smirnoff and Don Julio, we craft brands chosen for life's moments - from everyday connections to landmark celebrations.

Bring your talent, curiosity and ambition, and strive for your personal best alongside people who challenge, support and learn from each other. Together, as one outstanding team, we keep learning, improving and raising the bar for our brands, our business and each other.

Join us and play your part in making life's moments mean a little more.

About the Function:

Global Business Services (GBS) acts as the strategic enabler of our business, providing essential operational, financial, and analytical services that power day-to-day performance across 40+ markets. With a diverse team of over 2,000 professionals located in Bangalore, Gurugram, Budapest, Bogota, and Manila, GBS offers tremendous exposure to global operations and a wide learning landscape.

We foster continuous development across digital capabilities, industry expertise, functional skills, and domain depth. No matter where your journey begins, you'll gain global visibility, meaningful impact, and the support of an inclusive and empowering culture.

About the role:

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 strong 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.
• 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.
• 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.
• Write Python-based scripts to automate recurring data consolidation, cleansing, and reconciliation across customer spend data sources, reducing manual reporting effort.
• Build advanced Excel models (pivot-driven, macro/VBA-enabled) for scenario analysis, variance tracking, and FTE or cost-impact assessments.
• Conduct deep-dive and root-cause analysis on claim rejections, processing delays, and spend variances; convert findings into clear, quantified, decision-ready insights.
• Prepare and deliver advanced, executive-ready presentations that translate complex spend data into a concise business narrative for senior leadership.
• 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.
• Reconcile SAP S/4HANA accruals, condition contract balances and settlements against the general ledger and reporting outputs, and explain any gaps to Finance.
• Flag data quality, methodology, or reconciliation gaps in existing reporting and business cases, and recommend fixes before figures are presented externally.
• Support the design, testing, and rollout of new reporting tools, automation, and process improvements across the customer spend value chain.
• 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.
• 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.
• Present findings and recommendations confidently to senior and executive audiences, adapting dep