Sr. BI Analyst (Analytics & Insights)

Position –

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.

• 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:

• Minimum 4 years of hands-on experience in a BI Analyst or similar role.
• Expertise in SQL (T-SQL, PL/SQL, or similar) for data extraction and manipulation.
• Strong experience with Tableau, including dashboard design, storytelling, and performance tuning.
• Prior experience working in the Banking or Financial Services industry is mandatory.
• Familiarity with data warehousing concepts, ETL processes, and BI tools.
• Strong analytical thinking and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Bachelor’s degree in computer science, Statistics, Finance, or a related field.

Soft Skills:

• Strong problem-solving and critical-thinking abilities.
• Excellent communication and presentation skills.
• Ability to work independently and as part of a team.
• Attention to detail and the ability to work with complex data sets.

Preferred Qualifications:

• Proficiency in SQL, Python, VBA, and JavaScript for data analysis, automation, and enhancing reporting functionalities.
• Strong experience with Tableau; experience with other BI tools like Power BI or Looker is a plus.
• Exposure to Databricks for building and managing data pipelines, performing large-scale data processing, and advanced analytics.

Amherst’s core values:

• Culture & Conduct

  : Positive attitude with high integrity. Agile in adapting to a dynamic environment with emerging datapoints. We do the right thing the right way and are accountable for our actions.

• Client-Centricity & Business Acumen

  : Strong Team player, multiple internal/external stakeholders management,

• Communication & Connectivity

  : Strong written and verbal communication skills with clients and management. Collaboration – We align, contribute, and win together.

• Execution & Delivery

  : Self-starter, Proactive, motivated, driven personality, Excellent organizational and time management skills.

• Agility

  – We are nimble and responsive.

• Community

  – We empower and support people to create a sense of belonging for all.

Working Shift/ arrangement: