Business Analyst – GTN & Trade Promotion Planning
Prefer a full account with a password? Sign Up to Apply
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
Requirements
Department: Engineering
Function: Information Technology
Experience Level: Not Applicable