Sr. BI 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.

• →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.

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

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

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