Financial Modelling Associate
Fresh Prints
FP&A Analyst
Modern.ai
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇵🇭 Philippines
Visit company websiteJob Level
JuniorMid-Level
About the role
- Evaluate financial and performance data of prospective clients across eCommerce, retail, and DTC channels.
- Build dynamic financial models to forecast ROI, CAC, LTV, media efficiency, and scale potential.
- Assist the Sales Team in creating deal proposals to support new client acquisition and close rate.
- Collaborate with Growth, Creative, and Marketing teams to align assumptions with campaign levers.
- Own and maintain “Budget vs. Actual” tracking models for active clients.
- Monitor key performance indicators (KPI), paid media spend, revenue targets, and contribution margins.
- Flag early indicators of underperformance and support the strategy team in recommending course corrections.
- Analyze seasonal trends, marketing mix effectiveness, and cohort behavior across channels.
- Consolidate client-level forecasts into a master agency revenue and margin model.
- Partner with the CSO and finance team to track how client budgets impact Modern Agency’s internal P&L.
- Support capacity planning and hiring roadmap based on client pipeline and budget shifts.
- Proactively identify risks and opportunities across the client portfolio.
Requirements
- 2–4 years of experience in FP&A, investment banking, management consulting, or strategic finance, with exposure to eCommerce or digital marketing
- Strong Excel/Google Sheets modeling skills
- Ability to distill complex financial data into clear, strategic insights for non-financial stakeholders
- Exceptional attention to detail, but also capable of zooming out and identifying macro-level trends
- Comfortable working in a fast-paced, remote-first startup environment
- Familiarity with DTC metrics (CAC, LTV, MER, retention curves, etc.) and ad platform data (Meta, TikTok, Google)
Benefits
- Direct mentorship from agency leadership
- Unlimited PTO
- Chance to grow in a great team!
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
financial modelingROI forecastingCAC analysisLTV analysisKPI monitoringdata analysisbudget trackingperformance analysisExcelGoogle Sheets
Soft skills
attention to detailstrategic insightcollaborationcommunicationproblem-solvingadaptabilitytime managementcritical thinkingproactive identification of risksability to work in fast-paced environments
