Job
Description
Department / Role Overview: Amherst Residential Within the broader Amherst organization, the Merchant Banking business unit serves as the cornerstone of investment management activities. This division oversees critical financial operations including raising new debt and equity capital, forming new ventures, executing strategic acquisition and disposition of homes, and managing Amherst's extensive portfolio investments. As part of Amherst's fully integrated approach, the Merchant Banking business unit works in close coordination with other key divisions, including Development and Operations. This role is positioned within the Investment Strategy team, a critical component of the Merchant Banking division. In this position, you will directly contribute to the sophisticated data-driven processes that inform and power Amherst's investment decisions. The Investment Strategy (Research) team functions as the analytical engine behind Amherst's market success. This specialized group combines advanced modeling techniques, comprehensive market surveillance, and data-driven methodologies to develop insights that guide investment strategy across the entire portfolio. By applying rigorous quantitative analysis alongside deep industry expertise, the team effectively monitors both internal operational metrics and broader market movements to identify emerging opportunities, anticipate shifts, and generate actionable intelligence. As an integral part of Amherst's vertically integrated platform, the Investment Strategy team seamlessly translates analytical findings into strategic capital deployment recommendations. This collaborative approach allows the team to work effectively with other business units while maintaining Amherst's competitive advantage in making informed, data-backed investment decisions in the dynamic real estate marketplace. Primary Responsibilities: Model Maintenance: Maintain and regularly update existing investment models, ensuring data accuracy and timely refreshes. Data Support: Gather, validate, and organize data from multiple sources to support ongoing investment analysis. Reporting Assistance: Assist in preparing recurring investment reports and presentations for internal stakeholders. Performance Tracking: Monitor and update key portfolio metrics, comparing performance against established benchmarks and targets. Analysis Support: Conduct basic market research and data analysis to support the Investment Strategy teams decision-making process. Visualization Development: Create and update charts, graphs, and dashboards to communicate investment insights effectively. Documentation: Maintain comprehensive documentation of data sources, analytical methodologies, and model assumptions. Desired Skills & Qualifications: Bachelor's degree in Finance, Economics, Data Science, Statistics, or a related quantitative field. 2-6 years of experience in an analytical, research, or financial role; exposure to real estate investment analysis is a plus but not required. Strong proficiency in Microsoft Excel, including formulas, pivot tables, and data analysis; experience with macros and VBA is a plus. Familiarity with data analysis tools such as Python, R, or SQL, with the ability to independently run analyses and modify existing code. Experience with data visualization tools like Tableau or Power BI is a plus. Proficiency in Microsoft PowerPoint, with the ability to develop clear, data-driven presentations. Exceptional attention to detail and organizational skills. Strong communication skills and the ability to work collaboratively in a team environment. A proactive mindset with a strong desire to learn and grow analytical skills within an investment context. Working Shift/ arrangement : US Shift (1:30 PM - 10:30 PM - IST), Flexible - Hybrid working model.
