BENGALURU · FULLTIME
Manager - OTC Business Analysis-1
Diageo
Bengaluru · onsite · Posted 12d ago
Sourced from
Undisclosed6–11 yrsfulltimeBengaluru
Your match
?
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
Job Summary
Role Responsibilities
Key Competencies
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.
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.
- 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.
Sourced from naukri
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
AutomationAgileCraftAdvanced ExcelCds Viewsbusiness insightsAccrualsAutomatingBusiness AnalysisDashboardcontinuous developmentAnalyticsDashboard DesigncloudCommunication SkillsBusiness IntelligenceCommercial Finance
Section · Company
About Diageo
Diageo
Beverage
3k+
employees
1997
29 years old
London
United Kingdom (UK)
About
Global spirits leader with over $20 billion revenue, home to iconic brands across 180+ markets.
Industries
Manufacturing
Employee ratings
1,211 reviews
3.8/ 5
Culture
3.8
Career growth
3.1
Work-life
3.8
Employees rate it well for
Work Culture154Work Life Balance133Senior Management91Salary91Career Growth78
Find them on