Sr. BI Analyst (Analytics & Insights)

Position – Sr. BI Analyst (Analytics & Insights)

Amherst Overview

Amherst is a vertically integrated real estate investment, development, and operating platform, offering solutions across the U.S. real estate capital stack, including single-family residential (SFR), mortgage-backed securities (MBS), and commercial real estate (CRE). Amherst is headquartered in Austin, TX and New York, NY, in the United States, with regional global offices located in India and Costa Rica. Underpinned by proprietary technology, battle-tested data and mortgage model, and a deep understanding of U.S. real estate markets, Amherst’s vertically integrated platform seeks to provide investors a more efficient model to price, finance, and manage real estate with turnkey execution capabilities across the firm’s debt and equity strategies in the public and private residential, commercial, and mortgage-backed securities markets.

Our Single-Family Residential (SFR) strategy has quickly scaled over the last 10 years to own and operate 40,000+ homes in 30+ markets across 20 states while building a vertically integrated real estate investment and operating platform that manages approximately $18bn in assets. Across the SFR strategy, Amherst acquires, builds, renovates, leases, finances, manages, and disposes of homes on its own account and for its investors. Outside of the SFR strategy, Amherst is engaged in various strategic initiatives and venture businesses, including commercial real estate debt and equity (all things non-SFR) and mortgage-backed securities advisory. For Further information about The Amherst Group, kindly visit https : / / www.amherst.com / .

Department / Role Overview : Amherst Residential

We are looking for a skilled Sr. BI Analyst with expertise in working with large data sets, techniques to extract insights, build predictive models, and deliver actionable business solutions. The ideal candidate will possess strong analytical skills, technical proficiency, and a passion for working with data to solve complex problems.

Job Description (Primary Responsibilities)

• As a BI Analyst, you will play a key role in transforming raw data into actionable insights that drive business decisions.
• Collaborating with business units (e.g., Risk, Finance, Product) to gather reporting requirements and provide analytical support.
• Writing and optimizing SQL queries to extract and manipulate data from complex systems and data warehouses.
• Designing and enhancing Tableau dashboards to communicate KPIs, trends, and financial metrics effectively.
• Working on data ETL processes in collaboration with data engineering teams to ensure smooth data flow and availability for reporting.
• Translating business logic into data-driven solutions by implementing calculations, data transformations, and rules that align with business definitions.
• Developing new metrics and performance indicators to support evolving business strategies and regulatory needs.
• Continuously identifying and driving process improvements across reporting workflows, automation, and dashboard performance.
• Conducting deep-dive analyses to uncover insights related to customer behavior, product performance, risk exposure, and compliance trends.
• Documenting data definitions, business rules, and reporting logic for transparency and consistency

Desired Skills / Qualifications :

Soft Skills :

Preferred Qualifications :

Amherst’s core values :

Working Shift / arrangement : US Shift (1 : 30 PM – 10 : 30 PM – IST), Flexible - Hybrid working model