Note: The job is a remote job and is open to candidates in USA. Montegallo is hiring a Junior Financial Analyst to support underwriting and financial analysis for real estate development opportunities. The role tracks project budgets, prepares financial and investor reporting, and supports capital and financing activities throughout the development lifecycle.
Responsibilities
- Assist in building and maintaining pro forma models for acquisitions and ground-up development projects, including cash flow, return metrics (IRR, equity multiple, yield on cost, cash-on-cash), and sensitivity analyses
- Gather and analyze market data, including comparable sales, rent comps, absorption rates, cap rates, and construction costs, to support underwriting assumptions
- Update models as assumptions change and document key inputs and outputs
- Track development budgets against actuals, and prepare variance analyses for project teams
- Review and reconcile draw requests, invoices, and change orders with project managers and accounting
- Maintain cost-to-complete forecasts and flag potential overruns early
- Prepare monthly and quarterly project reports for internal leadership, investors, and lenders
- Support the creation of investment committee memos, investor presentations, and lender packages
- Build dashboards and summaries that track portfolio performance and project milestones
- Help prepare loan draw packages, equity capital call schedules, and covenant compliance tracking
- Assist with lender and investor information requests
- Track debt and equity balances, interest reserves, and funding sources across projects
- Collaborate with accounting on month-end close, accruals, and reconciliations
- Support ad hoc analyses, including feasibility studies, lease-up projections, and exit scenarios
- Contribute to process improvements and help standardize templates and reporting tools
Skills
- Bachelor's degree in Finance, Accounting, Economics, Real Estate, or a related field
- 0–2 years of experience in financial analysis, real estate, banking, accounting, or a related field (internships count)
- Advanced proficiency in Microsoft Excel (formulas, lookups, pivot tables, scenario and sensitivity analysis)
- Strong analytical and quantitative skills with excellent attention to detail
- Clear written and verbal communication skills, and the ability to present findings concisely
- Ability to manage multiple priorities and meet deadlines in a fast-paced environment
Company Overview