Business Analyst – GTN & Trade Promotion Planning

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 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.