Headquarters: mexico npd / epd commercial gate tool developer (excel-based)remote full-timeabout the rolewe are redesigning our new product development (npd) and existing product development (epd) operating system and are seeking an experienced specialist to build a robust, excel-based commercial gate tool to support consistent, high-quality decision-making across gate 1, gate 2, and gate 3. The process architecture and governance model are already defined. This role exists to close the tooling gap by designing and delivering a practical, user-friendly excel framework that enables commercial evaluation, scenario analysis, and cross-functional alignment. This is a short-term, high-impact project role focused on delivering a tangible, business-critical tool — not ongoing operational ownership.what you'll dotool design & builddesign and build an excel-based commercial gate tool covering: kick-off gate 1, gate 2, gate 3create a clear, logical structure that aligns with existing npd / epd governancecommercial modeling & automationintegrate automated calculations, including: target cogs derived from rrp and margin targets; volume, pricing, and margin scenariosbuild scenario-handling logic to support: different sourcing routes, project types, cogs and cost structure assumptionssupply chain handover & outputsdesign clean, usable gate 3 outputs for supply chain, including: shopping lists/component requirements, po spend timing, cash flow forecastsusability & governanceapply formulas and macros where appropriate — creating a tool that is robust but not over-engineeredfocus on: usability and clarity, version control, ease of adoption across functions (commercial, supply chain, finance, marketing)ensure the tool reflects real commercial decisions — pragmatic, transparent, and actionablecollaboration & iterationwork closely with business and operations leads to gather feedback, iterate quickly, and align the tool to real-world use casesideal profileexpert-level excel modeller with strong command of advanced formulas, scenario logic, macros/automationproven experience building commercial decision-making tools, governance or stage-gate frameworksstrong commercial acumen: margin targets, cost trade-offs, operational decision-makingcomfortable working independently in an ambiguous, build-from-scratch environmentexperience in fmcg, retail, or product development environments strongly preferredwhat this role is / isn'tthis role isa practical, decision-enabling tool builda short-term, high-impact projecta collaborative engagement with senior business stakeholdersthis role is nota long-term operational rolea pure finance or academic modeling exerciseto apply#j-*-ljbffr