Sql analyst [h1.location_city]

Asset Liability Management Reporting Analyst

The Amherst Group's companies are comprised of leading real estate investment and advisory firms with a mission to transform the way real estate is owned, financed and managed. Amherst leverages its proprietary data, analytics, technology, and decades of experience to seek solutions for a fragmented, slow-to-evolve real estate ecosystem and to materially improve the experience for residents, buyers, sellers, communities, and investors. Today Amherst has over 1000 employees and $14.1 billion in assets under management.

Over the past decade, Amherst has scaled its platform to become one of the largest operators of single-family assets and has acquired, renovated, and leased more than 46,000 homes across 32 markets in the U.S. The firm delivers customized, stabilized cash-flowing portfolios of assets to its investors, wrapped in all the ongoing services required to manage, own, and finance the asset including property management, portfolio management, and a full capital markets team. In addition to its single-family rental platform, Amherst's debt business pursues two distinct credit strategies in mortgage-backed securities and commercial real estate lending. Over its 25-year history, Amherst has developed a deep bench of research and technology talent, and leverages data and analytics at every stage in the asset lifecycle to improve operations and preserve long-term value for our investors and the more than 188,000 residents the firm has served.

Amherst is looking for an Asset Liability Management Reporting Analyst who will primarily support the Capital Management teams in managing various credit lines with commitments exceeding $6.5bn across multiple funds. This will include assembling reporting materials, maintaining historical performance records and executing day to day operations in support of specific credit lines for various investment funds. The ALM Reporting Analyst will be comfortable with high visibility reporting standards, networking with multiple internal departments to assemble all required information and communicating with outside counterparties to deliver results and streamline workflows. This is an excellent opportunity for someone eager for exposure to, and rapid advancement in, high level corporate financing and capital markets activities.

Responsibilities

• Prepare property and portfolio level collateral and performance status reporting
• Support monthly, quarterly and annual reporting activities, including aggregation and validation of reported financial and performance metrics
• Interpret and correctly calculate debt covenants, lending limits and identify opportunities to improve leverage efficiency
• Communicate with internal and external (lender) stakeholders to satisfy reporting requirements and respond to ad hoc data requests
• Maintain tracking databases of key credit line details and prepare ad hoc reporting around historical performance and usage
• Facilitate project management around key initiatives

Qualifications

Our full-time employee benefits include :

Amherst is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information or veteran status, and encourage all applicants to apply.