Summer Financial Modeling Intern
📍 Location: Holliston, MA → In-Person
⏳ Duration: Summer 2025 (Full-Time, 10-12 Weeks)
đź’° Compensation: Summer Stipend ($2-4k based on time and performance)
About the Role:
We are seeking a highly analytical and detail-oriented Finance Modeling Intern to join our team for Summer 2025. This role will provide hands-on experience in financial analysis, accounting processes, and data management, with a strong emphasis on Excel-based modeling and reporting.
Key Responsibilities:
- Assist with financial analysis, forecasting, and budgeting using advanced Excel functions.
- Support month-end closing processes, journal entries, and reconciliations.
- Develop and improve financial models, dashboards, and reports for key business insights.
- Work with large data sets, conducting trend analysis, variance analysis, and ad-hoc reporting.
- Assist in accounts payable/receivable tracking and financial audits.
- Research and analyze cost-saving opportunities and process efficiencies.
Required Skills & Qualifications:
✅ Currently pursuing a Bachelor’s or Master’s degree in Finance, Accounting, Economics, or a related field.
âś… Exceptional Excel skills (Pivot Tables, VLOOKUP, INDEX-MATCH, Macros, Power Query, VBA preferred).
âś… Experience with financial modeling, data visualization, and business analytics.
âś… Detail-oriented and analytical mindset, with excellent problem-solving abilities.
âś… Ability to work independently and collaboratively in a fast-paced environment.
âś… Prior experience or coursework in financial analysis, auditing, or corporate finance is a plus.
What You’ll Do:
âś… Develop dynamic financial models (e.g. 3-statement models, revenue forecasts, unit economics, DCFs, valuation comps)
âś… Assist in the preparation of investor materials, board decks, and pitch content
âś… Analyze company performance using internal data, KPIs, and external benchmarks
âś… Conduct scenario modeling, sensitivity analysis, and risk assessment
âś… Research market trends, competitors, and pricing dynamics to inform financial assumptions
âś… Collaborate cross-functionally with product, clinical, and marketing teams on budget planning
What You’ll Gain:
- Hands-on experience working with real financial data and business insights.
- Opportunity to refine and apply advanced Excel and financial modeling skills.
- Exposure to corporate finance, accounting, and decision-making processes.
- Mentorship and networking with finance and accounting professionals.