Business Analyst – GTN & Trade Promotion Planning

Company Description Nagarro is a global digital engineering company helping organisations become AI-first and digital-first. With a presence across 35+ countries and deep capabilities in software engineering, AI, cloud, and platform transformation, Nagarro partners with leading enterprises across Travel, Logistics, Hospitality, Telecom, and Technology sectors. Job Description Role Summary Acts as the bridge between planning processes and the engineering team, reverse-engineering legacy systems into structured specifications for AI-assisted development. Key Responsibilities Reverse-engineer existing business logic (VBA macros, Excel formula chains, GTN waterfall rules) into documented functional specifications for spec-driven development. Run working sessions with Business Planning (BP) teams and KAM power users to validate business rules, including promo mechanics, days-cover norms, and MPL structures. Own the Feature Parity Matrix to ensure no legacy features are dropped. Lead UAT coordination, design test scenarios using real business data, and gather sign-off from business champions. Must-Have Skills Data Modeling (Capable) Stakeholder Management VBA Macros Strong requirements elicitation and functional specification writing Experience reverse-engineering legacy Excel/VBA logic into documented specifications GTN (Gross-to-Net) / Trade Promotion Planning or S&OP domain knowledge UAT scenario design and stakeholder sign-off management Data modelling basics (entities, relationships, hierarchies) Good-to-Have Skills Generative AI Fundamentals (Capable) BI Reports (Strong) Exposure to GenAI-assisted documentation and code-parsing tools SQL for data validation Power BI / Excel Pivot modelling knowledge RGM experience