Excel Modelling Consultant - Skincare Product NPD/EPD Process job opportunity at Activate Talent.



Date2026-01-07T08:49:53.484Z bot
Activate Talent Excel Modelling Consultant - Skincare Product NPD/EPD Process
Experience: General
Pattern: Full-time
apply Apply Now
Salary:
Status:

Job

Copy Link Report
degreeGeneral
Colombia

NPD / EPD Commercial Gate Tool Developer (Excel-Based) REMOTE FULL-TIME About the Role We 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 long-term, high-impact role focused on delivering a tangible, business-critical tool — not ongoing operational ownership. What You’ll Do Tool Design & Build Design and build an Excel-based Commercial Gate Tool covering: Kick-off Gate 1 Gate 2 Gate 3 Create a clear, logical structure that aligns with existing NPD / EPD governance. Commercial Modeling & Automation Integrate automated calculations , including: Target COGS derived from RRP and margin targets Volume, pricing, and margin scenarios Build scenario-handling logic to support: Different sourcing routes Project types COGS and cost structure assumptions Supply Chain Handover & Outputs Design clean, usable Gate 3 outputs for Supply Chain, including: Shopping lists / component requirements PO spend timing Cash flow forecasts Usability & Governance Apply formulas and macros where appropriate — creating a tool that is robust but not over-engineered . Focus on: Usability and clarity Version control Ease of adoption across functions (Commercial, Supply Chain, Finance, Marketing). Ensure the tool reflects how real commercial decisions are made — pragmatic, transparent, and actionable. Collaboration & Iteration Work closely with business and operations leads to: Gather feedback Iterate quickly Align the tool to real-world use cases Ideal Profile Expert-level Excel modeller with strong command of: Advanced formulas Scenario logic Macros / automation Proven experience building: Commercial decision-making tools Governance or stage-gate frameworks Strong commercial acumen: Margin targets Cost trade-offs Operational decision-making Comfortable working independently in an ambiguous, build-from-scratch environment . Experience in FMCG, retail, or product development environments strongly preferred.

Other Ai Matches

44134150062- Chain Manager - Analytics & Project Support Applicants are expected to have a solid experience in handling Job related tasks
Growth Marketer (Klaviyo Focus) Applicants are expected to have a solid experience in handling Job related tasks
Google Media Buyer Applicants are expected to have a solid experience in handling Job related tasks
39837912608- Amazon PPC Specialist/ Brand Manager Applicants are expected to have a solid experience in handling Job related tasks
Full-Stack Engineer (Lead Product Engineer) Applicants are expected to have a solid experience in handling Job related tasks
Performance Video Editor Applicants are expected to have a solid experience in handling Job related tasks
Digital Marketing Manager 1.1 Applicants are expected to have a solid experience in handling Job related tasks
50435888212 - Video Editor Applicants are expected to have a solid experience in handling Job related tasks
55682431005 - Graphic Designer Applicants are expected to have a solid experience in handling Job related tasks
46016975397 - Director of Amazon Applicants are expected to have a solid experience in handling Job related tasks
51020352875 - Applovin Media Buyer Applicants are expected to have a solid experience in handling Job related tasks
43812325297 - Project Manager Applicants are expected to have a solid experience in handling Job related tasks
41045975966- TikTok Shop Specialist Applicants are expected to have a solid experience in handling Job related tasks
40239678491- Video Editor Applicants are expected to have a solid experience in handling Job related tasks
Digital Designer Applicants are expected to have a solid experience in handling Job related tasks
TikTok Affiliate Manager Applicants are expected to have a solid experience in handling Job related tasks
Growth Marketing Assistant-38765192474 Applicants are expected to have a solid experience in handling Job related tasks
49447936547- Operations Manager - E-Commerce & Inventory (DTC + Subscription Mod Applicants are expected to have a solid experience in handling Job related tasks
38960373080 - Retention Strategist Applicants are expected to have a solid experience in handling Job related tasks
55478373810 - UK Influencer Assistant (Part-Time) Applicants are expected to have a solid experience in handling Job related tasks
54340896536 - LinkedIn Ads Specialist Applicants are expected to have a solid experience in handling Job related tasks
FullStack Developer (React, React Native, Node.) Applicants are expected to have a solid experience in handling React Native, Node.) related tasks
32022640562-Social Influencer Outreach Specialist Applicants are expected to have a solid experience in handling Job related tasks