About this role
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 ManagementVBA MacrosStrong requirements elicitation and functional specification writingExperience reverse-engineering legacy Excel/VBA logic into documented specificationsGTN (Gross-to-Net) / Trade Promotion Planning or S&OP domain knowledgeUAT scenario design and stakeholder sign-off managementData modelling basics (entities, relationships, hierarchies)Good-to-Have Skills
Generative AI Fundamentals (Capable)BI Reports (Strong)Exposure to GenAI-assisted documentation and code-parsing toolsSQL for data validationPower BI / Excel Pivot modelling knowledgeRGM experience