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