About the role
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