Strategic Financial Analyst
Indianapolis, IN - USA
Job Summary
The Strategic Financial Analyst provides analytical and strategic support directly to the President & CEO and CFO of a multi-family real estate investment company. This role serves as a key resource across investments capital markets portfolio management and executive reporting. The ideal candidate brings 23 years of experience from an accounting firm or financial services environment combined with deep proficiency in financial modeling and a strong command of AI and technology tools that enhance speed and accuracy in analysis and reporting.
- Bachelors degree in Finance Accounting Economics or a related field; CPA track or CFA candidacy a plus
- 23 years of relevant experience at a public accounting firm investment bank financial services firm or real estate investment company
- Prior exposure to real estate private equity or multi-family investment structures strongly preferred
- Must have a valid drivers license and annually provide proof of auto insurance
- Advanced Excel proficiency required: complex financial modeling dynamic proformas sensitivity tables and scenario analysis
- Demonstrated experience leveraging AI tools (e.g. ChatGPT Copilot or similar) to improve analytical workflows automate reporting and surface insights
- Proficiency with financial software and platforms (Yardi Argus or similar real estate platforms a plus)
- Experience with data visualization tools (Power BI Tableau or similar) preferred
- Familiarity with CRM data room management and investor reporting platforms
- Exceptional analytical and financial modeling skills with a high degree of accuracy
- Strong executive presence and communication skills able to synthesize complex data into clear concise narratives for C-suite audiences
- Proactive self-starter who operates with urgency ownership and sound judgment
- High learning agility and intellectual curiosity; stays current on market tends AI tools and real estate finance innovations
- Comfortable working in a fast-paced entrepreneurial environment with shifting priorities
- Highly organized with exceptional attention to detail and ability to manage multiple deliverables simultaneously
- High degree of professionalism integrity and discretion when handling sensitive financial information
- Collaborative team player who builds strong relationships across departments
Executive & Strategic Support
- Serve as a direct analytical resource to the President & CEO and CFO preparing reports models and presentations that support strategic decision-making
- Prepare and maintain executive dashboards performance summaries and board/investor reporting packages
- Research macroeconomic trends capital markets conditions and multi-family real estate dynamics to inform leadership decisions
- Anticipate information needs of senior leadership and proactively deliver analysis without being asked
Investment Analysis & Underwriting
- Develop and maintain underwriting proformas for new acquisitions and development opportunities including validation of assumptions with Property Management Development and Construction teams
- Conduct market and demographic research for new developments potential acquisitions current assets and projects under construction
- Analyze and model capital stack optimization financing structures and return profiles
- Research analyze and present recommendations on stabilized value-add and development assets
- Track property-level metrics against business plan budgets acquisition proformas and renovation return-on-cost goals; identify trends and areas for improvement
- Maintain asset tracking schedules for construction lease-up and value-add renovation projects
Portfolio Management & Capital Markets
- Perform portfolio analytics and data management monitoring performance across the full investment portfolio
- Build and maintain portfolio models reforecasts hold/sell analyses and IRR/equity multiple tracking
- Prepare financing packages investor reports and fundraising materials for debt and equity transactions
- Support debt management processes including closing coordination ongoing compliance monitoring and refinancing analysis
- Assist with portfolio operations including compliance valuations reporting and other tasks as needed
- Coordinate with real estate tax consultants on tax assessment strategies and appeals
- Maintain and update investor and lender CRM databases and data rooms
Technology & Process Innovation
- Champion the use of AI and automation tools to streamline financial analysis reporting and data management workflows
- Identify opportunities to leverage technology to reduce manual effort improve reporting accuracy and accelerate turnaround times
- Assist in evaluating and implementing new financial software or platforms that enhance team capabilities
- Develop and maintain underwriting proformas for new acquisitions and development opportunities including validation of assumptions with Property Management Development and Construction teams
General
- Build and maintain strong working relationships with Development Acquisitions Asset Management Property Management and Capital Markets teams
- Deliver high-quality results across multiple concurrent projects under tight deadlines
- Maintain a client-oriented perspective ensuring all data metrics and analyses are accurate and consistent across deliverables
- Ensure adherence to company policies procedures and guidelines in all communications and work product
- Travel as needed for market evaluations due diligence and portfolio site visits
- Complete other duties and projects as assigned by supervisor
#CC
Required Experience:
IC
About Company
Expertise in all aspects of the multifamily industry have shaped sound investment strategies to create value and maximize returns for our institutional…