[Remote] Non-Paid Internship for Financial Modeling Analyst
Note: The job is a remote job and is open to candidates in USA. Shop 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.
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
Skills
ā¢ 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
ā¢ 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 Overview
ā¢ Shop ONline New York It was founded in 2020, and is headquartered in Yonkers, New York, USA, with a workforce of 11-50 employees. Its website is https://www.topofny.com.
Apply Now
Apply Now
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
Skills
ā¢ 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
ā¢ 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 Overview
ā¢ Shop ONline New York It was founded in 2020, and is headquartered in Yonkers, New York, USA, with a workforce of 11-50 employees. Its website is https://www.topofny.com.
Apply Now
Apply Now