Shop Online New York · 23 hours ago
Non-Paid Internship for Financial Modeling Analyst
United States
Internship
Remote
InternShop Online New York is an e-commerce company preparing for launch, and they are seeking a Financial Modeling Analyst Intern to support their data-driven planning efforts. The intern will build and maintain financial models that inform business decisions related to pricing, inventory financing, and marketing spend.
AdvertisingBusiness DevelopmentMedia and Entertainment
Hiring Manager
Flavia Vo
Responsibilities
Build a three-statement, driver-based model with monthly granularity (income statement, balance sheet, cash flow) tied to operational inputs
Create SKU/channel revenue builds (traffic → conversion → AOV → returns) with sensitivity and scenario toggles
Model unit economics and cohort LTV, CAC/payback, contribution margin, and retention curves
Construct working capital schedules (AR, AP, inventory turns) and 13-week cash flow forecasts
Develop landed cost and COGS frameworks (freight, duties, warehouse fees) and link to pricing scenarios
Produce scenario and sensitivity analyses (best/base/worst cases; data tables; scenario manager)
Build valuation-ready artifacts when appropriate (high-level DCF inputs, comparables framework)
Document assumptions, version models, and maintain audit trails aligned with SOPs
Convert insights into concise memos and simple dashboards for non-finance stakeholders
Qualification
Required
Advanced Excel/Google Sheets skills: nested logic, lookups, dynamic arrays, pivot tables, data tables, error handling; comfort building from a blank workbook
Understanding of e-commerce metrics and levers (conversion, AOV, churn/retention, contribution margin, CAC/LTV)
Familiarity with inventory and working capital mechanics (inventory turns, AR/AP cycles)
Ability to design clear model architecture, separate inputs/logic/outputs, and enforce version control
Strong communication skills to explain assumptions, risks, and results to non-finance teams
Preferred
Experience assembling clean inputs and joins; SQL or Python for analysis preferred
Experience with a BI tool (Looker Studio, Tableau, or Power BI) is a plus
Benefits
Real impact on pricing, cash runway, and growth allocation decisions
Close collaboration with leadership and cross-functional teams
A portfolio of professional-grade models, dashboards, and memos
Certificate of completion and, based on performance, a detailed letter of recommendation
Company
Shop Online New York
Shop ONline New York
Founded in 2020
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Abad Morel
Founder
Company data provided by crunchbase