Manager – OTC Business Analysis-1

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 depth and format to the audience. · 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: Competency Level Applied in This Role Python Advanced Automating data pipelines and repeatable reporting scripts (pandas-based cleansing, consolidation, and reconciliation) across customer spend data sources. Power BI Advanced Data modelling, DAX measures, and interactive dashboard design for spend, claims, and risk-tier performance reporting. SAP S/4HANA Advanced Extracting and reconciling customer spend data from S/4HANA (condition contracts, Settlement Management, accruals, deductions and billing), working with CDS views and Fiori apps, and understanding SD/FI document flow. Advanced Excel Advanced Complex formulas, pivot tables, and macros/VBA for ad-hoc analysis, variance tracking, and FTE/cost-impact modelling. Presentation Skills Advanced Building and delivering polished, executive-ready PowerPoint decks that turn data into a clear, persuasive business narrative. Skills & Qualifications Must-Have · 6+ years of experience in reporting, analytics, or business intelligence, ideally within a shared services / GBS or commercial finance environment. · Advanced proficiency in Power BI (data modelling, DAX, dashboard design) — required. · Hands-on experience extracting, analysing and reconciling data in SAP S/4HANA (SD and FI-CO), including a solid understanding of document flow, key tables and CDS views — required. · Working proficiency in Python for data automation and analysis (pandas or equivalent) — required. · Advanced Excel skills (complex formulas, pivot tables, macros/VBA) — required. · Advanced PowerPoint / presentation skills, with demonstrated ability to present to senior leadership — required. · Strong analytical capability with a track record of converting data into meaningful business insights and recommendations. · Ability to critically assess a business case or reported benefit — spot inconsistent assumptions, unreconciled data, and overstated claims — and present a corrected, defensible version. · Strong stakeholder management and communication skills, with confidence to challenge conventional thinking. Preferred · Experience with SAP S/4HANA Settlement Management (condition contracts) and FSCM Dispute or Deduction Management. · Exposure to SAP reporting and data platforms such as SAP Analytics Cloud, BW/4HANA or Datasphere, or to an ECC-to-S/4HANA migration. · Exposure to Order-to-Cash, trade spend, claims, or condition-contract processes, with a preference for FMCG/AlcoBev industry experience. · Familiarity with Anaplan or similar planning tools. · Exposure to agile ways of working, and to Lean/Six Sigma or other continuous-improvement methodologies. Key Attributes · Analytical and evidence-led — lets the data lead the conclusion, even when it complicates the story. · High ownership, attention to detail, and structured thinking. · Confident communicator — able to simplify complexity for a senior, non-technical audience. · Proactive change mindset; comfortable challenging existing reporting and processes to improve them. · Thrives in a fast-paced, cross-functional, and data-heavy environment. Working with us Flexibility is key to our success. Talk to us about what flexibility means to you, so that you’re supported to manage your wellbeing and balance your priorities from day one. We recognise and value performance, offering our people a highly competitive Rewards and Benefits package including: Our purpose is crafting iconic drinks chosen for life’s moments. And it’s our people, with their different experiences, perspectives and talents, who make that possible. We value diversity in its broadest sense and want everyone to feel they can belong, contribute and strive for their personal best. You’ll work alongside people with different backgrounds, experiences and perspectives — challenging, supporting and learning from one another as one outstanding team. Together, we’re constantly learning and improving, combining the strength of our people, capabilities and iconic brands to raise the bar, grow and win. Wherever you join us, you’ll have the opportunity to contribute, make an impact and play your part in making life’s moments mean a little more. Ready to bring your best? This could be your opportunity. If you require a reasonable adjustment, please ensure that you capture this information when you submit your application. Recruitment Scam Warning Protecting candidates is very important to us. All communications regarding your application will come from an email address ending in @diageo.com. In our recruitment process, we'll never ask for money. Worker Type : Regular Primary Location: Bangalore Karle Town SEZ Additional Locations : Job Posting Start Date : 2026-09-29